Skip to Content
author's profile photo Former Member
0
Former Member

SAP backened database much compatable on Oracle /SQL

Posted on Aug 15, 2006 at 03:34 PM 13 Views

Hi,

We are going to start SAP R/3 new dimensional products implementation. Client wanted to know that which backend databse is very much compatable for SAP.

If some one have much idea on that can please help different comparisions on SAP On Oracle / SQL .

Thanks

kristene

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Sep 27, 2006 at 03:18 PM
    0

    All SAP supported platforms are compatible. It's up to you to decide what RDBMS is the best:

    1) Oracle is stable, scalable or most often used by SAP community (~70%) especially for large organisations. But expensive in licenses and slightly more complex to manage compared to SQLServer.

    2) SQLServer is cheaper for small companies. Closely integrated with Windows. So if you're a Windows shop, you should select this one.

    3) DB2/UDB is a good choice, but I have doubt whether it's there to stay. Only ~3% usage in the community. It's relatively cheap if sold with pSeries bundle. Run&Maintain is well intgrated in SAP and TSM.

    4) MaxDB. Different beast. It's cheapest of all; but not many organizations are using it.

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Andre Urban Blumberg
      Oct 22, 2006 at 05:09 PM

      Yes I would also like to concur with Andre Blumberg's post. We are running 2.2TB R/3 system on MS SQL 2000 (also upgrading to MS SQL 2005 in next months) and W2K3 with great sucess. System and I/O performnce is execellent and the MS SQL 2000 database is very easy to manage.

      I have spent the last 9 years working primarily with SAP on RISC platforms with Oracle and DB2 databases and have only been running on Windows and MS SQL for the last 18 months; however, I have to say I am very impressed with the platform: both from a price performance perspective and in terms on daya to day operation - backup/recovery, DBA admin etc. MS SQL is a worthy competitor on all counts.

      x64 and MS SQL 2005 - both of which we will be upgrading to in the coming months - will bring further scalability, supportability and performance improvements.

    Comment on This Answer

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.