JDBC Drivers

To configure a JDBC Driver | Known JDBC Driver Issues

The following types of relational databases are supported for use with Proficy Portal:

If you plan to access a relational database from an analysis display, you need to configure one or more Java Database Connectivity (JDBC) drivers. A JDBC driver is software that enables a relational database and Proficy Portal to communicate with each other as follows:

  1. A user submits a database command. The command may instruct the software to:

    • Retrieve data.

    • Insert, update, or delete data.

    • Execute a stored procedure.

  2. Proficy Portal receives the request and sends it to the driver.

  3. The driver passes the request to the relational database.

  4. The relational database executes the request and sends data to the driver, if required.

  5. The driver receives any data returned from the relational database and sends it to the Proficy Portal server for subsequent routing to the client.

Proficy Portal installs and configures the following JDBC drivers:

SQL connector licensing is implemented on a per provider basis. Drivers available to the SQL connector are licensed on a per database provider basis.

If you require a driver that Proficy Portal does not install, you must install the driver yourself. Refer to the driver's documentation for installation instructions.

After a JDBC driver is installed, it must be configured in Proficy Portal. By configuring a driver, you provide Proficy Portal with information needed for the SQL connector to function with the installed JDBC driver.

You can configure a JDBC driver with the JDBC Configuration utility. To start the utility, select JDBC Configuration from the Proficy Portal program group. When the utility starts, it displays the JDBC drivers that Proficy Portal configured during installation. You can configure any additional JDBC drivers by clicking the Add button and supplying the following information:

Refer to To configure a JDBC Driver for detailed JDBC configuration instructions.

JDBC Driver Configurations

JDBC Driver


GE Fanuc DB2

(supplied with Proficy Portal)

Class name: com.gefanuc.jdbc.db2.DB2Driver

URL: jdbc:gefanuc:db2://hostname:port;DatabaseName=dbname;

JAR Files: Gldb2.jar, Glbase.jar, Glutil.jar

GE Fanuc Oracle

(supplied with Proficy Portal)

Class name: com.gefanuc.jdbc.oracle.OracleDriver

URL: jdbc:gefanuc:oracle://hostname:port;SID=SIDName;

JAR Files: Gloracle.jar, Glbase.jar, Glutil.jar

GE Fanuc SQL Server

(supplied with Proficy Portal)

Class name: com.gefanuc.jdbc.sqlserver.SQLServerDriver

URL: jdbc:gefanuc:sqlserver://hostname:port;Databasename=Name

JAR Files: Glsqlserver.jar, Glbase.jar, Glutil.jar

jadoZoom (communicating to an ODBC connector)

(supplied with Proficy Portal)

Class name: com.inzoom.jdbcado.Driver

URL: jdbc:izmado:Provider=SQLOLEDB;Server=servername;
Database=dbname;Network Library=libraryname;

JAR Files: izmado.jar

jadoZoom communicating to a OLE DB database

Class name: com.inzoom.jdbcado.Driver

URL: jdbc:izmado:Provider=SQLOLEDB;Server=servername;
Database=dbname;Network Library=libraryname;

JAR Files: izmado.jar

NOTE: The provider string depends on the provider you are using. Refer to Table 2 for provider string examples. Also refer to your database documentation to learn the exact syntax you require.

DB2 Type 4 (DB 2 V8)

Class name: COM.ibm.db2.jcc.DB2Driver

URL: jdbc:db2://@ipaddress:portnumber/dbname

JAR Files: db2jcc.jar

SQL Server 2000

(downloaded from microsoft.com)

Class name: com.microsoft.jdbc.sqlserver.SQLServerDriver

URL: jdbc:microsoft:sqlserver://servername:portnumber;DatabaseName=dbname

JAR Files: mssqlserver.jar, msbase.jar, and msutil.jar

ODBC Bridge

Class name: com.inzoom.jdbcado.Driver

URL: jdbc:izmado:DSN=dbname;

JAR Files: izmado.jar

Oracle 9i

Class name: oracle.jdbc.driver.OracleDriver

URL: jdbc:oracle:thin:@hostname:portnumber:dbname

JAR Files: ojdbc14.jar


Class name: net.sourceforge.jtds.jdbc.Driver

URL: jdbc:jtds:sqlserver://hostname:portnumber/dbname;DOMAIN=domain

JAR File: jtds-0.9.jar

OLE DB Provider String Examples

When connecting to...

Use the Provider String...

SQL Server 2000



Provider=IhOLEDB.iHistorian.1:Data Source=IP Address

See Also

To configure a JDBC Driver

JDBC to Proficy Portal Data Type Mappings

Known JDBC Driver Issues

To configure an SQL data source to use Windows Authentication