Software that already provides many essential functions has the advantage that the standardised data pool avoids duplicate data storage and interfaces are not required. But even with such so-called integrated software, it is sometimes necessary to fall back on other software solutions. In this case, the interfaces are essential for the smooth running of all software functions. The right interface concept is particularly important here.
At the beginning is the interface concept
Programming an interface is not that difficult with the right preparation. This is usually based on an interface concept, which fields there are and what they contain (e.g. data type, field length or number of decimal places). The interface description also shows which file format is used for the exchange (mostly .csv or .xml). The entire conceptualisation of the interface should be well documented. In particular, the data concept and operation must be explained so that it enables other users to use or extend the interface. In this way, every new user can understand how to use the interface.
How the interfaces exchange the data
It is also possible to import the data directly into the Database of the other software. However, there is always a risk that users will not be able to work in the software that receives the data because the tables are blocked. It is therefore better if the data exchange is processed via a "clipboard". The software then retrieves the data to be received when the workload permits.
Interface monitoring
With "simple" interfaces, data can be exchanged quickly between two software solutions. However, there is usually little transparency for the user regarding the transferred data. Possible transmission errors are not noticed. In this case, interface monitoring becomes necessary.
This can be used to log the entire data transfer. Transmission errors are displayed or smaller data transfers - in the event of incorrect data - are cancelled. In either case, these data records can be corrected manually. The user can also delete entire data transfers and carry them out again.
Compared to the "simple" interfaces, the development of interface monitoring is quite complex. It is therefore worthwhile if an appropriate tool is already available for the software as a add on is available or is integrated in the standard system.
Shopware 6 for SAP Business One
SAP Business One and DATEV - Synchronised
DATEV and SAP Business One Export & Import
Electronic invoices to authorities
SAP Business One Connect for carriers
