DWBI CONCEPTS

Getting Started SAP BODS

Details

Category: ETL BODS

Last Updated on Wednesday, 10 October 2012 04:12

Written by Saurav Mitra

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

  

  

  

About the Author

Saurav Mitra is a business intelligence professional.
Connect with the author via Google+