Microsoft SQL Server modules

Last update: March 14, 2025

You can use Adobe Workfront Fusion to connect to Microsoft SQL Server.

Access requirements

Expand to view access requirements for the functionality in this article.

You must have the following access to use the functionality in this article:

Adobe Workfront packageAny
Adobe Workfront license

New: Standard

Or

Current: Work or higher

Adobe Workfront Fusion license**

Current: No Workfront Fusion license requirement

Or

Legacy: Workfront Fusion for Work Automation and Integration

Product

New:

  • Select or Prime Workfront package: Your organization must purchase Adobe Workfront Fusion.
  • Ultimate Workfront package: Workfront Fusion is included.

Or

Current: Your organization must purchase Adobe Workfront Fusion.

For more detail about the information in this table, see Access requirements in documentation.

For information on Adobe Workfront Fusion licenses, see Adobe Workfront Fusion licenses.

Connecting the Microsoft SQL Server service to Workfront Fusion

For instructions about connecting your Microsoft SQL Server account to Workfront Fusion, see Create a connection to Adobe Workfront Fusion - Basic instructions

NOTE
Some Microsoft apps use the same connection, which is tied to individual user permissions. Therefore, when creating a connection, the permissions consent screen displays any permissions that were previously granted to this user’s connection, in addition to any new permissions needed for the current application.
For example, if a user has “Read table” permissions granted via the Excel connector and then creates a connection in the Outlook connector to read emails, the permissions consent screen will show both the already granted “Read table” permission and the newly required “Write email” permission.

Using Microsoft SQL Server modules

You can execute your custom logic directly on your database server through stored procedures. Adobe Workfront Fusion loads interface of input/output parameters and recordset dynamically so each parameter or value can be mapped individually. Before you start configuring your scenario, make sure the account you’re using to connect to your database has read access to INFORMATION_SCHEMA.ROUTINES and INFORMATION_SCHEMA.PARAMETERS views.

When Fusion establishes the connection to the SQL server destination, the Fusion user identifies the Host (the domain name or IP address where the server is hosted) and the port. Fusion can connect to any available host and port.

For information about specific IP addresses used by Workfront Fusion, see IP Addresses for accessing Adobe Workfront Fusion

To learn more about creating a stored procedure, see the Microsoft SQL Server documentation.

NOTE
Workfront Fusion doesn’t support multiple recordsets. Only the first one is processed.