Adding Certify Databases to the Worksoft Portal

You must add Worksoft Certify databases to the Worksoft Portal. Worksoft RPA Orchestrator requires two different Certify databases:

  • RPA development database - testing database
  • RPA published database - production database

Database Connection Configuration Options

When you add your Certify databases, you must select how you want to set up your database security configuration. You need to be a superuser to configure both connections:

  • User Based Configuration
  • Managed Service Identity Configuration

To add a Certify database with a user-based configuration connection:

  1. From the Worksoft Portal menu, select Settings > Certify Databases.

    The Certify Databases page opens.

  1. Click the Add New Database button.

    The Add Certify Database dialog opens.

  1. Select the User Based Configuration option.

  2. In the Name field, enter a unique name for your Certify database that will be your database alias.

  3. In the SQL Server field, enter the server name.
  4. In the Database field, enter the database name.

  5. If you want to use Windows authentication, select the Use Trusted Connection (Windows) option.

    For more information about configuring Windows authentication, see the Worksoft Certify Installation Guide.

  6. If you want to use SQL Server authentication, enter the SQL Server user name and password in the respective fields.

  7. Select the Trust Server Certificate option.

  8. Click Test Configuration to test your database connection.

    A message opens stating if the connection was successful or failed. If the test fails, troubleshoot the database connection.

  9. Click OK to close the message.

  10. Click Add to save your database.

    The new database appears in the Certify Databases page.

To add a Certify database with a Managed Service Identity configuration connection:

  1. From the Worksoft Portal menu, select Settings > Certify Databases.

    The Certify Databases page opens.

  1. Click the Add New Database button.

    The Add Certify Database dialog opens.

  1. Select the Managed Service Identity Configuration option.

  2. In the Name field, enter a unique name for your Certify database that will be your database alias.

  3. In the SQL Server field, enter the server name.
  4. In the Database field, enter the database name.

  5. In the Managed Identity ID field, enter the ID.

  6. Click Test Configuration to test your database connection.

    A message opens stating if the connection was successful or failed. If the test fails, troubleshoot the database connection.

  7. Click OK to close the message.

  8. Click Add to save your database.

    The new database appears in the Certify Databases page.

 

Related Topics Link IconRelated Topics