Encrypting Network Traffic
Looker strongly recommends encrypting network traffic between the Looker application and your database. Consider one of the options described on this page.
If you’re interested in using SSL encryption, see the Denodo documentation.
Configuring Denodo for Looker
Preparing Denodo for Looker requires just a couple steps:
Import a Custom Function
In order to support Symmetric Aggregates, connecting to Denodo currently requires importing a custom function. You can find our custom
DT-Looker-Utils.vql function in this User Forum topic. Import this function using the Import option in the File menu of the Denodo Administration Tool.
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.
Looker’s ability to provide some features depends on the database dialect’s ability to support that functionality. In the current Looker release, Denodo supports the following Looker features:
After completing the database configuration, you can connect to the database from Looker using these directions.