ESP dSeries Workload Automation

  • Private Community
 View Only

  • 1.  DE Series - MQSQL Query Support

    Posted Mar 04, 2020 04:04 PM
    DE Series - MQSQL Query Support

    Can D Series make MYSQL queries using SQL job
    If I set the URL to a MYSQL Server can I query a MYSQL DB Table.

    I would like to see custom MYSQL jobs and that would be seen as more functionality in the DE Series toolbox. 


  • 2.  RE: DE Series - MQSQL Query Support
    Best Answer

    Broadcom Employee
    Posted Mar 05, 2020 01:18 AM
    Hi,

    Looks like the DB Plugin does not support MYSQL  database as of now.
    The documentation below points to the supported database types.

    http://techdocs.broadcom.com/content/broadcom/techdocs/us/en/ca-enterprise-software/intelligent-automation/workload-automation-agent-for-databases/11-5/release-notes/ca-wa-agent-for-databases-platform-support-matrix.html

    -Ravi Kiran
    Original Message


  • 3.  RE: DE Series - MQSQL Query Support

    Posted Mar 05, 2020 09:48 AM
    Hi Kunduri 

    This is awful,   you have a monitor job for MYSQL, but we can't even query a MYSQL DB.
    Altryx can query Oracle, MYSQL etc, and it can output to a proper CSV file.

    Are we still in the 90's

    Come on Broadcom (CA) we need this functionality out of the box.
    It has Executives looking at this product and asking "why can't it connect to a MYSQL DB", then all bets are off for staying on DE Series.

    This should be a priority and should have been available years back.





    Original Message