Connecting to a data source 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 in Watson™ Knowledge Catalog.)

Steps:

1. In the project, go to Assets > New asset > Data access tools > Connection.
2. Select a connector and create the connection. For more information, see Adding connections to projects.
3. 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 Properties > Connection > View connection and select the connection.

Create a platform connection and then select the connection in DataStage

A platform connection is a connection asset in the Platform assets catalog. (DataStage does not support connections in Watson Knowledge 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:

1. Go to Data > Platform connections. Click New connection.
2. Select a connector and create the connection. For more information, see Adding platform connections.
3. 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 Properties > Connection > View connection and select the connection.