We have a requirement to connect CA to a SQL database dataserver connection.
Our SQL datawarehouse uses schema based multitenancy. 

How is it possible for our end clients to connect to the same instance of CA and use the same reports and folders but have the reports only connect and display data from their particulcar SQL schema.



------------------------------
Jonathan berry
------------------------------

#CognosAnalyticswithWatson

Hi Jonathan,

One way you can do it is to leave the Database name blank and add something  like this into the connection parameters. This example will replace DATABASE with your user name.

DATABASE=#toupper($account.defaultName)#

I don't know what you would use but I'd suggest testing with FM to see what specific parameter and/or macro is right for you. 

Another potential solution could be using Command Blocks.

------------------------------
TREVOR COMEAU
------------------------------

You can also add macros to the datasources in Framework Manager if you are using published models.

------------------------------
TREVOR COMEAU
------------------------------