The user experience is really good and features also Review collected by and hosted on G2.com.

Can work on the integration with other etl tools Review collected by and hosted on G2.com.

graphical notation, parallel job flows and reusable components Review collected by and hosted on G2.com.

Sometimes the performance is not up to mark,and complex replication process Review collected by and hosted on G2.com.

User friendly and has advanced options to perform ETL. Review collected by and hosted on G2.com.

Costly as compared to other ETL tool like Informatica and security could have been better. Review collected by and hosted on G2.com.

The best part is I can synchronise my data any number of times. The flexibility it provides with relational and non-relational databases. Review collected by and hosted on G2.com.

A mild bumper we are trying to figure out the job history reports or errors in the job. No track of metadata created manually. Review collected by and hosted on G2.com.

IBM InfoSphere DataStage can provide a great performance since it works with the concept of data parallelism processing across the nodes you can define over settings. As any other ETL tool it can help users to understand the goal of each program easily through the visual data flow. It's well designed to be scalable and it also provides many features and packs according to the new trends (Big Data, Machine Learning etc) being very flexible to run custom codes developed in other programming languages. The idea of dividing the tool in the Designer module, Director module and Administrator module is also a plus in my opinion. Review collected by and hosted on G2.com.

Being a real advanced developer of IBM InfoSphere DataStage is not really an easy task since there are many tricks and many concepts of data parallelism processing that need to be applied in the programs to achieve the best results. Sometimes there are some metadata bugs that requires starting and stopping the DataStage services to fix it. The newer versions of the client runs "heavy" and require a good desktop computer (memory/cpu) to run smoothly. It's a reliable tool but it's also expensive, if you need to upgrade the version, certainly you will need IBM's support to do so. Review collected by and hosted on G2.com.

The designer has a great UI to develop the code. The palette has a wide variety of stages for all transformations and data quality requirements.

The director helps you compile and run the ETL jobs. It also helps us to check the state of the job before running the job.

If Information Analyzer (IA) is chosen to do the data profiling, the rules created in IA can be directly imported to Data Stage to accelerate the development process.

The tool has a transformer stage which is capable of doing most of the transformations.

The tool also helps you develop and maintain your data transfer jobs and control jobs as parallel and sequence jobs respectively thereby avoiding confusions.

It has a wide variety of partitioning techniques that can help you optimize the parallel jobs

It is flexible enough to connect with different types of relational and non relational databases

Reading logs is so easy with the Director. Review collected by and hosted on G2.com.

Sometimes, the error messages that we get will be totally irrelevant to the actual error in the job.

There are limited forums to discuss challenges in using the tool.

Configuring DSNs on the LINUX server is sometimes very challenging when we don't have a handy guide to help us.

Limited information available in the documentation provided.

Code comparison is a challenging while promoting jobs to higher environments. An additional feature to do that will be really helpful

The jobs can't be debugged using check points.

The tool can be improved for cloud integration capabilities Review collected by and hosted on G2.com.

I worked with IBM InfoSphere DataStage for 1 year. It was a very good experience, because I was not very knowledgeable about ETL and through it I was able to understand and work better because it was very easy. Review collected by and hosted on G2.com.

Perhaps what I did not like, was the problems of connections with some databases Review collected by and hosted on G2.com.

Datastage supports multiple data sources which include but not limited to sequential files, indexed files, relational databases, external data sources, archives, enterprise applications. Also, it is also easy to adapt and learn the tools by a developer. It is backed by a strong enterprise support and IBM provides good documentation. It has been widely used and most trusted and recommended Data Integration Tools available in the market. Review collected by and hosted on G2.com.

Since it is an enterprise solution, there is a high competition in terms of latest tools available in the market and the UI is current and easy to use. It is not easy to get use cases and help online to implement few functionalities. It is not easy to convince a Customer who are not tided to IBM tools Review collected by and hosted on G2.com.

The way of design. It is somewhat easy to understand and easy to use. Especially the parallel processing. Also it has the capability of using sequences and server jobs too. Review collected by and hosted on G2.com.

It would be nice if we could able to view first 10 records in the dataset. Also the day types rounding. For example even though the oracle data type is date, it shows as time stamp. Also, if we are keying in a decimal (40,38) to the dataset, we would not be able to view the correct data thru dataset. Review collected by and hosted on G2.com.

1) Datastage on Cloud pak for data helps you to build modern Information Architecture - Starting point for your journey to AI

2) Authorizes high-performance batch also real-time data extraction, transforming and loading.

3) Provides built-in scalability to future-proof your architecture.

4) Assists developers to be extra efficient and productive throughout automation and also reuse of common development responsibilities with touch of AI

5)The specific powerful, industry-leading ETL engine gives built-in scalability to future-proof your design using a design-once-and deploy-anywhere way. Review collected by and hosted on G2.com.

Debugging for previous datastage versions 11.5 and earlier was real pain - You will see lot of unwanted meaningless messages in datastage director. The error messages can be really hard to understand and interpret Review collected by and hosted on G2.com.