CData Software - Knowledge Base
Recent Articles
-
How to Connect to Live Salesforce 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 Salesforce data for you.
-
Build ServiceNow-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for ServiceNow Data and create custom apps in Mendix.
-
Natively Connect to FHIR Data in PHP
The CData ODBC driver for FHIR enables you to create PHP applications with connectivity to FHIR data. Leverage the native support for ODBC in PHP.
-
Object-Relational Mapping (ORM) with Discord 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 Discord data into a Java-based ORM framework, Hibernate.
-
How to Connect to Live Apify 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 Apify data for you.
-
How to Connect to & Open PingOne Data in Microsoft Excel
This article uses the CData ODBC driver for PingOne to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Connect to Freshteam Data in Ruby
Connect to Freshteam data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Create SSAS Tabular Models from CloudConvert Data
How to build a SQL Server Analysis Service Tabular Model from CloudConvert data using CData drivers.
-
Connecting Mastra with Zoho Creator Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to enable Mastra agents to securely query, read, and act on real-time Zoho Creator data, no replication required.
-
Rapidly Develop Twitter Ads-Driven Apps with Active Query Builder
Leverage the Active Query Builder SQL interface and .NET data access to create data-driven WinForms and ASP.NET apps backed by Twitter Ads.
-
How to Connect to Live Quickbase 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 Quickbase data without replication.
-
Analyze CSV Data in Looker
Use CData Connect AI to connect to CSV Data from Looker and build custom apps using live CSV data.
-
Import and Visualize Parquet Data in Power View
Create data visualizations based on Parquet data in Excel.
-
Create SparkPost-Connected Dashboards in Grafana
Connect to SparkPost Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to SparkPost data.
-
Create Reports from Databricks Data in Looker Studio
Use CData Connect AI to gain access to live Databricks data and create custom reports in Looker Studio.
-
Load Bugsnag Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Bugsnag data to a database.
-
Build an OLAP Cube in SSAS from Placid Data
Establish a connection to Placid data data from SQL Server Analysis Services, and use the Placid Data Provider to build OLAP cubes for use in analytics and reporting.
-
Visualize SendPulse Data in Sisense
Create an ElastiCube in Sisense app with access to SendPulse data.
-
Automate GetResponse Data Replication to Azure Synapse
Use CData Sync to customize and automate GetResponse data replication to Azure Synapse.
-
Query Live Jira Assets 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 Jira Assets data directly from the development environment.
-
Connect to ClickTime Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for ClickTime and the SQL Gateway to access ClickTime data from Google Apps Script.
-
Import Zoho Inventory Data Using Azure Data Factory
Use CData Connect AI to connect to Zoho Inventory Data from Azure Data Factory and import live Zoho Inventory data.
-
Analyze Avalara AvaTax Data in Cognos Analytics
Use CData Connect AI to connect to Avalara AvaTax Data from Cognos Analytics and analyze live Avalara AvaTax data.
-
Build AI Agents with SAP Business One Data in IBM watsonx Orchestrate using CData Connect AI
Learn how to build intelligent agents in IBM watsonx Orchestrate that can securely access and act on live SAP Business One data through CData Connect AI.
-
Analyze Live Redshift Data in SAS Viya
Use CData Connect AI to connect to Redshift data from SAS Viya and deploy self-service analytics using live Redshift data.
-
Build Apps with Live Impala data in Adalo using CData Connect AI
Use CData Connect AI to integrate live Impala data into the Adalo platform and build custom mobile and web applications with real-time Impala data.
-
Moving Data from Printful to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Printful data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Automate Bullhorn CRM Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Bullhorn CRM data from PowerShell? This article demonstrates how to utilize the Bullhorn CRM Cmdlets for tasks like connecting to Bullhorn CRM data, automating operations, downloading data, and more.
-
Build Charts with SAS Data Sets Data in Clear Analytics
Create dynamic charts and perform analytics based on SAS Data Sets data in Clear Analytics.
-
Build Automated Zuora-Connected Workflows in Zapier
Use CData Connect AI to connect to live Zuora data and build automated workflows in Zapier.
-
Access Salesloft Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Salesloft data from HeidiSQL.
-
Automated Continuous Highrise Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Highrise replication to Amazon Redshift.
-
Process & Analyze Basecamp Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Basecamp Data.
-
Automated Continuous MarkLogic Replication to SingleStore
Use CData Sync for automated, continuous, customizable MarkLogic replication to SingleStore.
-
How to Use a Microsoft Access Database to Update Zendesk Data in Real Time
Update Zendesk data by creating a linked table in Microsoft Access with the CData Zendesk ODBC Driver.
-
Integrating Claude Code CLI 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.
-
Automated Continuous Egnyte Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Egnyte replication to Amazon Redshift.
-
Connect to and Query Nuclia Data in QlikView over ODBC
Create data visualizations with Nuclia data in QlikView.
-
Automated Continuous OpenWeatherMap Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable OpenWeatherMap replication to Azure SQL Database.
-
Getting Started with the CData Excel Add-In for AlloyDB
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for AlloyDB.
-
Access Exa Data from MySQL in PHP
Connect to Exa through the standard MySQL libraries in PHP.
-
Connect to Supabase Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Supabase data from Filemaker Pro on Mac.
-
Back Up SAP Ariba Source data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for SAP Ariba Source. In this article, we will employ an SSIS workflow to populate a database with SAP Ariba Source data data.
-
Connect to Live ADP Data in MicroStrategy through CData Connect AI
Create a live connection to ADP Data in CData Connect AI and connect to your ADP data from MicroStrategy.
-
Automated Continuous Basecamp Replication to MySQL
Use CData Sync for automated, continuous, customizable Basecamp replication to MySQL.
-
Create Grafana-Connected Dashboards in Grafana
Connect to Grafana Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Grafana data.
-
Integrate LibreChat with Live Oracle SCM Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Oracle SCM data from within the chat interface.
-
Consume JSON OData Feeds in PowerBuilder
This article demonstrates how to consume JSON services as OData feeds from PowerBuilder using the API Server.
-
A PostgreSQL Interface for ElevenLabs Data (MySQL Remoting via JDBC)
Use the Remoting features of the ElevenLabs JDBC Driver to create a PostgreSQL entry-point for data access.
-
Build Automated Bright Data-Connected Workflows in Zapier
Use CData Connect AI to connect to live Bright Data data and build automated workflows in Zapier.
-
Connect to MailChimp Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for MailChimp and the SQL Gateway to access MailChimp data from Google Apps Script.
-
Use Dash to Build to Web Apps on Facebook Ads Data
Create Python applications that use pandas and Dash to build Facebook Ads-connected web apps.
-
Automate Invoiced Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Invoiced data from PowerShell? This article demonstrates how to utilize the Invoiced Cmdlets for tasks like connecting to Invoiced data, automating operations, downloading data, and more.
-
Automated Continuous LinkedIn Ads Replication to SQL Server
Use CData Sync for automated, continuous, customizable LinkedIn Ads replication to SQL Server.
-
Build Perplexity-Connected Applications in Kiro with CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Kiro to securely access, query, and take action on live Perplexity data without replication.
-
Access Live Dropbox 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 Dropbox data through MCP integration.
-
Create Dashboards and Visualize Live Excel Online Data in Geckoboard
Use CData Connect AI to connect to live Excel Online data and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Create Zoho Creator Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Zoho Creator data access from reports, embedded analytics, and more.
-
Analyze Salesforce Pardot Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Salesforce Pardot data and visualize live Salesforce Pardot data in Infragistics Reveal.
-
Connect to CampaignMonitor Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for CampaignMonitor to connect to CampaignMonitor data and execute queries in PowerBuilder.
-
How to connect to Google Tasks Data from IntelliJ
Integrate connectivity to Google Tasks data with wizards in IntelliJ.
-
Natively Connect to Raisers Edge NXT Data in PHP
The CData ODBC driver for Raisers Edge NXT enables you to create PHP applications with connectivity to Raisers Edge NXT data. Leverage the native support for ODBC in PHP.
-
Query Live NetSuite SuiteAnalytics 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 NetSuite SuiteAnalytics data directly from the development environment.
-
Automated Continuous Invoiced Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Invoiced replication to Apache Cassandra.
-
Connect to LinkedIn Ads Data in Ruby
Connect to LinkedIn Ads data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
How to connect to GraphQL Data from IntelliJ
Integrate connectivity to GraphQL data with wizards in IntelliJ.
-
Create MongoDB-Connected Dashboards in Grafana
Connect to MongoDB Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to MongoDB data.
-
Use the CData Software ODBC Driver for Cassandra in MicroStrategy Web
Connect to Cassandra data in MicroStrategy Web using the CData Software ODBC Driver for Cassandra.
-
MailerLite Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to MailerLite data through CData Connect AI using different applications and tools.
-
How to Connect the Power BI Service to BambooHR: Complete Guide
Connect to the CData Software Power BI Connector for BambooHR from PowerBI.com to provide real-time BambooHR data across the organization.
-
How to work with Parquet Data in Apache Spark using SQL
Access and process Parquet Data in Apache Spark using the CData Software JDBC Driver.
-
Using the CData Software ODBC Driver for Amazon S3 in PyCharm
Connect to Amazon S3 as an ODBC data source in PyCharm using the CData Software ODBC Driver for Amazon S3.
-
Automated Continuous Hacker News Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Hacker News replication to Apache Cassandra.
-
Integrate Live Supabase Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf's Cascade agent to securely access and query live Supabase data from within the IDE.
-
Seamlessly Bring Zoho CRM Data into Retool Using CData Connect AI
Integrate Zoho CRM data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Access SAP Ariba Source Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live SAP Ariba Source data from HeidiSQL.
-
How to Connect Aweber 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 Aweber data in real time using natural language.
-
Back Up Vercel data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData API Driver for ADO.NET. In this article, we will employ an SSIS workflow to populate a database with Vercel data data.
-
Build Visualizations of Gumroad Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Gumroad data in Birst.
-
How to Visualize SAP Business One 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 SAP Business One data in Python.
-
DataBind Controls to SAP Fieldglass Data in Delphi
DataBind to SAP Fieldglass data in Delphi with standard data access components and controls.
-
Connect to Procore Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Procore to connect to Procore data and execute queries in PowerBuilder.
-
Visualize ShipStation Data in TIBCO Spotfire through OData
Integrate ShipStation data into dashboards in TIBCO Spotfire.
-
Connect to Outreach.io Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Outreach.io and the Script function in FileMaker Pro to connect to Outreach.io and work with Outreach.io data in your FileMaker application.
-
How to Work with Greenhouse Data in ETL Validator JDBC
Connect to Greenhouse from ETL Validator jobs using the CData Software JDBC Driver.
-
Publish Crystal Reports on Tanda Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Tanda data.
-
Integrating GitHub Copilot with Kafka 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 LlamaIndex with Zoho Projects Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Zoho Projects data in real time.
-
ETL Dynamics NAV in Oracle Data Integrator
This article shows how to transfer Dynamics NAV data into a data warehouse using Oracle Data Integrator.
-
Access Live Front Data in AWS Lambda
Connect to live Front data in AWS Lambda using the CData JDBC Driver.
-
Connect to Dotmailer Data in DBArtisan
Use wizards in DBArtisan to configure Dotmailer data as a data source.
-
Connect to Google Spanner Data in HULFT Integrate
Connect to Google Spanner as a JDBC data source in HULFT Integrate
-
Create Data Visualizations in Cognos BI with SparkPost Data
Access SparkPost data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Access Live MarkLogic 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 MarkLogic data through MCP integration.
-
Build a Singer.io Tap for Phoenix With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Phoenix data using the CData Python Connector.
-
Connect to HDFS Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time HDFS data using standard SQL.
-
Access Live Contentful Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Contentful data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Deploy the ADO.NET Provider for ZohoDesk on an SSRS Report Server
Connect to ZohoDesk data from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.
-
Automated Continuous Strava Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Strava replication to Google BigQuery.
-
Build Semantic Layer Views for ServiceDesk Plus Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for ServiceDesk Plus data.