This section outlines the tasks you perform to prepare the autonomous data warehouse to receive the data.

Description of the illustration nsawa_integrate_third-party_data_figure1.png

You must ensure that the warehouse receives the right data in the right format by completing these tasks:

• Identify the data sources.
• Connect to the warehouse.
• Create the schema.
• Create the tables.

1. Identify and enlist the data source tables, fields, and rows to extract from the third-party source systems.
2. Examine the various approaches to connect to the warehouse to perform the data definition language (DDL) or data manipulation language (DML) operations and use the approach that suits your requirements.
3. After you connect to the warehouse, create a schema or database to absorb the data. If data is coming from multiple sources, decide whether you want to create multiple schemas or databases for different third-party sources or one schema or database for all third-party sources. See Provisioning Autonomous Data Warehouse Cloud
4. Create destination tables to store data from the incoming third-party sources.
   See Connecting SQL Developer and Creating Tables.