Connecting 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.

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.

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 (e.g., 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 (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, contact the UITS Enterprise Decision Support Services (EDSS) team.

This is document angi in the Knowledge Base.
Last modified on 2017-05-18 12:58:08.

  • Fill out this form to submit your issue to the UITS Support Center.
  • Please note that you must be affiliated with Indiana University to receive support.
  • All fields are required.

Please provide your IU email address. If you currently have a problem receiving email at your IU account, enter an alternate email address.

  • Fill out this form to submit your comment to the IU Knowledge Base.
  • If you are affiliated with Indiana University and need help with a computing problem, please use the I need help with a computing problem section above, or contact your campus Support Center.

Please provide your IU email address. If you currently have a problem receiving email at your IU account, enter an alternate email address.