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.

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>