DataStage is a good tool for the ETL platform, but it is not suitable for a huge volume of data. It works well for low to medium volume of data. I would advise others to do a feasibility study and evaluate available options in the market in terms of features and cost.

I would rate IBM InfoSphere DataStage a seven out of ten.

I'd rate the solution seven out of ten. 

I haven't used it too much. I need more time with the solution. 

Whether another user should try it or not depends on the environment. If you already have a lot of Oracle applications, it might make sense. It can do everything any other ETL can do.

I used to be a partner with IBM. I have to reset the partnership. 

I would recommend the solution for on-premises setups. 

I would rate the solution eight out of ten. 

I deal with companies from the healthcare industry. The solutions are largely cloud-based. In data-rich industries like telecom or BFSI, such tools are extensively used. Healthcare also has a lot of data. I will encourage people to use the solution. It is quite an easy tool.

Every stage has a help guide. It’s an extensive documentation. We can understand the purpose of a stage, how the connection has to be set up, how to set up a username and password, and whom we should contact. New users must start using the tool and explore it. They might have to invest ten days or two weeks to understand the workflows and options. It is easy to learn. My company is a partner with IBM.

Overall, I rate the product a nine out of ten.

If they're already using DataStage, definitely. If it's a new implementation, there are other tools with competitive pricing that might be worth considering.

Overall, I would rate the solution an eight out of ten. 

We have used IBM InfoSphere DataStage effectively for managing Big Data within our products, particularly in scenarios involving large volumes of records for ETL processes. However, we have seen that for near real-time or on-time integration tasks, DataStage may not be optimal due to its resource-intensive nature.

DataStage's scalability has indeed supported our data growth, particularly for ETL tasks involving large volumes of data, enabling us to manage increased data loads effectively.

The scalability of DataStage supported our data growth by allowing us to manage increased data loads effectively, primarily through optimizing the usage of the tool rather than inherent scalability features. However, we faced challenges with real-time processing as DataStage could not trigger processes based on events like emails, requiring us to schedule tasks at intervals, which limited its suitability for real-time scenarios.

DataStage integrates with our existing IT infrastructure by connecting to our manufacturing processes and systems like ERP and SAP. It facilitates integration by consolidating data from various sources, enabling us to view unified information across our systems.

I would recommend DataStage for data integration, especially for SQL data and ETL tasks.

Overall, I would rate DataStage at a seven out of ten. While it is a robust solution for data integration and ETL tasks, there is room for improvement in adopting more modern architectures to meet evolving needs.

I would highly recommend this solution because of its shared-nothing architecture that it uses, the capabilities it offers, and the fact that every feature has its own use. For example, it has a Director for creating jobs, clients for monitoring and scheduling jobs, and an Administrative client for administration purposes. This is something well managed by IBM.

Overall, I would rate the solution a seven out of ten. There are certain areas of improvement.

The last version of IBM InfoSphere DataStage which I've worked with was version 11.7.

I work for an IT service company that works with multiple clients on multiple projects, so close to two hundred people use IBM InfoSphere DataStage for various clients.

Per project, on average, three people take care of IBM InfoSphere DataStage deployment, maintenance, and support-related activities.

My advice to people looking into implementing IBM InfoSphere DataStage is that it's a very good product. A lot of similar products have come up nowadays, but this product has a pretty good reputation as it's been in the market for quite a while. I do think other products such as Talend, Informatica PowerCenter, and Informatica Data Quality are better than IBM InfoSphere DataStage.

My rating for IBM InfoSphere DataStage is eight out of ten.

My company has a partnership with IBM.

I recommend that other people who want to use it go for DataStage on the cloud. The on-prem version of the solution looks and feels old. Also it's time-consuming as well. Overall, I rate the solution a six out of ten.

I give the solution a seven out of ten.

We have a separate platform team or support team. In case of any query, it used to be routed to this team, which was internally used to deal with the Data Stage people.

I'm not a technical expert because I haven't been a developer for 12 years. This is what I understand from the feedback I've received. Informatica Power Exchange Data Integration is much better from a scalability perspective, compared to IBM InfoSphere Data Stage. Scalability, user-friendliness, and inclusion of different business rules are all important, but I think Informatica Power Exchange Data Integration gives us one step further on that.

If you want to learn about integrating data, this product offers a valuable learning opportunity. Then you can consider transitioning to the next product in line. The underlying concept remains the same. 

I believe this solution is more reliable and provides a better understanding of data integration, data quality management, and master data management. It covers all aspects of data management, making it easier to learn. 

This is my perspective, possibly influenced by my extensive experience working with this product for many years. It is the main strength of this solution.

Overall, I would rate the solution a ten out of ten. 

I would rate this particular product as a nine out of ten. It is very powerful and very fast, but the problems with the interface make it less than perfect.

As far as other advice that I would have for other people considering this as a solution, the first and most important is to examine your needs and decide on the processes you want to build. From that, you can immediately have a better idea of the type of solution that might be best for you. Then it is a good idea to get the advice of a consultant — like us.

We use the on-premises deployment model.

If you are comparing the solution to Informatica, this solution is much simpler. In Informatica, for example, there might be two to three ways to find a log, but with DataStage, they make it much easier. However, compared to other vendors, IBM's licensing costs are more expensive.

I'd rate the solution eight out of ten.

The first consideration is the type of source system they have, whether it is a mainframe or not. Another key indicator for me to suggest DataStage is if the client has other IBM ecosystems, such as data quality or IBM governance tools. This makes it highly suitable because you can easily establish data lineage.

Overall, I rate the solution a seven out of ten.

As part of the tool's maintenance, we install the updates and take backups. We rely on two engineers to help with the process.  I rate IBM InfoSphere DataStage an eight out of ten. 

I would advise others to identify the communication between servers and the client tools correctly. If working from a client environment and connecting to the server, configuration should be done correctly, otherwise you may encounter some issues.

I would rate this solution an eight out of ten. 

I'd recommend the product to others. 

I'd rate it a nine out of ten. We've been pleased with its capabilities overall. 

If you have the budget and your solution requires industrial/enterprise strength data integration, this product is always a good choice.

I would rate the product a nine out of ten. You need to get a balance between batch ETL processing and streaming. 

Informatica provides a cloud-based deployment but we only work with the on-premises version. This is a product that I can recommend.

I would rate this solution a six out of ten.

I would rate this solution 8 out of 10.

I am not a developer, I have a team within our company for that.

There is a cloud migration strategy going on, so they are thinking of moving to the cloud. They want a tool that is not heavy and suitable for their budget.

The recommendation for using this tool would depend on the requirements. 

I don't have anything bad to say about this product.

I would rate this solution an eight out of ten.

I would recommend this solution for large-scale implementation where you need a complex transformation and data integration to happen according to a structured format, either a data vault or a dimension model. It is suitable for big companies because of the cost. It is a very valuable platform for data in large volumes. For small volumes, you have other open-source tools that can do the same thing for you.

I am part of a consultancy, and I have deployed this product for companies. We have five to eight developers. Because InfoSphere is a licensed product, and its licenses cost a lot, there are not many InfoSphere developers.

I would rate IBM InfoSphere DataStage an eight out of ten.

This is a good product, but there is room for improvement.

I would rate this solution an eight out of ten.

I rate IBM InfoSphere DataStage an eight out of ten.

The advice I would give to others is to make sure they define a framework for development and for management. This could be very useful for the future of the product in the company.

I would rate the entire solution eight out of ten. I really like DataStage. The product fits our requirements perfectly.

We are changing the product now, however, to a cloud-based approach for DataStage.

We have had different projects with three of four clients. The average term per project has been nine months and one year.

If you are working with an open-source solution or another solution, you can implement some features by yourself. For example, in the case of Amazon, which has Amazon Lambda, you can easily write your code in Python or Java, and it will orchestrate it. You can create your features yourself easily and gives you more abilities to make your solution run quicker, eliminating the dependence from the vendor.

I would rate IBM InfoSphere DataStage an eight out of ten.

This product has a lot of good features.

I would rate this solution an eight out of ten.

The last version I interacted with was 11.3 because the later versions were cloud-based and usually our customers didn't want to use the solution on the cloud.

In terms of advice, I would give to anyone trying to implement the solution is this: you to have accurate sizing. Clients always do the sizing wrong and they need more experience to get the sizing right. Setting up the environments takes sizing into account but it usually makes a lot of problems if the sizing is poor when it starts to operate. Then you have re-implement and it will require an increase in resources that will change your budget. 

I would rate this solution nine out of ten.

I rate this solution an eight out of 10. 

I would rate InfoSphere an eight out of 10. 

It is the best solution in the IBM environment. It uses IBM data models, such as data quality tools.

My advice for anyone considering IBM Infosphere Datastage is to use a decent consulting house to help you once you get around to committing to the product. Do not assume that you will be able to go at this alone unless you have an extremely talented staff.  

On a scale from one to ten (where one is the worst and ten is the best), I would rate this product as a seven-out-of-ten.  

I think DataStage is a product that one should look at as a good candidate in this segment.

I would rate this product a seven out of 10.

Try to do a lot of training before beginning the project.

I would rate this solution as seven out of ten because I think there are some problems with the design of the interface. They should also develop new connectors. The solution is quite complex for people and you need a lot of training to use it.

Don't use the Netezza adapter, as it's poor

You should also look at Redbooks and DeveloperWorks articles for knowledge gathering.