CData Software - Knowledge Base
Recent Articles
-
Analyze Google Analytics Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Google Analytics from Power Pivot. You will use the Table Import Wizard to load Google Analytics data. You can visually build the import query or use any SQL supported by the driver.
-
Automate CockroachDB Data Replication to Azure Synapse
Use CData Sync to customize and automate CockroachDB data replication to Azure Synapse.
-
Interact with Live Marketo Data in Meta Muse via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Muse to securely interact with live Marketo data.
-
Access Live Bannerbear Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Bannerbear data from your Google Sheets.
-
Analyze WooCommerce Data in Looker
Use CData Connect AI to connect to WooCommerce Data from Looker and build custom apps using live WooCommerce data.
-
How to Connect to Live Oracle Financials Cloud 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 Oracle Financials Cloud data without replication.
-
Object-Relational Mapping (ORM) with Parquet Data Entities in Java
Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to Parquet data into a Java-based ORM framework, Hibernate.
-
Connect to BigCommerce Data in DBeaver
Use the CData ODBC Driver to connect to BigCommerce data in DBeaver.
-
Automated Continuous AfterShip Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable AfterShip replication to Google Cloud SQL.
-
Connect to VWO Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live VWO data from Filemaker Pro on Mac.
-
How to create Dynamics CRM federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Dynamics CRM data in MySQL .
-
Integrate Google's Vertex AI Agent with Live Klaviyo Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Klaviyo data within intelligent workflows.
-
Connect to Email Data in Jaspersoft Studio
Execute SQL to remote Email data in Jaspersoft Studio.
-
Visualize Live ZohoExpense Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live ZohoExpense data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
How to Connect SAP Hybris C4C 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 Hybris C4C data in real time using natural language.
-
Connect to Real-Time Square Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Square and Dataflow to import and use Square data in Power Apps.
-
Use ChatGPT to Talk to Your GitLab 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 GitLab data for you.
-
Automated Continuous Teradata Replication to SingleStore
Use CData Sync for automated, continuous, customizable Teradata replication to SingleStore.
-
How to Connect to Live Toggl 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 Toggl data without replication.
-
Connect to Zendesk Data from PowerBuilder via ADO.NET
This article demonstrates how to access Zendesk data from Appeon PowerBuilder using the CData ADO.NET Provider for Zendesk.
-
Use the CData Software ODBC Driver for SurveyMonkey in MicroStrategy Web
Connect to SurveyMonkey data in MicroStrategy Web using the CData Software ODBC Driver for SurveyMonkey.
-
Analyze Blackbaud FE NXT Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Blackbaud FE NXT data and visualize live Blackbaud FE NXT data in Infragistics Reveal.
-
Access Live ScrapingBee Data in AWS Lambda (with IntelliJ IDEA)
Connect to live ScrapingBee data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Back Up FTP data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for FTP. In this article, we will employ an SSIS workflow to populate a database with FTP data data.
-
How to Build an ETL App for Redshift Data in Python with CData
Create ETL applications and real-time data pipelines for Redshift data in Python with petl.
-
Interact with Live TaxJar Data in Meta Muse via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Muse to securely interact with live TaxJar data.
-
Automate ShipStation Data Replication to SAP HANA
Use CData Sync to customize and automate ShipStation data replication to SAP HANA.
-
Integrating Claude Code CLI with SurveyMonkey 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 Excel Add-In for SQL Server
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for SQL Server.
-
Create Zoho CRM-Connected Applications in Appsmith
Connect to Zoho CRM Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Zoho CRM data.
-
Integrating GitHub Copilot with Google Tasks 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.
-
Connect to Hubstaff Data in Ruby
Connect to Hubstaff data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Automated Continuous Mailjet Replication to Vertica
Use CData Sync for automated, continuous, customizable Mailjet replication to Vertica.
-
Build Apps with Live Impala Data Using the Low-Code Development Platform of Mendix
Connect Impala data with Mendix to build apps using the CData JDBC Driver for Impala.
-
Integrating LangGraph with Zoom Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Zoom data within automated workflows.
-
How to publish and share eBay Analytics Data dashboards with Tableau Server
The CData ODBC driver for eBay Analytics enables you integrate eBay Analytics data into Tableau dashboards.
-
Build Apps with Live SAP SuccessFactors LMS data in Adalo using CData Connect AI
Use CData Connect AI to integrate live SAP SuccessFactors LMS data into the Adalo platform and build custom mobile and web applications with real-time SAP SuccessFactors LMS data.
-
Use Azure AI Foundry to Talk to Your Cosmos DB 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 Cosmos DB data for you.
-
Access Live JobNimbus Data in AWS Lambda (with IntelliJ IDEA)
Connect to live JobNimbus data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Getting Started with the CData SSIS Components for Notion
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Notion.
-
How to Work with Google Sheets Data in ETL Validator JDBC
Connect to Google Sheets from ETL Validator jobs using the CData Software JDBC Driver.
-
Integrate with live Raisers Edge NXT Data in Jitterbit
Use CData Connect AI to connect to and integrate live Raisers Edge NXT data in Jitterbit.
-
Integrating Codex 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.
-
Integrate OpenCode with Live ZohoInvoice Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable OpenCode to securely access and query live ZohoInvoice data from within your AI coding agent.
-
How to connect to Amazon Athena Data from IntelliJ
Integrate connectivity to Amazon Athena data with wizards in IntelliJ.
-
How to import Epicor Kinetic Data into Apache Solr
Use the CData Software JDBC Driver for Epicor Kinetic in Data Import Handler and create an automated import of Epicor Kinetic data to Apache Solr Enterprise Search platform.
-
Query Pipeline CRM Data as a MySQL Database in Node.js
Execute MySQL queries against Pipeline CRM data from Node.js.
-
Provide OData Services of Avro Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Avro data by developing a WCF Service Application.
-
Query Microsoft OneDrive Data in ColdFusion
Write standard ColdFusion data access code to connect to Microsoft OneDrive data.
-
DataBind Controls to Webex Data in Delphi
DataBind to Webex data in Delphi with standard data access components and controls.
-
Access Live Oracle Financials Cloud Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Oracle Financials Cloud data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
How to Connect the Power BI Service to Google Analytics: Complete Guide
Connect to the CData Software Power BI Connector for Google Analytics from PowerBI.com to provide real-time Google Analytics data across the organization.
-
Connect to PostgreSQL Data in Claris FileMaker Pro
Use the CData ODBC Driver for PostgreSQL in FileMaker Pro to connect to PostgreSQL and work with PostgreSQL data in your FileMaker applications.
-
How to integrate Google Directory with Apache Airflow
Access and process Google Directory data in Apache Airflow using the CData JDBC Driver.
-
Easily Integrate FreeAgent Data in Lazarus Pascal IDE
Learn how to easily integrate live FreeAgent data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Build MVC Applications with Connectivity to Cosmos DB Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Cosmos DB from an ASP.NET MVC application.
-
How to Connect Flowise AI Agents to Live SAP SuccessFactors LMS 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 SAP SuccessFactors LMS data without replication.
-
Integrate with Instantly Data in JReport Designer
Create charts and reports based on Instantly data in JReport Designer.
-
Build a Singer.io Tap for SendGrid With the CData Python Connector
Learn how to easily build a Singer.io Tap for live SendGrid data using the CData Python Connector.
-
How to connect and process Close data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Close data.
-
Integrating Codex with Google Cloud Storage 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.
-
Connect to SingleStore Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live SingleStore data.
-
Process & Analyze Tickspot Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Tickspot Data.
-
Automated Greenhouse Data Replication to Teradata
Use CData Sync to Customize and automate Greenhouse data replication to Teradata.
-
Visualize SAP Ariba Source Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to SAP Ariba Source data.
-
Connect to ServiceDesk Plus Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for ServiceDesk Plus data in Airbyte.
-
How to connect to VWO Data in DBVisualizer
Integrate VWO data with visual data analysis tools and data connection wizards in DBVisualizer
-
How to Connect to Live Figshare 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 Figshare data without replication.
-
Getting Started with the CData Python Connector for LeadDesk
Learn to install and license the CData Python Connector and configure a connection to live LeadDesk data.
-
Operational Reporting on PDFMonkey Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote PDFMonkey data.
-
Automated Chargebee Data Replication to Teradata
Use CData Sync to Customize and automate Chargebee data replication to Teradata.
-
Connect to Outreach.io Data in Aqua Data Studio
Access Outreach.io data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Import Real-Time EnterpriseDB Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use EnterpriseDB data in ColdFusion.
-
Create Dynamic Insightly Grids Using the Infragistics XamDataGrid
Learn how you can connect Insightly to Infragistics XamDataGrid to build dynamic grids.
-
Automate PostgreSQL Data Replication to Couchbase
Use CData Sync to Customize and automate PostgreSQL data replication to Couchbase.
-
Use the CData Software ODBC Driver for Paylocity in MicroStrategy
Connect to Paylocity data in MicroStrategy Developer using the CData Software ODBC Driver for Paylocity.
-
Automated Continuous Shopify Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Shopify replication to AlloyDB.
-
Build Data Flows from Coda to SQL Server using SSIS
Easily back up Coda data to SQL Server using the SSIS components for Coda.
-
Integrate LibreChat with Live Cassandra Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Cassandra data from within the chat interface.
-
Create SAP ByDesign-Connected Nintex Workflows
Use CData Connect AI to connect to SAP ByDesign Data from Nintex Workflow Cloud and build custom workflows using live SAP ByDesign data.
-
ShipStation Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to ShipStation data through CData Connect AI using different applications and tools.
-
Visualize LaunchDarkly Data in Tableau
The CData ODBC driver for LaunchDarkly enables you integrate LaunchDarkly data into Tableau dashboards.
-
Analyze SAP ByDesign Data in Cognos Analytics
Use CData Connect AI to connect to SAP ByDesign Data from Cognos Analytics and analyze live SAP ByDesign data.
-
Access Live MailChimp Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live MailChimp data from your Excel spreadsheets.
-
Visualize Live Slack Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Slack data into custom reports in Power BI.
-
Query Google Contacts Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Google Contacts data from Node.js.
-
Integrate Dify with Live SAP Business One Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Dify agents and workflows to securely access and query live SAP Business One data.
-
How to Connect the Power BI Service to Raisers Edge NXT: Complete Guide
Connect to the CData Software Power BI Connector for Raisers Edge NXT from PowerBI.com to provide real-time Raisers Edge NXT data across the organization.
-
How to Build an ETL App for xBase Data in Python with CData Connect AI
Extract and transform live xBase data in Python with petl and the CData Connect AI Python SDK.
-
How to Connect to Live Freshteam 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 Freshteam data for you.
-
How to Work with Mailjet Data in AWS Glue Jobs Using JDBC
Connect to Mailjet from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Connect to Miro Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Miro and work with Miro data in your FileMaker applications.
-
Create a Data Access Object for Quaderno Data using JDBI
A brief overview of creating a SQL Object API for Quaderno data in JDBI.
-
Build Apps with Live Azure Table data in Adalo using CData Connect AI
Use CData Connect AI to integrate live Azure Table data into the Adalo platform and build custom mobile and web applications with real-time Azure Table data.
-
Replicate Microsoft Exchange Data to Multiple Databases via the CData Sync CLI
Replicate Microsoft Exchange data to disparate databases with a single configuration.
-
Connect Bannerbear to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Bannerbear data using the CData Python MCP Server.
-
Access Live Snapchat Ads Data in AWS Lambda
Connect to live Snapchat Ads data in AWS Lambda using the CData JDBC Driver.
-
How to connect to Missive Data from Spring Boot
Connect to Missive in a Spring Boot Application using the CData API Driver for JDBC
-
Automated Continuous Clio Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Clio replication to Azure SQL Database.
-
Explore Geographical Relationships in MySQL Data with Power Map
Create data visualizations with MySQL data in Power Map.