Microsoft SQL Server

A powerful data management system

The Microsoft SQL Server is a powerful data management system with an excellent cost benefit ratio. The SQL Server's relational database as well as the additional functionalities and services such as the business intelligence applications (OLAP, data mining, analysis and reporting) as well as the notification services, make it the ideal platform for the ERP system Microsoft Dynamics NAV.

Microsoft SQL Server and the ERP system Microsoft Dynamics NAV

Microsoft SQL Server The SQL Server is also attractive for smaller companies. One of its strengths: It grows in an optimal manner with its customer, which ensures a high degree of investment security. The ERP system Dynamics NAV and the SQL Server form a homogonous system that compliments each other, presents your business process in a comprehensive manner and stores all of your data centrally in one location.

Microsoft SQL Server: extensive security

The data management system meets the most stringent standards in regard to security. The structured management of access rights, the cyclical performance of maintenance plans and the regular backing up of data is ensured by means of powerful management programmes. The data exchange with third-party systems can be carried out in an event or time-controlled manner via various interface options of the integration services.

With prisma informatik you will have an experienced partner at your side, who has successfully completed various SQL server implementations, also with high user numbers and large data volumes.

Our utilisation examples of the Microsoft SQL Server:

Automatic delivery of evaluations (reporting services, analysis services, notification services)

Every Friday, always at the same time, the managing director receives pre-defined, representative reports on the weekly turnover figures of the company branches. The data is compiled by the ERP-System Dynamics NAV, processed and sent by e-mail. At the same time, the respective branch managers receive detailed product group statistics on the turnover in their respective branch (reporting and analysis services).

At a certain turnover amount the client receives a bonus. For this reason, you will be automatically informed by the data management system SQL Server three weeks before a bonus agreement ends, when you have not achieved your target yet. This creates an incentive to place corresponding orders on time (notification services).

Process and cache comprehensive evaluations

A production company continuously records all machine data, i.e. run-time, speed, load. This graphically presented information is managed together with the order data in the ERP system Dynamics NAV and is available on a long-term basis. By means of the reporting services of the SQL server, the machine data is processed at night and cached in corresponding reports. By means of this workflow, the performance of the actual system is not overloaded and the information is already available in the morning.

Scalable performance for growing data volume

A wholesaler initially works with 75 users. Due to the acquisition of a competitor he must now manage around 250 users with several thousand orders every day with his ERP system Dynamics NAV. Due to the scalability of the Microsoft SQL application and the SQL Server know-how of prisma informatik, the wholesaler can be flexibly supported during his expansion.