Agentless Access via Proxy

Overview

QueryPie supports connections via URL Proxy without the need for an agent. When connecting to a database from web services like Redash, Tableau, and Zeppelin, users can securely access the database using the URL Proxy authentication information generated by QueryPie while applying access control policies.

Receiving URL Proxy Authentication Info

This task can only be performed for DB connections where Proxy use has been enabled by an administrator. For enabling Proxy use, refer to the Enable Database Proxy document.

1. Log in to QueryPie and click on Databases in the top menu bar.

2. Click on Proxy Info at the top right.

3. Copy the Proxy Host and Proxy Port for the service you intend to use and enter them instead of the actual DB host.

4. Click the Create Token button to generate a user authentication token.

5. Use the Username and Password provided in the popup to configure your service to connect through the QueryPie proxy. (This user authentication token information is fully exposed only when initially issued).

6. If the token key is lost, click the Revoke button to delete the existing key and then click Create Token button to generate a new token.