Reference an entity in a different database

Posts   
 
    
CL
User
Posts: 1
Joined: 03-Mar-2017
# Posted on: 03-Mar-2017 17:19:17   

I currently have a stored procedure that references a table in another database. Is there a way of doing this using LLBLgen objects?

daelmo avatar
daelmo
Support Team
Posts: 8245
Joined: 28-Nov-2005
# Posted on: 04-Mar-2017 05:35:28   

Hi CL,

You could either:

a) Add those two databases (catalogs) in your LLBLGen Designer and map tables to entities from those two databases.

b) Use a DBLink (or something similar depending on the DB) to create a virtual table in your DB that references the table in the other database. Then in LLBLGen Designer obtain both the normal tables as the special (dblink) one.

David Elizondo | LLBLGen Support Team