ALL THAT YOU NEED TO KNOW ABOUT CDS VIEW SAP

A View is not a persistent entity and is defined as the projection of several other entities. SAP HANA XS (SAP HANA Extended Application) helps to define a view in a CDS document that can be stored as a design-time file in the repository. The repository files can be read by applications that are specifically developed and includes view definition that can be transported to other SAP HANA systems.

What is SAP CDS

SAP CDS (SAP Core Data Service) is an architecture for data modeling. It helps to define and consume data models not on the application server but on the database server. The powerful in-memory database of SAP HANA is thereby leveraged to fulfill certain key requirements. It includes performing fast real-time performance for maximum operations at the database level, assisting users to retrieve data quickly, and reducing application execution time. SAP CDS is used by developers to create underlying data models that application services expose to UI clients as CDS View SAP.



What is CDS View SAP?

CDS View SAP is the virtual data model of SAP HANA that allows direct access to underlying tables of the HANA database. CDS View SAP was launched along with the new programming model of SAP and is focused on pushing logic from the application server to the client side and database. SAP defines this as ‘Code -to-date or ‘Code Pushdown’. It is carried out by the CDS View SAP which derives the logic from the ABAP application and executes it on the database server instead of the application server. ABAP CDS Views are located in the application server while the logic is processed in the database and are created using an improved version of the open SQL syntax.

Data in SAP is physically stored in transparent tables while for data modeling purposes, CDS View SAP is an abstraction layer on top of the tables. This establishes the relationship between database tables and hides the complexity from the ABAP programmer.

HANA CDS Views and ABAP CDS Views

There are two types of CDS View SAP – HANA CDS Views and ABAP CDS views. In the past CDS View SAP was only available in the SAP HANA ecosystem but now CDS is also enabled in SAP NetWeaver as ABAP. This allows developers to work with the ABAP programming layer while the execution of the code is relegated to the database. CDS View SAP supports built-in functions and extensions, conceptual modeling, and relationship definitions which are an improvement over the traditional data modeling tools.

There are several advantages of CDS View SAP. It can be exposed as an OData Service for accessing and extracting SAP data. CDS Views are independent of databases like Open SQL and can be run on any database system that matches the SAP environment. A critical feature is that CDS View SAP supports automatic client handling.


Comments

Post a Comment

Popular posts from this blog

Everything you need to know about Extract, Transform and Load (ETL) tools

Image
As a central repository that holds all the bid data from various different sources, a data lake is the vast, richest pool of raw data, the purpose of which is undefined. Data from this lake is then put to use for analytics and machine learning by organizations. A data lake is used for storing both relational and non-relational data from devices, apps, and users. Different types of analytics, such as machine learning, big data analytics, textual search, SQL queries, and real-time analytics can be derived from a data lake. It has both curated and non-curated data. An SAP data lake is easy to set up and can ingest data from on-premise or from a cloud warehouse. According to a survey, 90% of businesses believe that big data initiatives help them determine future success. A data lake allows data engineers, data scientists, and business analysts to access information using the tools and applications of their choice. There’s a lot of value in a data lake for businesses, the ability to harnes...
Read more

Migrating Oracle Database to Amazon Simple Storage Service (S3)

Image
Amazon Simple Storage Service (S3) is a cloud-based service that is cost-effective and provides unlimited storage capabilities. For Oracle databases, the most common source for data lakes in the Amazon Relational Database Service (RDS). To migrate the database from Oracle to S3 , there should be an AWS account. Further, also required is an Amazon RDS for the Oracle database and an S3 bucket l ocated in the same region where the AWS DMS (Database Migration Service) replication instance is created for migration.  Databases can be migrated from Oracle to S3in any one of two ways. The first is by importing data, Oracle Data Pump, and Database Link where the Data Pump and the Oracle DBMS_FILE_TRANSFER package are used to link to a source Oracle instance. This can be initiated either through an Amazon EC2 instance or an Amazon RDS for the Oracle database instance. After the Oracle data is exported to a dump file with the DBMS_DATAPUMP package, the file thus created is copied to the Ama...
Read more

The Unique Architecture of the SAP Data Lake

Image
SAP launched HANA Data Lake in April 2020, intending to provide users with an advanced as well as a very cost-effective data storage repository. The complete package consists of a native storage extension and an  SAP Data Lake   that is standard across all models and versions. The architecture of the SAP Data Lake is unique and stands out from other forms of data lakes. Businesses have the option to store data that is frequently used and accessed (hot data) segregated from data that is not used much (warm data) in the Native Storage Extension (NSE) of SAP HANA. The SAP Data Lake may be visualized as a pyramid with three distinct layers. On the top part of the pyramid is space offered to businesses to store the data which is critical for daily operations and has to be accessed daily. Since this data has very high demand, the storing cost too is the highest among all the three segments. The middle layer of the pyramid is for organizations to store data that is no...
Read more