Method and apparatus for gathering and organizing information pertaining to an entity

1 . A method of gathering and organizing data pertaining to an entity comprising:

extracting the data from a plurality of data sources associated with one or more tenants;

organizing the data into connector files having a predefined structure and associating the data in each connector file with a tenant parameter; and

storing the connector files in memory.

2 . The method of claim 1 wherein the extracting step further comprises:

selecting a tenant from a plurality of tenants, where each tenant comprises a plurality of data sources.

3 . The method of claim 1 wherein the connector files are either dynamic connector files or generic connector files.

4 . The method of claim 1 wherein the organizing step comprises:

adding meta data to the connector files comprising at least one of a tenant code, data partition code, source code or a native identifier.

5 . The method of claim 1 wherein at least one connector file is a dynamic connector file and the organization step further comprises:

creating a configuration file associated with the dynamic connector file, where the configuration file comprises parameters for the dynamic connector file.

6 . The method of claim 5 wherein the configuration file is an XML file.

7 . The method of claim 1 further comprising:

accessing the connector files;

filtering the data in the connector files; and

storing the filtered connector files as import tables.

8 . The method of claim 7 further comprising:

accessing the import tables;

processing information in the import tables to generate at least one staging table; and

processing information in the at least one staging table to generate a gold record.

9 . Apparatus for gathering and organizing data pertaining to an entity comprising:

a system_meta schema for controlling data base processing;

a system_DW_ 1 schema for accessing a first set of asset data;

a system_DW_ 2 schema for accessing a second set of asset data;

where the system_meta schema switches between system_DW_ 1 schema and system_DW_ 2 schema.