# JDBC Data Source

To add a database as a data source in Axibase Collector, open the Data Sources > Databases page and click New Data Source.

# General Settings

Field	Description
Name	Data source identifier.
Database Type	Type of database. Possible values: Oracle, MSSQL, MSSQL_Native, DB2, SOLID, MYSQL, POSTGRESQL, SYBASE, DERBY, SAP, PI_SERVER, VERTICA, CUSTOM
Server	IP or hostname of target server.
Port	Port on which database listens.
Database	Name of the database residing on the database server.
Instance	Instance identifying name.
Username	Username connecting to the database. The recommended setting is to create a read-only account to access the database.
Password	User password.
Driver Properties	Extended JDBC diver properties. Specific to each database

# Connection Settings

# Pool

Field	Description
Max Active Connections	Maximum number of active connections.
Max Idle Connections	Maximum number of idle connections.
Max Wait, seconds	Maximum number of seconds for a job to wait until the job requires a connection from the pool.
Min Idle Connections	Minimum number of idle connections.
Initial Connection Pool Size	Initial size of the connection pool.

# Connection

Field	Description
Test Query	Test query to keep the connection alive.
Max Age, minutes	Maximum duration of the connection, after which the connection is closed and reopened by the database.
Idle Timeout, seconds	Duration after which an unused connection is closed.
Login Timeout, seconds	Wait duration when opening a connection.
Socket Timeout, seconds	Duration after which the connection is dropped if there is no response from the server.