2schemas on the same server in one universe

building reports webintelligence
1

Hi -

Can i work with 2schemas/databases on the same server in the same universe with a single connection.
Thanks,

ks.reddy (BOB member since 2007-01-18)

2

Hi,

Which database do you use?

Are both schemas (tables in those schemas) accessible by a DB user that is defined in the universe connection? If yes, then there should be no problems.

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

3

two schemas inside a same database is possible. but not possible in different databases.

sprajkumar :india: (BOB member since 2005-12-09)

4

we are using mysql, with same permissions but not able to access both the schema tables with one connection.

ks.reddy (BOB member since 2007-01-18)

5

Did you ever get anywhere with this? I am facing a similar issue.
The same userid can connect to multiple databases on the one server and see all the tables, but I am unable to get it to work with a single connection.
With SQL server this works just fine, the table browser lists all the databases that you have permissions for and then expands into which schema you can see finally down to the tables. I’m assuming this is to do with the BO/MySQL interface rather than anything else. If I connect using something else I can write queries which join tables across databases without a problem.
I’ve had a look at the prm files etc which I would have thought would define it but I can’t see anything that jumps out at me.

ken.gaul :uk: (BOB member since 2002-06-18)