Installing Looker on-premise involves setting up the software on your server, configuring startup options, and ensuring secure access. Once installed, you can integrate Looker with Secoda to enhance data management and analytics.
This guide provides a step-by-step process on how to achieve this.
1. Add Looker to Your Server
Start by installing Look er on your server. This is the first step towards setting up a customer-hosted deployment.
- Ensure your server meets the necessary system requirements.
- Download the Looker software.
- Install the software on your server.
2. Configure Looker Startup Options
After installing Looker, you need to configure its startup options to suit your needs.
- Set the Looker startup options as per your requirements.
- Ensure the settings are correctly configured to avoid any startup issues.
- Save the changes and restart Looker to apply the new settings.
3. Configure Your SSL Certificate for HTTPS
For secure communication, configure your SSL certificate to enable HTTPS.
- Obtain a valid SSL certificate from a trusted Certificate Authority (CA).
- Install the SSL certificate on your server.
- Configure Looker to use the SSL certificate for HTTPS.
4. Consider Port Forwarding for a Cleaner URL
Port forwarding can help you achieve a cleaner URL for your Looker instance.
- Configure your router or firewall for port forwarding.
- Set the port forwarding rules as per your needs.
- Ensure the port forwarding is working correctly by testing the URL.
5. Allow Looker Support to Access Your Instance
Granting Looker support access to your instance can help in troubleshooting any issues.
- Enable remote support in the Looker settings.
- Provide the necessary permissions for Looker support to access your instance.
- Ensure the access is secure and limited to troubleshooting purposes only.
6. Integrate Looker with Secoda
Once Looker is set up, you can integrate it with Secoda for enhanced data management and analytics.
- Go to the Integrations tab in the Secoda app and select Add Integration.
- Search for and select Looker.
- Enter the Looker Client ID, Client Secret, and host, then click Connect.
7. Connect the LookML Repo to Secoda
For Secoda to get lineage between Looker and the data warehouse, it needs access to the GitHub repo where Looker manages file versions and records changes.
- Provide Secoda with access to the GitHub repo.
- Secoda will automatically detect LookML projects connected to the Looker instance.
- The LookML projects can be viewed in the Git tab on the Looker Integration Page.
Integrating Secoda with your on-premise Looker enables you to leverage AI-powered data management capabilities, enhancing your data search, cataloging, monitoring, and governance processes.