Bring in Custom Database Objects
You can bring in custom database objects into the physical layer of the semantic model template using the Import, Merge, or Copy and Paste methods.
Import Custom Database Objects
Import the custom database objects or merge your semantic model metadata into the physical layer of the semantic model template.
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 as an example, RPD_MERGE_USER. The RPD_MERGE_USER schema is temporary; after you've imported the tables and tested, you must revert the settings back to the old state.
Note:
Ensure that you revert the prebuilt connections to the original settings before uploading. Don't add any additional connections to the external semantic model.- In Oracle Fusion Data Intelligence Console, click Semantic Model Extensions under Application Administration.
- 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 if you haven't done it previously.
- Sign in to the Model Administration Tool that's a part of the Oracle Analytics Client Tools.
- In the Model Administration Tool, open the downloaded semantic model, navigate to Oracle_Data_Warehouse, and edit Oracle_Data_Warehouse_Connection_Pool.
- Provide the TNS entry of your autonomous data warehouse and enter the username and password of the custom schema; for example credentials of RPD_MERGE_USER.
- Save your changes to the connection pool.