cancel
Showing results for 
Search instead for 
Did you mean: 

What is the Procedure for loading Material master data from flat file toMDM

Former Member
0 Kudos

What is the Procedure for loading Material master data from flat file to MDM Repository or Import Manager?

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi Chiru,

In order to import flat files into MDM do the following. This solution is specific to MS Windows:

<b>I. Set up ODBC for *.txt or *.csv files</b>

1. Open Data Sources (ODBC) interface:

Start> Settings> Control Panel--> Administrative Tools -->Data Sources (ODBC).

2. Select System DSN Tab in Data Sources (ODBC) interface.

3. Click on [Add]. Select the Microsoft Text Driver. Click Finish.

4. Write a Data Source Name

5. Uncheck Use Current Directory to enable the [Select Directory…] button.

6. Click on [Select directory…] to determine the source directory.

7. Select the source file.

8. Click [OK] and return to the ODBC Text Setup screen.

9. Click [OK].

10. Return to the ODBC Data Source Administrator dialog and click [OK].

<b>II. Importing from Flat file</b>

1. Run MDM Import Manager.

2. Select ODBC from the Type drop-down field of the Connect To Source dialog.

3. Enter the DSN name from the Setup ODBC Connection dialog above.

4. Select the file name with extension (.csv or .txt) in the Tables panel of MDM Import Manager and the file content in the Records panel.

Hope this solved your problem.<b>Please mark helpful answers</b>

Regards,

Siddharth.

Former Member
0 Kudos

Hi Siddharth,

Long back I have done the way you have written step by step.. But i don't know why every time i use to get error "<b>The Configuration process failed</b>". Do you have any idea about this? Why am I getting such error?

former_member205403
Active Contributor
0 Kudos

Hi Chiru,

For loading a flat file , after connecting to repository u have to select type as "odbc" and specify the DSN.I am assuming that you know how to create DSN and specify the correct folder containing ur source files.

Now select the required source file and destination table and perform the required field and value mapping. And then perform match record step and execute import.

Hope this will help you.Let me know the result.

Thanks,

<b>Shiv Prashant Dixit</b>