Integration with BODS Webservice API

Gregg MorrisGregg Morris Senior Infrastructure AnalystPosts: 21 Journeyman ✭✭✭
Currently, we integrate BODS jobs using Unix shell scripts. This is proving to be clumsy when trying to manage environments, getting job reports, and killing hung processes.

Using Automic RA Webservices 3.2, I am working on a POC to perform the following operations:

Job execution
1) Call Logon API and get back SessionID and capture it in a variable -> Only needed if we enable Session security
2) Call Run_Batch_Job with job details ; Get RunID as return value and capture in variable
2) Using RunIDLoop (Get_Trace_LogGet_BatchJob_Status) until Status changes to 'Succeeded' or 'Error'; Probably check every 1 or 2 minutes
3) If Status  = 'Succeded', Call Get_Trace_Log else if Status =  'Error', call Get_Trace_Log followed by Get_Error_Log    (Get_Trace_Log gives generic job log while Get_Error_Log gives only error specific logs)
4) Call Logout to end the session  -> Only needed if we enable Session security

Job cancellation
On Cancellation, Call Stop_Batch_Job using RunID, captured from Run_Batch_Job

Any advice will be appreciated.
Tagged:

Comments

  • Simone MartineschenSimone Martineschen Technical Services Manager Sao Paulo, BrazilPosts: 115 Specialist ✭✭✭✭
    Hello @Gregg Morris ..I'm developing a project similar to yours (BODS integration with WS). Did you have any luck with it? Are you using a standard BODS webservice? Which one?
  • Gregg MorrisGregg Morris Senior Infrastructure Analyst Posts: 21 Journeyman ✭✭✭
    Standard BODS SOAP Webservice.
    The challenge that we ran into was the Session Security over a load balanced BODS system.
    It works fine using a single system as the endpoint, but the Session ID doesn't carry over between the two (or more) servers when using a load balancer as the end point.
    I used SOAP-UI to parse and test the SOAP wsdl.xml
  • Simone MartineschenSimone Martineschen Technical Services Manager Sao Paulo, BrazilPosts: 115 Specialist ✭✭✭✭
    Thank you!
  • Simone MartineschenSimone Martineschen Technical Services Manager Sao Paulo, BrazilPosts: 115 Specialist ✭✭✭✭
    Another question @Gregg Morris ...the basis team is not able to find the Standard SOAP Webservice and enable it. Did you have to make some customization or was it available on your BODS installation? For this project we do not have the BO completely installed, just the DataServices integrator.
Sign In or Register to comment.