Sybase open client connectivity

[Former Member]

Hi,

I am developing a universe in XIR3.1 and using Sybase ASE.

Our requirement is to connect to multiple databases of one Sybase ASE server in a single universe.

The connection we have created is Sybase Open Client with one database.

When we try to insert table from different databases, instead of showing the tables that belong to that particular database ,it shows tables of the database which we have used to create connection earlier.

Under all different databases it shows the same tables of the database which I have used creating the connection earlier.

However the similar scenario works fine in XIR2. We have tested it successfully.

How to resolve this issue.

Thanks in advance!

[former_member447840 · Accepted solution]

Hi Pratul,

If your users are assigned to specific schemas then you may set up Connection Overrides. These are first set up by using a the CMC and then Universe Designer.

So... in the CMC you have say 3 groups, each of these must have your distinct users.

Then create 3 seperate connections for each of the 3 database sources.

Open up Universe Designer and use the security override screen by selecting a specific group to use a specific connection.

~Joe Szabo