SSIS tutorial: How to retrieve data from Trello

Introduction

Trello is a popular project management platform used by teams worldwide to organize tasks, track progress, and collaborate on projects. Many organizations need to integrate Trello data with SQL Server for reporting, analytics, and business intelligence purposes. Using Zappysys SSIS PowerPack, you can easily extract card data, lists, and board information from Trello using REST APIs without writing custom code.

This tutorial demonstrates how to connect SSIS to Trello and load card and board data into SQL Server tables using the Zappysys REST API Source component.

Prerequisites

1. SQL Server Integration Services (SSIS) is installed.
2. Visual Studio with SSIS extension or SQL Server Data Tools (SSDT).
3. A Trello account with at least one board and list created.
4. Zappysys SSIS PowerPack installed on your system.

Steps
Generate Trello API Key and Token

1. Go to the Trello Power-up page and log in to your account.
2. Create a new App and fill in the form.
   

   Trello – Create a new App

3. Inside your new App, click the API key, then generate a new API Key.
   

   Trello – API key page

4. In the API Key section, click the Token link to generate an access token.
   

   Trello – API key and Token link

5. Choose the token’s expiration time (Recommended: 30 days for security).
6. Review the permissions and click Create Token.
7. Copy the generated token and store it securely.
8. You now have both your API Key and Token. Keep these credentials confidential.

Configure SSIS Package Variables

1. Open your SSIS project in Visual Studio or SQL Server Data Tools (SSDT).
2. Create a new package or open an existing one.
3. Navigate to the Variables section and create the following variables:
   1. TrelloApiKey (String) — Enter the API Key you generated in the previous step.
   2. TrelloToken (String) — Enter the access token you created.
   3. BoardId (String) — Enter your Trello Board ID.
4. Ensure all variables are marked as sensitive if they contain authentication credentials to secure the package.

Create and Configure the  JSON Source

1. 1. Add a new Data Flow Task to your SSIS package.
   2. Double-click the Data Flow Task to enter the Data Flow design surface.
      

      Drag and drop Data flow

   3. Drag a ZappySys JSON Source component from the toolbox onto the canvas.
      

      SSIS JSON Source – Drag and Drop

   4. Double-click the ZappySys JSON Source to open its configuration editor.
   5. In the Connection section, enter the Trello API endpoint to retrieve cards from your board:
      
      https://api.trello.com/1/members/me/boards?key={{User::TrelloApiKey}}&token={{User::TrelloToken}}

      1	https://api.trello.com/1/members/me/boards?key={{User::TrelloApiKey}}&token={{User::TrelloToken}}

   6. Set the HTTP Request Method to GET.
   7. Click Test Connection to verify that your API credentials are correct and you can access your Trello board data.
   8. Click Preview Data to view the card data that will be extracted from Trello.
   9. Click OK to save the configuration.
      

      Trello – JSON source example

   10. Alternatively, you can use the boardId parameter in the request to retrieve specific board data. Here are some common API endpoints:
       GET /boards/{boardId}/cards — Retrieve all cards from a specific board
GET /boards/{boardId}/lists — Retrieve all lists from a specific board
GET /cards/{cardId} — Retrieve details of a specific card
       

       Trello – JSON source example board ID

Configure the Data Destination

1. Drag and drop a destination component (such as OLE DB Destination, SQL Server Destination, or Flat File Destination) into the Data Flow.
2. Connect the output arrow from the JSON Source component to the destination component.
3. Double-click the destination component to open its configuration dialog.
4. Configure the connection manager to point to your target SQL Server database.
5. In the destination editor, specify the target table where Trello data will be stored.
6. In the Mappings section, map the columns from the JSON response to the corresponding SQL Server table columns.
7. Configure error-handling options based on your requirements (fail on errors, ignore errors, or redirect error rows to an error table).
8. Click OK to save the destination configuration.
9. Execute the package and verify that the data extraction is working correctly.
   

   Trello – Final Result

Conclusion

Connecting SSIS to Trello using Zappysys REST API Source simplifies the integration of project management data into your SQL Server environment without custom development. By following the steps outlined in this tutorial, you can build reliable SSIS packages that automatically synchronize Trello board data with SQL Server for analytics, reporting, and business intelligence. Whether you need to track project progress, analyze team productivity, consolidate data from multiple teams, or create executive dashboards, Trello integration with SSIS provides a flexible and powerful solution that saves time and reduces manual data entry errors.

Explore the full capabilities of the ZappySys SSIS PowerPack to optimize your data integration tasks. By applying this pattern, you can extend your solution to include additional transformations, data validation, error handling, and scheduling through SQL Server Agent.

Need Help?

If you encounter any issues, our support team is here to help:

1. Live Chat — Use the chat widget (bottom-right corner of this page)
2. Email — support@zappysys.com
3. Support Center — Visit the ZappySys Support Portal