CData Software - Knowledge Base
Recent Articles
-
Connect ZohoInvoice to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect ZohoInvoice with IBM WebSphere for seamless data integration and connectivity.
-
Access Procore 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 Procore.
-
DataBind Charts to Bullhorn CRM Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Bullhorn CRM 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.
-
Getting Started with the CData Excel Add-In for Clockify
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Clockify.
-
How to connect PolyBase to TaxJar
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live TaxJar.
-
Automate Exa Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Exa from PowerShell? This article demonstrates how to utilize the Exa Cmdlets for tasks like connecting to Exa, automating operations, downloading data, and more.
-
Query, Visualize, and Share live NetSuite Data in Redash
Use CData Connect AI to connect to live NetSuite CRM & ERP in Redash for querying, visualizing, and sharing.
-
Create Apollo-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Apollo Data from Klipfolio and build custom visualizations using live Apollo.
-
Access Live HCL Domino Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to HCL Domino from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Build a Simple VCL Application for Zoho Recruit Data
How to build a simple VCL Application to view Zoho Recruit in RAD Studio using the CData ODBC Driver for Zoho Recruit.
-
Getting Started with the CData ADO.NET Provider for ZendeskSell
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Eventbrite Reporting in OBIEE with the Eventbrite JDBC Driver
Deploy the Eventbrite JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Use the CData Software ODBC Driver for CloudConvert in SAS for Real-Time Reporting and Analytics
Connect to real-time CloudConvert in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for CloudConvert.
-
Build MVC Applications with Connectivity to CampaignMonitor Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access CampaignMonitor from an ASP.NET MVC application.
-
Integrating Codex CLI with Microsoft OneNote 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 Power BI XMLA Data into Power Automate Desktop using CData Connect
CData Connect for Power BI XMLA Data enables you to integrate Power BI XMLA into workflows built using Microsoft Power Automate Desktop.
-
How to Seamlessly Import Deel Data into IBM SPSS Modeler
Integrate Deel data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Create Data Visualizations Based On Cassandra Data in Mode
Use CData Connect AI to connect to Cassandra Data from Mode and build visualizations using live
-
Analyze MailChimp Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze MailChimp with the CData JDBC Driver for MailChimp.
-
DataBind Charts to Adobe Experience Manager Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Adobe Experience Manager 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 Google Analytics 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 Google Analytics.
-
Connect Anaplan Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Anaplan using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
How to integrate Metabase with Sage 200 Data
Use CData Connect AI to connect to live Sage 200 and create an interactive dashboard in Metabase from Sage 200.
-
Getting Started with the CData Power BI Connector for Sendwithus
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Connect to Instagram Data in NetBeans
Connect to Instagram in NetBeans with the data source configuration wizard.
-
Access Aircall 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 Aircall.
-
Power BI Connector Getting Started Guide
A basic guide to connecting Power BI to data from anywhere using the CData Power BI Connector.
-
Create SSAS Tabular Models from Azure Data Catalog Data
How to build a SQL Server Analysis Service Tabular Model from Azure Data Catalog using CData drivers.
-
Getting Started with the CData JDBC Driver for Freshsales
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Freshsales.
-
Load Pinterest Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Pinterest to a database.
-
Connect to Hugging Face Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Hugging Face and the SQL Gateway to access Hugging Face from Google Apps Script.
-
LionDesk Reporting in OBIEE with the LionDesk JDBC Driver
Deploy the LionDesk JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Integrate with Teamgate Data in JReport Designer
Create charts and reports based on Teamgate in JReport Designer.
-
Publish Scrapfly-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Scrapfly.
-
Getting Started with the CData ADO.NET Provider for Square
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Square.
-
How to Connect to Live Azure DevOps 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 Azure DevOps for you.
-
Integrate Live Reckon Accounts Hosted Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf
-
Connect Suadeo to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Suadeo with IBM WebSphere for seamless data integration and connectivity.
-
Automated Continuous Attio Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Attio replication to PostgreSQL.
-
Integrate Live Google Directory Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf
-
Create HubSpot-Connected Dashboards in Grafana
Connect to HubSpot Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to HubSpot.
-
Connect to Tanda from Asprova with CData Software ODBC Driver for Tanda
This article shows how to connect faster to Tanda data from Asprova.
-
SingleStore Reporting in OBIEE with the SingleStore JDBC Driver
Deploy the SingleStore JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Publish Oracle Eloqua-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Oracle Eloqua.
-
Integrate with Lakebase Data in JReport Designer
Create charts and reports based on Lakebase in JReport Designer.
-
Build Semantic Layer Views for OneNote Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Microsoft OneNote.
-
Automated Continuous Tally Replication to MongoDB
Use CData Sync for automated, continuous, customizable Tally replication to MongoDB.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Oracle Database within intelligent workflows.
-
Use the CData Software JDBC Driver for YouTube Analytics in MicroStrategy Web
Connect to YouTube Analytics in MicroStrategy Web using the CData Software JDBC Driver for YouTube Analytics.
-
Access Asana 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 Asana.
-
Access Sage Intacct Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Sage Intacct from HeidiSQL.
-
Automate Pingdom Data Replication to Azure Data Lake
Use CData Sync to customize and automate Pingdom replication to Azure Data Lake.
-
Create API-Connected Nintex Workflows
Use CData Connect AI to connect to API Data from Nintex Workflow Cloud and build custom workflows using live API.
-
Build Dynamics 365 Business Central-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Dynamics 365 Business Central Data from Zoho Analytics and import live Dynamics 365 Business Central.
-
Moving Data from Freshservice to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Freshservice data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Use Dash to Build to Web Apps on Jira Data
Create Python applications that use pandas and Dash to build Jira-connected web apps.
-
Import Salesforce CRM Analytics Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Salesforce CRM Analytics Data and provide access to live Salesforce CRM Analytics for custom reports in the Power BI Service.
-
Connect to Grafana Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Grafana as an External Source in Dremio.
-
Visualize FHIR Data in Tableau
The CData ODBC driver for FHIR enables you integrate FHIR into Tableau dashboards.
-
How to create an RPA flow for Zuora Data in UiPath Studio
Use the Zuora ODBC Driver to create workflows that access real-time Zuora without any coding.
-
Access Live QuickBooks Time Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live QuickBooks Time from your Excel spreadsheets.
-
Build Data Flows from SQL Server to DB2 through SSIS
Easily push SQL Server data to DB2 using the CData SSIS Tasks for DB2.
-
How to integrate Sentry with Apache Airflow
Access and process Sentry in Apache Airflow using the CData JDBC Driver.
-
How to Visualize Klaviyo Data in Python with pandas
Use pandas and other modules to analyze and visualize live Klaviyo in Python.
-
Work with Live Asana Data in Power Query
Use CData Connect AI to connect to Asana and work with live Asana in Microsoft Power Query.
-
Connect to Paddle from a Connection Pool in WebLogic
Use the CData JDBC Driver for Paddle to connect to Paddle from Web applications running on WebLogic.
-
Automate Tasks in Power Automate Using the CData API Server
Automate eBay actions in Microsoft Flow — sending emails, posting to social media, or syncing CRM and ERP.
-
Use Dash to Build Web Apps on Snowflake Data via CData Connect AI
Build interactive Dash web apps on live Snowflake using pandas and the CData Connect AI Python SDK.
-
Enable the LeadDesk JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with LeadDesk.
-
Publish Teamgate-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Teamgate.
-
How to work with Hugging Face Data in Apache Spark using SQL
Access and process Hugging Face Data in Apache Spark using the CData Software JDBC Driver.
-
Create ShipStation-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to ShipStation Data from OutSystems and build custom enterprise apps using live ShipStation.
-
Automated Continuous Twitter Ads Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Twitter Ads replication to AlloyDB.
-
Create a Data Access Object for Avalara AvaTax Data using JDBI
A brief overview of creating a SQL Object API for Avalara AvaTax in JDBI.
-
Using the CData Software ODBC Driver for NASA in PyCharm
Connect to NASA as an ODBC data source in PyCharm using the CData Software ODBC Driver for NASA.
-
Connect to SAP Business One Data in NetBeans
Connect to SAP Business One in NetBeans with the data source configuration wizard.
-
Integrate Live Stripe Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Stripe to Blue Prism using the CData ODBC Driver for Stripe to create automated workflows for repetitive business tasks.
-
Connect to QuickBooks Online Data in RapidMiner
Integrate QuickBooks Online with standard components and data source configuration wizards in RapidMiner Studio.
-
Automated Continuous SuiteCRM Replication to SingleStore
Use CData Sync for automated, continuous, customizable SuiteCRM replication to SingleStore.
-
Visualize Okta Data in TIBCO Spotfire through ADO.NET
Integrate Okta into dashboards in TIBCO Spotfire.
-
Automated Continuous Google Sheets Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Google Sheets replication to Apache Kafka.
-
Query Parquet Data in ColdFusion
Write standard ColdFusion data access code to connect to Apache Parquet.
-
Build Agents in Relevance AI with Access to Live Square Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Square within intelligent agent workflows.
-
Publish SAP Ariba Source-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live SAP Ariba Source.
-
How to Access Splunk Data Using Entity Framework
This article shows how to access Splunk using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Create LinkedIn Dataflows on PowerBI.com
Connect to the CData Power BI Connector for LinkedIn from PowerBI.com to create Power BI Dataflows with real-time data.
-
How to import Oracle Sales Data into Apache Solr
Use the CData Software JDBC Driver for Oracle Sales in Data Import Handler and create an automated import of Oracle Sales to Apache Solr Enterprise Search platform.
-
Build Microsoft Planner-Powered Applications in Claude Code with CData MCP Server
Use the CData MCP Server for Microsoft Planner to explore live Microsoft Planner Data in Claude Code to assist with building Microsoft Planner-powered applications.
-
Access Discourse Data from MySQL in Amazon QuickSight
Connect to Discourse and build visualizations of Discourse using a MySQL Connection in Amazon QuickSight.
-
Integrate Live MailChimp Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to MailChimp from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live MailChimp.
-
Integrate with live CouchDB Data in Jitterbit
Use CData Connect AI to connect to and integrate live Apache CouchDB in Jitterbit.
-
Deploy the ADO.NET Provider for Figshare on an SSRS Report Server
Connect to Figshare 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 Connect DBeaver to Lakebase via a JDBC Driver
Manage Lakebase with visual tools in DBeaver like the query browser.
-
Access Zoho CRM Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Zoho CRM from HeidiSQL.
-
Build Adobe Analytics Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Adobe Analytics and build visualizations in Tableau.
-
Connect to Azure Analysis Services Data in DBeaver
Use the CData ODBC Driver to connect to Azure Analysis Services in DBeaver.
-
Enable the Act CRM JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Act CRM.
-
Automated Continuous SuiteCRM Replication to Amazon S3
Use CData Sync for automated, continuous, customizable SuiteCRM replication to Amazon S3.
-
Stream Delighted Data into Apache Kafka Topics
Access and stream Delighted in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Prepare, Blend, and Analyze Landbot Data in Alteryx Designer (ODBC)
Build workflows to access live Landbot for self-service data analytics.