There are two ways to connect Qlik to Honeydew:

  1. Via a JDBC connection, using the Presto protocol
  2. Via a Snowflake connection, utilizing the Honeydew Snowflake Native Application

​
Setting up a new Data Connection

Qlik data connections are mapped to a Honeydew workspace and branch

It is recommended to use an API Key for setting up the connection.

  1. In the main menu, go to Create and then click Data connections
  2. Choose a Space from the list of spaces
  3. Choose Presto from the list of Data connectors
  4. Set Host name to jdbc.honeydew.cloud and Port to 443
  5. Set Catalog to <workspace>__<branch> value, based on the Honeydew workspace and branch you would like to connect to. Omit the branch value if connecting to prod. For example, for workspace tpch, branch prod, the value would be: tpch. And for workspace tpch, branch dev, it would be tpch__dev.
  6. Choose LDAP Authentication as the Authentication Type
  7. Check the User defined credentials checkbox if you would like to use per-user credentials or keep unchecked if you would like to share the credentials with anyone who has access to this data connection.
  8. Set Username to the API key (or a Honeydew username), and Password to the API secret (or to the user’s password in Honeydew).
  9. Make sure the Enable SSL toggle is On (it should be enabled by default)
  10. Provide a unique Name for the data connection (e.g. “Honeydew”)
  11. Click Test Connection
  12. Once the connection is successful, click Create

If your organization uses a custom hostname for the JDBC connection, you can locate it in the Honeydew UI, under the JDBC section in Settings.

You can now create datasets on top of the Honeydew database connection, using the Qlik user interface.

Qlik does not support Direct Query for Presto data connection. Only data import is supported.

​
Connecting via Snowflake Connection using the Snowflake Native Application

  1. Create a Snowflake database connection in the account where you have the Honeydew Snowflake Native Application installed
  2. In query editor for a new query/report, use the Honeydew Snowflake Native Application query interfaces (SELECT_FROM_FIELDS or SELECT_FROM_QUERY) to query the data.

​
Metadata Sync

Honeydew support for Qlik metadata sync is in preview. For more information, please contact support@honeydew.ai.

Was this page helpful?