PostgreSQL
host | db-host |
port | 5432 |
database | test |
user | postgres |
password | test |
SQL test |
|
MySQL
host | db-host:3306 |
database | test |
user | root |
password | test |
SQL test |
|
User account and accessed database must have the remote access enabled.
How Do I Grant Access To An Existing Database?
Let us assume that you are always making connection from remote IP called 202.54.10.20 for database called webdb for user webadmin, To grant access to this IP address type the following command At mysql> prompt for existing database, enter: mysql> update db set Host='202.54.10.20' where Db='webdb'; mysql> update user set Host='202.54.10.20' where user='webadmin';
Oracle
host | db-host |
port | 1521 |
driver | V14_10_2_0_1 |
user | tester |
password | test |
SID | XE |
SQL test |
|
MS SQL
host | db-host |
port | 1433 |
user | sa |
password | test |
database | test |
SQL test |
|
SQL Server Authentication must be enabled.
You need an SQL account to access the MS SQL remotely.
Sybase SQL Anywhere 11
host | db-host |
port | 2638 |
user | dba |
password | sql |
database | demo |
SQL test |
|
Browse all JDBC parameters
Teradata 13
host | db-host |
user | dbc |
password | test |
SQL test |
|
Visit Teradata documentation for additional parameters https://developer.teradata.com/doc/connectivity/jdbc/reference/current/jdbcug_chapter_2.html#BABJIHBJ