Siebel Customer-Centric Enterprise Warehouse Installation and Configuration Guide > Storing, Extracting, and Loading Additional Data >

About Integrating Data from Source Systems Without Prepackaged Business Adapters


Siebel Customer-Centric Enterprise Warehouse provides universal business adapters for source systems that have no prepackaged business adapter. These source systems are referred to as universal sources. The universal business adapter extracts, transforms, and loads data from these sources. However, unlike the prepackaged business adapters for particular source systems, the universal business adapters are prepackaged to perform general transformations, such as enabling Type II Slowly Changing Dimensions, date data type conversion logic, and deletion logic. The universal source architecture extracts and loads data from any source system. As a result, you may need to configure the data or prepackaged extract, or both, and load mappings to incorporate your unique transformation logic. For more information on the universal source data requirements, and an architectural overview of the ETL processes, see the following sections.

Siebel Customer-Centric Enterprise Warehouse Installation and Configuration Guide