How can I use existing entities/cubes available on database_A in database_B?

Previous Member

Hello community!

 

I would like to use our databases as efficient as possible.  Data in Board database_A are loaded into entities.  I need exact the same data in Board database_B.  Extracting and loading the ASCII-extract is an option, but I would like to avoid this as it creates too much duplication and processing.

 

On a Microsoft SQL Server you would "Link" the other server to use its tables and queries.

 

How can I use existing entities/cubes available on database_A in database_B?  

 

Best regards,

Steven

Helmut Heimann

Hi Steven Van Aken,

 

there are two options--one: (as you've already mentioned) is to export/import the data.

The second possibility would be to use a ROLAP for the cube data and an SQL table containing all entity data you wish to use in both BOARD databases.

You'd have to load the entity/cube data only once (into the SQL database) and afterward could distribute it to both BOARD databases (entity data by DataReaders, cube data available via ROLAP).

Maybe even Datamarts could offer some options for you.

 

Kind Regards,

Helmut