Oracle Cloud Infrastructure Documentation

Creating a Connection

When you create a data asset in Data Integration, you provide the details for the default connection. If needed, you can add more connections to an existing data asset of any type except OCI Object Storage.

  • Note

    Support for using passwords will be deprecated soon. We recommend that you use the OCI Vault option. For information, see OCI Vault Secrets and Oracle Wallets.
    1. On the Data assets page, select the name of the data asset that you want to work in. If you need help finding the Data assets page, see Listing Data Assets.
    2. In the Connections section of the data asset details page, select Add connection.

      You cannot add connections to an OCI Object Storage data asset because only one connection is allowed.

    3. In the Add connection panel, complete the fields as needed to create the connection. For information about the fields, see the applicable page for the data asset at Data Assets.

      Select the Make this the default connection checkbox if you want this connection to be the default connection for the data asset.

    4. (Optional) After you complete the required fields, select Test connection to ensure that a connection can be established.

      A success or failure message appears to indicate the result of the test. A successful test isn't required to add the connection.

    5. Select Save connection.

      If applicable, select Continue to continue using a password.

      A notification appears informing you that the connection is saved successfully.

  • Use the oci data-integration connection create command and required parameters to create a connection:

    oci data-integration connection create [OPTIONS]

    For a complete list of flags and variable options for CLI commands, see the Command Line Reference.

  • Run the CreateConnection operation to create a connection.