REST Connection

SQL Server 2005, 2008, 2008R2, 2012, 2014, 2016

SQL Server 2005, 2008, 2008R2, 2012, 2014, 2016

All Downloads ----- Join VIP ----- Questions?


REST Connection Manager is an SSIS Connection Manager for establishing REST connections. Use the API to build components based on the REST Connection Manager. The REST Connection Manager depends on configuration which describes the REST service in use.


Use the REST Connection Manager dialog to specify properties for connecting to the REST service.

Server Options


Select the REST service to use. The following services are currently supported:

ArcGIS Feature Dropbox Fleet Complete Google Admin Google Calendar
Google Drive Google Sheets Google Tasks Hubspot Marketo
OneDrive Parature Pardot ServiceNow Shopify
SimplyDigi Square Twitter Xero Zoho CRM

If you want to see support for other services, please contact us to discuss this.


Specify the name or IP address of the REST service.

Token file

For REST service authorized by a token, you must select the connection token file. If a token file does not exist, you must create a New... token.

Token password

Specify the token file decryption password.

REST connection parameters

Each REST service has specific parameters for establishing successful connections. Press the icon to get more information about the connection parameters.

Time-out (secs)

Specify the number of seconds before timing out the session connection. The default value of this property is 100 seconds.


Specify if all clients should use the same connection. This property has the options listed in the following table.

Value Description
True All clients use the same connection (default).
False Every client uses a different connection.
Test Connection

Confirm the connection manager configuration by clicking Test Connection.

Advanced Options

Verbose log

Specify the verbose log file name for investigating REST connection issues.

Requests per second

Specify the number of web services requests per second. The default is 5 requests/second.

Retry Max

Specify the maximum request retry number.

Retry Pause

Specify the number of seconds to pause between retries. The default is 30 seconds.

Retry Error

Optional. Specify to retry only if the error message matches the RegEx pattern.

Proxy Options


Specify the name or IP address of the proxy server. If not specified, a proxy server is not used.


Specify the port number on the proxy server to use for the connection.

User name

Specify the user name to access the proxy server.


Specify the password to access the proxy server.

How to get a new REST Token

The token setup process is organized as a wizard consisting of three steps:

  1. Step: Specify the REST service parameters required to initiate the authorization. If there are no parameters, check the next step.
  2. Step: Authorize COZYROC SSIS+ to connect to the REST service. If the token retrieval succeeds, the next wizard step will have the access token, refresh token, etc automatically populated in the next step.
  3. Step: If the automatic token retrieval fails, you can manually specify the access token. If all required information is populated, you can specify the token file name and password to save it.

Tips for successful token retrieve:

  • Disable the Windows Firewall.
  • Explicitly Run As: Admin Visual Studio.
  • Try running the token retrieval from a different machine.