Connecting to Oracle
- Install the Oracle OLEDB driver on the BiG EVAL Server.
- Download the Oracle Data Access Components (ODAC) for Windows from the oracle website. At the time of writing, the following URL could be used for that: https://www.oracle.com/database/technologies/dotnet-odacdeploy-downloads.html
- Use the 64bit edition because BiG EVAL is a 64bit application.
- Use the version that fits to your databases version number.
- The ODAC package contains many different drivers and applications. BiG EVAL only uses the Oracle OLEDB driver.
- Install the OLEDB driver by following Oracles instructions.
- Download the Oracle Data Access Components (ODAC) for Windows from the oracle website. At the time of writing, the following URL could be used for that: https://www.oracle.com/database/technologies/dotnet-odacdeploy-downloads.html
- Create the datasource in BiG EVAL.
- Open the navigation menu “Environemtn” > “Datasources”.
- Create a new datasource and give it a name.
- Choose “OLEDB” as the type of the datasource.
- Use the following connectionstring and ensure that the placeholders are replaced correctly.
Provider=OraOLEDB.Oracle;Data Source=[MyServername];User Id=[MyUsername]; Password=[MyPassword]; - Choose “Oracle (PL/SQL)” as the dialect.
- Save the datasource.
- Open the navigation menu “Environemtn” > “Datasources”.