Premium Only-

Microsoft SQL Server Connector

A new set of Premium Edition direct connectors to Microsoft SQL Server are now available. Using a similar approach to eForms Mobile SYNC, we’ve provided connectors to push data from Forms and Tasks to a Microsoft SQL Server database, as well as a connector for pulling rows into Data Sources directly from a Microsoft SQL Server table.

The main target for this connector is the Microsoft Azure SQL Database (as this way all data stays within Azure data centers), however, a direct connection to any Microsoft SQL Server database (e.g. via Amazon RDS) will work. For on-premise cases, we believe eForms Mobile SYNC continues to be a more secure option, as SYNC provides DMZ compatibility, ensuring your on-premise database is not exposed to the internet.

First, you have to be sure that your database firewall has been configured to accept connections from platform servers. Review our support documentation for Platform IP address information.

In the field title “Connection String”, enter the SQL Server connection string to be used by connectors to access your database. Windows Authentication is NOT supported; you must include username and password credentials in the string. The SQL user specified MUST have at least db_ddladmin and db_datawriter database-level roles assigned. For the simplest configuration, grant db_owner role to the user.

Need to add two different Microsoft SQL Server databases? No problem, just press ADD CONNECTION after the first one is complete.

Other Improvements

Premium Only-

Multiple Connections

of the Same Type

This is one of the most requested features over the last 3 years and are pleased to announce its general availability for all Premium Edition accounts. This feature allows you to connect to multiple destinations on the same external service (e.g. multiple SharePoint instances or multiple Google accounts). When you have multiple Connections of the same type, you’ll see a Connections dropdown when you configure connectors, allowing you to specify which Connection to use when that connector executes. Additionally, you can now name your Connections and there’s also a helpful Clone option to quickly copy Connections.

Premium Only-

First Available Person

The ability to assign Task to the first available user is now live. When assigning a task to a user, if the First Available option is selected, the system will randomly assign this Task to the first ‘available’ app user. A user is considered to be available if they do not have any existing

Tasks already scheduled during the start/end period of this new Task. This is useful for Tasks where any user can be assigned and saves time spent searching calendars for availability; instead the system smartly allocates this Task according to existing assignments.