IBM InfoSphere DataStage Primary Use Case

BB
DataStage at a healthcare company with 10,001+ employees

We are supporting a healthcare domain vendor located in the US. We get data from various domains, such as health insurance. We have member data, provider data, and consumer data. We also have client-related stuff and broker-related commission data. 

We get the data from these domains, and after receiving it, we apply the transformation rules, such as joints. We also do the standardization of data by formatting and doing field validations, such as formatting the date field and doing data and time validations. We also do other normal transformations with some business logic. After applying all this, we send the data to the business.

View full review »
Sumeet  Zalpuri - PeerSpot reviewer
Data engineer at ASR Nederland N.V.

I'm working for an insurance provider. They have applications where they register claims, insurance, et cetera. We get a flat file from the vendor and put those flat files into our Oracle Data Warehouse and report on the data. We publish those reports to our institutional investors, partners, and business users, including banks. 

View full review »
Rahul Saxena - PeerSpot reviewer
Manager - Business Technology Solutions at a consultancy with 1,001-5,000 employees

The tool is used for ETL. It is one of the leading tools in the industry.

View full review »
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,234 professionals have used our research since 2012.
AM
CEO at DELOMID IT

We use the solution for data warehousing and data migration. 

View full review »
Amir Amin - PeerSpot reviewer
Solution Architect - Data Engineering at Tenx

We have integrated multiple data sources into a single data warehouse. For this, we used to build complex ETL jobs and datasets to integrate data from multiple sources into a single data warehouse. So, these are basically the use cases.

View full review »
Tirthankar Roy Chowdhury - PeerSpot reviewer
Teamlead at Tata consultancy services

IBM InfoSphere DataStage was mostly used for ETL and data integration purposes, so extract, transfer, and load, including some data quality use cases. My team used the solution to extract data from various sources, do some business transformations, load the data into a target database, or generate files.

View full review »
Shifa Shah - PeerSpot reviewer
Data engineer at nust

Right now, I'm working for a telecom company. So, we are using IBM InfoSphere DataStage for constructing ETL jobs for them so that they can load data from their various different sources into their warehouse.


View full review »
ARTURO MONTIEL - PeerSpot reviewer
Arquitecto Industrial IoT at a consultancy with 10,001+ employees

We primarily use IBM InfoSphere DataStage for ETL scenarios, extracting, transforming, and loading data across various systems efficiently. Although we experimented with using it for real-time or on-time integrations in the past few years, our main focus remains on its strength in traditional batch data integration processes.

View full review »
SM
Program Manager at a consultancy with 10,001+ employees

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

View full review »
HM
Data Architect at Blue Technology

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.

View full review »
UF
Owner at mip GmbH

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.

View full review »
PB
Senior Data Warehouse Developer at a computer software company with 5,001-10,000 employees

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.

View full review »
Muharrem Iseri - PeerSpot reviewer
Managing Partner at a tech services company with 11-50 employees

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.

View full review »
TN
Technical Data Analyst at a government with 10,001+ employees

We migrate data from old databases to new databases. 

View full review »
Roshan Jayakodi - PeerSpot reviewer
Consultant - Data Engineering at South Asian Technologies

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

View full review »
ArturKowalczyk - PeerSpot reviewer
Technology Innovation Leader at Netrix S.A.

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.

View full review »
RL
Partner at Avydium Data LLC

Complex data integration projects which require integration from multiple data sources.

View full review »
Kirill Slivchikov - PeerSpot reviewer
Owner at 7Spring Consult

I work as a consultant and I have several projects with the Russian banks. My main expertise is building data warehouses and I use the product as a ETL. 

View full review »
JM
Manager at a consultancy with 1,001-5,000 employees

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.

View full review »
Utkarsh Shrivastava - PeerSpot reviewer
ETL/Solution Architect at Crux

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.

View full review »
PR
Systems Integration Associate Director at a computer software company with 10,001+ employees

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.

View full review »
RT
Data/Solution Architect at a computer software company with 51-200 employees

We use it for creating a pattern for data integration with our data vault. We have also used it for creating APIs.

View full review »
AM
CEO at DELOMID IT

We implement this solution for our customers. The majority of them are Enterprise companies.

View full review »
TD
IT Administrator at a transportation company with 10,001+ employees

We primarily use the solution for ETL jobs and movement of data.

View full review »
KS
Owner at 7Spring Consult

I am a consultant. I provide product information for our clients.

View full review »
NC
IT Analyst at Tata Consultancy Services

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

View full review »
AG
Head of IT Integration & Finance Transformation at a financial services firm with 5,001-10,000 employees

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.

View full review »
Muharrem Iseri - PeerSpot reviewer
Managing Partner at a tech services company with 11-50 employees

My company is a consulting firm and I'm a managing partner. We consult for large size companies in the telecommunications, banking and insurance sectors. We partner with IBM. We're not using the latest version of DataStage but one of the more recent ones. I use the product for a migration project. It's a DB2 to Oracle migration project and the source database is mainframe. I need DataStage for that purpose.

View full review »
KS
Owner at 7Spring Consult

It is in the environment of our client, who is a large Russian bank. They are in the top 20, as of August, and have the re-maintenance project of their data warehouse solution based on IBM technologies. They use IBM BWD, a banking data model, on Netezza and DataStages in ETL tools. It is a native case.

We are using the on-premise deployment model.

View full review »
CO
Managing Director at a tech services company with 11-50 employees

We are using this solution with enterprise customers for ETL (Extract, Transform and Load). The clients are just using it for retail processes.  

View full review »
MU
Enterprise and Information Architect at a tech consulting company with self employed

I'm an enterprise and information architect, and we're a customer of IBM. I personally don't use the product but assist companies in the market do for making the integration picture and design.

View full review »
it_user1093698 - PeerSpot reviewer
Technical Partner Manager at a tech services company with 1,001-5,000 employees

My customers use it. I don't use this solution. It's used to extract data from several different sources, as well as to store data and load it into a data warehouse.

View full review »
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,234 professionals have used our research since 2012.