CData Software - Knowledge Base
Recent Articles
-
How to use SQLAlchemy ORM to access Wrike Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Wrike data.
-
Build a Simple VCL Application for Amplitude Data
How to build a simple VCL Application to view Amplitude data in RAD Studio using the CData ODBC Driver for Amplitude.
-
How to Connect to Live Discord 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 Discord data through natural language.
-
Use the CData Software ODBC Driver for Sage Cloud Accounting in MicroStrategy
Connect to Sage Cloud Accounting data in MicroStrategy Developer using the CData Software ODBC Driver for Sage Cloud Accounting.
-
How to Build an ETL App for Sentry Data in Python with CData
Create ETL applications and real-time data pipelines for Sentry data in Python with petl.
-
Bridge ChargeOver Connectivity with Apache NiFi
Access and process ChargeOver data in Apache NiFi using the CData JDBC Driver.
-
How to publish and share PayPal Data dashboards with Tableau Server
The CData ODBC driver for PayPal enables you integrate PayPal data into Tableau dashboards.
-
Use Manus AI to Talk to Your BigCommerce Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Manus AI agents to securely answer questions and take actions on BigCommerce data.
-
How to create Databricks federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Databricks data in MySQL .
-
Connect to Act CRM 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 Act CRM data.
-
Prepare, Blend, and Analyze Trello Data in Alteryx Designer (Connect AI)
Build workflows to access live Trello data for self-service data analytics.
-
Build MVC Applications with Connectivity to Odoo Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Odoo from an ASP.NET MVC application.
-
Use Databricks Agent Bricks to Talk to Your Testmonitor Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Testmonitor data for you.
-
Natively Connect to Workday Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Workday data. Leverage the native support for ODBC in PHP.
-
Getting Started with the CData Tableau Connector for QuickBooks Online
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for QuickBooks Online.
-
Connect to Live Coda Data in MicroStrategy through CData Connect AI
Create a live connection to Coda Data in CData Connect AI and connect to your Coda data from MicroStrategy.
-
Automated Continuous API Replication to SQL Server
Use CData Sync for automated, continuous, customizable API replication to SQL Server.
-
Deploy the ADO.NET Provider for Copper on an SSRS Report Server
Connect to Copper 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.
-
Easily Integrate Qualaroo Data in Lazarus Pascal IDE
Learn how to easily integrate live Qualaroo data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Getting Started with the CData Excel Add-In for Microsoft Teams
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Microsoft Teams.
-
Trigger Wave Financial IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for Wave Financial with standard wizards in Logic Apps.
-
Connect and Query Live Twitter Ads Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Twitter Ads data into Databricks and enable direct, live querying and analysis without replication.
-
Connect to Live FHIR Data in MicroStrategy through CData Connect AI
Create a live connection to FHIR Data in CData Connect AI and connect to your FHIR data from MicroStrategy.
-
Automated Continuous Pinecone Replication to Vertica
Use CData Sync for automated, continuous, customizable Pinecone replication to Vertica.
-
Integrate with Zendesk Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Zendesk data to a JSON file on disk.
-
Automated Continuous Browserless Replication to Oracle
Use CData Sync for automated, continuous, customizable Browserless replication to Oracle.
-
Create Dashboards and Visualize Live Microsoft Entra ID Data in Geckoboard
Use CData Connect AI to connect to live Microsoft Entra ID data and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Connect to and Visualize Live CockroachDB Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live CockroachDB data.
-
A PostgreSQL Interface for Templated Data (MySQL Remoting via JDBC)
Use the Remoting features of the Templated JDBC Driver to create a PostgreSQL entry-point for data access.
-
Analyze SAP Concur Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze SAP Concur data with the CData JDBC Driver for SAP Concur.
-
Trigger WooCommerce IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for WooCommerce with standard wizards in Logic Apps.
-
Create Power BI Reports on Real-Time Spark Data
Use the CData ODBC Driver for Spark to visualize Spark data in Power BI Desktop.
-
Seamlessly Bring SAP Ariba Source Data into Retool Using CData Connect AI
Integrate SAP Ariba Source data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Build Charts with Autopilot Data in Clear Analytics
Create dynamic charts and perform analytics based on Autopilot data in Clear Analytics.
-
Automated Continuous HCL Domino Replication to SQL Server
Use CData Sync for automated, continuous, customizable HCL Domino replication to SQL Server.
-
How to create Visio diagrams from Stripe Data
Automatically update Stripe data with the changes you make to Visio master shapes.
-
Connect to Harvest Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Harvest as an External Source in Dremio.
-
Connect to JobNimbus Data in RazorSQL
Connect to JobNimbus from wizards and query JobNimbus data from the GUI in the RazorSQL database management tool.
-
Use the CData Software ODBC Driver for ChartMogul in MicroStrategy Web
Connect to ChartMogul data in MicroStrategy Web using the CData Software ODBC Driver for ChartMogul.
-
Visualize Foursquare Data in Tableau
The CData ODBC driver for Foursquare enables you integrate Foursquare data into Tableau dashboards.
-
Create Informatica Mappings From/To an ODBC Data Source for Hubstaff
Create an ODBC connection to Hubstaff in Informatica and browse and transfer Hubstaff data.
-
How to Work with Landbot Data in ETL Validator JDBC
Connect to Landbot from ETL Validator jobs using the CData Software JDBC Driver.
-
Getting Started with the CData JDBC Driver for Google Ad Manager
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Google Ad Manager.
-
Access Live Google Spanner Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Google Spanner data from your Google Sheets.
-
Migrating data from Trello to Google BigQuery using CData SSIS Components.
Easily push Trello data to Google BigQuery using the CData SSIS Tasks for Trello and Google BigQuery.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Clio
Provide connectivity to Clio data through an SAP BusinessObjects universe.
-
Automated Continuous Retently Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Retently replication to delimited files (CSV/TSV).
-
Connect to iContact Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for iContact Data and connect to iContact data in Akorbi Digital RunMyProcess.
-
Design BIRT Reports on DocuSign Data
Provide current DocuSign data to your embedded analytics.
-
Enable the Sendwithus JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Sendwithus data.
-
Migrating data from AfterShip to Databricks using CData SSIS Components.
Easily push AfterShip data to Databricks using the CData SSIS Tasks for AfterShip and Databricks.
-
Create Data Visualizations in Cognos BI with Epicor Kinetic Data
Access Epicor Kinetic data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Build Dashboards with Instantly Data in Dundas BI
Create dynamic dashboards and perform analytics based on Instantly data in Dundas BI.
-
Integrate with Jodoo Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Jodoo data to a JSON file on disk.
-
Replicate Multiple ServiceNow Accounts via the CData Sync CLI
Replicate multiple ServiceNow accounts to one or many databases.
-
Build Data Flows from Wistia to SQL Server using SSIS
Easily back up Wistia data to SQL Server using the SSIS components for Wistia.
-
Connect Presto Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Presto data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Analyze Bugsnag Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Bugsnag from Power Pivot. You will use the Table Import Wizard to load Bugsnag data. You can visually build the import query or use any SQL supported by the driver.
-
Build Epicor Kinetic Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Epicor Kinetic data and build visualizations in Tableau.
-
Getting Started with the CData JDBC Driver for Acumatica
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Acumatica.
-
Use ChatGPT to Talk to Your Azure Analysis Services 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 Azure Analysis Services data for you.
-
Integrating GitHub Copilot with Bullhorn CRM 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.
-
Publish Crystal Reports on Toggl Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Toggl data.
-
DataBind Charts to PolarTeamPro Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to PolarTeamPro data 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.
-
Analyze Live ZohoPeople Data in SAS Viya
Use CData Connect AI to connect to ZohoPeople data from SAS Viya and deploy self-service analytics using live ZohoPeople data.
-
Publish Billsby-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Billsby data.
-
Integrating Gumloop with QuickBooks Time Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on QuickBooks Time data within automated workflows.
-
Create Data Visualizations Based On Jumpseller Data in Mode
Use CData Connect AI to connect to Jumpseller Data from Mode and build visualizations using live Jumpseller data.
-
Access Discord 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 Discord data.
-
Integrate OpenCode with Live Notion Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable OpenCode to securely access and query live Notion data from within your AI coding agent.
-
Automated Continuous Microsoft Exchange Replication to SQL Server
Use CData Sync for automated, continuous, customizable Microsoft Exchange replication to SQL Server.
-
Build Data Flows from Xero to SQL Server using SSIS
Easily back up Xero data to SQL Server using the SSIS components for Xero.
-
Replicate Multiple Wrike Accounts via the CData Sync CLI
Replicate multiple Wrike accounts to one or many databases.
-
Replicate Multiple Adobe Analytics Accounts via the CData Sync CLI
Replicate multiple Adobe Analytics accounts to one or many databases.
-
Connect to and Query Dotmailer Data in QlikView over ODBC
Create data visualizations with Dotmailer data in QlikView.
-
Integrate with LightSpeedRetail Data in JReport Designer
Create charts and reports based on LightSpeedRetail data in JReport Designer.
-
Easily Integrate MessageBird Data in Lazarus Pascal IDE
Learn how to easily integrate live MessageBird data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Work with SAP Ariba Procurement Data in FoxPro
Load SAP Ariba Procurement data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Publish Reports with Clari Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Clari data.
-
Moving Data from Monday.com to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Monday.com data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Integrate Open WebUI with Live xBase Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live xBase data from within the chat interface.
-
Build a Simple VCL Application for Okta Data
How to build a simple VCL Application to view Okta data in RAD Studio using the CData ODBC Driver for Okta.
-
How to Connect to Live SAP Hybris C4C 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 SAP Hybris C4C data for you.
-
Connect to and Query Microsoft Ads Data in QlikView over ODBC
Create data visualizations with Microsoft Ads data in QlikView.
-
Use the CData ODBC Driver for Microsoft Dataverse in Microsoft Power Query
You can use the CData Microsoft Dataverse ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Microsoft Dataverse data into Microsoft Power Query.
-
How to Connect to Splunk Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Splunk data. Leverage the pyodbc module for ODBC in Python.
-
Getting Started with the CData Connect AI Python SDK for SingleStore
Install the CData Connect AI Python SDK to read and write live SingleStore data with standard DB-API 2.0 Python code.
-
Rapidly Develop Authorize.Net-Driven Apps with Active Query Builder
Leverage the Active Query Builder SQL interface and .NET data access to create data-driven WinForms and ASP.NET apps backed by Authorize.Net.
-
Integrate Google's Vertex AI Agent with Live Aweber 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 Aweber data within intelligent workflows.
-
Integrating Claude Code with Impala Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Impala data within assisted coding and automated development workflows.
-
Build Zoho Creator-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Zoho Creator data.
-
Use the CData Software ODBC Driver for Microsoft Exchange in MicroStrategy Web
Connect to Microsoft Exchange data in MicroStrategy Web using the CData Software ODBC Driver for Microsoft Exchange.
-
Visualize Live Simplesat Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Simplesat data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Query Unbounce Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Unbounce data from Node.js.
-
Create SSAS Tabular Models from SAP SuccessFactors LMS Data
How to build a SQL Server Analysis Service Tabular Model from SAP SuccessFactors LMS data using CData drivers.
-
Use Agno to Talk to Your Zoho CRM 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 Zoho CRM data for you.
-
Use the CData Software ODBC Driver for Sybase IQ in MicroStrategy Desktop
Connect to Sybase IQ data in MicroStrategy Desktop using the CData Software ODBC Driver for Sybase IQ.
-
Access Live SingleStore Data in TIBCO Data Virtualization
Use the SingleStore Tibco DV Adapter to create a SingleStore data data source in TIBCO Data Virtualization Studio and gain access to live SingleStore data from your TDV Server.
-
How to connect to ConstantContact Data from IntelliJ
Integrate connectivity to ConstantContact data with wizards in IntelliJ.
-
Access Authorize.Net Data from MySQL in Amazon QuickSight
Connect to Authorize.Net and build visualizations of Authorize.Net data using a MySQL Connection in Amazon QuickSight.