RDBMS-requirements for usage of XI

[Former Member]

Hello!

Could some one help me by RDBMS-requirements for XI?

a) for XI is either Oracle 10g or Microsoft SQL 2005 required (Yes/No)

b) SQL, JDBC, and ODBC drivers available for Oracle 10g and/or MS SQL Server 2005 (Yes/No)

c) use DBMS enforced referential integrity or program enforced referential integrity of data

d) standard pre-defined SQL queries and related calculations provided for use with industry standard reporting tools (Yes/No)

e) database monitoring tools be used to manage impending maintenance needs and potential problems and performance impacts (i.e., tool will monitor and detect prior to real problem occurring) (Yes/No)

Thank you!

Regards

[Former Member]

Hi Peter ,

1. Its up to you weather you prefere oracle or SQL server(available in both) . The last XI I installed at client site with SP 16 was using Oracle 9.0 not 10.0.the required RDBMS is always bundled with netweaver(XI) suite so you do not need to bother about it and its version.

2. For JDBC connectivity (JDBC Adapter) you need to add driver for respective dababase to XI server. they are not shiped from SAP. you need to download them from vendors ie. Microsoft or Oracle website.( free download).

3. for database integrity, it is upto the driver what it support what no. For JDBC adapter features and limmitation read SAP note.

4. for point (d) and (e) I can just say that you can use stanadard SQL , can call procedures, use DML statements and trasaction.Normally XI access data from RDBMS using interface tables.

Hope this will help..

Thanx & Regards

Vinod