Oleh: denysutani | Juli 19, 2010

Cognos Connect to Oracle

We now trying to connect Cognos with Oracle

1. Open Cognos Administration and configuration tab. At left panel, click data source connection
2. Click new data source button
3. Give source name. We can give additional information if needed.
4. Choose Oracle for type. Click next
5. Fill SQL*Net connect string with database name. We can see this in tnsnames.ora

TEST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
(CONNECT_DATA =
(SID = TEST)
(SERVER = DEDICATED)
)
)

Create new user for Cognos in Oracle because if we use SYS there will be an error. Fill username and password.
6. Click test connection and then click test
7. If it works it will show like the picture below.
null
8. Click close twice until back to window at step 5. Click next.
9. Click finish.

——————————————————————————————————-

1. Buka Cognos Administration dan masuk ke tab Configuration. Di bagian panel kiri atas, klik data source connection
2. Klik new data source
3. Beri nama pada bagian name. Jika ingin memberi info lebih detail bisa isi informasi di bagian description dan screen tip. Klik next
4. Pada type, pilih Oracle. Klik Next
5. Pada SQL*Net connect string isi dengan nama database. Bisa dilihat di tnsnames.ora

TEST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
(CONNECT_DATA =
(SID = TEST)
(SERVER = DEDICATED)
)
)

Buat user baru di Oracle, karena jika menggunakan SYS akan muncul error. Pada bagian bawah isi username dan password yang dibuat tadi.
6. Klik test connection, kemudian klik test.
7. Jika koneksi berhasil maka akan muncul gambar seperti di bawah.
null
8. Klik close 2 kali hingga kembali ke layar pada langkah no 5. Klik next.
9. Klik finish.


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: