Cognos connect to Excell using ODBC

1. Create excel file
2. Open control panel, administrative then Data Source ODBC
3. Open System DSN and click add button
4. Choose Microsoft Excel Driver then Finish
5. At ODBC Microsoft Excel Setup, give data source name and select workbook.

At this step, we already make ODBC connection to the data source. Now, we want to setup from cognos connection to use the data source.
6. From cognos administration, open configuration tab.
7. At data source connection click new
8. Give a name for data connection.
9. Choose ODBC for type.
10. Input ODBC data source name with the same name from step 5
11. Click test to make sure the connection has already setup.

This entry was posted in Cognos and tagged , , , , , , . Bookmark the permalink.

Leave a Reply

Your email address will not be published. Required fields are marked *

*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>