search cancel

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

book

Article ID: 187731

calendar_today

Updated On:

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"
 
 

Cause

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:
 
 

Environment

Process Automation 4.3 and above

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"
 
 

Attachments