PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 05/29/2014 1:09 PM by  Kimm
Enterprise Job Scheduling & Lawson (TIDAL)
 5 Replies
Sort:
You are not authorized to post a reply.
Author Messages
Garth Gerwing
Solution/Integration Architect
Workers Compensation Board of Manitoba
Basic Member
(43 points)
Basic Member
Posts:27


Send Message:

--
01/04/2012 2:58 PM
    We are currently using TIDAL as an enterprise job schedular. We would like to also use it to trigger and manage Lawson jobs - whereby we can manage timing and dependencies between Lawson jobs and non-Lawson jobs.

    NOTE: am aware that TIDAL has an extension product of: Lawson Enterprise Adaptor

    Does anyone have experience with either:
     - usage of the TIDAL Lawson Enterprise Adaptor - costs, effectiveness, complexity?
     - interfacing between TIDAL and Lawson without the use of the above adaptor?

    Any feedback would be most appreciated - thanks.
    Woozy
    Private
    Private
    Veteran Member
    (3469 points)
    Veteran Member
    Posts:701


    Send Message:

    --
    01/05/2012 1:27 PM

    Hi Garth - We don't use TIDAL and I have zero knowledge of it, but we use Control-M as our enterprise scheduler for almost all of our Lawson processes including S3 batch jobs, S3 ProcessFlows, LTM async tasks, and LTM ProcessFlows. 

    Control-M basically just gives us the ability to run tasks from the command line.  If TIDAL does the same thing, then this should work for you.

    We've created a small number of scripts that call the lawson command-line utilities.  Generally our scripts launch a process, then watch until it completes or errors, then notify a distribution list that it completed or failed.

    We have scripts for:
    - launching S3 batch programs (jqsubmit/wtsubmit)
    - watching for S3 batch completion/error (jqstatus)
    - launching S3 processflows (fileclient)
    - watching for S3 pflow completion (rngdbdump against LOGAN>wfworkunit)
    - launching LTM processflows
    - launching LTM async tasks

    Basically, we create ControlM jobs that call the appropriate script(s) and pass in the required parameters for program, user, job, etc.

    Since S3 provides dedicated command-line tools for these tasks, this is pretty straightforward.  LTM is more complicated because they don't provide those types of utilities, so we had to fake the system to do what we needed it to do.

    Good luck.

    Kelly Meade
    J. R. Simplot Company
    Boise, ID
    Garth Gerwing
    Solution/Integration Architect
    Workers Compensation Board of Manitoba
    Basic Member
    (43 points)
    Basic Member
    Posts:27


    Send Message:

    --
    01/06/2012 10:49 AM
    Thanks for the timely response, Kelly.

    Process Flow and LTM don't factor-in to our scenario (just S3 batch jobs) - so it would appear we are good-to-go. Next steps for us, then, is to investigate the scripting capabilities of TIDAL - and I am pretty sure that we can get this going with a little tinkering.

    Very much appreciate the feedback.
    LauraP
    Private
    Private
    Advanced Member
    (70 points)
    Advanced Member
    Posts:28


    Send Message:

    --
    01/13/2012 10:37 AM
    Hi Garth -

    We've been using Tidal now for the majority of our Lawson processing for almost 2 years. We use the Lawson adapter and it works quite well. We have alot of Visual Basic processes, .NET processes and PL/SQL Stored Procedures that need to be run in conjunction with the Lawson jobs so Tidal has worked really well in stringing all the pieces together.

    We have even used email to trigger the execute of a job (Tidal looks for a specific value in the Subject Line).

    If you'd like to discuss it further - I'd be happy to talk with you by phone and I could get our head BIS Job Scheduler to meet as well - he set the majority of the processing up and is VERY familiar with Tidal and it's tie to Lawson.

    Feel free to email me directly at lpatena@yankeecandle.com

    - Laura
    Garth Gerwing
    Solution/Integration Architect
    Workers Compensation Board of Manitoba
    Basic Member
    (43 points)
    Basic Member
    Posts:27


    Send Message:

    --
    11/07/2012 12:26 PM
    Hey Kelly,

    I know it has been awhile RE this - but I have just now got my hands on a TIDAL DEV environment - and want to enact some "Proof-Of-Concept" testing RE this.
    As I previously mentioned - it's only the S3 batch-related aspects that concern us - so, as per above:
       - launching S3 batch programs (jqsubmit/wtsubmit)
       - watching for S3 batch completion/error (jqstatus)

    I was wondering if it would be at all possible for you to shoot me an example of your script(s) for each of the above? This would really allow me to hit the ground running. Appreciate your time and consideration of this matter.  My direct email = ggerwing@wcb.mb.ca

    Garth

     
    Kimm
    Software Developer
    Artisan Partners
    Basic Member
    (11 points)
    Basic Member
    Posts:5


    Send Message:

    --
    05/29/2014 1:09 PM
    Hi All,

    We are looking into this same idea for our Infor 10 install. As with Garth, this would just be for S3 batch programs and tokens (importdb and GL165). We're moving to ActiveBatch from TIDAL. Can anyone provide example scripts for how they're accomplishing this?
    You are not authorized to post a reply.