Posts

Showing posts from August, 2024

An Overview Of CDS View SAP

Image
Before moving to CDS View SAP , let us understand what CDS is. It is a short form for Core Data Services, a programming language developed and launched by SAP. Users need not go through the application server to define and consume models on the database with CDS V iew SAP. Rather , CDS View may be used to create data models with OData services that might be moved outside the applications. This is a feature that is unique to CDS View SAP. Types of CDS View SAP There are two types of CDS View SAP. The first is HANA CDS View which is a programming and virtual data model that comes as a standard feature of SAP HANA. Here businesses can have direct access to all the tables in the SAP database. The second is ABAP CDS View, an important technology that is widely used to develop modern applications on SAP systems. It offers improved performance in data modeling when used together with the SAP HANA database. Developers can use ABAP CDS View to create semantically rich data models and pr...

Microsoft SQL Server and Change Data Capture Feature

Image
  In today’s data-driven business environment, the Change Data Capture (CDC) feature gives an edge in operational efficiencies to organizations. CDC stops data breaches by creating a firewall for databases and stores values of all changes made to databases without compromising them in any manner. In the past, businesses had made a demand for these features and various databases had tried varied solutions but without much success. These included triggers, timestamps, complex queries, and data auditing. It was only after Microsoft launched their SQL Server CDC tool that users got what they had always asked for.      Microsoft launched SQL Server CDC IN 2005 with “after update”, “after insert”, and “after delete” capabilities. However, DBAs considered it too complex and invasive and hence, it was not well-received. Based on this feedback, Microsoft launched a new version in 2008 that was technologically advanced with several cutting-edge features. These are still ...