Acumatica Integration Guides and Tutorials

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

CData Software connectivity tools provide access to live Acumatica data from popular BI, analytics, ETL, and custom applications, offering our customers access to their data wherever they want. Below you will find a list of guides and tutorials for integrating with live Acumatica 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 Acumatica in Alteryx Designer
Amazon QuickSightCloud HubBuild Interactive Dashboards from Acumatica in Amazon QuickSight
Aqua Data StudioJDBCConnect to Acumatica in Aqua Data Studio
BirstJDBCBuild Visualizations of Acumatica in Birst
BIRTJDBCDesign BIRT Reports on Acumatica
Clear AnalyticsODBCBuild Charts with Acumatica in Clear Analytics
Microsoft ExcelExcelExcel Spreadsheet Automation with the QUERY Formula
DBxtraODBCBuild Dashboards with Acumatica in DBxtra
DomoODBCCreate Datasets from Acumatica in Domo Workbench
Dundas BIODBCBuild Dashboards with Acumatica in Dundas BI
FineReportJDBCFeed Acumatica into FineReport
Google Data StudioCloud HubCreate Reports from Acumatica in Google Data Studio
IBM Cognos BIODBCCreate Data Visualizations in Cognos BI with Acumatica
JasperServerJDBCCreate Acumatica Reports on JasperReports Server
Jaspersoft BI SuiteJDBCConnect to Acumatica in Jaspersoft Studio
JReport DesignerJDBCIntegrate with Acumatica in JReport Designer
KNIMEJDBCEnable the Acumatica JDBC Driver in KNIME
LINQPadADO.NETWorking with Acumatica in LINQPad
Power BI DesktopPower BIAuthor Power BI Reports on Real-Time Acumatica
Power BI OnlineCloud HubVisualize Live Acumatica in the Power BI Service
Microsoft SSASADO.NETBuild an OLAP Cube in SSAS from Acumatica
MicroStrategyJDBCUse the CData JDBC Driver for Acumatica in MicroStrategy
OBIEEJDBCAcumatica Reporting in OBIEE with the Acumatica JDBC Driver
Pentaho Report DesignerJDBCIntegrate Acumatica in the Pentaho Report Designer
QlikViewODBCConnect to and Query Acumatica in QlikView over ODBC
RJDBCAnalyze Acumatica in R
RapidMiner JDBCConnect to Acumatica in RapidMiner
SAP Business ObjectsJDBCCreate an SAP BusinessObjects Universe on the CData JDBC Driver for Acumatica
SAP Crystal ReportsJDBCPublish Reports with Acumatica in Crystal Reports
SAP LumiraAPI ServerConsume Acumatica OData Feeds in SAP Lumira
SASODBCUse the CData ODBC Driver for Acumatica in SAS for Real-Time Reporting and Analytics
SisenseJDBCVisualize Live Acumatica in Sisense
Spago BIJDBCConnect to Acumatica in SpagoBI
TableauODBCVisualize Acumatica in Tableau
Tableau OnlineCloud HubBuild Acumatica Visualizations in Tableau Online
Tableau ServerODBCPublish and Share Acumatica Dashboards with Tableau Server
TIBCO SpotfireADO.NETVisualize Acumatica in TIBCO Spotfire through ADO.NET
TIBCO Spotfire ServerJDBCOperational Reporting on Acumatica from Spotfire Server
VisioODBCLink Visio Shapes to Acumatica

Back to top

ETL & Replication


ProductTechnologyArticle Title
Amazon RedshiftCData SyncAutomated Continuous Acumatica Replication to Amazon Redshift
Amazon S3CData SyncAutomated Continuous Acumatica Replication to Amazon S3
Apache CassandraCData SyncAutomated Continuous Acumatica Replication to Apache Cassandra
AWS GlueJDBCConnect to Acumatica in AWS Glue Jobs Using JDBC
BIMLSSISUse Biml to Build SSIS Tasks to Replicate Acumatica to SQL Server
CloverDXJDBCConnect to Acumatica in CloverDX (formerly CloverETL)
CSVCData SyncAutomated Continuous Acumatica Replication to Local Delimited Files
IBM DB2CData SyncAutomated Continuous Acumatica Replication to IBM DB2
FoxProODBCWork with Acumatica in FoxPro
Google BigQueryCData SyncAutomated Continuous Acumatica Replication to Google BigQuery
Google Cloud SQLCData SyncAutomated Continuous Acumatica Replication to Google Cloud SQL
Google Data FusionJDBCPipe Acumatica in Google Data Fusion
Heroku / Salesforce ConnectCData SyncReplicate Acumatica for Use in Salesforce Connect
Informatica CloudJDBCIntegrate Acumatica in Your Informatica Cloud Instance
Informatica PowerCenterJDBCCreate Informatica Mappings From/To a JDBC Data Source for Acumatica
Jaspersoft ETLJDBCConnect to Acumatica in Jaspersoft Studio
Microsoft AccessCData SyncAutomated Continuous Acumatica Replication to Microsoft Access
Microsoft Azure TablesCData SyncAutomated Continuous Acumatica Replication to Azure SQL
Microsoft ExcelExcelTransfer Data from Excel to Acumatica
MongoDBCData SyncAutomated Continuous Acumatica Replication to MongoDB
MySQLCData SyncAutomated Continuous Acumatica Replication to MySQL
Oracle Data IntegratorJDBCETL Acumatica in Oracle Data Integrator
Oracle DatabaseCData SyncAutomated Continuous Acumatica Replication to Oracle
PostgreSQLCData SyncAutomated Continuous Acumatica Replication to PostgreSQL
Replicate to CSVPowerShellReplicate Acumatica to MySQL with PowerShell
SnowflakeCData SyncAutomated Continuous Acumatica Replication to Snowflake
SQL ServerCData SyncAutomated Continuous Acumatica Replication to SQL Server
SQLiteCData SyncAutomated Continuous Acumatica Replication to SQLite
TalendJDBCConnect to Acumatica and Transfer Data in Talend
UiPath StudioODBCCreate an RPA Flow that Connects to Acumatica in UiPath Studio

Back to top

Data Virtualization



Back to top

Software Development


ProductTechnologyArticle Title
.NET ChartsADO.NETDataBind Charts to Acumatica
.NET QueryBuilderODBCRapidly Develop Acumatica-Driven Apps with Active Query Builder
Angular JSAPI ServerUsing AngularJS to Build Dynamic Web Pages with Acumatica
Apache SparkJDBCWork with Acumatica in Apache Spark Using SQL
Microsoft Azure Logic AppsAPI ServerTrigger Acumatica IFTTT Flows in Azure App Service
ColdFusionJDBCQuery Acumatica in ColdFusion
DevExpressADO.NETDataBind Acumatica to the DevExpress Data Grid
EF - Code FirstADO.NETAccess Acumatica with Entity Framework 6
EF - LINQADO.NETLINQ to Acumatica
EF - MVCADO.NETBuild MVC Applications with Connectivity to Acumatica
Filemaker ProJDBCBidirectional Access to Acumatica from FileMaker Pro
GoODBCWrite a Simple Go Application to work with Acumatica on Linux
Google Apps ScriptCloud HubConnect to Acumatica in Google Apps Script
HibernateJDBCObject-Relational Mapping (ORM) with Acumatica Entities in Java
IntelliJJDBCConnect to Acumatica in IntelliJ
JBossJDBCConnect to Acumatica from a Connection Pool in JBoss
JDBIJDBCCreate a Data Access Object for Acumatica using JDBI
JRubyJDBCConnect to Acumatica in JRuby
NodeJSAPI ServerQuery Acumatica from Node.js
NodeJSCloud HubQuery Acumatica as a MySQL Database in Node.js
PHPCloud HubAccess Acumatica in PHP through the Cloud Hub
PHPODBCNatively Connect to Acumatica in PHP
PowerShellPowerShellPipe Acumatica to CSV in PowerShell
PowerBuilderADO.NETConnect to Acumatica from PowerBuilder
PyCharmODBCUsing the CData ODBC Driver for Acumatica in PyCharm
PythonODBCConnect to Acumatica in Python on Linux/UNIX
RubyODBCConnect to Acumatica in Ruby
SAP UI5API ServerIntegrate Real-Time Access to Acumatica in SAPUI5 MVC Apps
TomcatJDBCConfigure the CData JDBC Driver for Acumatica in a Connection Pool in Tomcat
VCL App (RAD Studio)FireDACBuild a Simple VCL Application for Acumatica
WebLogicJDBCConnect to Acumatica from a Connection Pool in WebLogic

Back to top

Data Management



Back to top

Workflow Automation



Back to top