Edit Connections and Upload Semantic Model

Sometimes you must reconfigure the database connection information that's saved inside your source semantic model .rpd file before you migrate to the new Oracle Analytics Cloud on Oracle Cloud Infrastructure. For example, if you moved your data from Oracle Cloud Infrastructure Classic to Oracle Cloud Infrastructure, this is required because the connect string for the new database is different. If you do need to edit the source semantic model, you must upload the updated semantic model on the target before you migrate the rest of your content.

Note:

These instructions only apply if you currently use Model Administration Tool for Oracle Analytics Cloud to manage semantic models. If you use Semantic Modeler, you edit database connections through Console in your target environment.

1. Determine the connection string for the new database on Oracle Cloud Infrastructure.
2. If you haven’t done so already, download and install the latest Model Administration Tool for Oracle Analytics Cloud from:

   http://www.oracle.com/technetwork/middleware/oac/downloads/oac-tools-4392272.html

   For instructions, see Download and Install Oracle Analytics Client Tools.

3. Locate the final snapshot of your source environment (BAR file) that you downloaded to your local system.

   You must know the password you entered when you downloaded the snapshot. You'll be asked to provide the password later.

4. Run the expandarchive command to expand the BAR file and navigate to the semantic model .rpd file.
   1. At a command window, set the DOMAIN_HOME variable.
      For example: C:\> set DOMAIN_HOME=<CLIENT_TOOL_INSTALL_HOME>\domains\bi
      Where CLIENT_TOOL_INSTALL_HOME is the directory where you installed the client tools.
   2. Navigate to the required scripts directory:
      For example: C:\> cd <INSTALL_HOME>\bi\modules\oracle.bi.metadatalcm\scripts>ls
   3. Run the expandarchive command to expand the BAR file.

      Use the format:

      expandarchive.cmd  <BAR file location> <expand archive directory> [encryptionpassword=<password>]

      For example:

      C:\TOOLS\Oracle\bi\modules\oracle.bi.metadatalcm\scripts>expandarchive.cmd C:\Downloads\Migrate.bar C:\OCIMigration encryptionpassword=secret123

   4. Navigate to the expand archive directory and locate the semantic model file.
      A semantic model file named default.rpd is located under datamodel\rpd\default.rpd.
5. Use the latest Model Administration Tool to open default.rpd.
   The password required to open default.rpd is the password you entered to download the snapshot.
6. Navigate to the Physical Layer pane, select the database connection you want to edit, and open the Connection Pool dialog.
7. Edit the connection details In Data Source Name, to specify the new database on Oracle Cloud Infrastructure.
8. Save the changes to default.rpd.
9. Copy the updated semantic model file (default.rpd) back to the BAR file.
10. Upload the updated semantic model file (default.rpd) to the target Oracle Analytics Cloud instance.
    Navigate to the Console, click Snapshots, click the Page menu, and then click Replace Data Model.