CData Software - Knowledge Base
Recent Articles
-
Visualize Teamgate Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Teamgate data.
-
Natively Connect to Testmonitor Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Testmonitor data. Leverage the native support for ODBC in PHP.
-
How to publish and share Excel Online Data dashboards with Tableau Server
The CData ODBC driver for Excel Online enables you integrate Excel Online data into Tableau dashboards.
-
Automate Oracle Data Replication to Couchbase
Use CData Sync to Customize and automate Oracle data replication to Couchbase.
-
Connect to Calendly 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 Calendly and work with Calendly data in your FileMaker application.
-
Enable the MailChimp JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with MailChimp data.
-
Integrate Amazon Marketplace with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Amazon Marketplace with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Amazon Marketplace data.
-
Integrate Optimizely with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Optimizely with External Services.
-
Connect IBM Cloud Object Storage to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect IBM Cloud Object Storage with IBM WebSphere for seamless data integration and connectivity.
-
Use the CData Software JDBC Driver for Printify in MicroStrategy
Connect to Printify data in MicroStrategy Developer using the CData Software JDBC Driver for Printify.
-
Build Semantic Layer Views for Cosmos DB Data in APOS Live Data Gateway
Use the CData Connector for Cosmos DB in APOS Live Data Gateway to build Semantic Layer Views for Cosmos DB data.
-
Analyze Google Search Results in Cognos Analytics
Use CData Connect AI to connect to Google Search Results from Cognos Analytics and analyze live Google Search results.
-
Use ChatGPT to Talk to Your Bitbucket 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 Bitbucket data for you.
-
Connect to Raisers Edge NXT from Asprova with CData Software ODBC Driver for Raisers Edge NXT
This article shows how to connect faster to Raisers Edge NXT data from Asprova.
-
How to Connect to Google Forms Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Google Forms data. Leverage the pyodbc module for ODBC in Python.
-
Visualize ActiveCampaign Data in TIBCO Spotfire through OData
Integrate ActiveCampaign data into dashboards in TIBCO Spotfire.
-
Create SendPulse-Connected Business Apps in AppSheet
Connect to SendPulse Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to SendPulse data.
-
Build Charts with PabblySubscriptions Data in Clear Analytics
Create dynamic charts and perform analytics based on PabblySubscriptions data in Clear Analytics.
-
Access Oracle Eloqua Reporting Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Oracle Eloqua Reporting data from HeidiSQL.
-
How to Access Live Azure Table Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Azure Table enables you to integrate Azure Table data into workflows built using Microsoft Power Automate Desktop.
-
Add Gorgias Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Gorgias with the Informatica Enterprise Data Catalog to classify and organize data.
-
Query Live SendGrid 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 SendGrid data directly from the development environment.
-
Automate Productboard Data Replication to Azure Synapse
Use CData Sync to customize and automate Productboard data replication to Azure Synapse.
-
Query, Visualize, and Share live Azure Data Catalog Data in Redash
Use CData Connect AI to connect to live Azure Data Catalog data in Redash for querying, visualizing, and sharing.
-
Use Biml to Build SSIS Tasks to Replicate Klipfolio Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Klipfolio data to SQL Server.
-
Connect to Instantly from Asprova with CData Software ODBC Driver for Instantly
This article shows how to connect faster to Instantly data from Asprova.
-
Work with Printful Data in FoxPro
Load Printful data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Connect to Salesforce Marketing Data as an External Data Source using PolyBase
Use CData Connect AI and PolyBase to create an external data source in SQL Swerver with access to live Salesforce Marketing data.
-
Analyze Freshservice Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Freshservice data and visualize Freshservice data in SAP Analytics Cloud.
-
How to Connect to Live Suadeo Data in n8n Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable n8n to securely read and take actions on your Suadeo data for you.
-
Automated Continuous Rebilly Replication to SingleStore
Use CData Sync for automated, continuous, customizable Rebilly replication to SingleStore.
-
Getting Started with the CData Power BI Connector for Keap
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Connect to TigerGraph Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to TigerGraph.
-
Use Microsoft Copilot Studio to talk to your Omnisend 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 Omnisend data for you.
-
Visualize Live Act CRM Data in the Power BI Service
Use CData Connect AI to connect to live Act CRM data and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Connect to Epicor Kinetic Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Epicor Kinetic data in Airbyte.
-
Process & Analyze XML Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live XML Data.
-
Prepare, Blend, and Analyze SuiteCRM Data in Alteryx Designer (ODBC)
Build workflows to access live SuiteCRM data for self-service data analytics.
-
How to connect PolyBase to Google Directory
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Google Directory data.
-
Connect to Vimeo Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Vimeo data using standard SQL.
-
Build MongoDB-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for MongoDB Data and create custom apps in Bubble.
-
Use Biml to Build SSIS Tasks to Replicate Sage 300 Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Sage 300 data to SQL Server.
-
Integrate Klaviyo Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Klaviyo data from Informatica Cloud.
-
Integrate Hubstaff Data in Pentaho Data Integration
Build ETL pipelines based on Hubstaff data in the Pentaho Data Integration tool.
-
Connect to HubSpot Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live HubSpot data.
-
Connect to Excel Online Data from Crystal Reports
Use CData Connect AI to connect to and report on live Excel Online data from Crystal Reports.
-
Extract, Transform, and Load Impala Data in Informatica PowerCenter
Create a simple Workflow for Impala data in Informatica PowerCenter.
-
A PostgreSQL Interface for Oracle HCM Cloud Data using the CData ODBC Driver
Use the SQL Gateway and Oracle HCM Cloud ODBC Driver to create a PostgreSQL entry-point for data access.
-
How to Use a Microsoft Access Database to Update Workday Data in Real Time
Update Workday data by creating a linked table in Microsoft Access with the CData Workday ODBC Driver.
-
Build AI/ML Models with Live Procore Data using Dataiku
Connect Procore Data with Dataiku using the CData API Driver for JDBC.
-
Automated Continuous ZohoMarketingHub Replication to Amazon S3
Use CData Sync for automated, continuous, customizable ZohoMarketingHub replication to Amazon S3.
-
Perform Batch Operations with Basecamp Data in Apache NiFi
Connect to Basecamp data and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Create SSAS Tabular Models from Certinia Data
How to build a SQL Server Analysis Service Tabular Model from Certinia data using CData drivers.
-
Build xBase Visualizations in Tableau Desktop
Use CData Connect AI to connect to live xBase data and build visualizations in Tableau.
-
Build SharePoint-Connected Apps in Choreo
Use CData Connect AI to connect to SharePoint Data from Choreo and build custom apps using live SharePoint data.
-
Integrating LlamaIndex with Bannerbear Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Bannerbear data in real time.
-
How to Build an ETL App for Microsoft OneDrive Data in Python with CData
Create ETL applications and real-time data pipelines for Microsoft OneDrive data in Python with petl.
-
Connect to SpaceX Data in Jaspersoft Studio
Execute SQL to remote SpaceX data in Jaspersoft Studio.
-
Moving Data from Zoho Projects to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Zoho Projects data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
How to import SendGrid Data into Apache Solr
Use the CData Software JDBC Driver for SendGrid in Data Import Handler and create an automated import of SendGrid data to Apache Solr Enterprise Search platform.
-
Query Brex Data as a MySQL Database in Node.js
Execute MySQL queries against Brex data from Node.js.
-
Connect to Quickbase in SpagoBI
Create reports featuring live Quickbase data in SpagoBI Studio. Host Quickbase reports on SpagoBI Server.
-
Automated Continuous Jira Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Jira replication to Apache Kafka.
-
Connect to LeadDesk Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to LeadDesk and work with LeadDesk data in your FileMaker applications.
-
Bridge Salesforce Connectivity with Apache NiFi
Access and process Salesforce data in Apache NiFi using the CData JDBC Driver.
-
Automated Continuous NASA Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable NASA replication to Apache Kafka.
-
Validate QuickBooks Online Data with QuerySurge
Access and validate QuickBooks Online data in QuerySurge using the CData JDBC Driver.
-
Integrating Supabase Data in Talend Cloud Data Management Platform
Connect Supabase Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
DataBind Controls to Teradata Data in C++Builder
DataBind to Teradata data in C++Builder with standard components and controls.
-
Analyze Power BI XMLA Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Power BI XMLA data with the CData JDBC Driver for Power BI XMLA.
-
Getting Started with the CData Python Connector for Browserless
Learn to install and license the CData Python Connector and configure a connection to live Browserless data.
-
How to create MailChimp federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for MailChimp data in MySQL .
-
Analyze Exact Online Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Exact Online data and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Build a Simple VCL Application for Typeform Data
How to build a simple VCL Application to view Typeform data in RAD Studio using the CData ODBC Driver for Typeform.
-
Connect Marketo Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Marketo data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
A PostgreSQL Interface for Oracle Eloqua Data using the CData ODBC Driver
Use the SQL Gateway and Oracle Eloqua ODBC Driver to create a PostgreSQL entry-point for data access.
-
Visualize Live OneNote Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live OneNote data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Integrating LangChain with Snapchat Ads Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Snapchat Ads data within automated workflows.
-
Import SurveyMonkey Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to SurveyMonkey Data and provide access to live SurveyMonkey data for custom reports in the Power BI Service.
-
Deploy the ADO.NET Provider for Trello on an SSRS Report Server
Connect to Trello 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.
-
Getting Started with the CData SSIS Components for MailerLite
Complete guide to installing, licensing, and connecting with the CData SSIS Components for MailerLite.
-
Automated Continuous Accelo Replication to SQLite
Use CData Sync for automated, continuous, customizable Accelo replication to SQLite.
-
How to connect and process Harvest data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Harvest data.
-
Build AI/ML Models with Live Zoom Data using Dataiku
Connect Zoom Data with Dataiku using the CData API Driver for JDBC.
-
How to Query ConvertKit Data in MySQL Workbench
Execute MySQL queries against live ConvertKit data from MySQL Workbench.
-
Visualize OneNote Data in TIBCO Spotfire through ADO.NET
Integrate OneNote data into dashboards in TIBCO Spotfire.
-
Integrate with live IBM Informix Data in Jitterbit
Use CData Connect AI to connect to and integrate live IBM Informix data in Jitterbit.
-
Integrate with Live Oracle Eloqua Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Oracle Eloqua from the MuleSoft Anypoint Platform to integrate live Oracle Eloqua data into custom reports and dashboards.
-
Using the CData Software ODBC Driver for Harvest in PyCharm
Connect to Harvest as an ODBC data source in PyCharm using the CData Software ODBC Driver for Harvest.
-
How to connect Amazon QuickSight to Smartsheet Data
Create a connection to Smartsheet data in CData Connect AI and insert Smartsheet data into Amazon QuickSight SPICE to build interactive dashboards.
-
Connect to Slack Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Slack data.
-
How to connect to SageHR Data in DBVisualizer
Integrate SageHR data with visual data analysis tools and data connection wizards in DBVisualizer
-
Getting Started with the CData Excel Add-In for LaunchDarkly
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for LaunchDarkly.
-
Connect to Optimizely Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Optimizely and the SQL Gateway to access Optimizely data from Google Apps Script.
-
Consume SAP Hybris C4C OData Feeds in PowerBuilder
This article demonstrates how to consume SAP Hybris C4C data as OData feeds from PowerBuilder using the API Server.
-
Connect to Microsoft OneDrive Data in Claris FileMaker Pro
Use the CData ODBC Driver for Microsoft OneDrive in FileMaker Pro to connect to Microsoft OneDrive and work with Microsoft OneDrive data in your FileMaker applications.
-
Visualize Zoho Creator Data in Tableau
The CData ODBC driver for Zoho Creator enables you integrate Zoho Creator data into Tableau dashboards.
-
DataBind FormSite Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide FormSite data to a chart.
-
Integrate Theia IDE with Live Spark 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 Spark data from within the development environment.
-
Integrate Google's Antigravity Agent with Live Dynamics NAV Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Dynamics NAV data using the Model Context Protocol.