Process Automation - How to connect to a MS SQL server using Database operator
book
Article ID: 187731
calendar_today
Updated On:
Products
Process Automation ManagerCA 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:
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: