Loading Data

Creating an Asset

When you are ready to bring data into your Data Store, you can create an Asset for each logical grouping of source data. It is recommended that you create one data asset per data source. This enables you to more easily keep track of the data using data source IDs in the Data Exchange.

To create an Asset:

  1. Navigate to the Asset details page.
  2. Click the Create Asset button.
  3. Provide the following details:
    • Display Name: Optionally provide a display name for your Asset. This is used as a user friendly option to better identify the Asset.
    • Schema: The schema object that is used in the database to store your Asset data.
    • Vault Id: An OCID, which links to an existing vault where you store your credentials.
    • Encryption Key Id: The encryption key to use to generate new credentials
  4. Select the Submit button.

A schema is created to import data into. Move on to the next section to learn how to connect to an Asset.

Connecting to an Asset

In the previous step you created an Asset and provided a schema. Connect to your Asset so that you can begin to import data.

To connect to an Asset:

  1. Download your wallet credentials from the Data Store screen using the instructions here: Connect to a Data Store.
  2. Open SQL developer and create a new Database connection.
  3. Assign the database connection a name such as Asset Connection
  4. From the Database Type, select Oracle.
  5. For Username, enter the value you used for Schema when you created your Asset in addition to the Data Store username (DEUSER[AssetName#ASSET])
  6. For Password, enter the password you retrieved from the vault secret when you created your Data Store. Remember you can always reset your password on the Data Store detail page using the ‘Reset Password’ action.
  7. For connection type, select Wallet.
  8. Select the Connect button.

If successful, you have an active connection to your Data Exchange Asset.

Loading Data into your Asset

Now that you have a successful connection to your Asset you may load source data into it in any fashion you choose. Oracle provides a list of examples here: Loading Data in Autonomous Database