Resolution:
If the Clarify adapter is not connecting with the Clarify database, kindly ensure the below checkpoints in order to ensure the Design Time adapter connectivity -

1. During the installation of the Clarify Adapter, ensure that you provide the correct path to the CBO Jars, CBO libraries, Database Client home and the SQL Driver Installation path/Oracle TNS Admin path.

CBO Jars Path - These JAR files is available in the ClarifyClient/lib folder structure.

CBO Libraries - These libraries are present in the Clarify Client Home.

2. After the correct installation, configure the adapter to the required database

3. If you have selected SQL Database, ensure that you have the latest available SQL JDBC client library.

4. If you have selected the Oracle Database, ensure that you provide the SID in the field 'database name'.

5. Ensure the JDBC URL is correctly generated, even though it is an uneditable field -

For SQL -

jdbc:sqlserver://&ltDBHostName>:&ltPort>databaseName=&ltdbName>

For Oracle -

jdbc:oracle:thin:@&ltDBHostName>:&ltPort>:&ltSID>

Note:- By default, the adapter displays databaseName instead of the SID. This is incorrect.

Why does the TIBCO Adapter (TM) for Clarify fail to connect with the Clarify database?