Bookshelf Home | Contents | PDF     

Siebel System Requirements and Supported Platforms > Supported Database Server Platforms >

Supported Relational Database Management Systems

The Siebel Database Server supports the relational database management systems listed in Table 8.

NOTE:  It is strongly recommended that you upgrade to the latest Siebel 8.1.1.x Fix Pack available in order to be able to use the most recent database versions.

Table 8. Supported Relational Database Management Systems
Vendor and Product
Version
Code Page1
Sort Order
Supported Operating System
Connectivity Software

Microsoft SQL Server 2005, compatibility level setting of 90

2005 with SP2 or above

UCS-2

1252

Binary or Dictionary with Case Insensitive and Accent or Dictionary with Case Sensitive

Available on all Microsoft Windows Server 2003 supported platforms.

Microsoft SQL Native Connectivity
(SNAC)

Microsoft SQL Server 2005, Enterprise Edition

2005 with SP2 or above

UCS-2

1252

Binary or Dictionary with Case Insensitive and Accent or Dictionary with Case Sensitive

Available on all Microsoft Windows Server 2003 supported platforms.

Microsoft SQL Native Connectivity (SNAC)

Microsoft SQL Server 2008 RTM or above

2008 (32-bit and 64-bit) RTM or above Service Pack

UCS-2

1252

Binary or Dictionary with Case Insensitive and Accent or Dictionary with Case Sensitive

Available on all Microsoft Windows Server 2003 or Microsoft Windows Server 2008 supported platforms. Microsoft SNAC (SQL Native Connectivity)

Microsoft SQL Native Connectivity (SNAC)

Microsoft SQL Server 2008 Enterprise Edition

2008 (32-bit and 64-bit) RTM or above Service Pack

UCS-2

1252

Binary or Dictionary with Case Insensitive and Accent or Dictionary with Case Sensitive

Available on all Microsoft Windows Server 2003 or Microsoft Windows Server 2008 supported platforms. Microsoft SNAC (SQL Native Connectivity)

Microsoft SQL Native Connectivity Client (SNAC)

Microsoft SQL Server 2008 R2

NOTE:  MSSQL Server 2008 R2 is supported as of the Siebel 8.1.1.6 Fix Pack

2008 R2 or above

UCS-2

1252

 

Binary or Dictionary with Case Insensitive and Accent or Dictionary with Case Sensitive

 

Available on all Microsoft Windows Server 2003 or Microsoft Windows Server 2008 supported platforms. Microsoft SNAC (SQL Native Connectivity)

 

Microsoft SQL Native Connectivity (SNAC)

 

IBM DB2 LUW Enterprise Edition

v9.1 with FixPak 4 or above3

UCS-22

1252, 943

 

Identity (System)

SQL_CS_UCA_NO4

SQL_CS_UCA_LTH

Available on all IBM DB2 LUW supported platforms.

IBM DB2 LUW V9 Runtime Client and DB2 LUW V9 Connect with Fix Pak 4 or above

IBM DB2 LUW Enterprise Edition3

v9.7 with FixPak 1 or above

UCS-22

1252, 943

 

Identity (System)

SQL_CS_UCA_NO4

SQL_CS_UCA_LTH

Available on all IBM DB2 LUW supported platforms.

 

IBM DB2 LUW v 9.7 Runtime Client v9.7 Connect with FixPak 1 or above.

IBM DB2 UDB for z/OS

8 + RML or above

5348, 943

1140 EBCDIC

Unicode

ASCII

 

IBM UDB for
z/OS and OS/390 v8 (with Required Maintenance Level as specified by APAR ii13985)

IBM DB2 9.7 Runtime Client and DB2 9.7 Connect with FixPak 1 or above

IBM DB2 for z/OS

v9 with PUT 08085 or above

5348, 943

1140 EBCDIC

Unicode

 

ASCII

All operating systems supported by IBM UDB for z/OS v9 (with Required Maintenance Level)

IBM DB2 9.7 Runtime Client and DB2 9.7 Connect with FixPak 1 or above

EBCDIC

IBM DB2 for z/OS

v10 + RML or above

5348, 943

1140 EBCDIC

Unicode

 

ASCII

z/OS

IBM DB2 9.7 Runtime Client and IBM DB2 9.7 Connect wiht FixPak 4 or above.

Oracle 10g Enterprise Server

Oracle 10g Standard Edition

10.2.0.2 or above

WE8MSWIN1252, JA16SJIS, AL32UTF8,
JA16SJISTILDE

 

Available on all Oracle supported platforms except IBM z/OS.

Oracle 11g client and Data Direct ODBC Driver 5.3

 

Oracle 11g R1 Enterprise Server

Oracle 11g R1 Standard Edition

11.1.0.6 or above

WE8MSWIN1252, JA16SJIS, AL32UTF8, JA16SJISTILDE

Binary sort order and all linguistic sort orders as provided by Oracle.

Available on all Oracle supported platforms except IBM z/OS.

Oracle 11g client and Data Direct ODBC Driver 5.3

Oracle 11g R2 Enterprise Server

Oracle 11g R1 Standard Edition

11.2.0.1.0 or above

WE8MSWIN1252, JA16SJIS, AL32UTF8, JA16SJISTILDE

Binary sort order and all linguistic sort orders as provided by Oracle.

Available on all Oracle supported platforms except IBM z/OS.

Oracle 11g client and Data Direct ODBC Driver 5.3

1. Referred to as "character set" for MS SQL and Oracle servers, "code set" for IBM UDB LUW, and "CCSID" for IBM UDB on OS/390 and z/OS series.

2. If you are installing an IBM DB2 Unicode database, use UTF-8 as the code set and retain the hyphen. You must enter UTF-8 although the code set support is for UCS-2. This is because when you specify UTF-8 for the VARCHAR field, the VARGRAPHIC field is set to UCS-2 automatically. Therefore, UCS-2 is not specified in this parameter.

3. To download this FixPak, go to http://www.ibm.com.

4. As system performance can be affected by using these sort orders, use of these sort orders is only supported with assistance from Oracle's Application Expert Services. For more information, contact your Oracle sales representative for Oracle Advanced Customer Services.

5. Support for IBM DB2 LUW v9.7 is available as of the Siebel 8.1.1.3 Fix Pack.

Note that dictionary sort orders (collation sequences) are not supported for use in the following circumstances:

  • During an upgrade from one Siebel application version to another. All databases being upgraded must use a binary sort order (called Identity in UDB).
  • When using Siebel Tools. Development databases where Siebel Tools is being used must use a binary sort order (called Identity in UDB).
    
Siebel System Requirements and Supported Platforms Copyright © 2012, Oracle and/or its affiliates. All rights reserved. Legal Notices.