Oleh: denysutani | November 6, 2010

Cognos connect to Greenplum

Well, this article will be written both English and Indonesia because I can not find how to connect Cognos to Greenplum documentation. Hope this will help someone who need it.

This is step by step how to connect Cognos to Greenplum
1. Download ODBC driver for Greenplum from
http://web.datadirect.com/products/odbc/greenplum/index.html
2. From Control Panel->Administrative Tools->Data Sources(ODBC), create System DSN Greenplum, and then fill Data Source Name, Host Name, Port Number and Database Name. Click test connect button to test the connection.
3. From Cognos Administration, create a new data source with ODBC type. Give ODBC data source name with the same name you created at step 2.

Berikut merupakan langkah-langkah yang dibutuhkan untuk melakukan koneksi dari Cognos ke Greenplum.

1. Download ODBC driver dari http://web.datadirect.com/products/odbc/greenplum/index.html
2. Dari Control Panel->Administrative Tools->Data Sources(ODBC), buat System DSN bernama Greenplum, kemudian isi Data Source Name, Host Name, Port Number dan Database Name. Kemudian klik test connect untuk melakukan uji coba koneksi.
3. Kemudian dari Cognos Administration, create new data source dengan type ODBC. Pada ODBC data source beri nama sesuai dengan yang kita buat di System DSN di langkah ke 2.

Semoga bermanfaat


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: