Specifying a JDBC name and URL

The JDBC name and URL, which define how Java applications connect to a database, are specified in the JDBC Name and URL dialog box.

  1. In the JDBC Driver Name field, enter the class name of your JDBC driver.
  2. In the JDBC Driver URL field, enter JDBC driver URL.
  3. Click Finish. The new data source definition appears in the Data Sources folder.

IBM® SPSS® Collaboration and Deployment Services is installed with a set of JDBC drivers for all major database systems. It also provides JDBC drivers for IBM SPSS Statistics file access.

For current supported database information, refer to the software product compatibility reports on the IBM Technical Support site.

If single sign-on is enabled for your system, include the optional AuthenticationMethod property in the driver URL string to use single sign-on for the database connection. Valid value for this property include kerberos and ntlm (NT LAN Manager).

Db2

Class name: spssoem.jdbc.db2.DB2Driver

URL string template:

jdbc:spssoem:db2://<host>:<port>;DatabaseName=<database>[;AuthenticationMethod=kerberos]

Greenplum

Class name: org.postgresql.Driver

URL string template:

jdbc:postgresql://<host>:<port>/<databasename>

Informix

Class name: spssoem.jdbc.informix.InformixDriver

URL string template:

jdbc:spssoem:informix://<host>:<port>;InformixServer=<Informix server>

MS SQL Server

Class name: spssoem.jdbc.sqlserver.SQLServerDriver

URL string template:

jdbc:spssoem:sqlserver://<host>:<port>;DatabaseName=<database>[;AuthenticationMethod=kerberos|ntlm]

MySQL

Class name: spssoem.jdbc.mysql.MySQLDriver

URL string template:

jdbc:spssoem:mysql://<host>:<port>;DatabaseName=<database>

Oracle

Class name: spssoem.jdbc.oracle.OracleDriver

URL string template:

jdbc:spssoem:oracle://<host>:<port>;SID=<database>[;AuthenticationMethod=kerberos]

SAP Hana

Class name: com.sap.db.jdbc.Driver

URL string template:

jdbc:sap://<host>:<port>

Sybase

Class name: spssoem.jdbc.sybase.SybaseDriver)

URL string template:

jdbc:spssoem:sybase://<host>:<port>;databaseName=<database>[;AuthenticationMethod=kerberos]

Teradata

Class name: com.teradata.jdbc.TeraDriver

URL string template:

jdbc:teradata://<host>/Database=<databasename>

IBM SPSS Statistics data files

Class name: com.spss.statistics.datafile.jdbc.openaccess.OpenAccessDriver

URL String template:

jdbc:spssstatistics://<hostname>:<port>;ServerDatasource=SAVDB;
CustomProperties=(<data_file_identifier>;UserMissingIsNull=<1|0>;MissingDoubleValueAsNAN=<1|0>)
Note:
  • The hostname parameter is the host name or IP address of the computer on which the driver is running. The default value is localhost.
  • The default is port is 18886.
  • Replace <data_file_identifier> with a string identifying the data file. This may be specified in a variety of ways. Use CONNECT_STRING=<path_to_file> to specify the path to the file, where the path is either a repository URI or a path relative to the host on which the driver is running. The path cannot contain any equals sign or semicolon characters. Alternatively, for data files stored in the repository, use REPOSITORY_ID=<file_id>;REPOSITORY_VERSION=<file_version> to specify the repository file and version identifiers. The file version may be specified as a label or as a version marker, with spaces replaced by the standard escape character of %20.
  • The UserMissingIsNull parameter is optional and specifies the treatment of user-defined missing values. 0 indicates that user-defined missing values are read as valid values. 1 indicates user-defined missing values are set to system-missing for numeric variables and blank for string variables. If UserMissingIsNull is not specified, it is set to a default value of 1.
  • The MissingDoubleValueAsNAN parameter is optional and specifies the treatment of missing numeric values. 0 indicates that user missing values are displayed with the original missing value in the data file. 1 indicates that user missing values are read as not a number (NaN). For JDBC, UserMissingIsNull should always be set to 1.
  • When testing a connection that specifies AuthenticationMethod=ntlm, use any credential available in the system. The selected credential is not actually passed to the data source due to the authentication method, but the test requires that a credential be specified.

System z data sources

IBM SPSS Collaboration and Deployment Services provides the capability to access the following System z data sources using standard DataDirect Db2 drivers:

  • Db2 for z/OS
  • Db2 LUW on Linux for System z
  • Oracle on Linux for System z