Learn more
 

Asana Integration Guides and Tutorials


A list of guides and tutorials for connecting to and working with live Asana data.

CData Software's connectivity tools enable users to connect directly to live Asana data data from widely-used BI, analytics, ETL, and custom applications, ensuring that our customers can access their data wherever they desire. Below, you'll find a collection of guides and tutorials on integrating with live Asana data.

Integration Use-Cases

Click below to jump to articles related to specific integration use-case.

Business Intelligence & Analytics


ProductTechnologyArticle Title
Alteryx DesignerODBCPrepare, Blend, and Analyze Asana in Alteryx Designer (ODBC)
Alteryx DesignerConnect CloudWork with Live Asana Data in Alteryx Designer (Connect Cloud)
Amazon QuickSightConnect CloudBuild Interactive Dashboards from Asana Data in Amazon QuickSight
Amazon SageMakerConnect CloudIntegrate Live Asana data into Amazon SageMaker Canvas
Aqua Data StudioJDBCConnect to Asana in Aqua Data Studio
AWS DatabricksJDBCProcess & Analyze Asana Data in Databricks (AWS)
Azure Analysis ServicesConnect CloudModel Asana Data Using Azure Analysis Services
BirstJDBCBuild Visualizations of Asana in Birst
BIRTJDBCDesign BIRT Reports on Asana
Clear AnalyticsODBCBuild Charts with Asana in Clear Analytics
Cognos Analytics (On-Prem)Connect CloudAnalyze Asana Data in Cognos Analytics
DBxtraODBCBuild Dashboards with Asana in DBxtra
DomoODBCCreate Datasets from Asana in Domo Workbench
Dundas BIODBCBuild Dashboards with Asana in Dundas BI
Excel (on Mac OS)ODBCWork with Asana Data in MS Excel on Mac OS X
FineReportJDBCFeed Asana into FineReport
Google SheetsConnect CloudAccess Live Asana Data in Google Sheets
IBM Cognos BIODBCCreate Data Visualizations in Cognos BI with Asana
Infragistics RevealConnect CloudAnalyze Asana Data in Infragistics Reval
JasperServerJDBCCreate Asana Reports on JasperReports Server
Jaspersoft BI SuiteJDBCConnect to Asana in Jaspersoft Studio
JReport DesignerJDBCIntegrate with Asana in JReport Designer
KlipfolioConnect CloudCreate Asana-Connected Visualizations in Klipfolio
KNIMEJDBCEnable the Asana JDBC Driver in KNIME
LINQPadADO.NETWorking with Asana in LINQPad
LookerConnect CloudAnalyze Asana Data in Looker
Looker StudioConnect CloudCreate Reports from Asana Data in Looker Studio
MetabaseConnect CloudCreate Interactive Asana-Connected Metabase Dashboards
Microsoft ExcelConnect CloudAccess Live Asana Data in Excel Desktop
Microsoft Excel for the WebConnect CloudAccess Live Asana Data in Excel for the Web
Microsoft SSASADO.NETBuild an OLAP Cube in SSAS from Asana
MicroStrategyConnect CloudConnect to Live Asana Data in MicroStrategy through Connect Cloud
MicroStrategyJDBCUse the CData JDBC Driver for Asana in MicroStrategy
Microstrategy DesktopJDBCUse the CData JDBC Driver for Asana in MicroStrategy Desktop
Microstrategy WebJDBCUse the CData JDBC Driver for Asana in MicroStrategy Web
Mode AnalyticsConnect CloudCreate Asana-Connected Visualizations in Mode
OBIEEJDBCAsana Reporting in OBIEE with the Asana JDBC Driver
pandasPythonUse pandas to Visualize Asana in Python
Pentaho Report DesignerJDBCIntegrate Asana in the Pentaho Report Designer
Power BI DesktopPower BIAuthor Power BI Reports on Real-Time Asana
Power BI ServiceConnect CloudVisualize Live Asana Data in the Power BI Service
Power PivotConnect CloudAccess Asana Data in Microsoft Power Pivot
Power QueryConnect CloudAccess Asana Data in Microsoft Power Query
Qlik CloudConnect CloudCreate Apps from Asana Data in Qlik Sense Cloud
QlikViewODBCConnect to and Query Asana in QlikView over ODBC
RJDBCAnalyze Asana in R (JDBC)
RODBCAnalyze Asana in R (ODBC)
RapidMinerJDBCConnect to Asana in RapidMiner
RedashConnect CloudQuery, Visualize, and Share live Asana Data in Redash
SAP Analytics CloudConnect CloudAnalyze Asana Data in SAP Analytics Cloud
SAP Business ObjectsJDBCCreate an SAP BusinessObjects Universe on the CData JDBC Driver for Asana
SAP Crystal ReportsJDBCPublish Reports with Asana in Crystal Reports (JDBC)
SAP Crystal ReportsConnect CloudPublish Reports with Asana in Crystal Reports (Connect Cloud)
SASODBCUse the CData ODBC Driver for Asana in SAS for Real-Time Reporting and Analytics
SAS JMPODBCUse the CData ODBC Driver for Asana in SAS JMP
SAS ViyaConnect CloudAnalyze Live Asana Data in SAS Viya
SisenseJDBCVisualize Live Asana in Sisense
Spago BIJDBCConnect to Asana in SpagoBI
TableauTableauVisualize Asana in Tableau Desktop
TableauConnect CloudVisualize Asana in Tableau Desktop (Connect Cloud)
Tableau CloudConnect CloudBuild Asana Visualizations in Tableau Cloud
Tableau ServerTableauPublish Asana-Connected Dashboards in Tableau Server
ThoughtSpotConnect CloudModel, Search, and Visualize Live Asana Data in ThoughtSpot
TIBCO SpotfireADO.NETVisualize Asana in TIBCO Spotfire through ADO.NET
TIBCO SpotfireConnect ServerVisualize Asana Data in TIBCO Spotfire
TIBCO Spotfire ServerJDBCOperational Reporting on Asana from Spotfire Server
Zoho AnalyticsConnect CloudCreate Asana-Connected Dashboards in Zoho Analytics

Back to top

ETL & Replication


ProductTechnologyArticle Title
AirbyteConnect CloudConnect to Asana Data in Airbyte ELT Pipelines
Amazon RedshiftCData SyncAutomated Continuous Asana Replication to Amazon Redshift
Amazon S3CData SyncAutomated Continuous Asana Replication to Amazon S3
Apache AirflowJDBCBridge Asana Connectivity with Apache Airflow
Apache CamelJDBCIntegrate with Asana using Apache Camel
Apache CassandraCData SyncAutomated Continuous Asana Replication to Apache Cassandra
Apache KafkaCData SyncAutomated Continuous Asana Replication to Apache Kafka
Apache NiFiJDBCBridge Asana Connectivity with Apache NiFi
AWS GlueConnect CloudBuild ETL Jobs with Asana Data in AWS Glue Jobs
Azure Data FactoryConnect CloudImport Asana Data Using Azure Data Factory
Azure Data LakeCData SyncAutomated Continuous Asana Replication to Azure Data Lake
Azure SynapseCData SyncAutomated Continuous Asana Replication to Azure Synapse
BIMLSSISUse Biml to Build SSIS Tasks to Replicate Asana to SQL Server
CloverDXJDBCConnect to Asana in CloverDX (formerly CloverETL)
CouchbaseCData SyncAutomated Continuous Asana Replication to Couchbase
CSVCData SyncAutomated Continuous Asana Replication to Local Delimited Files
DatabricksCData SyncAutomated Continuous Asana Replication to Databricks
ETL ValidatorJDBCHow to Work with Asana in ETL Validator
FoxProODBCWork with Asana in FoxPro
Google AlloyDBCData SyncAutomated Continuous Asana Replication to Google AlloyDB
Google BigQueryCData SyncAutomated Continuous Asana Replication to Google BigQuery
Google Cloud SQLCData SyncAutomated Continuous Asana Replication to Google Cloud SQL
Google Data FusionJDBCBuild Asana-Connected ETL Processes in Google Data Fusion
Google Data FusionJDBCBuild Pipelines with Live Asana Data in Google Cloud Data Fusion (CData Connect Cloud)
Heroku / Salesforce ConnectCData SyncReplicate Asana for Use in Salesforce Connect
HULFT IntegrateJDBCConnect to Asana in HULFT Integrate
IBM DB2CData SyncAutomated Continuous Asana Replication to IBM DB2
Informatica CloudJDBCIntegrate Asana in Your Informatica Cloud Instance
Informatica PowerCenterJDBCCreate Informatica Mappings From/To a JDBC Data Source for Asana
Jaspersoft ETLJDBCConnect to Asana in Jaspersoft Studio
Microsoft AccessCData SyncAutomated Continuous Asana Replication to Microsoft Access
Microsoft Azure TablesCData SyncAutomated Continuous Asana Replication to Azure SQL
Microsoft Power AutomateConnect CloudBuild Asana-Connected Automated Tasks with Power Automate (Desktop)
MongoDBCData SyncAutomated Continuous Asana Replication to MongoDB
MySQLCData SyncAutomated Continuous Asana Replication to MySQL
Oracle Data IntegratorJDBCETL Asana in Oracle Data Integrator
Oracle DatabaseCData SyncAutomated Continuous Asana Replication to Oracle
petlPythonExtract, Transform, and Load Asana in Python
PostgreSQLCData SyncAutomated Continuous Asana Replication to PostgreSQL
Replicate to MySQLPowerShellReplicate Asana to MySQL with PowerShell
SAP HANACData SyncAutomated Continuous Asana Replication to SAP HANA
SingleStoreCData SyncAutomated Continuous Asana Replication to SingleStore
SnapLogicJDBCIntegrate Asana with External Services using SnapLogic (JDBC)
SnapLogicConnect CloudIntegration with Asana Data in SnapLogic (Connect Cloud)
SnowflakeCData SyncAutomated Continuous Asana Replication to Snowflake
SQL ServerCData SyncAutomated Continuous Asana Replication to SQL Server
SQL Server Linked ServerConnect CloudConnect to Asana Data as a SQL Server Linked Server
SQLiteCData SyncAutomated Continuous Asana Replication to SQLite
TalendJDBCConnect to Asana and Transfer Data in Talend
UiPath StudioODBCCreate an RPA Flow that Connects to Asana in UiPath Studio
VerticaCData SyncAutomated Continuous Asana Replication to a Vertica Database
WorkatoConnect CloudBuild Automated Workflows with Live Asana Data in Workato
ZapierConnect CloudBuild Automated Asana-Connected Workflows in Zapier

Back to top

Data Virtualization


ProductTechnologyArticle Title
APOS Live Data GatewayJDBCBuild Semantic Layer Views for Asana (JDBC)
APOS Live Data GatewayConnect CloudBuild Semantic Layer Views for Asana Data (Connect Cloud)
DenodoJDBCCreate A Data Source for Asana in Denodo Platform
DremioJDBCConnect to Asana as an External Source in Dremio
MySQL Federated TablesODBCConnect to Asana as Federated Tables in MySQL
Oracle DatabaseODBCAccess Asana as a Remote Oracle Database
PostgreSQL FDWJDBCA PostgreSQL Interface for Asana
Salesforce ConnectConnect CloudEdit and Search Asana External Objects in Salesforce Connect
Salesforce External ServicesConnect CloudConnect to Asana through External Services in Salesforce
SQL Server Linked ServersODBCConnect to Asana as a Linked Server
SQL Server PolyBaseConnect CloudConnect to Asana Data using PolyBase with Connect Cloud
SQL Server PolyBaseODBCConnect to Asana as an External Data Source using PolyBase
TIBCO Data VirtualizationTIBCO DVAccess Live Asana Data in TIBCO Data Virtualization

Back to top

Software Development


ProductTechnologyArticle Title
AWS LambdaJDBCAccess Live Asana Data in AWS Lambda
AxiosConnect CloudBuild Asana-Connected Web Apps with Axios and CData Connect Cloud
.NET ChartsADO.NETDataBind Charts to Asana
.NET QueryBuilderODBCRapidly Develop Asana-Driven Apps with Active Query Builder
Angular JSConnect ServerUsing AngularJS to Build Dynamic Web Pages with Asana
Apache SparkJDBCWork with Asana in Apache Spark Using SQL
AppSheetConnect CloudCreate Asana-Connected Business Apps in AppSheet
Bubble.ioConnect CloudBuild Asana-Connected Apps in Bubble
C++BuilderODBCDataBind Controls to Asana Data in C++Builder
ChoreoConnect CloudBuild Custom Apps on Asana Data in Choreo
ColdFusionJDBCQuery Asana in ColdFusion Using JDBC
ColdFusionODBCQuery Asana in ColdFusion Using ODBC
DashPythonUse Dash & Python to Build Web Apps on Asana
DelphiODBCDataBind Controls to Asana Data in Delphi
DevExpressADO.NETDataBind Asana to the DevExpress Data Grid
EF - Code FirstADO.NETAccess Asana with Entity Framework 6
EF - LINQADO.NETLINQ to Asana
EF - MVCADO.NETBuild MVC Applications with Connectivity to Asana
Filemaker ProODBCBidirectional Access to Asana from FileMaker Pro
Filemaker Pro (on Mac)JDBCBidirectional Access to Asana from FileMaker Pro (on Mac)
GoODBCWrite a Simple Go Application to work with Asana on Linux
Google Apps ScriptConnect CloudConnect to Asana Data in Google Apps Script
HibernateJDBCObject-Relational Mapping (ORM) with Asana Entities in Java
IntelliJJDBCConnect to Asana in IntelliJ
JBossJDBCConnect to Asana from a Connection Pool in JBoss
JDBIJDBCCreate a Data Access Object for Asana using JDBI
JitterbitConnect CloudIntegrate with Live Asana Data in Jitterbit
JRubyJDBCConnect to Asana in JRuby
MendixConnect CloudBuild Asana-Connected Apps in Mendix (Connect Cloud)
MendixJDBCBuild Asana-Connected Apps in Mendix (JDBC)
Microsoft Power AppsConnect CloudIntegrate Live Asana Data into Custom Business Apps Built in Power Apps
NodeJSConnect CloudQuery Asana Data in Node.js (via Connect Cloud)
NodeJSODBCQuery Asana through ODBC in Node.js
OutSystemsConnect CloudCreate Asana-Connected Enterprise Applications in OutSystems
PHPConnect ServerAccess Asana in PHP through Connect Server
PHPODBCNatively Connect to Asana in PHP
PowerBuilderADO.NETConnect to Asana from PowerBuilder
PowerShellPowerShellPipe Asana to CSV in PowerShell
PyCharmODBCUsing the CData ODBC Driver for Asana in PyCharm
PythonODBCConnect to Asana in Python on Linux/UNIX
ReactConnect ServerBuild Dynamic React Apps with Asana Data
RubyODBCConnect to Asana in Ruby
RunMyProcessConnect CloudConnect to Asana Data in RunMyProcess
RunMyProcess DSECJDBCConnect to Asana in DigitalSuite Studio through RunMyProcess DSEC
SAP UI5Connect ServerIntegrate Real-Time Access to Asana in SAPUI5 MVC Apps
ServoyJDBCBuild Asana-Connected Apps in Servoy
Spring BootJDBCAccess Live Asana Data in Spring Boot Apps
SQLAlchemyPythonUse SQLAlchemy ORMs to Access Asana in Python
TomcatJDBCConfigure the CData JDBC Driver for Asana in a Connection Pool in Tomcat
UnqorkConnect CloudCreate Asana-Connected Applications in Unqork
VCL App (RAD Studio)ODBCBuild a Simple VCL Application for Asana
WebLogicJDBCConnect to Asana from a Connection Pool in WebLogic

Back to top

Data Management


ProductTechnologyArticle Title
Apache SolrJDBCImport Asana Data into Apache Solr
Coginiti ProJDBCAccess Live Asana Data in Coginiti Pro
DataGripJDBCQeury Asana Data in DataGrip
DB ArtisanJDBCManage Asana in DBArtisan as a JDBC Source
DB ArtisanODBCConnect to Asana in DBArtisan
DBeaverJDBCConnect to Asana in DBeaver
DbVisualizerJDBCConnect to Asana in DBVisualizer
HeidiSQLConnect CloudConnect to Asana Data in HeidiSQL
Informatica Enterprise Data CatalogJDBCAdd Asana to Informatica Enterprise Data Catalog
MySQL WorkbenchConnect ServerQuery Asana Data in MySQL Workbench (Connect Server)
MySQL WorkbenchODBCQuery Asana in MySQL Workbench (ODBC)
QuerySurgeJDBCValidate Asana Data with QuerySurge
RazorSQLJDBCConnect to Asana in RazorSQL
SQuirreLJDBCConnect to Asana in Squirrel SQL Client

Back to top

Workflow Automation


ProductTechnologyArticle Title
MuleSoft AnypointJDBCAccess Asana in Anypoint Using SQL
Nintex Workflow CloudConnect CloudBuild Asana-Connected Workflows in Nintex
Power AutomateConnect CloudIntegrate Asana Data into Power Automate Automated Tasks
SSIS ImportSSISImport Asana Data into SQL Server using SSIS

Back to top

Ready to get started?

Learn more:

Asana Connectivity Solutions

In this article

Related articles