MaxiSun is an interface system between Infor SunSystems/SAP Business One/other ERP systems and other third party business applications. The original MaxiSun software was developed to integrate Maximo and SunSystems, in 2001, by Sapphire Systems. Early versions of the software were very “ black box ” systems in that there was very little that could be modified by the client after the installation had taken place.
There were always two main components comprising the system, the data extraction component and the data conversion component. In the first version of the system the data extraction component was an SQR script authored originally by MRO software for Sapphire. The data transformation engine was originally authored by Sapphire in Visual Basic.
Since the early days MaxiSun has been modified to make it more capable of being configured by the client. The SQR extraction tool has been replaced with a dedicated program called Origin and the MaxiSun data conversion engine gained the benefit of a user interface that allowed the source and destination files to be mapped at field and line level.
These mapping settings needed a dynamic storage facility so this was created using a Microsoft Access database initially, later upgraded to SQL Server.