Merge Your External Applications

If you have an external semantic model from standalone Oracle Analytics Cloud, Oracle Analytics Server, or Oracle Business Intelligence Enterprise Edition, you can merge it with the semantic model of Oracle Fusion Data Intelligence only in your non-production instance.

You can also merge your existing catalogs in the external Oracle Analytics Cloud with those in the Oracle Analytics Cloud instance associated with your Oracle Fusion Data Intelligence instance. Both external semantic model and semantic model extensions can co-exist and you can include the external semantic model in your semantic model extensions. On the Publish Model page, select "Yes" if you want the external semantic model to be included.

Merging external semantic models may require you to scale up your Oracle Analytics Cloud compute resources to ensure better performance. In particular, if you're merging a semantic model that was in use on a live Oracle Analytics Cloud instance, then Oracle recommends scaling up Oracle Fusion Data Intelligence's Oracle Analytics Cloud compute resources by the same number of CPUs as the instance the semantic model is merged from.

To successfully merge an external semantic model, you must complete these tasks in the sequence they are listed:
  1. Create a custom database schema in the Oracle Autonomous Data Warehouse associated with your Oracle Fusion Data Intelligence instance.
  2. Migrate or create database objects such as tables, views, and synonyms in the new schema.
  3. Grant semantic model access to the database objects.
  4. Configure Oracle Analytics Client Tools (Oracle BI Administration Tool).
  5. Export the semantic model template.
  6. Bring in the custom database objects into the physical layer of the semantic model template by either importing, or merging, or copying and pasting.
  7. Prepare your external applications to ensure they work without interruption.
  8. Model the custom semantic model objects.
  9. Merge the external semantic model with the semantic model of your Oracle Fusion Data Intelligence instance.
  10. Validate the results.
  11. Bundle the merged semantic model to your production instance.