Knowledge BaseMetric InsightsSystemDatabasePorts used by Metric Insights to connect to different databases

Ports used by Metric Insights to connect to different databases

When you establish connection to a database, the Port number will be set by default, based on your choice of JDBC Driver. You can change it if necessary per the following article:

http://help.metricinsights.com/m/Connecting_to_Data_Sources/l/104147-create-new-sql-data-source

Note about HTTP and HTTPS: HTTPS URLs begin with "https://" and use port 443 by default, whereas HTTP URLs begin with "http://" and use port 80 by default.

HTTP is not encrypted and is vulnerable to man-in-the-middle and eavesdropping attacks, which can let attackers gain access to website accounts and sensitive information, and modify webpages to inject malware or advertisements. HTTPS is designed to withstand such attacks and is considered secure against them (with the exception of older, deprecated versions of SSL).

The list of default Ports for SQL data sources

Database Default port
MySQL Connector/J 3306
PostgreSQL 5432
Netezza 5480
Oracle 1521
Microsoft SQL Server (JTDS) 1433
Sybase (JTDS) 7100
Hadoop Hive 10000
Teradata 1025
Vertica 5433
HSQLDB 9001
Apache Hive2 10000