Connect to Looker with JDBC
After your Actian warehouse is created and running, you may connect to it from Looker.
Note: When loading large amounts of data, you may face network disconnects or network-related errors. You must keep your TCP connection alive by increasing the TCP keepalive length. For more information, see
Network Disconnects Due to Perceived Inactivity.
Before you can connect to your warehouse from Looker, you must install the Actian JDBC package. Follow the instructions in
Actian JDBC Driver.
To connect Looker to your Actian warehouse
1. Start Looker and display the dashboard.
2. In the Actian Data Platform, add your IP address and the Looker endpoint IP address to your warehouse’s allow list of trusted IPs.
4. Select Looker from the Connect to Actian warehouse dropdown.
5. From the Looker dashboard, click the Admin menu, Database, Connections.
6. Click the New Connection button.
The Connection Settings page is displayed.
7. Enter a name for the connection, for example, “Actian warehouse.”
8. Copy the following information from the Actian Data Platform Looker Connections page to the corresponding fields on the Looker Connections Settings page:
• Dialect
• Host
• Database
• Username
9. In the Looker Connections Settings Password field, enter the Actian warehouse Connection Password.
For more information, see:
10. At the bottom of the Looker Connections Settings page, click the Test These Settings button.
If the connection fails, make sure the Actian warehouse is running and double-check the information entered in the connection fields. Then test again until a successful connection is made.
11. Click the Add Connection button.
The new connection is added to Looker’s list of available connections.
12. Open the connection and test whether it returns data from your Actian warehouse.
Last modified date: 10/30/2024