Discussions
Categories
Choose a Product
THRUST SERVICES
CORE APPS
CE PRODUCTS
...
Quick Links
POPULAR
HELPFUL TIPS
Groups
My Links
FOR SIGNED IN MEMBERS:
Back to website
Home
Designing Analytics Reports
Using multiple database in one datasource
Migrateduser
<p>Hi,<br>
I have attached two images from which 'One_DB.jpg' show connectivity with one database which works fine when I use query in data set.</p>
<p> </p>
<p>But in my second attached image 'two_DB.jpg' I tried to use two database in one datasource, so that I can use both databases in my query at data set level.</p>
<p> </p>
<p>But when I use query against second database "PQR" then the query fails as it doesnt connect to it.<br>
Is this syntax wrong : jdbc:xyz//abc.co.xy/DATABASE=LMN,PQR ?</p>
<p> </p>
<p>LMN and PQR : database names</p>
<p> </p>
<p>Attached images are from connection profile which ultimately I will use in datasources.<br>
BIRT desginer used is : 4.4.0</p>
<p>Thanks in advance!!!!!</p>
Find more posts tagged with
Comments
There are no comments yet