Create a Presto connection

To access your data stored in Presto-configured databases, you will need to know the server name that you want to connect to. If LDAP authentication is required, you must also have access credentials. Once you have created a Presto connection, you can select data from the available databases and tables and then load that data into your app or document. If you select multiple databases, data will be loaded from all of them at the same time.

In Qlik Sense, you connect to Presto through the Add data dialog or the Data load editor.

In QlikView you connect to Presto through the Edit Script dialog.

Setting up the database properties

Database property Description Required
Host name The IP address or host name of the Presto server. yes
Port Port number for the Presto server. yes
Catalog (Project) The name of a database available to the Presto server. Specifying a database preselects it for the data selection step, but additional databases can be selected during the data selection process. no

Authentication

Qlik Sense: Presto authentication options

Property Description
Authentication Type Use no authentication or LDAP authentication.
Username User name for the Presto connection when using LDAP authentication.
Password Password for the Presto connection when using LDAP authentication.
Name

Name of the Presto connection.

The default name will be used if you do not enter a name.

QlikView: Presto authentication properties

Property Description
Authentication Type Use no authentication or LDAP authentication.
Username User name for the Presto connection when using LDAP authentication.
Password Password for the Presto connection when using LDAP authentication.

Setting SSL options

Property Description
Enable SSL Require SSL authentication on the connection the Presto server.
Use System Trust Store Use the SSL certificate located in the standard system location used for storing trusted certificates. This property can be selected only when SSL is enabled.
Full path of Trusted Certificates The full path to the SSL certificate if it is not stored in the standard system location. This property can be selected only when SSL is enabled.
Allow Self-signed Server Certificate Accept an SSL certificate from the server that is self-signed and not verified by a trusted authority. This property can be selected only when SSL is enabled.
Allow Common Name Host Name Mismatch Allow a mismatch between the SSL certificate's common name and the host name of the Presto server. This property can be selected only when SSL is enabled.

Miscellaneous properties

Property Description
Query timeout Amount of time before a data load query times out. Can be set from 30 seconds to 65535 seconds. Default = 30 seconds

Using Advanced options

Option Description Required

Name

Name of additional properties.

You can add more than one additional properties.

no
Value

Value of additional properties.

You can add more than one additional properties.

no
Note: When you connect to a Presto database with the Data load editor or the Edit Script dialog, Test Connection enables you to test the connection before you attempt to create it.

Did this information help you?

Thanks for letting us know. Is there anything you'd like to tell us about this topic?

Can you tell us why it did not help you and how we can improve it?