Installing data access drivers

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.

  • You must be familiar with your database and with the SQL language.
  • The correct data access driver must be installed for your database middleware. A data access driver is the software provided by a database vendor that allows a client application to connect to middleware and to access data in a database. You copy the data access driver for your middleware from your database vendor support web site to a local folder, and then you can select the driver in the application and connect to the database.
    Note Installing data access drivers from a vendor site can be problematic due to the variety of driver versions and file formats. If you are unfamiliar with your database version or the vendor web site, contact your database administrator.
Follow these general steps to obtain a data access driver:
  1. Download the data access driver (a .jar file) from the database vendor site, and copy the file to a local folder.
  2. Register the driver path by selecting the driver in the application.
  3. 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.

  1. Select Start of the navigation path File Next navigation step Preferences Next navigation step SQL Drivers End of the navigation path.
    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.
  2. 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.
  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.
  4. 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.
  5. 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.
  6. 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/pamInformation published on SAP site.
  7. 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.