Showcase Client 9.1.0.7 introduces support for a new SQL Server driver that can be used for Warehouse Builder definitions. This is also used for running IBM Collaboration & Deployment Services jobs containing Warehouse Builder job steps to an Enterprise Server.
Query and Report Writer data sources are not affected by this enhancement and no changes are required for DBQ and RPT files.
The new driver is supported for SQL Server 2012, 2008 and 2005 databases, but NOT SQL Server 2000. The old driver is still supported for SQL Server 2008, 2005 and 2000 databases. So, current users will
not need to make any changes unless you want to connect to SQL Server 2012.
By default, the old driver is defined in the data source examples. Therefore, you will need to edit the driver name and connection string if using the new driver:
C:\PROGRAM FILES (X86)\SHOWCASE\9\PRODDATA\CONFIG\SHOWCASE.CFG
SHOWCASECORP.DRIVERCLASSNAME=SPSSOEM.JDBC.SQLSERVER.SQLSERVERDRIVER
SHOWCASECORP.DRIVERCLASSNAME=COM.MICROSOFT.SQLSERVER.JDBC.SQLSERVERDRIVER
SHOWCASECORP.DRIVERURL=JDBC:SPSSOEM:SQLSERVER:
(followed by database connection information described below)SHOWCASECORP.DRIVERURL=JDBC:SQLSERVER:
(followed by database connection information described below)The connection string syntax is as follows:
showcasecorp.driverURL=jdbc:sqlserver://sssss[:nnnn[;InstanceName=iiiii
[;DatabaseName=ddddd]]]
(where sssss = ServerName, nnnn = PortNumber, iiiii = InstanceName, and
ddddd = DatabaseName)
The properties used to define the connection to the server are:
Other connection properties are supported. Please consult with Microsoft web page, Setting Connection Properties.
Examples:
Simple connection to the server (the default port, instance, and database will be used):
showcasecorp.driverURL=jdbc:sqlserver://ServerName
To use a port number:
showcasecorp.driverURL=jdbc:sqlserver://ServerName:1433
To use a specific instance name (where more than one instance of SQLServer database exists on a single server):
showcasecorp.driverURL=jdbc:sqlserver://ServerName:1433;InstanceName=instance1
To use a specific database:
showcasecorp.driverURL=jdbc:sqlserver://ServerName:1433;InstanceName=instance1;DatabaseName=MASTER
Note: Warehouse Builder Definitions do NOT need to be changed, since only the database name is stored there.
Still have questions? We can help. Submit a case to Technical Support.