CData Software - Knowledge Base
Recent Articles
-
Connect to ActiveCampaign from a Connection Pool in WebLogic
Use the CData JDBC Driver for ActiveCampaign to connect to ActiveCampaign from Web applications running on WebLogic.
-
Build Apps with Live MongoDB in Adalo using CData Connect AI
Use CData Connect AI to integrate live MongoDB into the Adalo platform and build custom mobile and web applications with real-time MongoDB.
-
Connect to OData Services from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for OData to connect to OData and execute queries in PowerBuilder.
-
Use the CData Software JDBC Driver for Coda in MicroStrategy Desktop
Connect to Coda in MicroStrategy Desktop using the CData Software JDBC Driver for Coda.
-
Access Live Jumpseller Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Jumpseller into the statistical analysis tools available in SAS JMP. This article shows how to use Jumpseller in the Graph Builder and Query Builder.
-
How to Query Live Salesforce Marketing Data in Claude Desktop
Connect to and query live Salesforce Marketing Data in Claude Desktop using CData MCP Server.
-
Automated Continuous CockroachDB Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable CockroachDB replication to PostgreSQL.
-
How to Connect to Live MarkLogic Data in Mistral AI Workflows
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live MarkLogic without replication.
-
Build Dashboards with Contentful Data in DBxtra
Create dynamic dashboards and perform analytics based on Contentful in DBxtra.
-
How to use SQLAlchemy ORM to access Act-On Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Act-On.
-
Integrate EmailOctopus Data in the Pentaho Report Designer
Publish reports based on EmailOctopus in the Pentaho BI tool.
-
Automated Continuous HubSpot Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable HubSpot replication to PostgreSQL.
-
Analyze Power BI XMLA Data in Cognos Analytics
Use CData Connect AI to connect to Power BI XMLA Data from Cognos Analytics and analyze live Power BI XMLA.
-
Build Procore-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Procore Data and create custom apps in Bubble.
-
Hacker News Reporting in OBIEE with the Hacker News JDBC Driver
Deploy the Hacker News JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Connect to Mixpanel Data in Aqua Data Studio
Access Mixpanel from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
How to Work with Google Translate Data in AWS Glue Jobs Using JDBC
Connect to Google Translate from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Integrate Google Translate Data in Pentaho Data Integration
Build ETL pipelines based on Google Translate in the Pentaho Data Integration tool.
-
Connect to Teradata Data in JRuby
Create a simple JRuby app with access to live Teradata.
-
Integrate with Guru Data in JReport Designer
Create charts and reports based on Guru in JReport Designer.
-
Automated Continuous Zuora Replication to Vertica
Use CData Sync for automated, continuous, customizable Zuora replication to Vertica.
-
How to Connect to & Open Planio Data in Microsoft Excel
This article uses the CData ODBC driver for Planio to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Build AI/ML Models with Live Accelo Data using Dataiku
Connect Accelo Data with Dataiku using the CData API Driver for JDBC.
-
Access Live Pipeline CRM Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Pipeline CRM in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
DataBind Charts to HBase Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Apache HBase 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.
-
Extend Google Sheets with HubSpot Data
Make calls to HubSpot from Google Apps Script via the API Server.
-
How to integrate Paylocity with Apache Airflow
Access and process Paylocity in Apache Airflow using the CData JDBC Driver.
-
Integrating Claude Code CLI with Zoom 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.
-
Integrate with BigCommerce Data in JReport Designer
Create charts and reports based on BigCommerce in JReport Designer.
-
How to connect to Short.io Data with Squirrel SQL client
Connect to Short.io and execute queries in the Squirrel SQL Client.
-
Model ServiceNow Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and ServiceNow, enabling the direct import of real-time ServiceNow.
-
Build Semantic Layer Views for Aweber Data in APOS Live Data Gateway
Use the CData Connector for Aweber in APOS Live Data Gateway to build Semantic Layer Views for Aweber.
-
Automated Continuous Freshservice Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Freshservice replication to Google Cloud SQL.
-
How to load SAP data into Elasticsearch via Logstash
Introducing a simple method to load SAP data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Excel Spreadsheet Automation on Notion Data with the QUERY Formula
Pull data from Notion, automate spreadsheets, and more with the QUERY formula.
-
Connect Klipfolio Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Klipfolio using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Create Blackbaud FE NXT-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Blackbaud FE NXT Data from OutSystems and build custom enterprise apps using live Blackbaud FE NXT.
-
Create PayPal Dataflows on PowerBI.com
Connect to the CData Power BI Connector for PayPal from PowerBI.com to create Power BI Dataflows with real-time data.
-
Access Live Google Campaign Manager 360 Data in Excel 365 Online (Excel for the web)
Connect to Google Campaign Manager 360 from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Replicate ShipStation Data from PowerShell
Write a quick PowerShell script to query ShipStation. Use connectivity to the live data to replicate ShipStation to SQL Server.
-
Moving Data from Adobe Commerce to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Adobe Commerce data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Build AI Agents with Snowflake 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 Snowflake through CData Connect AI.
-
How to Seamlessly Import SharePoint Data into IBM SPSS Modeler
Integrate SharePoint data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Build Xero-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Xero Accounting.
-
Add Paddle Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Paddle with the Informatica Enterprise Data Catalog to classify and organize data.
-
Integrate Figshare Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Figshare from Informatica Cloud.
-
Natively Connect to Campaigner Data in PHP
The CData ODBC driver for Campaigner enables you to create PHP applications with connectivity to Campaigner. Leverage the native support for ODBC in PHP.
-
Access Live Act-On Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Act-On into the statistical analysis tools available in SAS JMP. This article shows how to use Act-On in the Graph Builder and Query Builder.
-
Connect to Google Contacts Data from AWS Glue
Use CData Connect AI to gain access to live Google Contacts from your AWS Glue jobs.
-
Query PabblySubscriptions Data in ColdFusion
Write standard ColdFusion data access code to connect to PabblySubscriptions.
-
Getting Started with the CData Excel Add-In for PDFMonkey
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for PDFMonkey.
-
Integrate with JobNimbus Data in JReport Designer
Create charts and reports based on JobNimbus in JReport Designer.
-
Manage Insightly Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Insightly.
-
Access Live Jira Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Atlassian Jira from your Excel spreadsheets.
-
Connect to Cloudflare Data from PowerBuilder via ADO.NET
This article demonstrates how to access Cloudflare from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Explore Geographical Relationships in Adobe Analytics Data with Power Map
Create data visualizations with Adobe Analytics in Power Map.
-
Build Bullhorn CRM-Connected Apps in Choreo
Use CData Connect AI to connect to Bullhorn CRM Data from Choreo and build custom apps using live Bullhorn CRM.
-
Integrate Live JSON Services into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to JSON from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live JSON.
-
Working with Bright Data Data in LINQPad
Execute LINQ queries to Bright Data in LINQPad.
-
Automated Continuous SpaceX Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable SpaceX replication to OneLake in Microsoft Fabric.
-
Connect to Datadog in SpagoBI
Create reports featuring live Datadog in SpagoBI Studio. Host Datadog reports on SpagoBI Server.
-
Salesforce Pardot Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Salesforce Pardot through CData Connect AI using different applications and tools.
-
Automated Continuous AlloyDB Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable AlloyDB replication to Azure SQL Database.
-
Integrate Zuora with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Zuora with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Zuora.
-
Integrate with live ActiveCampaign Data in Jitterbit
Use CData Connect AI to connect to and integrate live ActiveCampaign in Jitterbit.
-
DataBind Charts to Nuclia Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Nuclia 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.
-
Prepare, Blend, and Analyze Zoho Books Data in Alteryx Designer (Connect AI)
Build workflows to access live Zoho Books for self-service data analytics.
-
Build Data Flows from ConvertAPI to SQL Server using SSIS
Easily back up ConvertAPI to SQL Server using the SSIS components for ConvertAPI.
-
Getting Started with the CData Python Connector for Salesforce CRM Analytics
Learn to install and license the CData Python Connector
-
Use the CData Software JDBC Driver for Rootly in MicroStrategy Web
Connect to Rootly in MicroStrategy Web using the CData Software JDBC Driver for Rootly.
-
Write a Simple Go Application to work with Facebook Ads Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Facebook Ads.
-
Connect to and Query Shopify Data in QlikView over ODBC
Create data visualizations with Shopify in QlikView.
-
How to Connect to Live Asana 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 Asana for you.
-
Query Zuora Data as a MySQL Database in Node.js
Execute MySQL queries against Zuora from Node.js.
-
Integrate Theia IDE with Live Neo4J Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE
-
Use the CData Software ODBC Driver for FreeAgent in MicroStrategy Web
Connect to FreeAgent in MicroStrategy Web using the CData Software ODBC Driver for FreeAgent.
-
Build Semantic Layer Views for Google Ads Data in APOS Live Data Gateway
Use the CData Connector for Google Ads in APOS Live Data Gateway to build Semantic Layer Views for Google Ads.
-
Integrate Zuora with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Zuora with External Services.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Microsoft Planner within intelligent workflows.
-
How to Work with Mode Data in AWS Glue Jobs Using JDBC
Connect to Mode from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Use Dash to Build Web Apps on HCL Domino Data via CData Connect AI
Build interactive Dash web apps on live HCL Domino using pandas and the CData Connect AI Python SDK.
-
Connect to Real-Time Flowlu Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Flowlu in Power Apps.
-
Seamlessly Bring Workday Data into Retool Using CData Connect AI
Integrate Workday data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Query Short.io Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Short.io from Node.js.
-
Create Microsoft Dataverse-Connected Nintex Workflows
Use CData Connect AI to connect to Microsoft Dataverse Data from Nintex Workflow Cloud and build custom workflows using live Microsoft Dataverse (CDS).
-
Connect to Lakebase Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Lakebase Data and connect to Lakebase in Akorbi Digital RunMyProcess.
-
Analyze Oracle Eloqua Reporting Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Oracle Eloqua Reporting in Microsoft R Open.
-
How to connect to Gorgias Data in DBVisualizer
Integrate Gorgias with visual data analysis tools and data connection wizards in DBVisualizer
-
Integrating Claude Code with FreshBooks Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on FreshBooks within assisted coding and automated development workflows.
-
How to update SingleStore from Excel
This article explains how to transfer data from Excel to SingleStore using the Excel Add-In for SingleStore.
-
Build Data Flows from ZendeskSell to SQL Server using SSIS
Easily back up ZendeskSell to SQL Server using the SSIS components for ZendeskSell.
-
Connect to Live MySQL Data in PostGresSQL Interface through CData Connect AI
Create a live connection to MySQL in CData Connect AI and connect to your MySQL from PostgreSQL.
-
Access Live Certinia 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 Certinia through MCP integration.
-
Replicate QuickBooks Time Data to Multiple Databases
Replicate QuickBooks Time to disparate databases with a point-and-click configuration.
-
Automated Continuous PostgreSQL Replication to SingleStore
Use CData Sync for automated, continuous, customizable PostgreSQL replication to SingleStore.
-
Visualize Live MariaDB Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live MariaDB using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
DataBind Controls to RabbitMQ Data in C++Builder
DataBind to RabbitMQ in C++Builder with standard components and controls.
-
Connect to Drift Data in CloverDX (formerly CloverETL)
Transfer Drift using the visual workflow in the CloverDX data integration tool.
-
Integrating OpenCode Terminal with Deel 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.
-
HBase Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Apache HBase through CData Connect AI using different applications and tools.