Infor M3 (Movex) Adapter

This adapter simplifies extraction of data from Infor M3, an ERP system previously known as Movex.

Adding a Movex/M3 adapter

1. Open a business unit, right click Data Sources, click Adapter Data Sources and then click Add Movex/M3 Adapter. The Add Movex/M3 Adapter window opens.
   
   
2. Click the database type of your M3 installation. You have the following options:
   • DB2
   • Oracle
   • Microsoft SQL Server
3. Click OK.
4. The standard window for adding a data source of the type you chose opens. Enter the connection details. See Adding a DB2 Data Source, Adding a Oracle Data Source and Adding a SQL Server Data Source for more information.
5. Right click the M3 data source you just added and click Change System Schema. The Setup System Schema window opens.
   
   
6. Type the environment schema name in the Name box.
7. In the Available Objects list, click None to make no tables available for use in the project, Company Tables Only to make only tables from the chosen company available or All Tables and Views to make every table and view in the M3 database available. ClickOK.
8. Right click the M3 data source and click Setup Accounts. The M3/Movex Accounts windows opens.
   
9. Select the companies and divisions to include by checking the box in the Use column. Click OK.