To configure a JDBC Driver | Known JDBC Driver Issues
The following types of relational databases are supported for use with Proficy Portal:
SQL Server 7 and 2000
Oracle 8i and 9i
DB2
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:
A user submits a database command. The command may instruct the software to:
Retrieve data.
Insert, update, or delete data.
Execute a stored procedure.
Proficy Portal receives the request and sends it to the driver.
The driver passes the request to the relational database.
The relational database executes the request and sends data to the driver, if required.
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:
GE Fanuc DB2
GE Fanuc Oracle
GE Fanuc SQL Server
jadoZoom (ADO Bridge for ODBC and OLE DB)
jTDS
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:
A name for the driver. This text is used by Proficy Portal to identify it.
The driver's Java class name. Refer to the following table or the driver's documentation for the Java class name to use.
The syntax to use when specifying the driver's URL. This text is displayed by the Administration application and is intended as a prompt to the person configuring the data source. To determine the correct syntax, refer to the following table or your driver's documentation.
The JAR files required to run the driver. Refer to the following table or the driver's documentation for a list of JAR files to include.
Refer to To configure a JDBC Driver for detailed JDBC configuration instructions.
|
JDBC Driver |
Configuration |
|
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; JAR Files: izmado.jar |
|
jadoZoom communicating to a OLE DB database |
Class name: com.inzoom.jdbcado.Driver URL: jdbc:izmado:Provider=SQLOLEDB;Server=servername; 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 |
|
jTDS |
Class name: net.sourceforge.jtds.jdbc.Driver URL: jdbc:jtds:sqlserver://hostname:portnumber/dbname;DOMAIN=domain JAR File: jtds-0.9.jar |
JDBC to Proficy Portal Data Type Mappings
To configure an SQL data source to use Windows Authentication
