Is it possible to have two catalogs in the one data access layer at all reason I am asking is someone created two tables in two different oracle databases and cause of reporting I am not allowed to move them. I was wondering how do I retireve entites from two different databases is this possible under one layer

You can map entities from more than one catalog into the same LLBLgen Project. You'd have to select these different catalogs when you connect to the database or when you are refreshing the catalog.

how is this achevied can you walk me through it and also. my oracle dba does not use primary keys or auot increments what would my best way of fetching the information

sorry I am actually talking about two different services not two catalogs is this possible or do i have create a dal for each server

my oracle dba does not use primary keys or auot increments what would my best way of fetching the information

You can manually define PKs in LLBLGen Designer.

sorry I am actually talking about two different services not two catalogs is this possible or do i have create a dal for each server

Using catalogs from 2 different servers in the same project is not currently supported.