CData Drivers for Exact Online v19.0.7156 (05 Aug 2019) All platforms
Exact Online ODBC Driver
Read, Write, and Update Exact Online through ODBC
Easily connect live Exact Online data with BI, ETL, Reporting, & Custom Apps.
Exact Online JDBC Driver
Read, Write, and Update Exact Online through JDBC
Easily connect live Exact Online data with Java-based BI, ETL, Reporting, & Custom Apps.
Exact Online ADO.NET Provider
Read, Write, and Update Exact Online from .NET Apps.
Easily connect Exact Online with BI, ETL, Reporting, and Custom Apps.
Extend SQL Server With Unrivaled Data Connectivity!
Exact Online SSIS Components Included in Enterprise SSIS Subscriptions
Get the Exact Online 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.
Exact Online BizTalk Adapter
Enterprise BizTalk Adapters for Exact Online
Powerful BizTalk Adapters that allow you to easily connect BizTalk Server with live Exact Online data through standard orchestrations. Use the Exact Online Adapters to synchronize with Exact Online Accounts, Divisions, Opportunities, etc. Perfect for data synchronization, local back-ups, workflow automation, and more!
- Similar to the BizTalk Adapter for SQL Server but for Exact Online entities: Accounts, Divisions, Opportunities, etc.
- Supports meta-data discovery and schema generation for Exact Online entities.
- Includes a Receive Adapter and a two-way Send Adapter with support for updategrams, stored procedures, and queries.
Exact Online Connector for MuleSoft
SQL-Centric MuleSoft Connectivity to Exact Online
Leverage the power of SQL to simplify integration with Exact Online. Our Exact Online 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 Exact Online data. Similar to the MuleSoft Database Connector, but for Exact Online.
- Powerful SQL Engine with support for dynamic queries, streaming, bulk operations, metadata discovery, query folding, and more.
Excel Add-In for Exact Online
Read, Write, and Update Exact Online from Excel
The Exact Online Excel Add-In is a powerful tool that allows you to connect with live Exact Online data, directly from Microsoft Excel. Use Excel to read, write, and update Accounts, Divisions, Opportunities, etc. Perfect for mass imports / exports / updates, data cleansing & de-duplication, Excel based data analysis, and more!
Exact Online Power BI Connector
Easily connect Microsoft Power BI with live Exact Online data for up-to-date visual analysis and reporting.
- Real-Time Data Access (DirectQuery)
- Full Metadata Discovery
- Robust SQL-92 Support
Exact Online PowerShell Cmdlets
An easy-to-use set of PowerShell Cmdlets offering real-time access to Exact Online 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 Exact Online data.
- Read, write, and update Exact Online Accounts, Divisions, Opportunities, etc. from PowerShell scripts.
- Easily pipe data into and out-of flat-files, databases, and other data stores for archival, back-up, and synchronization.
Exact Online FireDAC Components
Rapidly create and deploy powerful Delphi & C++Builder Apps that integrate with Exact Online account data including Accounts, Divisions, Opportunities, and more!
- Connect to Exact Online from Rad Studio Data Explorer.
- Comprehensive support for CRUD (Create, Read, Update, and Delete) operations.
- Integrate Delphi & C++Builder Apps with Exact Online Accounts, Divisions, Opportunities, and more!
OData APIs for Exact Online
Instantly Expose OData APIs for Exact Online with CData API Server
Connect Exact Online with popular OData clients like Microsoft Power BI, Salesforce Lightning Connect, Microsoft SharePoint, and custom Apps with CData API Server.
- Makes Exact Online 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.
Exact Online Data Pipeline. Replicate to Any Database With A Few Clicks
Automated Replication to popular Databases, Data Lakes, & Data Warehouses
- Straightforward automated data replication.
- Synchronize data with 100+ destinations.
- Easy-to-use ETL/ELT data movement.
This package includes the following components:
Exact Online ADO.NET Provider v19.0.7156
Exact Online BizTalk Adapter v19.0.7156
Exact Online Data Cmdlets v19.0.7156
Exact Online FireDAC Components v19.0.7156
Exact Online JDBC Driver v19.0.7156
Exact Online ODBC Driver v19.0.7156
Exact Online Power BI Connector v19.0.7156
Exact Online SSIS Components v19.0.7156
Excel Add-In for Exact Online v19.0.7156