Customer Data Integration (CDI) is the combination of the technology, processes and services needed to create and maintain an accurate, timely and complete representation of a customer across multiple channels, business lines, and enterprises. Typically there are multiple sources of customer data, held in multiple application systems and databases. CDI is typically one requirement for a complete Master Data Management Solution.

SQLstream's Continuous Data Integration (CDI) solution offers an effective, scalable and flexible vehicle for building and maintaining a unified view of your customer data:

• Distributed collection and continuous integration of customer data from many external applications, databases, message buses and other enterprise data sources.
• Transformation, filtering, aggregation and exception handling from any number of disparate data sources.

SQLstream's Continuous Data Mediation

SQLstream's Continous Data Mediation (CDM) solution enables automatic instrumentation of an existing CDI central repository, using SQLstream's RDBMS Change Data Capture solution to interpret the repository schema. SQLstream captures all changes to the data (inserts, deletes, edits, upserts), and generates the equivalent transactions as real-time data streams. SQLstream:

• Enables automatic instrumentation (using Change Data Capture) of the databases for each individual application that contributes to or manages any element of customer data databases.
• Handles application log files where databases are not used or available for instrumentation, using SQLstream's Log File and Log4J adapters.
• Handles application data collected from the Enterprise Message Buses to which applications publish customer changes using SQLstream's JMS Adapter.
• Continuous, real-time transformation and mediation of data from any number of data sources.

Orchestrating the CDI Process

SQLstream enables orchestration of the entire complex process of collection, aggregation, transformation, and synchronization across disparate data models for all of the master data and their components. All of the transformation, aggregation and routing logic is expressed as declarative SQL.

• Automatic RDBMS Data Change Capture for sources of customer data.
• Fully declarative logic, enabling you to express what data you require using declarative standards-based SQL rather than specifying how to procedurally process the data.
• High-performance processing and throughput.
• Pre-aggregation of data before loading into a central CDI data warehouse, supporting a wide range of third-party solutions.
• Optional integration with the leading open source Relational OLAP solution (Mondrian).

Enabling Additional CDI Applications

SQLstream's CDI solution approach also provides a natural platform to create and enable a wide range of new applications through repurposing the captured data streams of customer data.

By defining new SQL views over the streaming CDI transactions, you can create continuously evolving views of changes to customer data, such as changes to the following:

• Demographics, credit worthiness, total value purchased.
• Individuals' details or aggregated into changes at the account level.
• Customer orders or returns.
• Customer profile.

Complete new applications can be built using only a few SQL statements to perform the following real-time operations:

• Alerting, through email or otherwise, when a customer purchases or returns a historically unusual amount of goods.
• Generating qualified leads for other products by performing cross-selling analysis based on demographics and purchase history.
• Adjusting discount entitlements based on individual or account aggregate (or arbitrary aggregates such as friends and family) purchase levels either historically or within a given time window.
• Continuous order forecasting based on real-time customer purchase patterns.

A few high-level SQL queries captures each of these applications, reusable across a number of applications by using SQL Views, and centrally managable as part of your strategic dynamic data assets.

SQLstream enables and performs all of this based on industry standard SQL repurposed for CDM and continuous alerting.

SQLstream enables building such solutions at a small fraction of the cost of development using other state-of-the-art alternative technologies such as Enterprise Service Buses (ESB) and Service Oriented Architecture (SOA) integration technologies.

SQLstream creates an even smaller cost of ownership going forward, slashing the Total Cost of Ownership (TCO) through:

• Straightforward, central management.
• High-level rules based on familiar standards-based declarative SQL.
• Simple reuse through views.