Ready to get started?

Learn more about the CData SSIS Components for Trello or download a free trial:

Download Now

Export Data from SQL Server to Trello through SSIS

Easily push SQL Server data to Trello using the CData SSIS Tasks for Trello.

SQL Server databases are commonly used to store enterprise records. It is often necessary to move this data to other locations. The CData SSIS Task for Trello allows you to easily transfer Trello data. In this article you will export data from SQL Server to Trello.

Add Source and Destination Components

To get started, add a new ADO.NET Source control and a new Trello Destination control to the data flow task.

Configure the ADO.NET Source

Follow the steps below to specify properties required to connect to the SQL Server instance.

  1. Open the ADO.NET Source and add a new connection. Enter your server and database information here.
  2. In the Data access mode menu, select "Table or view" and select the table or view to export into Trello.
  3. Close the ADO NET Source wizard and connect it to the destination component.

Create a New Connection Manager for Trello

Follow the steps below to set required connection properties in the Connection Manager.

  1. Create a new connection manager: In the Connection Manager window, right-click and then click New Connection. The Add SSIS Connection Manager dialog is displayed.
  2. Select CData Trello Connection Manager in the menu.
  3. Configure the connection properties.

    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.

Configure the Trello Destination

In the destination component Connection Manager, define mappings from the SQL Server source table into the Trello destination table and the action you want to perform on the Trello data. In this article, you will insert Boards entities to Trello.

  1. Double-click the Trello destination to open the destination component editor.
  2. In the Connection Managers tab, select the connection manager previously created.
  3. In the Use a Table, menu, select Boards. In the Action menu, select Insert.
  4. On the Column Mappings tab, configure the mappings from the input columns to the destination columns.

Run the Project

You can now run the project. After the SSIS Task has finished executing, data from your SQL table will be exported to the chosen table.