Logo DWBI.org Login / Sign Up
Sign Up
Have Login?
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.
Login
New Account?
Recovery
Go to Login
Google icon Login or Sign Up with Google Facebook icon Login or Sign Up with Facebook Twitter icon Login or Sign Up with Twitter
By continuing you indicate that you agree to Terms of Service and Privacy Policy of the site.
SAP Data Services

Getting Started SAP BODS

 
Saurav Mitra
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
PrimeChess

PrimeChess.org

PrimeChess.org makes elite chess training accessible and affordable for everyone. For the past 6 years, we have offered free chess camps for kids in Singapore and India, and during that time, we also observed many average-rated coaches charging far too much for their services.

To change that, we assembled a team of top-rated coaches including International Masters (IM) or coaches with multiple IM or GM norms, to provide online classes starting from $50 per month (8 classes each month + 4 tournaments)

This affordability is only possible if we get more students. This is why it will be very helpful if you could please pass-on this message to others.

Exclucively For Indian Residents: 
Basic - ₹1500
Intermediate- ₹2000
Advanced - ₹2500

Top 10 Articles

Introduction to ANSI SQL

SAP BODS Transforms

Top 25 Unix interview questions with answers (Part I)

Top 50 SAP Business Objects Data Services (BODS) Interview Questions with Answers

Data Services Scripting Language

How to find out Which User is Running what SQL Query in Oracle database?

How to find out Expected Time of Completion for an Oracle Query

Best Informatica Interview Questions & Answers

Useful Informatica Metadata Repository Queries

How to install SAP BODS - Standalone