nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Using multiple database in one datasource

RRK

Hi, 
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.
 
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.
 
But when I use query against second database "PQR" then the query fails as it doesnt connect to it. 
Is this syntax wrong : jdbc:xyz//abc.co.xy/DATABASE=LMN,PQR ?
 
LMN and PQR : database names
 
Attached images are from connection profile which ultimately I will use in datasources. 
BIRT desginer used is : 4.4.0
Thanks in advance!!!!!

Find more posts tagged with

Comments

micajblock

Unless your database specifically supports such a URL (which I doubt) this is not a valid URL. Using multiple databases in a single query will depend on your database and JDBC implementation. Some databases support connecting to one database and then you can reference the second database in the query itself.

RRK

Thanks Mica...