I am trying to build an IQD file called "test.iqd" that I can pass to Transformer to allow me direct access to a SQL server database w/out having to go through Impromptu, Architect or Framework Manager.
Below is the code I am using:
COGNOS QUERY
STRUCTURE,1,1
DATABASE,Test_Source
DATASOURCENAME,E:\test.iqd
BEGIN SQL
{select Policy_Base
from dbo.Policy}
END SQL
COLUMN,0,Policy_Base
I set up my Cognos.ini file w/ the following:
[Databases]
GOS=;LOCAL;OD;DSN=GOScer4@ASYNC=0@0/0
GOV=;LOCAL;OD;DSN=GOVcer4@ASYNC=0@0/0
GODW=;LOCAL;OD;DSN=GODWcer4@ASYNC=0@0/0
GOMR=;LOCAL;OD;DSN=GOMRcer4@ASYNC=0@0/0
I71_DBASE_NTV_PP71_SAMPLE=;LOCAL;DB;C:\Program Files\Cognos\cer4\samples\PowerPlay\database@OEM
GREAT OUTDOORS=;LOCAL;OD;DSN=GREAT OUTDOORS@ASYNC=0@0/0
Test_Source=^User ID:^?Password:;LOCAL;OD;DSN=Test_Source;UID=%s;PWD=%s@ASYNC=0@0/0@COLSEQ=
I also created an ODBC definition called "Test_Source".
The error message I am getting is as follows:
(TR0118) Transformer can't read the database [Test_Source] defined in E:\test.iqd.
I have read the posts on this subject but I seem to be missing something. Any help would be greatly appreciated.
Thanks.
The only thing I can think of is you may need to qualify your table name, so for example:
select Policy_Base
from somedatabase.dbo.Policy
where "somedatabase" is the name of your database instance.