5.3 Create Custom Connectors

APPLIES TO: Data Transforms that is available as a separate listing on Marketplace called Data Integrator: Web Edition.

The Custom Connections page of the Administration tab of Oracle Data Transforms helps you to create custom connectors that point to any JDBC supported data sources.

The custom connectors will be listed in the Create Connection page where you can use them to connect data sources to Data Transforms. See Work with Connections for more information.

To create a new connector:

1. In the left pane, click Administration.

   A warning message appears.

2. Click Continue.
3. In the left pane, click Custom Connections.

   Custom Connections screen appears.

4. Click Create Connection Type.

   The Create Connection Type page appears.

5. From the Category drop-down select the type of connection that you wish to create whether database, application, or service.
6. Enter a name for the connection.
7. Enter the name of the JDBC Driver of the source connection. For example, oracle.jdbc.OracleDriver.

   Note:

   For connectors that require driver installation, you need to copy the jar files to the /u01/oracle/transforms_home/userlibs directory before you add the connection.
8. Click OK.

The newly created custom connection appears in the list and are available in the Create Connection page.

Click the Actions icon () next to the selected connection to perform the following operations:

• Select Edit, to edit the provided connection details.
• Click Export to export the connection. See Export Objects.
• Select Delete, to delete the created connection.

  Note:

  You cannot delete custom connectors that have existing connections.