What is CData Excel Add-Ins?
The CData Excel Add-In is a powerful tool that allows you to connect with live data, directly from Microsoft Excel. Use Excel to read, write, and update live data from web and desktop applications. Perfect for mass imports / exports / updates, data cleansing & de-duplication, Excel based data analysis, and more! Users simply supply their credentials via the connection wizard to create a connection and can immediately begin working with live tables of data. The Excel Add-In is completely self-contained; no additional software installation is required.
*Bi-directional access to live data. *Easy-to-use, straightforward configuration. *Quickly import, export, backup, analyze, report, transform, integrate, etc.
-Easy-To-Use, Straightforward Configuration:
*Install the Add-In *Login with User & Password *Select Tables
Installing any of the Excel Add-Ins creates a new CData data access toolbar in Excel that users can access to connect to remote data. From the Excel toolbar, users can select any of the installed CData Add-Ins to configure a connection.
*List of supported data sources:
- Microsoft Dynamics (CRM, Exchange, NAV, Excel, GP, SharePoint, Project)
- Sage 50UK
- Exact Online
- NEtSuite CRM&ERP
- SAP NetWeaver
- Google (Analytics, Adwords, Sheets, Apps, BigQuery)
- Xero Accounting
- Amazon SimpleDB
- OFX Financial Accounts
- OData Services
- Amazon DynamoDB
- RSS Files
- XML Files
- Oracle Eloqua
- Azure Table
- Zoho CRM
- Office 365
- Microsoft Active Directory
- Youtube Analytics
- PreEmptive Analytics
- QuickBooks (Online,Desktop,Point of Sale)
- LDAP Directory Services
- HPCC ECL Queries
- Microsoft SQL Server
CData Excel Add-Ins Screenshots
CData Excel Add-Ins information