ESP dSeries Workload Automation

  • 1.  Does CA DE Support Oracle MYSQL

    Posted Dec 12, 2018 02:30 PM

    I wish to query a MYSQL Database.

    I see CA DE has SQL Job and can take URL.

    Will it connect to a MYSQL database?

     

    How can I extract data from one database (table) and insert it into another table in another DB.

    E.g. MYSQL -> ORACLE

     

    Does CA DE support anything like this.

     

    From what I have seen CA DE SQL job can pull records into the Spool file, but that's it.



  • 2.  Re: Does CA DE Support Oracle MYSQL
    Best Answer

    Posted Dec 12, 2018 03:40 PM

    Hi David, 

    I would recommend using the database import/export tools/utilities provided by both db products. These can be added to scripts and done in batch if needed.  

     

    2¢ 



  • 3.  Re: Does CA DE Support Oracle MYSQL

    Broadcom Employee
    Posted Dec 13, 2018 01:12 AM

    Hi,

     

    If your query is regarding the databases that are supported by database plugin jobs like SQL then it looks like MYSQL is not supported currently.

     

    Refer the doc - CA WA Agent for Databases Support Information - CA Workload Automation Agent for Databases - 11.3 - CA Technologies Docu…  for more information.

     

    I agree to the suggestion provided by Powell.

     

    Hope it helps,

    Ravi Kiran



  • 4.  RE: Re: Does CA DE Support Oracle MYSQL

    Posted Mar 04, 2020 03:32 PM
    Kunduri Kiran

    Can a DE Database Agent query a MYSQL DB in general.
    I want to query a MYSQL DB using CA Workload Automation DE Series.
    I see MYSQL Server Monitor.




  • 5.  RE: Re: Does CA DE Support Oracle MYSQL

    Broadcom Employee
    Posted Mar 05, 2020 02:27 AM
    Hi,

    No , SQL jobs cannot talk to MYSQL database.

    Ravi Kiran