How to connect to Trello Data from IntelliJ

The CData JDBC Driver for Trello enables you to access Trello as a JDBC data source, providing integration with rapid development tools in IDEs. This article shows how to use the data source configuration wizard to connect to Trello data in IntelliJ.

Create a JBDC Data Source for Trello

Follow the steps below to add the driver JAR and define connection properties required to connect to Trello data.

1. In the Data Sources window, right-click and then click Add Data Source -> DB Data Source.

2. In the Data Source Properties dialog that appears, the following properties are required:

   • JDBC Driver Files: Click the button next to this menu to add the JDBC Driver file cdata.jdbc.trello.jar, located in the installation directory.
   • JDBC Driver Class: In this menu, select cdata.jdbc.trello.TrelloDriver from the list.

   • Database URL: Enter the connection URL in the JDBC URL property. The URL must start with jdbc:trello: and includes connection properties separated with semicolons.

     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.

     • Authorization Route: At the moment of registration, Trello assigns an API key and Token to the account. See the Help documentation for information on how to connect via the Authorization route.
     • OAuth Route: Similar to using Authorization, OAuth creates an Application Id and Secret when you create your account. See the Help documentation for information on how to to connect.

     Built-in Connection String Designer

     For assistance in constructing the JDBC URL, use the connection string designer built into the Trello JDBC Driver. Either double-click the JAR file or execute the jar file from the command-line.

     java -jar cdata.jdbc.trello.jar

     Fill in the connection properties and copy the connection string to the clipboard.

     A typical JDBC URL is the following:

     jdbc:trello:APIKey=myApiKey;Token=myGeneratedToken;InitiateOAuth=GETANDREFRESH

Edit and Save Trello Data

To discover schema information, right-click the data source you just created and click Refresh Tables. To query a table, right-click it and then click Open Tables Editor.