Flat file formats

[Former Member]

What are the flat files formats accepted for import and export in mdm?

How MDM recognize the document type/mapping to perform of incoming file (file name, folder) ?

What are the flat file format for export (delimited, structured, XML) ?

Does MDM handle Header in a flat file (import and export) ?

Does MDM handle several line definition in a flat file (import and export) ?

[former_member205403]

Hi Joesph,

Here are answers to your questions:

<b>Ans 1--></b> As previously told by adhappan ,you can import data using import manager from the following formats:

Access--Means From microsoft access

Excel -- From an excel file

ODBC--this is generally used to import data from a flat file.BY flat file i mean to say a tab comma seperated "csv " file or a ".txt "file.

Port--to import data from a port .In mdm, port actually refers to a directrory

XML--from an xml file

XML Schema-- this is used when you try to import data from a file whosr structure you have predefined in console using an xsd file.

<b>Ans 2--></b> we specify the file format while connecting to source by mentioning it in the <b>type</b> properties.and mapping is performed in the import manager in the map value tab.

<b>Ans 3--></b>When you import or export a flat file then data in the first line of file is considered as header.

<b>Ans 4 --></b> As i previously told ,MDM will handle header.

<b> Ans 5 --></b>MDM does not handle several line definition of header.

Hope it will help you.<b> Please remark if it really helped you</b>.

Thanks,

<b>Shiv Prashant Dixit</b>

[Former Member]

MDM Import Manager supports the following types of source formats:

Access

Excel

ODBC

Direct Connection to Oracle database

Port

SQL Server direct connection

XML

XML Schema.

Syndicator supports XML and Text file format

For import of flat files into MDM

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/5deafa96-0d01-0010-d982-abbcddeb...

Hope this helps,

Please mark helpful answers