Connect from Denodo¶

If you do not have the Denodo subscription bundle Enterprise Plus you can also deploy the Denodo Embedded MPP and connect to it from Denodo, using a standard JDBC data source, not the Embedded MPP data source, but without benefiting from Denodo’s optimization capabilities.

You have to fill in all the required fields:

Name
Database adapter: PrestoDB
Driver class path: presto-0.1x
Driver class: com.facebook.presto.jdbc.PrestoDriver
Database URI: jdbc:presto://presto-denodo:8443/hive/default?SSL=true&protocols=http11
Login: presto
Password: pr3st% (or the custom one if specified in the deployment process: cluster.sh deploy)

Important

Requirements to connect from Denodo JDBC data source to Denodo Embedded MPP:

Note that if the certificate used by the Denodo Embedded MPP is signed by a private authority, or it is self-signed, you have to import the Denodo Embedded MPP certificate into the Denodo server truststore.

The certs/certificate.crt is distributed for testing purposes ONLY. This certificate accepts presto-denodo as the Denodo Embedded MPP hostname. In this case, you have to add an entry in the hosts file where the Denodo server is running, with presto-denodo and the IP that appears as the EXTERNAL-IP of the Presto service.