cognos内容库如何从oracle转换成pg数据库

发布网友发布时间：2022-05-14 04:18

共1个回答

热心网友时间：2024-02-23 22:17

具体见下文，这里解释一下，当选择Oracle connection时SQL*Net connect string:中填写数据库名，另外userID和password必须填Normal的而非sysdba
If you are trying to reach oracle database server on a different machine, then you must install oracle client for 10g on cognos server and configure the listener and tnsnames.ora and test the connection through sql*net.
XE=1(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=dbs2. zpint.dom)(P
ORT21))(CONNECT_data＝(SERVER=DEDICATED)(SERVICE_ NAME=XE)))
Once you reach the database server successfully, your parameters to build an Oracle connection string will be;
SQL*Net connect string: XE
Collation sequence: Signon_____________________
User ID [Checkbox enabled]
Password [Checkbox enabled]
Create a signon that the Everyone group can use: {Default enabled}
User ID: Password: Confirm Password: