CData Software - Knowledge Base
Recent Articles
-
Getting Started with the CData Connect AI Python SDK for MySQL
Install the CData Connect AI Python SDK to read and write live MySQL with standard DB-API 2.0 Python code.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live IBM Informix within intelligent workflows.
-
Build a Singer.io Tap for Snowflake With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Snowflake data using
-
Validate Aweber Data with QuerySurge
Access and validate Aweber in QuerySurge using the CData JDBC Driver.
-
Integrating GitHub Copilot CLI with Guru 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.
-
Seamlessly Bring DocuSign Data into Retool Using CData Connect AI
Integrate DocuSign data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Build Semantic Layer Views for eBay Analytics Data in APOS Live Data Gateway
Use the CData Connector for eBay Analytics in APOS Live Data Gateway to build Semantic Layer Views for eBay Analytics.
-
Use JayDeBeApi to access SAP HANA Data in Python
Use standard Python scripting and the development environment of your choice to access live SAP HANA.
-
How to create Vercel federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Vercel in MySQL .
-
How to load Gong data into Elasticsearch via Logstash
Introducing a simple method to load Gong data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Publish Crystal Reports on Dynamics 365 Business Central Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Dynamics 365 Business Central.
-
Create Power BI Reports on Real-Time ServiceDesk Plus Data
Use the CData ODBC Driver for ServiceDesk Plus to visualize ServiceDesk Plus in Power BI Desktop.
-
Integrate Live Apify Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Apify to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Use the CData Software ODBC Driver for Sybase in MicroStrategy Desktop
Connect to Sybase in MicroStrategy Desktop using the CData Software ODBC Driver for Sybase.
-
Automated Continuous Microsoft Planner Replication to MongoDB
Use CData Sync for automated, continuous, customizable Microsoft Planner replication to MongoDB.
-
Publish LinkedIn-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live LinkedIn.
-
Build an OLAP Cube in SSAS from Billsby Data
Establish a connection to Billsby data from SQL Server Analysis Services, and use the Billsby Data Provider to build OLAP cubes for use in analytics and reporting.
-
Automate Zoho Inventory Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live Zoho Inventory and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
Prepare, Blend, and Analyze SAP Netweaver Gateway Data in Alteryx Designer (Connect AI)
Build workflows to access live SAP Netweaver Gateway for self-service data analytics.
-
How to Query Live GitLab Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live GitLab data in natural language using Python.
-
Integrating Antigravity CLI with Invoiced via CData CLI
Connect Invoiced to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Connect to and Visualize Live LinkedIn Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live LinkedIn.
-
Build Apps with Live Microsoft Ads in Adalo using CData Connect AI
Use CData Connect AI to integrate live Microsoft Ads into the Adalo platform and build custom mobile and web applications with real-time Microsoft Ads.
-
How to Build an ETL App for Highrise Data in Python with CData Connect AI
Build ETL pipelines that read and write live Highrise CRM in Python with petl and the CData Connect AI Python SDK.
-
Build Facebook-Connected Apps in Choreo
Use CData Connect AI to connect to Facebook Data from Choreo and build custom apps using live Facebook.
-
How to connect to Strava Data from IntelliJ
Integrate connectivity to Strava with wizards in IntelliJ.
-
Easily Integrate Outlook Data in Lazarus Pascal IDE
Learn how to easily integrate live Outlook in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Prepare, Blend, and Analyze Highrise Data in Alteryx Designer (ODBC)
Build workflows to access live Highrise CRM for self-service data analytics.
-
Integrating GitHub Copilot CLI with ShipEngine 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.
-
How to Connect the Power BI Service to Opsgenie: Complete Guide
Connect to the CData Software Power BI Connector for Opsgenie from PowerBI.com to provide real-time Opsgenie across the organization.
-
Use JayDeBeApi to access LightSpeedRetail Data in Python
Use standard Python scripting and the development environment of your choice to access live LightSpeedRetail.
-
Establish a Live Connection with SageHR Data using Tableau Bridge
The CData ODBC Driver for SageHR enables you to integrate live SageHR into Tableau Cloud dashboards using the Tableau Bridge.
-
Access Live EnterpriseDB Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live EnterpriseDB from your Excel spreadsheets.
-
Operational Reporting on AdRoll Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote AdRoll.
-
Connect Aircall to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Aircall with IBM WebSphere for seamless data integration and connectivity.
-
Connect to Pipedrive Data from PowerBuilder via JDBC
This article demonstrates how to access Pipedrive from PowerBuilder using the Pipedrive JDBC Driver.
-
Access Live Recurly Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Recurly into the statistical analysis tools available in SAS JMP. This article shows how to use Recurly in the Graph Builder and Query Builder.
-
Getting Started with the CData ODBC Driver for Salesforce Pardot
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Salesforce Pardot.
-
Getting Started with the CData Excel Add-In for Reckon Accounts Hosted
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Reckon Accounts Hosted.
-
Query SAS xpt Data as a MySQL Database in Node.js
Execute MySQL queries against SAS XPORT from Node.js.
-
Build Jira-Powered Applications in Gemini Code Assist with CData MCP Server
Use the CData MCP Server for Jira to explore live Jira Data in Gemini Code Assist to assist with building Jira-powered applications.
-
Enable the Facebook JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Facebook.
-
Use Grok to Talk to Your Dynamics 365 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 Microsoft Dynamics 365 for you.
-
How to connect SharePoint with RSS Feeds through external lists
Provide RSS Feeds to SharePoint users as an external list.
-
Replicate SAP Data to Multiple Databases via the CData Sync CLI
Replicate SAP ERP/NetWeaver to disparate databases with a single configuration.
-
Access Live Acumatica Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Acumatica ERP from your Excel spreadsheets.
-
Replicate ServiceNow Data to Multiple Databases
Replicate ServiceNow to disparate databases with a point-and-click configuration.
-
How to publish and share Parallel Data dashboards with Tableau Server
The CData ODBC driver for Parallel enables you integrate Parallel into Tableau dashboards.
-
Visualize Testmonitor Data in TIBCO Spotfire through ADO.NET
Integrate Testmonitor into dashboards in TIBCO Spotfire.
-
Analyze Excel Online Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Excel Online from Power Pivot. You will use the Table Import Wizard to load Microsoft Excel Online. You can visually build the import query or use any SQL supported by the driver.
-
Building Dynamic Web Pages with IBM Informix Data Using AngularJS
Create single-page applications with live connectivity to IBM Informix using the CData API Server.
-
ETL MySQL in Oracle Data Integrator
This article shows how to transfer MySQL into a data warehouse using Oracle Data Integrator.
-
Import Real-Time Access Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Microsoft Access in ColdFusion.
-
Work with ZohoDesk Data in FoxPro
Load ZohoDesk into a FoxPro database. This article includes full code and a walk-through of the process.
-
How to connect PolyBase to Front
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Front.
-
Query Jumpseller Data in DataGrip
Create a Data Source for Jumpseller in DataGrip and use SQL to query live Jumpseller.
-
How to update Airtable from Excel
This article explains how to transfer data from Excel to Airtable using the Excel Add-In for Airtable.
-
Analyze MarkLogic Data in Looker
Use CData Connect AI to connect to MarkLogic Data from Looker and build custom apps using live MarkLogic.
-
Connect and Query Live Jira Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Atlassian Jira into Databricks
-
Use the CData SSIS Components to Insert New or Update Existing BigQuery Records from SQL Server
Easily push SQL Server data to BigQuery using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into BigQuery or update existing records with data from a SQL Server database.
-
How to Connect DBeaver to Copper via a JDBC Driver
Manage Copper with visual tools in DBeaver like the query browser.
-
How to connect Amazon QuickSight to Zendesk Data
Create a connection to Zendesk in CData Connect AI and insert Zendesk into Amazon QuickSight SPICE to build interactive dashboards.
-
Visualize Live Act CRM Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Act CRM into custom reports in Power BI.
-
Integrate with Dynamics 365 Business Central Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Dynamics 365 Business Central in SnapLogic.
-
Connect ShipEngine to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect ShipEngine with IBM WebSphere for seamless data integration and connectivity.
-
Visualize Helpscout Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Helpscout.
-
Stream SAP HANA Data into Apache Kafka Topics
Access and stream SAP HANA in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
How to work with Freshdesk Data in Apache Spark using SQL
Access and process Freshdesk Data in Apache Spark using the CData Software JDBC Driver.
-
Automated Continuous Outreach.io Replication to Snowflake
Use CData Sync for automated, continuous, customizable Outreach.io replication to Snowflake.
-
Integrating Dataiku with Cassandra Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Apache Cassandra.
-
Build Visualizations of Google Search Results in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Google Search in Birst.
-
Integrate Live Power BI XMLA Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Power BI XMLA and integrate live Power BI XMLA into apps built in Microsoft Power Apps.
-
Build Trello-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Trello and build web apps with connectivity to live Trello.
-
Automated Zuora Data Replication to Teradata
Use CData Sync to Customize and automate Zuora replication to Teradata.
-
Integrate Goose with Live Amazon DynamoDB Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Amazon DynamoDB from within the local AI agent.
-
Connect to ZohoMarketingHub Data from PowerBuilder via ADO.NET
This article demonstrates how to access ZohoMarketingHub from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Visualize Office 365 Data in Sisense
Create an ElastiCube in Sisense app with access to Microsoft Office 365.
-
Connect to and Query CampaignMonitor Data in QlikView over ODBC
Create data visualizations with CampaignMonitor in QlikView.
-
Connect and Query Live QuickBooks Online Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live QuickBooks Online into Databricks
-
Connect to Slack Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Slack as an External Source in Dremio.
-
Replicate Multiple Workday Accounts via the CData Sync CLI
Replicate multiple Workday accounts to one or many databases.
-
Visualize Live ConvertAPI Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live ConvertAPI.
-
Automated Continuous PivotalTracker Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable PivotalTracker replication to Azure SQL Database.
-
Connect to PayPal Data from a Connection Pool in JBoss
Integrate PayPal into Java servlets: Use the Management Console in JBoss to install the PayPal JDBC Driver.
-
Use the CData Software JDBC Driver for JobNimbus in MicroStrategy Web
Connect to JobNimbus in MicroStrategy Web using the CData Software JDBC Driver for JobNimbus.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for CSV
Provide connectivity to CSV/TSV Files through an SAP BusinessObjects universe.
-
Automated Continuous Box Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Box replication to delimited files (CSV/TSV).
-
Design BIRT Reports on ElevenLabs Data
Provide current ElevenLabs to your embedded analytics.
-
Build Voice Agents in ElevenLabs with access to Live Dynamics 365 Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Microsoft Dynamics 365.
-
Integrate Open WebUI with Live Email Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Email from within the chat interface.
-
How to Build an ETL App for Webflow Data in Python with CData
Create ETL applications and real-time data pipelines for Webflow in Python with petl.
-
How to Connect DBeaver to Databricks via a JDBC Driver
Manage Databricks with visual tools in DBeaver like the query browser.
-
Use the CData Software ODBC Driver for HCL Domino in MicroStrategy Desktop
Connect to HCL Domino in MicroStrategy Desktop using the CData Software ODBC Driver for HCL Domino.
-
DataBind ChartMogul Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide ChartMogul to a chart.
-
DataBind Charts to Paylocity Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Paylocity 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.
-
Use the CData Software JDBC Driver for Ontraport in MicroStrategy Web
Connect to Ontraport in MicroStrategy Web using the CData Software JDBC Driver for Ontraport.
-
Connect CouchDB to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect CouchDB with IBM WebSphere for seamless data integration and connectivity.
-
Integrate Cursor with Live Freshdesk Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Freshdesk from within the editor.
-
How to connect to Jira Assets Data with Squirrel SQL client
Connect to Jira Assets and execute queries in the Squirrel SQL Client.
-
Automated Continuous Ontraport Replication to MySQL
Use CData Sync for automated, continuous, customizable Ontraport replication to MySQL.