Considerations when choosing REST token storage. pros and cons of the old (file-based) and the new (DB-based) approach

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 file-based storage:
  1.  Eliminate the need to copy the token file to the production server as an additional deployment step.
  2. ‚Äč Eliminate problems with services that employ non-reusable refresh tokens. Many third-party services that use OAuth 2.0 (e.g. Google services) send a refresh token that can be used only once. Thus if the same token file is copied on several machines (development, staging, production), refreshing a token on one of them will invalidate the refresh tokens on all other machines. A centralized storage eliminates this problem, as upon access token expiration, a new access and refresh token would be readily available for all servers.
 Specifying a path for the token file on a network share, which is accessible by the development machines and the production/staging servers, is a good alternative to using the Database storage.

    • Related Articles

    • 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 ...
    • 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 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 ...
    • Error Message: Invalid Token Password

      Action: Test Connection succeeds, but then the REST Connection Manager fails with the following error message. Error Message: Invalid Token Password Solution: Please check what your Package Protection Level is.  If it is DontSaveSensitive, then all ...
    • 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 ...