It's all about the answers!

Ask a question

Getting Rational Insight Excel Integration to work

Johannes Kaufmann (1111) | asked Nov 09 '12, 10:12 a.m.

I'm trying to integrate a MS Excel worksheet as a data source for Rational Insight.

I am following this tutorial: and am stuck at validating the ODBC-Data Source in the Cognos Framework Manager. Testing the connection results in the status "failed".
I tried using a .csv / the MS Access text ODBC-driver, but arrive at the same result.

Does anyone have an idea for a possible error source or solution?


One answer

permanent link
Benjamin Silverman (4.1k610) | answered Nov 09 '12, 7:35 p.m.
Hi Johannes,

The data source should be added to the 32-bit ODBC Administrator tool (C:\Windows\Syswow64\odbcad32.exe) if you're on a 64-bit system.  In order to access the data source from Framework Manager, you need to define an ODBC data source from within Cognos first.  Perhaps you added the data source to the 64-bit ODBC Administrator rather than the 32-bit tool?

Your answer

Register or to post your answer.