Test Data Manager

Expand all | Collapse all

Triggering Mainframe Jobs with CA TDM Portal

  • 1.  Triggering Mainframe Jobs with CA TDM Portal

    Posted 01-18-2019 12:48 PM

    Hi All,

     

    We developed some custom functionalities which let you use all TDM Mainframe Add-on functionalities through CA Test Data Manager Portal (also through DataMaker).

     

    Basically, It lets you to submit and run Mainframe jobs to UNLOAD and LOAD masked data from source DB2 system to target DB2 system. You can submit those jobs from CA TDM Portal and get any information (Status, Return Codes, Execution Steps, Audits, Reports etc) about Mainframe jobs submitted in the back round. That means any data requester can run that masking/subsetting jobs without the knowledge of Mainframe. That makes TDM to be used more widely and effectively.

     

    By using this customization, you don't need to connect Mainframe terminal directly through 3270 emulator.

     

    For further information, please feel free to contact me.

     

    Cihan Ankara

    cihan.ankara@gunittech.com

     

     

    Below you may find some screenshots about the process.

     

    1. Service Catalog for Mainframe Integration

     

     

    2. Submitting UNLOAD(GTXMSKL) and LOAD(GXMSKL2) Jobs to Get Masked Subset

     

     

    3. Run Masking Job in Simulation Mode to Get Audit Reports

     

     

    4. Audit Files in MF and Shared

     

     

    5. MF Job Logs

     

     

    6. Submitted JCL and Outputs of the Job

     

    ####



  • 2.  Re: Triggering Mainframe Jobs with CA TDM Portal

    Posted 01-21-2019 04:08 AM

    This is very interesting. it will be helpful if you tell us how the designed these self service flows. Did you use Javelin to connect to MF?.



  • 3.  Re: Triggering Mainframe Jobs with CA TDM Portal

    Posted 01-21-2019 04:29 AM

    Hi,

     

    Javelin has the orchestrator role in here. It orchestrates all necessary steps to trigger MF jobs. There is also some custom code development behind it.

     

    Best,



  • 4.  RE: Triggering Mainframe Jobs with CA TDM Portal

    Posted 06-10-2019 05:28 AM
    Also recommend looking at CA Brightside which has APIs to do the job submission and output retrieval.


  • 5.  RE: Triggering Mainframe Jobs with CA TDM Portal

    Posted 06-10-2019 03:36 PM
    Edited by Cihan Ankara 06-10-2019 03:47 PM


  • 6.  RE: Triggering Mainframe Jobs with CA TDM Portal

    Posted 06-10-2019 03:36 PM
    Edited by Cihan Ankara 06-10-2019 03:48 PM


  • 7.  RE: Triggering Mainframe Jobs with CA TDM Portal

    Posted 06-10-2019 03:36 PM
    Edited by Cihan Ankara 06-10-2019 03:48 PM


  • 8.  RE: Triggering Mainframe Jobs with CA TDM Portal

    Posted 06-10-2019 03:36 PM
    Edited by Cihan Ankara 06-10-2019 03:48 PM


  • 9.  RE: Triggering Mainframe Jobs with CA TDM Portal

    Posted 06-10-2019 03:36 PM
    That's right. TDM has now similar but not same functionality. Glad to inspire product management to develop that functionality after having several webex sessions about the idea. However still needs some improvement to get rid of some manual operations. Special thanks to Walter Guerrero!

    ------------------------------
    Managing Consultant
    GUNITTECH
    ------------------------------