ODBC Driver for Trello

Build 22.0.8462

Windows DSN Configuration

Using the Microsoft ODBC Data Source Administrator

You can use the Microsoft ODBC Data Source Administrator to edit the DSN configuration. Note that the DSN is created during the installation process.

Complete the following steps to edit the DSN configuration:

  1. Select Start > Search, and enter ODBC Data Sources in the Search box.
  2. Choose the version of the ODBC Administrator that corresponds to the bitness of your application (32-bit or 64-bit).
  3. Click the System DSN tab.
  4. Select the system data source and click Configure.
  5. Edit the information on the Connection tab and click OK.

Note: For .NET Framework 4.0, the driver distributes Microsoft Visual C++ 2015-2022 Redistributable. For .NET Framework 3.5, the driver distributes Microsoft Visual C++ 2008 Redistributable.

Trello uses token-based authentication to grant third-party applications access to their API. When a user has granted an application access to their data, the application is given a token that can be used to make requests to Trello's API. Trello's API can be accessed in 2 different ways. The first is using Trello's own Authorization Route, and the second is using OAuth1.0.

Trello Authorization Route

At the moment of registration, Trello assigns an API key and Token to the account.

Note: Set AuthScheme to Token to activate this authentication method.

At the moment of registration, Trello assigns an API key and Token to the account. We can retrieve this API key after logging in to Trello and visiting https://trello.com/app-key. After obtaining your API key, you can use it to obtain a Token by visiting https://trello.com/1/authorize?expiration=never&name=MyPersonalToken&scope=read,write,account&response_type=token&key={Key} and replacing {key} with the obtained API key. After visiting the page, you can authorize the application to use your account by clicking the allow button. You'll be redirected to a page with your token. To make requests to Trello's API you will need both API key and Token.

Note: You can change the expiration time of the token by changing expiration= with one of the following values (1hour, 1day, 30days, never).

Set:

  • APIKey: The key found at https://trello.com/app-key
  • Token: The token obtained

OAuth

Note: Set AuthScheme to OAuth to activate this authentication method.

Similar to using Authorization, OAuth creates an Application Id and Secret when you create your account. See Using OAuth Authentication for information on how to to connect.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462