This knowledge base article is intended to provide you with a step-by-step guide on how to establish a connection to Metrics, leveraging the power of ODBC (Open Database Connectivity). By following the instructions outlined in this guide, you can seamlessly access your Metrics data and harness it for various analytical and reporting purposes.
Prerequisites
- Have whitelisted your IP ranges you will be using to connect to your metrics DB
- Received an SSL Key pair
- Received the database and host details
- Received Username and password
- Have chosen a relevant CA bundle to verify Jumbo
Note: CA bundles are not provided by Jumbo. Use a trusted CA bundle like what is provided with your operating system, or these CA certificates extracted from Mozilla: https://curl.se/docs/caextract.html.
Dbeaver
1. Enter in the connection details
In the new connection window enter the provided details
- Host
- Database
- Port
- Username
- Password
2. Navigate to the SSL tab
Navigate to the SSL tab in the new connection window. Tick the “Use SSL” box.
Select the provided files:
- CAcert.pem
- clientcertificate.crt
- clientprivatekey.key
- Change the SSL mode to “verify-full”
Microsoft ODBC Data Source
1. Open the ODBC Data Source Administrator
Open the ODBC Data Source Administrator and navigate to System DSN and click Add…
2. Select PostgreSQL Unicode(x64) and click Finish
3. Enter the relevant connection details
- Description
-
Database
- Metrics database name
-
Server
- Host
- Username & Password
-
SSL Mode
- verify-full
- Port
4. Click Datasource and then in the new window popping up click Page 3
4. Specify the location of the relevant certificates
In the “libq parameters:(I) you will need to specify the location of the relevant certificates
e.g sslrootcert=C:/temp/cacert.pem sslcert=C:/temp/example.crt sslkey=C:/temp/example.key