BODS Data Extraction

[Former Member]

Hello,

We want to extract data from files which are in format DOC/DOCX/PDF/XLS/XLSX.

Please help me know if at all we can extract or extraction is limited to structured and unstructured text files only.

If at all this can be achieved by some custom coding or using SAP LT? We want to extract, transform and load into HANA. Is there any other way?

Thanks,

Pradeep

[vnovozhilov]

Hi Pradeep,

In a batch job, a source can be a table, an SAP application table, a previously defined template table, a file, an XML file, an IDoc file, ABAP data flow, or an SAP extractor.

In a real-time job, a source can be a table, an SAP application table, a previously defined template table, a file, an IDoc file, an XML file, an IDoc message, or an XML message. Each real-time job must have exactly one real-time data source—either an IDoc message or an XML message.

So from the formats required only XLS is supported natively.

Thank you,

Viacheslav.