How can Infosistema DMM move data stored in separate DB catalogs?

In some OutSystems installation scenarios, the database catalog where entity information is placed is not the same one where OutSystems meta information is.

In these situations, Infosistema DMM needs to discover where the entity physical table is in order to produce its execution plan and commands.

The proper way to do it is looking into the OutSystems metamodel and that’s exactly what Infosistema DMM does.

After getting a pointer to the entity and respective eSpace in the OSSYS_ENTITY and OSSYS_ESPACE tables, the DBCatalog_Id column in the OSSYS_ESPACE table will have an FK to the OSSYS_DBCATALOG table.

In environments that use more than one catalog this table will tell us the name of the other catalog that should be used as a prefix in all subsequent queries or commands against the pretended entity.

5 Ways Infosistema DMM Can Pacify Your Organization DPO