Creating a Data Asset
Create a data asset in a Data Integration workspace.
To create the data asset, select the data source type, provide the property details of the data source, and specify the default connection to use to connect to the source.
We recommend that you use a secret in Oracle Cloud Infrastructure (OCI) Vault to store the connection password. For information, see OCI Vault Secrets and Oracle Wallets. In particular, consider the following requirements when using OCI Vault secrets:
- Ensure that you have set up the required policies for using OCI Vault and secrets.
- Create a secret for the password.
- If you use an Oracle wallet, you must modify the wallet zip file before creating a secret for the wallet contents, as described in OCI Vault Secrets and Oracle Wallets. You also need a secret for the wallet password and a secret for the database password.
If you publish tasks to an application in OCI Data Flow, consider the following requirements when creating your data assets:
- OCI Vault secrets are required for passing credentials securely across OCI services. Use secrets in OCI Vault to store the login credentials for connecting to the data sources.
- OCI Data Flow doesn't allow connections through host IP addresses. Specify the fully qualified domain name (FQDN) for the database hosts.
For more information about what's supported and what to consider when connecting to data sources, see Considerations and Support Information
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.
Navigate to the workspace in which you want to create a data asset.
For the steps to access a workspace, see Accessing a Workspace.
- On the workspace home page, click Data assets.
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.
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.
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.
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
- 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.
- Navigate to the workspace in which you want to create a data asset.
Run the CreateDataAsset operation to create a data asset.