You can install ODAC (Oracle Data Access Components) to allow access to Oracle open database connectivity through Business Adapter Studio. Using XCopy ODAC packages also allows for connection to Oracle databases when beacon is running an Oracle discovery.
Connect to an Oracle data source through the Business Adapter Studio
- Install ODAC. Download the 32-bit version of the ODAC-Xcopy package, based on your current version of Oracle.
NOTE: If you are installing into an existing Xcopy home, uninstall the current Xcopy version before installing the new ODAC-Xcopy package.
- Open a command prompt as an administrator and navigate to the Oracle installation directory for the original install.
- Run uninstall.bat <COMPONENT_NAME> <ORACLE_HOME_PATH>.
- For example, where your existing Oracle Home directory is C:\oracle , run uninstall.bat all c:\oracle.
- Extract the contents of the new Xcopy zip file to c:\oraclesource.
- Open a command prompt as an administrator and navigate to the c:\oraclesource directory.
- Run the following command: install.bat OLEDB c:\oracle myhome true.
- Open File Explorer and right-click on This PC. Select Properties, then select Advanced system settings.
- In the System Properties window, select the Advanced tab then select Environment Variables...
- In User variables for Administrator select the Path variable then select Edit...
- Select New and add C:\oracle to your path environment variable. Select New again and C:\oracle\bin to your path environment variable. This will enable the Business Adapter Studio application to locate the ODBC drivers.
- You should now be able to connect to your Oracle database via Business Adapter Studio.
Learn More
For further information on testing the connection and connection strings, see How to check Oracle database connection from the Inventory
