Data Assets

Oracle Cloud Infrastructure Data Integration supports a range of data source types, from databases to flat files, that you can use as sources and targets for your data integration tasks.

Data assets  represent the data sources that you want to use in Data Integration data flows, tasks, and pipelines. You create data assets from the Data assets page in a workspace. When you create a data asset, you specify one default connection to the data source. After creating a data asset, you can create additional connections as needed, edit a connection, view the data asset details, edit the data asset, and delete the data asset.

Before you start creating data assets for and connecting to the data sources that you need, use the following pages to learn about which ones are supported, and other considerations and support information:

• Types of data sources and their supported versions
• Supported object types
• Supported compression types
• Data types not supported
• Manage sensitive information for connecting to sources
• Read and write data with hierarchical data types
• Unicode standard in data and metadata
• Data type mappings
• Networking components in Oracle Cloud Infrastructure

When you're ready to create data assets, use the following pages for specific values that you need to enter:

• Creating a Data Asset
  • 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