Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.
Process Automation - How to connect to a MS SQL server using Database operator
Article ID: 187731
Process Automation Manager
CA Process Automation Base
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"
Before trying to configure Database operator, the right Driver must be imported, as explained here:
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:
Process Automation 4.3 and above
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: