Oracle ODBC Driver Setup - CADWorx - Installation & Upgrade

CADWorx Structure Installation Guide

PPMProduct
CADWorx
PPMCategory_custom
Installation & Upgrade
Version_CAESAR
12
Version_CADWorx
20.0 (2020)
Version_CADWorxStructure
2020(4.0)

The following instructions and screen captures describe how to setup the data source name (DSN) for Oracle databases.

  1. Start the ODBC Administrator from the Control Panel to setup the Oracle ODBC Driver. Please make certain you are running the latest version of the ODBC Administrator and ODBC Drivers To check the version, go to the About Tab. The latest version of ODBC can be found on the Microsoft Web Site.

  2. Hit the Add button, and select Oracle ODBC Driver. The name "Oracle in OraDb11g_home1" may be different on your system. 

  3. In the next dialog, type in the following:

    • For CADWorx P&ID:
      Data Source Name: P&ID_ORACLE
      Service Name: CWORA11g
      The Data Source Name must be P&ID_ORACLE. The service name can be whatever you selected for the database name.

    • For CADWorx Plant:
      Data Source Name: PLANT_ORACLE
      Service Name: CWORA11g
      The Data Source Name has to be PLANT_ORACLE. The service name can be whatever you selected for the database name.

    • For CADWorx IP:
      Data Source Name: IP_ORACLE
      Service Name: CWORA11g
      The Data Source Name has to be IP_ORACLE. The service name can be whatever you selected for the database name.

  4. After the DSN is created, test the DSN by pressing the "Test Connection" button.