MYSQL Database Agent Support

Document ID : KB000122943
Last Modified Date : 12/12/2018
Show Technical Document Details
Question:
Does DE Support MYSQL (Not Microsoft) Database Connection/Agents DB URL? I am looking to connect to Oracle MYSQL. Does the agent provide support for MySQL database?
 
Answer:
Utilizing the database plugin for the system agent against a MySQL database should work. You will need to ensure the following:
  1. the jdbc driver is in the classpath.
  2. the driver classname is defined in the agentparm.txt.
  3. the correct jdbc url is defined in the job definition.
The caveat to this is that DB trigger type jobs will not work. This is because we ship the properties files specific to each of the databases; with SQL statements, to allow for creation of the trigger and related tables. It is the incompatibility of db triggers that make it so we can't do a blanket "bring your own jdbc" for the database plugin.