Skip to Content
avatar image
Former Member

BODS Technical Design Document

Hi all,I would like to know how Technical Design Document is created in BODS,what information to be included from the ETL prespective.Please give me an example template.Please give the information in detail,need it very urgent.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Nov 02, 2015 at 06:30 AM

    Hi devika,

    Firstly,go to data services management console then you will find an option called AUTO DOCUMENTATION just below the ADMINISTRATION. If you go in to that tab then you have select your repository and project then the job you wanted to document.Select the respective job or job then find the print option on the top then the DS will genearate an auto documentation to save it as a PDF or Ms word you like.

    Try it and tell me that this is the one your looking for or not

    Regards,

    Naveen

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Your question is generic.

      The technical spec needs to expain the purpose of each Data Dervices object (Table/ WF/DF/File format) that are to be created with in the job or project.

      The techinical specification document template varies depending on the project need.A typical data conversion project involving SAP Data Services , a technical spec document contains the following information.

      1.Introduction1.1Overview1.2Conversion Process Description1.3Changes for Release2.Implementation – SAP DS2.1Jobs2.2Extraction Jobs2.2.1Special Extraction2.2.2Pre-load Validation  Extraction2.2.3Post-load Validation  Extraction2.3Inputs and Outputs2.3.1Input Tables (External to this WRICEF)2.3.2Input files2.3.3Output Tables2.3.4Pre-Load Output Files2.3.5Post-Load Output Files2.3.6Load File Structure2.4Transformation2.4.1Workflows2.4.2Dataflows2.2.3Exceptional Field Mapping2.5Pre-load Validation Details2.5.1Pre-load Validation steps2.6XREF Generation  Details2.6.1XREF Generation steps
  • Nov 03, 2015 at 05:21 AM

    You can also club following sections to make your document perfect.

    1. 1.Introduction / Overview...

    2          Environment Details for Extracts.. 2

    1. 2.1    
           Source Information. 23

    1. a.       
           Destination Information. 23

    1. b.       
           BODS Server Information. 24

    1. c.       
           File Folder Structure. 25

    3          BODS
    Server Details. 27

    1. 3.1
           Dev Environment 27

    1. 3.2
           QA Environment

    PROD Environment 37

    4        
    Column Mapping.. 44

    5          BODS
    Objects structure.. 45

    6          Architectural View... 5

    1. 6.1.1    Source Layer. 50

    1. 6.1.2    Staging

           Layer
      . 50

    1. 6.1.3    EDW Layer. 50

    1. 6.1.4    Target Layer. 50

    1. 6.1.5    Source Layer. 50

    1. 6.1.6    Staging

           Layer
      . 50

    1. 6.1.7    EDW Layer. 50

    1. 6.1.8    Target Layer. 50

    7          Business Requirement.. 5

    8          High Level Approach.. 52

    9          Detailed Business Process.. 59

    10       Error Handling.. 7

    11       Data Source Requirements.. 78

    12       Observations from Data Analysis.. 79

    1. 12.3
           Data Model Diagram:

    1. 12.4
           Data Model

           Diagram:

    1. 12.5
           Data Model Diagram:

    1. 12.6
           Data Model Diagram:

    1. 12.7
           List of Tables. 84
    Add comment
    10|10000 characters needed characters exceeded