Import External Entities - Different DBs

Gonçalo Almeida

Question

Hi all,

I need to import 2 external entities that will be consumed by an espace (Platform 9.0).
These entities are beeing synched from an external Database with the outsystems database (SQL Server), so they exist inside the outsystems database. So I simply imported them in Integration Studio.

Problem: In our Production environment, the main catalog is split from the apps catalog, and these 2 entities are inside the apps catalog. So, the extension works in DEV but not in PRD. I decided to create in Service Center, a Database Connection to use with that extension, thus overcoming that problem. Well.....no.....because when the extension is created and the entities imported, they have the physical name of the database like this:

Database.dbo.entity

So, cross environments, it forces the database to have the same name...and....you guessed it, it doesn't.
How can I use this same extension, cross environments?
I've attached the extension.

regards

Drive_ExternalEntities.xif

07 Jul 2015

Gonçalo Almeida

Well,

Apparently I found the solution. All I had to do was delete the database name that Integration Studio put there.
So, here is the final extension, that works in all environments.

Drive_ExternalEntities.xif

08 Jul 2015

Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.

See the full guidelines