This article is a step by step guide to learn the basic of SAP BODS. Starting from the Basic we will cover the essential topics like SCD implementation, Fact loading, CDC Mechanisms, Persistent Cache, Substitution Parameters, Variables and Parameters, Data Quality and many more.

Getting Started with SAP BODS DESIGNER

After BODS Installation, let us try to look at the basics of creating Project, Datastore, Import Table, Batch Job, Workflow, Dataflow and executing a simple Job.

Now we will go step by step after loging into the SAP BODS Designer Console. Here the given screen-shots are self explanatory.

  • CREATE PROJECT

    New Project

    Project Name

    Project Created - Metadata saved in Repository

  • CREATE DATASTORE

    New Datastore

    Datastore Credentials

    Datastore Created Successfully

  • IMPORT DATASTORE TABLE BY NAME

    Import Table

    Table Name

    Table Imported Successfully

  • CREATE NEW BATCH JOB

    Add Batch Job in Project

    Batch Job Name and Description

    Batch Job Created

  • CREATE GLOBAL VARIABLE

    BODS Variables

    Create Global Variables

    Global Variable Created

  • ADD WORKFLOW

    Add Workflow in Job

  • ADD DATAFLOW

    Add Dataflow in Workflow

    Now we will create a simple Mapping or Dataflow.

  • ADD ROW GENERATION TRANSFORM

    Add Row Generation Transform in Dataflow

    Row Generation Properties

  • ADD QUERY TRANSFORM

    Add Query Transform

    Link RowGen & Query Transform

  • ADD TARGET TABLE TO DATAFLOW

    Add Target Table

    Link Query & Target

  • TABLE AND TRANSFORM PROPERTIES

    Query Transform Properties

    Column Map Logic

    All Columns Mapped

    Target Table Properties

    Target Table Options

  • VALIDATE AND SAVE OBJECTS TO METADATA REPOSITORY

    Validate all Objects

    Save All Objects

  • EXECUTE BATCH JOB

    Execute Batch Job

    Execution Options

    Global Variable Value at Execution Point

  • CHECK DATA TO VALIDATE SUCCESSFUL JOB RUN

    Job Completed Successfully

    Job Monitor Displays Count

    Preview Target Table Data


Have a question on this subject?

Ask questions to our expert community members and clear your doubts. Asking question or engaging in technical discussion is both easy and rewarding.

Are you on Twitter?

Start following us. This way we will always keep you updated with what's happening in Data Analytics community. We won't spam you. Promise.

  • Using MERGE Transform in SAP Data Services

    This tutorial describes how to use MERGE transform in SAP Data Services (formerly known as BusinessObjects Data Services). A short video is also provided to provide hands-on.

  • Auditing in SAP Data Services

    A proper data reconciliation process must be in place in any data Extraction-Transformation-Load (ETL) process. A successful reconciliation process should only indicate whether or not the data is correct. But data reconciliation is not easy....

  • How to use Data Services Reverse Pivot Transformation

    In this article, we will learn how to use SAP Data Services Reverse Pivot Transform. The Reverse Pivot transformation combines data from several rows into one row by creating new columns. For each unique value in a pivot axis column and each...

  • Map_CDC_Operation in Data Services

    Map CDC Operation is used to support relational or mainframe changed-data capture (CDC). This transform reads the source DML changes i.e. INSERT/UPDATE/DELETE and reflects the same in the target system. So the transform maps all the source rows...

  • Data Services Metadata Query Part 3

    This article is a continuation of the previous topic related to Data Services Metadata Query. Let us explore more into the Data Services Repository Metadata.

  • Data Services Scripting Language

    We can use the Data Services Scripting Language to write scripts and custom functions to address complex logical expressions.

  • Learning SAP Data Services - Online Tutorial

    We are pleased to start this new tutorial page for SAP BusinessObjects Data Services (BODS). If you do not know SAP Data Services (BODS) yet but wish to master this ETL tool, you have come to the right place. Even if you are already familiar with...

  • Data Services Metadata Query Part 1

    Data Services provides full access to the repository metadata tables and views for metadata analysis. To access this metadata either we can use SQL SELECT statements or use the metadata reporting from Management Console.

  • Why SAP Data Services

    SAP BusinessObjects Data Services delivers a single enterprise-class solution for Data Integration, Data Quality, Data Profiling, and Text Data Processing that allows us to integrate, transform, improve, and deliver trusted data to critical...

  • Fools Guide to BODS - Registering Repository to CMC

    In our earlier article, we have learnt how to create a repository in BODS. Once that part is done, The final process before launching the BODS application is registering the repository with...