Great ETL software for complex data rules
October 28, 2019

Great ETL software for complex data rules

Anonymous | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User

Overall Satisfaction with IBM InfoSphere DataStage

It is mainly used by IT department as ETL software. It served as an efficient tool for us to extract data, transform and load data in the databases or provide the output file for users and other systems. With ODBC connections, it can connect Oracle, SQL, and other databases and open files to read and write.
  • Very reliable in handling data extraction, data transformation and loading
  • Flexibility in connecting to different type of databases, relational or non-relational
  • Great features such as parallel processing, hash handling, etc.
  • You can also take advantage of its FTP functions, and scheduling features if you need to.
  • Technical support is a key area IBM should improve for this product. Sometimes our case is assigned to a support engineer and he has no idea of the product or services.
  • Provide custom reports for datastage jobs and performance such as job history reports, warning messages or error messages.
  • Make it fully compatible with Oracle and users can direct use of Oracle ODBC drivers instead of Data Direct driver. Same for SQL server.
  • Provides us an excellent ETL application
  • Made our data handling easy
  • Provide the business with high quality reports
We have very limited experience of using Informix and should not provide any comments. But datastage works real well for us.
I mainly handle support cases with IBM and the support is really lagging behind.

Do you think IBM DataStage delivers good value for the price?

Not sure

Are you happy with IBM DataStage's feature set?

Yes

Did IBM DataStage live up to sales and marketing promises?

Yes

Did implementation of IBM DataStage go as expected?

Yes

Would you buy IBM DataStage again?

Yes

It is well suited if your data is quite complex and many data rules are in place. You have to write real complex data joins to generate output. While DataStage can handle it and provide you an intuitive design for support and analysis.

IBM DataStage Feature Ratings

Connect to traditional data sources
8
Simple transformations
10
Complex transformations
9
Metadata management
8
Business rules and workflow
9
Collaboration
4
Testing and debugging
8