CData Software - Knowledge Base
Recent Articles
-
Create Dynamic BenchmarkEmail Grids Using the Infragistics XamDataGrid
Learn how you can connect BenchmarkEmail to Infragistics XamDataGrid to build dynamic grids.
-
Automate HubSpot Data Replication to Azure Data Lake
Use CData Sync to customize and automate HubSpot data replication to Azure Data Lake.
-
Connect to Impala Data in HULFT Integrate
Connect to Impala as a JDBC data source in HULFT Integrate
-
Create Dynamic iContact Grids Using the Infragistics XamDataGrid
Learn how you can connect iContact to Infragistics XamDataGrid to build dynamic grids.
-
Automated Continuous Zuora Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Zuora replication to delimited files (CSV/TSV).
-
Integrate with Confluence Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Confluence data in SnapLogic.
-
Use Grok to Talk to Your Act-On 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 Act-On data for you.
-
DataBind Controls to Microsoft Ads Data in Delphi
DataBind to Microsoft Ads data in Delphi with standard data access components and controls.
-
Access Live Office 365 Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Office 365 data from your Excel spreadsheets.
-
Integrating Kiro with MarkLogic 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.
-
Use ChatGPT to Talk to Your Exa 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 Exa data for you.
-
Connect to QuickBooks Data from PowerBuilder via ADO.NET
This article demonstrates how to access QuickBooks data from Appeon PowerBuilder using the CData ADO.NET Provider for QuickBooks.
-
Create Tally Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Tally from PowerBI.com to create Power BI Dataflows with real-time data.
-
Automated Continuous Supabase Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Supabase replication to IBM DB2.
-
Build a Simple VCL Application for AdRoll Data
How to build a simple VCL Application to view AdRoll data in RAD Studio using the CData ODBC Driver for AdRoll.
-
Integrating LlamaIndex with Wave Financial Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Wave Financial data in real time.
-
Connect to Azure Data Catalog from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Azure Data Catalog data, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Build an OLAP Cube in SSAS from Neo4J Data
Establish a connection to Neo4J data data from SQL Server Analysis Services, and use the Neo4J Data Provider to build OLAP cubes for use in analytics and reporting.
-
Replicate Deel Data in Heroku for Use in Salesforce Connect
Replicate Deel data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Establish a Live Connection with Demio Data using Tableau Bridge
The CData ODBC Driver for Demio enables you to integrate live Demio data into Tableau Cloud dashboards using the Tableau Bridge.
-
Work with Postmark Data in FoxPro
Load Postmark data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Use the CData ODBC Driver for Amplitude from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Amplitude to connect to Amplitude data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Amplitude data in Excel.
-
Connect to Office 365 Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Office 365 data from Filemaker Pro on Mac.
-
Creating SharePoint-Connected Applications in Unqork
You can use CData Connect AI to feed SharePoint data to Unqork and build custom business apps.
-
Create Dashboards and Visualize Live YouTube Analytics Data in Geckoboard
Use CData Connect AI to connect to live YouTube Analytics data and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Use the CData Software ODBC Driver for Discourse in MicroStrategy
Connect to Discourse data in MicroStrategy Developer using the CData Software ODBC Driver for Discourse.
-
Connect to Twitter Ads from Asprova with CData Software ODBC Driver for Twitter Ads
This article shows how to connect faster to Twitter Ads data from Asprova.
-
Integrate with Asana Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Asana data to a JSON file on disk.
-
Natively Connect to ScrapingBee Data in PHP
The CData ODBC driver for ScrapingBee enables you to create PHP applications with connectivity to ScrapingBee data. Leverage the native support for ODBC in PHP.
-
Build Mailgun Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Mailgun data and build visualizations in Tableau Cloud.
-
Publish Crystal Reports on Stripe Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Stripe data.
-
Build SAP Ariba Source Visualizations in Tableau Cloud
Use CData Connect AI to connect to live SAP Ariba Source data and build visualizations in Tableau Cloud.
-
Integrate Moosend Data into Power Automate Desktop using CData Connect
CData Connect for Moosend Data enables you to integrate Moosend data into workflows built using Microsoft Power Automate Desktop.
-
Query ZohoPeople Data in DataGrip
Create a Data Source for ZohoPeople in DataGrip and use SQL to query live ZohoPeople data.
-
Add Missive Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Missive with the Informatica Enterprise Data Catalog to classify and organize data.
-
Connect to GitLab from a Connection Pool in WebLogic
Use the CData JDBC Driver for GitLab to connect to GitLab data from Web applications running on WebLogic.
-
Integrate Live Salesforce CRM Analytics 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 Salesforce CRM Analytics data from within the IDE.
-
How to Connect to Live Tavily 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 Tavily data through natural language.
-
Connect and Query Live CSV Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live CSV data into Databricks and enable direct, live querying and analysis without replication.
-
Integrating Antigravity CLI with Bannerbear data via CData CLI
Connect Bannerbear data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
How to connect and process Dynamics CRM data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Dynamics CRM data.
-
Integrating QuickBooks Online Data in Talend Cloud Data Management Platform
Connect QuickBooks Online Data with Talend Cloud Data Management Platform using the CData JDBC Driver for QuickBooks Online.
-
Build Dynamics CRM-Connected Apps in Choreo
Use CData Connect AI to connect to Dynamics CRM Data from Choreo and build custom apps using live Dynamics CRM data.
-
Connect to Hacker News Data from PowerBuilder via ADO.NET
This article demonstrates how to access Hacker News data from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Connect and Visualize Live Presto Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Presto data into the Databricks platform and create visualization dashboards with real-time Presto data.
-
Stream eBay Data into Apache Kafka Topics
Access and stream eBay data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Connect to ConstantContact Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with ConstantContact Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Integrate Oracle Service Cloud Data in Pentaho Data Integration
Build ETL pipelines based on Oracle Service Cloud data in the Pentaho Data Integration tool.
-
Create Reports with ZohoPeople Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date ZohoPeople data.
-
Analyze Adobe Experience Manager Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Adobe Experience Manager data and visualize live Adobe Experience Manager data in Infragistics Reveal.
-
Connect PDFMonkey to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect PDFMonkey with IBM WebSphere for seamless data integration and connectivity.
-
Connecting Mastra with Timely Data 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 Timely data, no replication required.
-
Use Databricks Agent Bricks to Talk to Your Mailjet Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Mailjet data for you.
-
Integrating LangChain with JSON Services via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on JSON services within automated workflows.
-
Integrate Live Dynamics CRM Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Dynamics CRM from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Dynamics CRM data.
-
Connect to ZohoInvoice Data Using the Script Function in Claris FileMaker Pro
Use the CData API Driver for ODBC and the Script function in FileMaker Pro to connect to ZohoInvoice and work with ZohoInvoice data in your FileMaker application.
-
Integrating Kiro with SAS xpt 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 Microsoft Teams Data with Squirrel SQL client
Connect to Microsoft Teams data and execute queries in the Squirrel SQL Client.
-
Replicate Multiple Blackbaud FE NXT Accounts via the CData Sync CLI
Replicate multiple Blackbaud FE NXT accounts to one or many databases.
-
Use Claude to Talk to Your Microsoft Exchange Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your Microsoft Exchange data for you.
-
Connect to Browserless Data from PowerBuilder via JDBC
This article demonstrates how to access Browserless data from PowerBuilder using the Browserless JDBC Driver.
-
Create Datasets from Bitly in Domo Workbench and Build Visualizations of Bitly Data in Domo
Use the CData Software ODBC Driver for Bitly to create datasets from Bitly data in Domo Workbench and then build visualizations in the Domo service.
-
Analyze PagerDuty Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze PagerDuty data with the CData JDBC Driver for PagerDuty.
-
Prepare, Blend, and Analyze Short.io Data in Alteryx Designer (ODBC)
Build workflows to access live Short.io data for self-service data analytics.
-
Build a PostgreSQL Interface for OData Services using the CData JDBC Driver
Use the Remoting features of the OData JDBC Driver to create a PostgreSQL entry-point for data access.
-
Migrating data from ClickUp to Snowflake using CData SSIS Components.
Easily push ClickUp data to Snowflake using the CData SSIS Tasks for ClickUp and Snowflake.
-
Build a Simple VCL Application for ConstantContact Data
How to build a simple VCL Application to view ConstantContact data in RAD Studio using the CData ODBC Driver for ConstantContact.
-
Connect to BenchmarkEmail Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time BenchmarkEmail data using standard SQL.
-
Build Rootly-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Rootly data and build web apps with connectivity to live Rootly data.
-
Integrating Cursor with Avro 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.
-
Analyze SageHR Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze SageHR data with the CData JDBC Driver for SageHR.
-
Build AI/ML Models with Live XML Data using Dataiku
Connect XML Data with Dataiku using the CData JDBC Driver for XML.
-
How to Connect the Power BI Service to Coinbase: Complete Guide
Connect to the CData Software Power BI Connector for Coinbase from PowerBI.com to provide real-time Coinbase data across the organization.
-
Enable the Microsoft OneDrive JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Microsoft OneDrive data.
-
Connect to Impala from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Impala data, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Automated Continuous Workable Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Workable replication to Azure SQL Database.
-
Analyze Google Search Results in Looker
Use CData Connect AI to connect to Google Search Results from Looker and build custom apps using live Google Search results.
-
Use the CData Software ODBC Driver for Nuclia in MicroStrategy Desktop
Connect to Nuclia data in MicroStrategy Desktop using the CData Software ODBC Driver for Nuclia.
-
Automated Continuous Instantly Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Instantly replication to Google BigQuery.
-
Bind Live SingleStore Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live SingleStore data and seamlessly connect and bind them to Wijmo's FlexGrid for real-time, interactive data access without manual data movement.
-
Use Dash to Build Web Apps on Pinterest Data via CData Connect AI
Build interactive Dash web apps on live Pinterest data using pandas and the CData Connect AI Python SDK.
-
Access SAP SuccessFactors LMS Data from MySQL in Amazon QuickSight
Connect to SAP SuccessFactors LMS and build visualizations of SAP SuccessFactors LMS data using a MySQL Connection in Amazon QuickSight.
-
Use JayDeBeApi to access Zoho Projects Data in Python
Use standard Python scripting and the development environment of your choice to access live Zoho Projects data.
-
Create Datasets from Freshdesk in Domo Workbench and Build Visualizations of Freshdesk Data in Domo
Use the CData Software ODBC Driver for Freshdesk to create datasets from Freshdesk data in Domo Workbench and then build visualizations in the Domo service.
-
Connect to TaxJar Data in Google Apps Script via Connect AI
Use CData Connect AI to access TaxJar data in Google Apps Script.
-
Automated Continuous xBase Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable xBase replication to Azure SQL Database.
-
Integrate Live Oracle Eloqua Reporting Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Oracle Eloqua Reporting data to Blue Prism using the CData ODBC Driver for Oracle Eloqua Reporting to create automated workflows for repetitive business tasks.
-
Analyze Egnyte Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Egnyte from Power Pivot. You will use the Table Import Wizard to load Egnyte data. You can visually build the import query or use any SQL supported by the driver.
-
How to Seamlessly Import JobNimbus Data into IBM SPSS Modeler
Integrate JobNimbus data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Object-Relational Mapping (ORM) with Marketo 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 Marketo data into a Java-based ORM framework, Hibernate.
-
Integrating Kiro with Aircall 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.
-
Natively Connect to JotForm Data in PHP
The CData ODBC driver for JotForm enables you to create PHP applications with connectivity to JotForm data. Leverage the native support for ODBC in PHP.
-
Configure the CData JDBC Driver for Invoiced in a Connection Pool in Tomcat
Connect to Invoiced data from a connection pool in Tomcat.
-
Import Real-Time Hive Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Hive data in ColdFusion.
-
IBM Informix Reporting in OBIEE with the IBM Informix JDBC Driver
Deploy the IBM Informix JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Connect to Hacker News Data in CloverDX (formerly CloverETL)
Transfer Hacker News data using the visual workflow in the CloverDX data integration tool.
-
Integrating OpenCode with IBM Cloud Object Storage 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.
-
Build Agents in Relevance AI with Access to Live Toggl Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Toggl data within intelligent agent workflows.
-
Create Power BI Reports on Real-Time Instagram Data
Use the CData ODBC Driver for Instagram to visualize Instagram data in Power BI Desktop.
-
How to integrate Act-On with Apache Airflow
Access and process Act-On data in Apache Airflow using the CData JDBC Driver.