Flow Connect

General

This section provides guidance on installing and configuring the Manage Survey Applications and the Manage Exam Applications for Flow Connect.

Each application package contains unique applications for specific functions, and each function must be installed in a licensed Novacura environment.

Applications

Application	Required Connectors/Services
Manage Surveys	Microsoft SQL Connector, Mail Connector
Survey Response	Microsoft SQL Connector, Mail Connector
Manage Exams	Microsoft SQL Connector, Mail Connector
Exam Response	Microsoft SQL Connector, Mail Connector

System and Version

System	Version
Novacura Flow Connect Designer	1.0.0.199
Connector Agent	1.0.0.878
Connectors	Microsoft SQL Server, Mail

Prerequisites

Before importing the application package:

• Ensure all groups and connectors for the Exam/Survey app are created.

• The database must use the ‘Survey’ schema, and tables must follow predefined standards for column structures and record formats to align with application logic.

• Detailed table definitions and formats are available in the SQL Server Data Source Setup and Schema section.

SQL Server Data Source Setup and Schema

It is essential to import the Survey schema provided in the “supporting files” package (included with the application download) into your SQL database. Specific tables must conform to predefined standards for column structure and record formats to maintain consistency with application logic. The following outlines the required tables and their corresponding values.

Database Tables

[Survey].[survey_states]

Id	Name
1	PLANNED
2	CONFIRMED
3	PUBLISHED
4	FINISHED
5	CANCELLED

[Survey].[roles]

Id	Name
1	admin
2	user

[Survey].[question_types]

Id	Name
1	Yes/No
2	Multi-Choice
3	Single-Choice
4	Free Text_Short
5	Free Text_Long
6	Numerical
7	True/False
8	Picture
9	Date
10	Time
11	Date/Time
12	Signature

Flow Connect Connectors

Microsoft SQL Connector

If you don't have a connector set up, you can see an example here.

Email Connector

If you don't have a connector set up, you can see an example here.

Installation

Make sure that you have created all connectors and variables before importing the application package.

1. Import Application Package

Import application package using your "share link" this will initiate an import wizard.

For details see Import Application Package

2. Setting User Groups

Together with the imported application package, you need to set up a user group. Add users to your user group, grant the user group access to the application package from the Application Package screen to make the applications available for your users.

For details see Create User Groups and Manage User Groups

3. Deploy Application

In the Application Package screen, click Deployments to open the Deployment Overview screen. From here, select which applications to deploy to your available environment.

Once deployed, the applications will be available to execute on your chosen Flow Connect client.

For detailed instructions, see Deploy Application.