Patent ID: 8639652
Filing Date: 2014-01-28
Classification: G06F

Abstract:
1. A non-transitory computer readable medium storing instructions to cause at least one data processor of at least one computing system to port an extract transform load (ETL) job, comprising executable instructions to: determine, using a flow object associated with at least one old data store configuration profile, that a new data store configuration profile characterizing a data store is associated with a data flow for the ETL job, the data flow having dependent data flows; determine, using the flow object, whether the new data store configuration profile contains aliases to database object owner identities, and if so, identifying dependent flows of the data flow using the aliases and updating the identified dependent data flows to use the aliases; determine, using the flow object, if the new data store configuration does not contain aliases, and determine whether the new data store configuration profile contains a change in database type and database version; add properties for readers, transforms, and loaders to the dependent data flows of the data flow if it is determined that the new data store configuration profile contains the same database type but higher database version compared to the at least one old data store configuration profile; add properties for readers, transforms, and loaders to the dependent data flows of the data flow except for bulk loader properties if it is determined that the new data store configuration profile contains the same database type but lower database version compared to the at least one old data store configuration profile; port the ETL job from the data store to a second data store using either the updated dependent data flows or the dependent data flows with the added properties of the data flow; and generate a log characterizing porting of the ETL job from the data store to the second data store; wherein the log comprises names of the updated data flows, which language is modified, objects in the updated data flows that are affected by the updating, a type of the objects, a usage of the objects, whether the objects have a bulk loader option and whether bulk loader option is copied.