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
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
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.
If you would like us to get in touch with you, please let us know how we can reach you via this form.
Contact firstname.lastname@example.org if you have any question about Acumatica