CData Software - Knowledge Base
Recent Articles
-
Automated Continuous ServiceNow Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable ServiceNow replication to delimited files (CSV/TSV).
-
Connect to Microsoft Entra ID Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Microsoft Entra ID data in Airbyte.
-
Consume RSS OData Feeds in PowerBuilder
This article demonstrates how to consume RSS feeds as OData feeds from PowerBuilder using the API Server.
-
Replicate Raisers Edge NXT Data from PowerShell
Write a quick PowerShell script to query Raisers Edge NXT data. Use connectivity to the live data to replicate Raisers Edge NXT data to SQL Server.
-
Using the CData Software ODBC Driver for Adobe Analytics in PyCharm
Connect to Adobe Analytics as an ODBC data source in PyCharm using the CData Software ODBC Driver for Adobe Analytics.
-
Import Real-Time Teamwork Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Teamwork data in ColdFusion.
-
Create Mailjet Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Mailjet from PowerBI.com to create Power BI Dataflows with real-time data.
-
How to connect and process Cvent data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Cvent data.
-
How to Visualize Sugar CRM 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 Sugar CRM data in Python.
-
Create Informatica Mappings From/To a JDBC Data Source for Odoo
Create Odoo data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
How to connect and process Jira data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Jira data.
-
Use the CData SSIS Components to Insert New or Update Existing Microsoft Exchange Records from SQL Server
Easily push SQL Server data to Microsoft Exchange using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Microsoft Exchange or update existing records with data from a SQL Server database.
-
Getting Started with the CData JDBC Driver for MarkLogic
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for MarkLogic.
-
Create Informatica Mappings From/To a JDBC Data Source for Keap
Create Keap data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Use the CData Software ODBC Driver for QuickBooks Online in MicroStrategy Desktop
Connect to QuickBooks Online data in MicroStrategy Desktop using the CData Software ODBC Driver for QuickBooks Online.
-
Connect to Google Translate Data in NetBeans
Connect to Google Translate data in NetBeans with the data source configuration wizard.
-
Build LightSpeedRetail-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to LightSpeedRetail data and build web apps with connectivity to live LightSpeedRetail data.
-
Integrate Gmail Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Gmail data and integrate live Gmail data into your Power Automate tasks.
-
Connect to Front Data in HULFT Integrate
Connect to Front as a JDBC data source in HULFT Integrate
-
How to connect to Float Data from Spring Boot
Connect to Float in a Spring Boot Application using the CData API Driver for JDBC
-
Model Coda Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Coda, enabling the direct import of real-time Coda data.
-
Analyze Clio Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Clio data with the CData JDBC Driver for Clio.
-
How to create Azure Data Lake Storage federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Azure Data Lake Storage data in MySQL .
-
Integrate Goose with Live ZohoPeople Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live ZohoPeople data from within the local AI agent.
-
Connect to Brex Data from a Connection Pool in JBoss
Integrate Brex data into Java servlets: Use the Management Console in JBoss to install the Brex JDBC Driver.
-
Integrating Boomi Agentstudio with Oracle Eloqua Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Oracle Eloqua data, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
How to Connect DBeaver to TigerGraph via a JDBC Driver
Manage TigerGraph data with visual tools in DBeaver like the query browser.
-
A PostgreSQL Interface for Rebilly Data using the CData ODBC Driver
Use the SQL Gateway and Rebilly ODBC Driver to create a PostgreSQL entry-point for data access.
-
Integrate Microsoft Dataverse with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Microsoft Dataverse with External Services.
-
How to integrate Metabase with SAP SuccessFactors LMS Data
Use CData Connect AI to connect to live SAP SuccessFactors LMS data and create an interactive dashboard in Metabase from SAP SuccessFactors LMS data.
-
Connect to Facebook Ads in SpagoBI
Create reports featuring live Facebook Ads data in SpagoBI Studio. Host Facebook Ads reports on SpagoBI Server.
-
Access Live Azure Data Catalog Data in TIBCO Data Virtualization
Use the Azure Data Catalog Tibco DV Adapter to create a Azure Data Catalog data data source in TIBCO Data Virtualization Studio and gain access to live Azure Data Catalog data from your TDV Server.
-
Build Freshteam-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Freshteam Data and create custom apps in Mendix.
-
Automated Continuous Databricks Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Databricks data replication to OneLake in Microsoft Fabric.
-
Access Live HDFS Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live HDFS data from your Excel spreadsheets.
-
Import Real-Time Avro Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Avro data in ColdFusion.
-
How to Connect to Live QuickBooks Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live QuickBooks data securely in real time.
-
Use the CData Software JDBC Driver for GetResponse in MicroStrategy Desktop
Connect to GetResponse data in MicroStrategy Desktop using the CData Software JDBC Driver for GetResponse.
-
Connect to SuiteCRM Data in Google Apps Script via Connect AI
Use CData Connect AI to access SuiteCRM data in Google Apps Script.
-
Integrate Dify with Live HDFS 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 HDFS data.
-
Load Flowlu Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Flowlu data to a database.
-
Getting Started with the CData ODBC Driver for SFTP
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for SFTP.
-
Integrate Trae with Live Sage 300 Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Trae to securely access and query live Sage 300 data from within the AI-powered IDE.
-
How to Connect the Power BI Service to Freshdesk: Complete Guide
Connect to the CData Software Power BI Connector for Freshdesk from PowerBI.com to provide real-time Freshdesk data across the organization.
-
How to connect to EmailOctopus Data from Spring Boot
Connect to EmailOctopus in a Spring Boot Application using the CData API Driver for JDBC
-
Design BIRT Reports on Zoho Projects Data
Provide current Zoho Projects data to your embedded analytics.
-
DataBind VWO Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide VWO data to a chart.
-
Aweber Reporting in OBIEE with the Aweber JDBC Driver
Deploy the Aweber JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Connect to Google Cloud Storage Data in DBeaver
Use the CData ODBC Driver to connect to Google Cloud Storage data in DBeaver.
-
Build Semantic Layer Views for CampaignMonitor Data in APOS Live Data Gateway
Use the CData Connector for CampaignMonitor in APOS Live Data Gateway to build Semantic Layer Views for CampaignMonitor data.
-
Create ShipStation Dataflows on PowerBI.com
Connect to the CData Power BI Connector for ShipStation from PowerBI.com to create Power BI Dataflows with real-time data.
-
Build Automated Workflows with Live MailChimp Data in Workato
Use CData Connect AI to connect to live MailChimp data and build automated workflows in Workato.
-
Visualize Live Qualaroo Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Qualaroo data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Build an OLAP Cube in SSAS from Oracle Service Cloud Data
Establish a connection to Oracle Service Cloud data data from SQL Server Analysis Services, and use the Oracle Service Cloud Data Provider to build OLAP cubes for use in analytics and reporting.
-
Integrate OpenCode with Live Azure Data Catalog Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable OpenCode to securely access and query live Azure Data Catalog data from within your AI coding agent.
-
Automated Continuous OneNote Replication to Amazon S3
Use CData Sync for automated, continuous, customizable OneNote replication to Amazon S3.
-
Using the CData Software ODBC Driver for Telegram in PyCharm
Connect to Telegram as an ODBC data source in PyCharm using the CData Software ODBC Driver for Telegram.
-
Query Chargebee Data as a MySQL Database in Node.js
Execute MySQL queries against Chargebee data from Node.js.
-
Build Semantic Layer Views for Google Drive Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Google Drive data.
-
Integrate Goose with Live Google Campaign Manager 360 Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Google Campaign Manager 360 data from within the local AI agent.
-
Integrating Kiro with ClickUp 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 ODBC Driver for CouchDB in Microsoft Power Query
You can use the CData CouchDB ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import CouchDB data into Microsoft Power Query.
-
Connect to SpaceX Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for SpaceX and the SQL Gateway to access SpaceX data from Google Apps Script.
-
Create Dashboards and Visualize Live ZohoDesk Data in Geckoboard
Use CData Connect AI to connect to live ZohoDesk data and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Work with Live Amazon Marketplace Data in Power Query
Use CData Connect AI to connect to Amazon Marketplace data and work with live Amazon Marketplace data in Microsoft Power Query.
-
Integrating Antigravity CLI with Gorgias data via CData CLI
Connect Gorgias data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Use Biml to Build SSIS Tasks to Replicate GraphQL Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate GraphQL data to SQL Server.
-
Publish Crystal Reports on Vault CRM Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Vault CRM data.
-
Integrating Gumloop with YouTube Analytics Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on YouTube Analytics data within automated workflows.
-
Replicate Multiple Spark Accounts via the CData Sync CLI
Replicate multiple Spark accounts to one or many databases.
-
Build Semantic Layer Views for ClickTime Data in APOS Live Data Gateway
Use the CData Connector for ClickTime in APOS Live Data Gateway to build Semantic Layer Views for ClickTime data.
-
Access Live Presto Data in TIBCO Data Virtualization
Use the Presto Tibco DV Adapter to create a Presto data data source in TIBCO Data Virtualization Studio and gain access to live Presto data from your TDV Server.
-
Integrating Boomi Agentstudio with Moosend Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Moosend data, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Replicate CouchDB Data from PowerShell
Write a quick PowerShell script to query CouchDB data. Use connectivity to the live data to replicate CouchDB data to SQL Server.
-
Integrating SAP SuccessFactors LMS Data in Talend Cloud Data Management Platform
Connect SAP SuccessFactors LMS Data with Talend Cloud Data Management Platform using the CData JDBC Driver for SAP SuccessFactors LMS.
-
Query FHIR Data as a SQL Server Database in Node.js
Execute SQL Server queries against FHIR data from Node.js.
-
Build Semantic Layer Views for Dynamics 365 Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Dynamics 365 data.
-
Access SAP ByDesign Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live SAP ByDesign data from HeidiSQL.
-
Build Apps with Live Salesforce Data 360 data in Adalo using CData Connect AI
Use CData Connect AI to integrate live Salesforce Data 360 data into the Adalo platform and build custom mobile and web applications with real-time Salesforce Data 360 data.
-
Choosing the Best Method to Connect Timely to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Timely data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Write a Simple Go Application to work with ClickUp Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to ClickUp data.
-
How to integrate Bright Data with Apache Airflow
Access and process Bright Data data in Apache Airflow using the CData JDBC Driver.
-
DataBind Charts to Azure Synapse Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Azure Synapse 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.
-
Access Mailgun Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Mailgun data from HeidiSQL.
-
Connect to Real-Time Cloudflare Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Cloudflare data in Power Apps.
-
How to connect to Google Forms Data from Spring Boot
Connect to Google Forms in a Spring Boot Application using the CData API Driver for JDBC
-
Analyze Live Google Analytics Data in SAS Viya
Use CData Connect AI to connect to Google Analytics data from SAS Viya and deploy self-service analytics using live Google Analytics data.
-
Analyze Clio Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Clio data in Microsoft R Open.
-
Connect HelloSign to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live HelloSign data using the CData Python MCP Server.
-
How to Seamlessly Import Scrapfly Data into IBM SPSS Modeler
Integrate Scrapfly data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Integrating Kiro with Teradata 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.
-
Connecting Pipedream with Zuora 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 Zuora data in real time.
-
Build a PostgreSQL Interface for MySQL Data using the CData JDBC Driver
Use the Remoting features of the MySQL JDBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to Impala Data in RapidMiner
Integrate Impala data with standard components and data source configuration wizards in RapidMiner Studio.
-
Automated Continuous Access Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Access replication to Amazon Redshift.
-
Create Informatica Mappings From/To a JDBC Data Source for SAS xpt
Create SAS xpt data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
How to work with ZohoSubscriptions Data in Apache Spark using SQL
Access and process ZohoSubscriptions Data in Apache Spark using the CData Software JDBC Driver.
-
DataBind Controls to SAP SuccessFactors LMS Data in Delphi
DataBind to SAP SuccessFactors LMS data in Delphi with standard data access components and controls.
-
Build Automated Google Forms-Connected Workflows in Zapier
Use CData Connect AI to connect to live Google Forms data and build automated workflows in Zapier.
-
Build Automated SAS Data Sets-Connected Workflows in Zapier
Use CData Connect AI to connect to live SAS Data Sets data and build automated workflows in Zapier.