0 / 0
Connecting to a data source in DataStage

Connecting to a data source in DataStage

You can connect to remote data sources with a project connection or a platform connection.

You can connect to a remote data source in the following ways.

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:

  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.

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.
Generative AI search and answer
These answers are generated by a large language model in watsonx.ai based on content from the product documentation. Learn more