Can I link two universe- Teradata but different servers

building semantic layer
1

Experts,

Can I link 2 universes both are teradata but different servers. I am using BO XI 3.1 (SP2)? If there is no direct way, please advice if is there any workaound.

Thanks,
kris

BOKris (BOB member since 2003-08-27)

2

Currently in XIR3, you can only have one database connection per universe, so to answer your question, No unforunately you can’t.

However you do have a couple of solutions.

  1. A report itself can have many different queries and each query can connect to a different universe, so you can create two universes, one for each of your database sources and then link the result together in the report.
  2. You can use Business Objects Data Federator to merge your two datasourece into a single datasource and then build a single universe over that.
  3. You can wait until XIR4 comes out. Designer has been modified to include Data Federator, so no more single database connection in a universe.

My guess is that at the moment, the most cost effective option for you is option 1. But it depends on your budget and when you need to get this done.

plessiusa :netherlands: (BOB member since 2004-03-22)

3

Hi BOKris,

Some other options, although plessiusa has given you good ones. You could use Data Integrator/Data Services if you have these ETL tools to bring these two data sources together (maybe Data Federator will incorporate all of this soon?). The way it works now is you just access one database created through Data Services/Data Integrator from Universe Designer or Crystal that has the combined data.

So it looks like your options are:

  1. use Webi to link your Universes for this report

  2. Use Data Services/Data Integrator to merge it all into one source (I am not familiar with Data Federator being accessible for the typical client so anyone please correct me if I am wrong)

  3. Sounds like there is something going on with merging ETL ideas with Universe ideas as plessiusa says, so that is a good thing. Only problem is we don’t know when that will happen.

So I would normally say you need to utilize an ETL solution like #2 above. However you need to consider the changes occurring in the market and with SAP/BO and apply them to your short term and long term decisions.

Thanks!

Bobber :us: (BOB member since 2009-08-28)