Scribd
Upload
141 views80 pages

Bods Part 1

SAP BODS

Uploaded by

Bhaskar Banerjee
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF or read online on Scribd
141 views80 pages

Bods Part 1

SAP BODS

Uploaded by

Bhaskar Banerjee
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF or read online on Scribd
Te T | Infosys Limited Unit 4 SAP Data Services “The below diagram describes how SAP Data Services components fit in with other software in the SAP porto, aaa) | riovoe ee Das tite | CRE eee | ee ] ite Aten Saver cus =f ]]| | todo Gewarg Pacion ||| | : utsor | | Accose sorvee ou EIM Adaptive sm | _saPevanesdtect pli EE =] - | one at ican | compen igwe lfowce: Ache Ge Bhp helps. co SAP solution portfolio layers provide the most reliable, scalable, flexible, and manageable susiness inteligence (61) ‘platform which supports the best end-user interfaces for reporting, query Janalysis[performance management dashboards/scorecards and also other applications that can be integrated with SAP Data Services with existing SAP infrastructure with the following SAP tools: ‘= SAP Systm Landscape Directory (SLD) * SAP Solution Manage; * ciS Transport (CTS+) * Monitoring with CA Wily Introscope . 1855 Objects Information Platform Services: The basie components required by Data Services are available in SAP Business Objects Information platlorm services (IPS)._ It is a ETACORP/CRSICOURSE ID ‘CONFIDENTIAL ‘Version No Infosys Limited dalle Unit 1 - SAP Data Setvices mink-version of SAP Business Objects 8l Platform with only CMS and other related services (no Teporting or dashkoard engines), However, it has the ability to provide all the platform functionalities like user management, authentication, authorization, scheduling, job processing etc + SAP Business intelligence (8!) platform includes Data Services and Business Intelligence clients such as Web intelligence documents or Crystal Reports. REC Connections help in establishing connection between Data Services and SAP BW. chitecture components of SAP Data Services: = major components of SAP Data Services ta Services Workbench + Management Console + Repository (Local/Central/Profiler) Data Services Server Manager * Data Services Repository Manager * License Manager Platform CMC (Central Management Console) Designer: it is datastores and ront end GUI (Graphical User interface) development tool, It fs used to create ta mappings which manages metadata, define protacal for transformations and load business data into the target systems Data Services Workbench: This tool simplifies the migration of data and schema information between different.database systems, Workbench can be used to create, display and modify the objects, design dataflow, display the source table data, view logs and status of a job. Yet itis not afl edged tool as compared to SAP DS Designer Management Console: This provides browser hased access ta administration tasks ef Repository: Set of tables in RDBMS that holds the user-created afd predefined system objects, source target metadata and transformation rules. These repositories kan be created in any database like Oracle, HANA, Sybase, MS SQL Server and MyS{it. There are three types of repositories: * Local repository = Central Repository ‘+ Profiler Repository ETACORPICRSICOURSE ID ‘CONFIDENTIAL Version No Pagoroil? Unfosys Limited Unit 4 -SAP Data Service Job Server: ret r ves the job information from its associated Repository and starts an engin vices Engine extracts data from multiple het ex data transformations and loads data into the targ his server is used to execute the real-time jobs, Multiple Access latform CMC (Central Management Console): This sa web based tool for hata configurations of jobs servers and security management ete Server Manager: This s used to add, delete or edit the prbperties of Job Servers. The ager defines the links between Job Servers and Repository Repository Manager: Create, Upgrade and Check the versions of Local, Central an information Steward Overview: information Steward helps business, data analysts and IT users in data o” which improves tne duality oftholr enterprise data assets, Stewards a combination of SAP Business Objects Business Inteligence (Bl) platform and nheritsthe sealable architecture of these two. platforms, EIM Adaptive Processing instance of Adaptive Processing Server in Bi platform and Information Steward .6f Adaptive Jab Server in Platform. Its basically used for process Distributed Architecture: SAP Data Services seAVEF processes can be elther “vertically scaled” o¢ "horizontally scaled”. In vertical scaling architecture, all the esses can be configured and run simultaneously rer eee ty Horizontal Scaling a scesses are distributed between two of hare on the same network Vertical Scaling vs Horizontal Scaling n vertical scaling, hardware cost will be reduced, This could be utilized for development or quality environments where services could be configured on ane machine. Whereas in horlaont achieved as itis possible to run multiple, redundant versions of the same serve process en more than one machine and hence there s no dependency on one machine and processing ETACORPIORSICOURSE 0 CONFIDENTIAL Version No Pagesot ETACORPICRSCOURSE Introduction ables in RDBMS that Holds the user fined system object Infosys Linted Unit 4 -SAP Data Services Introduction to Detigner: window based GUI client for developers. t provides Interaction with the local repository. Following paragraph discusses the primary functionalities avaiable in the Designer Object Creation and Management igners used to create jobs and execute them manually. Manually executing jobs In Designer helps developer test the sanity ofthe logic inthe Development environment to ensure thatthe expected sts are delivered by the job. Hence primarily Designer is used by developers for davelopment/unit ‘thave scheduling capablities. Hence post deploymant of jobs itive ud be scheduled elther through a third party scheduletor through Data Service «Console. Data Services Management Console provides an option te rignually execute th se of Designer isto facilitate access to Centta| Repositories and Profiler Repositories, i “Types of objects in Data Services: olowing objects are available In Data Servicas + project —this is used by developers to argan' Trang. Deno. DeVS + Job -AJob isthe only schedulable object In Data Services, Jobs ar ‘executed together, There are two types of obs Batch and Realtime job Batch Job - Batch jobs are objects set that can be scheduled and executed together. tis ETNCORPIGRSICOURSEID. ~~ CONFIDENTIAL Version no Paget tail? sequetceof ett + Dillons Dotatows are reusable objects where dat extracted rom sour, ranformed + Data sto tabled This ep = [vise [omen | von CD Teme Yates Unit 4 - SAP Data Services + Fileformats jes an mel r Format TI Pwr | ge_ itis mosteammonly used as fine seri fr cal scripting language. ttis most y vrriables, execute functions ete. They arevery flexib Topic inthe iobs Single-use object Page veal NCORPICRSEOURSE IO CONFIDENTIAL Version No Below screenshot shows the login process to the designer tool All Programs. SAP Data Services 4.2 > Data Services Designer reen enter the beldly details: Hostname: After enter the erédentiasclick on registered with Cha¢ offthat Data Selegt the assighiedsbostitory, click OK Log On’ and it displays all the repositories that are created and ‘CONFIDENTIAL WVorson No Pager Infosys Limited Unit 2 - SAP Data Services Infosys Limited Unit 2 - SAP Data Services Highlighted part inthe local object library shows the reposit ¥ dotalls for the user who is currently ogg Repository data information (This would be discussed in deta 91 Object Library - Provides acc 7 lerarchical view Bill obje Workspace area - Area of the application windowpin WhicR"tREBbjects can be defined, display Infosys Linvted Unt 2-SAP Data Services A project the highest lev tn the Designer. Project are created in the designer, Only one project with muttipe use a way to organize other objects which restetnpoyeToble wAoritloyre contains? ~ It contains a group of fob: Jt centalis Workflows and Workflows in tu Where itis stored? - tis stored jp theyocall abject Rar. How to create a new project? be uocaty. pane inthe Designer + Right clickon the blank space and s Invosys Limite Unit 2 SAP Data Services rays enone ‘Alobis the only sc lulable abject in Data Services Jobs are made up of steps that are executed together. Each ste in work space to create a Job diagram. Jobs can be created elt Is represented by an object ican that is placed using local object ibrary oF using project Below isthe snapshot that shows how to create a new Job 20s of jobs which can be cre itch - Batch jobs are objects set that can be Seneduléd and 8 mount of data from source system ted together. It is used fo Real time - Real-time jobs runs congtahly when ¢ontigured asa real-time service. it waits fora request J request is executed to retugh bath the tesull. It follows a réquest-response model bis triggered by/liserfifher in the Designer or scheduled by a scheduler lke Business ata Services scheduler avaliable in the Magagement Console or by using Business Objects Enterprise or by ssng thd party scheduler like Widows Scheduler What are the contefit ofa job2 he job can contain falowing 1. Workdiows Optional objects used for decision making process for executing other objects bata Flows ‘Objects used te|pxtract data froin the source and load the data into the t. table. It contains the source tables, target tables and transforms. Scripts Single use objects which cantain function cals and are used to assign value to.8varinble inside erints. Conditionals Single use objects used to implement IF-Then-tse loge Ina worktiow 5. While Loop Single use object that fused ina workllav, While laop repeats the sequence ETACORPCREOURSE I SONFIDENTIAL Vorsion Wo Page t20ist Infosys Limited Unit 2 SAP Data Services ps as long asthe condition is true. 6. Try-cateh block It is a combination of one try and one or more catch blacks. fe. while executing Job if any error occurs its caught by catch block and an alternate workflow i Creating a new Job from ‘Project Area’ pane: nthe project name and choose ‘Ney Batth Job’ dP Real Time Jot + | Eat the name Infosys Limited, Unit 2 - SAP Data Services Creating a new Job from ‘Local Object Library’ pane: + Navigate to Job tab + Rlght-lck ‘Batch Jobs’ or ‘Real-time Jobs’ and choo: © edit the name ithe Job to the open project fn tha project area, This wil add the job inthis project [Workflow P are reusable objects in SAP Data Services that groups together objects tad fitexecution ode ye ne a & Wont ov 4 pay ijion lh aumstans | @ Deters Bleomans LZ ted from thelabjactibrary or the tool palette. Arvexsting work the Objet lara or lt'the workspace from Job or the workflow its ata theolowing objects = other workflan = sols ‘onnected to define the ore which they should be executed, Objects ina nt seque indicated by connecting lines ETAICORPIORSIGOURSEID CONFIDENTIAL arson No Pagosa ol are eran we aa ara d@e 4 to pas: Values 38 worl. Variables can azo be defined {ofosys Limited Unit 2 SAP Data Services Properties of a Workflow: a ore rere any in thajb. The Alga toldsa ths Festure might arise In ajab with comp) ute Only Once ensures that ajob execites I Baly forthe fist occurrence of a workflow Recover as 2 unit forces all the objStsIn'ayrorktiow to re-cxecute whein 3 ja is being re-executed with as failed exeedtiontoption that failed after partially executing the workflow marked a a 2 wogiflowyis Rt marked as Recovery unit, during re-execition ofthe job in eecavery mods, So, this option should be enabled for workflow where the «ts in the worktlow depand on each other and should shiays pe executed together ‘bypass optign with 2 sIBBBF ES’ allows the worktiow ta be skipped during execution. This ds igor dian of the job Workflow Exceution Type: ties, select one of the following asthe ‘Execute Type’ to define the hat can be executed in parallel unas separate threads nthe process share resources across all dataflow inthe workflow fe workllow can only be executed by a continuous warkfove Unt 2 - SAP Data Servi ind kept jn methory for the net tantiation and cleanup activities tke opening database! connections tions nee ated foreach ot be called inside a Sind continloys of Regular workfo tbe called For @feastinAlpt XNIL_ploelifecarigt be eet in a cont olectad BY Sigler antinwous wo alt” ate avaliable Rin, dataliows in sub-pro gn and "Run 3a) Separate proc ub ¢ valid to be used Snsle oF Continuous workflows and will sul 2 reusable objeckawhh oc Oba bran, esahary: BOOS FEFO_ TRADING. 15 Data tape [owroten WF OF Gevracdses Unit 2- SAP Data Services sod luegffo andlbut ofa datafiow Vaisbles can also be de To bediscussethjn detl in later topics) Invosys uted Unit2- SAP Data Services Properties of Dataflow. cy: eae Infosys Li Unit2 - SAP Data Services Embedded data flows can help reuse dataflow logic and simplty data flow dispay Typet of Embedded data flow: Three types of embedded data flow ca embedded dataflow Hom existing data tow create such an ofaneddé dstltow, 2). Opea.the dita foWin which the embecdad data flow is required »} Drag ahd drop Af exeting vale dataflow fro objec brary into n theworspace (fom stp a Ah The dite Now can then be|fenarned according to embedded data th andertions starting with eOF Infosys Limtes Uni 2 - SAP Data Services erson table whi ed the port, HRW tf ne output inect to this embedded data flow. this type Bhembedded dot ne oipub embedded data flow. 4) Fn an existing data flow Selettthe'Source object and all connected objects til the objects that are required a pt Click and select “Make Embedded Data flow..” from the dialog Infosys Limited a [= | fom anotherlstingdata tow ject ity ito the parent dat fi embedded data f dat Flow Gan nob used ina data low with come other targe +> Ee 2 flow call will now load the records in PEMAIL ony a Unit 2 SAP Data Services infosys Limted Bypassing dataflow/workflow: aver | ES Unit 2 - SAP Data Services Create Databare Datastore: tables undehyot Stare fo Data services rightclick the datasto tabs in Bog Gatabase defined by the datastore splay ina window inthe infosys Limited Unit 2 - SAP Data Services nabled and optlagbrop and re creat ture Tixeand Gniydeta i truncated a re%teate’ option is unchecked; data wil get sppen etary as. targeMtablelenly once and can be used as'a source table ay numb EF eomsars table Js BeRC=Hb|e on temporary table ne fEmporary table light color Unit 2 - SAP Data Series Target table properties: Rows per commit erect Ootions | Lone cotins | Load Hopes | retoxd Commands | Posted Conard Clete roma oar: imber of Loaders: is set to 2 andtow: ne second bale} 2000 rong writ 72 loading press. One that adr re data loaded, ‘Diions [ete ostine Toei tions | Retoed Connards | Posticed Conard Bore pe com [aso (ite earn ble etre adr: Auto correct losd: hiss the option availble inthe target table which prevents are wo more options avaiable which works along with auto correct loa: Tae! Geter Tee Gate | aadtioors | RetoalCowmmas | Roxie fe pr coat [55 Cl ear ae be te: ust havea primary key column defines Trot Option Yeo Gira | Vand ines | tant Gms | Pond Corman ] pe cont [sony dt om al tere bad: retin heya resend Commands tare WuleLonde Options | sada | ow br amt [ego Mourne Network Pact Seti [4 a file format: sw io esis [Fn Data Fes click the Files Fair icon Sh ate tothe sles_orgtat.Cick open, Peau Format chargeDatet dni put output changeskiptow Headed ta es, WF Arwivutepang sve the column types and lengths as oo target objects: mated witfolumns pa Rs 6 used in late table thathas Wea coated and saved in dation Tee ree and target objects: jects can be used 3s

You might also like