The SQL connection object is failing with error message "U02012064 No driver found"
Article ID: 185621
CA Automic Workload Automation - Automation Engine
The target DB is called Denodo and the connection string used in the connection object is as shown below.
When you click on Test button of the connection object, the error message is shown below.
Release : 12.3
Component : AUTOMATION ENGINE
For this particular case, the string in the connection string is incorrect. The string vdp should be vbd.
jdbc:vdp://<hostname of the denodo>:<port of Denodo>/btatest
jdbc:vdb://<hostname of the denodo>:<port of Denodo>/btatest
Please modify the connection string from jdbc:vdp://<hostname of Denodo>:<port of Denodo>/btatest to jdbc:vdb://<hostname of Denodo>:<port of Denodo>/btatest
Another possible solution is to make sure that jdbc driver of the Denodo database is present in the <DB Service agent>\bin\jdbc.