Oleh: denysutani | Juli 18, 2010

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.


Tinggalkan Balasan

Isikan data di bawah atau klik salah satu ikon untuk log in:

Logo WordPress.com

You are commenting using your WordPress.com account. Logout / Ubah )

Gambar Twitter

You are commenting using your Twitter account. Logout / Ubah )

Foto Facebook

You are commenting using your Facebook account. Logout / Ubah )

Foto Google+

You are commenting using your Google+ account. Logout / Ubah )

Connecting to %s

Kategori

%d blogger menyukai ini: