DE Support for MYSQL

[David Lock]

Hi Guys,

Does DE Series 12.2 support DB Queries to MYSQL without using scripts.
An ability like the SQL Job but connects to MYSQL if we provide the URL to the MYSQL DB like we would for different Oracle Databases.

e.g.
"jdbc:mysql://localhost:3306/SID");  

Or have a dedicated agent for MYSQL

[Ravi Kiran Kunduri]

Hi,

CA Workload Automation DE or DB Agents are not certified on MYSQL. However, I think it should work if you provide the jdbc url and the jdbc driver needed to connect to it.

- Ravi Kiran

[Mathieu Petit]

Hi

Yes, it will work if you copy mysql-connector-java-xxxx.jar in jars/ext

jdbc:mysql://localhost:3306/database