CData Software - Knowledge Base
Recent Articles
-
Create Reports with Cloudflare Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Cloudflare data.
-
Working with Kafka Data in LINQPad
Execute LINQ queries to Kafka data in LINQPad.
-
How to Use a Microsoft Access Database to Update LinkedIn Data in Real Time
Update LinkedIn data by creating a linked table in Microsoft Access with the CData LinkedIn ODBC Driver.
-
How to create an RPA flow for ClickTime Data in UiPath Studio
Use the ClickTime ODBC Driver to create workflows that access real-time ClickTime data without any coding.
-
DataBind Controls to CircleCI Data in Delphi
DataBind to CircleCI data in Delphi with standard data access components and controls.
-
Migrating data from ZohoInvoice to Snowflake using CData SSIS Components.
Easily push ZohoInvoice data to Snowflake using the CData SSIS Tasks for ZohoInvoice and Snowflake.
-
Connect to Salesforce CRM Analytics Data from AWS Glue
Use CData Connect AI to gain access to live Salesforce CRM Analytics data from your AWS Glue jobs.
-
Use JayDeBeApi to access Samanage Data in Python
Use standard Python scripting and the development environment of your choice to access live Samanage data.
-
Analyze Google Spanner Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Google Spanner data and visualize live Google Spanner data in Infragistics Reveal.
-
Import Real-Time Redis Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Redis data in ColdFusion.
-
How to create an RPA flow for Typeform Data in UiPath Studio
Use the Typeform ODBC Driver to create workflows that access real-time Typeform data without any coding.
-
Create Adobe Commerce-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Adobe Commerce Data from Klipfolio and build custom visualizations using live Adobe Commerce data.
-
Model OneNote Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and OneNote, enabling the direct import of real-time OneNote data.
-
Create Informatica Mappings From/To a JDBC Data Source for LDAP
Create LDAP data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Connect to Oracle Eloqua Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Oracle Eloqua to connect to Oracle Eloqua data and execute queries in PowerBuilder.
-
Use the CData Software JDBC Driver for Box in MicroStrategy Desktop
Connect to Box data in MicroStrategy Desktop using the CData Software JDBC Driver for Box.
-
Integrate QuickBooks Online with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate QuickBooks Online with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to QuickBooks Online data.
-
Automated Continuous MessageBird Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable MessageBird replication to delimited files (CSV/TSV).
-
Analyze Wrike Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Wrike from Power Pivot. You will use the Table Import Wizard to load Wrike data. You can visually build the import query or use any SQL supported by the driver.
-
Build Automated Workflows with Live Kafka Data in Workato
Use CData Connect AI to connect to live Kafka data and build automated workflows in Workato.
-
Getting Started with the CData SSIS Components for Epicor Kinetic
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Epicor Kinetic.
-
How to Build an ETL App for SharePoint Data in Python with CData
Create ETL applications and real-time data pipelines for SharePoint data in Python with petl.
-
Build Pinterest-Connected Apps in Choreo
Use CData Connect AI to connect to Pinterest Data from Choreo and build custom apps using live Pinterest data.
-
Load Figshare Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Figshare data to a database.
-
Import and Visualize Pipeline CRM Data in Power View
Create data visualizations based on Pipeline CRM data in Excel.
-
Use the CData Software JDBC Driver for Facebook Ads in MicroStrategy Web
Connect to Facebook Ads data in MicroStrategy Web using the CData Software JDBC Driver for Facebook Ads.
-
Create Data Visualizations Based On Amazon Athena Data in Mode
Use CData Connect AI to connect to Amazon Athena Data from Mode and build visualizations using live Amazon Athena data.
-
Connect to Real-Time Freshteam Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Freshteam data in Power Apps.
-
LINQ to ServiceDesk Plus Data
LINQ offers versatile querying capabilities within the .NET Framework (v3.0+), offering a straightforward method for programmatic data access through CData ADO.NET Data Providers. In this article, we demonstrate the use of LINQ to retrieve information from the ServiceDesk Plus Data Provider.
-
Deploy the ADO.NET Provider for Airtable on an SSRS Report Server
Connect to Airtable data 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.
-
Natively Connect to REST Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to REST data. Leverage the native support for ODBC in PHP.
-
How to Connect to & Open Epicor Kinetic Data in Microsoft Excel
This article uses the CData ODBC driver for Epicor Kinetic to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Connect to Notion Data in JRuby
Create a simple JRuby app with access to live Notion data.
-
View Reports on Real-Time Bitbucket Data in Power BI Report Server
Use the CData ODBC Driver for Bitbucket to visualize Bitbucket data in Power BI Desktop and then publish them to Power BI Report Server.
-
Analyze JobNimbus Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze JobNimbus data in Microsoft R Open.
-
Use the CData ODBC Driver for ChartMogul in Microsoft Power Query
You can use the CData ChartMogul ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import ChartMogul data into Microsoft Power Query.
-
How to use SQLAlchemy ORM to access Harvest Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Harvest data.
-
Create a Data Access Object for OpenWeatherMap Data using JDBI
A brief overview of creating a SQL Object API for OpenWeatherMap data in JDBI.
-
Process & Analyze Sugar CRM Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Sugar CRM Data.
-
Integrate Cline with Live SFTP Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live SFTP data from within your IDE.
-
Build SurveyMonkey-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for SurveyMonkey Data and create custom apps in Mendix.
-
How to Work with ZohoSubscriptions Data in ETL Validator JDBC
Connect to ZohoSubscriptions from ETL Validator jobs using the CData Software JDBC Driver.
-
Integrate Open WebUI with Live Exact Online Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Exact Online data from within the chat interface.
-
Build Outreach.io-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Outreach.io data.
-
How to Connect to Active Directory Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Active Directory data. Leverage the pyodbc module for ODBC in Python.
-
Build Semantic Layer Views for Strava Data in APOS Live Data Gateway
Use the CData Connector for Strava in APOS Live Data Gateway to build Semantic Layer Views for Strava data.
-
Integrate Omnisend Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Omnisend data and integrate live Omnisend data into your Power Automate tasks.
-
Connect to Live Basecamp Data in MicroStrategy through CData Connect AI
Create a live connection to Basecamp Data in CData Connect AI and connect to your Basecamp data from MicroStrategy.
-
How to Connect to Live Vault CRM Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Vault CRM data securely in real time.
-
Replicate Templated Data to Multiple Databases via the CData Sync CLI
Replicate Templated data to disparate databases with a single configuration.
-
Automated Continuous Spark Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Spark replication to Apache Kafka.
-
How to Visualize Cosmos DB Data in Python with pandas
Use pandas and other modules to analyze and visualize live Cosmos DB data in Python.
-
Connect to SAP Hybris C4C Data in RapidMiner
Integrate SAP Hybris C4C data with standard components and data source configuration wizards in RapidMiner Studio.
-
Automated Continuous LinkedIn Replication to SQL Server
Use CData Sync for automated, continuous, customizable LinkedIn replication to SQL Server.
-
Build Visualizations of Active Directory Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Active Directory data in Birst.
-
Connect to Snowflake Data in DBArtisan
Use wizards in DBArtisan to configure Snowflake data as a data source.
-
Bidirectional Access to Access Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Access data in Filemaker Pro for Mac or Windows.
-
Automated Continuous ChargeOver Replication to Vertica
Use CData Sync for automated, continuous, customizable ChargeOver replication to Vertica.
-
Using the CData Software ODBC Driver for Egnyte in PyCharm
Connect to Egnyte as an ODBC data source in PyCharm using the CData Software ODBC Driver for Egnyte.
-
Use Grok to Talk to Your Monday.com 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 Monday.com data for you.
-
Integrate Real-Time Access to Pipedrive in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Pipedrive data in real time.
-
Integrate Google's Antigravity Agent with Live Airtable Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Airtable data using the Model Context Protocol.
-
Integrate Goose with Live Box Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Box data from within the local AI agent.
-
Connect OnePageCrm to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live OnePageCrm data using the CData Python MCP Server.
-
Automated Continuous Microsoft Exchange Replication to MySQL
Use CData Sync for automated, continuous, customizable Microsoft Exchange replication to MySQL.
-
Connect to PingOne Data in Google Apps Script via Connect AI
Use CData Connect AI to access PingOne data in Google Apps Script.
-
How to use SQLAlchemy ORM to access Zoom Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Zoom data.
-
Integrate Live QuickBooks Online Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to QuickBooks Online from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live QuickBooks Online data.
-
Access Live ADP Data in Emergent via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Emergent agents to securely access and build applications with live ADP data through MCP integration.
-
Connect to Aircall Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Aircall as an External Source in Dremio.
-
How to Connect DBeaver to Basecamp via a JDBC Driver
Manage Basecamp data with visual tools in DBeaver like the query browser.
-
Connect to Splunk Data from a Connection Pool in JBoss
Integrate Splunk data into Java servlets: Use the Management Console in JBoss to install the Splunk JDBC Driver.
-
Aircall Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Aircall facts in real time.
-
How to Seamlessly Import Raisers Edge NXT Data into IBM SPSS Modeler
Integrate Raisers Edge NXT data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Access Live Egnyte Data in Excel 365 Online (Excel for the web)
Connect to Egnyte data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Connect to MailerLite Data in DBeaver
Use the CData ODBC Driver to connect to MailerLite data in DBeaver.
-
Connect to SAP Business Warehouse Data in NetBeans
Connect to SAP Business Warehouse data in NetBeans with the data source configuration wizard.
-
Connect to LinkedIn Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for LinkedIn data in Airbyte.
-
How to Connect to Live Spark Data from Claude Agent SDK (via CData Connect AI)
Leverage CData Connect AI to enable Claude Agent SDK applications to securely read and take actions on your Spark data for you.
-
Connect to SAS Data Sets Data in RapidMiner
Integrate SAS Data Sets data with standard components and data source configuration wizards in RapidMiner Studio.
-
Analyze Printify Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Printify data in Microsoft R Open.
-
Rapidly Develop Microsoft Teams-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 Microsoft Teams.
-
Integrating Cursor with Wave Financial 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 Sage Intacct Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Sage Intacct and the SQL Gateway to access Sage Intacct data from Google Apps Script.
-
Getting Started with the CData ADO.NET Provider for Snapchat Ads
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Snapchat Ads.
-
Integrating LlamaIndex with SageHR Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on SageHR data in real time.
-
Create Azure Table-Connected Dashboards in Grafana
Connect to Azure Table Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Azure Table data.
-
Write a Simple Go Application to work with SAP Hybris C4C Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to SAP Hybris C4C data.
-
Connect to and Query Drip Data in QlikView over ODBC
Create data visualizations with Drip data in QlikView.
-
How to import Vercel Data into Apache Solr
Use the CData Software JDBC Driver for Vercel in Data Import Handler and create an automated import of Vercel data to Apache Solr Enterprise Search platform.
-
Use JayDeBeApi to access ZeroBounce Data in Python
Use standard Python scripting and the development environment of your choice to access live ZeroBounce data.
-
Access Ontraport Data from MySQL in PHP
Connect to Ontraport through the standard MySQL libraries in PHP.
-
Query, Visualize, and Share live Zoho Books Data in Redash
Use CData Connect AI to connect to live Zoho Books data in Redash for querying, visualizing, and sharing.
-
How to create Azure Table federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Azure Table data in MySQL .
-
Connect to Facebook Data in DBeaver
Use the CData ODBC Driver to connect to Facebook data in DBeaver.
-
Connect to Billsby Data from PowerBuilder via ADO.NET
This article demonstrates how to access Billsby data from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Use Biml to Build SSIS Tasks to Replicate Datadog Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Datadog data to SQL Server.
-
Work with Greenplum Data in FoxPro
Load Greenplum data into a FoxPro database. This article includes full code and a walk-through of the process.
-
How to Connect Flowise AI Agents to Live Office 365 Data via CData Connect AI
Integrate Flowise AI with the CData Connect AI MCP Server to enable agents to securely query and act on live Office 365 data without replication.
-
Visualize Insightly Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Insightly data.