Welcome to Kofax RPA > Management Console > Management Console Configuration and User Interface > Add Database Type

Add Database Type

Use this procedure to add a modified database type in the Management Console. As an example, we will add a Microsoft SQL Server that requires Windows Integrated Security.

  1. In the Management Console, select Admin > Settings and click Database Types.
  2. Click Add Database Type.
  3. Specify the following values:
    • Name: Microsoft SQL Server (Integrated Security)
    • JDBC driver: com.microsoft.sqlserver.jdbc.SQLServerDriver
    • Connection URL template: jdbc:sqlserver://${ServerName};databaseName=${Schema};integratedSecurity=true
    • Select Microsoft SQL Server in the Database Type list.

    Click Save to add the database type to the list.

  4. Download the "Microsoft JDBC Driver 4.0 for SQL Server" from the Microsoft website and extract it to a folder on your disk.
  5. Copy sqljdbc_auth.dll to the \lib directory in the Kofax RPA installation folder. The file is located in the extracted folder under Microsoft JDBC Driver 4.0 for SQL Server\sqljdbc_4.0\enu\auth\x64 or \86 folder.

    If there are RoboServers running on other computers, the sqljdbc_auth.dll must be installed on each one.

  6. Upload the sqljdbc.jar file to the Management Console. Select Database Drivers in the Admin > Settings tab and click Upload Driver Jar. Browse for the corresponding JDBC driver. The .jar file is located in the extracted folder under Microsoft JDBC Driver 4.0 for SQL Server\sqljdbc_4.0\enu.
  7. Restart Kofax RPA Management Console.

You can now connect to the database that uses the newly created database type on the Admin > Clusters tab of the Management Console.

Notes on Microsoft SQL Server for Windows Integrated Security
  • If you do not copy the required database .dll file, use the 32-bit version of the auth .dll instead of the 64-bit, or if you do not restart the Management Console, you may get the following error message: "Error connecting to the database: This driver is not configured for integrated authentication."
  • If the server is not part of the domain, you may get the following error: "Error connecting to the database: Login failed. The login is from an untrusted domain and cannot be used with Windows authentication."

See the following topics for more details about using databases in Kofax RPA.