How to add remote data source in transformer.

[SMS636]

How can i use SQL Server as my datasource in transformer.
Transformer during the creation of .mdl model i am not getting a chance to specify OLEDB or ODBC data source .... What to do?

 

[GJParker]

You can either create your queries using Impromptu and save these as IQD files.

Or

Link your SQL Server tables through an Access database and use this as the datasource

Gary

Gary Parker
MIS Data Analyst
Manchester, England

 

[drlex]

At a pinch, if you lack Impromptu, you can write your own SQL in TextEdit/Notepad and use it as an IQD. You'll need to start it with

COGNOS QUERY
STRUCTURE,1,1
DATABASE,<name of database>

and make sure that your cognos.ini file has a reference for <name of database> to the ODBC/OLEDB connection like

<name of database>=;LOCAL;OD;DSN=<SQLserverDBname>@ASYNC=0@0/0@COLSEQ=

soi la, soi carré

 

[GJParker]

Like it drlex, Very cunning

Gary Parker
MIS Data Analyst
Manchester, England

 

[drlex]

You're too kind, Gary. Anything to avoid <shudder>Access</shudder>....

soi la, soi carré