Combining SQL Server & Oracle Results for a report

building reports desktopintelligence
1

I know with Business Objects you should be able to design a report that combines elements from different data sources.

The situation: we have a SQL Server Database and an Oracle Database. We need to design a report that
will show all the accounts on the SQL Server Database that do not exist in the Oracle Billing System. It is a report that will run nightly, so we really wanted to try and design this in BO so that we could utilize DocAgent.

I know I can’t link the universes together. I have tried to create a .rep file that contains one report from SQL Server and one report from Oracle. When I try to create the third report using data from my rep file, it will only allow me to choose data from one or the other, but not both.

I’m sure I’m just missing one connection or checkbox. Any help or suggestions anyone could give me on this is greatly appreciated!

Thanks,

Jennifer LaTulippe
jlatulip@powertel.com

Listserv Archives (BOB member since 2002-06-25)

2

It sounds like you need to link the datasets. To do so, choose View from the Data menu. Then expand one of your queries and select the column that relates to the other query and then select the Definition tab. On the Definition tab, click the Link button and you will be prompted to select a column from the other data provider to link to. Repeat this process if you need to link on more than one field. Once done linking, you can insert tables based on data from the existing document and all data will be available to you.

Hope that helps,

Donald May
E-mail: maydp@pweh.com

Listserv Archives (BOB member since 2002-06-25)