CData Software - Knowledge Base
Recent Articles
-
Use Dash to Build Web Apps on Asana Data via CData Connect AI
Build interactive Dash web apps on live Asana using pandas and the CData Connect AI Python SDK.
-
Automated Continuous WordPress Replication to IBM DB2
Use CData Sync for automated, continuous, customizable WordPress replication to IBM DB2.
-
Use Grok to Talk to Your NetSuite 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 NetSuite CRM & ERP for you.
-
How to Connect to Live Google Ad Manager Data from crewAI Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable crewAI agents to securely read and take actions on your Google Ad Manager for you.
-
How to import Raisers Edge NXT Data into Apache Solr
Use the CData Software JDBC Driver for Raisers Edge NXT in Data Import Handler and create an automated import of Raisers Edge NXT to Apache Solr Enterprise Search platform.
-
Migrating data from Toggl to Google BigQuery using CData SSIS Components.
Easily push Toggl to Google BigQuery using the CData SSIS Tasks for Toggl and Google BigQuery.
-
Create Apps from Trello Data in Qlik Sense Cloud
Use CData Connect AI to connect to Trello Data and build apps from live Trello in Qlik Sense Cloud.
-
Use the CData Software ODBC Driver for Unbounce in SAS for Real-Time Reporting and Analytics
Connect to real-time Unbounce in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Unbounce.
-
Build Apps with Live MailerSend Data Using the Low-Code Development Platform of Mendix
Connect MailerSend with Mendix to build apps using the CData API Driver for JDBC.
-
Connect to Miro Data Using the Script Function in Claris FileMaker Pro
Use the CData API Driver for ODBC and the Script function in FileMaker Pro to connect to Miro and work with Miro in your FileMaker application.
-
Automated Continuous FormSite Replication to Oracle
Use CData Sync for automated, continuous, customizable FormSite replication to Oracle.
-
Create Datasets from Missive in Domo Workbench and Build Visualizations of Missive Data in Domo
Use the CData Software ODBC Driver for Missive to create datasets from Missive in Domo Workbench and then build visualizations in the Domo service.
-
A PostgreSQL Interface for Flowlu Data using the CData ODBC Driver
Use the SQL Gateway and Flowlu ODBC Driver to create a PostgreSQL entry-point for data access.
-
Use Dash to Build to Web Apps on Tally Data
Create Python applications that use pandas and Dash to build Tally-connected web apps.
-
Query Instantly Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Instantly from Node.js.
-
How to Visualize Oracle Data in Python with pandas via CData Connect AI
Use the CData Connect AI Python SDK with pandas and Matplotlib to analyze and visualize live Oracle Database in Python.
-
How to Connect to Live Cosmos DB 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 Azure Cosmos DB for you.
-
Access Live Sybase Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Sybase in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Query Microsoft Dataverse Data as a MySQL Database in Node.js
Execute MySQL queries against Microsoft Dataverse (CDS) from Node.js.
-
Analyze Hubstaff Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Hubstaff from Power Pivot. You will use the Table Import Wizard to load Hubstaff. You can visually build the import query or use any SQL supported by the driver.
-
Moving Data from Mailgun to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Mailgun data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Connect ActiveCampaign Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your ActiveCampaign using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Getting Started with the CData JDBC Driver for SQL Server
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for SQL Server.
-
Build MongoDB-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for MongoDB Data and create custom apps in Mendix.
-
Stream TaxJar Data into Apache Kafka Topics
Access and stream TaxJar in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Build Greenplum-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Pivotal GreenPlum.
-
Automated Continuous Clio Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Clio replication to Apache Kafka.
-
How to Build an ETL App for Instagram Data in Python with CData
Create ETL applications and real-time data pipelines for Instagram in Python with petl.
-
Replicate Multiple JSON Accounts
Replicate multiple JSON accounts to one or many databases.
-
Configure the CData JDBC Driver for Optimizely in a Connection Pool in Tomcat
Connect to Optimizely from a connection pool in Tomcat.
-
Operational Reporting on ServiceDesk Plus Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote ServiceDesk Plus.
-
How to use SQLAlchemy ORM to access Xero Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Xero Accounting.
-
Server Certificate Verification Failed: Connection Aborted
This entry details the typical causes of the error and proposes solutions to resolve it.
-
Use the CData Software JDBC Driver for Salesloft in MicroStrategy
Connect to Salesloft in MicroStrategy Developer using the CData Software JDBC Driver for Salesloft.
-
Connect to and Visualize Live Google Search Results in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Google Search.
-
Bridge AgileCRM Connectivity with Apache NiFi
Access and process AgileCRM in Apache NiFi using the CData JDBC Driver.
-
Publish Omnisend-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Omnisend.
-
Connect to Attio Data in DBArtisan
Use wizards in DBArtisan to configure Attio as a data source.
-
Integrating OpenCode Terminal with Mouseflow 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.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for REST
Provide connectivity to REST through an SAP BusinessObjects universe.
-
Integrating Claude Code CLI with Outreach.io 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.
-
Enable the Datadog JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Datadog.
-
Build Dashboards with Okta Data in Dundas BI
Create dynamic dashboards and perform analytics based on Okta in Dundas BI.
-
Replicate Pingdom Data in Heroku for Use in Salesforce Connect
Replicate Pingdom to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Access SharePoint Excel Services Data from MySQL in PHP
Connect to SharePoint Excel Services through the standard MySQL libraries in PHP.
-
Publish Clio-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Clio.
-
Integrate with Outlook Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Outlook to a JSON file on disk.
-
Viewing Phoenix Data in RAD Studio Data Explorer
How to view Apache Phoenix in RAD Studio Data Explorer using the CData ODBC Driver for Phoenix.
-
Analyze IBM Informix Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for IBM Informix from Power Pivot. You will use the Table Import Wizard to load IBM Informix. You can visually build the import query or use any SQL supported by the driver.
-
How to load Tickspot data into Elasticsearch via Logstash
Introducing a simple method to load Tickspot data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Build Charts with SAS xpt Data in Clear Analytics
Create dynamic charts and perform analytics based on SAS XPORT in Clear Analytics.
-
How to Connect SAP BusinessObjects BI Data to Gemini Enterprise via CData Connect AI
Connect CData Connect AI Remote MCP to Gemini Enterprise to securely read and take actions on live SAP BusinessObjects BI data in real time using natural language.
-
Using the CData Software ODBC Driver for Toggl in PyCharm
Connect to Toggl as an ODBC data source in PyCharm using the CData Software ODBC Driver for Toggl.
-
How to import SAS xpt Data into Apache Solr
Use the CData Software JDBC Driver for SAS xpt in Data Import Handler and create an automated import of SAS XPORT to Apache Solr Enterprise Search platform.
-
Visualize LaunchDarkly Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to LaunchDarkly.
-
Analyze Zoho Inventory Data in Cognos Analytics
Use CData Connect AI to connect to Zoho Inventory Data from Cognos Analytics and analyze live Zoho Inventory.
-
How to Connect to Bitbucket Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Bitbucket. Leverage the pyodbc module for ODBC in Python.
-
Use the CData Software ODBC Driver for SAP Concur in SAS for Real-Time Reporting and Analytics
Connect to real-time SAP Concur in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for SAP Concur.
-
Creating Google Calendar-Connected Applications in Unqork
You can use CData Connect AI to feed Google Calendar to Unqork and build custom business apps.
-
Load SparkPost Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load SparkPost to a database.
-
Connect to Jira Data from Crystal Reports
Use CData Connect AI to connect to and report on live Atlassian Jira from Crystal Reports.
-
Rapidly Develop Google Ad Manager-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 Google Ad Manager.
-
How to integrate Metabase with Email Data
Use CData Connect AI to connect to live Email and create an interactive dashboard in Metabase from Email.
-
Connect to Excel Data in Ruby
Connect to Microsoft Excel in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Trigger SAP Ariba Source IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for SAP Ariba Source with standard wizards in Logic Apps.
-
How to Visualize Outreach.io Data in Python with pandas via CData Connect AI
Use the CData Connect AI Python SDK with pandas and Matplotlib to analyze and visualize live Outreach.io in Python.
-
Build AI Agents with Salesforce Data in IBM watsonx Orchestrate using CData Connect AI
Learn how to build intelligent agents in IBM watsonx Orchestrate that can securely access and act on live Salesforce & Force.com through CData Connect AI.
-
Integrating Claude Code with Google Ad Manager Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Google Ad Manager within assisted coding and automated development workflows.
-
Build Freshdesk-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData MCP Server for Freshdesk to explore live Freshdesk Data in GitHub Copilot to assist with building Freshdesk-powered applications.
-
Automated Continuous DocuSign Replication to SingleStore
Use CData Sync for automated, continuous, customizable DocuSign replication to SingleStore.
-
Use the CData Software ODBC Driver for MariaDB in MicroStrategy Desktop
Connect to MariaDB in MicroStrategy Desktop using the CData Software ODBC Driver for MariaDB.
-
DataBind Controls to Couchbase Data in Delphi
DataBind to Couchbase in Delphi with standard data access components and controls.
-
Automated Continuous Redis Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Redis replication to delimited files (CSV/TSV).
-
Build Browserless-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Browserless.
-
Integrate Live Salesforce Data 360 Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Salesforce Data 360 to Blue Prism using the CData ODBC Driver for Salesforce Data 360 to create automated workflows for repetitive business tasks.
-
Automated Continuous YouTube Analytics Replication to Databricks
Use CData Sync for automated, continuous, customizable YouTube Analytics replication to Databricks.
-
Create Sage Intacct-Connected Nintex Workflows
Use CData Connect AI to connect to Sage Intacct Data from Nintex Workflow Cloud and build custom workflows using live Sage Intacct.
-
WooCommerce Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on WooCommerce facts in real time.
-
DataBind Controls to Vimeo Data in C++Builder
DataBind to Vimeo in C++Builder with standard components and controls.
-
Automate Snapchat Ads Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live Snapchat Ads and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
How to Connect Flowise AI Agents to Live Box Data via CData Connect AI
Integrate Flowise AI with the CData Connect AI MCP Server to enable agents to securely query and act on live Box without replication.
-
How to Connect the Power BI Service to Avro: Complete Guide
Connect to the CData Software Power BI Connector for Avro from PowerBI.com to provide real-time Apache Avro across the organization.
-
Automated Teamwork Data Replication to Teradata
Use CData Sync to Customize and automate Teamwork replication to Teradata.
-
Connect to Freshdesk Data in Jaspersoft Studio
Execute SQL to remote Freshdesk in Jaspersoft Studio.
-
Connect to Live Twilio Data in MicroStrategy through CData Connect AI
Create a live connection to Twilio Data in CData Connect AI and connect to your Twilio from MicroStrategy.
-
Access Live Zoho Projects Data in Roo Code via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Roo Code agents to securely access and build applications with live Zoho Projects through MCP integration.
-
Connect to Real-Time Clockify Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Clockify in Power Apps.
-
Getting Started with the CData ADO.NET Provider for SAP HANA XS Advanced
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for SAP HANA XS Advanced.
-
How to Connect to Live Google Cloud Storage 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 Google Cloud Storage for you.
-
Automated Continuous Square Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Square replication to Azure SQL Database.
-
A PostgreSQL Interface for Codat Data using the CData ODBC Driver
Use the SQL Gateway and Codat ODBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to Microsoft Teams in SpagoBI
Create reports featuring live Microsoft Teams in SpagoBI Studio. Host Microsoft Teams reports on SpagoBI Server.
-
Model Databricks Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Databricks, enabling the direct import of real-time Databricks.
-
Connect to CapsuleCRM in SpagoBI
Create reports featuring live CapsuleCRM in SpagoBI Studio. Host CapsuleCRM reports on SpagoBI Server.
-
Replicate Clockify Data in Heroku for Use in Salesforce Connect
Replicate Clockify to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Query Snapchat Ads Data as a MySQL Database in Node.js
Execute MySQL queries against Snapchat Ads from Node.js.
-
Excel Spreadsheet Automation on RSS Feeds with the QUERY Formula
Pull data from RSS, automate spreadsheets, and more with the QUERY formula.
-
Automated Continuous Neo4J Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Neo4J replication to Azure SQL Database.
-
Prepare, Blend, and Analyze Scrapfly Data in Alteryx Designer (ODBC)
Build workflows to access live Scrapfly for self-service data analytics.
-
Build Microsoft OneDrive-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Microsoft OneDrive Data and create custom apps in Mendix.