Import the Dynamics AX Adapter

Overview

The Dynamics AX Adapter is required for AX 4.0, AX 2009, AX 2012 ERP systems and allows the Jet Data Manager to read the needed objects used by the Jet Data Manager that pertain to the metadata that is stored in Dynamics AX. The Dynamics AX Adapter must be imported and executed in order for the Jet Data Manager to properly synchronize with the Dynamics AX database.

Process

During the installation, you will need to import our adapter objects into the Dynamics AX database. The Jet Analytics AX Adapter object must first be downloaded with the Jet Analytics software from the insightsoftware website here. The objects will reside in the .xpo file in the ZIP folder under 1 - Jet Analytics- REQUIREDAfter downloading and extracting this software follow the steps below. In order to import these objects, you will need to access the following environments with "admin" permissions.

1. Start AX and open the Projects window (CTRL+SHIFT+P)

2. Click Import (CTRL+SHIFT+I)

3. Click “Browse” and locate the Jet Analytics AX Adapter v4.4.xpo file from the Download file.  (This is located within the Server Components folder)

4. Make sure that Import with ID values is unchecked Click OK to start the import.  After the import, the project is compiled The compiler output should show No Errors, No Warnings, No Best Practice Deviations and No Tasks.

   Importing the AX adapter creates the following objects inside the AOT:

   One AX Project:

   1. TIMEXTENDERADAPTER_V330_AX****

   Four AX Classes

   1. TIMEXTENDERENUMS
      • This class is responsible for reading all of the ENUM values in Dynamics AX and storing them in the TIMEXTENDERENUMTABLE table
   2. TIMEXTENDERRELATIONS
      • This class is responsible for reading the relationships between tables within Dynamics AX and storing them within the TIMEXTENDERRELATIONSTABLE table
   3. TIMEXTENDERTSCHEMATABLES
      • This class is responsible for reading the table schema within the database. In addition, data types for table columns are read. All of this information is then stored within the TIMEXTENDERTABLESCHEMA table
   4. TIMEXTENDERVIRTUALTABLES
      • This class is responsible for reading all of the virtual tables within Dynamics AX and storing the table and field list within the TIMEXTENDERVIRTUALTABLE table

   Four AX Tables:

   1. TIMEXTENDERENUMTABLE
   2. TIMEXTENDERRELATIONSTABLE
   3. TIMEXTENDERTABLESCHEMA
   4. TIMEXTENDERVIRTUALTABLE

   

   Removing the AX objects listed above will delete the Jet Data Manager Adapter used to read the AX data source. If it shows errors or warnings, recompile the project.

5. Open the Projects window again(CTRL+SHIFT+P).

6. Locate the project called TimeXtenderAdapter_V44_<AX Version> and open.

7. Right click the first of the Classes and select Open

8. Click OK to run the class immediately.

   Note: Some classes will take minutes to run.

9. Repeat the previous two steps for the other three classes in the project