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 13.

NOTE:  Siebel clients and servers should be the same version and build.

Table 13. 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 SNAC (SQL Native Connectivity) Native Client

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 SNAC (SQL Native Connectivity) Native Client

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) v9.x. Compatibility mode must be set to 90 when configuring the database.

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 SQL Native Connectivity (SNAC) v9.x. Compatibility mode must be set to 90 when configuring the database.

Microsoft SQL Server 2008 R2

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 SQL Native Connectivity (SNAC)

NOTE:  There are no restrictions on the SNAC version as long as you are using Siebel 8.0.0.13.

IBM Universal Database (UDB) Enterprise Server Edition

82

UCS-2

1252, 943

Identity (System)

SQL_CS_UCA_NO

SQL_CS_UCA_LTH

Available on all IBM UDB LUW supported platforms.

IBM UDB Runtime Client and UDB Connect version 8 with FixPak 12 or above.3

IBM DB2 UDB for z/OS

8 + RML

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 UDB Runtime Client 8.1 and UDB Connect PE 8.1 with FixPak 12 or above.3

IBM DB2 Runtime Client and DB2 9.5 Connect with FixPak 5 or above.

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

IBM DB2 for z/OS

v9

5348, 943

1140 EBCDIC

Unicode

ASCII

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

IBM DB2 9.1 Runtime Client and DB2 9.1 Connect with FixPak 4 or above

IBM DB2 9.5 Runtime Client and DB2 9.5 Connect with FixPak 5 or above

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

EDCBIC

IBM DB2 for LUW Enterprise Edition

V9.1 with FixPak 4 or above

UCS-2

1252, 943

Identity (System)

SQL_CS_UCA_NO

SQL_CS_UCA_LTH

Available on all IBM DB2 LUW supported platforms.

IBM UDB Runtime Client and UDB Connect version 9 with FixPak 4 or above

IBM DB2 for LUW5

V9.7 with FixPak 1 or above

UCS-2

1252, 943

Identity (System)

SQL_CS_UCA_NO

SQL_CS_UCA_LTH

Available on all IBM DB2 LUW supported platforms.

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

Oracle 10g Enterprise/ Standard Server

10.2.0.4 or above

WE8MSWIN1252, JA16SJIS, AL32UTF8,
JA16SJISTILDE

 

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

Oracle 10g client and Data Direct ODBC Driver 5.0

Oracle 11g Enterprise/Standard Server

11.1.0.6 or above

WE8MSWIN1252, JA16SJIS, AL32UTF8,
JA16SJISTILDE

 

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

Oracle 10g client and Data Direct ODBC Driver 5.0

Oracle 11g R2 Enterprise/Standard Server4

11.2.0.1.0 or above

WE8MSWIN1252, JA16SJIS, AL32UTF8

Binary or Dictionary7

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

Oracle 10g client and Data Direct ODBC Driver 5.0

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 System z series.

2. If you are installing an IBM UDB Unicode database, use UTF-8 as the codeset and retain the hyphen. You must enter UTF-8 although the codeset 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-306.ibm.com/software/data/db2/udb/support/downloadv8_linuxx8624kernel.html#r12.

4. Oracle 11g R2 is supported as of the Siebel 8.0.0.9 Fix Pack.

5. IBM DB2 for LUW v9.7 is supported as of the Siebel 8.0.0.9 Fix Pack.

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

  • During an upgrade from one Siebel 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.