Encrypting network traffic

Looker strongly recommends encrypting network traffic between the Looker application and your database. Consider one of the options described on the Enabling secure database access documentation page.

If you’re interested in using SSL encryption, see the Denodo documentation.

Configuring Denodo for Looker

Preparing Denodo for Looker requires a few steps:

Import a custom function

To support symmetric aggregates, a custom function (BASE64_TO_BASE10) has to be added to the Denodo VDP Server. For instructions, see Denodo's Knowledge Base article on Connecting Looker to Denodo.

Grant the database user appropriate permissions

Looker will require SELECT access to any tables or databases you would like to query within Looker. Ensure the database user with which you are connecting to Looker can access these tables.

Feature support

For Looker to support some features, your database dialect must also support them.

In Looker 22.6, Denodo supports the following Looker features:

In Looker 22.6, Denodo 7 supports the following Looker features:

In Looker 22.6, Denodo 8 supports the following Looker features:

Next steps

After completing the database configuration, you can connect to the database from Looker using these directions.