Step-By-Step Smart Data Integration, Btp,Capm,Bas,Hana Cloud

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

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.

Requirements

No Prerequisites

Good to have basic SQL knowledge

Description

In this course you will learn about -Business Technology PlatformBTP Trial Account Creation and IntroductionSetting dev space for BAS SDISubscription to HANA Cloud tools and providing authorizationsCreating HANA Cloud DB instanceConcepts of Data ProvisioningSimilarities and Differences between Smart Data Access (SDA) and Smart Data Integration(SDI)In SDA SectionSDA Remote Source Creation,Users and Virtual table at Target systemLearn about data virtualization, data federationCreating Remote Source using SQLCreating Remote Subscription, Replicating Data in Real-time using SQL, Working with SQLs.In SDI SectionDPAgent InstallationRegistering dpagentRegistering AdaptersWorking with File Adapter and HANA adapterCreating Remote Source using adapter and dpagentWorking with Cloud Application ProgrammingWorking on Business Application StudioCreation of Node JS based CAP ProjectInitial configuration for developmentCreating user and Granting user privileges to work with remote sourceCreating virtual tables, Replication Tasks and Flowgraphs using in a CAP Project using BASCreating .hdbgrants, .hdbsynonym,.hdbreptask,.hdbflowgraph etc. filesCreating user provided service instance and using it in CAP projectWorking with various features of flowgraphs and replication tasksCreating physical table replicating data in Real-TimeTesting Real-time data transferDeployment in to cloud foundry, SAP BTP trial account.Testing and validationand many more….NOTE: All resources are available at "Lecture 11 under resources"

Overview

Section 1: Introduction

Lecture 1 Introduction

Section 2: Starting with BTP, BAS, HANA Cloud

Lecture 2 Creating Trial Account

Lecture 3 Setting dev space for BAS SDI, Subscription to HANA Cloud tools

Lecture 4 Creating HANA Cloud DB Instance

Section 3: Provisioning Introduction- SDI & SDA, Data Virtualization

Lecture 5 5- Basics of provisioning, Virtualization etc

Lecture 6 6- Transformation, SDA & SDI Similarities and Difference

Section 4: Smart Data Access SDA

Lecture 7 7- Export Import Catalog Objects

Lecture 8 8- SDA Remote Source Creation, Users and Virtual table at Target system

Lecture 9 9- Creating remote source using SQL

Lecture 10 10- Remote Subscription, Replicating Data in Realtime using SQL

Lecture 11 11- Some SQLs

Section 5: Smart Data Integration - SDI

Lecture 12 12- downloading data provisioning agent

Lecture 13 13- DP Agent Installation

Lecture 14 14- Registering Agent

Lecture 15 15- Registering Adapter

Lecture 16 16 - Creating remote source using File Adapter

Lecture 17 17- Creating virtual table, working with Configuration File

Lecture 18 18- Registering Hana Adapter

Lecture 19 19- Creating SDI Remote source using Hana Adapter

Section 6: CAPM, BAS, Flowgraph, Replication Task, Virtual Table, Deployment to CF

Lecture 20 20- Section Highlight, Creating Source Table

Lecture 21 21- Resolving privilege issues using GUID, creating table and inserting data

Lecture 22 22- Working with BTP

Lecture 23 23- CAPM Project creation

Lecture 24 24- Making Project Ready for CAP Development and Binding, Creating .env file

Lecture 25 25- Resolving @sap hana-client Error

Lecture 26 26- Starting Source and Target

Lecture 27 27- Granting User Privileges on Remote Source

Lecture 28 28- Creating schema and roles, assigning role to user

Lecture 29 29- Creating user provided service in BTP and binding

Lecture 30 30- hdbgrants file in BAS

Lecture 31 31- Creating schema and roles, assigning role to user

Lecture 32 32- Creating Virtual Table From BAS

Lecture 33 33- Creating Replication Task with Initial Load and Executing

Lecture 34 34- Creating Realtime Replication Task and Data Validation

Lecture 35 35-Creating Flowgraph

Lecture 36 36- Creatiing Flowgraph and validation

Lecture 37 37- Testing Realtime feature of Flowgraph and Reptask, Data Validation

Lecture 38 38- Filtering data in a replication task and writing expression

Lecture 39 39- Filtering Data in a Flowgraph

Lecture 40 40- Monitoring Flowgraph and Rep Tasks

Lecture 41 41- Building and Deploying to Cloud Foundry

Lecture 42 42- Deployed to CF and Testing Realtime Features

Section 7: Conclusion & Thank You

Lecture 43 Conclusion

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