If you are unable to create a new account, please email support@bspsoftware.com

Author Topic: Connection Name (not DataSource name)  (Read 1462 times)

Offline ej

  • Full Member
  • ***
  • Join Date: Oct 2008
  • Posts: 8
  • Forum Citizenship: +0/-1
Connection Name (not DataSource name)
« on: 07 Apr 2016 09:13:13 am »
We are on Cognos 10.2

My goal is for a report to be able to run against either a SQL Server Database or an Oracle Database (btw, table structures are identical).  There is a data field in the package which contains the name of the database that the report is being run against.  Currently, that field is set up in Framework Manager using a SQL Server pass-thru SQL query.  Of course, that query will not work when run against an Oracle database as it contains a specific to SQL Server function. 

I want to, based on the connection (not the data source), have Framework Manager run one or the other query.  I don't know if this is possible.  First I can't find any parameter or means of obtaining the connection name and second, I don't know if one can conditionally run SQL statements within Framework Manager.

Has anyone been able to do this?
Thanks,
EJ