Try our new research platform with insights from 80,000+ expert users
reviewer2260647 - PeerSpot reviewer
Technical Data Analyst at a government with 10,001+ employees
Real User
Helps to migrate old databases to newer ones
Pros and Cons
  • "We can view what we want to do. We can transform data and put them on tables."
  • "I want the tool to continue with the on-prem version, not the cloud one."

What is our primary use case?

We migrate data from old databases to new databases. 

What is most valuable?

We can view what we want to do. We can transform data and put them on tables. 

What needs improvement?

I want the tool to continue with the on-prem version, not the cloud one. 

For how long have I used the solution?

I have been using the solution for six years. 

Buyer's Guide
IBM InfoSphere DataStage
April 2025
Learn what your peers think about IBM InfoSphere DataStage. Get advice and tips from experienced pros sharing their opinions. Updated: April 2025.
856,873 professionals have used our research since 2012.

What do I think about the stability of the solution?

I rate the solution's stability a seven out of ten. 

What do I think about the scalability of the solution?

My company has 12 users for IBM InfoSphere DataStage. I rate its scalability a nine out of ten. 

How are customer service and support?

It takes time to get answers from the support. The responsiveness varies. Sometimes it is fast, and other times it is slow. 

How would you rate customer service and support?

Neutral

How was the initial setup?

IBM has good installation documents. The tool's deployment took a day to complete. 

What other advice do I have?

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. 

Disclosure: My company does not have a business relationship with this vendor other than being a customer.
PeerSpot user
ArturKowalczyk - PeerSpot reviewer
Technology Innovation Leader at Netrix S.A.
Real User
Flexible with good connectivity and good modeling
Pros and Cons
  • "We like the flexibility of modeling."
  • "The error messaging needs to be improved."

What is our primary use case?

The product is primarily used for  intense data transformation; it's part of the risk management, and dataflow, and is sourcing data from the data warehouse on the SAP Sybase platform.

What is most valuable?

The connectivity with the databases and the speed and flexibility of modeling is excellent. We like the flexibility of modeling.

The solution is stable.

It can scale.

What needs improvement?

We'd like better integration with source control and error and diagnostic information. The error messaging needs to be improved. 

The solution is a bit complicated. 

For how long have I used the solution?

I've been using the solution for four years. 

What do I think about the stability of the solution?

It's stable. it's reliable. There are no bugs or glitches. It doesn't crash or freeze. 

What do I think about the scalability of the solution?

We can scale the solution as needed. 

There are about 50 users on the solution right now. 

How are customer service and support?

While technical support may have been used, I have never personally dealt with them.

Which solution did I use previously and why did I switch?

I've used SSIS as well and find this product to be more difficult to set up.

How was the initial setup?

The initial setup can be challenging. It's harder to set up than, for example, SSIS.

I'm not sure how long it took to set up, as it was already in place when I joined the team. However, I would say it took a week to deploy.

We have five people on hand that can handle deployment and maintenance tasks. They are all engineers. 

What about the implementation team?

The initial setup can be handled in-house. 

What's my experience with pricing, setup cost, and licensing?

The licensing we have is permanent. 

What other advice do I have?

I'd recommend the product to others. 

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

Which deployment model are you using for this solution?

On-premises
Disclosure: My company does not have a business relationship with this vendor other than being a customer.
PeerSpot user
Buyer's Guide
IBM InfoSphere DataStage
April 2025
Learn what your peers think about IBM InfoSphere DataStage. Get advice and tips from experienced pros sharing their opinions. Updated: April 2025.
856,873 professionals have used our research since 2012.
Utkarsh Shrivastava - PeerSpot reviewer
ETL/Solution Architect at Crux
Real User
Good performance optimization and useful for ETL purposes when we're building data warehouses or data marts
Pros and Cons
  • "The performance optimization is quite good in DataStage. It provides parallelism and pipelining mechanisms"
  • "In the future, I would like to see more integration with cloud technologies."

What is our primary use case?

The primary use case is for ETL purposes for when we're building data warehouses or data marts. We use it to get the data from different disparate sources, do some ETL on them, and we use DataStage and then load them into the data warehouse, database, or data mart.

This solution used to be on-premises, but they've recently come out with a hybrid offering.

What is most valuable?

The performance optimization is quite good in DataStage. It provides parallelism and pipelining mechanisms. I have not found those in Informatica or Talend.

What needs improvement?

As a product, it needs to be more stable. It's a legacy product, so even though it's high-performing, it's not very stable compared to other products like Informatica or Talend. The UI also looks dated.

In the future, I would like to see more integration with cloud technologies. Technical support could be improved.

For how long have I used the solution?

I've worked with DataStage for about 9 years.

What do I think about the stability of the solution?

The stability could be better.

What do I think about the scalability of the solution?

It's scalable.

How are customer service and support?

I would rate technical support 6 out of 10.

How was the initial setup?

For the on-prem solution, it was moderately complex. I'm not sure about the hybrid version.

What other advice do I have?

I would rate this solution 8 out of 10.

Which deployment model are you using for this solution?

Hybrid Cloud
Disclosure: My company does not have a business relationship with this vendor other than being a customer.
PeerSpot user
reviewer1623630 - PeerSpot reviewer
Head of IT Integration & Finance Transformation at a financial services firm with 5,001-10,000 employees
Real User
Great flexibility with full delivery integration
Pros and Cons
  • "Offers great flexibility."
  • "Currently lacking virtualization ability."

What is our primary use case?

The most powerful use of this solution is for full delivery integration. Aside from the ETL aspect, it makes data lineage. We are customers of IBM InfoSphere and I'm head of IT integration and finance transformation.

What is most valuable?

The key feature for me is the flexibility this solution offers. 

What needs improvement?

The solution is currently lacking virtualization ability. If they were to include it, it could be a good evolution on this framework. I'd like to see an improvement in support and a more customer friendly and knowledgeable support staff.  

For how long have I used the solution?

I've been using this solution for over 20 years. 

What do I think about the scalability of the solution?

Scalability is a question of licensing, but it can definitely be done.

How are customer service and technical support?

Technical support could be better - more knowledgeable and customer friendly. 

How was the initial setup?

We outsourced deployment to IBM and didn't have any issues. Implementation took about two weeks. We have between 20 and 30 users in the company and our maintenance is carried out by IBM.

What's my experience with pricing, setup cost, and licensing?

We pay an annual licensing fee. 

Which other solutions did I evaluate?

Yes, we evaluated other tools, and this tool is competing internally with our PySQL development. It's a battle between code and local.

What other advice do I have?

I rate this solution an eight out of 10. 

Which deployment model are you using for this solution?

On-premises
Disclosure: My company does not have a business relationship with this vendor other than being a customer.
PeerSpot user
reviewer1544970 - PeerSpot reviewer
Manager at a consultancy with 1,001-5,000 employees
Real User
Robust and scalable but the initial setup is not straightforward and the price is high
Pros and Cons
  • "It's a robust solution."
  • "The initial setup could be more straightforward."

What is our primary use case?

We are a solution provider and this is one of the products that we implement for our clients.

This solution has an end-to-end process used for data integration.

What is most valuable?

It's a robust solution.

What needs improvement?

The initial setup could be more straightforward.

For how long have I used the solution?

We have been providing IBM InfoSphere DataStage for one year.

What do I think about the stability of the solution?

I believe this solution is stable. We have not received any feedback from our clients.

What do I think about the scalability of the solution?

To my understanding, this solution is scalable.

We have several customers who are currently using it.

How are customer service and technical support?

I have not contacted technical support.

Which solution did I use previously and why did I switch?

We have a long list of different providers such as Informatica, IBM, Oracle, Microsoft SSIS, Pentaho, and Talend.

How was the initial setup?

The installation was not straightforward and I would rate it at medium complexity.

What about the implementation team?

The installation required assistance from an expert from IBM.

What's my experience with pricing, setup cost, and licensing?

The price is expensive but there are no licensing fees.

What other advice do I have?

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.

Which deployment model are you using for this solution?

On-premises
Disclosure: My company has a business relationship with this vendor other than being a customer: Partner
PeerSpot user
Systems Integration Associate Director at a computer software company with 10,001+ employees
Real User
Helpful support, and the Hierarchical Data Stage is good
Pros and Cons
  • "The Hierarchical Data Stage is good."
  • "The interface needs improvement."

What is our primary use case?

We are a consulting company and we use this solution for our clients. We set up the data for them. We have various healthcare-related information from their vendor and business partners. They have integrated them and get data reports from it.

How has it helped my organization?

It improves how our client's organization functions.

What is most valuable?

We mainly use the designer and developer qualities. We use the basic features that we have.

They have many good features. The Hierarchical Data Stage is good.

What needs improvement?

The interface needs improvement. The interface in Informatica is easier than in DataStage.

The licensing can be improved. Many companies are moving away from DataStage because it is expensive.

The biggest issue that is unclear is how are they integrating into DevOps when they are binary files.

We would like to see DataStage integrated with DevOps so that a pipeline can be created for auto-deployment. Right now we are all doing it manually.

For how long have I used the solution?

I have been working with IBM InfoSphere DataStage for seven years.

We have the 11.3 version but have recently migrated to the 11.7 version.

What do I think about the stability of the solution?

It's a stable product, it's not new.

What do I think about the scalability of the solution?

It's very scalable. Our clients are medium-sized companies with a 1.5 billion turnover.

How are customer service and technical support?

We reached out to IBM because the file was not readable, and they resolved the issue.

Technical support is good. I have not found any issues with technical support. I would rate them an eight out of ten.

In some cases, they have a delay in giving suggestions for the configuration.

Which solution did I use previously and why did I switch?

Previously, in another company, I worked with Informatica. There are not a lot of differences but the interface is easier than it is in DataStage.

How was the initial setup?

I don't do the setup, but I think that they have many challenges.

Initially, we had challenges with the configuration. We were trying to use the comparison for Excel, and reading the Excel files from the source, but the files were not readable.

What's my experience with pricing, setup cost, and licensing?

It's very expensive.

Which other solutions did I evaluate?


What other advice do I have?

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.

Which deployment model are you using for this solution?

On-premises
Disclosure: My company does not have a business relationship with this vendor other than being a customer.
PeerSpot user
IT Analyst at Tata Consultancy Services
Real User
A stable solution for loading data into our data warehouse
Pros and Cons
  • "The most valuable feature is the data integration for data warehousing."
  • "The response time from support is slow and needs to be improved."

What is our primary use case?

We primarily use this product for data loading. We take data from different applications and databases and put it into our data warehouse. 

What is most valuable?

The most valuable feature is the data integration for data warehousing.

What needs improvement?

The response time from support is slow and needs to be improved.

For how long have I used the solution?

I have been using InfoSphere DataStage for almost eight years.

What do I think about the stability of the solution?

This is a stable product.

What do I think about the scalability of the solution?

We have almost 30 people who use InfoSphere DataStage.

How are customer service and technical support?

Technical support can be slow.

What other advice do I have?

This product has a lot of good features.

I would rate this solution an eight out of ten.

Disclosure: My company has a business relationship with this vendor other than being a customer: partner
PeerSpot user
Senior Data Warehouse Developer at a computer software company with 5,001-10,000 employees
MSP
Stable and scalable with a straightforward setup
Pros and Cons
  • "Finding logs is very easy on the solution."
  • "The template mapping could be easier."

What is our primary use case?

We primarily use the solution for the UTS tool as well a for billing and data. We use it to clean the data from different systems and for pulling in data.

What is most valuable?

The solution is good for bringing in data from third-party systems.

Various aspects of the solution are valuable, but it often depends on the use cases.

Finding logs is very easy on the solution.

Overall, compared to SAS or Informatica, the solution is much easier to navigate.

What needs improvement?

The mod options should be simplified. Some options on DataStage aren't working properly.

The solution needs to lower its price.

The template mapping could be easier.

The solution should allow for compression of data.

For how long have I used the solution?

I've been using the solution for about 12 years.

What do I think about the stability of the solution?

Typically, the solution is stable.

What do I think about the scalability of the solution?

The solution is scalable. We have about six or seven clients using the solution currently.

How are customer service and technical support?

We've never been in direct contact with IBM's technical support. We use a third party, so if we have issues, we turn to them for troubleshooting.

Which solution did I use previously and why did I switch?

We previously used tools such as Informatica. We've also previously used SQL for billing.

How was the initial setup?

The initial setup is easy for the DataStage, but for billing and metadata, it gets more complicated. In our case, before installing the metadata, the proper documentation was not there, which complicated things a bit.

What about the implementation team?

We handled the implementation ourselves.

What's my experience with pricing, setup cost, and licensing?

The solution is quite expensive in comparison to similar solutions.

Which other solutions did I evaluate?

We did approach other vendors before ultimately choosing IBM.

What other advice do I have?

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.

Disclosure: My company does not have a business relationship with this vendor other than being a customer.
PeerSpot user
Buyer's Guide
Download our free IBM InfoSphere DataStage Report and get advice and tips from experienced pros sharing their opinions.
Updated: April 2025
Product Categories
Data Integration
Buyer's Guide
Download our free IBM InfoSphere DataStage Report and get advice and tips from experienced pros sharing their opinions.