CData Software - Knowledge Base
Recent Articles
-
Access Live Wistia Data in Excel 365 Online (Excel for the web)
Connect to Wistia data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Build Voice Agents in ElevenLabs with access to Live OData Services
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live OData services.
-
Publish Codat-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Codat data.
-
Visualize SAP HANA XS Advanced Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to SAP HANA XS Advanced data.
-
Analyze Sybase IQ Data in Looker
Use CData Connect AI to connect to Sybase IQ Data from Looker and build custom apps using live Sybase IQ data.
-
Publish Reports with Shortcut Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Shortcut data.
-
Integrating Cursor with Demio 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.
-
Build an OLAP Cube in SSAS from Amazon DynamoDB Data
Establish a connection to Amazon DynamoDB data data from SQL Server Analysis Services, and use the Amazon DynamoDB Data Provider to build OLAP cubes for use in analytics and reporting.
-
Integrate OpenCode with Live Sage Intacct Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable OpenCode to securely access and query live Sage Intacct data from within your AI coding agent.
-
Bidirectional Access to SharePoint Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate SharePoint data in Filemaker Pro for Mac or Windows.
-
Connect to CouchDB Data from HeidiSQL
Use CData Connect AI to connect to and query live CouchDB data from HeidiSQL.
-
Access Live BigCommerce Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate BigCommerce data into the statistical analysis tools available in SAS JMP. This article shows how to use BigCommerce data in the Graph Builder and Query Builder.
-
Use Biml to Build SSIS Tasks to Replicate Demio Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Demio data to SQL Server.
-
Automated Continuous SendGrid Replication to Amazon S3
Use CData Sync for automated, continuous, customizable SendGrid replication to Amazon S3.
-
Use Microsoft Copilot Studio to talk to your QuickBooks Online Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Microsoft Copilot Studio to securely answer questions and take actions on your QuickBooks Online data for you.
-
Using the CData Software ODBC Driver for HBase in PyCharm
Connect to HBase as an ODBC data source in PyCharm using the CData Software ODBC Driver for HBase.
-
Migrating data from Demio to Snowflake using CData SSIS Components.
Easily push Demio data to Snowflake using the CData SSIS Tasks for Demio and Snowflake.
-
Import Oracle Data Using Azure Data Factory
Use CData Connect AI to connect to Oracle Data from Azure Data Factory and import live Oracle data.
-
Create a Data Access Object for Microsoft Exchange Data using JDBI
A brief overview of creating a SQL Object API for Microsoft Exchange data in JDBI.
-
Connect Anaplan to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Anaplan data using the CData Python MCP Server.
-
Use the CData Software ODBC Driver for Foursquare in MicroStrategy Desktop
Connect to Foursquare data in MicroStrategy Desktop using the CData Software ODBC Driver for Foursquare.
-
Build Oracle Sales-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Oracle Sales Data from Zoho Analytics and import live Oracle Sales data.
-
Build AI/ML Models with Live Google Calendar Data using Dataiku
Connect Google Calendar Data with Dataiku using the CData JDBC Driver for Google Calendar.
-
Write a Simple Go Application to work with Attio Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Attio data.
-
Moving Data from Square to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Square data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Access Jodoo 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 Jodoo data.
-
Build Microsoft Ads-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Microsoft Ads data.
-
Use the CData Software JDBC Driver for Xero in MicroStrategy
Connect to Xero data in MicroStrategy Developer using the CData Software JDBC Driver for Xero.
-
Connect to PabblySubscriptions Data from a Connection Pool in JBoss
Integrate PabblySubscriptions data into Java servlets: Use the Management Console in JBoss to install the PabblySubscriptions JDBC Driver.
-
Getting Started with the CData Python Connector for Yelp
Learn to install and license the CData Python Connector and configure a connection to live Yelp data.
-
Excel Spreadsheet Automation on Mistral AI Data with the QUERY Formula
Pull data from Mistral AI, automate spreadsheets, and more with the QUERY formula.
-
Integrating Cursor with Hugging Face 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.
-
Excel Spreadsheet Automation on MySQL Data with the QUERY Formula
Pull data from MySQL, automate spreadsheets, and more with the QUERY formula.
-
Connect to Anaplan Data in Claris FileMaker Pro
Use the CData ODBC Driver for Anaplan in FileMaker Pro to connect to Anaplan and work with Anaplan data in your FileMaker applications.
-
How to Connect to Live Zuora Data in Mistral AI Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live Zuora data without replication.
-
Build a Simple VCL Application for GraphQL Data
How to build a simple VCL Application to view GraphQL data in RAD Studio using the CData ODBC Driver for GraphQL.
-
Build Apps with Live Sage 200 Data Using the Low-Code Development Platform of Mendix
Connect Sage 200 data with Mendix to build apps using the CData JDBC Driver for Sage 200.
-
Connect Google Search to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Google Search with IBM WebSphere for seamless data integration and connectivity.
-
Automated Continuous Vimeo Replication to SQL Server
Use CData Sync for automated, continuous, customizable Vimeo replication to SQL Server.
-
Choosing the Best Method to Connect FreeAgent to SQL Server: 5 Options Explained
Discover multiple ways to connect and use FreeAgent data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Import and Visualize Cohere Data in Power View
Create data visualizations based on Cohere data in Excel.
-
Search External Shippo Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Shippo data to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Shippo Data objects that you can access from apps and the dashboard.
-
Integrating OpenCode with Mocean 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.
-
Integrating Cursor with iContact 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.
-
Automate Campaigner Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Campaigner data from PowerShell? This article demonstrates how to utilize the Campaigner Cmdlets for tasks like connecting to Campaigner data, automating operations, downloading data, and more.
-
Connect to Google Directory Data in Aqua Data Studio
Access Google Directory data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
How to Build an ETL App for Microsoft Exchange Data in Python with CData
Create ETL applications and real-time data pipelines for Microsoft Exchange data in Python with petl.
-
Build Avaza-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Avaza data and build web apps with connectivity to live Avaza data.
-
How to work with Anaplan Data in Apache Spark using SQL
Access and process Anaplan Data in Apache Spark using the CData Software JDBC Driver.
-
Extract, Transform, and Load Stripe Data in Informatica PowerCenter
Create a simple Workflow for Stripe data in Informatica PowerCenter.
-
Getting Started with the CData ODBC Driver for Chargebee
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Chargebee.
-
How to Connect to Live Lakebase 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 Lakebase data through natural language.
-
Integrate Live Monday.com Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Monday.com from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Monday.com data.
-
Build SAP Hybris C4C-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live SAP Hybris C4C data.
-
Connect to Pipedrive Data from Crystal Reports
Use CData Connect AI to connect to and report on live Pipedrive data from Crystal Reports.
-
Automated Continuous Tally Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Tally replication to PostgreSQL.
-
How to Build an ETL App for Salesforce Pardot Data in Python with CData Connect AI
Build ETL pipelines that read and write live Salesforce Pardot data in Python with petl and the CData Connect AI Python SDK.
-
Model Elasticsearch Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Elasticsearch, enabling the direct import of real-time Elasticsearch data.
-
Connect to ZohoExpense Data in NetBeans
Connect to ZohoExpense data in NetBeans with the data source configuration wizard.
-
Create Informatica Mappings From/To an ODBC Data Source for Azure Table
Create an ODBC connection to Azure Table in Informatica and browse and transfer Azure Table data.
-
Connect to Confluence Data from PowerBuilder via ADO.NET
This article demonstrates how to access Confluence data from Appeon PowerBuilder using the CData ADO.NET Provider for Confluence.
-
Build Visualizations of Foursquare Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Foursquare data in Birst.
-
Connect to ClickUp Data in CloverDX (formerly CloverETL)
Transfer ClickUp data using the visual workflow in the CloverDX data integration tool.
-
How to integrate Metabase with Google Directory Data
Use CData Connect AI to connect to live Google Directory data and create an interactive dashboard in Metabase from Google Directory data.
-
Provide OData Services of Factorial Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Factorial data by developing a WCF Service Application.
-
How to Visualize ZohoExpense 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 ZohoExpense data in Python.
-
Use the CData Software JDBC Driver for Procore in MicroStrategy Desktop
Connect to Procore data in MicroStrategy Desktop using the CData Software JDBC Driver for Procore.
-
Use the CData Software JDBC Driver for Salesforce in MicroStrategy
Connect to Salesforce data in MicroStrategy Developer using the CData Software JDBC Driver for Salesforce.
-
Integrate OpenCode with Live Zoho CRM Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable OpenCode to securely access and query live Zoho CRM data from within your AI coding agent.
-
Replicate Multiple Missive Accounts via the CData Sync CLI
Replicate multiple Missive accounts to one or many databases.
-
Use the CData ODBC Driver for Rootly in Microsoft Power Query
You can use the CData Rootly ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Rootly data into Microsoft Power Query.
-
Integrating Gumloop with Authorize.Net Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Authorize.Net data within automated workflows.
-
Automated Continuous SendGrid Replication to Databricks
Use CData Sync for automated, continuous, customizable SendGrid replication to Databricks.
-
Build Dashboards with Everhour Data in DBxtra
Create dynamic dashboards and perform analytics based on Everhour data in DBxtra.
-
Build a Simple VCL Application for OneNote Data
How to build a simple VCL Application to view OneNote data in RAD Studio using the CData ODBC Driver for OneNote.
-
Automate Miro Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Miro data from PowerShell? This article demonstrates how to utilize the Miro Cmdlets for tasks like connecting to Miro data, automating operations, downloading data, and more.
-
Automated Continuous Adobe Target Replication to Oracle
Use CData Sync for automated, continuous, customizable Adobe Target replication to Oracle.
-
Connect to Jumpseller Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Jumpseller and work with Jumpseller data in your FileMaker applications.
-
Replicate ServiceNow Data from PowerShell
Write a quick PowerShell script to query ServiceNow data. Use connectivity to the live data to replicate ServiceNow data to SQL Server.
-
Connect to Dynamics 365 Business Central Data from PowerBuilder via JDBC
This article demonstrates how to access Dynamics 365 Business Central data from PowerBuilder using the Dynamics 365 Business Central JDBC Driver.
-
Import Teradata Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Teradata Data and provide access to live Teradata data for custom reports in the Power BI Service.
-
Build CockroachDB-Connected Apps in Choreo
Use CData Connect AI to connect to CockroachDB Data from Choreo and build custom apps using live CockroachDB data.
-
Using the CData Software ODBC Driver for Jumpseller in PyCharm
Connect to Jumpseller as an ODBC data source in PyCharm using the CData Software ODBC Driver for Jumpseller.
-
Use Biml to Build SSIS Tasks to Replicate ConvertKit Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate ConvertKit data to SQL Server.
-
Getting Started with the CData Connect AI Python SDK for Quickbase
Install the CData Connect AI Python SDK to read and write live Quickbase data with standard DB-API 2.0 Python code.
-
Getting Started with the CData JDBC Driver for NASA
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for NASA.
-
Integrate Gumroad Data in the Pentaho Report Designer
Publish reports based on Gumroad data in the Pentaho BI tool.
-
How to use SQLAlchemy ORM to access Dotmailer Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Dotmailer data.
-
Connect to MailerLite Data in DBArtisan
Use wizards in DBArtisan to configure MailerLite data as a data source.
-
Seamlessly Bring Sendwithus Data into Retool Using CData Connect AI
Integrate Sendwithus data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Extract, Transform, and Load Google Cloud Storage Data in Informatica PowerCenter
Create a simple Workflow for Google Cloud Storage data in Informatica PowerCenter.
-
Write a Simple Go Application to work with Qualaroo Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Qualaroo data.
-
Build Apps with Live SAP HANA data in Adalo using CData Connect AI
Use CData Connect AI to integrate live SAP HANA data into the Adalo platform and build custom mobile and web applications with real-time SAP HANA data.
-
Build ActiveCampaign-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to ActiveCampaign data and build web apps with connectivity to live ActiveCampaign data.
-
Automated Continuous CouchDB Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable CouchDB replication to Azure SQL Database.
-
Integrate Cline with Live Odoo Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Odoo data from within your IDE.
-
Load Box Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Box data to a database.
-
How to Access Live Lakebase Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Lakebase enables you to integrate Lakebase data into workflows built using Microsoft Power Automate Desktop.
-
Automated Continuous Zoho Projects Replication to Oracle
Use CData Sync for automated, continuous, customizable Zoho Projects replication to Oracle.
-
Automated Continuous Facebook Ads Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Facebook Ads replication to PostgreSQL.