CData Software - Knowledge Base
Recent Articles
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Pinterest
Provide connectivity to Pinterest data through an SAP BusinessObjects universe.
-
Excel Spreadsheet Automation on Pipedrive Data with the QUERY Formula
Pull data from Pipedrive, automate spreadsheets, and more with the QUERY formula.
-
Use the CData Software ODBC Driver for Samanage in MicroStrategy Web
Connect to Samanage data in MicroStrategy Web using the CData Software ODBC Driver for Samanage.
-
How to connect to ScrapingBee Data from IntelliJ
Integrate connectivity to ScrapingBee data with wizards in IntelliJ.
-
Build Automated Workflows with Live SAP HANA XS Advanced Data in Workato
Use CData Connect AI to connect to live SAP HANA XS Advanced data and build automated workflows in Workato.
-
Use the CData Software ODBC Driver for Microsoft Teams in MicroStrategy Desktop
Connect to Microsoft Teams data in MicroStrategy Desktop using the CData Software ODBC Driver for Microsoft Teams.
-
How to load Deel data into Elasticsearch via Logstash
Introducing a simple method to load Deel data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
How to connect to Paylocity Data from IntelliJ
Integrate connectivity to Paylocity data with wizards in IntelliJ.
-
Automated Continuous Azure DevOps Replication to Databricks
Use CData Sync for automated, continuous, customizable Azure DevOps replication to Databricks.
-
How to create Brex federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Brex data in MySQL .
-
How to Connect the Power BI Service to xBase: Complete Guide
Connect to the CData Software Power BI Connector for xBase from PowerBI.com to provide real-time xBase data across the organization.
-
Use Dash to Build to Web Apps on Amazon DynamoDB Data
Create Python applications that use pandas and Dash to build Amazon DynamoDB-connected web apps.
-
Automated Continuous AgileCRM Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable AgileCRM replication to Google Cloud SQL.
-
Integrate Azure DevOps Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Azure DevOps data and integrate live Azure DevOps data into your Power Automate tasks.
-
Build a PostgreSQL Interface for CloudConvert Data using the CData JDBC Driver
Use the Remoting features of the CloudConvert JDBC Driver to create a PostgreSQL entry-point for data access.
-
Use the CData ODBC Driver for Freshsales from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Freshsales to connect to Freshsales data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Freshsales data in Excel.
-
Integrating OpenCode with Amazon DynamoDB 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.
-
Analyze Freshteam Data in Cognos Analytics
Use CData Connect AI to connect to Freshteam Data from Cognos Analytics and analyze live Freshteam data.
-
Automated Continuous Azure Synapse Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Azure Synapse replication to Apache Cassandra.
-
Publish Reports with MailerLite Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date MailerLite data.
-
Access Live MessageBird Data in AWS Lambda
Connect to live MessageBird data in AWS Lambda using the CData JDBC Driver.
-
Import and Visualize Stack Exchange Data in Power View
Create data visualizations based on Stack Exchange data in Excel.
-
How to Connect Bannerbear 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 Bannerbear data in real time using natural language.
-
Query ActiveCampaign Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume ActiveCampaign entities in PHP by modeling them as objects.
-
Use Databricks Agent Bricks to Talk to Your DocuSign Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your DocuSign data for you.
-
How to Query Live Klipfolio Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Klipfolio data data in natural language using Python.
-
Connect to Wistia Data from PowerBuilder via JDBC
This article demonstrates how to access Wistia data from PowerBuilder using the Wistia JDBC Driver.
-
Build Apps with Live SAP SuccessFactors data in Adalo using CData Connect AI
Use CData Connect AI to integrate live SAP SuccessFactors data into the Adalo platform and build custom mobile and web applications with real-time SAP SuccessFactors data.
-
Use the CData Software ODBC Driver for Twitter Ads in MicroStrategy
Connect to Twitter Ads data in MicroStrategy Developer using the CData Software ODBC Driver for Twitter Ads.
-
Analyze PolarTeamPro Data in Looker
Use CData Connect AI to connect to PolarTeamPro Data from Looker and build custom apps using live PolarTeamPro data.
-
Analyze Facebook Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Facebook data with the CData JDBC Driver for Facebook.
-
Build Automated ZohoPeople-Connected Workflows in Zapier
Use CData Connect AI to connect to live ZohoPeople data and build automated workflows in Zapier.
-
Connect to Paylocity Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Paylocity data in Airbyte.
-
Analyze Missive Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Missive from Power Pivot. You will use the Table Import Wizard to load Missive data. You can visually build the import query or use any SQL supported by the driver.
-
Access Cassandra Data from MySQL in Amazon QuickSight
Connect to Cassandra and build visualizations of Cassandra data using a MySQL Connection in Amazon QuickSight.
-
How to Work with Retently Data in AWS Glue Jobs Using JDBC
Connect to Retently from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Work with Live EnterpriseDB Data in Power Query
Use CData Connect AI to connect to EnterpriseDB data and work with live EnterpriseDB data in Microsoft Power Query.
-
Connect to SAP BusinessObjects BI Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time SAP BusinessObjects BI data using standard SQL.
-
How to connect Amazon QuickSight to Oracle Sales Data
Create a connection to Oracle Sales data in CData Connect AI and insert Oracle Sales data into Amazon QuickSight SPICE to build interactive dashboards.
-
How to Connect to Live QuickBooks 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 QuickBooks data for you.
-
Build Visualizations of Raisers Edge NXT Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Raisers Edge NXT data in Birst.
-
How to Query Live Mailjet Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Mailjet data data in natural language using Python.
-
Automated Continuous DocuSign Replication to AlloyDB
Use CData Sync for automated, continuous, customizable DocuSign replication to AlloyDB.
-
Automated Continuous Beeminder Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Beeminder replication to AlloyDB.
-
Replicate ChartMogul Data in Heroku for Use in Salesforce Connect
Replicate ChartMogul data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Integrate Google's Antigravity Agent with Live Yelp Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Yelp data using the Model Context Protocol.
-
Access ZeroBounce 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 ZeroBounce data.
-
Query Instagram Data as a SQL Server Database in Node.js
Execute SQL Server queries against Instagram data from Node.js.
-
Connect to Access Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Access and the SQL Gateway to access Access data from Google Apps Script.
-
Build Data Flows from FormSite to SQL Server using SSIS
Easily back up FormSite data to SQL Server using the SSIS components for FormSite.
-
Automated Continuous Missive Replication to SQLite
Use CData Sync for automated, continuous, customizable Missive replication to SQLite.
-
Query Acumatica Data as a SQL Server Database in Node.js
Execute SQL Server queries against Acumatica data from Node.js.
-
Publish Crystal Reports on Confluence Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Confluence data.
-
Process & Analyze Cassandra Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Cassandra Data.
-
How to Access Live VWO Data in Power Automate Desktop via ODBC
The CData ODBC Driver for VWO enables you to integrate VWO data into workflows built using Microsoft Power Automate Desktop.
-
Create Procore Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Procore data access from reports, embedded analytics, and more.
-
Build Cloudflare-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Cloudflare Data and create custom apps in Bubble.
-
Visualize Egnyte Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Egnyte data.
-
Access Live Square Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Square data from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Bidirectional Access to MarkLogic Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate MarkLogic data in Filemaker Pro for Mac or Windows.
-
Getting Started with the CData ODBC Driver for Jodoo
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Jodoo.
-
Connect to Wrike Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Wrike and the SQL Gateway to access Wrike data from Google Apps Script.
-
Integrate Act-On Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Act-On data from Informatica Cloud.
-
Use JayDeBeApi to access Dynamics 365 Business Central Data in Python
Use standard Python scripting and the development environment of your choice to access live Dynamics 365 Business Central data.
-
Replicate Multiple Microsoft Teams Accounts
Replicate multiple Microsoft Teams accounts to one or many databases.
-
How to Connect to Live Azure Analysis Services Data from Gemini CLI (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Gemini CLI to securely read and take actions on your Azure Analysis Services data for you.
-
Use ChatGPT to Talk to Your GraphQL 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 GraphQL data for you.
-
Integrate Phoenix Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Phoenix data and integrate live Phoenix data into your Power Automate tasks.
-
Stream WordPress Data into Apache Kafka Topics
Access and stream WordPress data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Create Informatica Mappings From/To an ODBC Data Source for Box
Create an ODBC connection to Box in Informatica and browse and transfer Box data.
-
Use Biml to Build SSIS Tasks to Replicate ActiveCampaign Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate ActiveCampaign data to SQL Server.
-
Integrating Codex with Zoho Inventory 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.
-
Access MailerLite 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 MailerLite data.
-
Visualize ChartMogul Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to ChartMogul data.
-
Connect to Marketo Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Marketo to connect to Marketo data and execute queries in PowerBuilder.
-
DataBind Charts to Google Forms Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Google Forms 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.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for LeadDesk
Provide connectivity to LeadDesk data through an SAP BusinessObjects universe.
-
Replicate Pinecone Data from PowerShell
Write a quick PowerShell script to query Pinecone data. Use connectivity to the live data to replicate Pinecone data to SQL Server.
-
Integrating GitHub Copilot with Salesforce Pardot 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.
-
Getting Started with the CData ODBC Driver for ZendeskSell
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for ZendeskSell.
-
Build Dashboards with Bannerbear Data in Dundas BI
Create dynamic dashboards and perform analytics based on Bannerbear data in Dundas BI.
-
Build Dashboards with Clio Data in DBxtra
Create dynamic dashboards and perform analytics based on Clio data in DBxtra.
-
Automated Continuous Sage 300 Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Sage 300 replication to AlloyDB.
-
How to Connect to Live Square 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 Square data for you.
-
Migrating data from ZendeskSell to Google BigQuery using CData SSIS Components.
Easily push ZendeskSell data to Google BigQuery using the CData SSIS Tasks for ZendeskSell and Google BigQuery.
-
Use ChatGPT to Talk to Your YouTube Analytics 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 YouTube Analytics data for you.
-
Automated Continuous Microsoft Planner Replication to SQLite
Use CData Sync for automated, continuous, customizable Microsoft Planner replication to SQLite.
-
Create Hive-Connected Applications in Appsmith
Connect to Hive Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Hive data.
-
Know Your LLMs: Google Gemini
Learn how Google Gemini models support enterprise AI workloads, including multimodality, function calling, security, and integration with CData Connect AI via MCP.
-
Automated Continuous HCL Domino Replication to Databricks
Use CData Sync for automated, continuous, customizable HCL Domino replication to Databricks.
-
Visualize Optimizely Data in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load Optimizely data into TIBCO Spotfire.
-
How to Connect to Live Paymo 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 Paymo data through natural language.
-
Import Real-Time PolarTeamPro Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use PolarTeamPro data in ColdFusion.
-
Create NetSuite-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to NetSuite Data from OutSystems and build custom enterprise apps using live NetSuite data.
-
Visualize Live Gumroad Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Gumroad data.
-
Excel Spreadsheet Automation on GitHub Data with the QUERY Formula
Pull data from GitHub, automate spreadsheets, and more with the QUERY formula.
-
Stream Freshsales Data into Apache Kafka Topics
Access and stream Freshsales data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Query Snapchat Ads Data in DataGrip
Create a Data Source for Snapchat Ads in DataGrip and use SQL to query live Snapchat Ads data.
-
Replicate Insightly Data to Multiple Databases
Replicate Insightly data to disparate databases with a point-and-click configuration.
-
Connect to MYOB AccountRight Data in HULFT Integrate
Connect to MYOB AccountRight as a JDBC data source in HULFT Integrate