CData Software - Knowledge Base
Recent Articles
-
A PostgreSQL Interface for Spotify Data (MySQL Remoting via JDBC)
Use the Remoting features of the Spotify JDBC Driver to create a PostgreSQL entry-point for data access.
-
How to Connect Flowise AI Agents to Live ZohoDesk 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 ZohoDesk data without replication.
-
How to use SQLAlchemy ORM to access Twilio Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Twilio data.
-
Build Semantic Layer Views for Sage Cloud Accounting Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Sage Cloud Accounting data.
-
How to Query Spotify Data in MySQL Workbench
Execute MySQL queries against live Spotify data from MySQL Workbench.
-
Getting Started with the CData ADO.NET Provider for Printify
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Replicate Azure Synapse Data in Heroku for Use in Salesforce Connect
Replicate Azure Synapse data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
ChartMogul Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on ChartMogul facts in real time.
-
Replicate Act-On Data to Multiple Databases via the CData Sync CLI
Replicate Act-On data to disparate databases with a single configuration.
-
Automated Continuous ShipStation Replication to MongoDB
Use CData Sync for automated, continuous, customizable ShipStation replication to MongoDB.
-
Automated Continuous ZohoExpense Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable ZohoExpense replication to Amazon Redshift.
-
Automated Continuous SpaceX Replication to IBM DB2
Use CData Sync for automated, continuous, customizable SpaceX replication to IBM DB2.
-
Automated Continuous iContact Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable iContact data replication to OneLake in Microsoft Fabric.
-
Write a Simple Go Application to work with Microsoft Dataverse Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Microsoft Dataverse data.
-
LINQ to Excel Data
LINQ offers versatile querying capabilities within the .NET Framework (v3.0+), offering a straightforward method for programmatic data access through CData ADO.NET Data Providers. In this article, we demonstrate the use of LINQ to retrieve information from the Excel Data Provider.
-
Integrate with live SAP Ariba Source Data in Jitterbit
Use CData Connect AI to connect to and integrate live SAP Ariba Source data in Jitterbit.
-
Connect to SAP Concur Data in DBArtisan
Use wizards in DBArtisan to configure SAP Concur data as a data source.
-
Query Presto Data in DataGrip
Create a Data Source for Presto in DataGrip and use SQL to query live Presto data.
-
How to Easily Query Shopify Data in OpenOffice Base
Connect to Shopify data in OpenOffice Base using the CData ODBC Driver for Shopify and generate reports with live data insights.
-
Build Dashboards with SendInBlue Data in DBxtra
Create dynamic dashboards and perform analytics based on SendInBlue data in DBxtra.
-
Visualize Live Impala Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Impala data into custom reports in Power BI.
-
Connect to Cassandra Data in RapidMiner
Integrate Cassandra data with standard components and data source configuration wizards in RapidMiner Studio.
-
Automated Continuous Hubstaff Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Hubstaff replication to Amazon Redshift.
-
Process & Analyze SageHR Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live SageHR Data.
-
Connect to and Visualize Live ZarMoney Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live ZarMoney data.
-
Work with YouTube Analytics Data in FoxPro
Load YouTube Analytics data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Access Mistral AI 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 Mistral AI data.
-
Integrate Live Optimizely Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Optimizely data and integrate live Optimizely data into apps built in Microsoft Power Apps.
-
Connect to Live ZohoPeople Data in PostGresSQL Interface through CData Connect AI
Create a live connection to ZohoPeople in CData Connect AI and connect to your ZohoPeople data from PostgreSQL.
-
Build MVC Applications with Connectivity to Missive Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Missive from an ASP.NET MVC application.
-
Configure the CData JDBC Driver for Vimeo in a Connection Pool in Tomcat
Connect to Vimeo data from a connection pool in Tomcat.
-
Use Dash to Build to Web Apps on SAP Business One Data
Create Python applications that use pandas and Dash to build SAP Business One-connected web apps.
-
Automated Continuous Contentful Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Contentful replication to Google Cloud SQL.
-
Connect to and Visualize Live Shortcut Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Shortcut data.
-
Integrate Instagram Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Instagram data from Informatica Cloud.
-
Connect to Splunk Data from PowerBuilder via ADO.NET
This article demonstrates how to access Splunk data from Appeon PowerBuilder using the CData ADO.NET Provider for Splunk.
-
Connect to Salesloft Data in Ruby
Connect to Salesloft data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Build a Simple VCL Application for Float Data
How to build a simple VCL Application to view Float data in RAD Studio using the CData ODBC Driver for Float.
-
DataBind Controls to Shortcut Data in C++Builder
DataBind to Shortcut data in C++Builder with standard components and controls.
-
Visualize SharePoint Excel Services Data in TIBCO Spotfire through OData
Integrate SharePoint Excel Services data into dashboards in TIBCO Spotfire.
-
Use the CData Software JDBC Driver for IBM Cloud Object Storage in MicroStrategy
Connect to IBM Cloud Object Storage data in MicroStrategy Developer using the CData Software JDBC Driver for IBM Cloud Object Storage.
-
Connect to Zoho CRM in SpagoBI
Create reports featuring live Zoho CRM data in SpagoBI Studio. Host Zoho CRM reports on SpagoBI Server.
-
Integrate Salesloft Data into Power Automate Desktop using CData Connect
CData Connect for Salesloft Data enables you to integrate Salesloft data into workflows built using Microsoft Power Automate Desktop.
-
Use the CData Software JDBC Driver for Acumatica in MicroStrategy Web
Connect to Acumatica data in MicroStrategy Web using the CData Software JDBC Driver for Acumatica.
-
Build Apps with Live Factorial Data Using the Low-Code Development Platform of Mendix
Connect Factorial data with Mendix to build apps using the CData API Driver for JDBC.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Email
Provide connectivity to Email data through an SAP BusinessObjects universe.
-
Automated Continuous Supabase Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Supabase replication to PostgreSQL.
-
Integrate ZendeskSell Data in the Pentaho Report Designer
Publish reports based on ZendeskSell data in the Pentaho BI tool.
-
Create a Data Access Object for Apify Data using JDBI
A brief overview of creating a SQL Object API for Apify data in JDBI.
-
Manage FTP Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for FTP.
-
How to connect and process Browserless data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Browserless data.
-
How to connect to Opsgenie Data with Squirrel SQL client
Connect to Opsgenie data and execute queries in the Squirrel SQL Client.
-
Getting Started with the CData Python Connector for eBay Analytics
Learn to install and license the CData Python Connector and configure a connection to live eBay Analytics data.
-
Use Azure AI Foundry to Talk to Your BigQuery 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 BigQuery data for you.
-
Connect to Azure Analysis Services Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Azure Analysis Services as an External Source in Dremio.
-
Choosing the Best Method to Connect Zoho Projects to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Zoho Projects data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Getting Started with the CData JDBC Driver for MailChimp
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for MailChimp.
-
How to Connect to Live GetResponse 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 GetResponse data for you.
-
Configure the CData JDBC Driver for Aweber in a Connection Pool in Tomcat
Connect to Aweber data from a connection pool in Tomcat.
-
Integrate Sage Cloud Accounting Data into Power Automate Desktop using CData Connect
CData Connect for Sage Cloud Accounting Data enables you to integrate Sage Cloud Accounting data into workflows built using Microsoft Power Automate Desktop.
-
Work with QuickBooks Data in FoxPro
Load QuickBooks data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Integrating Claude Code with SparkPost Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on SparkPost data within assisted coding and automated development workflows.
-
Create Power BI Reports on Real-Time HubSpot Data
Use the CData ODBC Driver for HubSpot to visualize HubSpot data in Power BI Desktop.
-
Access EnterpriseDB Data from MySQL in PHP
Connect to EnterpriseDB through the standard MySQL libraries in PHP.
-
Build Paymo Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Paymo data and build visualizations in Tableau.
-
Build Semantic Layer Views for ClickUp Data in APOS Live Data Gateway
Use the CData Connector for ClickUp in APOS Live Data Gateway to build Semantic Layer Views for ClickUp data.
-
Analyze MYOB AccountRight Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze MYOB AccountRight data in Microsoft R Open.
-
Access Live Reckon Accounts Hosted Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Reckon Accounts Hosted data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Access Live Google Campaign Manager 360 Data in Coginiti Pro
Connect to and query live Google Campaign Manager 360 data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Integrate Bugsnag with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Bugsnag with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Bugsnag data.
-
How to Connect Flowise AI Agents to Live Sage Intacct 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 Sage Intacct data without replication.
-
Automated Continuous Zoho Projects Replication to SingleStore
Use CData Sync for automated, continuous, customizable Zoho Projects replication to SingleStore.
-
Build Smartsheet-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Smartsheet data and build web apps with connectivity to live Smartsheet data.
-
Back Up Sage Cloud Accounting data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Sage Cloud Accounting. In this article, we will employ an SSIS workflow to populate a database with Sage Cloud Accounting data data.
-
Use Azure AI Foundry to Talk to Your SFTP 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 SFTP data for you.
-
Use Agno to Talk to Your ServiceNow Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Agno agents to securely answer questions and take actions on your ServiceNow data for you.
-
Add Neo4J Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Neo4J with the Informatica Enterprise Data Catalog to classify and organize data.
-
Access Live Outlook Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Outlook data into the statistical analysis tools available in SAS JMP. This article shows how to use Outlook data in the Graph Builder and Query Builder.
-
How to Connect to & Open ElevenLabs Data in Microsoft Excel
This article uses the CData ODBC driver for ElevenLabs to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Excel Spreadsheet Automation on BigQuery Data with the QUERY Formula
Pull data from BigQuery, automate spreadsheets, and more with the QUERY formula.
-
How to Connect to Live Oracle Eloqua 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 Oracle Eloqua data for you.
-
Getting Started with the CData SSIS Components for Teamwork
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Teamwork.
-
How to integrate Cosmos DB with Apache Airflow
Access and process Cosmos DB data in Apache Airflow using the CData JDBC Driver.
-
How to Connect DBeaver to SFTP via a JDBC Driver
Manage SFTP data with visual tools in DBeaver like the query browser.
-
Elorus Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Elorus facts in real time.
-
Use Azure AI Foundry to Talk to Your ADP 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 ADP data for you.
-
Connect to Live Quickbase Data in MicroStrategy through CData Connect AI
Create a live connection to Quickbase Data in CData Connect AI and connect to your Quickbase data from MicroStrategy.
-
Getting Started with the CData Connect AI Python SDK for BigQuery
Install the CData Connect AI Python SDK to read and write live BigQuery data with standard DB-API 2.0 Python code.
-
Provide OData Services of Rebilly Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Rebilly data by developing a WCF Service Application.
-
Integrate Goose with Live Paylocity Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Paylocity data from within the local AI agent.
-
Build Visualizations of Monday.com Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Monday.com data in Birst.
-
Connect to Keap Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Keap data using standard SQL.
-
Connect Aweber to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Aweber data using the CData Python MCP Server.
-
How to Connect to Live Oracle Sales 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 Oracle Sales data for you.
-
Integrating Claude Code with SAS Data Sets Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on SAS Data Sets data within assisted coding and automated development workflows.
-
Connect to Certinia Data from AWS Glue
Use CData Connect AI to gain access to live Certinia data from your AWS Glue jobs.
-
Automated Continuous Pushbullet Replication to SingleStore
Use CData Sync for automated, continuous, customizable Pushbullet replication to SingleStore.
-
Establish a Live Connection with Shippo Data using Tableau Bridge
The CData ODBC Driver for Shippo enables you to integrate live Shippo data into Tableau Cloud dashboards using the Tableau Bridge.
-
Integrating OpenCode with ClickTime 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.
-
How to Visualize Pinecone Data in Python with pandas
Use pandas and other modules to analyze and visualize live Pinecone data in Python.