This section describes the generic steps to create a connection. The displayed connection detail options may vary depending on the selected connection type.

Apart from the connection types listed in Supported Connection Types you can create custom connectors, which you can use to connect Data Transforms to any JDBC supported data sources. See Create Custom Connectors.

To create a new connection:

1. From the left pane of the Home page, click the Connections tab.

   Connections page appears.

2. Click Create Connection.

   The Create Connection page slides in.

3. Do one of the following:
   • In the Select Type field, enter the name or part of the name of the connection type.
   • Select the type of connection that you wish to create.
     • Databases - Allows you to configure any connection type for supported database types.
     • Applications - Allows you to configure any connection type for supported applications.
     • Services - Allows you to configure any connection type for supported services.
4. After selecting the required connection type, click Next.

   The Connection Name field is pre-populated with a default name. You can edit this value.

5. For Connection Details, provide the connection details for the selected type such as:
   • Connection -
     • JDBC URL - The URL to connect to the data server. For example:
       jdbc:weblogic:sqlserver://hostname:port[;property=value[;...]]

       Note:

       If you are accessing Data Transforms from an Autonomous Database on a public endpoint, then the allowed port numbers are 2484, 1521-1525, 1708, 3306, 80.

       For connectors that use an autoREST driver that provides the model files along with the driver, specify the servername and other properties required to connect to that datasource. For example:

       jdbc:weblogic:autorest://servername;[property=value[;...]]

     • User - The user name, if required, for connecting to the server.
     • Password - The password for connecting to server.
   • Advanced Options
     • Array Fetch Size - When reading large volumes of data from a data server, Oracle Data Transforms fetches successive batches of records. This value is the number of rows (records read) requested by Oracle Data Transforms on each communication with the data server.
     • Batch Update Size - When writing large volumes of data into a data server, Oracle Data Transforms pushes successive batches of records. This value is the number of rows (records written) in a single Oracle Data Transforms INSERT command.

       Note:

       Set Batch Update Size to 1000 or less for loading tables with BLOB data type columns.
     • Degree of Parallelism for Target - This value indicates the number of threads allowed for a loading task. The default value is 1. The maximum number of threads allowed is 99.

     Note:

     Connection details are specific and the above options vary based on the selected connection type. For the default connection that is created during provisioning, only the User and Password fields are editable. All the other fields are disabled.
6. After providing all the required connection details, click Test Connection to test the connection.
   If the test connection fails, do one of the following:

   • Check whether the Autonomous Database from where you are accessing Data Transforms is configured to use a private endpoint.

     See Enable Access to Private Data Sources from Autonomous Database for more information.

     See Enable Access to Private Data Sources from Autonomous Database for more information.

   • If a connection between Autonomous Databases on a Private Endpoint fails with a "Mismatch with server cert DN" error, check whether you have specified the ssl_server_dn_match=yes property in the JDBC URL. See Troubleshoot Mismatch with Server Cert DN Error for more information.
7. Click Create.

   The new connection is created.

The newly created connections are displayed in the Connections page.

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

• Select Edit to edit the provided connection details.
• Select Test Connection to test the created connection.
• Click Export to export the connection. See Export Objects.
• Select Delete Schema to delete schemas.
• Select Delete Connection to delete the created connection.

You can also search for the required connection to know its details based on the following filters:

• Name of the connection.
• Technology associated with the created connection.

Topics