Program Manager at a consultancy with 10,001+ employees
Real User
Top 20
The solution can incorporate very complex business rules, is moderately scalable, and is stable
Pros and Cons
  • "The most valuable feature of the solution is the ability to incorporate very complex business rules in Data Stage."
  • "The solution can be a bit more user-friendly, similar to Informatica."

What is our primary use case?

The solution is mainly used for, marketing campaigns, customer segmentation, and home loans.

What is most valuable?

The most valuable feature of the solution is the ability to incorporate very complex business rules in Data Stage.

What needs improvement?

The solution can be a bit more user-friendly, similar to Informatica.

I would like the solution to have some basic streaming functionality added.

For how long have I used the solution?

I have been using the solution for one year.

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

What do I think about the stability of the solution?

We don't currently have much in our production environment. We are gradually moving into production, so whatever small setup we have is okay for now. I'm taking the overall perspective into account and I think we do have dependencies on the other jobs. This is purely based on the feedback we receive, which sometimes means that we're not able to run our process because there are dependencies, similar to other jobs also. The jobs don't complete on time. We received feedback that there was a problem handling data, which caused jobs to fail and needed to be rerun. This could be product-specific, design-specific, or anything else, but I think there is room for improvement in terms of stability. I would give the solution a seven out of ten.

What do I think about the scalability of the solution?

I think that scalable systems should also have good performance. The scalability of this solution in my opinion may not be on the same level as Informatica Power Exchange Data Integration.

I give the scalability of the solution a seven out of ten. We are facing problems whenever we have huge amounts of data and there are job failures. We need to take care of how to tackle that situation. 

How was the initial setup?

We didn't need to do anything because the customer, with whom we are working on the project, had already set everything up for us. The initial setup was not in our preview.

What other advice do I have?

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.

Which deployment model are you using for this solution?

Hybrid Cloud

If public cloud, private cloud, or hybrid cloud, which cloud provider do you use?

Google
Disclosure: My company has a business relationship with this vendor other than being a customer:
PeerSpot user
Data Architect at Blue Technology
Real User
Top 10
A highly-stable and scalable solution with seamless integration capabilities
Pros and Cons
  • "The concept of integration is a valuable feature of the product."
  • "The graphical user interface (GUI) feels a lot like the interfaces from the 1980s."

What is our primary use case?

We use it for many kinds of projects. For example, we use it for business intelligence, master data management, data quality, data governance, data integration to SAP, Oracle retail, and real-time integration.

What is most valuable?

The concept of integration is a valuable feature of the product. The product excels in this area. In fact, it is one of the two leading products in the integration field. 

Based on my experience, interacting with data through integration has been more profitable than any other products or projects. Data integration is a reliable feature.

What needs improvement?

The graphical user interface (GUI) feels a lot like the interfaces from the 1980s. Regarding IBM, they initially indicated that version 8.11.7 would be their final release. We require more connectors to establish clear connections to cloud services. Connecting to the cloud is not easy or transparent within the product. Although the product has the potential to connect to the cloud, configuring and setting it up is challenging.

In future releases, connecting to the cloud should be easy and transparent.

For how long have I used the solution?

I’ve been using this solution since 2005. I’m currently using version 11.7.

What do I think about the stability of the solution?

The stability of the solution is ten on ten.

What do I think about the scalability of the solution?

The scalability of the solution is nine on ten.

How was the initial setup?

Setting up the system is difficult and requires a lot of technical expertise. It demands a high level of experience during the setup process. 

However, despite the difficulty, our team, possibly the only one in Mexico, is good at quickly completing the setup.

Most of our implementations or installations are on-premises, accounting for approximately 90% of the total. The remaining 10% of our implementations are on the cloud.

What was our ROI?

The product has proven to be exceptional and highly competitive in the market. As a result, I have experienced substantial financial success with the product. There are many examples we have for the ROI.

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

The price of the product is reasonable, especially for mid-sized companies. We have been successfully selling to several mid-sized companies.

Which other solutions did I evaluate?

The market is indeed filled with numerous solutions. Currently, I am exploring Microsoft's offerings, particularly their integration capabilities. Also, the purpose and functionalities of Azure are pretty interesting. I have been working with Quick Link, and specifically, I have been working with Azure Database.

What other advice do I have?

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. 

Disclosure: I am a real user, and this review is based on my own experience and opinions.
Flag as inappropriate
PeerSpot user
Buyer's Guide
IBM InfoSphere DataStage
March 2024
Learn what your peers think about IBM InfoSphere DataStage. Get advice and tips from experienced pros sharing their opinions. Updated: March 2024.
765,386 professionals have used our research since 2012.
Owner at mip GmbH
Real User
Powerful, reliable and the ability to run it in parallel mode makes it very fast
Pros and Cons
  • "The product is a stable and powerful data management solution that can run in parallel mode for enhanced speed."
  • "The interface needs work to be more user-friendly."

What is our primary use case?

We are a consultancy company, so we are not using DataStage for our own purposes. We deploy it for our customers. We use it to supply data integration and data warehousing solutions based on the specific needs of clients.

How has it helped my organization?

The product has improved our organization by allowing us to provide the product to clients as a reliable data management solution.

What is most valuable?

The product is a very powerful data management tool and the ability to run it in the parallel mode makes it very, very fast. I would say that the ability to use parallel mode would be one of the most valuable features.

What needs improvement?

The features that could be better starts with the user interface. It has been getting better in the last releases and in the past few years, and I guess that they will continue to make progress on this front. But even with the improvements that they have made, it could be even better now, and really should be. I think it's a little bit difficult to use because of the interface. Being user-friendly is important for any product and they need to make this adjustment.

In addition to improvements in the base user interface, I would say it would be good to incorporate more interface options for cloud-based systems.

For how long have I used the solution?

The organization has been using this solution for about 10 years.

What do I think about the stability of the solution?

The product is very stable. The stability enhances the fact that it is powerful and fast, so it is a reliable solution with good performance.

What do I think about the scalability of the solution?

I feel that the product has excellent scalability. We currently have more than 15,000 users as clients worldwide and scalability has never presented as an issue. It's used in the U.S., in Asia, and in Europe, so it seems to perform in various markets satisfactorily.

It's an enterprise-enabled product, so with that designation, it really needs to be scalable to satisfy the needs of clients — and those needs change all the time. It has the ability to connect reliably to a lot of sources and this is a very, very important thing for people who are using it.

How are customer service and technical support?

We do have some experience with technical support and customer services. We have access to the IBM software hotline, which is normal for IBM.  They work with the FTS (Follow the Sun) support model which means they are available 24/7. The availability is good and the response is as well. I would say it is good support.

How was the initial setup?

The initial setup of the product is straightforward. The first deployment may be more complex in one case than another. It depends on the complexity of the processes an organization is building and what they need to consider in future planning. Normally you can install it without much trouble and have your first processes live within a few days.

After that, the project is ongoing and it becomes more complex as you build it out. Normally everything does not have to be in place from the beginning as the solution may be deployed to solve new or future issues. In other words it is not replacing something that is already functioning, it is providing something new. As you build out, you get more processes going and the setup becomes more complex. But the initial setup is quite simple.

What about the implementation team?

We do the deployment with our own team for the client, but the implementation can change depending on the client needs. When the client has specific things that need to be resolved for their situation or they want to install and to implement additional products to integrate with the base solution, that affects the rollout. It's especially true during the implementation stage. The implementation team can begin with as little as one person and it can end up as a team of five, six, or seven members depending on complexity and needs for rapid deployment. It also depends on whether the product is going to be used throughout the company. There are a lot of customers who deploy globally or selectively because they may have a strategy already in place for certain solutions that they may not want to change. For example, they may already have ETL processes being used without DataStage and it may not make sense to convert these processes.

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

It is very difficult to say how much the product costs because there are variables depending on the configuration. Normally it's priced according to use, so the price can vary quite a lot. The more you use, the more you pay.

In comparison to other products, I would say it's not so expensive as Informatica, but it is intended to be an enterprise solution so it's not very cheap to deploy as products that are not enterprise solutions.

The products we offer are really very different in pricing compared to open-source products. With open-source you have only the maintenance cost. For the software products we use, you have to invest in the software and then the maintenance costs are in addition to that.

There are no other costs in addition to the standard licensing fee and the maintenance. With IBM, you typically pay for the licenses and the first 12 months of maintenance is included in that cost. Afterward, you pay for the maintenance year-to-year.

Which other solutions did I evaluate?

We currently also use PowerCenter from Informatica as a solution for some clients. It isn't really a previous solution or a solution we evaluated and discarded but it is one that we sometimes use instead of DataStage. It depends on the needs of our customers.

The decision on which product to pick has partly to do with what the client wants to do and what we believe is the better solution for them and their needs. We have some projects where we use PowerCenter simply because our customer wants to use it; we have other projects where we use DataStage because of some of these customers are already using DataStage or they prefer it because it is from IBM.

In a similar way, we sometimes use Microsoft Integration Services, which is a very small part of our business. But again it isn't so much that we evaluated the solution and dismissed it or switched from using it. These products are opportunities for us to choose between in order to provide the best solution for clients. We evaluate the options and choose the best fit for the project.

What other advice do I have?

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.

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: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
Muharrem Iseri - PeerSpot reviewer
Managing Partner at a tech services company with 11-50 employees
Real User
Top 5
Easy to understand to monitor the data lineage from source to target but pricing could be better
Pros and Cons
  • "IBM is stable and accurate to monitor. It's easy to understand to monitor the data lineage from source to target."
  • "DataStage is quite expensive. It is too hard to find a consultant using DataStage in Turkey."

What is our primary use case?

IBM InfoSphere DataStage is a core ETL tool. We use it with source systems like mainframes. DataStage is perfectly suited for extracting data from mainframes.

What is most valuable?

IBM is stable and accurate to monitor. It's easy to understand to monitor the data lineage from source to target.

What needs improvement?

DataStage is quite expensive. It is too hard to find a consultant using DataStage in Turkey.

For how long have I used the solution?

I have been using IBM InfoSphere DataStage for three years. I also used this solution for two years back in 2009-10.

What do I think about the stability of the solution?

The product is stable.

I rate the solution’s stability a nine out of ten.

What do I think about the scalability of the solution?

I rate the solution’s scalability an eight out of ten.

How are customer service and support?

The quality and response time of support is fine. It's pretty quick.

How would you rate customer service and support?

Positive

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

Informatica is the first choice for me. It's easy to use and not so expensive compared to DataStage.

How was the initial setup?

You install IBM InfoSphere DataStage once you've set it up properly. It's robust and reliable, but initially configuring it can be challenging.

What other advice do I have?

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.

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
Flag as inappropriate
PeerSpot user
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. 

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: I am a real user, and this review is based on my own experience and opinions.
Flag as inappropriate
PeerSpot user
Roshan Jayakodi - PeerSpot reviewer
Consultant - Data Engineering at South Asian Technologies
Reseller
Top 10
Data integration tool that is scalable and offers good customer support for premium customers
Pros and Cons
  • "When we have needed help from the IBM team, they were helpful. Our company is a premium partner so we get fast responses."
  • "Their web interface is good but the on-prem sites are outdated. The solution could also be improved if they could integrate the data pipeline scheduling part of their interface."

What is our primary use case?

We started using this solution as we needed a system upgrade. We had to move the Db2 data to a AS400 system. 

What is most valuable?


What needs improvement?

Their web interface is good but the on-prem sites are outdated. The solution could also be improved if they could integrate the data pipeline scheduling part of their interface. 

For how long have I used the solution?

We have been using this solution for a couple of months.

What do I think about the scalability of the solution?

This is a scalable solution. 

How are customer service and support?

When we have needed help from the IBM team, they were helpful. Our company is a premium partner so we get fast responses. 

How would you rate customer service and support?

Positive

How was the initial setup?

The infrastructure and the software configuration part was done by one of my teammates. We were able to complete it in two working days. This was only for the installation of DataStage. 

What other advice do I have?

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. 

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:
PeerSpot user
ArturKowalczyk - PeerSpot reviewer
Technology Innovation Leader at Netrix S.A.
Real User
Top 5Leaderboard
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: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
Buyer's Guide
Download our free IBM InfoSphere DataStage Report and get advice and tips from experienced pros sharing their opinions.
Updated: March 2024
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.