7.2 Import Data Entities

The easiest and most common way to create a Data Entity is by importing its structure from the connection type (for example, Oracle database).

To import existing Data Entities:

1. From the left pane of the Home page, click the Data Entities tab.

   Data Entities page appears.

2. Click Import Data Entities, to import the existing data entities.

   Import Data Entities page slides-in.

3. Select the Connection followed by Schema and then finally select the Type of Objects you want to import. For Oracle Object Storage connections, the Schema drop-down lists the name of the bucket that you specified in the URL when you created the connection.
4. [For Oracle Business Intelligence Cloud Connector (BICC) connections only] From the Offerings to import for collection, choose the offerings whose data stores you want to import. You must select at least one offering to import the BICC public view objects (PVO).

   Note:

   The import of BICC PVOs can take a long time depending on the number of selected objects. To improve performance, Oracle recommends that you use a mask to filter and limit the number of PVOs that you want to import.
5. Choose a Mask/filter if you don't want to import every object in the schema.

   Depending on the Connection Type, you will be presented with further options for importing.

   Note:

   For Oracle Object Storage connections, this value is case-sensitive. If Batch similar files is set to True, all the files that match the mask and have the same structure are grouped together into a single data entity.
6. [For Oracle Financials Cloud connections only] From the list in the Resources section, select the items that you want to import. When the import process completes, a table is created for each selected resource.
7. [For REST server connections only] In the Resources section, do the following:
   • In the Resource URI field, enter the URL of the REST service you want to import resources from.
   • Click the + icon.
   • In the Name column enter an identifier for the resource.
   • In the Operation URI column enter the URI of the resource.
   • Click Test Resource to check whether the entries are valid.
8. Click Start.

   A Job is created and the corresponding Job ID is displayed for you to track the session. Click the Job ID to view the details of the job.

   Upon successful execution of the job, all the selected Data Entities are imported. Click the Refresh icon present at the right corner of the Data Entities page, to see the new imported Data Entities.