CData Software - Knowledge Base

Recent Acumatica Articles

Use the CData Software ODBC Driver for Acumatica in SAS for Real-Time Reporting and Analytics

Connect to real-time Acumatica ERP in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Acumatica.

Extract, Transform, and Load Acumatica in Informatica PowerCenter

Create a simple Workflow for Acumatica ERP in Informatica PowerCenter.

How to connect to Acumatica from Spring Boot

Connect to Acumatica in a Spring Boot Application using CData JDBC Acumatica Driver

Replicate Acumatica for Use in Salesforce Connect

Replicate Acumatica ERP to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.

Build Acumatica-Connected Apps in Bubble

Use CData Connect Cloud to create an OData feed for Acumatica and create custom apps in Bubble.

How to Build Dynamic React Apps with Acumatica

Use the CData Connect and React to Build Dynamic Web Apps with Live Acumatica .

Connect to Acumatica from a Connection Pool in Jetty

The Acumatica JDBC Driver supports connection pooling: This article shows how to connect faster to Acumatica ERP from Web apps in Jetty.

Viewing Acumatica in RAD Studio Data Explorer

How to view Acumatica ERP in RAD Studio Data Explorer using the CData ODBC Driver for Acumatica.

Analyze Live Acumatica in SAS Viya

Use CData Connect Cloud to connect to Acumatica ERP from SAS Viya and deploy self-service analytics using live Acumatica ERP.

Access Live Acumatica in TIBCO Data Virtualization

Use the CData Software TIBCO DV Adapter for Acumatica to create a Acumatica ERP source in TIBCO Data Virtualization Studio and gain access to live Acumatica ERP from your TDV Server.

Automate Acumatica Replication to Couchbase

Use CData Sync to Customize and automate Acumatica ERP replication to Couchbase.

A PostgreSQL Interface for Acumatica

Use the SQL Gateway and Acumatica ODBC Driver to create a PostgreSQL entry-point for data access.

Connect to Acumatica from PowerBuilder

This article demonstrates how to use the CData ODBC Driver for Acumatica to connect to Acumatica ERP and execute queries in PowerBuilder.

Build MVC Applications with Connectivity to Acumatica

This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Acumatica from an ASP.NET MVC application.

Automate Acumatica Integration Tasks from PowerShell

Are you in search of a quick and easy way to access Acumatica ERP from PowerShell? This article demonstrates how to utilize the Acumatica Cmdlets for tasks like connecting to Acumatica ERP, automating operations, downloading data, and more.

Access Acumatica from MySQL in HeidiSQL

Use CData ODBC Driver and SQL Gateway to connect and query live Acumatica ERP from HeidiSQL.

Analyze Acumatica in SAP Analytics Cloud

Use CData Connect Cloud to create an OData API on top of Acumatica ERP and visualize Acumatica ERP in SAP Analytics Cloud.

Connect to Acumatica in NetBeans

Connect to Acumatica ERP in NetBeans with the data source configuration wizard.

How to Work with Acumatica in AWS Glue Jobs Using JDBC

Connect to Acumatica from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.

Use CData Connect Cloud to Access Acumatica in Microsoft Power Pivot

Use CData Connect Cloud to connect to live Acumatica ERP in the Power Pivot business intelligence tool.

Enable the Acumatica JDBC Driver in KNIME

Use standard data access components in KNIME to create charts and reports with Acumatica ERP.

Connect to Acumatica from a Connection Pool in WebLogic

Use the CData JDBC Driver for Acumatica to connect to Acumatica ERP from Web applications running on WebLogic.

Create an SAP BusinessObjects Universe on the CData JDBC Driver for Acumatica

Provide connectivity to Acumatica ERP through an SAP BusinessObjects universe.

Working with Acumatica in LINQPad

Execute LINQ queries to Acumatica ERP in LINQPad.

Access Live Acumatica in Excel 365 Online (Excel for the web)

Connect to Acumatica ERP from Excel 365 Online (Excel for the web) with CData Connect Cloud.

Connect to Acumatica through External Services in Salesforce

How to Connect the Power BI Service to Acumatica: Complete Guide

Connect to the CData Software Power BI Connectors from PowerBI.com to provide real-time datasets across the organization.

How to Query Acumatica in MySQL Workbench

Execute MySQL queries against live Acumatica ERP from MySQL Workbench.

Automated Continuous Acumatica Replication to Oracle

Use CData Sync for automated, continuous, customizable Acumatica replication to Oracle.

PowerShell Scripting to Replicate Acumatica to MySQL

Write a simple PowerShell script to replicate Acumatica ERP to a MySQL database.

Connect to Acumatica as a SQL Server Linked Server

Use CData Connect Cloud to create a linked server for live Acumatica ERP.

Automated Continuous Acumatica Replication to Google BigQuery

Use CData Sync for automated, continuous, customizable Acumatica replication to Google BigQuery.

Query Acumatica in DataGrip

Create a Data Source for Acumatica in DataGrip and use SQL to query live Acumatica ERP.

How to connect PolyBase to Acumatica

Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Acumatica ERP.

Add Acumatica to Informatica Enterprise Data Catalog

Use the CData Software JDBC Driver for Acumatica with the Informatica Enterprise Data Catalog to classify and organize data.

Create Informatica Mappings From/To an ODBC Data Source for Acumatica

Create an ODBC connection to Acumatica in Informatica and browse and transfer Acumatica ERP.

Visualize Acumatica in TIBCO Spotfire through ODBC

The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load Acumatica ERP into TIBCO Spotfire.

Create Reports from Acumatica in Looker Studio

Use CData Connect Cloud to gain access to live Acumatica ERP and create custom reports in Looker Studio.

Connect to Acumatica in Google Apps Script

Use CData Connect Cloud to access Acumatica ERP in Google Apps Script.

Analyze Acumatica in Infragistics Reveal

Use CData Connect Cloud to create on OData API on top of Acumatica ERP and visualize live Acumatica ERP in Infragistics Reveal.

Create Datasets from Acumatica in Domo Workbench and Build Visualizations of Acumatica in Domo

Use the CData Software ODBC Driver for Acumatica to create datasets from Acumatica ERP in Domo Workbench and then build visualizations in the Domo service.

Visualize Acumatica from Tableau

Use the Tableau Desktop business intelligence tool to connect to Acumatica ERP.

Connect to Acumatica from AWS Glue

Use CData Connect Cloud to gain access to live Acumatica ERP from your AWS Glue jobs.

Use the CData SSIS Components to Insert New or Update Existing Acumatica Records from SQL Server

Easily push SQL Server data to Acumatica using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Acumatica or update existing records with data from a SQL Server database.

Analyze Acumatica in R

Create data visualizations and use high-performance statistical functions to analyze Acumatica ERP in Microsoft R Open.

Back Up Acumatica ERP to SQL Server through SSIS

Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Acumatica. In this article, we will employ an SSIS workflow to populate a database with Acumatica ERP data.

Perform Batch Operations with Acumatica in Apache NiFi

Connect to Acumatica ERP and perform batch operations in Apache NiFi using the CData Software JDBC Driver.

Automated Continuous Acumatica Replication to Databricks

Use CData Sync for automated, continuous, customizable Acumatica replication to Databricks.

Create Acumatica Dataflows on PowerBI.com

Connect to the CData Power BI Connectors from PowerBI.com to create Power BI Dataflows with real-time data.

Create a Data Access Object for Acumatica using JDBI

A brief overview of creating a SQL Object API for Acumatica ERP in JDBI.

Access Acumatica from MySQL in PHP

Connect to Acumatica through the standard MySQL libraries in PHP.

Integrating Acumatica in Talend Cloud Data Management Platform

Connect Acumatica with Talend Cloud Data Management Platform using the [product_name].

Automated Continuous Acumatica Replication to Azure SQL

Use CData Sync for automated, continuous, customizable Acumatica replication to Azure SQL.

How to Import Acumatica into SQL Server using SSIS

Easily back up Acumatica ERP to SQL Server using the SSIS components for Acumatica.

Create Acumatica-Connected Business Apps in AppSheet

Connect to Acumatica via CData Connect Cloud in Google AppSheet and create custom business applications with real-time access to Acumatica ERP.

Acumatica Reporting and Star Schemas in OBIEE

Create a star schema that shows perspectives on Acumatica facts in real time.

Integrate Acumatica with External Services using SnapLogic

Use CData JDBC drivers in SnapLogic to integrate Acumatica with External Services.

Analyze Acumatica in Looker

Use CData Connect Cloud to connect to Acumatica from Looker and build custom apps using live Acumatica ERP.

Automated Continuous Acumatica Replication to SQL Server

Use CData Sync for automated, continuous, customizable Acumatica replication to SQL Server.

Connect to Acumatica in Google Apps Script

Use the ODBC Driver for Acumatica and the SQL Gateway to access Acumatica ERP from Google Apps Script.

Query Acumatica in MySQL Workbench

Create a virtual MySQL database for Acumatica ERP in CData Software Connect (or Connect Server) and work with live Acumatica ERP in MySQL Workbench.

Build Acumatica-Connected Dashboards Using Zoho Analytics

Use CData Connect Cloud to connect to Acumatica from Zoho Analytics and import live Acumatica ERP.

Visualize Live Acumatica of Power BI Report Builder in Power BI Service

Use CData Power BI Connectors to connect to live Acumatica ERP using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.

Automate Acumatica Replication to Azure Data Lake

Use CData Sync to customize and automate Acumatica ERP replication to Azure Data Lake.

Connect to Acumatica in JRuby

Create a simple JRuby app with access to live Acumatica ERP.

Build Semantic Layer Views for Acumatica in APOS Live Data Gateway

Use the CData Connector for Acumatica in APOS Live Data Gateway to build Semantic Layer Views for Acumatica ERP.

Export Data from SQL Server to Acumatica through SSIS

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

Connect to Acumatica in SpagoBI

Create reports featuring live Acumatica ERP in SpagoBI Studio. Host Acumatica reports on SpagoBI Server.

Import Acumatica into FileMaker Pro

Create reports that integrate Acumatica ERP in Filemaker Pro.

Query Acumatica as a SQL Server Database in Node.js

Execute SQL Server queries against Acumatica ERP from Node.js.

Connect to and Visualize Live Acumatica in Tableau Prep

Use CData Tableau Connectors and Tableau Prep Builder to visualize live Acumatica ERP.

Validate Acumatica with QuerySurge

Access and validate Acumatica ERP in QuerySurge using the CData JDBC Driver.

Integrate Acumatica into Power Automate Desktop using CData Connect

CData Connect for Acumatica enables you to integrate Acumatica ERP into workflows built using Microsoft Power Automate Desktop.

Visualize Acumatica in Sisense

Create an ElastiCube in Sisense app with access to Acumatica ERP.

Integrate Acumatica in Your Informatica Cloud Instance

Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Acumatica ERP from Informatica Cloud.

How to Use a Microsoft Access Database to Update Acumatica in Real Time

Update Acumatica data by creating a linked table in Microsoft Access with the CData Acumatica ODBC Driver.

Explore Geographical Relationships in Acumatica with Power Map

Create data visualizations with Acumatica ERP in Power Map.

Automated Continuous Acumatica Replication to AlloyDB

Use CData Sync for automated, continuous, customizable Acumatica replication to AlloyDB.

Replicate Acumatica to Multiple Databases

Replicate Acumatica ERP to disparate databases with a point-and-click configuration.

Build a Simple VCL Application for Acumatica

How to build a simple VCL Application to view Acumatica ERP in RAD Studio using the CData ODBC Driver for Acumatica.

How to connect to Acumatica from IntelliJ

Integrate connectivity to Acumatica ERP with wizards in IntelliJ.

Create Acumatica Dashboards in Bold BI

Use CData Software Connect Server to create a virtual SQL Server Database for Acumatica ERP to build custom dashboards in Bold BI.

Query Acumatica in ColdFusion

Write standard ColdFusion data access code to connect to Acumatica ERP.

Automated Continuous Acumatica Replication to Apache Cassandra

Use CData Sync for automated, continuous, customizable Acumatica replication to Apache Cassandra.

Build Acumatica-Connected Visualizations in datapine

Use CData Connect Cloud and datapine to build visualizations and dashboards with access to live Acumatica ERP.

Integrate with Acumatica in JReport Designer

Create charts and reports based on Acumatica ERP in JReport Designer.

Create Apps from Acumatica in Qlik Sense Cloud

Use CData Connect Cloud to connect to Acumatica and build apps from live Acumatica ERP in Qlik Sense Cloud.

ETL Acumatica in Oracle Data Integrator

This article shows how to transfer Acumatica ERP into a data warehouse using Oracle Data Integrator.

How to use SQLAlchemy ORM to access Acumatica in Python

Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Acumatica ERP.

How to update Acumatica from Excel

This article explains how to transfer data from Excel to Acumatica using the Excel Add-In for Acumatica.

Natively Connect to Acumatica in PHP

Create PHP applications on Linux/UNIX machines with connectivity to Acumatica ERP. Leverage the native support for ODBC in PHP.

Replicate Multiple Acumatica Accounts

Replicate multiple Acumatica accounts to one or many databases.

Connect to Acumatica in Ruby

Connect to Acumatica ERP in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.

Connect to Acumatica from PowerBuilder

This article demonstrates how to access Acumatica ERP from Appeon PowerBuilder using the CData ADO.NET Provider for Acumatica.

Connect to Acumatica as an External Data Source using PolyBase

Use CData Connect Cloud and PolyBase to create an external data source in SQL Swerver with access to live Acumatica ERP.

Provide OData Services of Acumatica from a WCF Application

In this article, we will demonstrate the process of generating an OData feed for Acumatica ERP by developing a WCF Service Application.

Automated Continuous Acumatica Replication to Google Cloud SQL

Use CData Sync for automated, continuous, customizable Acumatica replication to Google Cloud SQL.

Use the CData Software ODBC Driver for Acumatica in MicroStrategy

Connect to Acumatica ERP in MicroStrategy Developer using the CData Software ODBC Driver for Acumatica.

Automated Continuous Acumatica Replication to Amazon Redshift

Use CData Sync for automated, continuous, customizable Acumatica replication to Amazon Redshift.

Connect to Acumatica from HeidiSQL

Use CData Connect Cloud to connect to and query live Acumatica ERP from HeidiSQL.

Integrate with Acumatica using Apache Camel2

Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Acumatica ERP to a JSON file on disk.

Visualize Live Acumatica in the Power BI Service

Use CData Connect Cloud to connect to live Acumatica ERP and create custom reports in the Power BI Service through the On-Premises Gateway.

How to pipe Acumatica to CSV in PowerShell

Use standard PowerShell cmdlets to access Acumatica tables.

Query, Visualize, and Share live Acumatica in Redash

Use CData Connect Cloud to connect to live Acumatica ERP in Redash for querying, visualizing, and sharing.

Integrate with Live Acumatica in MuleSoft (via CData Connect Cloud)

Use CData Connect Cloud to connect to Acumatica from the MuleSoft Anypoint Platform to integrate live Acumatica ERP into custom reports and dashboards.

Integrate with Acumatica in SnapLogic

Use CData Connect Cloud to connect to and integrate with live Acumatica ERP in SnapLogic.

Replicate Acumatica from PowerShell

Write a quick PowerShell script to query Acumatica ERP. Use connectivity to the live data to replicate Acumatica ERP to SQL Server.

How to Access Live Acumatica in Power Automate Desktop via ODBC

The CData ODBC Driver for Acumatica enables you to integrate Acumatica ERP into workflows built using Microsoft Power Automate Desktop.

Use the CData Software JDBC Driver for Acumatica in MicroStrategy Desktop

Connect to Acumatica ERP in MicroStrategy Desktop using the CData Software JDBC Driver for Acumatica.

Model Acumatica Using Azure Analysis Services

Leverage CData Connect Cloud to establish a connection between Azure Analysis Services and Acumatica, enabling the direct import of real-time Acumatica ERP.

Automated Continuous Acumatica Replication to SingleStore

Use CData Sync for automated, continuous, customizable Acumatica replication to SingleStore.

Build Acumatica-Connected ETL Processes in Google Data Fusion

Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Acumatica ERP.

Visualize Acumatica in Tableau

The CData ODBC driver for Acumatica enables you integrate Acumatica ERP into Tableau dashboards.

Author and Share Power BI Reports on Real-Time Acumatica

Use the CData ODBC Driver for Acumatica to visualize Acumatica ERP in Power BI Desktop and then upload to the Power BI service.

View Reports on Real-Time Acumatica in Power BI Report Server

Use the CData ODBC Driver for Acumatica to visualize Acumatica ERP in Power BI Desktop and then publish them to Power BI Report Server.

A PostgreSQL Interface for Acumatica

Use the Remoting features of the Acumatica ODBC Driver to create a PostgreSQL entry-point for data access.

How to Visualize Acumatica Data in Python with pandas

Use pandas and other modules to analyze and visualize live Acumatica ERP in Python.

Connect to Acumatica in CloverDX (formerly CloverETL)

Transfer Acumatica ERP using the visual workflow in the CloverDX data integration tool.

Build Dashboards with Acumatica in DBxtra

Create dynamic dashboards and perform analytics based on Acumatica ERP in DBxtra.

LINQ to Acumatica

LINQ offers versatile querying capabilities within the .NET Framework (v3.0+), offering a straightforward method for programmatic data access through CData ADO.NET Data Providers. In this article, we demonstrate the use of LINQ to retrieve information from the Acumatica Data Provider.

Analyze Acumatica with Power Pivot

This article walks you through the process of using the CData ODBC Driver for Acumatica from Power Pivot. You will use the Table Import Wizard to load Acumatica ERP. You can visually build the import query or use any SQL supported by the driver.

Automate Acumatica Replication to Azure Synapse

Use CData Sync to customize and automate Acumatica ERP replication to Azure Synapse.

Connect to Live Acumatica in PostGresSQL Interface through CData Connect Cloud

Create a live connection to Acumatica in CData Connect Cloud and connect to your Acumatica ERP from PostgreSQL.

DataBind Controls to Acumatica in Delphi

DataBind to Acumatica ERP in Delphi with standard data access components and controls.

Publish Crystal Reports on Acumatica

Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Acumatica ERP.

How to publish and share Acumatica dashboards with Tableau Server

The CData ODBC driver for Acumatica enables you integrate Acumatica ERP into Tableau dashboards.

Use the CData ODBC Driver for Acumatica in SAS JMP

You can use the CData ODBC Driver to integrate Acumatica ERP into the statistical analysis tools available in SAS JMP. This article shows how to use Acumatica ERP in the Graph Builder and Query Builder.

Manage Acumatica in DBArtisan as a JDBC Source

Use wizards in DBArtisan to create a JDBC data source for Acumatica.

Automated Continuous Acumatica Replication to PostgreSQL

Use CData Sync for automated, continuous, customizable Acumatica replication to PostgreSQL.

Connect to Acumatica in Aqua Data Studio

Access Acumatica ERP from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.

Creating Acumatica-Connected Applications in Unqork

You can use CData Connect Cloud to feed Acumatica ERP to Unqork and build custom business apps.

Build Dashboards with Acumatica in Dundas BI

Create dynamic dashboards and perform analytics based on Acumatica ERP in Dundas BI.

How to Build an ETL App for Acumatica in Python with CData

Create ETL applications and real-time data pipelines for Acumatica ERP in Python with petl.

Process & Analyze Acumatica in Databricks (AWS)

Use CData, AWS, and Databricks to perform data engineering and data science on live Acumatica .

Build Acumatica-Connected Apps in Choreo

Use CData Connect Cloud to connect to Acumatica from Choreo and build custom apps using live Acumatica ERP.

How to integrate Metabase with Acumatica

Use CData Connect Cloud to connect to live Acumatica ERP and create an interactive dashboard in Metabase from Acumatica ERP.

How to create Acumatica federated tables in MySQL

Use the SQL Gateway and the ODBC Driver to set up federated tables for Acumatica ERP in MySQL .

Access Live Acumatica in Google Sheets

Use CData Connect Cloud to gain access to live Acumatica ERP from your Google Sheets.

How to connect to Acumatica in DBVisualizer

Integrate Acumatica ERP with visual data analysis tools and data connection wizards in DBVisualizer

Prepare, Blend, and Analyze Acumatica in Alteryx Designer

Build workflows to access live Acumatica ERP for self-service data analytics.

Visualize Acumatica in Tableau Desktop (through CData Connect)

Create a virtual SQL Server database for Acumatica ERP in CData Software Connect (or Connect Server) and build visualizations from live Acumatica ERP in Tableau Desktop.

Automated Continuous Acumatica Replication to Apache Kafka

Use CData Sync for automated, continuous, customizable Acumatica replication to Apache Kafka.

Establish a Live Connection with Acumatica using Tableau Bridge

The CData ODBC Driver for Acumatica enables you to integrate live Acumatica ERP into Tableau Cloud dashboards using the Tableau Bridge.

Replicate Acumatica to Multiple Databases

Replicate Acumatica ERP to disparate databases with a single configuration.

Integrate Acumatica in the Pentaho Report Designer

Publish reports based on Acumatica ERP in the Pentaho BI tool.

Create Data Visualizations in Cognos BI with Acumatica

Access Acumatica ERP as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.

Use JayDeBeApi to access Acumatica in Python

Use standard Python scripting and the development environment of your choice to access live Acumatica ERP.

Stream Acumatica into Apache Kafka Topics

Access and stream Acumatica ERP in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.

Analyze Acumatica in R

Use standard R functions and the development environment of your choice to analyze Acumatica ERP with the CData JDBC Driver for Acumatica.

Connect to Acumatica from a Connection Pool in JBoss

Integrate Acumatica ERP into Java servlets: Use the Management Console in JBoss to install the Acumatica JDBC Driver.

Connect to Acumatica in RazorSQL

Connect to Acumatica from wizards and query Acumatica ERP from the GUI in the RazorSQL database management tool.

Access Live Acumatica in AWS Lambda (with IntelliJ IDEA)

Connect to live Acumatica ERP in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.

Using the CData Software ODBC Driver for Acumatica in PyCharm

Connect to Acumatica as an ODBC data source in PyCharm using the CData Software ODBC Driver for Acumatica.

How to work with Acumatica in Apache Spark using SQL

Access and process Acumatica in Apache Spark using the CData Software JDBC Driver.

How to Connect to & Open Acumatica in Microsoft Excel

This article uses the CData ODBC driver for Acumatica to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.

Rapidly Develop Acumatica-Driven Apps with Active Query Builder

Leverage the Active Query Builder SQL interface builder and the ease of .NET data access to create data-driven WinForms and ASP.NET apps.

DataBind Acumatica to the DevExpress Data Grid

Use the CData Software ADO.NET Provider for Acumatica with the DevExpress Windows Forms and Web controls to provide Acumatica ERP to a chart.

Deploy the ADO.NET Provider for Acumatica on an SSRS Report Server

Connect to Acumatica ERP from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.

Connect to Acumatica from Crystal Reports

Use CData Connect Cloud to connect to and report on live Acumatica ERP from Crystal Reports.

Design BIRT Reports on Acumatica

Provide current Acumatica ERP to your embedded analytics.

Build Pipelines with Live Acumatica in Google Cloud Data Fusion (via CData Connect Cloud)

Use CData Connect Cloud to connect to Acumatica from Google Cloud Data Fusion, enabling the integration of live Acumatica ERP into the building and management of effective data pipelines.

Build Visualizations of Acumatica in Birst

Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Acumatica ERP in Birst.

Automated Continuous Acumatica Replication to Microsoft Access

Use CData Sync for automated, continuous, customizable Acumatica replication to Microsoft Access.

Use Dash to Build to Web Apps on Acumatica

Create Python applications that use pandas and Dash to build Acumatica-connected web apps.

Use the CData Software JDBC Driver for Acumatica in MicroStrategy

Connect to Acumatica ERP in MicroStrategy Developer using the CData Software JDBC Driver for Acumatica.

Automated Continuous Acumatica Replication to Snowflake

Use CData Sync for automated, continuous, customizable Acumatica replication to Snowflake.

Connect to Acumatica in the Denodo Platform

Use CData driver technologies to create a virtual data source for Acumatica ERP in the Denodo Virtual DataPort Administrator.

Using AngularJS to Build Dynamic Web Pages with Acumatica

Use the CData Connect Server to create Acumatica OData feeds and build single-page applications with live Acumatica ERP.

Use the CData Software JDBC Driver for Acumatica in MicroStrategy Web

Connect to Acumatica ERP in MicroStrategy Web using the CData Software JDBC Driver for Acumatica.

Connect to Acumatica from Filemaker Pro (Mac)

Use CData Connect Cloud to connect to and query live Acumatica ERP from Filemaker Pro on Mac.

Import Real-Time Acumatica in ColdFusion to Build Applications

Use CData JDBC drivers to import and use Acumatica ERP in ColdFusion.

Visualize Acumatica in TIBCO Spotfire through OData

Integrate Acumatica ERP into dashboards in TIBCO Spotfire.

Visualize Acumatica in TIBCO Spotfire through ADO.NET

Integrate Acumatica ERP into dashboards in TIBCO Spotfire.

Connect to Acumatica in DigitalSuite Studio through RunMyProcess DSEC

Use Arkobi Digital

How to Work with Acumatica in ETL Validator JDBC

Connect to Acumatica from ETL Validator jobs using the CData Software JDBC Driver.

How to Create Power BI Visual Reports with Real-Time Acumatica

Use CData Power BI Connectors to visualize Acumatica ERP in Power BI.

Load Acumatica to a Database Using Embulk

Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Acumatica ERP to a database.

Integrate Live Acumatica into Amazon SageMaker Canvas with RDS

Use CData Connect Cloud to connect to Acumatica from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Acumatica ERP.

Automated Continuous Acumatica Replication to Local Delimited Files

Use CData Sync for automated, continuous, customizable Acumatica replication to delimited files (CSV/TSV).

Create Acumatica-Connected Visualizations in Klipfolio

Use CData Connect Cloud to connect to Acumatica from Klipfolio and build custom visualizations using live Acumatica ERP.

Connect to Live Acumatica in MicroStrategy through CData Connect Cloud

Create a live connection to Acumatica in CData Connect Cloud and connect to your Acumatica ERP from MicroStrategy.

Acumatica Cloud Connectivity

Explore a compilation of guides and tutorials demonstrating how to establish connections to Acumatica ERP through CData Connect Cloud using different applications and tools.

Create Acumatica-Connected Nintex Workflows

Use CData Connect Cloud to connect to Acumatica from Nintex Workflow Cloud and build custom workflows using live Acumatica ERP.

Integrate with live Acumatica in Jitterbit

Use CData Connect Cloud to connect to and integrate live Acumatica ERP in Jitterbit.

Visualize Live Acumatica in Tableau

Use CData Tableau Connectors and Tableau Desktop to visualize live Acumatica ERP.

A PostgreSQL Interface for Acumatica

Use the Remoting features of the Acumatica JDBC Driver to create a PostgreSQL entry-point for data access.

Connect to Acumatica in as an External Source in Dremio

Use the CData JDBC Driver to connect to Acumatica as an External Source in Dremio.

Access Acumatica from MySQL in Amazon QuickSight

Connect to Acumatica and build visualizations of Acumatica ERP using a MySQL Connection in Amazon QuickSight.

Publish Acumatica-Connected Dashboards in Tableau Server

Use CData Tableau Connectors and Tableau Server to visualize live Acumatica ERP.

Automate Acumatica Replication to SAP HANA

Use CData Sync to customize and automate Acumatica ERP replication to SAP HANA.

Create Reports with Acumatica in SAP Crystal Reports

Use the Report Wizard to design a report based on up-to-date Acumatica ERP.

Use the CData Software ODBC Driver for Acumatica in MicroStrategy Web

Connect to Acumatica ERP in MicroStrategy Web using the CData Software ODBC Driver for Acumatica.

How to import Acumatica into Apache Solr

Use the CData Software JDBC Driver for Acumatica in Data Import Handler and create an automated import of Acumatica ERP to Apache Solr Enterprise Search platform.

Use Biml to Build SSIS Tasks to Replicate Acumatica to SQL Server

Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Acumatica ERP to SQL Server.

Work with Acumatica in FoxPro

Load Acumatica ERP into a FoxPro database. This article includes full code and a walk-through of the process.

How to create Visio diagrams from Acumatica

Automatically update Acumatica ERP with the changes you make to Visio master shapes.

Create SSAS Tabular Models from Acumatica

How to build a SQL Server Analysis Service Tabular Model from Acumatica ERP using CData drivers.

Use the CData ODBC Driver for Acumatica in Microsoft Power Query

You can use the CData Acumatica ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Acumatica ERP into Microsoft Power Query.

Replicate Multiple Acumatica Accounts

Replicate multiple Acumatica accounts to one or many databases.

Analyze Acumatica in Cognos Analytics

Use CData Connect Cloud to connect to Acumatica from Cognos Analytics and analyze live Acumatica ERP.

Create Acumatica-Connected Enterprise Applications in OutSystems

Use CData Connect Cloud to connect to Acumatica from OutSystems and build custom enterprise apps using live Acumatica ERP.

How to connect to Acumatica with Squirrel SQL client

Connect to Acumatica ERP and execute queries in the Squirrel SQL Client.

Automated Continuous Acumatica Replication to SQLite

Use CData Sync for automated, continuous, customizable Acumatica replication to SQLite.

Visualize Live Acumatica in Power BI (via CData Connect Cloud)

Use the CData Power BI Connector and CData Connect Cloud to integrate live Acumatica ERP into custom reports in Power BI.

How to integrate Acumatica with Apache Airflow

Access and process Acumatica ERP in Apache Airflow using the CData JDBC Driver.

Acumatica Reporting in OBIEE with the Acumatica JDBC Driver

Deploy the Acumatica JDBC driver on OBIEE to provide real-time reporting across the enterprise.

Configure the CData JDBC Driver for Acumatica in a Connection Pool in Tomcat

Connect to Acumatica ERP from a connection pool in Tomcat.

Build Acumatica-Connected Web Apps in Servoy

Use Servoy Developer to easily connect to Acumatica ERP and build web apps with connectivity to live Acumatica ERP.

Query Acumatica through ODBC in Node.js

Use node-odbc to execute SQL queries against Acumatica ERP from Node.js.

Build Acumatica-Connected Apps in Mendix

Use CData Connect Cloud to create an OData feed for Acumatica and create custom apps in Mendix.

Build Semantic Layer Views for Acumatica in APOS Live Data Gateway

Use the CData Connect Cloud and APOS Live Data Gateway to build Semantic Layer Views for Acumatica ERP.

How to connect Amazon QuickSight to Acumatica

Create a connection to Acumatica ERP in CData Connect Cloud and insert Acumatica ERP into Amazon QuickSight SPICE to build interactive dashboards.

Object-Relational Mapping (ORM) with Acumatica Entities in Java

Build Charts with Acumatica in Clear Analytics

Create dynamic charts and perform analytics based on Acumatica ERP in Clear Analytics.

Query Acumatica as a MySQL Database in Node.js

Execute MySQL queries against Acumatica ERP from Node.js.

How to Access Acumatica Using Entity Framework

This article shows how to access Acumatica ERP using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.

Edit and Search External Acumatica Objects in Salesforce Connect

Access Acumatica as a Remote Oracle Database

Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Acumatica ERP from your Oracle system.

Connect to Acumatica in Airbyte ELT Pipelines

Use CData Connect Cloud to build ELT pipelines for Acumatica ERP in Airbyte.

Access Acumatica in Mule Applications Using the CData JDBC Driver

Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for Acumatica ERP.

Access Live Acumatica in Coginiti Pro

Connect to and query live Acumatica ERP from the GUI in the Coginiti Pro: SQL Analytics Tool.

Publish Acumatica-Connected Dashboards in Tableau Server

Use CData JDBC drivers and Tableau Server to visualize live Acumatica ERP.

Connect to Acumatica in RunMyProcess through Connect Cloud

Use CData Connect Cloud to create on OData API for Acumatica and connect to Acumatica ERP in Akorbi Digital RunMyProcess.

How to connect to Acumatica from MS Excel on Mac OS X

Create a Data Source Name in iODBC with the CData ODBC Driver for Acumatica and work with Acumatica ERP in Microsoft Excel on Mac OS X.

How to Connect to Acumatica in Using Python: 6 Steps

Create Python applications on Linux/UNIX machines with connectivity to Acumatica ERP. Leverage the pyodbc module for ODBC in Python.

Create Dynamic Acumatica Grids Using the Infragistics XamDataGrid

Learn how you can connect Acumatica to Infragistics XamDataGrid to build dynamic grids.

Import Real-Time Acumatica in ColdFusion to Build Applications

Use CData ODBC drivers to import and use Acumatica ERP in ColdFusion.

DataBind Wijmo Grid to Acumatica

Provide real-time Acumatica ERP to interactive controls.

Natively Connect to Acumatica in PHP

The CData ODBC driver for Acumatica enables you to create PHP applications with connectivity to Acumatica ERP. Leverage the native support for ODBC in PHP.

Connect to Acumatica in RapidMiner

Integrate Acumatica ERP with standard components and data source configuration wizards in RapidMiner Studio.

Work with Live Acumatica in Power Query

Use CData Connect Cloud to connect to Acumatica ERP and work with live Acumatica ERP in Microsoft Power Query.

Create Acumatica Reports on JasperReports Server

Deploy the CData JDBC Driver on JasperReports Server to provide real-time Acumatica data access from reports, embedded analytics, and more.

Excel Spreadsheet Automation with the QUERY Formula

Pull data, automate spreadsheets, and more with the QUERY formula.

Build Acumatica Visualizations in Tableau Cloud

Use CData Connect Cloud to connect to live Acumatica ERP and build visualizations in Tableau Cloud.

Automated Continuous Acumatica Replication to Vertica

Use CData Sync for automated, continuous, customizable Acumatica replication to Vertica.

Bridge Acumatica Connectivity with Apache NiFi

Access and process Acumatica ERP in Apache NiFi using the CData JDBC Driver.

Connect to Acumatica in DBeaver

Use the CData ODBC Driver to connect to Acumatica ERP in DBeaver.

Connect to Acumatica from PowerBuilder

This article demonstrates how to access Acumatica ERP from PowerBuilder using the Acumatica JDBC Driver.

Operational Reporting on Acumatica from Spotfire Server

Create and share Spotfire data visualizations with real-time connectivity to remote Acumatica ERP.

Connect to Acumatica in HULFT Integrate

Connect to Acumatica as a JDBC data source in HULFT Integrate

Connect to and Query Acumatica in QlikView over ODBC

Create data visualizations with Acumatica ERP in QlikView.

Create Data Visualizations Based On Acumatica in Mode

Use CData Connect Cloud to connect to Acumatica from Mode and build visualizations using live

Automated Continuous Acumatica Replication to MongoDB

Use CData Sync for automated, continuous, customizable Acumatica replication to MongoDB.

Access Acumatica in PHP through Connect Server

Connect to Acumatica through the standard SQL Server libraries in PHP.

Write a Simple Go Application to work with Acumatica on Linux

Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Acumatica ERP.

Integrate Acumatica into Automated Tasks with Power Automate

Use CData Connect Cloud to connect to Acumatica ERP and integrate live Acumatica ERP into your Power Automate tasks.

Automated Continuous Acumatica Replication to MySQL

Use CData Sync for automated, continuous, customizable Acumatica replication to MySQL.

Feed Acumatica into FineReport

How to set Acumatica ERP as a JDBC data source in FineReport.

Automated Continuous Acumatica Replication to Amazon S3

Use CData Sync for automated, continuous, customizable Acumatica replication to Amazon S3.

Create an SAP BusinessObjects Universe on the CData ODBC Driver for Acumatica

Provide connectivity to Acumatica ERP through an SAP BusinessObjects universe.

Create Informatica Mappings From/To a JDBC Data Source for Acumatica

Create Acumatica data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.

Automated Continuous Acumatica Replication to IBM DB2

Use CData Sync for automated, continuous, customizable Acumatica replication to IBM DB2.

Connect to Acumatica from Asprova with CData Software ODBC Driver for Acumatica

This article shows how to connect faster to Acumatica data from Asprova.

Use the CData ODBC Driver for Acumatica from SharePoint Excel Services

Bidirectional Access to Acumatica from FileMaker Pro

Use the MySQL Remoting feature of the JDBC driver to integrate Acumatica ERP in Filemaker Pro for Mac or Windows.

How to connect and process Acumatica from Azure Databricks

Use CData, Azure, and Databricks to perform data engineering and data science on live Acumatica

How to create an RPA flow for Acumatica in UiPath Studio

Use the Acumatica ODBC Driver to create workflows that access real-time Acumatica ERP without any coding.

Connect to Acumatica in Jaspersoft Studio

Execute SQL to remote Acumatica ERP in Jaspersoft Studio.

How to Connect DBeaver to Acumatica via a JDBC Driver

Manage Acumatica ERP with visual tools in DBeaver like the query browser.

Import Acumatica Using Azure Data Factory

Use CData Connect Cloud to connect to Acumatica from Azure Data Factory and import live Acumatica ERP.

Connect to Acumatica in DBArtisan

Use wizards in DBArtisan to configure Acumatica ERP as a data source.

Prepare, Blend, and Analyze Acumatica in Alteryx Designer

Build workflows to access live Acumatica ERP for self-service data analytics.

Access Live Acumatica in AWS Lambda

Connect to live Acumatica ERP in AWS Lambda using the CData JDBC Driver.

DataBind Charts to Acumatica

Integrate Live Acumatica into Custom Business Apps Built in Power Apps

Use CData Connect Cloud to connect to Acumatica ERP and integrate live Acumatica ERP into apps built in Microsoft Power Apps.

Access Live Acumatica in Excel (Desktop)

Use CData Connect Cloud to gain access to live Acumatica ERP from your Excel spreadsheets.

Build an OLAP Cube in SSAS from Acumatica

Establish a connection to Acumatica ERP data from SQL Server Analysis Services, and use the Acumatica Data Provider to build OLAP cubes for use in analytics and reporting.

Use the CData Software ODBC Driver for Acumatica in MicroStrategy Desktop

Connect to Acumatica ERP in MicroStrategy Desktop using the CData Software ODBC Driver for Acumatica.

Publish Reports with Acumatica in SAP Crystal Reports

Use the Report Wizard to design a report based on up-to-date Acumatica ERP.

Import and Visualize Acumatica in Power View

Create data visualizations based on Acumatica ERP in Excel.

Connect to Acumatica as a Linked Server

Use the SQL Gateway and the ODBC Driver to set up a linked server for Acumatica ERP.

Import Acumatica into the Power BI Service for Visualizations

Use CData Connect Cloud to connect to Acumatica and provide access to live Acumatica ERP for custom reports in the Power BI Service.

DataBind Controls to Acumatica in C++Builder

DataBind to Acumatica ERP in C++Builder with standard components and controls.

Automated Acumatica Replication to Teradata

Use CData Sync to Customize and automate Acumatica ERP replication to Teradata.

Use the CData Software ODBC Driver for Acumatica in SAS for Real-Time Reporting and Analytics

Connect to real-time Acumatica ERP in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Acumatica.

Extract, Transform, and Load Acumatica in Informatica PowerCenter

Create a simple Workflow for Acumatica ERP in Informatica PowerCenter.

How to connect to Acumatica from Spring Boot

Connect to Acumatica in a Spring Boot Application using CData JDBC Acumatica Driver

Replicate Acumatica for Use in Salesforce Connect

Replicate Acumatica ERP to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.

Build Acumatica-Connected Apps in Bubble

Use CData Connect Cloud to create an OData feed for Acumatica and create custom apps in Bubble.

How to Build Dynamic React Apps with Acumatica

Use the CData Connect and React to Build Dynamic Web Apps with Live Acumatica .

Connect to Acumatica from a Connection Pool in Jetty

The Acumatica JDBC Driver supports connection pooling: This article shows how to connect faster to Acumatica ERP from Web apps in Jetty.

Viewing Acumatica in RAD Studio Data Explorer

How to view Acumatica ERP in RAD Studio Data Explorer using the CData ODBC Driver for Acumatica.

Analyze Live Acumatica in SAS Viya

Use CData Connect Cloud to connect to Acumatica ERP from SAS Viya and deploy self-service analytics using live Acumatica ERP.

Access Live Acumatica in TIBCO Data Virtualization

Use the CData Software TIBCO DV Adapter for Acumatica to create a Acumatica ERP source in TIBCO Data Virtualization Studio and gain access to live Acumatica ERP from your TDV Server.

Automate Acumatica Replication to Couchbase

Use CData Sync to Customize and automate Acumatica ERP replication to Couchbase.

A PostgreSQL Interface for Acumatica

Use the SQL Gateway and Acumatica ODBC Driver to create a PostgreSQL entry-point for data access.

Connect to Acumatica from PowerBuilder

This article demonstrates how to use the CData ODBC Driver for Acumatica to connect to Acumatica ERP and execute queries in PowerBuilder.

Build MVC Applications with Connectivity to Acumatica

This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Acumatica from an ASP.NET MVC application.

Automate Acumatica Integration Tasks from PowerShell

Access Acumatica from MySQL in HeidiSQL

Use CData ODBC Driver and SQL Gateway to connect and query live Acumatica ERP from HeidiSQL.

Analyze Acumatica in SAP Analytics Cloud

Use CData Connect Cloud to create an OData API on top of Acumatica ERP and visualize Acumatica ERP in SAP Analytics Cloud.

Connect to Acumatica in NetBeans

Connect to Acumatica ERP in NetBeans with the data source configuration wizard.

How to Work with Acumatica in AWS Glue Jobs Using JDBC

Connect to Acumatica from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.

Use CData Connect Cloud to Access Acumatica in Microsoft Power Pivot

Use CData Connect Cloud to connect to live Acumatica ERP in the Power Pivot business intelligence tool.

Enable the Acumatica JDBC Driver in KNIME

Use standard data access components in KNIME to create charts and reports with Acumatica ERP.

Connect to Acumatica from a Connection Pool in WebLogic

Use the CData JDBC Driver for Acumatica to connect to Acumatica ERP from Web applications running on WebLogic.

Create an SAP BusinessObjects Universe on the CData JDBC Driver for Acumatica

Provide connectivity to Acumatica ERP through an SAP BusinessObjects universe.

Working with Acumatica in LINQPad

Execute LINQ queries to Acumatica ERP in LINQPad.

Access Live Acumatica in Excel 365 Online (Excel for the web)

Connect to Acumatica ERP from Excel 365 Online (Excel for the web) with CData Connect Cloud.

Connect to Acumatica through External Services in Salesforce

How to Connect the Power BI Service to Acumatica: Complete Guide

Connect to the CData Software Power BI Connectors from PowerBI.com to provide real-time datasets across the organization.

How to Query Acumatica in MySQL Workbench

Execute MySQL queries against live Acumatica ERP from MySQL Workbench.

Automated Continuous Acumatica Replication to Oracle

Use CData Sync for automated, continuous, customizable Acumatica replication to Oracle.

PowerShell Scripting to Replicate Acumatica to MySQL

Write a simple PowerShell script to replicate Acumatica ERP to a MySQL database.

Connect to Acumatica as a SQL Server Linked Server

Use CData Connect Cloud to create a linked server for live Acumatica ERP.

Automated Continuous Acumatica Replication to Google BigQuery

Use CData Sync for automated, continuous, customizable Acumatica replication to Google BigQuery.

Query Acumatica in DataGrip

Create a Data Source for Acumatica in DataGrip and use SQL to query live Acumatica ERP.

How to connect PolyBase to Acumatica

Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Acumatica ERP.

Add Acumatica to Informatica Enterprise Data Catalog

Use the CData Software JDBC Driver for Acumatica with the Informatica Enterprise Data Catalog to classify and organize data.

Create Informatica Mappings From/To an ODBC Data Source for Acumatica

Create an ODBC connection to Acumatica in Informatica and browse and transfer Acumatica ERP.

Visualize Acumatica in TIBCO Spotfire through ODBC

The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load Acumatica ERP into TIBCO Spotfire.

Create Reports from Acumatica in Looker Studio

Use CData Connect Cloud to gain access to live Acumatica ERP and create custom reports in Looker Studio.

Connect to Acumatica in Google Apps Script

Use CData Connect Cloud to access Acumatica ERP in Google Apps Script.

Analyze Acumatica in Infragistics Reveal

Use CData Connect Cloud to create on OData API on top of Acumatica ERP and visualize live Acumatica ERP in Infragistics Reveal.

Create Datasets from Acumatica in Domo Workbench and Build Visualizations of Acumatica in Domo

Use the CData Software ODBC Driver for Acumatica to create datasets from Acumatica ERP in Domo Workbench and then build visualizations in the Domo service.

Visualize Acumatica from Tableau

Use the Tableau Desktop business intelligence tool to connect to Acumatica ERP.

Connect to Acumatica from AWS Glue

Use CData Connect Cloud to gain access to live Acumatica ERP from your AWS Glue jobs.

Use the CData SSIS Components to Insert New or Update Existing Acumatica Records from SQL Server

Analyze Acumatica in R

Create data visualizations and use high-performance statistical functions to analyze Acumatica ERP in Microsoft R Open.

Back Up Acumatica ERP to SQL Server through SSIS

Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Acumatica. In this article, we will employ an SSIS workflow to populate a database with Acumatica ERP data.

Perform Batch Operations with Acumatica in Apache NiFi

Connect to Acumatica ERP and perform batch operations in Apache NiFi using the CData Software JDBC Driver.

Automated Continuous Acumatica Replication to Databricks

Use CData Sync for automated, continuous, customizable Acumatica replication to Databricks.

Create Acumatica Dataflows on PowerBI.com

Connect to the CData Power BI Connectors from PowerBI.com to create Power BI Dataflows with real-time data.

Create a Data Access Object for Acumatica using JDBI

A brief overview of creating a SQL Object API for Acumatica ERP in JDBI.

Access Acumatica from MySQL in PHP

Connect to Acumatica through the standard MySQL libraries in PHP.

Integrating Acumatica in Talend Cloud Data Management Platform

Connect Acumatica with Talend Cloud Data Management Platform using the [product_name].

Automated Continuous Acumatica Replication to Azure SQL

Use CData Sync for automated, continuous, customizable Acumatica replication to Azure SQL.

How to Import Acumatica into SQL Server using SSIS

Easily back up Acumatica ERP to SQL Server using the SSIS components for Acumatica.

Create Acumatica-Connected Business Apps in AppSheet

Connect to Acumatica via CData Connect Cloud in Google AppSheet and create custom business applications with real-time access to Acumatica ERP.

Acumatica Reporting and Star Schemas in OBIEE

Create a star schema that shows perspectives on Acumatica facts in real time.

Integrate Acumatica with External Services using SnapLogic

Use CData JDBC drivers in SnapLogic to integrate Acumatica with External Services.

Analyze Acumatica in Looker

Use CData Connect Cloud to connect to Acumatica from Looker and build custom apps using live Acumatica ERP.

Automated Continuous Acumatica Replication to SQL Server

Use CData Sync for automated, continuous, customizable Acumatica replication to SQL Server.

Connect to Acumatica in Google Apps Script

Use the ODBC Driver for Acumatica and the SQL Gateway to access Acumatica ERP from Google Apps Script.

Query Acumatica in MySQL Workbench

Create a virtual MySQL database for Acumatica ERP in CData Software Connect (or Connect Server) and work with live Acumatica ERP in MySQL Workbench.

Build Acumatica-Connected Dashboards Using Zoho Analytics

Use CData Connect Cloud to connect to Acumatica from Zoho Analytics and import live Acumatica ERP.

Visualize Live Acumatica of Power BI Report Builder in Power BI Service

Use CData Power BI Connectors to connect to live Acumatica ERP using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.

Automate Acumatica Replication to Azure Data Lake

Use CData Sync to customize and automate Acumatica ERP replication to Azure Data Lake.

Connect to Acumatica in JRuby

Create a simple JRuby app with access to live Acumatica ERP.

Build Semantic Layer Views for Acumatica in APOS Live Data Gateway

Use the CData Connector for Acumatica in APOS Live Data Gateway to build Semantic Layer Views for Acumatica ERP.

Export Data from SQL Server to Acumatica through SSIS

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

Connect to Acumatica in SpagoBI

Create reports featuring live Acumatica ERP in SpagoBI Studio. Host Acumatica reports on SpagoBI Server.

Import Acumatica into FileMaker Pro

Create reports that integrate Acumatica ERP in Filemaker Pro.

Query Acumatica as a SQL Server Database in Node.js

Execute SQL Server queries against Acumatica ERP from Node.js.

Connect to and Visualize Live Acumatica in Tableau Prep

Use CData Tableau Connectors and Tableau Prep Builder to visualize live Acumatica ERP.

Validate Acumatica with QuerySurge

Access and validate Acumatica ERP in QuerySurge using the CData JDBC Driver.

Integrate Acumatica into Power Automate Desktop using CData Connect

CData Connect for Acumatica enables you to integrate Acumatica ERP into workflows built using Microsoft Power Automate Desktop.

Visualize Acumatica in Sisense

Create an ElastiCube in Sisense app with access to Acumatica ERP.

Integrate Acumatica in Your Informatica Cloud Instance

Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Acumatica ERP from Informatica Cloud.

How to Use a Microsoft Access Database to Update Acumatica in Real Time

Update Acumatica data by creating a linked table in Microsoft Access with the CData Acumatica ODBC Driver.

Explore Geographical Relationships in Acumatica with Power Map

Create data visualizations with Acumatica ERP in Power Map.

Automated Continuous Acumatica Replication to AlloyDB

Use CData Sync for automated, continuous, customizable Acumatica replication to AlloyDB.

Replicate Acumatica to Multiple Databases

Replicate Acumatica ERP to disparate databases with a point-and-click configuration.

Build a Simple VCL Application for Acumatica

How to build a simple VCL Application to view Acumatica ERP in RAD Studio using the CData ODBC Driver for Acumatica.

How to connect to Acumatica from IntelliJ

Integrate connectivity to Acumatica ERP with wizards in IntelliJ.

Create Acumatica Dashboards in Bold BI

Use CData Software Connect Server to create a virtual SQL Server Database for Acumatica ERP to build custom dashboards in Bold BI.

Query Acumatica in ColdFusion

Write standard ColdFusion data access code to connect to Acumatica ERP.

Automated Continuous Acumatica Replication to Apache Cassandra

Use CData Sync for automated, continuous, customizable Acumatica replication to Apache Cassandra.

Build Acumatica-Connected Visualizations in datapine

Use CData Connect Cloud and datapine to build visualizations and dashboards with access to live Acumatica ERP.

Integrate with Acumatica in JReport Designer

Create charts and reports based on Acumatica ERP in JReport Designer.

Create Apps from Acumatica in Qlik Sense Cloud

Use CData Connect Cloud to connect to Acumatica and build apps from live Acumatica ERP in Qlik Sense Cloud.

ETL Acumatica in Oracle Data Integrator

This article shows how to transfer Acumatica ERP into a data warehouse using Oracle Data Integrator.

How to use SQLAlchemy ORM to access Acumatica in Python

Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Acumatica ERP.

How to update Acumatica from Excel

This article explains how to transfer data from Excel to Acumatica using the Excel Add-In for Acumatica.

Natively Connect to Acumatica in PHP

Create PHP applications on Linux/UNIX machines with connectivity to Acumatica ERP. Leverage the native support for ODBC in PHP.

Replicate Multiple Acumatica Accounts

Replicate multiple Acumatica accounts to one or many databases.

Connect to Acumatica in Ruby

Connect to Acumatica ERP in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.

Connect to Acumatica from PowerBuilder

This article demonstrates how to access Acumatica ERP from Appeon PowerBuilder using the CData ADO.NET Provider for Acumatica.

Connect to Acumatica as an External Data Source using PolyBase

Use CData Connect Cloud and PolyBase to create an external data source in SQL Swerver with access to live Acumatica ERP.

Provide OData Services of Acumatica from a WCF Application

In this article, we will demonstrate the process of generating an OData feed for Acumatica ERP by developing a WCF Service Application.

Automated Continuous Acumatica Replication to Google Cloud SQL

Use CData Sync for automated, continuous, customizable Acumatica replication to Google Cloud SQL.

Use the CData Software ODBC Driver for Acumatica in MicroStrategy

Connect to Acumatica ERP in MicroStrategy Developer using the CData Software ODBC Driver for Acumatica.

Automated Continuous Acumatica Replication to Amazon Redshift

Use CData Sync for automated, continuous, customizable Acumatica replication to Amazon Redshift.

Connect to Acumatica from HeidiSQL

Use CData Connect Cloud to connect to and query live Acumatica ERP from HeidiSQL.

Integrate with Acumatica using Apache Camel2

Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Acumatica ERP to a JSON file on disk.

Visualize Live Acumatica in the Power BI Service

Use CData Connect Cloud to connect to live Acumatica ERP and create custom reports in the Power BI Service through the On-Premises Gateway.

How to pipe Acumatica to CSV in PowerShell

Use standard PowerShell cmdlets to access Acumatica tables.

Query, Visualize, and Share live Acumatica in Redash

Use CData Connect Cloud to connect to live Acumatica ERP in Redash for querying, visualizing, and sharing.

Integrate with Live Acumatica in MuleSoft (via CData Connect Cloud)

Use CData Connect Cloud to connect to Acumatica from the MuleSoft Anypoint Platform to integrate live Acumatica ERP into custom reports and dashboards.

Integrate with Acumatica in SnapLogic

Use CData Connect Cloud to connect to and integrate with live Acumatica ERP in SnapLogic.

Replicate Acumatica from PowerShell

Write a quick PowerShell script to query Acumatica ERP. Use connectivity to the live data to replicate Acumatica ERP to SQL Server.

How to Access Live Acumatica in Power Automate Desktop via ODBC

The CData ODBC Driver for Acumatica enables you to integrate Acumatica ERP into workflows built using Microsoft Power Automate Desktop.

Use the CData Software JDBC Driver for Acumatica in MicroStrategy Desktop

Connect to Acumatica ERP in MicroStrategy Desktop using the CData Software JDBC Driver for Acumatica.

Model Acumatica Using Azure Analysis Services

Leverage CData Connect Cloud to establish a connection between Azure Analysis Services and Acumatica, enabling the direct import of real-time Acumatica ERP.

Automated Continuous Acumatica Replication to SingleStore

Use CData Sync for automated, continuous, customizable Acumatica replication to SingleStore.

Build Acumatica-Connected ETL Processes in Google Data Fusion

Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Acumatica ERP.

Visualize Acumatica in Tableau

The CData ODBC driver for Acumatica enables you integrate Acumatica ERP into Tableau dashboards.

Author and Share Power BI Reports on Real-Time Acumatica

Use the CData ODBC Driver for Acumatica to visualize Acumatica ERP in Power BI Desktop and then upload to the Power BI service.

View Reports on Real-Time Acumatica in Power BI Report Server

Use the CData ODBC Driver for Acumatica to visualize Acumatica ERP in Power BI Desktop and then publish them to Power BI Report Server.

A PostgreSQL Interface for Acumatica

Use the Remoting features of the Acumatica ODBC Driver to create a PostgreSQL entry-point for data access.

How to Visualize Acumatica Data in Python with pandas

Use pandas and other modules to analyze and visualize live Acumatica ERP in Python.

Connect to Acumatica in CloverDX (formerly CloverETL)

Transfer Acumatica ERP using the visual workflow in the CloverDX data integration tool.

Build Dashboards with Acumatica in DBxtra

Create dynamic dashboards and perform analytics based on Acumatica ERP in DBxtra.

LINQ to Acumatica

Analyze Acumatica with Power Pivot

Automate Acumatica Replication to Azure Synapse

Use CData Sync to customize and automate Acumatica ERP replication to Azure Synapse.

Connect to Live Acumatica in PostGresSQL Interface through CData Connect Cloud

Create a live connection to Acumatica in CData Connect Cloud and connect to your Acumatica ERP from PostgreSQL.

DataBind Controls to Acumatica in Delphi

DataBind to Acumatica ERP in Delphi with standard data access components and controls.

Publish Crystal Reports on Acumatica

Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Acumatica ERP.

How to publish and share Acumatica dashboards with Tableau Server

The CData ODBC driver for Acumatica enables you integrate Acumatica ERP into Tableau dashboards.

Use the CData ODBC Driver for Acumatica in SAS JMP

Manage Acumatica in DBArtisan as a JDBC Source

Use wizards in DBArtisan to create a JDBC data source for Acumatica.

Automated Continuous Acumatica Replication to PostgreSQL

Use CData Sync for automated, continuous, customizable Acumatica replication to PostgreSQL.

Connect to Acumatica in Aqua Data Studio

Access Acumatica ERP from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.

Creating Acumatica-Connected Applications in Unqork

You can use CData Connect Cloud to feed Acumatica ERP to Unqork and build custom business apps.

Build Dashboards with Acumatica in Dundas BI

Create dynamic dashboards and perform analytics based on Acumatica ERP in Dundas BI.

How to Build an ETL App for Acumatica in Python with CData

Create ETL applications and real-time data pipelines for Acumatica ERP in Python with petl.

Process & Analyze Acumatica in Databricks (AWS)

Use CData, AWS, and Databricks to perform data engineering and data science on live Acumatica .

Build Acumatica-Connected Apps in Choreo

Use CData Connect Cloud to connect to Acumatica from Choreo and build custom apps using live Acumatica ERP.

How to integrate Metabase with Acumatica

Use CData Connect Cloud to connect to live Acumatica ERP and create an interactive dashboard in Metabase from Acumatica ERP.

How to create Acumatica federated tables in MySQL

Use the SQL Gateway and the ODBC Driver to set up federated tables for Acumatica ERP in MySQL .

Access Live Acumatica in Google Sheets

Use CData Connect Cloud to gain access to live Acumatica ERP from your Google Sheets.

How to connect to Acumatica in DBVisualizer

Integrate Acumatica ERP with visual data analysis tools and data connection wizards in DBVisualizer

Prepare, Blend, and Analyze Acumatica in Alteryx Designer

Build workflows to access live Acumatica ERP for self-service data analytics.

Visualize Acumatica in Tableau Desktop (through CData Connect)

Create a virtual SQL Server database for Acumatica ERP in CData Software Connect (or Connect Server) and build visualizations from live Acumatica ERP in Tableau Desktop.

Automated Continuous Acumatica Replication to Apache Kafka

Use CData Sync for automated, continuous, customizable Acumatica replication to Apache Kafka.

Establish a Live Connection with Acumatica using Tableau Bridge

The CData ODBC Driver for Acumatica enables you to integrate live Acumatica ERP into Tableau Cloud dashboards using the Tableau Bridge.

Replicate Acumatica to Multiple Databases

Replicate Acumatica ERP to disparate databases with a single configuration.

Integrate Acumatica in the Pentaho Report Designer

Publish reports based on Acumatica ERP in the Pentaho BI tool.

Create Data Visualizations in Cognos BI with Acumatica

Access Acumatica ERP as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.

Use JayDeBeApi to access Acumatica in Python

Use standard Python scripting and the development environment of your choice to access live Acumatica ERP.

Stream Acumatica into Apache Kafka Topics

Access and stream Acumatica ERP in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.

Analyze Acumatica in R

Use standard R functions and the development environment of your choice to analyze Acumatica ERP with the CData JDBC Driver for Acumatica.

Connect to Acumatica from a Connection Pool in JBoss

Integrate Acumatica ERP into Java servlets: Use the Management Console in JBoss to install the Acumatica JDBC Driver.

Connect to Acumatica in RazorSQL

Connect to Acumatica from wizards and query Acumatica ERP from the GUI in the RazorSQL database management tool.

Access Live Acumatica in AWS Lambda (with IntelliJ IDEA)

Connect to live Acumatica ERP in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.

Using the CData Software ODBC Driver for Acumatica in PyCharm

Connect to Acumatica as an ODBC data source in PyCharm using the CData Software ODBC Driver for Acumatica.

How to work with Acumatica in Apache Spark using SQL

Access and process Acumatica in Apache Spark using the CData Software JDBC Driver.

How to Connect to & Open Acumatica in Microsoft Excel

This article uses the CData ODBC driver for Acumatica to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.

Rapidly Develop Acumatica-Driven Apps with Active Query Builder

Leverage the Active Query Builder SQL interface builder and the ease of .NET data access to create data-driven WinForms and ASP.NET apps.

DataBind Acumatica to the DevExpress Data Grid

Use the CData Software ADO.NET Provider for Acumatica with the DevExpress Windows Forms and Web controls to provide Acumatica ERP to a chart.

Deploy the ADO.NET Provider for Acumatica on an SSRS Report Server

Connect to Acumatica ERP from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.

Connect to Acumatica from Crystal Reports

Use CData Connect Cloud to connect to and report on live Acumatica ERP from Crystal Reports.

Design BIRT Reports on Acumatica

Provide current Acumatica ERP to your embedded analytics.

Build Pipelines with Live Acumatica in Google Cloud Data Fusion (via CData Connect Cloud)

Use CData Connect Cloud to connect to Acumatica from Google Cloud Data Fusion, enabling the integration of live Acumatica ERP into the building and management of effective data pipelines.