PostgreSQL

    host

    db-host

    port

    5432

    database

    test

    user

    postgres

    password

    test

    SQL test

    select * from test

    MySQL

    host

    db-host:3306

    database

    test

    user

    root

    password

    test

    SQL test

    select * from test

    Icon

    User account and accessed database must have the remote access enabled.

    How Do I Grant Access To An Existing Database?

    Oracle

    host

    db-host

    port

    1521

    driver

    V14_10_2_0_1

    user

    tester

    password

    test

    SID

    XE

    SQL test

    select * from test

    MS SQL

    host

    db-host

    port

    1433

    user

    sa

    password

    test

    database

    test

    SQL test

    select * from test

    Icon

    SQL Server Authentication must be enabled.

    Icon

    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

    select * from products

    Icon

    If you see error "JZ0SJ: Metadata accessor information was not found on this database. Please install the required tables as mentioned in the jConnect documentation." then you have to allow the Sybase jConnect JDBC driver to access system catalog information. Please execute SQL query "ALTER DATABASE Upgrade JCONNECT ON" and see documentation for more details.

    Icon

    Some Sybase installations does not have metadata support initialized. In this case, it is necessary to initialize the metadata by calling the stored procedure or set the use_metadata connection parameter to false. Read more here.

    Icon

    Browse all JDBC parameters

    Teradata 13

    host

    db-host

    user

    dbc

    password

    test

    SQL test

    select * dbc.tables