SAP Business ByDesign vs. Microsoft SQL Server

Do you plan on going public at some point? If so, this may not be the best solution for you

Incentivized

Microsoft SQL is ubiquitous, while MySQL runs under the hood all over the place. Microsoft SQL is the platform taught in colleges and certification courses and is the one most likely to be used by businesses because it is backed by Microsoft. Its interface is friendly (well, as pleasant as SQL can be) and has been used by so many for so long that resources are freely available if you encounter any issues.

Incentivized

• I like the ease of use and the implementation methodology.
• With SAP Business ByDesign you can integrate other systems with Web Services, and data technology to get information easy and fast.
• SAP Business ByDesign includes an Analytics Module to create new reports in regards to your needs.

• Easy to configure and use with Visual Studio and Dot Net
• Easy integration with MSBI to perform data analysis
• Data Security
• Easy to understand and use
• Very easy to export database and tables in the form of SQL query or a script

Incentivized

• Time off request could be better. Right now, there is no option for sick time
• It crashes often
• Customization could be better

Incentivized

• Microsoft SQL Server Enterprise edition has a high cost but is the only edition which supports SQL Always On Availability Groups. It would be nice to include this feature in the Standard version.
• Licensing of Microsoft SQL Server is a quite complex matter, it would be good to simplify licensing in the future. For example, per core vs per user CAL licensing, as well as complex licensing scenarios in the Cloud and on Edge locations.
• It would be good to include native tools for converting Oracle, DB2, Postgresql and MySQL/MariaDB databases (schema and data) for import into Microsoft SQL Server.

Incentivized

SAP BYD work centers are consistent and easy to navigate once you understand one work center. The document flow tab that is in each window allows one to see all related transactions. Document flow is important because one is able to see the flow of transactions and can therefore reverse transactions by following the document flow in reverse. It is possible to group items in each overview screen to see what items are open. The system is working as hoped.

Incentivized

We understand that the Microsoft SQL Server will continue to advance, offering the same robust and reliable platform while adding new features that enable us, as a software center, to create a superior product. That provides excellent performance while reducing the hardware requirements and the total cost of ownership of our solution.

Incentivized

Because SAP Business ByDesign allows us to improve our work, reduce the operational steps, implement audit controls, allows us found standard reports or it allows us to create new ones if you need more than the exists are enough for your work or your needs. Overall, SAP Business ByDesign allows us to standardize our operations, enhance our work, improve our skills, work over a web environment or mobile interface.

SQL Server mostly 'just works' or generates error messages to help you sort out the trouble. You can usually count on the product to get the job done and keep an eye on your potential mistakes. Interaction with other Microsoft products makes operating as a Windows user pretty straight forward. Digging through the multitude of dialogs and wizards can be a pain, but the answer is usually there somewhere.

Incentivized

Its does not have outages.

Incentivized

SSAS data cubes may some time slow down your Excel reports.

Incentivized

The Business ByDesign support is stablished since you contract the service with SAP. SAP resolves according to the service level agreement. Currently, we continue with the service and we are using the support channels available. We are receiving the support. The SAP support gets an incident and after that, they contact us to resolve the incident, if necessary, they set the meeting to understand it or we explain the incident

We managed to handle most of our problems by looking into Microsoft's official documentation that has everything explained and almost every function has an example that illustrates in detail how a particular functionality works. Just like PowerShell has the ability to show you an example of how some cmdlet works, that is the case also here, and in my opinion, it is a very good practice and I like it.

Incentivized

It was good

Incentivized

very hands on and detailed training

Incentivized

I recommend implementing all workshops during the ERP selection that you need to know very well about the ERP software. It allows us to gather information to accurate the plan of the project implementation. Additionally, we must reach the high-level commitment to achieve the main goals, to define the RACI matrix and communicate to all project stakeholders.

Other than SQL taking quite a bit of time to actually install there are no problems with installation. Even on hardware that has good performance SQL can still take close to an hour to install a typical server with management and reporting services.

Incentivized

ByDesign stacks up well against the competition. Companies that do multiple things are usually the best fit (manufacturing, distribution, and service). The more 'modules' used, the fewer competitors will be able to meet the company's needs. It is not inexpensive, but if the needs of the company have the complexity from either a global perspective and need localizations and foreign currency, or a volume perspective and need resources greater than what can be easily housed on-premise, ByDesign should be a top consideration.

Incentivized

[Microsoft] SQL Server has a much better community and professional support and is overall just a more reliable system with Microsoft behind it. I've used MySQL in the past and SQL Server has just become more comfortable for me and is my go to RDBMS.

Incentivized

SQL server does handle growing demands of a mid sized company.

Incentivized

• Positive - Access to the real-time reporting allowing for faster decision making especially when fixed price projects are heading into an over budget position.
• Positive - Complex KPI can now be tracked and as a consequence intensive plans can be made to capitalise on this level of reporting. Staff also have clear visibility over their own performance.
• Negative - We are a bit on the small side at 30 employees for a ByD solution so it was relatively expensive for us. It would be a much better value preposition above 50 employees.

• Increased accuracy - We went from multiple users having different versions of an Excel spreadsheet to a single source of truth for our reporting.
• Increased Efficiency - We can now generate reports at any time from a single source rather than multiple users spending their time collating data and generating reports.
• Improved Security - Enterprise level security on a dedicated server rather than financial files on multiple laptop hard drives.

Incentivized