MS SQL, or Microsoft SQL Server, is a relational database system used for enterprise applications and databases such as ERP or CRM systems. It is compatible with many programming languages and is often integrated with other Microsoft products.


Did you find out anything new?
Share on social media

Where have we used MS SQL?

Take a look at the examples

SEND Předplatné

Magazine Subscription Management Software

The new web application automates a number of key processes of the subscription service. The collection of subscription orders is solved by API integration with external systems of client companies. The application processes received orders and displays them in the user environment, where orders can be further managed or exported for carriers in CSV import files. The application then continuously obtains the status of the shipment from the delivery service and updates it. It is also connected to the warehouse management (Helios) and the system checks the stocks, which are regularly sent to FTP client publishers. Although the core processes take place in the background and the user interface is used primarily for data viewing and bulk imports and exports, the application can edit individual orders if necessary.


Call Center Management System

The CC3 web application is used by call center operators as well as LeasePlan employees, who also deal with car repair shops, insurance companies etc. Each user is assigned a role that determines the level of user permissions. Request processing is easier due to integration with other systems and a number of automatic actions, such as notifications related to individual tasks, recording of communication, or sending request emails to car repair shops. In addition to the service locator, the CC3 also communicates with the main vehicle registration system. Clients who need a replacement vehicle, a service or to resolve an insurance claim can be identified very quickly using the registration number and other data. The user interface of the application is based on the previous internal system. The transition to the new software was really easy for the users. The application is also open for further upgrades in the future. The main goal was achieved while meeting all the requirements – speeding up the application. The use of newer technologies, such as AJAX, plays a significant role in this. Thanks to asynchronous communication, the new application does not redraw the entire page, but only certain elements of the user interface.

Peugeot, Citroën, Invenias

Migrating data to a new environment

With our help, you will find the implementation and transition from your existing information system to the new one easy. Thanks to our experts and their experience, we will plan and implement a fast and safe data migration for you. We can retrieve and understand the necessary data from the legacy system. We will then cleanse the acquired data of errors and any flaws, such as missing zip codes for your customer’s address. We also remove duplicate data and related inconsistencies. We ensure that no data is lost or corrupted when data is transformed between two systems, as any subsequent correction in the new information system can be very complicated.