CData Drivers for Acumatica
The CData Drivers for Acumatica provide easy access to live Acumatica ERP data from BI, Analytics, Reporting, ETL, and custom applications. Through standard drivers like JDBC, ODBC, & ADO.NET and with direct connectivity to popular applications like Excel, SSIS, PowerShell, Power BI and more, CData Drivers allow for easier access to Acumatica data, all through the ubiquitous query language: SQL.
Install a CData Driver and start writing SQL to get Acumatica data. Easily access Acumatica data from popular data-centric tools, applications, and platforms:
• BI & Analytics
• ETL, Replication & Warehousing
• Data Management
• Workflow & Automation
• Developer Tools & Technologies
• Data Virtualization
Key features
-
Fully compatible with Contract Based REST API, Version 17.200.001
-
Powerful metadata querying enables SQL-like access to non-database sources
-
Push down query optimization pushes SQL operations down to the server whenever possible, increasing performance
-
Client-side query execution engine supports SQL-92 operations that are not available server-side
-
Connect to live Acumatica ERP data, for real-time data access
-
Full support for data aggregation and complex JOINs in SQL queries
-
Secure connectivity through modern cryptography, including TLS 1.2, SHA-256, ECC, etc.
-
Seamless integration with leading BI, reporting, and ETL tools and with custom applications
About CData Software, Inc.
CData Software is a leading provider of data access and connectivity solutions. Our mission is to simplify the way that users and applications connect with data. We specialize in the development of Drivers and data access technologies for real-time access to online or on-premise applications, databases, and Web APIs.
