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