Skip to Content
0

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

Mar 17 at 09:46 AM

93

avatar image

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Dirk Venken
Mar 19 at 09:07 PM
2

Best database? HANA!

:)

Show 3 Share
10 |10000 characters needed characters left characters exceeded

hahahah :)

0

I would think that the use of HANA would be overblown. Would a in-memory columnar database really be the best choice to build BODS repositories on?

0

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.

1
Arun Sasi Mar 19 at 05:34 AM
1

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

Show 2 Share
10 |10000 characters needed characters left characters exceeded

I agree with the easy administration of the Windows environment.

In terms of performance, does Data Services perform much better on Linux?

Are there less issues and bugs with Data Services on Windows than on Linux?

Is Sybase ASE harder to administer and configure than MS SQL Server?

Thanks.

0

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.

0