Skip to main content
TrustRadius
IBM DataStage

IBM DataStage
Formerly InfoSphere DataStage

Overview

What is IBM DataStage?

IBM® DataStage® is a data integration tool that helps users to design, develop and run jobs that move and transform data. At its core, the DataStage tool supports extract, transform and load (ETL) and extract, load and transform (ELT) patterns.…

Read more
Recent Reviews

DATASTAGE -ETL

10 out of 10
January 31, 2019
Incentivized
  • DS is one of the most powerful ETL tools on the market. Its connectors to different bases plus the pack make it a solid tool, and …
Continue reading
Read all reviews

Awards

Products that are considered exceptional by their customers based on a variety of criteria win TrustRadius awards. Learn more about the types of TrustRadius awards to make the best purchase decision. More about TrustRadius Awards

Popular Features

View all 11 features
  • Simple transformations (9)
    9.8
    98%
  • Connect to traditional data sources (9)
    9.5
    95%
  • Complex transformations (9)
    9.3
    93%
  • Collaboration (9)
    9.0
    90%
Return to navigation

Pricing

View all pricing
N/A
Unavailable

What is IBM DataStage?

IBM® DataStage® is a data integration tool that helps users to design, develop and run jobs that move and transform data. At its core, the DataStage tool supports extract, transform and load (ETL) and extract, load and transform (ELT) patterns. A basic version of the software is available for on…

Entry-level set up fee?

  • No setup fee

Offerings

  • Free Trial
  • Free/Freemium Version
  • Premium Consulting/Integration Services

Would you like us to let the vendor know that you want pricing?

28 people also want pricing

Alternatives Pricing

N/A
Unavailable
What is SolarWinds Task Factory?

According to the vendor, SolarWinds Task Factory saves time managing tedious ELT/ETL tasks with high-performing SQL Server Integration Services (SSIS) components that can be used within the Visual Studio environment to connect to nearly any data source. Task Factory’s components and tasks have been…

What is Skyvia?

Skyvia is a cloud platform for no-coding data integration (both ELT and ETL), automating workflows, cloud to cloud backup, data management with SQL, CSV import/export, creating OData services, etc. The vendor says it supports all major cloud apps and databases, and requires no software except a web…

Return to navigation

Features

Data Source Connection

Ability to connect to multiple data sources

9.1
Avg 8.2

Data Transformations

Data transformations include calculations, search and replace, data normalization and data parsing

9.5
Avg 8.4

Data Modeling

A data model is a diagram or flowchart that illustrates the relationships between data

9
Avg 8.1

Data Governance

Data governance is the practise of implementing policies defining effective use of an organization's data assets

8.9
Avg 8.2
Return to navigation

Product Details

What is IBM DataStage?

IBM® DataStage® is a data integration tool that helps users to design, develop and run jobs that move and transform data. At its core, the DataStage tool supports extract, transform and load (ETL) and extract, load and transform (ELT) patterns. A basic version of the software is available for on-premises deployment, and the cloud-based DataStage for IBM Cloud Pak® for Data offers automated integration capabilities in a hybrid or multicloud environment.


IBM DataStage Technical Details

Deployment TypesOn-premise, Software as a Service (SaaS), Cloud, or Web-Based
Operating Systems,
Mobile ApplicationNo

Frequently Asked Questions

IBM® DataStage® is a data integration tool that helps users to design, develop and run jobs that move and transform data. At its core, the DataStage tool supports extract, transform and load (ETL) and extract, load and transform (ELT) patterns. A basic version of the software is available for on-premises deployment, and the cloud-based DataStage for IBM Cloud Pak® for Data offers automated integration capabilities in a hybrid or multicloud environment.

Reviewers rate Simple transformations highest, with a score of 9.8.

The most common users of IBM DataStage are from Enterprises (1,001+ employees).
Return to navigation

Comparisons

View all alternatives
Return to navigation

Reviews and Ratings

(34)

Attribute Ratings

Reviews

(1-4 of 4)
Companies can't remove reviews or game the system. Here's why
niman goli | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Incentivized
IBM InfoSphere DataStage is used for data analysis for business trending and banking aging report for the customers.It would be helpful for finding when the last transaction was done and when the future transaction would be coming for . IBM InfoSphere DataStagecan help with ease of access , easy of gui management and easy navigation for the user to great help
  • banking environment
  • user data management
  • user account management
  • data stage integration with cloud
  • integration with bmc
  • database management with datastage
it is suited for the scenario where the major or more number users and transactions are involved.it would help with data analysis,of how many transactions, and what was the frequency of the transactions,how much amount was paid and how much was the due , and how many count of the refills done.
Data Source Connection (2)
100%
10.0
Connect to traditional data sources
100%
10.0
Connecto to Big Data and NoSQL
100%
10.0
Data Transformations (2)
100%
10.0
Simple transformations
100%
10.0
Complex transformations
100%
10.0
Data Modeling (5)
100%
10.0
Data model creation
100%
10.0
Metadata management
100%
10.0
Business rules and workflow
100%
10.0
Collaboration
100%
10.0
Testing and debugging
100%
10.0
Data Governance (2)
100%
10.0
Integration with data quality tools
100%
10.0
Integration with MDM tools
100%
10.0
  • its best on return on investment
  • its comes at low cost
  • its easy of use access
its very good and i would get best support from ibm if their is any issue.i would upgrade it very easily.ibm red books are very good for learning and getting expertise on the product.we would get frequent updates when their is a patch released.it would be easy to integrate with other product or open source
BMC Automated Mainframe Intelligence (AMI), Dell EMC AppSync, Hitachi Compute Blade (BladeSymphony)
Edger Loredo | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Incentivized
The effective mapping product and highly effective for project data management and scalability is the best. Functions are simple to start with and all the features are easy to custom. The IBM platform offers the best mapping capability and the data modeling functions are excellent. The reports are excellent and effective.
  • Mapping tools are excellent.
  • Reporting functions.
  • Data collaboration.
  • The deep functions manipulation is tricky.
  • Tools are not easy to manipulate through Cloud services.
  • Ability to manage big data can be more functional.
Excellent Cloud data mapping tool and easy creating multiple project data analytics in real-time and the report distribution are excellent via this IBM product. Easy tool to provide data visualization and the integration is effective and helpful to migrating huge amounts of data across other platforms and different websites insights gathering.
Data Source Connection (2)
90%
9.0
Connect to traditional data sources
90%
9.0
Connecto to Big Data and NoSQL
90%
9.0
Data Transformations (2)
90%
9.0
Simple transformations
90%
9.0
Complex transformations
90%
9.0
Data Modeling (5)
90%
9.0
Data model creation
90%
9.0
Metadata management
90%
9.0
Business rules and workflow
90%
9.0
Collaboration
90%
9.0
Testing and debugging
90%
9.0
Data Governance (2)
85%
8.5
Integration with data quality tools
80%
8.0
Integration with MDM tools
90%
9.0
  • Great data mapping solution and easy to assemble various data report.
  • Excellent analytics production and easy to visualize big data.
  • Easy project management and reliable integration platform and Cloud data management.
With effective capabilities and easy to manipulate the features and easy to produce accurate data analytics and the Cloud services Automation, this IBM platform is more reliable and easy to document management. The features on this platform are equipped with excellent big data management and easy to provide accurate data analytics.
Score 7 out of 10
Vetted Review
Verified User
Incentivized
We use DataStage for ETL development, creating jobs to extract the data from different source systems and transform the data to use with different databases, and load the data into the database tables/views using staging tables. We use DataStage with Cognos to show the glossary information for any particular field and track it all the way from the report to the source application.
  • Data integration
  • ETL jobs
  • Business Glossary
  • Creating snapshot views using jobs
  • Better interface for the job designs
It helps minimize the project delivery cycle since it allows a common set of tools across IIS. MDM integrations are a plus.
Data Source Connection (2)
85%
8.5
Connect to traditional data sources
90%
9.0
Connecto to Big Data and NoSQL
80%
8.0
Data Transformations (2)
90%
9.0
Simple transformations
100%
10.0
Complex transformations
80%
8.0
Data Modeling (5)
86%
8.6
Data model creation
90%
9.0
Metadata management
70%
7.0
Business rules and workflow
80%
8.0
Collaboration
100%
10.0
Testing and debugging
90%
9.0
Data Governance (2)
80%
8.0
Integration with data quality tools
70%
7.0
Integration with MDM tools
90%
9.0
  • Mostly positive since we use all kind of different source system applications.
  • It provides graphical framework for jobs development.
  • The can be transformed and delivered to different databases.
It's obvious since they both are from the same vendors and it makes it easier and can get better rates for licensing. Also, sales rapes are very helpful in case of escalations and critical issues.
Score 8 out of 10
Vetted Review
Verified User
Incentivized
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.
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.
Data Source Connection (1)
80%
8.0
Connect to traditional data sources
80%
8.0
Data Transformations (2)
95%
9.5
Simple transformations
100%
10.0
Complex transformations
90%
9.0
Data Modeling (4)
72.5%
7.3
Metadata management
80%
8.0
Business rules and workflow
90%
9.0
Collaboration
40%
4.0
Testing and debugging
80%
8.0
Data Governance
N/A
N/A
  • 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.
Return to navigation