This documentation supports the 11.2 version of BMC Discovery.

To view an earlier version of the product, select the version from the Product version menu.

JDBC drivers

The following table provides an example JDBC URL for database targets. It also provides documentation and download URLs where available. For more information, consult the database vendor's documentation.

Database

JDBC URL
Internet site

IBM DB2
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
Ingres
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

Microsoft SQL Server
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

MySQL

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

Oracle

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).

PostgreSQL
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

Sybase

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.

Was this page helpful? Yes No Submitting... Thank you

Comments