JDBC drivers

jdbc:db2://host[:50001][/schema][:name=value[;name=value ...]] 

The following example URL connects to an IBM DB2 server running on a host on IP address 192.168.1.100, port 50001, schema schema_name, user fred, password password, and SSL set to true:

jdbc:db2://192.168.1.100:50001/schema_name:user=fred;password=password;SSL=true

• Driver download
• Vendor documentation

jdbc:ingres://host:[port]/database
    [;property=value][;property=value]

The following example URL connects to an Ingres server running on a host on IP address 192.168.0.100, port mnemonic II7, database name ADDMdatabase, user fred, and password password:

jdbc:ingres://192.168.0.100:II7/ADDMdatabase;user=fred;password=password

• Driver download
• Vendor documentation

jdbc:sqlserver://serverName[\instanceName][:portNumber]
    [;property=value][;property=value]

The following example URL connects to an instance of MS SQL server called TDA running on a host on IP address 192.168.0.100, port 1433, user fred, and password password. The username and password correspond to a user configured on the database rather than a Windows AD user. For more information, see the related Microsoft article.

jdbc:sqlserver://192.168.0.100\TDA:1433;User=fred;Password=password

• Driver download
• Vendor documentation

jdbc:mysql://host[,failoverhost...][:port]/[database]
    [;property=value][;property=value]

The following example URL connects to a MySQL server running on a host on IP address 192.168.0.100, port 3306, database name ADDM_IMPORT, user fred, and password password:

jdbc:mysql://192.168.0.100:3306/ADDM_IMPORT?user=fred&password=password

• Driver download
• Vendor documentation

For Oracle, there are two possible connection styles:

Connection using service

jdbc:oracle:<drivertype>:[username/password]@//host[:port]/service

The following example URL connects, using a thin driver, to an Oracle server running on a host on IP address 192.168.0.100, port 1521, and service ADDM_DB:

jdbc:oracle:thin:@//192.168.0.100:1521/ADDM_DB

Connection using SID

jdbc:oracle:<drivertype>:@host[:port]:SID

The following example URL connects, using a thin driver, to an Oracle server running on a host on IP address 192.168.0.100, port 1521, and SID ADDM100:

jdbc:oracle:thin:[username/password]@192.168.0.100:1521:ADDM100

• Driver download. On this page, click the link relevant to your installed version of Oracle database.
• Vendor documentation—The JDBC download page has the README, Javadocs, and code samples available as a zipped file. Download this file to know more about the JDBC driver.

For more information about setting up both styles in BMC Discovery, see Multiple Drivers Using the Same JAR (Oracle).

jdbc:postgresql://host:[port]/database
    [?propertyName1][=propertyValue1][&propertyName2][=propertyValue2]

The following example URL connects to a Postgres server running on a host on IP address 192.168.0.100, port 5432, and database name ADDMdatabase:

jdbc:postgresql://192.168.0.100:5432/ADDMdatabase

• Driver download
• Vendor documentation

jdbc:sybase:Tds:host[:port][/databasename]

The following example URL connects to a Sybase server running on a host on IP address 192.168.0.100, port 6689, and database name ADDM_DB:

jdbc:sybase:Tds:192.168.0.100:6689/ADDM_DB

• Vendor documentation. This page also provides a link for the driver download. However, you must have the appropriate login credentials to download the driver.