This section provides you with an overview of the steps required to install and set-up the driver. After completing this procedure, you will be able to begin accessing data with your application.

To begin accessing data with the driver:

  1. Install the driver:
    1. After downloading the product, unzip the installer files to a temporary directory.
    2. From the installer directory, run the appropriate installer file to start the installer.
      • Windows: PROGRESS_DATADIRECT_JDBC_INSTALL.exe
      • Non-Windows: PROGRESS_DATADIRECT_JDBC_INSTALL.jar
    3. Follow the prompts to complete installation.

    The installer program supports multiple installation methods, including command-line and silent installations. For detailed instructions, refer to the Progress DataDirect for JDBC Drivers Installation Guide.

  2. Set your system CLASSPATH to include the driver .jar file. The CLASSPATH is the search string your Java Virtual Machine (JVM) uses to locate JDBC drivers on your computer. The following examples demonstrate setting the CLASSPATH from a command line using the default installation directory.

    • Windows Example

      CLASSPATH=.;C:\Program Files\Progress\DataDirect\JDBC\lib\60\denodo.jar

    • UNIX/LINUX Example

      CLASSPATH=.:/opt/Progress/DataDirect/JDBC/lib/60/denodo.jar
  3. Configure your driver using one of the following methods:

    • Connection URL: You can begin using the driver immediately by passing a connection URL with your application or tool. The following example shows how to connect using the user ID/password authentication.

      jdbc:datadirect:denodo://myserver:9996;
DatabaseName=mydb;User=jsmith;Password=secret;
      Note: The User and Password properties are not required to be stored in the connection string. They can also be passed separately by the application.
      Note: See Authentication for details.
    • Data sources: The driver also supports connecting using JDBC data sources. A JDBC data source is a Java object, specifically a DataSource object, that defines connection information required for a JDBC driver to connect to the database. See Connecting using data sources for more information.
    Note: For most connections, specifying the minimum required connection properties is sufficient to begin accessing data; however, you can provide values for optional properties to use additional supported features and improve performance.
  4. Set the values for any optional properties that you want to configure. For additional information on optional features and functionality, see the following resources:
    • Connection URL examples provides connection string examples that can be used to configure common functionality and features. You can modify and combine these examples to create a string that best suites your environment.
    • Connection property descriptions provides a complete list of supported properties by functionality.
    • Performance considerations describes connection properties that affect performance, along with recommended settings.
  5. Connect to your service and begin accessing data with your applications, BI tools, database tools, and more. To help you get started, the following resources guide you through accessing data with some common tools:
    • Tableau: Tableau is a business intelligence software program that allows you to easily create reports and visualized representations of your data.
    • DbVisualizer: DB Visualizer is a database tool that allows you to connect and execute SQL statements against your data.
    • Interactive SQL for JDBC (JDBCISQL): JDBCISQL is a command line interface that allows you to connect to a data source, execute SQL statements and retrieve results for display on a terminal.
    • DataDirect Test: DataDirect Test allows you to test connect, execute SQL statements, and practice using the JDBC API right out of the box.

This completes the deployment of the driver.