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.


    Book a Presales Call


    Are you new to COZYROC and evaluating our solutions? 
    Book a Presales Call with us now and get 5% off SSIS+.

      • 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 ...

      • How to manually generate a Shopify 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 ...