The following is a guide to getting oracle working as a Database Source in Integrify. You will need remote desktop access to the application server that Integrify is installed on and an account with administrative privileges. Note that a reboot of the server may be necessary during setup.
- Remote desktop into the application server
- Open up an administrative command prompt (right click "command prompt" and select Run as Administrator)
- Change directory to the location the integrify application is installed. The default would be C:\integrify\app\webserver
- run the following command:
npm install oracledb
- Download the free 64-bit Instant Client Basic ZIP file from Oracle Technology Network. (The 32-bit Instant Client is here).
Add its directory to
PATH. For example on Windows 7, update
PATHin Control Panel -> System -> Advanced System Settings -> Advanced -> Environment Variables -> System variables ->
PATHand add your path, such as
If you have multiple versions of Oracle libraries installed, make sure the desired version occurs first in the path before you run Node.js.
- Optionally create the default Oracle Client configuration directory
If you intend to co-locate optional Oracle configuration files such as
oraaccess.xmlwith Instant Client, they can be put in a
C:\oracle\instantclient_12_2\network\adminsubdirectory. Create this if needed.
This is the default Oracle configuration directory for applications linked with this Instant Client.
Alternatively, if you use Oracle client configuration files, they can be put in another, accessible directory. Then set the environment variable
TNS_ADMINto that directory name.
- Install the Visual Studio Redistributables
PATHvariable needs to include the appropriate VS Redistributable:
- Oracle client 12.2 requires the Visual Studio 2013 Redistributable.
- Oracle client 12.1 requires the Visual Studio 2010 Redistributable.
- Oracle client 11.2 requires the Visual Studio 2005 Redistributable.
You can also find out the version required by locating the library
dumpbin /dependents oci.dll
If you see
MSVCR120.dllthen you need the VS 2013 Redistributable. If you see
MSVCR100.dllthen you need the VS 2010 Redistributable. If you see
MSVCR80.dllthen you need the VS 2005 Redistributable.
Configure a Database Source
- From your workstation, log into Integrify as normal with an account having Administrator rights to Integrify.
- Select System Settings > Database Sources from the left navigation menu.
- Click "Add Connection" in the top menu
- Enter the details of the connection. Name and description can be entered at your discretion.
- The server field can be configured in one of two ways. If you are utilizing a tnsnames.ora file, you can use an entry from that file, or you can use the following format:
<databaservername or ip>\<Database Name>
- Username and password are self explanatory
- Use Oracle as the provider
- Click 'Save'
You should now be able to use the Database Connection in the DB tab for questions that support it as wells as DB realated task types.
There are some troubleshooting steps here if you run into issues: https://oracle.github.io/node-oracledb/INSTALL.html#-6-troubleshooting-node-oracledb-installation-problems