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
CREATE DATASTORE
IMPORT DATASTORE TABLE BY NAME
CREATE NEW BATCH JOB
CREATE GLOBAL VARIABLE
ADD WORKFLOW
ADD DATAFLOW
Now we will create a simple Mapping or Dataflow.
ADD ROW GENERATION TRANSFORM
ADD QUERY TRANSFORM
ADD TARGET TABLE TO DATAFLOW
TABLE AND TRANSFORM PROPERTIES
VALIDATE AND SAVE OBJECTS TO METADATA REPOSITORY
EXECUTE BATCH JOB
CHECK DATA TO VALIDATE SUCCESSFUL JOB RUN
