Oracle Cloud Infrastructure Documentation

Set Up Table Import in the Repository File

Set up how to import the tables of an external application such as another Oracle Analytics Cloud instance into the repository file of Oracle Fusion Data Intelligence to enable merging of the external semantic model with the semantic model of Oracle Fusion Data Intelligence.

Ensure that your corporate virtual private network (VPN) allows connectivity to your autonomous data warehouse. You can use the transparent network substrate (TNS) entry of the low offering of your autonomous data warehouse to import the tables. For example, (description= (retry_count=20)(retry_delay=3)(address=(protocol=tcps)(port=<>)(host=<>))(connect_data=(service_name=<>))(security=(ssl_server_cert_dn="CN=my domain.com,OU=my organization,O=organization,L=my location,ST=my state,C=my country")))

The table import process creates the tables in a separate physical schema called OAX_USER. After you have imported the tables and tested, revert the settings back to the old state.

Note

Ensure that you don't remove the externalize connection setting in the connection pool when you upload the repository file back into Oracle Fusion Data Intelligence.
  1. In Oracle Fusion Data Intelligence Console, click Semantic Model Extensions under Application Administration.
  2. On the Semantic Model Extensions page, in the External Application region, click Actions, and then click Export Semantic Model Template to download the template semantic model.
  3. Sign in to the Model Administration Tool that's a part of the Oracle Analytics Client Tools.
  4. In the Model Administration Tool, open the downloaded semantic model, navigate to Oracle_Data_Warehouse, and edit Oracle_Data_Warehouse_Connection_Pool.
  5. Provide the TNS entry of your autonomous data warehouse and enter the username and password of the OAX_USER credentials.
  6. Save your changes to the connection pool.