Process Automation - How to connect to a MS SQL server using Database operator

Products

• Process Automation Manager
• CA Process Automation Base

Issue/Introduction

In order to use Database operators, there are few fields that have to be filled before trying to run it, among them is the Driver name, which if filled incorrectly, the next error may appear:

 

"Could not load database driver"

 

 

Environment

Process Automation 4.3 and above

Cause

Before trying to configure Database operator, the right Driver must be imported, as explained here:

 

https://techdocs.broadcom.com/content/broadcom/techdocs/us/en/ca-enterprise-software/intelligent-automation/automic-process-automation/04-3-04/administrating/administer-components/administer-user-resources/upload-orchestrator-resources.html

 

Which will result in the following:

 

 

But a common mistake is to use this same resource as Driver in the configuration of Database operator as follow:

 

 

Which will result in the following error:

 

 

Resolution

The driver required for the Database operator is located under: Configuration tab -> Domain -> (lock Domain) -> Connectors -> Databases, as shown in the following image:



So, the actual Driver required is:

"com.microsoft.sqlserver.jdbc.SQLServerDriver"