Showing results for 
Show  only  | Search instead for 
Did you mean: 

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 

  1. 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.

  2. Open a command prompt as an administrator and navigate to the Oracle installation directory for the original install. 
  3. 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.
  4. Extract the contents of the new Xcopy zip file to c:\oraclesource.
  5. Open a command prompt as an administrator and navigate to the c:\oraclesource directory. 
  6. Run the following command: install.bat OLEDB c:\oracle myhome true. 
  7. Open File Explorer and right-click on This PC. Select Properties, then select Advanced system settings.

advanced system settings.png

  1.  In the System Properties window, select the Advanced tab then select Environment Variables...

system properties.png

  1. In User variables for Administrator select the Path variable then select Edit...




















  1. 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.  
















  1. You should now be able to connect to your Oracle database via Business Adapter Studio.  

data link properties oracle.png

Learn More
For further information on testing the connection and connection strings, see How to check Oracle database connection from the Inventory

Was this article helpful? Yes No
No ratings
Level 10


What about on non windows Operating system?

By Community Manager Community Manager
Community Manager

@durgeshsingh - the Business Adapter Studio only runs on Windows. You do not need to install ODAC on any non-Windows computers in order to use it with the Business Adapter Studio.

Level 10

You mean, ODAC-X shall be install on beacon & then it can be use.

Version history
Last update:
‎Jul 20, 2023 12:54 PM
Updated by: