The graphical user interface and powerful SQL generation capabilities make the coding of ETL flows very easy and efficient. The ability to easily run processes in parallel or sequentially is also very valuable. Overall the ease of use is Data Services key benefit.
Room for Improvement:
While Data Services performs very well when dealing with relational structures and to a lesser degree with delimited files, there is significant room from improvement with the integration with web services and related data formats (XML, JSON, etc.). We have had to code our own ETL processes in Python or Java to extract data from all but the simplest web services.
Use of Solution:
If you have a need to access non-relational data sources, review the tool’s capabilities for your specific use cases very carefully.