# US 2019/0171749 A1 · Data integration framework for multiple data providers using service url

> Agents: this data is available as JSON from the patentgrep API and MCP server — see https://patentgrep.com/llms.txt

- Number: US 2019/0171749 A1
- Document ID: US20190171749A1
- Status: Published application
- Kind: A1
- Application number: 15/830,276
- Filed: 2017-12-04
- Published: 2019-06-06
- Earliest claimed: 2017-12-04
- Assignees: Sap SE
- Applicants: Sap SE
- Inventors: Vinutha Yediyur VaradarajaIyengar; Mayank Manchanda
- Web page: https://patentgrep.com/patent/US20190171749A1

## CPC

- G06F 16/254: {Extract, transform and load [ETL] procedures, e.g. ETL data flows in data warehouses}
- G06F 16/2379: {Updates performed during online database operations; commit processing}
- G06F 16/2455: Query execution
- G06F 16/256: {in federated or virtual databases}
- G06F: ELECTRIC DIGITAL DATA PROCESSING (computer systems based on specific computational models G06N)

## Abstract

A method and system are provided including a mapper module; a display; a memory storing processor-executable steps; and a mapper processor coupled to the memory, and in communication with the mapper module and operative to execute the processor-executable process steps to cause the system to: receive a link to a first data source, wherein the first data source is an external data source; parse data stored at the first data source; generate a mapper table based on the parsed data, wherein the mapper table includes at least one external data field associated with the parsed data; determine at least one target data field in a second data source, wherein the target data field corresponds to at least one external data field; map the at least one determined target data field to the corresponding external data field in the mapper table; and access the mapper table with an application during execution of the application. Numerous other aspects are provided.

## Claims

### Claim 1

A system comprising:
a mapper module;
a display;
a memory storing processor-executable steps; and
a mapper processor coupled to the memory, and in communication with the mapper module and operative to execute the processor-executable process steps to cause the system to:
receive a link to a first data source, wherein the first data source is an external data source;
parse data stored at the first data source;
generate a mapper table based on the parsed data, wherein the mapper table includes at least one external data field associated with the parsed data;
determine at least one target data field in a second data source, wherein the target data field corresponds to at least one external data field;
map the at least one determined target data field to the corresponding external data field in the mapper table; and
access the mapper table with an application during execution of the application.

### Claim 2 (depends on 1)

The system of claim 1, wherein the link is a Uniform Resource Locator (URL).

### Claim 3 (depends on 1)

The system of claim 1, wherein parsing further comprises processor-executable steps to cause the system to:
request at least one of one or more data fields and one or more data elements from the first data source.

### Claim 4 (depends on 3)

The system of claim 3, wherein generating the mapper table further comprises processor-executable steps to cause the system to:
import the external data field of each data element provided by the first data source to the mapper table.

### Claim 5 (depends on 1)

The system of claim 1, wherein executing the application further comprising processor-executable steps to cause the system to:
query the first data source for one or more data elements associated with the external data field in the mapper table;
receive the one or more data elements from the first data source in response to the query; and
receive one or more data elements from the second data source.

### Claim 6 (depends on 5)

The system of claim 5, further comprising processor-executable steps to cause the system to:
display the one or more received data elements.

### Claim 7 (depends on 6)

The system of claim 6, wherein the each received data element includes a data provider indicator.

### Claim 8 (depends on 5)

The system of claim 5, further comprising processor-executable steps to cause the system to:
transmit the one or more received data elements directly to a second application.

### Claim 9

A computer-implemented method comprising:
parsing data stored at a first data source, wherein the first data source is an external data source;
generating a mapper table based on the parsed data, wherein the mapper table includes at least one external data field associated with the parsed data;
determining at least one target data field in a second data source, wherein the target data field corresponds to at least one external data field;
mapping the at least one determined target data field to the corresponding external data field in the mapper table; and
accessing the mapper table with an application during execution of the application.

### Claim 10 (depends on 9)

The method of claim 9, further comprising:
receiving a link to the first data source prior to parse the data.

### Claim 11 (depends on 9)

The method of claim 9, wherein the link is a Uniform Resource Locator (URL).

### Claim 12 (depends on 9)

The method of claim 9, wherein parsing further comprises:
requesting one or more data elements from the first data source.

### Claim 13 (depends on 12)

The method of claim 12, wherein generating the mapper table further comprises:
importing the external data field of each data element provided by the first data source to the mapper table.

### Claim 14 (depends on 9)

The method of claim 9, wherein executing the application further comprises:
querying the first data source for one or more data elements associated with the external data field in the mapper table;
receiving the one or more data elements from the first data source in response to the query; and
receiving one or more data elements from the second data source.

### Claim 15 (depends on 14)

The method of claim 14, further comprising:
displaying the one or more received data elements.

### Claim 16 (depends on 14)

The method of claim 14, further comprising:
transmitting the one or more received data elements directly to a second application.

### Claim 17

A non-transitory computer-readable medium storing program code, the program code executable by a computer system to cause the computer system to:
receive a link to a first data source, wherein the first data source is an external data source;
request one or more data items from the first data source;
generate a mapper table based on the parsed data, wherein the mapper table includes at least one external data field associated with the parsed data;
determine at least one target data field in a second data source, wherein the target data field corresponds to at least one external data field;
map the at least one determined target data field to the corresponding external data field in the mapper table; and
access the mapper table with an application during execution of the application.

### Claim 18 (depends on 17)

The medium of claim 17, wherein the link is a Uniform Resource Locator (URL).

### Claim 19 (depends on 17)

The medium of claim 17, wherein generating the mapper table further comprises program code to cause the system to:
import the external data field of each data element provided by the first data source to the mapper table.

### Claim 20 (depends on 17)

The medium of claim 17, wherein executing the application further comprising program code to cause the system to:
query the first data source for one or more data elements associated with the external data field in the mapper table;
receive the one or more data elements from the first data source in response to the query; and
receive one or more data elements from the second data source.
