Where it is needed to go beyond the boundaries of Dynamics Ax it is suggested that partners and customers to use of the Axnosis SIM. SIM attempts to standardize on interfaces to/from Ax.

The principles of SIM:

Firstly, integration points are identified. These are configured in a Base enum. These enums are used and a mapping is done against these integration points. This mapping maps the external table fields to a corresponding table inside Ax.

Secondly a T-SQL statement is linked to each integration point. These SQL statements are used when the actual integration job is executed. The heart of SIM is that normal SQL statements are entered into the Dynamics Ax SIM form. SIM translates this SQL statement into native X++ without any user involvement.

Thirdly an Integration class is used when the integration is executed either manually or scheduled.

Fourthly, with the relevant data in Ax, populated from an external source Ax can now use this data accordingly. E.g. with the Symplexity interface, information in the “AxnSymGLIT” table is used to automatically create GL journal entries for the payroll.

Finaly, depending on the 3rd party application being interfaced with, it is possible to write data from Ax into tables of the 3rd party application.

The current application of SIM includes: A2L – Ax to Labware LIMS A2S – Ax to Symplexity A2P – Ax to Pragma A2M – Ax to PIMS A2V – Ax to VIP