CData Software - Knowledge Base
Recent Articles
-
Build Semantic Layer Views for MessageBird Data in APOS Live Data Gateway
Use the CData Connector for MessageBird in APOS Live Data Gateway to build Semantic Layer Views for MessageBird data.
-
Create Informatica Mappings From/To an ODBC Data Source for eBay
Create an ODBC connection to eBay in Informatica and browse and transfer eBay data.
-
How to Access Live MailerSend Data in Power Automate Desktop via ODBC
The CData ODBC Driver for MailerSend enables you to integrate MailerSend data into workflows built using Microsoft Power Automate Desktop.
-
Provide OData Services of PolarTeamPro Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for PolarTeamPro data by developing a WCF Service Application.
-
Integrate Live Office 365 Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Office 365 data to Blue Prism using the CData ODBC Driver for Office 365 to create automated workflows for repetitive business tasks.
-
Build Voice Agents in ElevenLabs with access to Live SAS xpt Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live SAS xpt data.
-
Easily Integrate Stack Exchange Data in Lazarus Pascal IDE
Learn how to easily integrate live Stack Exchange data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Connecting Agentforce with WordPress 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 WordPress data for you.
-
Access Freshdesk Data from MySQL in PHP
Connect to Freshdesk through the standard MySQL libraries in PHP.
-
Access Live Highrise Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Highrise data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Automated Continuous Oracle Eloqua Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Oracle Eloqua replication to Google Cloud SQL.
-
Connect to AfterShip Data in Google Apps Script via Connect AI
Use CData Connect AI to access AfterShip data in Google Apps Script.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Retently
Provide connectivity to Retently data through an SAP BusinessObjects universe.
-
Getting Started with the CData Tableau Connector for Calendly
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Migrating data from Rootly to Databricks using CData SSIS Components.
Easily push Rootly data to Databricks using the CData SSIS Tasks for Rootly and Databricks.
-
How to publish and share PabblySubscriptions Data dashboards with Tableau Server
The CData ODBC driver for PabblySubscriptions enables you integrate PabblySubscriptions data into Tableau dashboards.
-
Build Salesforce Pardot-Connected Apps in Choreo
Use CData Connect AI to connect to Salesforce Pardot Data from Choreo and build custom apps using live Salesforce Pardot data.
-
Build SpaceX-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live SpaceX data.
-
Build an OLAP Cube in SSAS from OData Services
Establish a connection to OData services data from SQL Server Analysis Services, and use the OData Data Provider to build OLAP cubes for use in analytics and reporting.
-
Automated Sugar CRM Data Replication to Teradata
Use CData Sync to Customize and automate Sugar CRM data replication to Teradata.
-
Getting Started with the CData Power BI Connector for Xero
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Xero.
-
A PostgreSQL Interface for Cassandra Data using the CData ODBC Driver
Use the SQL Gateway and Cassandra ODBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to Twilio in SpagoBI
Create reports featuring live Twilio data in SpagoBI Studio. Host Twilio reports on SpagoBI Server.
-
How to Connect to Live Yelp 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 Yelp data for you.
-
Replicate Redis Data to Multiple Databases
Replicate Redis data to disparate databases with a point-and-click configuration.
-
Connect to FreshBooks Data from AWS Glue
Use CData Connect AI to gain access to live FreshBooks data from your AWS Glue jobs.
-
Choosing the Best Method to Connect Egnyte to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Egnyte data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Enable the Reckon Accounts Hosted JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Reckon Accounts Hosted data.
-
Create Datasets from SAS xpt in Domo Workbench and Build Visualizations of SAS xpt Data in Domo
Use the CData Software ODBC Driver for SAS xpt to create datasets from SAS xpt data in Domo Workbench and then build visualizations in the Domo service.
-
Connect to and Visualize Live LinkedIn Ads Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live LinkedIn Ads data.
-
Getting Started with the CData Python Connector for PabblySubscriptions
Learn to install and license the CData Python Connector and configure a connection to live PabblySubscriptions data.
-
How to integrate Outlook with Apache Airflow
Access and process Outlook data in Apache Airflow using the CData JDBC Driver.
-
Consume Marketo OData Feeds in PowerBuilder
This article demonstrates how to consume Marketo data as OData feeds from PowerBuilder using the API Server.
-
Use the CData ODBC Driver for Oracle Financials Cloud in Microsoft Power Query
You can use the CData Oracle Financials Cloud ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Oracle Financials Cloud data into Microsoft Power Query.
-
ETL EnterpriseDB in Oracle Data Integrator
This article shows how to transfer EnterpriseDB data into a data warehouse using Oracle Data Integrator.
-
How to Easily Query Snowflake Data in OpenOffice Base
Connect to Snowflake data in OpenOffice Base using the CData ODBC Driver for Snowflake and generate reports with live data insights.
-
Replicate Multiple ConstantContact Accounts
Replicate multiple ConstantContact accounts to one or many databases.
-
Integrating Antigravity CLI with Parallel data via CData CLI
Connect Parallel data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Analyze Sage Cloud Accounting Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Sage Cloud Accounting data and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Connect to AlloyDB Data from PowerBuilder via JDBC
This article demonstrates how to access AlloyDB data from PowerBuilder using the AlloyDB JDBC Driver.
-
Operational Reporting on Freshsales Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Freshsales data.
-
Getting Started with the CData ADO.NET Provider for Google Tasks
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Extract, Transform, and Load Gumroad Data in Informatica PowerCenter
Create a simple Workflow for Gumroad data in Informatica PowerCenter.
-
Prepare, Blend, and Analyze FreeAgent Data in Alteryx Designer (ODBC)
Build workflows to access live FreeAgent data for self-service data analytics.
-
Use Agno to Talk to Your Printify Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Agno agents to securely answer questions and take actions on your Printify data for you.
-
Create a Data Access Object for Gmail Data using JDBI
A brief overview of creating a SQL Object API for Gmail data in JDBI.
-
Connect to Real-Time Reckon Accounts Hosted Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Reckon Accounts Hosted and Dataflow to import and use Reckon Accounts Hosted data in Power Apps.
-
Use the CData Software JDBC Driver for CircleCI in MicroStrategy Desktop
Connect to CircleCI data in MicroStrategy Desktop using the CData Software JDBC Driver for CircleCI.
-
Prepare, Blend, and Analyze Sage 300 Data in Alteryx Designer (ODBC)
Build workflows to access live Sage 300 data for self-service data analytics.
-
How to Work with JotForm Data in AWS Glue Jobs Using JDBC
Connect to JotForm from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Automated Continuous ZohoMarketingHub Replication to Snowflake
Use CData Sync for automated, continuous, customizable ZohoMarketingHub replication to Snowflake.
-
Query Live HBase Data in Perplexity Desktop via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Perplexity Desktop to securely access and query live HBase data through a conversational interface.
-
How to Build an ETL App for Egnyte Data in Python with CData
Create ETL applications and real-time data pipelines for Egnyte data in Python with petl.
-
How to connect to Microsoft Exchange Data with Squirrel SQL client
Connect to Microsoft Exchange data and execute queries in the Squirrel SQL Client.
-
Connect to Brex Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Brex to connect to Brex data and execute queries in PowerBuilder.
-
Access Live CircleCI Data in AWS Lambda (with IntelliJ IDEA)
Connect to live CircleCI data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Connect to ZohoExpense Data in HULFT Integrate
Connect to ZohoExpense as a JDBC data source in HULFT Integrate
-
Connect to Pinterest Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Pinterest to connect to Pinterest data and execute queries in PowerBuilder.
-
Connect to Oracle Service Cloud Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Oracle Service Cloud Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Import Real-Time Stack Exchange Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Stack Exchange data in ColdFusion.
-
Create SSAS Tabular Models from Mailgun Data
How to build a SQL Server Analysis Service Tabular Model from Mailgun data using CData drivers.
-
Viewing PabblySubscriptions Data in RAD Studio Data Explorer
How to view PabblySubscriptions data in RAD Studio Data Explorer using the CData ODBC Driver for PabblySubscriptions.
-
Automated Continuous Landbot Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Landbot data replication to OneLake in Microsoft Fabric.
-
How to Query Pinterest Data in MySQL Workbench
Execute MySQL queries against live Pinterest data from MySQL Workbench.
-
Access Jumpseller Data from MySQL in PHP
Connect to Jumpseller through the standard MySQL libraries in PHP.
-
How to Connect to Live eBay 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 eBay data for you.
-
Automated Continuous Bitbucket Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Bitbucket data replication to OneLake in Microsoft Fabric.
-
Connect to Quaderno Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Quaderno as an External Source in Dremio.
-
Integrating Codex with IBM Informix 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.
-
Create a Data Access Object for Cosmos DB Data using JDBI
A brief overview of creating a SQL Object API for Cosmos DB data in JDBI.
-
How to create Azure Analysis Services federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Azure Analysis Services data in MySQL .
-
Use Databricks Agent Bricks to Talk to Your ZohoSubscriptions Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your ZohoSubscriptions data for you.
-
Visualize SAP Business One Data in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load SAP Business One data into TIBCO Spotfire.
-
Query Live SAS Data Sets Data in Zed Editor via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Zed Editor to securely access and query live SAS Data Sets data directly from the development environment.
-
DataBind Controls to FTP Data in Delphi
DataBind to FTP data in Delphi with standard data access components and controls.
-
Analyze Certinia Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Certinia data in Microsoft R Open.
-
Automated Continuous Mocean Replication to Snowflake
Use CData Sync for automated, continuous, customizable Mocean replication to Snowflake.
-
Import and Visualize Freshsales Data in Power View
Create data visualizations based on Freshsales data in Excel.
-
Seamlessly Bring Egnyte Data into Retool Using CData Connect AI
Integrate Egnyte data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Create CSV-Connected Nintex Workflows
Use CData Connect AI to connect to CSV Data from Nintex Workflow Cloud and build custom workflows using live CSV data.
-
Work with Microsoft Planner Data in FoxPro
Load Microsoft Planner data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Automated Continuous Auth0 Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Auth0 replication to delimited files (CSV/TSV).
-
Integrate with live Figshare Data in Jitterbit
Use CData Connect AI to connect to and integrate live Figshare data in Jitterbit.
-
How to Visualize IBM Cloud Object Storage Data in Python with pandas
Use pandas and other modules to analyze and visualize live IBM Cloud Object Storage data in Python.
-
Choosing the Best Method to Connect Everhour to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Everhour data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Use the CData Software JDBC Driver for Bitbucket in MicroStrategy
Connect to Bitbucket data in MicroStrategy Developer using the CData Software JDBC Driver for Bitbucket.
-
How to integrate Mistral AI with Apache Airflow
Access and process Mistral AI data in Apache Airflow using the CData JDBC Driver.
-
Using the CData Software ODBC Driver for Redshift in PyCharm
Connect to Redshift as an ODBC data source in PyCharm using the CData Software ODBC Driver for Redshift.
-
Create Highrise-Connected Business Apps in AppSheet
Connect to Highrise Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Highrise data.
-
Connecting Mastra with CockroachDB 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 CockroachDB data, no replication required.
-
Import Real-Time PingOne Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use PingOne data in ColdFusion.
-
Connect to Gorgias 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 Gorgias and work with Gorgias data in your FileMaker application.
-
Connect to Sage Cloud Accounting Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Sage Cloud Accounting Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Connect to Flowlu Data in DBArtisan
Use wizards in DBArtisan to configure Flowlu data as a data source.
-
Use Dash to Build to Web Apps on ShipEngine Data
Create Python applications that use pandas and Dash to build ShipEngine-connected web apps.
-
Access Live Exa Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Exa data into the statistical analysis tools available in SAS JMP. This article shows how to use Exa data in the Graph Builder and Query Builder.
-
How to work with OpenWeatherMap Data in Apache Spark using SQL
Access and process OpenWeatherMap Data in Apache Spark using the CData Software JDBC Driver.
-
Creating Vault CRM-Connected Applications in Unqork
You can use CData Connect AI to feed Vault CRM data to Unqork and build custom business apps.
-
How to integrate Metabase with Google Contacts Data
Use CData Connect AI to connect to live Google Contacts data and create an interactive dashboard in Metabase from Google Contacts data.
-
DataBind Controls to Facebook Data in C++Builder
DataBind to Facebook data in C++Builder with standard components and controls.