# US 2012/0254259 A1 · Flexible order of authoring for data integration solutions

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

- Number: US 2012/0254259 A1
- Document ID: US20120254259A1
- Status: Published application
- Kind: A1
- Application number: 13/073,212
- Filed: 2011-03-28
- Published: 2012-10-04
- Earliest claimed: 2011-03-28
- Assignees: Microsoft Corporation
- Inventors: Kevin Thomas Edward McGuire; Sergio Silveira Clemente Filho; Matthew Carroll; Cimarron S. Ryan
- Web page: https://patentgrep.com/patent/US20120254259A1

## CPC

- G06F 16/25: Integrating or interfacing systems involving database management systems
- G06F: ELECTRIC DIGITAL DATA PROCESSING (computer systems based on specific computational models G06N)

## Abstract

A method includes connecting an integration process to a first set of inputs. The first set of inputs may include one or more inputs. The integration process includes one or more data transformation operations using the inputs. The method further includes receiving metadata about one or more of the inputs in the first set of inputs. The metadata about one or more of the inputs in the first set of inputs is cached. The integration process is then connected to a second set of inputs based on the cached metadata about one or more of the inputs in the first set of inputs.

## Claims

### Claim 1

In a computing environment, a method of changing an integration process source, the method comprising:
connecting an integration process to a first set of inputs, the first set of inputs comprising one or more inputs, wherein the integration process comprises one or more data transformation operations using the inputs;
receiving metadata about one or more of the inputs in the first set of inputs;
caching the metadata about one or more of the inputs in the first set of inputs; and
connecting the integration process to a second set of inputs based on the cached metadata about one or more of the inputs in the first set of inputs.

### Claim 2 (depends on 1)

The method of claim 1, wherein the metadata about one or more of the inputs in the first set of inputs describes columns from one or more sources.

### Claim 3 (depends on 1)

The method of claim 1, wherein connecting the integration process to a second set of inputs comprises a user selecting portions of a source based on the metadata and mapping the portions to inputs from the first source.

### Claim 4 (depends on 1)

The method of claim 1, wherein connecting the integration process to a second set of inputs comprises automatically selecting a source based on the metadata.

### Claim 5 (depends on 4)

The method of claim 4, wherein selecting a set of inputs based on the metadata comprises selecting a source based on an input name.

### Claim 6 (depends on 5)

The method of claim 5, wherein selecting a source based on an input name comprises selecting an input in the second set of inputs that has a same name as a source in the first set of inputs.

### Claim 7 (depends on 5)

The method of claim 5, wherein selecting a source based on an input name comprises selecting an input in the second set of inputs that has a similar name to a source in the first set of inputs.

### Claim 8 (depends on 1)

The method of claim 1, further comprising disconnecting from the first set of inputs prior to connecting to the second set of inputs.

### Claim 9 (depends on 8)

The method of claim 8, further comprising editing at least a portion of the transformation operations of the integration process while disconnected from the first set of inputs.

### Claim 10 (depends on 1)

The method of claim 1, further comprising sharing metadata from the integration process with a different integration process.

### Claim 11 (depends on 1)

The method of claim 1, further comprising providing a user with information based on the metadata about a possible input to connect to from the second set of inputs.

### Claim 12 (depends on 1)

The method of claim 1, further comprising updating the cached metadata based on the connected second set of inputs.

### Claim 13

One or more physical computer readable storage media comprising computer executable instructions that when executed by one or more processors cause the following to be performed:
receiving metadata about one or more inputs in a first set of inputs configured to be connected to an integration process, wherein the integration process comprises one or more data transformation operations;
caching the metadata about one or more of the inputs in the first set of inputs at the integration process; and
connecting the integration process to a set of inputs based on the cached metadata about one or more of the inputs in the first set of inputs.

### Claim 14 (depends on 13)

The one or more computer readable media of claim 13, wherein receiving metadata about one or more inputs in a first set of inputs configured to be connected to an integration process is performed as a result of connecting the integration process to the first set of inputs.

### Claim 15 (depends on 13)

The one or more computer readable media of claim 13, wherein receiving metadata about one or more inputs in a first set of inputs configured to be connected to an integration process is performed by receiving metadata from a set of inputs that is different than the set of inputs in the act of connecting the integration process to a set of inputs based on the cached metadata about one or more of the inputs in the first set of inputs.

### Claim 16 (depends on 13)

The one or more computer readable media of claim 13, wherein receiving metadata about one or more inputs in a first set of inputs configured to be connected to an integration process is performed by receiving metadata about an output component of the integration process.

### Claim 17 (depends on 13)

The one or more computer readable media of claim 13, wherein receiving metadata about one or more inputs in a first set of inputs configured to be connected to an integration process is performed by receiving metadata from a transform component of a different integration process.

### Claim 18 (depends on 13)

The one or more computer readable media of claim 13, wherein receiving metadata about one or more inputs in a first set of inputs configured to be connected to an integration process is performed by receiving metadata from an integration process developer.

### Claim 19 (depends on 13)

The one or more computer readable media of claim 13, wherein receiving metadata about one or more inputs in a first set of inputs configured to be connected to an integration process is performed by receiving metadata about a placeholder column.

### Claim 20

In a computing environment, a method of changing an integration process source, the method comprising:
connecting an integration process to a first set of inputs, the first set of inputs comprising one or more inputs, wherein the integration process comprises one or more data transformation operations using the inputs;
receiving metadata about one or more of the inputs in the first set of inputs by traversing an upstream path of the integration process and returning available columns from the upstream path;
caching the metadata about one or more of the inputs in the first set of inputs including information about the available columns;
disconnecting the integration process from the first set of inputs;
after disconnecting the integration process from the first set of inputs, adding one or more additional placeholder columns to the cached metadata based on a required column in a destination dataflow component;
modifying a component of the integration process using the cached metadata, including the added metadata about placeholder columns;
connecting the integration process to a second set of inputs based on the cached metadata, including the added metadata about placeholder columns.
