JDBC Provider Class Name

Last Updated : Sep 28, 2020 |

Database

JDBC Provider Class Name

JDBC Sources sample DB URL

Oracle

oracle.jdbc.pool.OracleConnectionPoolDataSource

jdbc:oracle:thin:@<Databaseserver IP or FQDN>:port number:<database name>

  • serverName

  • databaseName

  • portNumber: default is 1521

PostgreSQL

org.postgresql.jdbc2.optional.ConnectionPool

jdbc:postgresql:// <Database server IP

Ensure you configure the following custom properties:

  • serverName

  • databaseName

  • portNumber: default is 5432

MS SQL Server

com.microsoft.sqlserver.jdbc.SQLServerConnectionPoolDataSource

jdbc:sqlserver://<Database server IP or FQDN>

Ensure you configure the following custom properties:

  • serverName

  • databaseName

  • portNumber: default is 1433