USER MANUALS

Connect from Denodo

To establish a connection from Denodo to the Denodo Embedded MPP you have to create a JDBC data source and 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.

Kubernetes Services status

Kubernetes services status

Ping External IP

Ping External IP

hosts file

hosts file

Presto data source in Denodo

Presto data source in Denodo

Once the data source is configured, click on Create base View to explore the Presto schemas with their tables and their columns.

Presto tables in Denodo

Presto tables in Denodo

You can now run any query you want on your datasets.

Query results in Denodo

Query results in Denodo

Add feedback