Skip to main content
Version: 10.3.1

Connect to local MSSQL

It is good practice to verify changes to your Business Processes, Bot Tasks, Manual Tasks, and even Data Stores in your local environment. Local development environment based on Work.AI Developer contains a workstation version of the WorkFusion database.

Here is a short guide on how to connect to your local SQL Server Express RDBMS. The prerequisite is to install Work.AI Developer.

RDMS client​

You can install any client that supports MS SQL Server. We are using the following clients:

  • DBeaver: a free multi-platform database tool for developers, database administrators, analysts, and anyone who needs to work with databases. Supports all popular databases: MySQL, PostgreSQL, SQLite, Oracle, DB2, SQL Server, Sybase, MS Access, Teradata, Firebird, Apache Hive, Phoenix, Presto.
  • SQL Server Management Studio: an MS-native integrated environment for managing any SQL infrastructure, from SQL Server to Azure SQL Database. SSMS provides tools to configure, monitor, and administer instances of SQL Server and databases. Use SSMS to deploy, monitor, and upgrade the data-tier components used by your applications and build queries and scripts.
note

In this guide, DBeaver is used.

Connection credentials​

You can view all database connection details in the Secrets Vault management application installed by Work.AI Developer.

  1. Start the RPA Worker, Control Tower, or Workspace group in Work.AI Developer to launch Secrets Vault on your workstation.

  2. Once the group is up and running, access the Secrets Vault application from Launcher in the system tray or directly via the URL: https://localhost:18280/ui/.

  3. Log in to Secrets Vault using the username and password you set during the Work.AI Developer installation.

  4. Using links in application, navigate to secret > policy > IACDeveloper > workfusion_WFInternal.

  5. To connect, you can use the credentials for either the Control Tower schema (ct) or Data Store schema (ds).

  6. View values by clicking each key.

Connect and explore​

prerequisites
  • The DBeaver client is installed and running.
  • Data Store credentials are obtained as described above.

To connect, perform the following actions.

  1. In the toolbar, click New Database Connection.

  2. Choose the SQL Server database.

  3. Enter connection details.

  4. Click Test Connection... and then OK.

Now, you have full access to both schemas.

  • ct, where all WorkFusion system tables are located.
  • ds, where Automation Engineer-defined tables (Data Stores) are stored.
warning

Do not modify or delete anything in the ct schema unless you are 100% sure and a backup or rollback plan. Doing so can break your local Developer setup.