Connecting to PowerBI¶
Before you begin¶
In order to connect to Okera's Presto endpoint via PowerBI you will need the following:
- Presto ODBC Driver
- Okera's Presto Host/Port
- Your authentication credentials (depending on what your cluster is setup to authenticate with this could be LDAP or JWT)
Download the Presto ODBC driver¶
You will need to download a Presto ODBC driver in order to connect to PowerBI. You can download a free version from Tableau by selecting "Presto" and then "Windows" from Tableau's drivers page. Download the last option on the page for Tableau Desktop and Server. Alternatively you can also purchase Simba's Presto ODBC Driver.
Setting up the DSN (Data Source Name)¶
The next step in configuring the Presto ODBC driver is setting up the DSN.
Open up the ODBC Data Sources App (odbcad64.exe) on Windows
Navigate to System DSN tab and press Add.
Select the Simba Presto ODBC Driver.
Input something for Data Source Name and Description.
For Authentication Type choose LDAP.
Enter your username and password. Your password will either be your LDAP credentials, or your token (depending on how your Okera cluster is configured). If token, you can grab your token by clicking on user profile icon in the bottom left corner.
The Host and Port corresponds to Okera's Presto endpoint
port(the default is 14050). You can find this in the Okera UI by clicking on the
Systemtab. Click the System Icon in the left navigation menu to view the endpoint.
For Catalog enter
- SSL configuration: If your ODAS cluster uses an SSL certificate from a trusted Certificate Authority, you only need to make sure SSL is checked. If you have a self-signed certificate, you’ll need to configure the Simba driver to accept self-signed certs.
Connecting in PowerBI¶
In PowerBI press Get Data, and click More…
Navigate to Other and select ODBC
Select the "Simba Presto" DSN (or whatever name you input above). Optionally, specify a query. Otherwise hit OK and select the datasets to load.
When specifying a query, do not include a semicolon at the end.