coresystems Delivers Mobile ERP/CRM Solutions with EDB Postgres in the Cloud

Success Story

Coresystems AG is the world leader in standardized additional solutions for SAP and Microsoft ERP and CRM applications. For nearly 10 years, Coresystems has set new standards through innovative cloud and mobile solutions creating real added value for over 5,000 customers. Coresystems provides economically priced, easy-to-use solutions using state-of-the art technology and known standards.

Coresystems Coresuite Mobile makes company data available on smart phones, tablets, and laptops. This enables Coresystems customers to provide convenient access to data for mobile sales and service personnel without additional expensive ERP licenses. No additional infrastructure is required for synchronization via Coresuite Cloud, and the solution can be provisioned quickly with monthly subscriptions.

Synchronized Data in the Cloud

Coresuite Cloud operates as middleware in the cloud to communicate between an organization's ERP or CRM system and their mobile users. Synchronization is performed between the ERP/CRM system and a database, which supports mobile applications running on smartphones, tablets, and laptop computers. A reliable and performant database is critical to successful operations and providing the most accurate information to field personnel.

Coresystems' operating system vendor originally recommended the use of Ingres but several issues and challenges necessitated a move to another database.

"Where Postgres was a big step ahead was in the area of development and administration tools," said Yves Senn, Chief Technology Officer for Cloud Development at Coresystems. "StackBuilder simplified adding the modules we needed and the ease with which we could manage multiple servers and databases was a big plus."

Coresystems elected to switch from Ingres to EDB Postgres® Advanced Server from Enterprise® (EDB™) and has never looked back. Installation was simple and they were up and running quickly without any complicated tuning required.

Successful Implementation

Coresystems’ offering runs in the cloud using Linux on Amazon Web Services and is a full Java EE application using Red Hat® JBoss® and Hibernate. The development and administration tools included with EDB Postgres were superior to those with Ingres. The management of database servers and numerous databases within a single server was straightforward. The EDB Postgres Query Analyzer was particularly useful, offering features and capabilities that equalled or exceeded those from proprietary database vendors.

Coresystems made use of EDB's support services and was impressed with the timely and help responses received. The company also employed an EDB Architectural Health Check service, ensuring their system was optimally configured and tuned.

Successful Deployment

Running on Amazon Web Services in two data centers, Coresystems creates a new database for each customer to ensure data is secure. Up to 700 databases may be running in one Amazon large instance. A database for managing users, subscriptions, and other metadata is also present.

As a cloud-based solution, quick and easy provisioning is imperative and EDB Postgres' simple installation and configuration coupled with easy-to-use tools from Amazon avoided extra implementation costs. Provisioning was fully automated with a simple sign-up form and download of the easy-to-install connector, all of which could be performed in less than 20 minutes.

Current expected load is up to 200K users, each performing several synchronizations each day. This volume was to be easily handled with EDB Postgres.

Future plans included using EDB Postgres Advanced Server replication to perform streaming replication between instances in different regions within a data center to provide increased uptime and reliability.

With EDB Postgres Advanced Server, Coresystems was well positioned to meet its database needs for the future.