CData Software - Knowledge Base
Recent Articles
-
Use the CData Software ODBC Driver for ConvertKit in MicroStrategy
Connect to ConvertKit in MicroStrategy Developer using the CData Software ODBC Driver for ConvertKit.
-
DataBind Controls to Mailjet Data in Delphi
DataBind to Mailjet in Delphi with standard data access components and controls.
-
Access TaxJar Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access TaxJar from your Oracle system.
-
Publish Onfleet-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Onfleet.
-
Analyze Zendesk Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Zendesk and visualize live Zendesk in Infragistics Reveal.
-
Bind Live Microsoft Exchange Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Microsoft Exchange data
-
Automated Continuous TaxJar Replication to Snowflake
Use CData Sync for automated, continuous, customizable TaxJar replication to Snowflake.
-
Bind Live Salesforce CRM Analytics Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Salesforce CRM Analytics data
-
Getting Started with the CData Power BI Connector for Sugar CRM
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Sugar CRM.
-
Integrate Live OneNote Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Microsoft OneNote to Blue Prism using the CData ODBC Driver for OneNote to create automated workflows for repetitive business tasks.
-
Connect to Square Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Square.
-
How to Connect DBeaver to Procore via a JDBC Driver
Manage Procore with visual tools in DBeaver like the query browser.
-
Migrating data from eBay Analytics to Snowflake using CData SSIS Components.
Easily push eBay Analytics to Snowflake using the CData SSIS Tasks for eBay Analytics and Snowflake.
-
A PostgreSQL Interface for FormSite Data using the CData ODBC Driver
Use the SQL Gateway and FormSite ODBC Driver to create a PostgreSQL entry-point for data access.
-
Integrating Claude Code CLI with Google Forms 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.
-
Integrate with Oracle Eloqua Reporting Data in JReport Designer
Create charts and reports based on Oracle Eloqua Reporting in JReport Designer.
-
Connect PingOne to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect PingOne with IBM WebSphere for seamless data integration and connectivity.
-
Create a Data Access Object for Acumatica Data using JDBI
A brief overview of creating a SQL Object API for Acumatica ERP in JDBI.
-
Use Grok to Talk to Your Vault CRM Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Grok AI to securely answer questions and take actions on your Veeva Vault & Vault CRM for you.
-
How to publish and share Bugsnag Data dashboards with Tableau Server
The CData ODBC driver for Bugsnag enables you integrate Bugsnag into Tableau dashboards.
-
Build Data Flows from SQL Server to Stripe through SSIS
Easily push SQL Server data to Stripe using the CData SSIS Tasks for Stripe.
-
Getting Started with the CData Python Connector for Dynamics 365
Learn to install and license the CData Python Connector
-
Natively Connect to PolarTeamPro Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to PolarTeamPro. Leverage the native support for ODBC in PHP.
-
Automated Continuous Klipfolio Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Klipfolio replication to Apache Kafka.
-
Use the CData Software ODBC Driver for Facebook Ads in MicroStrategy Desktop
Connect to Facebook Ads in MicroStrategy Desktop using the CData Software ODBC Driver for Facebook Ads.
-
Publish Reports with Pushbullet Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Pushbullet.
-
Connect to Freshteam Data in NetBeans
Connect to Freshteam in NetBeans with the data source configuration wizard.
-
Connecting Moonlit Workflow with ActiveCampaign Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Moonlit workflows to securely read and act on your ActiveCampaign in real time.
-
Integrate FHIR Data in the Pentaho Report Designer
Publish reports based on FHIR in the Pentaho BI tool.
-
How to Query Live Azure Synapse Data in Perplexity MacOS Desktop
Connect to and query live Azure Synapse Data in Perplexity Desktop using CData MCP Server.
-
Analyze Raisers Edge NXT Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Raisers Edge NXT in Microsoft R Open.
-
Use the CData SSIS Components to Insert New or Update Existing QuickBooks Online Records from SQL Server
Easily push SQL Server data to QuickBooks Online using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into QuickBooks Online or update existing records with data from a SQL Server database.
-
How to connect and process PayPal from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live PayPal.
-
Visualize Gmail Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Gmail.
-
Easily Integrate ZendeskSell Data in Lazarus Pascal IDE
Learn how to easily integrate live ZendeskSell in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Connect to Real-Time Azure Analysis Services Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Azure Analysis Services and Dataflow to import and use Azure Analysis Services in Power Apps.
-
How to Connect to Live Trello Data from OpenAI Python Applications (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable OpenAI-powered Python applications to securely read and take actions on your Trello through natural language.
-
How to Connect DBeaver to SAS xpt via a JDBC Driver
Manage SAS XPORT with visual tools in DBeaver like the query browser.
-
Getting Started with the CData Power BI Connector for Onfleet
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Integrate Cline with Live Salesforce Pardot Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Salesforce Pardot from within your IDE.
-
Getting Started with the CData JDBC Driver for Tally
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Tally.
-
Stream Pinterest Data into Apache Kafka Topics
Access and stream Pinterest in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Connect to Real-Time Zoho CRM Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Zoho CRM and Dataflow to import and use Zoho CRM in Power Apps.
-
Build Data Flows from OnePageCrm to SQL Server using SSIS
Easily back up OnePageCrm to SQL Server using the SSIS components for OnePageCrm.
-
Integrate PayPal Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live PayPal from Informatica Cloud.
-
Automate Outreach.io Data Replication to Azure Synapse
Use CData Sync to customize and automate Outreach.io replication to Azure Synapse.
-
Migrating data from Oracle to Google BigQuery using CData SSIS Components.
Easily push Oracle Database to Google BigQuery using the CData SSIS Tasks for Oracle and Google BigQuery.
-
Prepare, Blend, and Analyze Excel Online Data in Alteryx Designer (Connect AI)
Build workflows to access live Microsoft Excel Online for self-service data analytics.
-
Build Semantic Layer Views for EmailOctopus Data in APOS Live Data Gateway
Use the CData Connector for EmailOctopus in APOS Live Data Gateway to build Semantic Layer Views for EmailOctopus.
-
Create Reports with Codat Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Codat.
-
Replicate Xero Data to Multiple Databases
Replicate Xero Accounting to disparate databases with a point-and-click configuration.
-
Consume CouchDB OData Feeds in PowerBuilder
This article demonstrates how to consume Apache CouchDB as OData feeds from PowerBuilder using the API Server.
-
Add SAS Data Sets Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for SAS Data Sets with the Informatica Enterprise Data Catalog to classify and organize data.
-
Connect to Shippo Data in NetBeans
Connect to Shippo in NetBeans with the data source configuration wizard.
-
Automated Continuous Shopify Replication to SQLite
Use CData Sync for automated, continuous, customizable Shopify replication to SQLite.
-
Moving Data from Qualaroo to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Qualaroo data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
How to integrate MongoDB with Apache Airflow
Access and process MongoDB in Apache Airflow using the CData JDBC Driver.
-
Integrate Live HBase Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Apache HBase to Blue Prism using the CData ODBC Driver for HBase to create automated workflows for repetitive business tasks.
-
Visualize Live Mixpanel Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Mixpanel.
-
Use the CData Software JDBC Driver for MySQL in MicroStrategy
Connect to MySQL in MicroStrategy Developer using the CData Software JDBC Driver for MySQL.
-
Working with Aweber Data in LINQPad
Execute LINQ queries to Aweber in LINQPad.
-
Connect to Google Sheets Data in DBeaver
Use the CData ODBC Driver to connect to Google Sheets in DBeaver.
-
Use the CData Software ODBC Driver for SurveyMonkey in MicroStrategy Desktop
Connect to SurveyMonkey in MicroStrategy Desktop using the CData Software ODBC Driver for SurveyMonkey.
-
How to connect and process EnterpriseDB from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live EnterpriseDB.
-
Connect to Float Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Float and work with Float in your FileMaker applications.
-
Connect to Billsby Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Integrating OpenCode Terminal with Perplexity 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 Real-Time Humanity Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Humanity in Power Apps.
-
Analyze Sendwithus Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Sendwithus in Microsoft R Open.
-
Process & Analyze Snowflake Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Snowflake Data.
-
Connect to AlloyDB Data in ACL Analytics
Connect to Google AlloyDB via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Google AlloyDB.
-
How to connect SharePoint with Google Analytics Data through external lists
Provide Google Analytics to SharePoint users as an external list.
-
Analyze MailChimp Data in Cognos Analytics
Use CData Connect AI to connect to MailChimp Data from Cognos Analytics and analyze live MailChimp.
-
LINQ to Google Analytics 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 Google Analytics Data Provider.
-
Create Data Visualizations in Cognos BI with Sage Intacct Data
Access Sage Intacct as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Creating Exact Online-Connected Applications in Unqork
You can use CData Connect AI to feed Exact Online to Unqork and build custom business apps.
-
Feed Samanage Data into FineReport
How to set Samanage as a JDBC data source in FineReport.
-
Connect Jodoo to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Jodoo using the CData Python MCP Server.
-
Connecting GenSpark with Slack Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Slack without any replication or custom integration required.
-
Model, Search, and Visualize Live BigCommerce Data in ThoughtSpot
Use CData Connect AI to connect to live BigCommerce for modeling, searching, and visualizing.
-
DataBind Controls to Retently Data in C++Builder
DataBind to Retently in C++Builder with standard components and controls.
-
Connect to and Visualize Live iContact Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live iContact.
-
Connect to Greenplum Data from PowerBuilder via JDBC
This article demonstrates how to access Pivotal GreenPlum from PowerBuilder using the Greenplum JDBC Driver.
-
Work with Databricks Data in FoxPro
Load Databricks into a FoxPro database. This article includes full code and a walk-through of the process.
-
Replicate Notion Data from PowerShell
Write a quick PowerShell script to query Notion. Use connectivity to the live data to replicate Notion to SQL Server.
-
Connect to Dynamics 365 Data from a Connection Pool in Jetty
The Dynamics 365 JDBC Driver supports connection pooling: This article shows how to connect faster to Microsoft Dynamics 365 from Web apps in Jetty.
-
Feed Office 365 Data into FineReport
How to set Microsoft Office 365 as a JDBC data source in FineReport.
-
Create Datasets from Close in Domo Workbench and Build Visualizations of Close Data in Domo
Use the CData Software ODBC Driver for Close to create datasets from Close in Domo Workbench and then build visualizations in the Domo service.
-
Connecting Mastra with OneNote 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 Microsoft OneNote, no replication required.
-
Analyze Front Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Front in Microsoft R Open.
-
How to Access Harvest Data Using Entity Framework
This article shows how to access Harvest using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Publish Pipedrive-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Pipedrive.
-
Getting Started with the CData SSIS Components for SAP
Complete guide to installing, licensing, and connecting with the CData SSIS Components for SAP.
-
Bidirectional Access to Toggl Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Toggl in Filemaker Pro for Mac or Windows.
-
Build AI/ML Models with Live Dotmailer Data using Dataiku
Connect Dotmailer Data with Dataiku using the CData API Driver for JDBC.
-
Access Live DocuSign Data in Excel 365 Online (Excel for the web)
Connect to DocuSign from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Automated Continuous Dynamics 365 Business Central Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Dynamics 365 Business Central replication to Google Cloud SQL.
-
Connect to Freshteam Data in CloverDX (formerly CloverETL)
Transfer Freshteam using the visual workflow in the CloverDX data integration tool.
-
Build Sugar CRM-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Sugar CRM and build Sugar CRM-connected web apps with Axios.
-
How to Query Live Miro Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Miro data in natural language using Python.