Establish JDBC Connection
A JDBC driver can pull data into Metric Insights using a SQL fetch command. This includes traditional databases as well as NoSQL sources with JDBC access.
This article describes the general process for creating a SQL data source. Information on creating a data source based on a Plugin can be found Create New Plugin Data Source.
For a description of Metric Insights overall approach to Data Sources, click Understanding Data Sources.
Video Tutorial
1. Create New Data Source
Access Admin > Collection & Storage > Data Sources
- [+ New Data Source]
- Select a SQL Data Source form the drop-down
- [Next]
2. Describe Connection
- Provide a descriptive Name for the connection
- Select the required Auth Type:
- Password: use the credentials as shown on the screen to provide access to the database;
- Identity Profile: select the existing Identity Profile in the Identity Profile field that will appear instead of Username and Password;
- Private Key: available only for Snowflake. See instructions for configuring Private Keys in this article;
- Active Directory Service Principal: available only for Microsoft SQL Server. See instructions for configuring ADSP in this article.
- Enter Host Name
- Supply Database name
- The Port number as well as JDBS string are set by default, based on your choice of JDBC Driver. Change it if necessary.
- NOTE: If you do not see the the desired driver in the drop-down provided, contact Metric Insights for assistance.
- [Save]
NOTE: The JDBC string will be created automatically based on your other inputs. In some cases, however, it will not be possible to infer the correct string without additional inputs. If the Connection Test fails, please check the documentation for your JDBC driver.
IMPORTANT: For Microsoft SQL Data Sources with invalid certificates, it is required to upend “;trustServerCertificate=true” to the JDBC connection string to establish connectivity.
3. Validate Created Connection in Data Source Editor
