REAL TIME JOB DEMO

A real-time job is created in the Designer and then configured in the Administrator as a real-time service associated with an Access Server into the management console..

This Demo will briefly explain the management console setting ..

We can execute the Real time job from any third party tool. let us use SOAPUI(third party tool) to demonstrate our Real time job.

Below is the screenshot of Batch Job used to create a sample table in the database(First Dataflow) and create the XML target file(second Dataflow). The XML Target file(Created in the second Dataflow) can be used to create the XML MESSAGE SOURCE in the real time job.

Below is the screenshot transformation logic of dataflow(DF_REAL_Data)

Capture.JPG

Below is the screenshot transformation logic of dataflow(DF_XML_STRUCTURE)

Capture.JPG

Below is the screenshot transformation logic of Query Transform “Query” used in DF_XML_STRUCTURE

Capture.JPG

Below is the screenshot transformation logic of Query Transform “Query” used in DF_XML_STRUCTURE

Capture.JPG

Capture.JPG

Capture.JPG

Capture.JPG

Capture.JPG

Capture.JPG

Below image show the creation of the Real time job in Data services.

Capture.JPG

Capture.JPG

Capture.JPG

Capture.JPG

Capture.JPG

Capture.JPG

FINALLY RUN THE REAL-TIME JOB USING SOAP UI TOOL

  1. Run the SoapUI tool
  2. Create the project à browser the WSDL file.
  3. Under project àReal-time servicesàcheck the project nameàsend the request.
  4. Request Window will open now enter the search string in it.
  5. Finally the record will come.
To report this post you need to login first.

11 Comments

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

  1. venkata P

    I have a task of eliminating duplicates based on first name and last name in a table  using Match transformation.

    Can any one help.

    (0) 
    1. Ravi Kashyap Post author

      Hi ,

      In real time job we can use one XML source message and one XML target message. As we are aware realtime job process one records at a time.

      Cheers !

      Ravi

      (0) 
  2. Pablo Silvestro

    Nice Information.

    I need to know if there a way to free flat files as source in Realtime job.

    because keep taken while the service is running.

    regards

    (0) 
  3. Coco Dai

    Hi Ravi,

    Our team is trying to find a solution for replicating data changes from source hana to target hana system. We could use DataService batch job to do this but it could only be triggered at most every 1 minutes. While our laterncy expectation is less than 10 seconds.So we start to look into the “realtime” job.

    Seems the realtime job could only process one record at one time.

    Is it suitable for replicating db changes for several tables?

    Thanks,

    Coco Dai

    (0) 

Leave a Reply