Set up how to import the metadata 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.
Perform this one-time setup while installing the Model Administration Tool. Ensure that you redo this setup if you plan to install a new version of the Model Administration Tool. See Download and Install Oracle Analytics ClientTools to download the tool.
- Sign in to the Oracle Cloud Infrastructure Console, download the wallet for your autonomous data warehouse, and unzip the wallet to a folder on your local machine.
- Place the
cwallet.sso file into a specific folder on the local machine where you have installed the Model Administration Tool.
- Place the
sqlnet.ora file and replace (if existing) the file in the $OBIEE12c\domains\bi\config\fmwconfig\bienv\core location where you have installed the Model Administration Tool.
- Navigate to
$OBIEE12c\domains\bi\config\fmwconfig\bienv\core and edit the sqlnet.ora file to point the WALLET_LOCATION variable to the folder which has the cwallet.sso file that you had previously downloaded. Ensure that the location points to the folder that has the wallet file. For example, WALLET_LOCATION = (SOURCE = (METHOD = file) (METHOD_DATA = (DIRECTORY="D:\test")))SSL_SERVER_DN_MATCH=yes.
- Save your changes to the
sqlnet.ora file.