Define a new data source

To connect Integration Composer to a data source, you define a data source connection that specifies how to connect to the data source.

About this task

Integration Composer uses JDBC drivers or an application programming interface (API) to establish connection to data sources. You can specify data source connection parameters when defining a data source or when defining a data schema.

After you define data source connection parameters, Integration Composer stores the connection information and displays those parameters when you attempt to connect to the data source. The only parameter that Integration Composer requests is the password.

If you connect to a data source in an Integration Composer session, the connection is kept open throughout the session, unless you complete either of these steps:

Close the connection by using Data Source > Close Data Source Connection.
Delete the open data source.

Before you create a mapping, you must define a data source for both the source data and the target data.

When you define a data source, you perform these tasks:

Select a data schema to associate with the data source.
Name the data source.
Specify the parameters for connecting to the data source.
If using Arabic or Hebrew, specify bidirectional layout formats to use for the database.

Procedure

Start Integration Composer and choose Define New Data Source. The Data Schema page contains data schemas delivered with Integration Composer, together with custom data schemas that you create in the application.
Select a data schema, then click Next.
In the Data Source field, type a name for the data source and click Next. The data source name must have at least two characters and is case-sensitive.
In the Connection Method field of the Connection Information page, select a connection method and enter the appropriate parameters.
Optional: If you install Integration Composer in Arabic or Hebrew and want to define bidirectional layout formats for the database that you are connecting to, click Bidi Layout Format.
Optional: To test the connection to the data source, click Test Connection. You test the connection only, without starting any additional Integration Composer processes. JDBC drivers that are not JDBC 2.0 compliant might not support this feature.
On the Connection Information page, click Finish and, in the confirmation dialog box, click OK.

Feedback