Is it possible creating Bo report from 2 diff.databases?

building reports desktopintelligence
1

Hi

this is s.chand.

i need to create single BO report(BO6.5 full client) from two different databaes.that is SQL Server and Sybase.Is it possible to create universe by using these two databases.if not by using storedporcedures is it possible to create report ?please intimate in how many ways we can resolve this?Please reply since this is very urgent requirement.

S.chandb :india: (BOB member since 2007-07-11)

2

HI, S.Chand.

Metadata Interlayer (Universe) works with only one DB connection at a time.

Therefore your solution can be as follows (as I know, maybe there is some another alternative way):
Precondition: Create two connections (one appropriate connection for one appropriate DB).

  1. Create one universe based on the first DB data using the first DB connection.
  2. Create another one universe based on the second DB data using the second DB connection.
  3. After all metadata is prepared in Designer module, create report based on two universes.

Albert Pikin :ru: (BOB member since 2008-09-22)

3

ok…it is possible when we have common coumns with same data type.i.e linking the two different dataproviders.

i need one more clarification. shall we link these two universes?(remember they are from sybase and sql server).if this is case how we can link two hetrogenious universes?pls give me the process how we can achieve it?Please advice…

S.chandb :india: (BOB member since 2007-07-11)

4

Please do not cross-post. It leads to fragmented discussions and is against our forum rules.

Your other post with the same question is here:

So please continue in the discussion only there.

This topic is now closed.

Marek Chladny :slovakia: (BOB member since 2003-11-27)