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.


    • Related Articles

    • Considerations when choosing REST token storage

      Since version 2.1 in COZYROC SSIS+ access tokens used by REST Connection Manager can be stored not only in the file system, but also in a database (SQL Server).   Using such a centralized storage addresses the following complications with the ...
    • How to use an XML configuration in a REST Connection Manager

      Follow these steps to use the configuration Right Click Connection Managers. Choose New Connection. Select Connection manager for REST connections. In the Configuration drop down choose {Custom}. A wrench appears to the right of the Configuration ...
    • How to manually generate a Google Services Token?

      A token-based authentication system allows users to enter their username and password in order to obtain a token, which allows them to fetch a specific resource, without using their username and password. Once their token has been obtained, the user ...
    • Why the buttons on the REST Connection manager are missing?

      Problem: I am not able to configure my REST Connection Manager component. After I select "Configuration", the buttons on the REST Connection manager screen are gone, they are missing . Look at the screenshot below: Solution: A possible reason for ...
    • How to get a new REST Token

      Make sure you have launched Visual Studio as "Run as Administrator". The token setup process is organized as a wizard consisting of three steps: Step 1: Specify the REST service parameters required to initiate the authorization. If there are no ...