How to save rest token in sql server instance. The REST API tokens can now be stored in an SQL Server instance (i.e. not just as a file), making token deployment easier

How to use a Database storage for new REST tokens

Make sure you have launched Visual Studio as "Run as Administrator".
1 : In Rest Connection Manager choose the configuration from the dropdown list you want to generate token for.
2: For the Token storage parameter in the grid below select Database from the drop down list as mention in the below screen shot (capture 1)
Capture 1
3: Click on the right side of the Token field so the new button appears as shown in the below screen shot (capture 2). Click on the new button to intiate the Token Generation Wizard
capture 2

3: The token setup process is organized as a wizard consisting of three steps:
  1. Step 1: Specify the REST service parameters required to initiate the authorization. If there are no parameters, check the next step.
  2. Step 2: Authorize COZYROC SSIS+ to connect to the REST service.
  3. Step 3: If the token retrieval succeeds, the next wizard step will have the access token, refresh token etc automatically populated in the next step. You will aslo see Token Storage fields as mention in the below screen shot (capture 3)
Leave the default token refresh date.  By default the date shown will allow the token to refresh as needed.
capture 3
4: Select Database for the field Save in and click on the Toggle button to setup the connection manager based on the previously defined connection information. Select the data connection and then click OK. To create a new connection manager, click New. After setting up the connection string provide Token Identifier and password for the Token and Click Ok as mention in the below screen shot (capture 4)
capture 4

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 start Visual Studio using "Run As: Admin"
  • Check the box on new token window of Wizard to "Tweak the user Agent..."

  • Try running the token retrieval from a different machine and move it to your machine.
  • Log out of the service your are trying to create a token for directly from your machines browsers.
  • Clear the cache in your machines browsers.