Join the Community

Sponsor

Free BI Digest

Need more help on this subject?

Getting Started SAP BODS

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

    Project Name

    Project Created - Metadata saved in Repository

  • CREATE DATASTORE

    New Datastore

    Datastore Credentials

    Datastore Created Successfully

  • IMPORT DATASTORE TABLE BY NAME

    Import Table

    Table Name

    Table Imported Successfully

  • CREATE NEW BATCH JOB

    Add Batch Job in Project

    Batch Job Name and Description

    Batch Job Created

  • CREATE GLOBAL VARIABLE

    BODS Variables

    Create Global Variables

    Global Variable Created

  • ADD WORKFLOW

    Add Workflow in Job

  • ADD DATAFLOW

    Add Dataflow in Workflow

    Now we will create a simple Mapping or Dataflow.

  • ADD ROW GENERATION TRANSFORM

    Add Row Generation Transform in Dataflow

    Row Generation Properties

  • ADD QUERY TRANSFORM

    Add Query Transform

    Link RowGen & Query Transform

  • ADD TARGET TABLE TO DATAFLOW

    Add Target Table

    Link Query & Target

  • TABLE AND TRANSFORM PROPERTIES

    Query Transform Properties

    Column Map Logic

    All Columns Mapped

    Target Table Properties

    Target Table Options

  • VALIDATE AND SAVE OBJECTS TO METADATA REPOSITORY

    Validate all Objects

    Save All Objects

  • EXECUTE BATCH JOB

    Execute Batch Job

    Execution Options

    Global Variable Value at Execution Point

  • CHECK DATA TO VALIDATE SUCCESSFUL JOB RUN

    Job Completed Successfully

    Job Monitor Displays Count

    Preview Target Table Data

About the Author

Saurav Mitra

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



If you have any doubt or question on the above article, please Ask your question here. We will surely help you out!

Before you leave, Kindly provide your comments / suggestions / feedback below. Thank You!

 

READ OUR RECOMMENDED ARTICLES