CData Software - Knowledge Base
Recent Articles
-
How to update SharePoint from Excel
This article explains how to transfer data from Excel to SharePoint using the Excel Add-In for SharePoint.
-
Reckon Accounts Hosted Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Reckon Accounts Hosted through CData Connect AI using different applications and tools.
-
Using the CData Software ODBC Driver for Oracle SCM in PyCharm
Connect to Oracle SCM as an ODBC data source in PyCharm using the CData Software ODBC Driver for Oracle SCM.
-
Access Live SAS Data Sets in AWS Lambda
Connect to live SAS Data Sets in AWS Lambda using the CData JDBC Driver.
-
How to Connect Flowise AI Agents to Live WordPress via CData Connect AI
Integrate Flowise AI with the CData Connect AI MCP Server to enable agents to securely query and act on live data without replication.
-
How to publish and share IBM Informix dashboards with Tableau Server
The CData ODBC driver for IBM Informix enables you integrate IBM Informix into Tableau dashboards.
-
How to Query Live Hive in Claude Desktop
Connect to and query live Hive in Claude Desktop using the CData MCP Server.
-
Integrate JSON Services in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live JSON from Informatica Cloud.
-
Analyze WordPress in R via JDBC
Use standard R functions and the development environment of your choice to analyze WordPress with the CData JDBC Driver for WordPress.
-
Query Google Calendar using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Google Calendar entities in PHP by modeling them as objects.
-
Connect to Smartsheet in DBeaver
Use the CData ODBC Driver to connect to Smartsheet in DBeaver.
-
Build an OLAP Cube in SSAS from Dynamics CRM
Establish a connection to Microsoft Dynamics CRM data from SQL Server Analysis Services, and use the Dynamics CRM Data Provider to build OLAP cubes for use in analytics and reporting.
-
Connecting Moonlit Workflow with Microsoft Exchange via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Moonlit workflows to securely read and act on your Microsoft Exchange in real time.
-
Prepare, Blend, and Analyze Tableau CRM Analytics in Alteryx Designer (ODBC)
Build workflows to access live Tableau CRM Analytics for self-service data analytics.
-
Provide OData Services of eBay from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for eBay by developing a WCF Service Application.
-
Create SSAS Tabular Models from SAP Ariba Source
How to build a SQL Server Analysis Service Tabular Model from SAP Ariba Source using CData drivers.
-
View Reports on Real-Time Redshift in Power BI Report Server
Use the CData ODBC Driver for Redshift to visualize Amazon Redshift in Power BI Desktop and then publish them to Power BI Report Server.
-
Automated Continuous Zoho CRM Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Zoho CRM replication to delimited files (CSV/TSV).
-
DataBind Harvest to the DevExpress Data Grid
Use the CData Software ADO.NET Provider for Harvest with the DevExpress Windows Forms and Web controls to provide Harvest to a chart.
-
Access Live HubSpot in AWS Lambda
Connect to live HubSpot in AWS Lambda using the CData JDBC Driver.
-
Building Dynamic Web Pages with WordPress Using AngularJS
Create single-page applications with live connectivity to WordPress using the CData API Server.
-
Connect to Dynamics CRM as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Microsoft Dynamics CRM.
-
Analyze Workday in R via JDBC
Use standard R functions and the development environment of your choice to analyze Workday with the CData JDBC Driver for Workday.
-
How to Connect DBeaver to Google Contacts via a JDBC Driver
Manage Google Contacts with visual tools in DBeaver like the query browser.
-
Build Visualizations of Smartsheet in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Smartsheet in Birst.
-
Access Live Amazon Athena in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Amazon Athena from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Create Facebook-Connected Nintex Workflows
Use CData Connect AI to connect to Facebook from Nintex Workflow Cloud and build custom workflows using live Facebook.
-
Process & Analyze SQL Server in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live SQL Server .
-
Bidirectional Access to Confluence from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Atlassian Confluence in Filemaker Pro for Mac or Windows.
-
Access Slack from MySQL in Amazon QuickSight
Connect to Slack and build visualizations of Slack using a MySQL Connection in Amazon QuickSight.
-
Use JayDeBeApi to access Gmail in Python
Use standard Python scripting and the development environment of your choice to access live Gmail.
-
Explore Geographical Relationships in Oracle Service Cloud with Power Map
Create data visualizations with Oracle Service Cloud in Power Map.
-
Migrating data from SuiteCRM to Google BigQuery using CData SSIS Components.
Easily push SuiteCRM to Google BigQuery using the CData SSIS Tasks for SuiteCRM and Google BigQuery.
-
Getting Started with the CData ADO.NET Provider for Google Sheets
-