Applies to: Kyvos Reporting

Upoad New Database Driver

If the provider you are looking for is not listed in the Provider dropdown and you have its library files, click Upload Driver button (under the Actions menu next to Help icon) to add respective driver files (if not added already). Select the Others option in Provider. In this case you will also have to specify Driver Class Name and Connection String.

To add a driver, perform the following steps.

1. Click Upload Driver button to open the Upload Driver dialog box.

2. In Name entry box, specify the driver file name along with the path or simply browse the driver file.

3. Click Upload.

4. The file will be updated and success message will appear.  Failure message will appear in case driver could not be uploaded.

5. Click Close button to close the dialog box.

Connect using Oracle client installed on Windows

• Kyvos Reporting recommends Oracle JDBC THIN connections for smooth and compatible access to Oracle Databases of various versions – 8, 9, 10, 11g or 12c.

• Kyvos Reporting also supports OCI_TNS (Oracle Call Interface Net Service Names) for those who want to use their Oracle client installations to connect to Oracle databases.

• If Oracle client is not installed on report server machine, then Kyvos Reporting chooses to use ojdbc14.jar, for THIN connections.

• If the report server machine has Oracle client installed, then Kyvos Reporting chooses to use classes12.zip, assuming that client is compatible with the server version being connected to.

• Kyvos Reporting allows Administrator to decide which driver Kyvos Reporting should use by following the below mentioned steps.

Steps to make changes in Report Engine loader batch file.

1. Open the file from path<install dir>\ReportEngine\bin\run.bat

2. Add the highlighted line to the file:@echo offset JRE_HOME=….jreset ORACLE_DRIVER=..libojdbc14.jarset PATH=”.”;%JRE_HOME%bin;%JRE_HOME%lib;%JRE_HOME%binserver;%PATH%SET INTELLICA_CLASSPATH=FOR %%i in (“..lib*.jar”) DO CALL includelib %%i notIncludeIEngineFOR %%i in (“..lib*.ZIP”) DO CALL includelib %%i notIncludeIEngineiEngine –oracledriver%ORACLE_DRIVER%%INTELLICA_CLASSPATH% “../config/ReportEngine.properties” -Xms20M -Xmx128MIn the batch file, a variable is being set to the name & path of the oracle driver we wish Kyvos Reporting to use.set ORACLE_DRIVER=..libojdbc14.jar

3. Change the iEngine calling line to pass the variable.iEngine -oracledriver%ORACLE_DRIVER%%INTELLICA_CLASSPATH% “../config/ReportEngine.properties” -Xms20M -Xmx128MThe above example forces Kyvos Reporting to use ojdbc14.jar driver for Oracle connections.