Enterprise resource planning (ERP) system data extraction, loading, and directing

• US 9,953,070 B1
• Filed: 10/14/2015
• Issued: 04/24/2018
• Est. Priority Date: 04/05/2015
• Status: Active Grant

• Current Assignee: Simply Data Now Inc.
• Original Assignee: Simply Data Now Inc.
• Inventors: Hankins, Richard Ruel Kenneth, Thorson, Joel David, Padmanabhan, Prashanth Krishnan
• Primary Examiner(s): Hoffman, Brandon S
• Application Number:
  US14/883,528
• Time in Patent Office: 923 Days
• Field of Search: None
• CPC Class Codes: G06F 16/254 Extract, transform and load [ETL] procedures, e.g. ETL data flows in data warehouses
• CPC Class Codes: G06F 21/6245 Protecting personal data, e.g. for financial or medical purposes

Abstract

An enterprise resource planning (ERP) system data extraction, directing, and loading (EDL) method, system, application, and computer program is disclosed having a Data Export Workbench (DEW) application and Data Integrator (DI) application operating within an ERP system environment. The EDL method and system can use existing hardware systems to quickly and efficiently extract, direct, and load any user requested data from an ERP system to predefined and controlled destinations that can be widely accessed by one or more users.

Claims

1. A method of extracting data from an enterprise resource planning (ERP) system and directing the extracted data to one or more end user destinations, the method comprising:

receiving mounted file system data, wherein the mounted file system data further identifies a mounted file system server directory;

receiving destination data, wherein the destination data is comprised of a target file server or a target database;

writing the mounted file system data and destination data to a control file;

receiving profile data, wherein the profile data references the destination data, wherein the profile data is further comprised of requested data and an authorization request, and wherein the requested data is comprised of one or more ERP data tables or ERP data fields;

pinging the mounted file server directory in order to detect the received profile data;

in response to detecting the profile data, determining the destination data from the profile data;

authorizing the profile data in response to the authorization request;

extracting the requested data from one or more ERP databases;

transmitting or loading the extracted requested data to the target file server or target database identified in the destination data; and

transmitting the extracted data from the target file server or target database to a user terminal.

2. The method of claim 1, further comprising receiving a request for new profile data creation and receiving new ERP data tables or fields for the requested data.

3. The method of claim 1, further comprising requesting authorization and activation of the received profile data from a system administrator.

4. The method of claim 3, further comprising in response to authorization, activating the profile data.

5. The method of claim 1, wherein the requested data is further comprised of one or more ERP tables filters and net changes.

6. The method of claim 1, wherein the profile data further comprises execution schedule data.

7. The method of claim 1, wherein the profile data further comprises priority data.

8. The method of claim 1, wherein the profile data is defined within a first portal operating on a first server, and the destination data is defined within a second portal operating on a second server independent of the first server.

9. A computer program product for extracting data from an enterprise resource planning (ERP) system and directing the extracted data to one or more end users, the computer program product comprising a non-transitory computer readable medium having program instructions embodied therewith, the program instructions executable by a computing device to cause the computing device to:

receive, by the computing device, mounted file system data, wherein the mounted file system data further identifies a mounted file system server and directory;

receive, by the computing device, destination data, wherein the destination data is comprised of a target file server or a target database;

write, by the computing device, the mounted file system data and destination data to a control file;

receive, by the computing device, profile data, wherein the profile data references the destination data, wherein the profile data is further comprised of defined requested data and an authorization request, and wherein the requested data is comprised of one or more ERP data tables or ERP data fields;

ping, by the computing device, the mounted file server directory in order to detect the received profile data;

in response to detecting the profile data by the computing device, determine the destination data from the profile data;

authorize, by the computing device, the profile data in response to the authorization request;

extract, by the computing device, the defined requested data from one or more ERP databases;

transmit or load, by the computing device, the extracted requested data to the target file server or target database identified in the destination data; and

transmit, by the computing device, the extracted data from the target file server or target database to a user terminal.