Logo DWBI.org Login / Sign Up
Sign Up
Have Login?
Login
New Account?
Recovery
Go to Login
SAP Data Services

Getting Started SAP BODS

Updated on Oct 01, 2020

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
New Project
Project Name
Project Name
Project Created - Metadata saved in Repository
Project Created - Metadata saved in Repository

CREATE DATASTORE

New Datastore
New Datastore
Datastore Credentials
Datastore Credentials
Datastore Created Successfully
Datastore Created Successfully

IMPORT DATASTORE TABLE BY NAME

Import Table
Import Table
Table Name
Table Name
Table Imported Successfully
Table Imported Successfully

CREATE NEW BATCH JOB

Add Batch Job in Project
Add Batch Job in Project
Batch Job Name and Description
Batch Job Name and Description
Batch Job Created
Batch Job Created

CREATE GLOBAL VARIABLE

BODS Variables
BODS Variables
Create Global Variables
Create Global Variables
Global Variable Created
Global Variable Created

ADD WORKFLOW

Add Workflow in Job
Add Workflow in Job

ADD DATAFLOW

Add Dataflow in Workflow
Add Dataflow in Workflow

Now we will create a simple Mapping or Dataflow.

ADD ROW GENERATION TRANSFORM

Add Row Generation Transform in Dataflow
Add Row Generation Transform in Dataflow
Row Generation Properties
Row Generation Properties

ADD QUERY TRANSFORM

Add Query Transform
Add Query Transform
Link RowGen & Query Transform
Link RowGen & Query Transform

ADD TARGET TABLE TO DATAFLOW

Add Target Table
Add Target Table
Link Query & Target
Link Query & Target

TABLE AND TRANSFORM PROPERTIES

Query Transform Properties
Query Transform Properties
Column Map Logic
Column Map Logic
All Columns Mapped
All Columns Mapped
Target Table Properties
Target Table Properties
Target Table Options
Target Table Options

VALIDATE AND SAVE OBJECTS TO METADATA REPOSITORY

Validate all Objects
Validate all Objects
Save All Objects
Save All Objects

EXECUTE BATCH JOB

Execute Batch Job
Execute Batch Job
Execution Options
Execution Options
Global Variable Value at Execution Point
Global Variable Value at Execution Point

CHECK DATA TO VALIDATE SUCCESSFUL JOB RUN

Job Completed Successfully
Job Completed Successfully
Job Monitor Displays Count
Job Monitor Displays Count
Preview Target Table Data
Preview Target Table Data