5.9 Create an Oracle Object Storage Connection
You can use Data Transforms to upload data from Oracle Object Storage to Autonomous Database.
The OCI Object Storage dedicated endpoints feature allows OCI customers to securely access the storage buckets. See Object Storage Dedicated Endpoints for more information. You need to use the new URL format when you create Object Storage connections in Data Transforms. For users that already have an Object Storage connection, the existing URL is automatically updated to the new URL format.
To create an Oracle Object Storage connection you need to have an Oracle Cloud Infrastructure username and an auth token. See Getting an Auth Token for information about how to generate the auth token. You need to specify these details when you define the connection in Oracle Data Transforms.
Note the following:
- To use an Oracle Object Storage connection to import data into Data Transforms, you must use a public IP address to access the compute node. If you want to use a private IP address to access the Object Storage service, make sure that you have access to the Internet.
- The supported file format for loading data from Oracle Object Storage to Autonomous Database and vice versa is CSV.
- The supported data types are Numeric, Double, String, and Date.
- Data load is not supported for Oracle Object Storage connections.
To define an Oracle Object Storage connection,
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.
Parent topic: Connections