Many window and door manufacturers use two independent programs for their daily work: Stolcad® Professional aimed to handle activities related to the production and quotation of constructions, and an ERP program aimed to monitor the company's inventory and financial statuses. Due to the fact that these two tools are separate, they do not share a common database, which could result in differences between the information in each of them. The ideal solution to address this challenge is to implement an individually adapted interface between the production program (Stolcad® Professional) and the warehouse and accounting program (ERP program).At the beginning of work on the integration, several important aspects should be established, which include, among others:
the data to be transferred between the programs
the direction of the communication (one or two-way)
the format of the transferred data
when and what operations should trigger the data exchange
The data to be transferred between the programs should be understood as the information determined by the manufacturer regarding orders, prices or specific recipients which should be automatically transferred.
In the case of the data transfer format, it is important to choose a method that will optimally transport information between the programs. The most popular choices are the use of SQL language or the choice of a traditional file form e.g.: XML or TXT.
The factor called direction of the communication determines how the data exchange should be proceed (one or two-way) and how many information flows should to be implemented.
The work on the interface is also greatly influenced by determing the moments or specific activities which should cause the data exchange, e.g. by manually clicking on a specific button in the program or automatically, after changing the established state or status.