IP Library Patent Application 11083064
Patent Application
App. No. 11/083,064

Migrating integration processes among data integration platforms

Loading inventors, assignments & file history…
Monitor This Case
Get email alerts when status or documents change.
Order Certified Copies
Most orders are placed with the USPTO same day — all within 24 business hours.
Order via The Patent Place →
Pre-filled with this patent's details
Quick Facts
Patent No.
US None
App. No.
11/083,064
Abstract

Methods and systems are provided for migrating a data integration facility, such as an ETL job, from a source data integration platform to a target data integration platform. For example, systems and methods are provided for migrating a data integration job from a source data integration platform having a source native format to a target data integration platform having a target native format; wherein the target native format is different than the source native format. The systems and methods may involve analyzing a source language construct of the source data integration platform to determine a logical syntax; constructing a target language construct of the target data integration platform adapted to perform the same logical operation on the target data integration platform as the source language construct performs on the source data integration platform; and substituting the target language construct for the source language construct in the source code for the data integration job.

Claims (48)

1 . A method of migrating a data integration job from a source data integration platform having a source native format to a target data integration platform having a target native format; wherein the target native format is different than the source native format, the method comprising:

analyzing a source language construct of the source data integration platform to determine a logical syntax;

constructing a target language construct of the target data integration platform adapted to perform the same logical operation on the target data integration platform as the source language construct performs on the source data integration platform; and

substituting the target language construct for the source language construct in the source code for the data integration job.

2 . The method of claim 1 wherein the method further comprises the step of running the data integration job with the substituted target language construct on the target data integration platform.

3 . The method of claim 1 wherein the data integration job comprises an ETL job.

4 . A method, comprising:

extracting source code from a source data integration facility;

breaking the source code into blocks;

analyzing a first source code block to determine its syntax;

determining the syntax is a known syntax; and

replacing the first source code block with a target code block; wherein the target code block is formatted in a target data integration facility format.

5 . The method of claim 4 wherein the known syntax comprises a generic syntax.

6 . A method, comprising:

extracting source code from a source data integration facility;

breaking the source code into blocks;

analyzing a first source code block to determine its syntax; and

determining the syntax is an unknown syntax.

7 . The method of claim 6 wherein the method further comprises the step of storing the first source code block in memory.

8 . The method of claim 6 wherein the method further comprises the steps of:

converting the first block into a plurality of representations;

parsing the plurality of representations;

transforming the plurality of representations into a generic model; and

translating the generic model into a second format.

9 . A system adapted to migrate a data integration job from a source data integration platform having a source native format to a target data integration platform having a target native format; wherein the target native format is different than the source native format, the system comprising a computer facility adapted to:

analyze a source language construct of the source data integration platform to determine a logical syntax;

construct a target language construct of the target data integration platform adapted to perform the same logical operation on the target data integration platform as the source language construct performs on the source data integration platform; and

substitute the target language construct for the source language construct in the source code for the data integration job.

10 . The system of claim 9 wherein the system is further adapted to run the data integration job with the substituted target language construct on the target data integration platform.

11 . The system of claim 9 wherein the data integration job comprises an ETL job.

12 . A system comprising a computer facility adapted to:

extract source code from a source data integration facility;

break the source code into blocks;

analyze a first source code block to determine its syntax;

determine the syntax is a known syntax; and

replace the first source code block with a target code block; wherein the target code block is formatted in a target data integration facility format.

13 . The system of claim 12 wherein the known syntax comprises a generic syntax.

14 . A system, comprising a computer facility adapted to:

extract source code from a source data integration facility;

break the source code into blocks;

analyze a first source code block to determine its syntax; and

determine the syntax is an unknown syntax.

15 . The system of claim 14 wherein the computer facility is further adapted to store the first source code block in memory.

16 . The system of claim 14 wherein the computer facility is further adapted to:

convert the first block into a plurality of representations;

parse the plurality of representations;

transform the plurality of representations into a generic model; and

translate the generic model into a second format.

Assignments (2)
ASSIGNMENT OF ASSIGNOR'S INTEREST Recorded Dec 26, 2005
From: ASCENTIAL SOFTWARE CORPORATION
To: INTERNATIONAL BUSINESS MACHINES CORPORATION
Reel/Frame 017555/0184 →
ASSIGNMENT OF ASSIGNOR'S INTEREST Recorded Sep 19, 2005
From: HARKEN, RICHARD EARL; JOHNSTON, ROBERT
To: ASCENTIAL SOFTWARE CORPORATION
Reel/Frame 016551/0700 →