The Sybase IQ 15 data access driver is automatically installed with the application. For
other databases, you may need to install the JDBC data access driver for your database
middleware, before using Query with SQL.
Follow these general steps to obtain a data access driver:
- Download the data access driver (a .jar file) from the
database vendor site, and copy the file to a local folder.
- Register the driver path by selecting the driver in the application.
- Select a Query with SQL data source on the SQL
Drivers tab in the application preferences.
You can select
an installed SQL driver or install the required driver.
- Select .
The
Driver Installation page lists database middleware names
and the status of drivers:
- When the status check mark is green, the driver is correctly installed
and you can start using Query with SQL.
- When the status check mark is red, the driver is not installed for that
middleware and you must install it.
- When the status check mark is yellow, a compatible driver is available
for the middleware, but the application must be restarted before it is
available. Once the software has restarted, you can use Query with
SQL.
- Choose a data source, and perform one of the following actions:
| Option |
Description |
| If the data source middleware has a green check mark |
Select Next, enter the middleware connection
information, and select Create. The data
access drive is installed. You do not need to perform the remaining
steps in this task.
|
| If the data source middleware has a yellow check mark |
Restart the application, and repeat step 1. |
| If the data source middleware has a red check mark |
Go to step 3. |
- If the middleware driver is not configured, select the Install
button, choose the database driver, and select Install
Drivers at the top of the database list.
- In the selection box for locally available middleware:
| Option |
Description |
| If the correct .jar file is listed |
Go to step 6. |
| If the correct .jar file is not listed |
Download the driver from the vendor support site, install the
driver, select Cancel to close the driver
selection box, and then download and install the correct
.jar file. |
You must access the web page that lists JDBC data access drivers for the middleware
vendor. Depending on the database, different types of driver files are
available; usually a compressed file containing the drivers or an executable
file to install the drivers automatically. For the application, download only
the compressed file.
- On your vendor's support web site, download the compressed JDBC driver file (for example, a
.tar, .gz, or
.zip file) for your database middleware version.
- On your computer, select the folder that contains the extracted JDBC driver files for your
database middleware.
A complete list of supported JDBC drivers is included in the Product
Availability Matrix, available on the SAP Service Marketplace site at
https://support.sap.com/pam
.
- Restart the application.
The list of available database middleware drivers is
updated.
When you use Query with SQL to create a new document in the application, the target
database middleware is listed with a green check mark, indicating that the driver is
available to access the database.