Can DataStage call a Web service?

The existing DS job calls an XML web service (SOAP) to push items onto the SharePoint hosted queue. The Job has to be modified to invoke the new JSON call and pushes the data to Azure cloud. Any examples I can refer to see how JSON calls were made from WST stage.

Is DataStage still used?

The companies using IBM InfoSphere DataStage are most often found in United States and in the Computer Software industry. IBM InfoSphere DataStage is most often used by companies with 50-200 employees and >1000M dollars in revenue. Our data for IBM InfoSphere DataStage usage goes back as far as 6 years and 7 months.

How do I connect to DataStage?

Open a command line or terminal and make a new directory in the DataStage system to store the SSL certificate and key files. In the Db2 console, download the SSL certificate from the Connect your applications to the database page. From the main menu, click Connect.

What is IIS DataStage?

IBM® InfoSphere® DataStage® is a data integration tool for designing, developing, and running jobs that move and transform data. InfoSphere DataStage is the data integration component of IBM InfoSphere Information Server.

How do you use the hierarchical stage in DataStage?


  1. Start the IBM® InfoSphere® DataStage® and QualityStage® Designer client.
  2. In the Repository pane, right-click the Jobs folder, and select New > Parallel job.
  3. Open the Real Time section of the palette, and drag one Hierarchical Data stage to the canvas.

Which ETL tool is easiest?

Here are the top ETL tools that could make users job easy with diverse features

  • Hevo Data. Hevo Data is an easy learning ETL tool which can be set in minutes.
  • Informatica PowerCenter.
  • IBM InfoSphere DataStage.
  • Talend.
  • Pentaho.
  • AWS Glue.
  • StreamSets.
  • Blendo.

How do I create an ODBC connection in DataStage?

DataStage – How to setup ODBC using with MS SQL database on Unix

  1. CD to $DSHOME. Make a copy of the file .odbc.ini. Edit . odbc.
  2. Go to the project , there is a file call uvodbc. config. Make a copy of the file then edit. Add the entry.
  3. Test odbc using DS_CONNECT defined for DataStage as follows:

Which are common services in DataStage?

The common services include: Scheduling services. These services plan and track activities such as logging, reporting, and suite component tasks such as data monitoring and trending. You can use the InfoSphere Information Server console and Web console to maintain the schedules.

What is DataStage ETL?

IBM InfoSphere DataStage is an ETL tool and part of the IBM Information Platforms Solutions suite and IBM InfoSphere. It uses a graphical notation to construct data integration solutions and is available in various versions such as the Server Edition, the Enterprise Edition, and the MVS Edition.