We had a customer who needed to keep their board in sync with a legacy CRM that could only be accessed via SQL.

What it does

DuraSync allows you to pull data from a remote data source and make it available within a board. For example, pull in a list of products and their prices from your production environment, then include this in other boards using a Mirror column.

Data can be pulled from a REST API with a JSON response, or any of the following SQL servers: Microsoft SQL Server, MySQL, PostgreSQL, or MariaDB. You can configure how often the data is kept in sync.

How we built it

We first built an MVP for the customer to self host in Docker. Then we rebuilt and productized the application to run for any customer who wants to pull it in from the Marketplace.

Challenges we ran into

We had to tweak design and UX to comply with requirements. We had to build out more features to support common use cases.

What's next for DuraSync

  • Support for more data source types
  • More advanced API connection capabilities
  • Ability to push data from into a remote destination

Built With

Share this project: