How to connect to cognos with oracle database

Step 1. Create new databasource

Give this details

connection name : test

SID : database name
servername : localhost
PORT : 1521


Define userid and password by checking signon check box.

Click next

Define descriptor like

(DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = oracledb)
    )
  )


Click text connection.