CData Software - Knowledge Base
Recent Articles
-
Model SharePoint Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and SharePoint, enabling the direct import of real-time Microsoft SharePoint.
-
Integrating Claude Code with Epicor Kinetic via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Epicor Kinetic within assisted coding and automated development workflows.
-
How to Connect Flowise AI Agents to Live LinkedIn Ads 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.
-
Automate Instagram Replication to SAP HANA
Use CData Sync to customize and automate Instagram replication to SAP HANA.
-
Working with Dynamics CRM in LINQPad
Execute LINQ queries to Microsoft Dynamics CRM in LINQPad.
-
Use the CData Software ODBC Driver for Databricks in SAS for Real-Time Reporting and Analytics
Connect to real-time Databricks in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Databricks.
-
Query Amazon S3 in ColdFusion
Write standard ColdFusion data access code to connect to Amazon S3.
-
How to integrate REST with Apache Airflow
Access and process REST in Apache Airflow using the CData JDBC Driver.
-
Query Drip using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Drip entities in PHP by modeling them as objects.
-
Integrating Boomi Agentstudio with Reckon Accounts Hosted via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Reckon Accounts Hosted, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Replicate Multiple Pinterest Accounts via the CData Sync CLI
Replicate multiple Pinterest accounts to one or many databases.
-
Analyze BambooHR with Power Pivot
This article walks you through the process of using the CData ODBC Driver for BambooHR from Power Pivot. You will use the Table Import Wizard to load BambooHR. You can visually build the import query or use any SQL supported by the driver.
-
Connect to Live Sage Cloud Accounting in MicroStrategy through CData Connect AI
Create a live connection to Sage Cloud Accounting in CData Connect AI and connect to your Sage Business Cloud Accounting from MicroStrategy.
-
How to Connect DBeaver to Google Drive via a JDBC Driver
Manage Google Drive with visual tools in DBeaver like the query browser.
-
DataBind Charts to Avro
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Apache Avro from controls in the Visual Studio toolbox. This article demonstrates a graphical approach using wizards in Visual Studio, as well as how to databind with only a few lines of code.
-
Use the CData Software JDBC Driver for Zoom in MicroStrategy
Connect to Zoom in MicroStrategy Developer using the CData Software JDBC Driver for Zoom.
-
Access Live Certinia in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Certinia into the statistical analysis tools available in SAS JMP. This article shows how to use Certinia in the Graph Builder and Query Builder.
-
Use the CData Software ODBC Driver for Oracle Eloqua in SAS for Real-Time Reporting and Analytics
Connect to real-time Oracle Eloqua in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Oracle Eloqua.
-
Access Dynamics NAV from MySQL in PHP
Connect to Dynamics NAV through the standard MySQL libraries in PHP.
-
A PostgreSQL Interface for Lakebase (MySQL Remoting via JDBC)
Use the Remoting features of the Lakebase JDBC Driver to create a PostgreSQL entry-point for data access.
-
Replicate SAP Netweaver Gateway to Multiple Databases via the CData Sync CLI
Replicate SAP Netweaver Gateway to disparate databases with a single configuration.
-
Connect NetSuite to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your NetSuite CRM & ERP using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
How to Query Live Trello in Claude Desktop
Connect to and query live Trello in Claude Desktop using the CData MCP Server.
-
Build Agents in Relevance AI with Access to Live Azure Data Lake Storage via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Azure Data Lake Storage within intelligent agent workflows.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed Eventbrite to Power BI dashboards. Simply drag and drop Eventbrite into data visuals on the Power BI canvas.
-
Build QuickBooks Time-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live QuickBooks Time and build QuickBooks Time-connected web apps with Axios.
-
How to create SQL Server federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Microsoft SQL Server in MySQL .
-
How to Query Live EnterpriseDB Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live EnterpriseDB data in natural language using Python.
-
Use the CData Software JDBC Driver for Twitter in MicroStrategy Desktop
Connect to Twitter in MicroStrategy Desktop using the CData Software JDBC Driver for Twitter.
-
Integrate Salesloft with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Salesloft with External Services.
-
Use the CData Software ODBC Driver for JotForm in MicroStrategy Web
Connect to JotForm in MicroStrategy Web using the CData Software ODBC Driver for JotForm.
-
Connect to Dynamics NAV in SpagoBI
Create reports featuring live Microsoft Dynamics NAV in SpagoBI Studio. Host Dynamics NAV reports on SpagoBI Server.
-
Automate SAP Netweaver Gateway Replication to SAP HANA
Use CData Sync to customize and automate SAP Netweaver Gateway replication to SAP HANA.
-
Connect to Cloudant in Google Apps Script via SQL Gateway
Use the ODBC Driver for Cloudant and the SQL Gateway to access IBM Cloudant from Google Apps Script.
-
Migrating data from SharePoint to Snowflake using CData SSIS Components.
Easily push Microsoft SharePoint to Snowflake using the CData SSIS Tasks for SharePoint and Snowflake.
-
Use Azure AI Foundry to Talk to Your Spark via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Azure AI Foundry agents to securely answer questions and take actions on your Apache Spark SQL for you.
-
Migrating data from Basecamp to Google BigQuery using CData SSIS Components.
Easily push Basecamp to Google BigQuery using the CData SSIS Tasks for Basecamp and Google BigQuery.
-
Create Apps from Google Campaign Manager 360 in Qlik Sense Cloud
Use CData Connect AI to connect to Google Campaign Manager 360 and build apps from live Google Campaign Manager 360 in Qlik Sense Cloud.
-
Deploy the ADO.NET Provider for Google Ads on an SSRS Report Server
Connect to Google Ads from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.
-
Explore Geographical Relationships in Jira with Power Map
Create data visualizations with Atlassian Jira in Power Map.
-
Creating Cosmos DB-Connected Applications in Unqork
You can use CData Connect AI to feed Azure Cosmos DB to Unqork and build custom business apps.
-
Automated Continuous Facebook Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Facebook replication to Amazon Redshift.
-
How to connect SharePoint with Elasticsearch through external lists
Provide Elasticsearch to SharePoint users as an external list.
-
Connecting Mastra with Instagram via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to enable Mastra agents to securely query, read, and act on real-time data across 300+ enterprise sources no replication required.
-
Create Elasticsearch-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Elasticsearch from OutSystems and build custom enterprise apps using live Elasticsearch.
-
Analyze Twilio in Infragistics Reveal
Use the CData API Server to create an OData API on top of Twilio and visualize live Twilio in Infragistics Reveal.
-
Query SuiteCRM in ColdFusion
Write standard ColdFusion data access code to connect to SuiteCRM.
-
Visualize GitHub in TIBCO Spotfire through OData
Integrate GitHub into dashboards in TIBCO Spotfire.
-
Edit and Search Active Directory External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of Active Directory to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create Active Directory objects that you can access from apps and the dashboard.
-
Create SAP Ariba Source-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to SAP Ariba Source from Klipfolio and build custom visualizations using live SAP Ariba Source.
-
Connect to Avalara AvaTax in Google Apps Script via SQL Gateway
Use the ODBC Driver for Avalara AvaTax and the SQL Gateway to access Avalara AvaTax from Google Apps Script.
-
Automate Instagram Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live Instagram and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
Connect to SingleStore in DBArtisan
Use wizards in DBArtisan to configure SingleStore as a data source.
-
Provide OData Services of Quickbase from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Quickbase by developing a WCF Service Application.
-
Build a Simple VCL Application for Oracle Service Cloud
How to build a simple VCL Application to view Oracle Service Cloud in RAD Studio using the CData ODBC Driver for Oracle Service Cloud.
-
Connect to CockroachDB as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for CockroachDB.
-
Create Data Visualizations in Cognos BI with Salesforce Data
This article describes how to use the CData ODBC Driver for Salesforce in Cognos BI.
-
Analyze Live Zoho Projects in SAS Viya
Use CData Connect AI to connect to Zoho Projects from SAS Viya and deploy self-service analytics using live Zoho Projects.
-
Connect to Todoist from a Connection Pool in Jetty
The Todoist JDBC Driver supports connection pooling: This article shows how to connect faster to Todoist from Web apps in Jetty.
-
DataBind Controls to Cassandra in C++Builder
DataBind to Apache Cassandra in C++Builder with standard components and controls.
-
Integrate Live GitHub into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to GitHub and integrate live GitHub into apps built in Microsoft Power Apps.
-
Stream Unbounce into Apache Kafka Topics
Access and stream Unbounce in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
How to Create Power BI Visual Reports with Real-Time Zoho Books
Use CData Power BI Connectors to visualize Zoho Books in Power BI.
-
How to Build an ETL App for Cassandra in Python with CData
Create ETL applications and real-time data pipelines for Apache Cassandra in Python with petl.
-
How to Connect Flowise AI Agents to Live Odoo 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.
-
Build a PostgreSQL Interface for Oracle Sales using the CData JDBC Driver
Use the Remoting features of the Oracle Sales JDBC Driver to create a PostgreSQL entry-point for data access.
-
Integrating Dataiku with HubSpot via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live HubSpot.
-
Access Live SAP HANA in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live SAP HANA from your Google Sheets.
-
Connect to LinkedIn in the Denodo Platform
Use CData driver technologies to create a virtual data source for LinkedIn in the Denodo Virtual DataPort Administrator.
-
ETL eBay Analytics in Oracle Data Integrator
This article shows how to transfer eBay Analytics into a data warehouse using Oracle Data Integrator.
-
Connect to Adobe Commerce from PowerBuilder via ADO.NET
This article demonstrates how to access Adobe Commerce from Appeon PowerBuilder using the CData ADO.NET Provider for Adobe Commerce.
-
Excel Spreadsheet Automation on Parquet with the QUERY Formula
Pull data, automate spreadsheets, and more with the QUERY formula.
-
Consume Highrise OData Feeds in PowerBuilder
This article demonstrates how to consume Highrise CRM as OData feeds from PowerBuilder using the API Server.
-
Use the CData Software JDBC Driver for MYOB AccountRight in MicroStrategy Desktop
Connect to MYOB AccountRight in MicroStrategy Desktop using the CData Software JDBC Driver for MYOB AccountRight.
-
Build Dashboards with Todoist in DBxtra
Create dynamic dashboards and perform analytics based on Todoist in DBxtra.
-
Connect to JSON Services Using the Script Function in Claris FileMaker Pro
-