Products

Solutions

Connectors

Support

Company

Resources

Search

Show articles by: Integration Technology | Driver Technology | Recent Articles

CData Software - Knowledge Base

Recent Acumatica Excel Articles

«
1

Excel Spreadsheet Automation with the QUERY Formula

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

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.

Use the CData ODBC Driver for Acumatica from SharePoint Excel Services

This article demonstrates how to use the CData ODBC Driver for Acumatica to connect to Acumatica ERP from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Acumatica ERP in Excel.

Explore Geographical Relationships in Acumatica with Power Map

Create data visualizations with Acumatica ERP in Power Map.

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 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.

Import and Visualize Acumatica in Power View

Create data visualizations based on Acumatica ERP in Excel.

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.

Access Live Acumatica in Excel (Desktop)

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

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.

How to update Acumatica from Excel

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

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.

«
1

CData Software is a leading provider of data access and connectivity solutions. Our standards-based connectors streamline data access and insulate customers from the complexities of integrating with on-premise or cloud databases, SaaS, APIs, NoSQL, and Big Data.

Connect With Us

Get Started

Data Connectors

ETL/ ELT Solutions

Cloud & API Connectivity

OEM & Custom Drivers

Connect With Us

Get Started

Data Visualization

Company

Resources