How to Connect an OEMM Model with Data from More Than One Store? (Doc ID 3009823.1)

Last updated on MARCH 12, 2024

Applies to:

Goal

How to connect an Oracle Enterprise Metadata Management (OEMM) Model with data from more than one store?

OEMM cannot use dynamic SQL statements. This is a workaround for dynamically created SQL statements. Therefore the DML statements are stored in a text file and it is imported with the Import Bridge “Oracle Database SQL DML (DI/ETL) Script (PL/SQL)”.

In some cases the source and the target objects of a DML statements are in different schemas stored in different OEMM-Models. In such cases, how can the Model with the dynamically created DML statements be connected to more than one Model (Store) to display the full data lineage over all Models of the entire configuration?

The option to create a Model where all impacted schemas are included and connect the DML model with this combined store is known, but for this use case not an option, because the schemas used are too large to store them together and the it is desired to reuse the separated models by schemas in different Configurations.
 

Solution