I'm researching SQL Server or SAP HANA. Which is better?
It really depends on the purpose of usage. Both have strengths and limitations. SAP HANA is expensive especially when you try to integrate data from other sources than SAP systems. SQL Server (I believed you refer to MSSQL), is good for you to store application data. However, if you need big data analysis or advanced analytics, SQL Server may not be the best solution. The same goes for SAP HANA.
We all know it's really hard to get good pricing and cost information.
Please share what you can so you can help your peers.
I work for a healthcare company with less than 1,000 employees.
I am new to FileMaker Pro but my company uses FileMaker Pro (FM Pro) as the frontend development tool. More and more applications will be built using FM Pro.
In the long run :
1. Is FM Pro Embedded DB or MS SQL Server a better choice in the long run for the backend database?
2. What are the pros and cons of using these two databases if we must use FileMaker Pro as the front end tool?
3. If MS SQL Server has been chosen, will there be any compromise with FileMaker Pro on areas such as functionalities, features, programming methods, etc?
Thanks! I appreciate your help.