DataStage connectors

Connectors for remote data sources

For connectors for remote data sources, you need to create a project connection asset for the associated DataStage connector before you can load data to or read from it in DataStage. A connection contains the information necessary to connect to the data source.

1. To create the connection asset or the "optimized" connection asset: From the project page, click Add to project > Connection. For more information, see Adding connections to projects.
2. Open DataStage and add the associated connector to the canvas. Go to Properties > Connection. Double-click the connector node on the canvas to open its Details card.
3. Select the connection from the Details card. Open the Stage tab, and go to Properties > Connection, and select the connection.

   Optional: The connectors are listed on the DataStage palette so that you can build your flow and add the connection asset later.

The "(optimized)" version of a connection gives you increased performance and more features such as before and after SQL statements, and sparse lookup and rejects links. However, you cannot use the "(optimized)" connection with other tools. You can use the connections that are available to other tools (for example, Salesforce.com), if you already created the connection, and you want to reuse it in DataStage.

Data sources are also available from the ODBC connection, which is also optimized for DataStage. Select the ODBC connection in the Add connection page, and then select a data source in the Create connection page.

Use the Generic JDBC connection to connect to a data source that has no connector defined for Cloud Pak for Data.

Other types of connector components

These entries in the palette do not require that you create a connection asset in the project.