Creating a Data Asset

• Console
• CLI
• API

• 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. Navigate to the workspace in which you want to create a data asset.

     For the steps to access a workspace, see Accessing a Workspace.

  2. On the workspace home page, click Data assets.
  3. On the Data assets page, click Create data asset.
     Data Integration displays the Select data asset type panel in which the data source types that you can select are organized in the following groups:

     • All: (Default) All the types of data sources that are supported.
     • RDBMS: The relational database type of data sources such as Oracle Database and Autonomous Data Warehouse.
     • File and Big Data: Data sources such as OCI Object Storage and HDFS.
     • Application: Application data sources such as Fusion Applications using BICC, Oracle Peoplesoft, and Generic REST.
     • Others: Influx DB.

     To search for a data source type, start typing the name in the search field.

  4. Click the icon of the data source type that you want to use to create the data asset.
     The Create data asset page appears with the selected data source type in the Type field.
  5. Enter a name and an optional description for the data asset.

     The identifier is a system-generated value based on the name. You can change the value, but after you create and save the data asset, you can't update the identifier.

  6. For the data source type that you selected, complete the property fields and the default connection fields as described in the following applicable page:
     • Object Storage Data Asset Properties
     • Oracle Database Data Asset Properties
     • Oracle Peoplesoft Data Asset Properties
     • Oracle Siebel Data Asset Properties
     • Oracle E-Business Suite Data Asset Properties
     • Autonomous Data Warehouse or Autonomous Transaction Processing Data Asset
     • Oracle Fusion Applications using Oracle Business Intelligence Cloud Connector (BICC)
     • Oracle Fusion Applications using Oracle Business Intelligence Publisher (BIP)
     • Amazon Aurora Data Asset Properties
     • Amazon RDS for SQL Server Data Asset Properties
     • Amazon Redshift Data Asset Properties
     • Amazon S3 Data Asset Properties
     • Generic REST Data Asset
     • HDFS Data Asset Properties
     • Hive Data Asset Properties
     • IBM DB2 Data Asset Properties
     • Influx DB Data Asset Properties
     • Microsoft Azure SQL Database Data Asset Properties
     • Microsoft Azure Synapse Analytics Data Asset Properties
     • Microsoft SQL Server Data Asset Properties
     • MySQL Data Asset Properties
     • MySQL HeatWave Data Asset Properties
     • MySQL on Amazon RDS Data Asset Properties
     • Oracle Database on Amazon RDS Data Asset Properties
     • PostgreSQL Data Asset Properties
     • Salesforce Data Asset Properties
     • Snowflake Data Asset Properties
  7. Click Create.

  After Data Integration creates the data asset, it displays the data asset details page where you can view the connections, schemas, and data entities. For more information, see Viewing the Details of a Data Asset.

  If applicable, you can create more connections for the data asset. A connection gives you access to more schemas and data entities that you can use in your data integration solutions. To add connections, see Creating a Connection.

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

  oci data-integration data-asset create [OPTIONS]

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

• Run the CreateDataAsset operation to create a data asset.