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:
• Aqua Data Studio
• Clover ETL
• Crystal Reports
• Cognos BI
• Crystal Reports
• FileMaker Pro
• Microsoft Access
• IBM WebSphere
• Microsoft Excel
• Oracle DB
• Power Map
• Power Pivot
• NetBeans IDE
• Oracle WebLogic
• SAP Business Objects
• SharePoint Services
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.
Your insights are valuable, be the first to rate this solution.