Import Data From an ODBC Through DIXF-AX 2012

Microsoft Dynamics AX 2012 Data Import/Export Framework provide the functionality to import data from an ODBC data source into Dynamics AX we will illustrate how to import data from MS SQL database into AX. First we will create sample database that contain some data. Then create an ODBC data source, I have table in AOT , Whose name is DataIMPTable, as below

Open Microsoft SQL Server Management Studio, create new table as like below and enter record
 Go to Control Panel > Administrative Tools >  Data Source (ODBC). 

Click Add to create New ODBC.
 Open AX then Go To DIXF > Setup > Source data format >

•  Click New
•  Enter the Data Source Name, Description then select ODBC from the Type List
•  From the DNS Type Select USer DNS
•  From DNS Location Select Client.

Go To Common > Processing group > Click new enter the Processing group Name, Description > Click Ctrl + S to save > Click Entities

. Enter Group name =S-OBDC , Description=S OBDC

Enter entity name = Data Imp Direct Table-2, Source data format=S_obdc enter sql query = select * from student Click Ctrl + S to save Click on Modify Source Mapping and map source and target fields as like

• 

Go To processing Group and select Group name and click on Get staging data

• 

Click on Run Button --- > Ok

• 

they give  message for inserted record as like below

• 
• Go to execution history for checking status

• 

Go to table and form and check data ,record inserted

•