Connect to Denodo through JDBC

Denodo is a data virtualization and data integration platform in use at Indiana University. Denodo can connect to many different kinds of data sources and then combine, aggregate, or join and filter these data sources and present the results in multiple formats.

Note:
Denodo is a highly available enterprise service that is only interrupted for maintenance on the third Sunday of each month, 5-6am. If Denodo requires a longer maintenance window, it will be advertised in advance.

Applications can connect to Denodo via JDBC using either the native Denodo driver or a Postgres driver:

  • Denodo driver: For the best performance, connect to Denodo using the Denodo JDBC Client driver. This driver is bundled with a VDB client installation, and is located in <Denodo Installation Folder>/tools/client-drivers/jdbc/denodo-vdp-jdbcdriver.jar.

    Following are example strings for connecting to a virtual database on IU's Denodo DEV, STG, and PRD environments when using the Denodo driver; replace vdb_name with the appropriate VDB name:

    DEV: jdbc:vdb://ebidvt-dev.uits.iu.edu:9999/vdb_name
    STG: jdbc:vdb://ebidvt-stg.uits.iu.edu:9999/vdb_name
    PRD: jdbc:vdb://ebidvt.uits.iu.edu:9999/vdb_name
  • Postgres driver: Alternatively, you can connect directly to Denodo using an out-of-the-box PostgreSQL JDBC driver. JDBC drivers can be used by Java applications or in database tools (for example, AquaData). These drivers are available from the PostgreSQL open source project and the IU Maven repository. (The PostgreSQL driver does not support internal Denodo functions or VQL, but allows robust connection pooling.)

    Following are example strings for connecting to a virtual database on IU's Denodo DEV, STG, and PRD environments when using the Postgres driver; replace vdb_name with the appropriate VDB name:

    DEV: jdbc:postgresql://ebidvt-dev.uits.iu.edu:9995/vdb_name?ssl=true
    STG: jdbc:postgresql://ebidvt-stg.uits.iu.edu:9995/vdb_name?ssl=true
    PRD: jdbc:postgresql://ebidvt.uits.iu.edu:9995/vdb_name?ssl=true

If you need help with Denodo at IU, or have questions, fill out the EDSD Support Form .

This is document angi in the Knowledge Base.
Last modified on 2024-01-17 14:14:44.