Purpose of this Documentation:

The main agenda behind creating this documentation is to know how to create a project, job , one to one mapping and job execution in Data Service designer.

 

SAP-Business Objects Data Services (BODS) Version — 14.2.5.800

 

Following are the steps to proceed things in a particular manner.

 

Step 1:

  • Click on windows button and then select the Data Service Designer.

 

Step 2:

  • After clicking on that designer “SAP Data Service repository login” dialogue box will be displayed on your system.

 

 

 

 

Step 3:

  • We have to enter the required credentials.

 

Step 4:

  • Then after click on the Log On button.

 

 

 

Step 5:

  • After click on Log On button we can able see some repositories.

 

Step:6

  • Choose the repository whatever we have assigned.

 

Step 7:

  • Click on “OK” Button.

 

Step 8:

  • SAP Data Service designer window will be opened after clicking OK.

Step 9:

  • Designer window is divided the screen into 3 parts

1.Structure area

2.Project area

3.Local object Library

  • Please follow the below pictures for an easy way to find the allocated areas of Designer.

 

This picture is belongs to Structure area

 

————This picture belongs to project area

———-This picture belongs to Local object library

 

Step 10:

  • Now we can able create new project here also we have 3 ways to create new project.

1.Go to structure area and right click on that new project then “project new” window will be open and we have to enter the name of the project and click on “create”.

  • Please follow the picture for how to create new project in structure area.

Step 11:

 

  • Click on the Create Project.

 

Step :12

  • Then project window will be displayed

 

Step 13:

  • we have to enter project name as per the Client requirement.

 

   Step 14:

  •  Click on create option

 

Step 15:      

  • Now new project will be created on project area

 

Step 16:  

  • Alternate option for project creation is
  • Go to project area and click on the project and select new project

 

Step 17:

  • Now “project new”  window will be opened.

 Now project creation is same what i was explained in previous steps of project creation.

 

Step 18:

  • 3rd option for project creation
  • Go to upper pallet and click on symbol of the highlighted part.

 

Step 19:

  • Now “project new” window will be open

 Now project creation is same what i was explained in previous steps of project creation.

Step 20:

  • Now we are going to create job
  • Go to project area and click on the project and choose “New batch job”

 

Step 21:  

  •  Click on the New batch job then one small dialogue box will be opened.

Step 22:

  • Rename the job what we wanted to keep.

Step 23:

  • Now we can create work flow. Go to right side pallet and choose the work flow symbol

 

Step 24:

  • Click on that symbol and drag to structure area

 

Step 25:

  • Now we can change the name of work flow as per the requirement.

Step 26:  

  •  Now we have to create Data flow. Go to right side pallet and select Data flow symbol.

Step 27:

  • Click on the data flow symbol and drag into structure area

Step 28:

  • Now we can change the name of Data flow as per the requirement

    

Step 29: 

  • Now we will be knowing about one to one query mapping of flat files
  • we can able to do query mapping in only Data flow
  • Flat files are located in local object library. please see the highlighted portion in below picture

Step 30:

  • Click on that symbol then flat files will retrieved in local object library.

 

Step 31:

  • Click on that flat files and choose new option to import new flat files.

Step 32:

  • Then click on that new option now then “File format Editor” window will be open.

Step 33:

  • We have to rename the name option as per the requirement.

 

Step 34:

  • Delete selected name and  we have to give required name

Step 35:

  • Now we have come to root directory and paste selected path there.

Step 36:

  • We have to go to require flat file area and selected and select that path

                        Note: The following steps are depending upon the company rules what i will mention in below picture .

  • Click windows+R  button then run dialogue box will be open.

Step 37:

  •   Enter the require path in run dialogue box and then click on OK button.

Step 38:

  • Now path location will be opened then we will copy the path location as highlighted.

 

Step 39:

  • Now we will paste the path location near Root directory of file format editor.

Step 40:

  • Now double click on “file name(s)” symbol

Step 41:

  • Now path location will be opened that we have provided at root directory.

Step 42:

  • Select which file you have to take as a source file and click on open button

Step 43:

Now a window pops up with YES or NO options then we have select yes option

Step 44: 

  • We have to rename the following columns as per the requirement, there are

1.NAME

2.column

3.Skip row header

Please follow the below picture for how to change.

Picture-1:

Picture 2:

  • Select which option you want.

Picture 3:

Step 45:

  • Now click on “save” and save&close” option.

 

Step 46:

  • Now we can able to see the our source file in “Local object Library”

Now go to flat files and check whether the require files is there or not.

Step 47:

  •  Now we will go to structure area and do one to one query mapping.
  •  First click on source file and drag into structure area and select “make source” option

Step 48:

  • Click on “make source” then source file will be created on designer area.

step 49:

  • Now we will rename the source file for easy identity.

 

Step 50:

  • Now go to Right side pallet and single click on mapping symbol and drag into designer area.

Step 51:

  • Now we have to do mapping the source file with the query via an arrow.

Step 52:

  • Now mapping area captures the data from source file
  • Double click on that query mapping then “Schema in”,”schema out” and “Schema remapping area’s will be opened.

Step 53:

  • Now we have to transfer the data from schema in to schema out.
  • Select all data from schema in and copy at schema out.
  • If you want only required data just drag required columns from schema in to schema out.

Step 54:

  • Come to data flow and single click on “template table symbol” and drag into structure area as a “Target file”

Step 55:

  • Now one dialog box will be opened in structure area then we will be creating template as target table.
  • Now we want to enter table name what we require.
  • Select the data store what we require and click OK button.

Step 56:

  • Now the target file will be created in structure area.

Step 57:

  •  Now we will be mapping the query to target table

Step 58:

  •   Go to query editor and click on “save all” option then “save all changes” window will be opened in structure area and click “ok” button after save all changes in dataflow.

step 59:

  • Now target file is stored in data-store.

Step 60:

  • Now go to upper pallet and click on “validate” option then one output window will be open, If there are no errors that means everything is fine in mapping.

Step 61:

  • Now go to job execution
  • Go to project area and right click on the job and execute

Step 62:

  •    Then execution properties window will be open, check the job server and click OK button

Step 63:

  • After clicking OK button  you will be able to see the job result in designer area.

 

Thank You!

 

 

To report this post you need to login first.

Be the first to leave a comment

You must be Logged on to comment or reply to a post.

Leave a Reply