Connecting to a data source in DataStage
You can connect to remote data sources with a flow connection, a project connection, or a platform connection.
You can connect to a remote data source in the following ways.
- Create a flow connection in DataStage®
- Create a connection asset in a project and then select the connection in DataStage
- Create a platform connection and then select the connection in DataStage
Create a flow connection in DataStage
Flow connections are specific to a DataStage flow.
Benefits:
- No need to create a separate connection. The connection properties are within the flow.
- You can parameterize all the connection properties. Parameterized properties make it easier to migrate the flow. For example, if you move from a development environment to a production environment, you need to change the only parameter values.
Steps:
- In DataStage, drag a connector to the canvas and double-click it.
- In the Stage tab under Properties, go to . The <Flow connection> option is selected by default.
- Enter the connection details, and then click Save. For guidance, see the information for the connection at Connectors. To parameterize a connection property, click the Parameterize icon {#}. For instructions, see Parameters and parameter sets.
The following connectors do NOT support the <Flow connection> option:
- IBM Cognos Analytics
- IBM Data Virtualization
- IBM® Data Virtualization Manager for z/OS®
- IBM Match 360
- Microsoft Azure Data Lake Storage
For information on migrating DataStage jobs with connections from traditional DataStage, see Enabling flow connections at Migrating connections in DataStage.
Create a connection asset in a project and then select the connection in DataStage
Benefit: You can share with the connection with other users in the project. The connection can be used with other tools or services in the project. (DataStage does not support connections that are created in a catalog. However, you can add a connection to a project from a catalog, and then DataStage can use the connection.)
Steps:
- In the project, go to .
- Select a connector and create the connection. For more information, see Adding connections to projects.
- Go to DataStage, expand
Connectors, and then add a connector to the canvas in one of the following ways:
- Drag the Asset browser to the canvas, and then select a connection. You can drill down to select specific data. The associated connector is added to the canvas.
- Drag a connector to the canvas and double-click it. Open its Stage tab. Go to and select the connection.
Watch this video series to see how to use some common connectors.
Create a platform connection and then select the connection in DataStage
A platform connection is a connection asset in the Platform assets catalog.
Benefit: You can share the connection across services and projects. The connection can be used in other tools and shared with multiple users.
Steps:
- Go to New connection. . Click
- Select a connector and create the connection. For more information, see Adding platform connections.
- Go to DataStage, expand Connectors, and then add a
connector to the canvas in one of the following ways:
- Drag the Asset browser to the canvas, and then select a connection. You can drill down to select specific data. The associated connector is added to the canvas.
- Drag a connector to the canvas and double-click it. Open its Stage tab. Go to and select the connection.