SAP SE
EXTRACTING AND POSTING DATA FROM AN UNSTRUCTURED DATA FILE

Abstract:

Disclosed herein are system, method, and computer program product embodiments for extracting and posting data from an unstructured data file to a database table. In an embodiment, a server receives a request to extract and post data from an unstructured data. The server extracts the data from the unstructured data file. The server identifies a set of columns from the structured format of the extracted data. Each column of the set of columns corresponds with a set of data elements from the extracted data. The server identifies a pattern of a set of possible patterns corresponding with each column of the set of columns. Furthermore, the server maps each column of the set of columns with a database column. The server stores each set of data elements of each respective column in the respective database column.