Defining an Oracle Autonomous Database Source Connection Using Object Storage

If you plan to import data from a file using the External Table feature in Oracle Autonomous Database, you must configure the Object Storage connection along with the database connection. You can configure the Object Storage connection as a Credential in the Oracle Database or defined in the EPM Connections. For details, see Managing Connections in Administering Planning .

If you want to browse the files in Object Storage using the file browser, you must specify the namespace and bucket in the System Settings and/or User Settings. For details, see System Settings and Setting User Level Profiles. If you specify the user settings, then the user settings takes preference over system settings.

To define an Oracle Autonomous Database source connection using object storage:

  1. On the Data Integration home page, from the Actions menu, click Setup and then click Applications.

  2. On the Applications page, click Image shows the Connect Configuration icon. (Configure Connections icon).

  3. On the Connections page, click Image shows the Add icon. (Add drop-down icon), select Oracle Autonomous DB.

  4. In Name, specify the name of the connection to the Oracle Autonomous DB.

    The name should not contain space or hyphens.

    The connection name will be used to store the wallet.

  5. In Description, specify a description of the connection to the Oracle Autonomous DB.

  6. In Wallet, click Image shows the Upload icon. to upload the wallet file for the autonomous database from Oracle Cloud Infrastructure. This is the wallet that you downloaded when connecting to Oracle Cloud Infrastructure.

    A wallet is a password-protected container that stores authentication and signing credentials, including private keys, certificates, and trusted certificates, all of which are used by SSL for strong authentication.

    This step assumes that you are connecting to an autonomous database instance that has already been created. For more information, see Connecting to the Oracle Cloud Infrastructure.

  7. In the DB Username, enter the Oracle Autonomous Database username.
  8. In DB Password, enter the Oracle Autonomous Database password. You must update this password anytime you change your Oracle Autonomous Database password.
  9. In DB Service Name, specify the database service/database instance on that server.
  10. In Object Storage Credentials, select one of the following:
    • Credential Name: Specify the Object Storage URL and the Object Storage Credential Name defined in the Oracle Autonomous Database.
    • Connection: Select the required Object Storage Connection defined in the Cloud EPM Connection and click Create Credential. The credentials are automatically created in the database.
  11. Click Test Connection.

    After the connection is successful, the "Connection to [source system name] successful" message is displayed.

  12. Click OK.
  13. After the object storage connection is established, on the Data Integration page, click Actions > File Browser. Select the object storage connection on the top-right drop down list. The data from the object storage bucket is displayed. Upload file directly into the required folder.