Udemy Business

Teach on Udemy

Turn what you know into an opportunity and reach millions around the world.

Learn More

Your cart is empty.

Keep shopping

Step-By-Step SAP Smart Data Integration, BTP, CAPM,BAS, HANA

Name: Step-By-Step SAP Smart Data Integration, BTP, CAPM,BAS, HANA
Rating: 4.4 (13 reviews)

Data Provisioning, SDI, SDA, BTP, BAS, HANA Cloud, Realtime Data Transfer

Created byBTPcoders Academy

Last updated 11/2024

English

What you'll learn

Smart Data Integration using Business Application Studio
Working with dpagent and adapter for SDI
Creation of replication tasks, flowgraph, and working with advanced options
End to end creation of CAP project and implementing data replication, provisioning and deployment
Observe data replication in real time.
Create physical tables from virtual tables.

Course content

7 sections • 43 lectures • 4h 29m total length

Introduction2:59
Explore SAP smart data integration on SAP BTP, set up a HANA Cloud database, and configure remote sources, subscriptions, and real-time data replication.

7- Export Import Catalog Objects3:51
8- SDA Remote Source Creation, Users and Virtual table at Target system9:03
9- Creating remote source using SQL4:11
10- Remote Subscription, Replicating Data in Realtime using SQL6:06
Create a physical table from a virtual table and enable real-time replication via a remote subscription using SQL. The lesson demonstrates configuring schemas, starting replication, and validating live data flow.
11- Some SQLs6:20
Learn to create remote sources with XML or SQL, and explore adapters and SDA environment limits. Manage virtual tables and operations like check, drop, cascade, and alter.

20- Section Highlight, Creating Source Table9:59
21- Resolving privilege issues using GUID, creating table and inserting data9:59
22- Working with BTP5:21
Open and configure SAP BTP environments to connect a remote source, manage privileges, and access the target system, while launching HANA Cloud and Business Application Studio for data integration.
23- CAPM Project creation6:20
24- Making Project Ready for CAP Development and Binding, Creating .env file10:00
25- Resolving @sap hana-client Error2:03
26- Starting Source and Target3:18
27- Granting User Privileges on Remote Source8:34
Grant privileges for the sdi user on a remote source, including creating remote subscriptions and assigning rights for data access in sap smart data integration.
28- Creating schema and roles, assigning role to user5:32
29- Creating user provided service in BTP and binding6:34
Create a user provided service instance in the BTP cockpit, bind it to a Hana project, and configure the binding in the MTA YAML file for SDI cross-container access.
30- hdbgrants file in BAS3:22
31- Creating schema and roles, assigning role to user5:32
32- Creating Virtual Table From BAS5:06
33- Creating Replication Task with Initial Load and Executing7:06
34- Creating Realtime Replication Task and Data Validation5:19
35-Creating Flowgraph9:04
Create a flow graph in SAP BTP to replicate data from a source EMP table to a target HDB table, using synonyms, real-time options, and enforcing primary keys for insert.
36- Creatiing Flowgraph and validation6:29
37- Testing Realtime feature of Flowgraph and Reptask, Data Validation3:52
Demonstrates testing the real-time flowgraph and reptask data validation by inserting records in the source system and validating immediate replication to the target and replication task tables.
38- Filtering data in a replication task and writing expression6:10
39- Filtering Data in a Flowgraph4:53
Filter data in a flow graph by currency_code is equal to USD, deploy, and preview to show only US data; leverage projection, aggregation, and join features.
40- Monitoring Flowgraph and Rep Tasks7:51
41- Building and Deploying to Cloud Foundry6:20
42- Deployed to CF and Testing Realtime Features9:14

Requirements

No Prerequisites
Good to have basic SQL knowledge

Description

In this course you will learn about -

Business Technology Platform

BTP Trial Account Creation and Introduction

Setting dev space for BAS SDI

Subscription to HANA Cloud tools and providing authorizations

Creating HANA Cloud DB instance

Concepts of Data Provisioning

Similarities and Differences between Smart Data Access (SDA) and Smart Data Integration(SDI)

In SDA Section

SDA Remote Source Creation,

Users and Virtual table at Target system

Learn about data virtualization, data federation

Creating Remote Source using SQL

Creating Remote Subscription, Replicating Data in Real-time using SQL, Working with SQLs.

In SDI Section

DPAgent Installation

Registering dpagent

Registering Adapters

Working with File Adapter and HANA adapter

Creating Remote Source using adapter and dpagent

Working with Cloud Application Programming

Working on Business Application Studio

Creation of Node JS based CAP Project

Initial configuration for development

Creating user and Granting user privileges to work with remote source

Creating virtual tables, Replication Tasks and Flowgraphs using in a CAP Project using BAS

Creating .hdbgrants, .hdbsynonym,.hdbreptask,.hdbflowgraph etc. files

Creating user provided service instance and using it in CAP project

Working with various features of flowgraphs and replication tasks

Creating physical table replicating data in Real-Time

Testing Real-time data transfer

Deployment in to cloud foundry, SAP BTP trial account.

Testing and validation

and many more...

NOTE: All resources are available at "Lecture 11 under resources"

Who this course is for:

SAP Consultants
SAP Architects
BTP Consultants and Aspirants
Anyone who wants to learn data provisioning concepts

Step-By-Step SAP Smart Data Integration, BTP, CAPM,BAS, HANA

What you'll learn

Explore related topics

Course content

Introduction1 lecture • 3min

Starting with BTP, BAS, HANA Cloud3 lectures • 18min

Provisioning Introduction- SDI & SDA, Data Virtualization2 lectures • 18min

Smart Data Access SDA5 lectures • 30min

Smart Data Integration - SDI8 lectures • 51min

CAPM, BAS, Flowgraph, Replication Task, Virtual Table, Deployment to CF23 lectures • 2hr 28min

Conclusion & Thank You1 lecture • 2min

Requirements

Description

Who this course is for: