business_op_code indicates the action that resulted in this record.cust_id is the unique identifier of a customer enrolled in the loyalty program.event_ts is a timestamp of when the event is recorded in the system.In our hypothetical scenario, a typical record at the source database looks like this: event_id The data warehouse aggregates loyalty data on a daily basis, and stores this information for consumption by analytics and visualization tools. The OLTP system acts as a system of record for a customer loyalty program. It uses an Amazon Redshift data warehouse as the target. To implement CDC, the retailer uses an Online Transaction Processing (OLTP) system backed by a Microsoft SQL Server database. It also selects Amazon Redshift as the data warehouse. The retailer decides to use AWS Database Migration Service (AWS DMS) for near real-time replication of the customer loyalty data. With respect to customer loyalty data, the on-premises SQL Server remains the system of record however, a copy of the data must also be maintained on AWS. To achieve this goal of data analytics on AWS, the retailer needs to maintain up-to-date data within the AWS environment. Recently, the retailer decided to build a data and analytics platform on AWS to better understand customer behavior, their spending patterns, and how that correlates with the state of the loyalty program.įor example, how long does a customer typically take to upgrade from the Basic to Silver category? Or, what is the average spend of customers who did not qualify for a loyalty category upgrade in the past 12 months? The retailer maintains an on-premises Microsoft SQL Server database as the system of record for customer loyalty. Depending on spending propensity, customers are assigned loyalty categories ranging from Basic to Platinum.Ĭustomers can use several channels (online, at the store, through partner merchants) to register for the loyalty program. Our hypothetical retailer offers a loyalty program to its customers. To better illustrate how to implement our solution, we have constructed a hypothetical scenario for the retail industry. In this post, we explain how to implement a custom CDC solution using Amazon Web Services (AWS). We have AWS Competencies in healthcare, life sciences, migration, and financial services. Cognizant specializes in cloud infrastructure, platform, security, application rationalization, and business analytics. You can implement CDC in diverse scenarios using a variety of tools and technologies, including commercial products as well as bespoke solutions.Ĭognizantis an AWS Partner Network (APN) Premier Consulting Partner and AWS Managed Service Provider. ![]() In the context of data replication, Change Data Capture (CDC) is the technique of systematically tracking incremental change in data at the source, and subsequently applying these changes at the target to maintain synchronization. ![]() Director of Technology at Cognizantīy Anirban De, Principal Architect of Technology at Cognizantīy Sumalya Bhattacharyya, Sr.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |