Before You Connect

To connect to Oracle, you must first update the appropriate environment variable. This variable must contain a folder location that includes the Oracle OCI Library assemblies, which are shipped alongside the add-in.

The correct environment variable depends upon your platform:

• Windows: The native libraries should be on your PATH. Note that the VC++ 2017 Redistributable package is required to load the OCI libraries.
• Mac: The native libraries should be on your DYLIB_LIBRARY_PATH.
• Linux: The native libraries should be on your LD_LIBRARY_PATH.

These native libraries can be found in the lib folder inside the installation directory of the add-in.

The NativeFolder property specifies the path to the directory that contains the native DLLs. By default, the add-in uses the system’s standard library-loading policy. You can specify either a full or relative path. On Windows and macOS, setting this property is a viable alternative to setting up environment variables.