Skip to Content

Best operating system for Data Services? Best database for Data Services?

What is the best operating system for Data Services in terms of performance, least number of issues, and support from SAP? Is it Windows Server, Linux, Unix, etc?

What is the best database for Data Services to build repositories on in terms of performance, least number of issues, and support from SAP? Is it Sybase ASE, Microsoft SQL Server, Oracle, etc?

Thanks.

Regards,

Mel Calucin

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Mar 19 at 09:07 PM

    Best database? HANA!

    :)

    Add comment
    10|10000 characters needed characters exceeded

    • I think Dirk was joking but we do use HANA as a repository database for POCs and it works well. Over the past few years I have tried many combinations of Database and OS. What I usually advise now is to stick with a combination that is already supported in your organisation. Usually having good OS administration and dba skills available is more valuable than trying to find a specific combination that is better supported by SAP. Also if it’s possible to get a team that knows tomcat with the platform you’re choose that is useful too, assuming you are deploying without tomcat. This is particularly true if you want to configure scale out.

  • Mar 19 at 05:34 AM

    Former Member

    What is the best operating system for Data Services in terms of performance, least number of issues, and support from SAP? Is it Windows Server, Linux, Unix, etc?

    --If you are looking for easy administration then Windows Server. If you want a secure operating system then Linux or Unix server. Troubleshooting issues on a Linux or unix server will be a little challenging as you need to run commands and scripts on the server.

    What is the best database for Data Services to build repositories on in terms of performance, least number of issues, and support from SAP? Is it Sybase ASE, Microsoft SQL Server, Oracle, etc?

    --Inbuilt repository database which comes along with SAP Data Services is Sybase ASE. If you want you can go for SQL Server or Oracle or any other supported database as per the Product Availabilty Matrix guide

    Regards

    Arun Sasi

    Add comment
    10|10000 characters needed characters exceeded

    • Data Services performs well on Linux server, only you need is the help of a knowledgeable Linux Administrator. The administration part is little complicated.both Sybase ASE and SQL Server are easier to administer.