CData Software - Knowledge Base
Recent Articles
-
Using the CData Software ODBC Driver for DB2 in PyCharm
Connect to DB2 as an ODBC data source in PyCharm using the CData Software ODBC Driver for DB2.
-
How to load BambooHR data into Elasticsearch via Logstash
Introducing a simple method to load BambooHR data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
How to Easily Query Humanity Data in OpenOffice Base
Connect to Humanity data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Use the CData SSIS Components to Insert New or Update Existing WooCommerce Records from SQL Server
Easily push SQL Server data to WooCommerce using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into WooCommerce or update existing records with data from a SQL Server database.
-
Integrating LlamaIndex with Freshteam Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Freshteam data in real time.
-
How to Work with Impala Data in ETL Validator JDBC
Connect to Impala from ETL Validator jobs using the CData Software JDBC Driver.
-
Migrating data from Freshteam to Databricks using CData SSIS Components.
Easily push Freshteam data to Databricks using the CData SSIS Tasks for Freshteam and Databricks.
-
Automate Google Forms Data Replication to Azure Data Lake
Use CData Sync to customize and automate Google Forms data replication to Azure Data Lake.
-
How to Connect to Live Oracle Eloqua Data from Google ADK Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Google ADK agents to securely read and take actions on your Oracle Eloqua data for you.
-
Replicate Strava Data in Heroku for Use in Salesforce Connect
Replicate Strava data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Automated Continuous Asana Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Asana replication to PostgreSQL.
-
Automated Continuous Dynamics CRM Replication to MySQL
Use CData Sync for automated, continuous, customizable Dynamics CRM replication to MySQL.
-
Integrate Live MongoDB 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 MongoDB data from within the IDE.
-
Import and Visualize SingleStore Data in Power View
Create data visualizations based on SingleStore data in Excel.
-
Visualize Live Postmark Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Postmark data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Visualize SAP Concur Data in TIBCO Spotfire through OData
Integrate SAP Concur data into dashboards in TIBCO Spotfire.
-
Automated Continuous Superchat Replication to MySQL
Use CData Sync for automated, continuous, customizable Superchat replication to MySQL.
-
Use the CData Software JDBC Driver for Snowflake in MicroStrategy Desktop
Connect to Snowflake data in MicroStrategy Desktop using the CData Software JDBC Driver for Snowflake.
-
Query CampaignMonitor Data through ODBC in Node.js
Use node-odbc to execute SQL queries against CampaignMonitor data from Node.js.
-
Automate Google Cloud Storage Data Replication to SAP HANA
Use CData Sync to customize and automate Google Cloud Storage data replication to SAP HANA.
-
How to Connect to Live Zoho Inventory Data from Gemini CLI (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Gemini CLI to securely read and take actions on your Zoho Inventory data for you.
-
How to Access Datadog Data Using Entity Framework
This article shows how to access Datadog data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Natively Connect to Paylocity Data in PHP
The CData ODBC driver for Paylocity enables you to create PHP applications with connectivity to Paylocity data. Leverage the native support for ODBC in PHP.
-
Automated Continuous SparkPost Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable SparkPost replication to Amazon Redshift.
-
Access Live Moosend 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 Moosend data through MCP integration.
-
DataBind Charts to Missive Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Missive data 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.
-
Write a Simple Go Application to work with Okta Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Okta data.
-
Integrating Claude Code with Sybase IQ Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Sybase IQ data within assisted coding and automated development workflows.
-
Explore Geographical Relationships in PayPal Data with Power Map
Create data visualizations with PayPal data in Power Map.
-
Query Autopilot Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Autopilot data from Node.js.
-
Integrate Amazon Marketplace Data into Power Automate Desktop using CData Connect
CData Connect for Amazon Marketplace Data enables you to integrate Amazon Marketplace data into workflows built using Microsoft Power Automate Desktop.
-
Analyze HelloSign Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze HelloSign data with the CData JDBC Driver for HelloSign.
-
Automated Continuous Active Directory Replication to Oracle
Use CData Sync for automated, continuous, customizable Active Directory replication to Oracle.
-
Integrating Codex with Azure Table 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.
-
Access Apollo Data in Mule Applications Using the CData JDBC Driver
Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for Apollo data.
-
Automated Continuous Amazon Marketplace Replication to Databricks
Use CData Sync for automated, continuous, customizable Amazon Marketplace replication to Databricks.
-
Create Informatica Mappings From/To a JDBC Data Source for Zoho Creator
Create Zoho Creator data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
How to Build an ETL App for ZohoExpense Data in Python with CData
Create ETL applications and real-time data pipelines for ZohoExpense data in Python with petl.
-
Connect to Perigon Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Perigon data in the Denodo Virtual DataPort Administrator.
-
ETL Excel in Oracle Data Integrator
This article shows how to transfer Excel data into a data warehouse using Oracle Data Integrator.
-
How to Work with Freshsales Data in AWS Glue Jobs Using JDBC
Connect to Freshsales from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Build Omnisend Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Omnisend data and build visualizations in Tableau Cloud.
-
Model, Search, and Visualize Live SQL Analysis Services Data in ThoughtSpot
Use CData Connect AI to connect to live SQL Analysis Services data for modeling, searching, and visualizing.
-
How to Visualize Google Contacts Data in Python with pandas via CData Connect AI
Use the CData Connect AI Python SDK with pandas and Matplotlib to analyze and visualize live Google Contacts data in Python.
-
Connect to Beeminder Data in DBeaver
Use the CData ODBC Driver to connect to Beeminder data in DBeaver.
-
Connecting Agentforce with Typeform Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Agentforce to securely read and take actions on your Typeform data for you.
-
Bind Live SAS xpt Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live SAS xpt data and seamlessly connect and bind them to Wijmo's FlexGrid for real-time, interactive data access without manual data movement.
-
How to Create Power BI Visual Reports with Real-Time Paymo Data
Use CData Power BI Connectors to visualize Paymo data in Power BI.
-
Process & Analyze OneNote Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live OneNote Data.
-
Query Amazon DynamoDB Data in ColdFusion
Write standard ColdFusion data access code to connect to Amazon DynamoDB data.
-
Analyze Splunk Data in Looker
Use CData Connect AI to connect to Splunk Data from Looker and build custom apps using live Splunk data.
-
Connect to Dynamics 365 Business Central from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Dynamics 365 Business Central data, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Automated Helpscout Data Replication to Teradata
Use CData Sync to Customize and automate Helpscout data replication to Teradata.
-
Process & Analyze Intercom Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Intercom Data.
-
Create SSAS Tabular Models from HelloSign Data
How to build a SQL Server Analysis Service Tabular Model from HelloSign data using CData drivers.
-
Automated Continuous Float Replication to Snowflake
Use CData Sync for automated, continuous, customizable Float replication to Snowflake.
-
How to Build an ETL App for Google Spanner Data in Python with CData
Create ETL applications and real-time data pipelines for Google Spanner data in Python with petl.
-
Automated Continuous Jumpseller Replication to Snowflake
Use CData Sync for automated, continuous, customizable Jumpseller replication to Snowflake.
-
Connect to Raisers Edge NXT Data from Crystal Reports
Use CData Connect AI to connect to and report on live Raisers Edge NXT data from Crystal Reports.
-
Integrate Theia IDE with Live Databricks Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE's built-in AI agents to securely access and query live Databricks data from within the development environment.
-
Connect Bitly to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Bitly with IBM WebSphere for seamless data integration and connectivity.
-
Connect to FreshBooks Data in Aqua Data Studio
Access FreshBooks data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Connect and Visualize Live Campaigner Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Campaigner data into the Databricks platform and create visualization dashboards with real-time Campaigner data.
-
Use ChatGPT to Talk to Your Stripe 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 Stripe data for you.
-
Access Live SFTP Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live SFTP data from your Excel spreadsheets.
-
Access Live CapsuleCRM Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live CapsuleCRM data from your Excel spreadsheets.
-
Build a PostgreSQL Interface for Sentry Data using the CData JDBC Driver
Use the Remoting features of the Sentry JDBC Driver to create a PostgreSQL entry-point for data access.
-
Creating ZohoInvoice-Connected Applications in Unqork
You can use CData Connect AI to feed ZohoInvoice data to Unqork and build custom business apps.
-
Use the CData ODBC Driver for Tanda from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Tanda to connect to Tanda data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Tanda data in Excel.
-
Create Paymo-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Paymo Data from OutSystems and build custom enterprise apps using live Paymo data.
-
Stream EnterpriseDB Data into Apache Kafka Topics
Access and stream EnterpriseDB data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Create Hive Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Hive data access from reports, embedded analytics, and more.
-
LINQ to OnePageCrm 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 OnePageCrm Data Provider.
-
Connect to BigCommerce Data in JRuby
Create a simple JRuby app with access to live BigCommerce data.
-
Connect to ZohoPeople Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to ZohoPeople and work with ZohoPeople data in your FileMaker applications.
-
Analyze Live Snapchat Ads Data in SAS Viya
Use CData Connect AI to connect to Snapchat Ads data from SAS Viya and deploy self-service analytics using live Snapchat Ads data.
-
Connect to Zendesk Data from HeidiSQL
Use CData Connect AI to connect to and query live Zendesk data from HeidiSQL.
-
Automated Continuous HCL Domino Replication to SQLite
Use CData Sync for automated, continuous, customizable HCL Domino replication to SQLite.
-
Consume LDAP OData Feeds in PowerBuilder
This article demonstrates how to consume LDAP objects as OData feeds from PowerBuilder using the API Server.
-
Create Power BI Reports on Real-Time AdRoll Data
Use the CData ODBC Driver for AdRoll to visualize AdRoll data in Power BI Desktop.
-
Integrate Trae with Live ADP Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Trae to securely access and query live ADP data from within the AI-powered IDE.
-
Integrating OpenCode with Bullhorn CRM 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 the CData Software ODBC Driver for SharePoint in MicroStrategy
Connect to SharePoint data in MicroStrategy Developer using the CData Software ODBC Driver for SharePoint.
-
Create Data Visualizations Based On ShipStation Data in Mode
Use CData Connect AI to connect to ShipStation Data from Mode and build visualizations using live ShipStation data.
-
Connect to and Query GitLab Data in QlikView over ODBC
Create data visualizations with GitLab data in QlikView.
-
Query Sybase Data as a MySQL Database in Node.js
Execute MySQL queries against Sybase data from Node.js.
-
Query SendPulse Data in DataGrip
Create a Data Source for SendPulse in DataGrip and use SQL to query live SendPulse data.
-
Integrating LangChain with ShipEngine Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on ShipEngine data within automated workflows.
-
Build a PostgreSQL Interface for Kintone Data using the CData JDBC Driver
Use the Remoting features of the Kintone JDBC Driver to create a PostgreSQL entry-point for data access.
-
Integrate FreeAgent Data in the Pentaho Report Designer
Publish reports based on FreeAgent data in the Pentaho BI tool.
-
Connect to Aircall Data from PowerBuilder via JDBC
This article demonstrates how to access Aircall data from PowerBuilder using the Aircall JDBC Driver.
-
Integrating Antigravity CLI with Google Contacts data via CData CLI
Connect Google Contacts data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Viewing Avro Data in RAD Studio Data Explorer
How to view Avro data in RAD Studio Data Explorer using the CData ODBC Driver for Avro.
-
Integrate Workday Data in the Pentaho Report Designer
Publish reports based on Workday data in the Pentaho BI tool.
-
Connect to TaxJar Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to TaxJar.
-
Connect to Mailjet 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 Mailjet and work with Mailjet data in your FileMaker application.
-
Access Workable Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Workable data from your Oracle system.
-
How to integrate Metabase with SAP HANA XS Advanced Data
Use CData Connect AI to connect to live SAP HANA XS Advanced data and create an interactive dashboard in Metabase from SAP HANA XS Advanced data.
-
Build MVC Applications with Connectivity to Pushbullet Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Pushbullet from an ASP.NET MVC application.
-
How to connect Amazon QuickSight to WooCommerce Data
Create a connection to WooCommerce data in CData Connect AI and insert WooCommerce data into Amazon QuickSight SPICE to build interactive dashboards.