CData Software - Knowledge Base
Recent Articles
-
Integrate with GetResponse Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy GetResponse data to a JSON file on disk.
-
Import SAP Business One Data Using Azure Data Factory
Use CData Connect AI to connect to SAP Business One Data from Azure Data Factory and import live SAP Business One data.
-
Stream QuickBooks Online Data into Apache Kafka Topics
Access and stream QuickBooks Online data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Automated Continuous Billsby Replication to Databricks
Use CData Sync for automated, continuous, customizable Billsby replication to Databricks.
-
Automated Azure Data Catalog Data Replication to Teradata
Use CData Sync to Customize and automate Azure Data Catalog data replication to Teradata.
-
How to connect Amazon QuickSight to Oracle HCM Cloud Data
Create a connection to Oracle HCM Cloud data in CData Connect AI and insert Oracle HCM Cloud data into Amazon QuickSight SPICE to build interactive dashboards.
-
Use the CData Software ODBC Driver for Amazon S3 in MicroStrategy Desktop
Connect to Amazon S3 data in MicroStrategy Desktop using the CData Software ODBC Driver for Amazon S3.
-
Build Agents in Relevance AI with Access to Live Microsoft Dataverse Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Microsoft Dataverse data within intelligent agent workflows.
-
How to connect to Mode Data from Spring Boot
Connect to Mode in a Spring Boot Application using the CData API Driver for JDBC
-
Create SAP Concur Dataflows on PowerBI.com
Connect to the CData Power BI Connector for SAP Concur from PowerBI.com to create Power BI Dataflows with real-time data.
-
DataBind ShipStation Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for ShipStation with the DevExpress Windows Forms and Web controls to provide ShipStation data to a chart.
-
Use Grok to Talk to Your Blackbaud FE NXT Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Grok AI to securely answer questions and take actions on your Blackbaud FE NXT data for you.
-
How to Build an ETL App for SharePoint Data in Python with CData Connect AI
Build ETL pipelines that read and write live SharePoint data in Python with petl and the CData Connect AI Python SDK.
-
Validate Optimizely Data with QuerySurge
Access and validate Optimizely data in QuerySurge using the CData JDBC Driver.
-
Connect to SAP Netweaver Gateway Data in ACL Analytics
Connect to SAP Netweaver Gateway data via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to SAP Netweaver Gateway data.
-
Connect to Toggl Data in ACL Analytics
Connect to Toggl data via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Toggl data.
-
Connect to ZohoExpense Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with ZohoExpense Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Automated Continuous Dynamics CRM Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Dynamics CRM replication to Apache Cassandra.
-
How to import Dynamics CRM Data into Apache Solr
Use the CData Software JDBC Driver for Dynamics CRM in Data Import Handler and create an automated import of Dynamics CRM data to Apache Solr Enterprise Search platform.
-
How to Access Pingdom Data Using Entity Framework
This article shows how to access Pingdom data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Query Active Directory Data as a SQL Server Database in Node.js
Execute SQL Server queries against Active Directory data from Node.js.
-
Automate PagerDuty Data Replication to SAP HANA
Use CData Sync to customize and automate PagerDuty data replication to SAP HANA.
-
Visualize Snapchat Ads Data in TIBCO Spotfire through ADO.NET
Integrate Snapchat Ads data into dashboards in TIBCO Spotfire.
-
How to Connect to Live Active Directory Data in n8n Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable n8n to securely read and take actions on your Active Directory data for you.
-
Automated Continuous OnePageCrm Replication to Databricks
Use CData Sync for automated, continuous, customizable OnePageCrm replication to Databricks.
-
Create API-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to API Data from Klipfolio and build custom visualizations using live API data.
-
How to connect to Webflow Data from IntelliJ
Integrate connectivity to Webflow data with wizards in IntelliJ.
-
Import Real-Time Act CRM Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Act CRM data in ColdFusion.
-
Connect to Paylocity Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Paylocity data from Filemaker Pro on Mac.
-
Work with Egnyte Data in FoxPro
Load Egnyte data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Rapidly Develop Impala-Driven Apps with Active Query Builder
Leverage the Active Query Builder SQL interface and .NET data access to create data-driven WinForms and ASP.NET apps backed by Impala.
-
Access Live ShipStation Data in Roo Code via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Roo Code agents to securely access and build applications with live ShipStation data through MCP integration.
-
Connect to SuiteCRM Data from HeidiSQL
Use CData Connect AI to connect to and query live SuiteCRM data from HeidiSQL.
-
Getting Started with the CData Power BI Connector for LinkedIn Ads
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for LinkedIn Ads.
-
Integrate Open WebUI with Live SuiteCRM Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live SuiteCRM data from within the chat interface.
-
Connect to RSS Feeds from PowerBuilder via JDBC
This article demonstrates how to access RSS feeds from PowerBuilder using the RSS JDBC Driver.
-
Getting Started with the CData Python Connector for AgileCRM
Learn to install and license the CData Python Connector and configure a connection to live AgileCRM data.
-
Building Dynamic Web Pages with OData Services Using AngularJS
Create single-page applications with live connectivity to OData using the CData API Server.
-
Consume SAP SuccessFactors OData Feeds in PowerBuilder
This article demonstrates how to consume SAP SuccessFactors data as OData feeds from PowerBuilder using the API Server.
-
Create Clio Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Clio data access from reports, embedded analytics, and more.
-
Connect and Visualize Live Gong Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Gong data into the Databricks platform and create visualization dashboards with real-time Gong data.
-
Build an OLAP Cube in SSAS from Customer.io Data
Establish a connection to Customer.io data data from SQL Server Analysis Services, and use the Customer.io Data Provider to build OLAP cubes for use in analytics and reporting.
-
Connect to MYOB AccountRight Data from a Connection Pool in Jetty
The MYOB AccountRight JDBC Driver supports connection pooling: This article shows how to connect faster to MYOB AccountRight data from Web apps in Jetty.
-
Choosing the Best Method to Connect Foursquare to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Foursquare data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Integrate Live Trello Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf's Cascade agent to securely access and query live Trello data from within the IDE.
-
Model, Search, and Visualize Live Dynamics NAV Data in ThoughtSpot
Use CData Connect AI to connect to live Dynamics NAV data for modeling, searching, and visualizing.
-
Connect to Microsoft Exchange Data as an External Data Source using PolyBase
Use CData Connect AI and PolyBase to create an external data source in SQL Swerver with access to live Microsoft Exchange data.
-
Connect to Sugar CRM Data in CloverDX (formerly CloverETL)
Transfer Sugar CRM data using the visual workflow in the CloverDX data integration tool.
-
Natively Connect to Stripe Data in PHP
The CData ODBC driver for Stripe enables you to create PHP applications with connectivity to Stripe data. Leverage the native support for ODBC in PHP.
-
Automated Continuous Elorus Replication to SQL Server
Use CData Sync for automated, continuous, customizable Elorus replication to SQL Server.
-
Use the CData ODBC Driver for SAP BusinessObjects BI from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for SAP BusinessObjects BI to connect to SAP BusinessObjects BI data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring SAP BusinessObjects BI data in Excel.
-
How to publish and share Gong Data dashboards with Tableau Server
The CData ODBC driver for Gong enables you integrate Gong data into Tableau dashboards.
-
Operational Reporting on Google Translate Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Google Translate data.
-
Build a PostgreSQL Interface for Gorgias Data using the CData JDBC Driver
Use the Remoting features of the Gorgias JDBC Driver to create a PostgreSQL entry-point for data access.
-
Integrating GitHub Copilot with Zoom data via CData CLI
CData CLI gives AI coding agents direct, command-line-native access to CData Drivers across hundreds of data sources, allowing agents to manage licenses, configure connections, run SQL queries, and explore schema metadata, all without leaving the terminal.
-
How to Connect to Live GitHub Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live GitHub data securely in real time.
-
Integrate Devin with Live Cloudflare Data Using CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Devin, the AI software engineer, to securely access and query live Cloudflare data.
-
Use ChatGPT to Talk to Your HBase Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable ChatGPT to securely answer questions and take actions on your HBase data for you.
-
Integrating GitHub Copilot with Dynamics 365 data via CData CLI
CData CLI gives AI coding agents direct, command-line-native access to CData Drivers across hundreds of data sources, allowing agents to manage licenses, configure connections, run SQL queries, and explore schema metadata, all without leaving the terminal.
-
Integrate LibreChat with Live Klaviyo Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Klaviyo data from within the chat interface.
-
Establish a Live Connection with Samanage Data using Tableau Bridge
The CData ODBC Driver for Samanage enables you to integrate live Samanage data into Tableau Cloud dashboards using the Tableau Bridge.
-
Integrate Dify with Live ActiveCampaign Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Dify agents and workflows to securely access and query live ActiveCampaign data.
-
Query, Visualize, and Share live Raisers Edge NXT Data in Redash
Use CData Connect AI to connect to live Raisers Edge NXT data in Redash for querying, visualizing, and sharing.
-
PayPal Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on PayPal facts in real time.
-
Connecting Google Drive to an AI Document Agent with CData Connect AI
Step-by-step guide to building an AI document agent that connects to Google Drive using CData Connect AI and MCP. Configure permissions, convert documents to native Google Docs format, set up a Claude project system prompt, and validate live document retrieval.
-
Object-Relational Mapping (ORM) with SAS xpt Data Entities in Java
Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to SAS xpt data into a Java-based ORM framework, Hibernate.
-
Automated Continuous Spotify Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Spotify replication to delimited files (CSV/TSV).
-
Prepare, Blend, and Analyze Freshservice Data in Alteryx Designer (Connect AI)
Build workflows to access live Freshservice data for self-service data analytics.
-
Automated Continuous Beeminder Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Beeminder replication to Amazon S3.
-
Integrate Trae with Live Adobe Experience Manager Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Trae to securely access and query live Adobe Experience Manager data from within the AI-powered IDE.
-
Manage LinkedIn Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for LinkedIn.
-
Create Google Search-Connected Nintex Workflows
Use CData Connect AI to connect to Google Search Results from Nintex Workflow Cloud and build custom workflows using live Google Search results.
-
Rapidly Develop Bitly-Driven Apps with Active Query Builder
Leverage the Active Query Builder SQL interface and .NET data access to create data-driven WinForms and ASP.NET apps backed by Bitly.
-
How to Connect to Live SurveyMonkey Data from OpenAI Python Applications (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable OpenAI-powered Python applications to securely read and take actions on your SurveyMonkey data through natural language.
-
Automated Continuous SAP Ariba Procurement Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable SAP Ariba Procurement replication to delimited files (CSV/TSV).
-
Integrating Claude Code CLI with Box Data via CData CLI
CData CLI gives AI coding agents direct, command-line-native access to CData Drivers across hundreds of data sources, allowing agents to manage licenses, configure connections, run SQL queries, and explore schema metadata - all without leaving the terminal.
-
Connect to Marketo Data from Crystal Reports
Use CData Connect AI to connect to and report on live Marketo data from Crystal Reports.
-
Replicate Multiple Bullhorn CRM Accounts
Replicate multiple Bullhorn CRM accounts to one or many databases.
-
Easily Integrate Salesforce Marketing Data in Lazarus Pascal IDE
Learn how to easily integrate live Salesforce Marketing data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
DataBind Controls to Float Data in Delphi
DataBind to Float data in Delphi with standard data access components and controls.
-
Use CData Connect AI to Access Excel Online Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Excel Online data in the Power Pivot business intelligence tool.
-
How to Create Power BI Visual Reports with Real-Time Pinterest Data
Use CData Power BI Connectors to visualize Pinterest data in Power BI.
-
Visualize Webex Data in Tableau
The CData ODBC driver for Webex enables you integrate Webex data into Tableau dashboards.
-
Replicate Multiple Adobe Commerce Accounts
Replicate multiple Adobe Commerce accounts to one or many databases.
-
Visualize Paddle Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Paddle data.
-
How to Connect DBeaver to Nuclia via a JDBC Driver
Manage Nuclia data with visual tools in DBeaver like the query browser.
-
Connect to and Query Cvent Data in QlikView over ODBC
Create data visualizations with Cvent data in QlikView.
-
Use Agno to Talk to Your Jira Assets Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Agno agents to securely answer questions and take actions on your Jira Assets data for you.
-
Use Dash to Build to Web Apps on HCL Domino Data
Create Python applications that use pandas and Dash to build HCL Domino-connected web apps.
-
Visualize Live Reply.io Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Reply.io data.
-
Integrate with Live Acumatica Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Acumatica from the MuleSoft Anypoint Platform to integrate live Acumatica data into custom reports and dashboards.
-
Query Live iContact Data in Perplexity Desktop via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Perplexity Desktop to securely access and query live iContact data through a conversational interface.
-
Query Google Directory Data in ColdFusion
Write standard ColdFusion data access code to connect to Google Directory data.
-
Analyze Live OData Services in SAS Viya
Use CData Connect AI to connect to OData services from SAS Viya and deploy self-service analytics using live OData services.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Spotify
Provide connectivity to Spotify data through an SAP BusinessObjects universe.
-
Design BIRT Reports on Elasticsearch Data
Provide current Elasticsearch data to your embedded analytics.
-
Import Google Analytics Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Google Analytics Data and provide access to live Google Analytics data for custom reports in the Power BI Service.
-
Create Data Visualizations Based On OneNote Data in Mode
Use CData Connect AI to connect to OneNote Data from Mode and build visualizations using live OneNote data.
-
Use the CData ODBC Driver for SharePoint in Microsoft Power Query
You can use the CData SharePoint ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import SharePoint data into Microsoft Power Query.
-
Use the CData Software ODBC Driver for Amazon DynamoDB in MicroStrategy Desktop
Connect to Amazon DynamoDB data in MicroStrategy Desktop using the CData Software ODBC Driver for Amazon DynamoDB.