PostgreSQL (alternately Postgres) is a free and open source object-relational database system boasting over 30 years of active development, reliability, feature robustness, and performance. It supports SQL and is designed to support various workloads flexibly.
N/A
SAP Business One
Score 8.3 out of 10
N/A
SAP Business One is an integrated enterprise resource planning (ERP) solution for small and medium-sized businesses, The product encompasses functionality around sales, customer relationships, inventory, operations, financials and human resources.
PostgreSQL is best used for structured data, and best when following relational database design principles. I would not use PostgreSQL for large unstructured data such as video, images, sound files, xml documents, web-pages, especially if these files have their own highly variable, internal structure.
SAP Business One would be more useful if it contained tools to acommodate the growing need of online sales. A more complete shipping module which handles tracking numbers with the common couriers would be great. A built in warehouse management system would be great designed to be used with barcode scanners
Following a bench mark process - this seems contradicting to flexibility however we have wished we could follow more of an industry benchmark. Our challenge as a small company has been knowing how to properly use the system. We have discovered that we have set up the system wrong based and are using it improperly which has cause a lot work to correct.
Better live reporting options - current we are on prem SQL. Yes SAP is moving to HANA however smaller companies like ourselves are not ready for that. We need to be able to maintain our existing SQL DB. We also have a demand for live BI Reporting. It has been difficult to do this with our current set up.
Error handling - have found it very difficult to troubleshoot. Errors are not always clear and answers are hard to find.
As I said before, it is a first level tool, well developed, and with very strong development support, although the learning curve, its implementation, the cost-benefit ratio, the price and the user experience is not the most suitable for small and medium-sized companies. It is a company with extensive experience, market positioning, technical support and expanded use
Postgresql is the best tool out there for relational data so I have to give it a high rating when it comes to analytics, data availability and consistency, so on and so forth. SQL is also a relatively consistent language so when it comes to building new tables and loading data in from the OLTP database, there are enough tools where we can perform ETL on a scalable basis.
I would like to give 8 out of 10 rating for SAP Business One because SAP Business One is a good choice for the mostly used business management solutions for the small and medium-sized companies. SAP Business One can help in optimizing the existing business process and enables streamline business processes for the daily activities for all users across the entire organization. The importance realization of SAP Business One implementation is based on the selection of the good reputation partner and its approach for the entire implementation. SAP Business One is a user-friendly and easy to use Enterprise system that the organization can benefit its features and functionalities by utilizing it.
The SAP Business One software is up and running every time you need it as it was planned. In more than 6 years that we have been using the product, it has never been unavailable and if it ever was, it was because of a planned maintenance window scheduled in the company.
The data queries are relatively quick for a small to medium sized table. With complex joins, and a wide and deep table however, the performance of the query has room for improvement.
SAP Business One performance depends mostly on the speed of your internal servers, should you have the solution on premise as we do. Sometimes the system tends to be a little slower for some users when others are executing really big reports of performing some batch loads, but generally, the performance is acceptable to all the users.
There are several companies that you can contract for technical support, like EnterpriseDB or Percona, both first level in expertise and commitment to the software.
But we do not have contracts with them, we have done all the way from googling to forums, and never have a problem that we cannot resolve or pass around. And for dozens of projects and more than 15 years now.
I rate my experience with SAP Business One's support team as excellent (10). They are easy to contact and effortless to work with on any issue or concern. I like the support SAP provides for any of their products. SAP has a great backing and I would recommend them to any of my colleagues.
The training I get was a consultant level training, so it's basically a 6 weeks training covering every aspect and every module of the system. It covered most common use cases and exercise training so you can get along with the software, as well as examples so there culd be a better understanding.
The online training is request based. Had there been recorded videos available online for potential users to benefit from, I could have rated it higher. The online documentation however is very helpful. The online documentation PDF is downloadable and allows users to pace their own learning. With examples and code snippets, the documentation is great starting point.
Over the past two years SAP has added a great deal of new SAP Business One on-line training for version 9.0 and 9.1. Most of the training is very strong, but some is difficult to understand and follow. Additionally, SAP still has a few holes in their on-line training around Production, Bill-of-Materials, MRP and Service.
These implementations are not easy. Even a standard implementation can be difficult. With a never-been-done-before implementation, the implementation team and the user team need to be thorough with planning, make a decision on key points, and stick to them before any design happens. Our biggest challenge was not from StellarOne, rather it was from the mid-implementation decisions from our internal team. StellarOne did a great job warning us, implementing our decision, and then helping us adjust our SAP to handle the new direction we took.
Although the competition between the different databases is increasingly aggressive in the sense that they provide many improvements, new functionalities, compatibility with complementary components or environments, in some cases it requires that it be followed within the same family of applications that performs the company that develops it and that is not all bad, but being able to adapt or configure different programs, applications or other environments developed by third parties apart is what gives PostgreSQL a certain advantage and this diversification in the components that can be joined with it, is the reason why it is a great option to choose.
SAP provides the most robust solution, with modules available for all department managers and even options for customization according to the company's special needs. We especially used the Crystal reports options to provide reports for each module. Overall, even if it's not the least expensive option, it has the best value for money.
For most small businesses, the only way you outgrow SAP Business One is if the nature of your business changes radically. Going from 1 to 50 users is quite easy with SAP B1. Going beyond 50 may require moving to the Hana SAP B1 platform to maintain or improve performance, but the path is there. Add-ons to SAP B1 can also be added as specific needs are encountered that are not closely met by the standard product. These may be required early in the product life because of the nature of your business, or as you expand the use of SAP B1.
Easy to administer so our DevOps team has only ever used minimal time to setup, tune, and maintain.
Easy to interface with so our Engineering team has only ever used minimal time to query or modify the database. Getting the data is straightforward, what we do with it is the bigger concern.
Employee efficiency has definitely increased with SAP Business One. This is attributed in a lot of ways to information visibility. Our employees are able to gather the data they need, quickly, and effectively.
Identifying inconsistencies in pricing has also been accomplished through use of reporting off individual tables. Previously, we weren't able to access our data in such a way as to enable us to write custom reports in-house.
We have also benefited greatly from having a single source of all business information. We utilize SAP Business One exclusively in-house. All documentation is attached to specific orders and Business Partners, as well as serialized equipment that has been sold.
