Connecting External Applications to EzPresto via JDBC

Describes how to connect external applications and BI tools, such as Tableau and PowerBI, to EzPresto through the EzPresto JDBC endpoint.

Connecting applications to EzPresto provides users with the convenience of using their preferred applications and the ability to leverage the high performance SQL query engine to quickly build out powerful executive charts and dashboards from massive amounts of data.

You can connect external applications to EzPresto using the JDBC connection URL or code.

Getting the JDBC Endpoint

You can get the JDBC endpoint in Unified Analytics by going to Administration > Settings in the left navigation bar. The JDBC Endpoint is displayed on the Configurations tab.

JDBC Connection URL

Use the following URL to connect EzPresto to external applications, replacing the domain with your Unified Analytics cluster domain:
jdbc:presto://ezpresto.<unified-analytics-cluster-domain>:443

JDBC Connection Code

To programmatically connect external applications to EzPresto, use the following code and enter values specific to your Unified Analytics cluster domain and user: 
String url = "jdbc:presto://ezpresto.unified-analytics-cluster-domain:443";
Properties properties = new Properties();
properties.setProperty("user", "ua-user");
properties.setProperty("password", "ua-user-password");
properties.setProperty("SSL", "true");
Connection connection = DriverManager.getConnection(url, properties);

Tableau Connection Example

The following example shows you how to connect Tableau to EzPresto:
Server : ezpresto.<unified-analytics-cluster-domain-name>
Port : 443
Catalog : <catalog-from-presto to which user wants to connect>
Authentication : LDAP
Username : <ua-user-name>
Password: <ua-user-password>
Require SSL : true
NOTE
The Tableau connector does not support SSO. The username and password are required