Import from SQL database

GIRITON can be integrated with any SQL or MDB database located in the client's internal network.

In this way, it is possible to automatically synchronize, for example, HR or a list of Projects from an ERP, accounting or payroll system into GIRITON, if such a system has data stored in a SQL or MDB database.

So when you add a new Employee into your payroll system, it will be automatically transferred to GIRITON in a moment.

Install the ProxyAgent app

The connection between GIRITON and the database in the client's internal network is ensured by the ProxyAgent application. Install it on a PC in your internal network, from which you can connect to your SQL or MDB database.

Add a Planned task

In the GIRITON web application, go to Menu user -> Administration -> Planned tasks -> Add -> "Import from SQL database".

The system prompts you to enter information such as: which agenda of Giriton will we imported into (Human Resources, Projects, ...), through which ProxyAgent will we connect to the database (see the step above) and login credentials into the database.

In the next step, you enter an SQL command to select the necessary data from the database. GIRITON already offers SQL commands for some well-known ERP and payroll systems, but you can enter your own command.

Subsequently, GIRITON will show you what will be the result of the import according to your settings. That is, how many records will be added, how many will only be updated and how many will be skipped without change. If you confirm everything a new scheduled task will be saved with the settings you made. The data import itself will not take place at this time.

You can start a scheduled task for importing data from the SQL server either manually by selecting a specific scheduled task in the User menu - Configuration - Planned tasks and clicking on "Execute manually". If you want the scheduled task to start automatically every 10 minutes, turn on the "Active" option for it and save the changes.

Other Accounting, Payroll, and ERP Systems

In most cases, accounting and ERP systems use some form of SQL database. Whether it is a Microsoft SQL server, MySQL server, SQLite, PostgreSQL server or an MDB file from MS Access, the GIRITON system can connect to such database and import data from it.

You will always need both the login data for this database and then create the correct SQL query that will return the data in the required format, with the fact that we already have everything pre-prepared and preset for accounting software. From a security point of view, it is ideal to create a user in the SQL database who has "readonly" permissions, i.e. who can only read from the tables, not write to them.

Other types of SQL databases

The vast majority of ERP and payroll systems use one of the already supported SQL databases. However, it may happen that your ERP or payroll system uses an SQL database that is not yet supported. How to proceed in such case? Let us know the type and version of your SQL database, for example "SQL Anywhere" version 16 and we will add support for this database.