Data Integration Services

Featured Case Studies

Operational Data Store

CapTech consultants were instrumental in the establishment of critical enterprise business concepts, i.e., a location hierarchy that provided enterprise-wide access to the corporate data thus enabling cross-department and enterprise-wide analysis…

Data Integration Supporting Customer and Product Data Analysis

CapTech developed a strategy to design, build, and deploy an enterprise-wide data mart for a major insurance organization, designed to increase analytic capabilities and isolate key characteristics and trends in their customer base to increase revenue opportunities…

CapTech has extensive experience developing Extraction, Transformation, and Load (ETL) applications in a variety of industries using ETL technologies such as Ab Initio, Informatica PowerCenter, IBM WebSphere Information Integration (formerly Ascential Software), and Microsoft's SQL Server Integration Services (SSIS).

CapTech has experience creating, conceptual, logical, and physical data models using common techniques/schemas (e.g. 3rd normal form, 4th normal form, star schemas, snowflake schemas, dimensional models) and common tools (e.g. ERWin, Visio, Designer 2000, etc.). Our consultants are experienced in all major relational database technologies including Oracle, Teradata, SQL Server, Netezza, and DB2.