DATASTAGE -ETL
January 31, 2019
DATASTAGE -ETL

Score 10 out of 10
Vetted Review
Verified User
Overall Satisfaction with IBM InfoSphere DataStage
- DS is one of the most powerful ETL tools on the market. Its connectors to different bases plus the pack make it a solid tool, and complete. It has a great number of functions, and the work with a big amount of data with DS is not complex (as long as you have the knowledge and know how to handle the partitioning algorithms, etc).
- DataStage has improved over time. It has improved its connectors, added functionalities, making easier the programming and the maintenance of the development.
- Connectivity.
- Handling large numbers of records.
- Varied partitioning algorithms.
- Complementary packages of connectivity to applications, SAP, etc.
- You must understand and know the algorithms, since the wrong use of them generates more time in processing.
- Metadata. You need to develop with connectors, and taking all the Metadata from the menu, all the data that you complete manually, you can't track it.
- The connection with SAP has allowed us to extract useful data, allowing us to set aside costly processes such as ABAP, etc.
- DataStage can load data wherever the data is . This gives you the facility to integrate data, create a DW with all the integrity that you need.
Compared to other ETL tools, the connectors really work, and makes the developments less complex because they facilitate the development of the processes. The maintenance of the processes is simple, since it is a very visual tool, and you can count on the technical documentation given by the tool.