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

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Nativesql&Cognossql

Started by sreenu, 11 Aug 2010 03:06:27 AM

Previous topic - Next topic

sreenu

Hi friends,
let me know what is procedure or steps can connect to multiple datasoures at a time in report creation time in report studio?
and difference between native sal and cognos sql can elabrate it? ???

blom0344

From within RS you can only access one package. However the package may be published from a model that uses multiple database connections.

Native SQL can be used when you cannot establish what you need by using Cognos SQL. Cognos will however parse it just the same. By using native SQL you probably lose the ability to reuse the model on another type of RDBMS. When you keep everything in Cognos SQL it is more portable in that respect. I would in all case try to stay with Cognos SQL