SAP BODS Data Services Overview - SAP BODS

What is SAP BODS Data Service Overview?

Data Services administration contains creating real time and batch jobs, preparation jobs, inserted data flow, variables and parameters, recovery mechanism, data profiling, Presentation tuning, etc.

Real Time Jobs

You can form real time jobs to process real time messages in Data Services designer. Like a batch job, real time job extracts the data, transforms and loads it.

Every real time job can abstract data from a single message. You can also abstract data from further sources like tables or files.

Real time jobs are not performed with the help of triggers different batch jobs. They are affected as real time services by managers. Real time services wait for messages from access server. Access server accepts this message and passes it to real time services, which is configured to process the message type. Real time services implement the message and precede the result and continue to process the messages until they get an instruction to stop executing.

Real Time vs. Batch Jobs

Transforms like the divisions and switch reason are used more often in real time job, which is not the case with batch jobs in designer.

Real time jobs are not performed in reply of a schedule or internal trigger unlike the batch jobs.

Creating Real Time Jobs

Real time jobs can be generated using same substances like data flows, work flows, loops, conditionals, scripts, etc.

You can use the following data models for making real time jobs −

  • Single data flow model
  • Multiple data flow model

Single data flow model

You can make a real time job with single data flow in its real time processing loop and it contains a single message source and single message target.

Creating Real Time job using single data model −

To create Real Time job using single data model, follow the given phases.

Step 1 − Go to Data Services Designer → Project New → Project → Enter the Project Name


Step 2 − Right click on the white space in Project area → New Real time job.


Workspace displays two constituents of Real time job −

  • RT_Process_begins
  • Step ends

It displays the start and the end of real time job.


Step 3
− To create a real time job with single data flow, choice data flow from the tool palette on the right panel and drag it to the work space.
Click inside the loop, you can use one message source and one message target in real time processing loop. Associate the starting and the end scripts to the data flow.


Step 4 − Add configure things in data flow as required and save the job.

Multiple data flow model

This permits you to create a real time job with multiple data flow in its real time processing loop. You also need to confirm that the data in each data model is fully treated before it moves to the next message.

Testing Real Time Jobs

You can test the real time job by passing the sample message as source message from the file. You can check if the Data Services make the estimated target message.

To ensure that your job gives you the expected result, you can perform the job in view data type. Using this type, you can release output data to make sure that your real time job is working fine.

Embedded Data Flows

Embedded data flow is known as data flows, which are called from alternative data flow in the plan. The embedded data flow can hold many numbers of source and targets but only one input or output pass data to main data flow.

The following kinds of embedded data flows can be used

  • One Input − Embedded data flow is added at the end of dataflow.
  • One Output − Embedded data flow is added at the beginning of a data flow.
  • No input or output − Replicate an existing data flow.

Embedded data flow can be used for the following determination −

  • To simplify the data flow display.
  • If you want to save the flow logic and reuse it in other data flows.
  • For debugging, wherein you create sections of data flow as embedded data flow and execute them separately.


All rights reserved © 2020 Wisdom IT Services India Pvt. Ltd Protection Status