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.
- In the JDBC Driver Name field, enter the class name of your JDBC driver.
- In the JDBC Driver URL field, enter JDBC driver URL.
- 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>)
- 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, useREPOSITORY_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 of1
. - 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 to1
. - 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