Unit processing makes it possible to meet any specific request for API consumption, data generation in an imposed format, injection of data into a MySQL database, placement of files on an FTP … etc.
Unit processing
Our approach to a configurable software package allows new needs to be taken into account without having to develop new features of the program itself, but simply by modifying the operating parameters.
This software package approach leads to the installation of the same program for all its users, which tests it on a large number of very different situations and thus guarantees its reliability, adaptability and maintainability. Maintenance functions are integrated into the program allowing an extremely fast resolution of problems that may still arise given the diversity of architectures involved in this type of solution.
Open Flux makes it possible to create a dialogue between several information systems.
To do this, it has its own database allowing to:
- Store the different settings of the folder.
- Store so-called “intermediate” data to allow visualization of the data conveyed before their integration into the recipient system, thus allowing the implementation of consistency checks or the entry, or even the automatic generation of new information not carried by the source system.
- Carry out any processing outside the perimeter of the connected information systems.
- Guarantee traceability of the treatments performed, especially in the event of an error to facilitate the diagnosis of the problem encountered. Through this own database, Open Flux makes it possible to configure a certain number of unit processes, then to organise them within a group of processes whose whole constitutes a flow. The different flows thus defined can then be categorized to group them according to the “theme” with which they are associated. There is no limit to the number of unit treatments or to the number of flows (groups of treatments) or their categorization.
Through this own database, Open Flux makes it possible to configure a certain number of unit processes, then to organise them within a group of processes whose whole constitutes a flow. The different flows thus defined can then be categorized to group them according to the “theme” with which they are associated. There is no limit to the number of unit treatments or to the number of flows (groups of treatments) or their categorization.
The different types of unit treatments are as follows:
- Access to the data of an information system by reading directly from a database or via an ODBC driver when the interfaced solution requires it (for example for Sage Line 100 in proprietary database).
- Sequential reading of data from one of the connected information systems to feed the Open Flux database, or vice versa of Open Flux data to feed an information system.
- Execution of an SQL query on data from the Open Flux database or on those of connected information systems.
- Import of external files (csv, xml, json, …) either into Open Flux or directly into one of the connected information systems.
- Export of data in files (csv, xml, json,…) either by reading Open Flux, or by reading one of the connected information systems.
- File transfer via FTP protocol up or down.
- Execution of a Web script by http protocol, with parameters passed in Post or Get mode.
Invocation of a Web Service by Soap protocol. - Running a local program with execution parameters.
- Various other processes such as deleting a file, zip/unzip files, etc.
All these unit processes have made it possible to configure connectors, for example between the following information systems (non-exhaustive list):
On premise
- Sage Line 100 proprietary base with ODBC kit to Prestashop 1.5,1.6, 1.7.x
- Sage Line 100 SQL Server to Magento 1.9.x, 2.x
- Sage SQL Server Line 100 with Business Objects to Prestashop 1.5,1.6, 1.7.x
- Sage to Shopify
- Sage to Pixisoft
- Sage to Woo Commerce
- EBP commercial management V18 to Prestashop
- EBP Open Line SME to OS Commerce
- EBP Open Line SME Line to Magento
- EBP Open Line to Shopify
- EBP to Woo Commerce
- Wavesoft with Shopify
- PMI
- Zeendoc to Sage 1000
- Zeendoc to Sage 100
- Docuware to Sage 100
- Creditsafe to Navision
- Creditsafe to Sage 1000
Cloud
- Cegid XRP Flex, Retail,
- Business Central
- SAP
- Zeendoc to SAP
- Zeendoc to Cegid XRP Flex
- Docuware to SAGE >X3