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

Homepage:

https://www.udemy.com/course/step-by-step-smart-data-integration-btpcapmbashana-cloud/