Forum Discussion

Will_Ko's avatar
Will_Ko
Copper Contributor
Nov 14, 2023

Integration between Asana and Microsoft SQL Servers using Microsoft Azure DevOps?

Hi,

 

I work for a bespoke kitchen company. We currently are using SQL Servers (on-premise). A lot of our software is integrated whereby any data input onto one system, would update on our other systems. We have recently started using Asana which is not integrated into our SQL Servers. According to the Asana website, it can integrate with Microsoft Azure. We have been advised by an external party to use Microsoft Azure 'DevOps' to achieve this.

 

Is this possible to do and if so, what are the steps required to do this?

 

Kind regards,

 

Will Ko

2 Replies

  • giuseppina's avatar
    giuseppina
    Copper Contributor

    Yes, it’s possible. But Azure DevOps is mainly for code and CI/CD, not direct data integration.

    Instead, you could use Azure Data Factory or Logic Apps to connect your on-prem SQL Server (via integration runtime) and Asana (via its REST API). This way, you can automate pulling data from Asana and updating your SQL.

    Azure DevOps could still help by managing scripts or pipelines that run these processes.

Resources