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