CData Software - Knowledge Base
Recent Articles
-
How to Connect to Live Twitter Ads 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 Twitter Ads data for you.
-
Integrate with Yelp Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Yelp data to a JSON file on disk.
-
Use Azure AI Foundry to Talk to Your AgileCRM Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Azure AI Foundry agents to securely answer questions and take actions on your AgileCRM data for you.
-
Integrate Theia IDE with Live Samanage Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE's built-in AI agents to securely access and query live Samanage data from within the development environment.
-
How to Visualize Redis 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 Redis data in Python.
-
Visualize Live Cosmos DB Data in the Power BI Service
Use CData Connect AI to connect to live Cosmos DB data and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Use Claude to Talk to Your RSS Feeds via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your RSS feeds for you.
-
Automated Continuous Google Campaign Manager 360 Replication to Vertica
Use CData Sync for automated, continuous, customizable Google Campaign Manager 360 replication to Vertica.
-
Create Datasets from Office 365 in Domo Workbench and Build Visualizations of Office 365 Data in Domo
Use the CData Software ODBC Driver for Office 365 to create datasets from Office 365 data in Domo Workbench and then build visualizations in the Domo service.
-
Visualize Live JobNimbus Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live JobNimbus data.
-
Use Claude to Talk to Your Microsoft Ads Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your Microsoft Ads data for you.
-
How to Work with Paymo Data in AWS Glue Jobs Using JDBC
Connect to Paymo from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Connect to ClickTime Data in Aqua Data Studio
Access ClickTime data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Creating DB2-Connected Applications in Unqork
You can use CData Connect AI to feed DB2 data to Unqork and build custom business apps.
-
Use CData Connect AI to Access Discord Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Discord data in the Power Pivot business intelligence tool.
-
Create a Data Access Object for Reply.io Data using JDBI
A brief overview of creating a SQL Object API for Reply.io data in JDBI.
-
Replicate Multiple Box Accounts via the CData Sync CLI
Replicate multiple Box accounts to one or many databases.
-
Use the CData Software JDBC Driver for Confluence in MicroStrategy Desktop
Connect to Confluence data in MicroStrategy Desktop using the CData Software JDBC Driver for Confluence.
-
Create SSAS Tabular Models from ZeroBounce Data
How to build a SQL Server Analysis Service Tabular Model from ZeroBounce data using CData drivers.
-
Automated Continuous Mistral AI Replication to Databricks
Use CData Sync for automated, continuous, customizable Mistral AI replication to Databricks.
-
How to use SQLAlchemy ORM to access Bugsnag Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Bugsnag data.
-
How to Easily Query Facebook Ads Data in OpenOffice Base
Connect to Facebook Ads data in OpenOffice Base using the CData ODBC Driver for Facebook Ads and generate reports with live data insights.
-
Using the CData Software ODBC Driver for Google Spanner in PyCharm
Connect to Google Spanner as an ODBC data source in PyCharm using the CData Software ODBC Driver for Google Spanner.
-
Access Miro Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Miro data from HeidiSQL.
-
Publish JobNimbus-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live JobNimbus data.
-
Access Salesforce Data 360 Data from MySQL in PHP
Connect to Salesforce Data 360 through the standard MySQL libraries in PHP.
-
Integrate Live Jira Assets Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Jira Assets from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Jira Assets data.
-
Automated Continuous Box Replication to Databricks
Use CData Sync for automated, continuous, customizable Box replication to Databricks.
-
Replicate LDAP Objects from PowerShell
Write a quick PowerShell script to query LDAP objects. Use connectivity to the live data to replicate LDAP objects to SQL Server.
-
Automate Paymo Data Replication to Azure Synapse
Use CData Sync to customize and automate Paymo data replication to Azure Synapse.
-
Connect to RabbitMQ Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for RabbitMQ and the SQL Gateway to access RabbitMQ data from Google Apps Script.
-
Validate ADP Data with QuerySurge
Access and validate ADP data in QuerySurge using the CData JDBC Driver.
-
Create Data Visualizations in Cognos BI with Auth0 Data
Access Auth0 data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Use Microsoft Copilot Studio to talk to your ZohoInvoice 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 ZohoInvoice data for you.
-
Use the CData SSIS Components to Insert New or Update Existing Excel Records from SQL Server
Easily push SQL Server data to Excel using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Excel or update existing records with data from a SQL Server database.
-
Interact with Live YouTube Analytics Data in Meta Muse via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Muse to securely interact with live YouTube Analytics data.
-
Access Live Greenhouse Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Greenhouse data from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
How to Connect to Live FreshBooks 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 FreshBooks data for you.
-
Extract, Transform, and Load FormSite Data in Informatica PowerCenter
Create a simple Workflow for FormSite data in Informatica PowerCenter.
-
Use the CData ODBC Driver for ZohoPeople from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for ZohoPeople to connect to ZohoPeople data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring ZohoPeople data in Excel.
-
How to publish and share Marketo Data dashboards with Tableau Server
The CData ODBC driver for Marketo enables you integrate Marketo data into Tableau dashboards.
-
Access Live Microsoft Teams Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Microsoft Teams data from your Google Sheets.
-
How to Easily Query LaunchDarkly Data in OpenOffice Base
Connect to LaunchDarkly data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Visualize Paymo Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Paymo data.
-
Analyze Google Cloud Storage Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Google Cloud Storage data and visualize Google Cloud Storage data in SAP Analytics Cloud.
-
Create Data Visualizations in Cognos BI with Salesforce Data
This article describes how to use the CData ODBC Driver for Salesforce in Cognos BI.
-
Choosing the Best Method to Connect Microsoft OneDrive to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Microsoft OneDrive data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Interact with Live Facebook Ads Data in Meta Muse via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Muse to securely interact with live Facebook Ads data.
-
Access Live Slack Data in Emergent via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Emergent agents to securely access and build applications with live Slack data through MCP integration.
-
Natively Connect to QuickBooks Data in PHP
The CData ODBC driver for QuickBooks enables you to create PHP applications with connectivity to QuickBooks data. Leverage the native support for ODBC in PHP.
-
Create Vimeo Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Vimeo from PowerBI.com to create Power BI Dataflows with real-time data.
-
Visualize Anaplan Data in Tableau
The CData ODBC driver for Anaplan enables you integrate Anaplan data into Tableau dashboards.
-
Publish MailerSend-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live MailerSend data.
-
Using the CData Software ODBC Driver for Browserless in PyCharm
Connect to Browserless as an ODBC data source in PyCharm using the CData Software ODBC Driver for Browserless.
-
Connect to Oracle Sales Data from a Connection Pool in JBoss
Integrate Oracle Sales data into Java servlets: Use the Management Console in JBoss to install the Oracle Sales JDBC Driver.
-
Build Semantic Layer Views for EnterpriseDB Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for EnterpriseDB data.
-
Integrating Claude Code CLI with LaunchDarkly 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.
-
Visualize Live LDAP Objects in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live LDAP objects into custom reports in Power BI.
-
Load SAP Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load SAP data to a database.
-
Query Elasticsearch Data as a MySQL Database in Node.js
Execute MySQL queries against Elasticsearch data from Node.js.
-
Replicate HBase Data to Multiple Databases
Replicate HBase data to disparate databases with a point-and-click configuration.
-
Connect to DocuSign Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with DocuSign Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Query WooCommerce Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume WooCommerce entities in PHP by modeling them as objects.
-
Replicate Oracle Service Cloud Data in Heroku for Use in Salesforce Connect
Replicate Oracle Service Cloud data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Build an OLAP Cube in SSAS from Strava Data
Establish a connection to Strava data data from SQL Server Analysis Services, and use the Strava Data Provider to build OLAP cubes for use in analytics and reporting.
-
Import Google Sheets Data Using Azure Data Factory
Use CData Connect AI to connect to Google Sheets Data from Azure Data Factory and import live Google Sheets data.
-
Use the CData Software JDBC Driver for Typeform in MicroStrategy
Connect to Typeform data in MicroStrategy Developer using the CData Software JDBC Driver for Typeform.
-
Build Dashboards with FreeAgent Data in DBxtra
Create dynamic dashboards and perform analytics based on FreeAgent data in DBxtra.
-
Build Snowflake-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Snowflake Data and create custom apps in Mendix.
-
How to Connect the Power BI Service to Adobe Commerce: Complete Guide
Connect to the CData Software Power BI Connector for Adobe Commerce from PowerBI.com to provide real-time Adobe Commerce data across the organization.
-
Use Biml to Build SSIS Tasks to Replicate XML Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate XML data to SQL Server.
-
Use the CData Software JDBC Driver for Google Drive in MicroStrategy Web
Connect to Google Drive data in MicroStrategy Web using the CData Software JDBC Driver for Google Drive.
-
Connect to Zoho Creator Data in DBeaver
Use the CData ODBC Driver to connect to Zoho Creator data in DBeaver.
-
Build SuiteCRM-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to SuiteCRM data and build web apps with connectivity to live SuiteCRM data.
-
Link Confluence with FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Confluence data in Filemaker Pro for Mac or Windows.
-
Replicate Teradata Data to Multiple Databases via the CData Sync CLI
Replicate Teradata data to disparate databases with a single configuration.
-
How to Visualize NASA Data in Python with pandas
Use pandas and other modules to analyze and visualize live NASA data in Python.
-
Create Reports with FTP Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date FTP data.
-
Visualize Live Perplexity Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Perplexity data into custom reports in Power BI.
-
Automate Avalara AvaTax Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Avalara AvaTax data from PowerShell? This article demonstrates how to utilize the Avalara AvaTax Cmdlets for tasks like connecting to Avalara AvaTax data, automating operations, downloading data, and more.
-
Access Demio 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 Demio data.
-
Build Agents in Relevance AI with Access to Live Oracle SCM Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Oracle SCM data within intelligent agent workflows.
-
How to Access iContact Data Using Entity Framework
This article shows how to access iContact data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Connect to LinkedIn Ads Data in RapidMiner
Integrate LinkedIn Ads data with standard components and data source configuration wizards in RapidMiner Studio.
-
Visualize LinkedIn 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 LinkedIn data into TIBCO Spotfire.
-
Connect MarkLogic to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live MarkLogic data using the CData Python MCP Server.
-
How to Connect to Live Omnisend 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 Omnisend data for you.
-
How to Visualize CockroachDB Data in Python with pandas
Use pandas and other modules to analyze and visualize live CockroachDB data in Python.
-
Build Automated Workflows with Live BigQuery Data in Workato
Use CData Connect AI to connect to live BigQuery data and build automated workflows in Workato.
-
Query Live Exa Data in Perplexity Desktop via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Perplexity Desktop to securely access and query live Exa data through a conversational interface.
-
Integrate Stripe Data in Pentaho Data Integration
Build ETL pipelines based on Stripe data in the Pentaho Data Integration tool.
-
How to Connect to Live Twitter Ads 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 Twitter Ads data without replication.
-
Connect to Sage 300 Data from AWS Glue
Use CData Connect AI to gain access to live Sage 300 data from your AWS Glue jobs.
-
Access Snowflake 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 Snowflake data.
-
Link Webflow with FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Webflow data in Filemaker Pro for Mac or Windows.
-
Access Nuclia Data from MySQL in PHP
Connect to Nuclia through the standard MySQL libraries in PHP.
-
Visualize Live Calendly Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Calendly data.
-
Publish Quickbase-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Quickbase data.
-
How to Connect to & Open Cohere Data in Microsoft Excel
This article uses the CData ODBC driver for Cohere to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Query Live ActiveCampaign Data in Zed Editor via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Zed Editor to securely access and query live ActiveCampaign data directly from the development environment.