CData Drivers for Acumatica v19.0.7156 (04 Aug 2019) All platforms
Acumatica ODBC Driver
Read, Write, and Update Acumatica through ODBC
Easily connect live Acumatica ERP data with BI, ETL, Reporting, & Custom Apps.
Acumatica JDBC Driver
Read, Write, and Update Acumatica through JDBC
Easily connect live Acumatica ERP data with Java-based BI, ETL, Reporting, & Custom Apps.
Acumatica ADO.NET Provider
Read, Write, and Update Acumatica from .NET Apps.
Easily connect Acumatica ERP with BI, ETL, Reporting, and Custom Apps.
Extend SQL Server With Unrivaled Data Connectivity!
Acumatica SSIS Components Included in Enterprise & Professional SSIS Subscriptions
Get the Acumatica SSIS Components together with 150+ SSIS Data Flow Components & Tasks! Our Enterprise and Professional SSIS Subscriptions combine an unprecedented collection of Enterprise-class SSIS data flow components, with the leading SSIS Tasks for Communications, Security, and File Transfer, into one easy-to-manage MSDN-style subscription.
- 150+ Enterprise SSIS Data Flow Sources & Destinations
- 30+ SSIS Tasks for Communications, Security, and File Transfer. (SSH, SFTP, Email, etc. )
- One year of free updates, upgrades, new releases, and support.
- Enterprise and Professional Subscriptions.
Acumatica BizTalk Adapter
Enterprise BizTalk Adapters for Acumatica
Powerful BizTalk Adapters that allow you to easily connect BizTalk Server with live Acumatica data through standard orchestrations. Use the Acumatica Adapters to synchronize with Acumatica Accounts, Bills, Customers, Leads, etc. Perfect for data synchronization, local back-ups, workflow automation, and more!
- Similar to the BizTalk Adapter for SQL Server but for Acumatica entities: Accounts, Bills, Customers, Leads, etc.
- Supports meta-data discovery and schema generation for Acumatica entities.
- Includes a Receive Adapter and a two-way Send Adapter with support for updategrams, stored procedures, and queries.
Acumatica Connector for MuleSoft
SQL-Centric MuleSoft Connectivity to Acumatica
Leverage the power of SQL to simplify integration with Acumatica. Our Acumatica Connector for MuleSoft includes a robust SQL engine that simplifies data connectivity and allows users to accomplish complex data manipulation without extensive transformation workflow.
- Write SQL, get Acumatica data. Similar to the MuleSoft Database Connector, but for Acumatica.
- Powerful SQL Engine with support for dynamic queries, streaming, bulk operations, metadata discovery, query folding, and more.
Excel Add-In for Acumatica
Read, Write, and Update Acumatica from Excel
The Acumatica Excel Add-In is a powerful tool that allows you to connect with live Acumatica data, directly from Microsoft Excel. Use Excel to read, write, and update Accounts, Bills, Customers, Leads, etc. Perfect for mass imports / exports / updates, data cleansing & de-duplication, Excel based data analysis, and more!
Acumatica Power BI Connector
Easily connect Microsoft Power BI with live Acumatica ERP data for up-to-date visual analysis and reporting.
- Real-Time Data Access (DirectQuery)
- Full Metadata Discovery
- Robust SQL-92 Support
Acumatica PowerShell Cmdlets
An easy-to-use set of PowerShell Cmdlets offering real-time access to Acumatica data. The Cmdlets allow users to easily read, write, update, and delete live data - just like working with SQL server.
- Easy-to-use Cmdlets with a simple SQL interface to live Acumatica data.
- Read, write, and update Acumatica Accounts, Bills, Customers, Leads, etc. from PowerShell scripts.
- Easily pipe data into and out-of flat-files, databases, and other data stores for archival, back-up, and synchronization.
Acumatica FireDAC Components
Rapidly create and deploy powerful Delphi & C++Builder Apps that integrate with Acumatica account data including Accounts, Bills, Customers, Leads, and more!
- Connect to Acumatica from Rad Studio Data Explorer.
- Comprehensive support for CRUD (Create, Read, Update, and Delete) operations.
- Integrate Delphi & C++Builder Apps with Acumatica Accounts, Bills, Customers, Leads, and more!
OData APIs for Acumatica
Instantly Expose OData APIs for Acumatica with CData API Server
Connect Acumatica with popular OData clients like Microsoft Power BI, Salesforce Lightning Connect, Microsoft SharePoint, and custom Apps with CData API Server.
- Makes Acumatica ERP accessible to Apps, BI tools, and other systems.
- Exposes data through standards-based interfaces like ODATA, SOAP, REST, HTML, RSS, ATOM, JSON, XLS, and CSV.
- Runs anywhere: on-premise, or in the cloud.
Acumatica Data Sync
Replicate Acumatica to on-premise or cloud databases with CData Sync
CData Sync provides a straightforward way to create and maintain a replica of your Acumatica data, making it easily accessible from common database tooling, software drivers, and analytics.
- Create and maintain a replica of your Acumatica data with a wide range of traditional and emerging databases.
- Point-and-click administration with straightforward scheduling of synchronization.
This package includes the following components:
Acumatica ADO.NET Provider v19.0.7156
Acumatica BizTalk Adapter v19.0.7156
Acumatica Data Cmdlets v19.0.7156
Acumatica FireDAC Components v19.0.7156
Acumatica JDBC Driver v19.0.7156
Acumatica ODBC Driver v19.0.7156
Acumatica Power BI Connector v19.0.7156
Acumatica SSIS Components v19.0.7156
Excel Add-In for Acumatica v19.0.7156