CData Software - Knowledge Base
Recent Articles
-
Create Couchbase-Connected Applications in Appsmith
Connect to Couchbase Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Couchbase.
-
Extract, Transform, and Load Chargebee Data in Informatica PowerCenter
Create a simple Workflow for Chargebee in Informatica PowerCenter.
-
Build Data Flows from Airtable to SQL Server using SSIS
Easily back up Airtable to SQL Server using the SSIS components for Airtable.
-
Integrating OpenCode Terminal with Tanda 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 SAS xpt Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for SAS XPORT in the Denodo Virtual DataPort Administrator.
-
How to connect and process Customer.io from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Customer.io.
-
Connect to Marketo Data in JRuby
Create a simple JRuby app with access to live Marketo.
-
Connect to CircleCI Data in Jaspersoft Studio
Execute SQL to remote CircleCI in Jaspersoft Studio.
-
Create Dynamic Mailgun Grids Using the Infragistics XamDataGrid
Learn how you can connect Mailgun to Infragistics XamDataGrid to build dynamic grids.
-
How to Query Live Campaigner Data in Claude Desktop
Connect to and query live Campaigner Data in Claude Desktop using CData MCP Server.
-
Getting Started with the CData JDBC Driver for Azure Table
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Azure Table.
-
Building Dynamic Web Pages with Nethunt Data Using AngularJS
Create single-page applications with live connectivity to Nethunt using the CData API Server.
-
Getting Started with the CData Power BI Connector for ChartMogul
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Getting Started with the CData SSIS Components for MailerSend
Complete guide to installing, licensing, and connecting with the CData SSIS Components for MailerSend.
-
Visualize Live iContact Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live iContact using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Access BambooHR Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live BambooHR from HeidiSQL.
-
Visualize Apify Data in TIBCO Spotfire through ADO.NET
Integrate Apify into dashboards in TIBCO Spotfire.
-
How to Easily Query CampaignMonitor Data in OpenOffice Base
Connect to CampaignMonitor data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Stream Instantly Data into Apache Kafka Topics
Access and stream Instantly in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Create Act-On Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Act-On from PowerBI.com to create Power BI Dataflows with real-time data.
-
Design BIRT Reports on Procore Data
Provide current Procore to your embedded analytics.
-
Import and Visualize Auth0 Data in Power View
Create data visualizations based on Auth0 in Excel.
-
Connect to SpaceX from Asprova with CData Software ODBC Driver for SpaceX
This article shows how to connect faster to SpaceX data from Asprova.
-
Query Egnyte Data in DataGrip
Create a Data Source for Egnyte in DataGrip and use SQL to query live Egnyte.
-
Using CData JDBC Drivers from NetBeans
CData JDBC Drivers make it easy for Java developers to work with a variety of data sources. In this article we show how to develop with CData JDBC Drivers using the NetBeans Java IDE.
-
Connect to ZohoMarketingHub Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for ZohoMarketingHub.
-
Build Pipelines with Live Freshdesk Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Freshdesk from Google Cloud Data Fusion, enabling the integration of live Freshdesk into the building and management of effective data pipelines.
-
How to create an RPA flow for Dynamics NAV Data in UiPath Studio
Use the Dynamics NAV ODBC Driver to create workflows that access real-time Microsoft Dynamics NAV without any coding.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed Everhour to Power BI dashboards. Simply drag and drop Everhour into data visuals on the Power BI canvas.
-
Integrating Claude Code with Oracle SCM Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Oracle SCM within assisted coding and automated development workflows.
-
How to Import Data from ActiveCampaign into Google Sheets
Import ActiveCampaign into a Google spreadsheet that is automatically refreshed.
-
Connect to LionDesk Data in HULFT Integrate
Connect to LionDesk as a JDBC data source in HULFT Integrate
-
How to Connect Amazon Athena Data to Gemini Enterprise via CData Connect AI
Connect CData Connect AI Remote MCP to Gemini Enterprise to securely read and take actions on live Amazon Athena data in real time using natural language.
-
Build Visualizations of Postmark Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Postmark in Birst.
-
Connecting Pipedream with GraphQL Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Pipedream workflows to securely read and take actions on GraphQL data in real time.
-
Connect and Query Live Elasticsearch Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Elasticsearch into Databricks
-
How to connect PolyBase to Dynamics CRM
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Microsoft Dynamics CRM.
-
Build AI/ML Models with Live Rebilly Data using Dataiku
Connect Rebilly Data with Dataiku using the CData API Driver for JDBC.
-
Easily Integrate BenchmarkEmail Data in Lazarus Pascal IDE
Learn how to easily integrate live BenchmarkEmail in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Create SSAS Tabular Models from Coinbase Data
How to build a SQL Server Analysis Service Tabular Model from Coinbase using CData drivers.
-
DataBind Controls to Reply.io Data in Delphi
DataBind to Reply.io in Delphi with standard data access components and controls.
-
View Reports on Real-Time Contentful Data in Power BI Report Server
Use the CData ODBC Driver for Contentful to visualize Contentful in Power BI Desktop and then publish them to Power BI Report Server.
-
Bridge ZohoMarketingHub Connectivity with Apache NiFi
Access and process ZohoMarketingHub in Apache NiFi using the CData JDBC Driver.
-
Connect to Gmail Data in Claris FileMaker Pro
Use the CData ODBC Driver for Gmail in FileMaker Pro to connect to Gmail and work with Gmail in your FileMaker applications.
-
Build SAP Business One-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData MCP Server for SAP Business One to explore live SAP Business One Data in GitHub Copilot to assist with building SAP Business One-powered applications.
-
Deploy the ADO.NET Provider for SpaceX on an SSRS Report Server
Connect to SpaceX 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.
-
How to Import Data from Airtable into Google Sheets
Import Airtable into a Google spreadsheet that is automatically refreshed.
-
Connect to Missive Data from PowerBuilder via ADO.NET
This article demonstrates how to access Missive from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Build a PostgreSQL Interface for Typeform Data using the CData JDBC Driver
Use the Remoting features of the Typeform JDBC Driver to create a PostgreSQL entry-point for data access.
-
Access Live Sage Cloud Accounting Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live Sage Cloud Accounting data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Integrate Live Freshservice Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Freshservice and integrate live Freshservice into apps built in Microsoft Power Apps.
-
Object-Relational Mapping (ORM) with Microsoft Dataverse 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 Microsoft Dataverse (CDS) into a Java-based ORM framework, Hibernate.
-
Automated Continuous PagerDuty Replication to Vertica
Use CData Sync for automated, continuous, customizable PagerDuty replication to Vertica.
-
Use the CData Software ODBC Driver for Salesforce Data 360 in MicroStrategy
Connect to Salesforce Data 360 in MicroStrategy Developer using the CData Software ODBC Driver for Salesforce Data 360.
-
Build a Singer.io Tap for Pipeline CRM With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Pipeline CRM data using
-
Back Up CircleCI to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData API Driver for ADO.NET. In this article, we will employ an SSIS workflow to populate a database with CircleCI data.
-
How to connect to LinkedIn Ads Data with Squirrel SQL client
Connect to LinkedIn Ads and execute queries in the Squirrel SQL Client.
-
Create Dashboards and Visualize Live Databricks Data in Geckoboard
Use CData Connect AI to connect to live Databricks and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Google Sheets using the Model Context Protocol.
-
Replicate Multiple Autopilot Accounts via the CData Sync CLI
Replicate multiple Autopilot accounts to one or many databases.
-
How to Access Live Slack Data in Visual Studio Code via Cline
Run CData MCP Server for Slack on Windows Subsytem for Linux (WSL) and connect to live Slack from the Cline extension in Visual Studio Code.
-
Choosing the Best Method to Connect Intercom to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Intercom from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Use Biml to Build SSIS Tasks to Replicate Avalara AvaTax Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Avalara AvaTax to SQL Server.
-
Visualize Live Anaplan Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Anaplan using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Use Microsoft Copilot Studio to talk to your Adobe Analytics Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Microsoft Copilot Studio to securely answer questions and take actions on your Adobe Analytics for you.
-
Migrating data from Yelp to Databricks using CData SSIS Components.
Easily push Yelp to Databricks using the CData SSIS Tasks for Yelp and Databricks.
-
Connect to Cohere Data in RazorSQL
Connect to Cohere from wizards and query Cohere from the GUI in the RazorSQL database management tool.
-
Use the CData Software JDBC Driver for Keap in MicroStrategy Desktop
Connect to Keap in MicroStrategy Desktop using the CData Software JDBC Driver for Keap.
-
Connect to SendPulse Data from a Connection Pool in Jetty
The SendPulse JDBC Driver supports connection pooling: This article shows how to connect faster to SendPulse from Web apps in Jetty.
-
Automated Continuous Microsoft Entra ID Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Microsoft Entra ID replication to IBM DB2.
-
Explore Geographical Relationships in BigQuery Data with Power Map
Create data visualizations with Google BigQuery in Power Map.
-
Use Azure AI Foundry to Talk to Your Tally Data 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 Tally ERP for you.
-
Getting Started with the CData SSIS Components for ScrapingBee
Complete guide to installing, licensing, and connecting with the CData SSIS Components for ScrapingBee.
-
Import PhantomBuster Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access PhantomBuster. In this article, you will use the OData format to import PhantomBuster into Microsoft Power Query.
-
Access Live CSV Data in AWS Lambda
Connect to live CSV/TSV Files in AWS Lambda using the CData JDBC Driver.
-
Connect to Freshdesk Data from Crystal Reports
Use CData Connect AI to connect to and report on live Freshdesk from Crystal Reports.
-
Create Data Visualizations Based On Redis Data in Mode
Use CData Connect AI to connect to Redis Data from Mode and build visualizations using live
-
Use JayDeBeApi to access PhantomBuster Data in Python
Use standard Python scripting and the development environment of your choice to access live PhantomBuster.
-
Build Charts with MYOB AccountRight Data in Clear Analytics
Create dynamic charts and perform analytics based on MYOB AccountRight in Clear Analytics.
-
Connect to MongoDB Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for MongoDB and the Script function in FileMaker Pro to connect to MongoDB and work with MongoDB in your FileMaker application.
-
Connect to Databricks Data in RapidMiner
Integrate Databricks with standard components and data source configuration wizards in RapidMiner Studio.
-
Integrating Kiro CLI with Oracle SCM 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.
-
Automated Continuous EnterpriseDB Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable EnterpriseDB replication to Azure SQL Database.
-
Visualize Dynamics 365 Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Microsoft Dynamics 365.
-
Visualize Live SAP Ariba Source Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live SAP Ariba Source into custom reports in Power BI.
-
Integrate BambooHR Data into Power Automate Desktop using CData Connect
CData Connect for BambooHR Data enables you to integrate BambooHR into workflows built using Microsoft Power Automate Desktop.
-
Integrate Guru with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Guru with External Services.
-
Establish a Live Connection with ZendeskSell Data using Tableau Bridge
The CData ODBC Driver for ZendeskSell enables you to integrate live ZendeskSell into Tableau Cloud dashboards using the Tableau Bridge.
-
How to Connect to Live Klaviyo 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 Klaviyo for you.
-
Analyze Insightly Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Insightly and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Access MariaDB 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 MariaDB.
-
Add CampaignMonitor Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for CampaignMonitor with the Informatica Enterprise Data Catalog to classify and organize data.
-
Connect to Dotmailer Data from a Connection Pool in Jetty
The Dotmailer JDBC Driver supports connection pooling: This article shows how to connect faster to Dotmailer from Web apps in Jetty.
-
Establish a Live Connection with SendGrid Data using Tableau Bridge
The CData ODBC Driver for SendGrid enables you to integrate live SendGrid into Tableau Cloud dashboards using the Tableau Bridge.
-
Getting Started with the CData Power BI Connector for Highrise
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Highrise.
-
Connect to ADP Data in Google Apps Script via Connect AI
Use CData Connect AI to access ADP in Google Apps Script.
-
Getting Started with the CData ADO.NET Provider for SAS xpt
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for SASxpt.
-
Use the CData Software JDBC Driver for ConvertAPI in MicroStrategy Desktop
Connect to ConvertAPI in MicroStrategy Desktop using the CData Software JDBC Driver for ConvertAPI.
-
Migrating data from SAP HANA to Databricks using CData SSIS Components.
Easily push SAP HANA to Databricks using the CData SSIS Tasks for SAP HANA and Databricks.
-
Build Apify-Powered Applications in Claude Code with CData MCP Server
Use the CData API Driver for MCP Server to explore live Apify Data in Claude Code to assist with building Apify-powered applications.