CData Software - Knowledge Base
Recent Articles
-
Use the CData Software ODBC Driver for Miro in SAS for Real-Time Reporting and Analytics
Connect to real-time Miro data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Miro.
-
Connect to Front Data in CloverDX (formerly CloverETL)
Transfer Front data using the visual workflow in the CloverDX data integration tool.
-
Moving Data from Microsoft Teams to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Microsoft Teams data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Getting Started with the CData SSIS Components for Freshdesk
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Freshdesk.
-
Viewing Accelo Data in RAD Studio Data Explorer
How to view Accelo data in RAD Studio Data Explorer using the CData ODBC Driver for Accelo.
-
A PostgreSQL Interface for Airtable Data (MySQL Remoting via JDBC)
Use the Remoting features of the Airtable JDBC Driver to create a PostgreSQL entry-point for data access.
-
Write a Simple Go Application to work with IBM Informix Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to IBM Informix data.
-
Integrate with Adobe Experience Manager Data in JReport Designer
Create charts and reports based on Adobe Experience Manager data in JReport Designer.
-
Connect to and Query Zuora Data in QlikView over ODBC
Create data visualizations with Zuora data in QlikView.
-
Access Azure Synapse Data from MySQL in Amazon QuickSight
Connect to Azure Synapse and build visualizations of Azure Synapse data using a MySQL Connection in Amazon QuickSight.
-
Integrating LlamaIndex with Tavily Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Tavily data in real time.
-
Getting Started with the CData Power BI Connector for Mistral AI
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Use the CData Software JDBC Driver for Zoho Books in MicroStrategy Desktop
Connect to Zoho Books data in MicroStrategy Desktop using the CData Software JDBC Driver for Zoho Books.
-
Query Amplitude Data as a MySQL Database in Node.js
Execute MySQL queries against Amplitude data from Node.js.
-
Build a Simple VCL Application for Stripe Data
How to build a simple VCL Application to view Stripe data in RAD Studio using the CData ODBC Driver for Stripe.
-
Replicate Printify Data from PowerShell
Write a quick PowerShell script to query Printify data. Use connectivity to the live data to replicate Printify data to SQL Server.
-
Build an OLAP Cube in SSAS from Aweber Data
Establish a connection to Aweber data data from SQL Server Analysis Services, and use the Aweber Data Provider to build OLAP cubes for use in analytics and reporting.
-
Build a Singer.io Tap for IBM Informix With the CData Python Connector
Learn how to easily build a Singer.io Tap for live IBM Informix data using the CData Python Connector.
-
Connect to Bannerbear Data in HULFT Integrate
Connect to Bannerbear as a JDBC data source in HULFT Integrate
-
Import Confluence Data Using Azure Data Factory
Use CData Connect AI to connect to Confluence Data from Azure Data Factory and import live Confluence data.
-
Use JayDeBeApi to access Freshdesk Data in Python
Use standard Python scripting and the development environment of your choice to access live Freshdesk data.
-
Automated Continuous SendInBlue Replication to Snowflake
Use CData Sync for automated, continuous, customizable SendInBlue replication to Snowflake.
-
Build LinkedIn-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to LinkedIn Data from Zoho Analytics and import live LinkedIn data.
-
Connect to Klaviyo Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Klaviyo data.
-
Connect to Telegram Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to Telegram.
-
Bridge OData Connectivity with Apache NiFi
Access and process OData services in Apache NiFi using the CData JDBC Driver.
-
Import CapsuleCRM Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to CapsuleCRM Data and provide access to live CapsuleCRM data for custom reports in the Power BI Service.
-
Integrate Live Mixpanel Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Mixpanel data to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
How to Work with Freshdesk Data in ETL Validator JDBC
Connect to Freshdesk from ETL Validator jobs using the CData Software JDBC Driver.
-
DataBind Controls to Jumpseller Data in Delphi
DataBind to Jumpseller data in Delphi with standard data access components and controls.
-
Using the CData Software ODBC Driver for ConvertKit in PyCharm
Connect to ConvertKit as an ODBC data source in PyCharm using the CData Software ODBC Driver for ConvertKit.
-
Integrate Live Rebilly Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Rebilly data to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Excel Spreadsheet Automation on Ontraport Data with the QUERY Formula
Pull data from Ontraport, automate spreadsheets, and more with the QUERY formula.
-
Access Live SFTP Data in Excel 365 Online (Excel for the web)
Connect to SFTP data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Migrating data from Keap to Google BigQuery using CData SSIS Components.
Easily push Keap data to Google BigQuery using the CData SSIS Tasks for Keap and Google BigQuery.
-
Create Data Visualizations Based On Presto Data in Mode
Use CData Connect AI to connect to Presto Data from Mode and build visualizations using live Presto data.
-
Connect to Grafana Data in Aqua Data Studio
Access Grafana data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
How to Build an ETL App for GitHub Data in Python with CData
Create ETL applications and real-time data pipelines for GitHub data in Python with petl.
-
Automate Aircall Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Aircall data from PowerShell? This article demonstrates how to utilize the Aircall Cmdlets for tasks like connecting to Aircall data, automating operations, downloading data, and more.
-
Create Informatica Mappings From/To a JDBC Data Source for Jumpseller
Create Jumpseller data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Create Reports with MarkLogic Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date MarkLogic data.
-
Build Pipelines with Live Figshare Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Figshare from Google Cloud Data Fusion, enabling the integration of live Figshare data into the building and management of effective data pipelines.
-
Use the CData Software ODBC Driver for FHIR in MicroStrategy
Connect to FHIR data in MicroStrategy Developer using the CData Software ODBC Driver for FHIR.
-
Connect to Suadeo Data in DBeaver
Use the CData ODBC Driver to connect to Suadeo data in DBeaver.
-
Excel Spreadsheet Automation on Pipeliner CRM Data with the QUERY Formula
Pull data from Pipeliner CRM, automate spreadsheets, and more with the QUERY formula.
-
Access Live ConvertKit Data in AWS Lambda
Connect to live ConvertKit data in AWS Lambda using the CData JDBC Driver.
-
Integrate with Supabase Data in JReport Designer
Create charts and reports based on Supabase data in JReport Designer.
-
Migrating data from ClickTime to Databricks using CData SSIS Components.
Easily push ClickTime data to Databricks using the CData SSIS Tasks for ClickTime and Databricks.
-
How to Visualize Billsby Data in Python with pandas
Use pandas and other modules to analyze and visualize live Billsby data in Python.
-
Use the CData Software ODBC Driver for Invoiced in MicroStrategy
Connect to Invoiced data in MicroStrategy Developer using the CData Software ODBC Driver for Invoiced.
-
Integrating Claude Code CLI with Cloudflare 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.
-
Build Voice Agents in ElevenLabs with access to Live Exact Online Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Exact Online data.
-
How to Access Live Gumroad Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Gumroad enables you to integrate Gumroad data into workflows built using Microsoft Power Automate Desktop.
-
Automated Continuous Gong Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Gong replication to Google BigQuery.
-
Create Square-Connected Nintex Workflows
Use CData Connect AI to connect to Square Data from Nintex Workflow Cloud and build custom workflows using live Square data.
-
Visualize Live eBay Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live eBay data into custom reports in Power BI.
-
How to use SQLAlchemy ORM to access Microsoft Entra ID Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Microsoft Entra ID data.
-
Create Dynamic Splunk Grids Using the Infragistics XamDataGrid
Learn how you can connect Splunk to Infragistics XamDataGrid to build dynamic grids.
-
Connect to Superchat Data in DBeaver
Use the CData ODBC Driver to connect to Superchat data in DBeaver.
-
How to connect to SharePoint Excel Services Data from Spring Boot
Connect to SharePoint Excel Services in a Spring Boot Application using the CData JDBC Driver for SharePoint Excel Services
-
Integrate Testmonitor with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Testmonitor with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Testmonitor data.
-
How to use SQLAlchemy ORM to access Email Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Email data.
-
Query SAP Fieldglass Data as a MySQL Database in Node.js
Execute MySQL queries against SAP Fieldglass data from Node.js.
-
How to Connect to Live MarkLogic 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 MarkLogic data for you.
-
Feed LightSpeedRetail Data into FineReport
How to set LightSpeedRetail data as a JDBC data source in FineReport.
-
Choosing the Best Method to Connect Odoo to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Odoo data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Use Dash to Build Web Apps on eBay Data via CData Connect AI
Build interactive Dash web apps on live eBay data using pandas and the CData Connect AI Python SDK.
-
Connect to and Query Klaviyo Data in QlikView over ODBC
Create data visualizations with Klaviyo data in QlikView.
-
ETL ZarMoney in Oracle Data Integrator
This article shows how to transfer ZarMoney data into a data warehouse using Oracle Data Integrator.
-
Use Dash to Build to Web Apps on Hugging Face Data
Create Python applications that use pandas and Dash to build Hugging Face-connected web apps.
-
Connect to Typeform Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Typeform as an External Source in Dremio.
-
Automated Continuous Egnyte Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Egnyte replication to Google Cloud SQL.
-
Integrating Antigravity CLI with Typeform data via CData CLI
Connect Typeform data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Connect Vimeo to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Vimeo data using the CData Python MCP Server.
-
How to Connect to & Open SingleStore Data in Microsoft Excel
This article uses the CData ODBC driver for SingleStore to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Model Microsoft OneDrive Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Microsoft OneDrive, enabling the direct import of real-time Microsoft OneDrive data.
-
Getting Started with the CData Excel Add-In for SendGrid
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for SendGrid.
-
Build BigQuery Visualizations in Tableau Cloud
Use CData Connect AI to connect to live BigQuery data and build visualizations in Tableau Cloud.
-
How to Query Timely Data in MySQL Workbench
Execute MySQL queries against live Timely data from MySQL Workbench.
-
Bind Live Salesforce Pardot Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Salesforce Pardot data and seamlessly connect and bind them to Wijmo's FlexGrid for real-time, interactive data access without manual data movement.
-
CData Sync Enhances Snowflake Integration with Optimized High Volume Data Handling
Learn how to optimize Snowflake data replication in CData Sync 24.3 using the new optimized option, boosting performance for high-volume data transfers.
-
Work with Acumatica Data in FoxPro
Load Acumatica data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Use the CData Software JDBC Driver for IBM Informix in MicroStrategy
Connect to IBM Informix data in MicroStrategy Developer using the CData Software JDBC Driver for IBM Informix.
-
Connect to Helpscout Data in NetBeans
Connect to Helpscout data in NetBeans with the data source configuration wizard.
-
Automated Continuous Dynamics 365 Business Central Replication to SQL Server
Use CData Sync for automated, continuous, customizable Dynamics 365 Business Central replication to SQL Server.
-
Replicate Snapchat Ads Data in Heroku for Use in Salesforce Connect
Replicate Snapchat Ads data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Access Live PagerDuty Data in AWS Lambda (with IntelliJ IDEA)
Connect to live PagerDuty data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
How to integrate Clari with Apache Airflow
Access and process Clari data in Apache Airflow using the CData JDBC Driver.
-
Using the CData Software ODBC Driver for SAP HANA XS Advanced in PyCharm
Connect to SAP HANA XS Advanced as an ODBC data source in PyCharm using the CData Software ODBC Driver for SAP HANA XS Advanced.
-
Connect to xBase Data in HULFT Integrate
Connect to xBase as a JDBC data source in HULFT Integrate
-
Work with SAS xpt Data in FoxPro
Load SAS xpt data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Automated Continuous Rootly Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Rootly replication to IBM DB2.
-
Connect Freshdesk Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Freshdesk data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Integrate Google's Vertex AI Agent with Live Google Spanner Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Google Spanner data within intelligent workflows.
-
Connect to Xero Data in RazorSQL
Connect to Xero from wizards and query Xero data from the GUI in the RazorSQL database management tool.
-
Connecting Moonlit Workflow with Reckon 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 Reckon data in real time.
-
Configure the CData JDBC Driver for Cassandra in a Connection Pool in Tomcat
Connect to Cassandra data from a connection pool in Tomcat.
-
Connect to and Visualize Live Timely Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Timely data.
-
Connect to Optimizely Data in Jaspersoft Studio
Execute SQL to remote Optimizely data in Jaspersoft Studio.
-
A PostgreSQL Interface for Demio Data (MySQL Remoting via JDBC)
Use the Remoting features of the Demio JDBC Driver to create a PostgreSQL entry-point for data access.