CData Software - Knowledge Base
Recent Articles
-
Connect to Freshteam Data in Ruby
Connect to Freshteam data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Integrate with Live PayPal Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to PayPal from the MuleSoft Anypoint Platform to integrate live PayPal data into custom reports and dashboards.
-
Access Tavily Data from MySQL in PHP
Connect to Tavily through the standard MySQL libraries in PHP.
-
Connect Superchat to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Superchat data using the CData Python MCP Server.
-
NetSuite Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to NetSuite data through CData Connect AI using different applications and tools.
-
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.
-
Integrating Claude Code CLI with Greenplum 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.
-
Connecting GenSpark with Hive Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Hive data without any replication or custom integration required.
-
Use Agno to Talk to Your Freshdesk 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 Freshdesk data for you.
-
Build AI Agents with Google Ads 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 Google Ads data through CData Connect AI.
-
Connect to SAP Netweaver Gateway Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for SAP Netweaver Gateway data.
-
How to Access Zoho Projects Data Using Entity Framework
This article shows how to access Zoho Projects data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
How to Query Live Hacker News Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Hacker News data data in natural language using Python.
-
Easily Integrate Freshdesk Data in Lazarus Pascal IDE
Learn how to easily integrate live Freshdesk data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Integrate Zendesk Data into Power Automate Desktop using CData Connect
CData Connect for Zendesk Data enables you to integrate Zendesk data into workflows built using Microsoft Power Automate Desktop.
-
Connecting Moonlit Workflow with Grafana Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Moonlit workflows to securely read and act on your Grafana data in real time.
-
Automated Continuous Highrise Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Highrise replication to Amazon Redshift.
-
Import Zoho Projects Data Using Azure Data Factory
Use CData Connect AI to connect to Zoho Projects Data from Azure Data Factory and import live Zoho Projects data.
-
Model ServiceDesk Plus Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and ServiceDesk Plus, enabling the direct import of real-time ServiceDesk Plus data.
-
How to Connect to Live Optimizely 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 Optimizely data for you.
-
Create GitHub-Connected Dashboards in Grafana
Connect to GitHub Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to GitHub data.
-
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.
-
Using the CData Software ODBC Driver for Placid in PyCharm
Connect to Placid as an ODBC data source in PyCharm using the CData Software ODBC Driver for Placid.
-
Build Dashboards with SendPulse Data in DBxtra
Create dynamic dashboards and perform analytics based on SendPulse data in DBxtra.
-
Automated Continuous Autopilot Replication to SingleStore
Use CData Sync for automated, continuous, customizable Autopilot replication to SingleStore.
-
How to Connect Flowise AI Agents to Live Procore 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 Procore data without replication.
-
How to Work with Float Data in AWS Glue Jobs Using JDBC
Connect to Float from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
SAP Concur Reporting in OBIEE with the SAP Concur JDBC Driver
Deploy the SAP Concur JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Integrate Accelo Data in the Pentaho Report Designer
Publish reports based on Accelo data in the Pentaho BI tool.
-
Build Automated Mailjet-Connected Workflows in Zapier
Use CData Connect AI to connect to live Mailjet data and build automated workflows in Zapier.
-
Perform API Operations Using the CData SharePoint Task
The CData SharePoint Task allows you to easily call stored procedures to perform SharePoint API operations.
-
Search External Yelp Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Yelp data to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Yelp Data objects that you can access from apps and the dashboard.
-
A PostgreSQL Interface for ChargeOver Data (MySQL Remoting via JDBC)
Use the Remoting features of the ChargeOver JDBC Driver to create a PostgreSQL entry-point for data access.
-
Replicate SAP Fieldglass Data to Multiple Databases via the CData Sync CLI
Replicate SAP Fieldglass data to disparate databases with a single configuration.
-
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.
-
Create Reports with Hacker News Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Hacker News 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.
-
Create Keap Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Keap data access from reports, embedded analytics, and more.
-
Automated Continuous Basecamp Replication to MySQL
Use CData Sync for automated, continuous, customizable Basecamp replication to MySQL.
-
Build Agents in Relevance AI with Access to Live SAP SuccessFactors LMS Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on SAP SuccessFactors LMS data within intelligent agent workflows.
-
Integrating Gumloop with Stripe Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Stripe data within automated workflows.
-
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.
-
Easily Integrate Google Ad Manager Data in Lazarus Pascal IDE
Learn how to easily integrate live Google Ad Manager data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Automate Greenhouse Data Replication to Azure Synapse
Use CData Sync to customize and automate Greenhouse data replication to Azure Synapse.
-
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.
-
How to connect SharePoint with Twilio Data through external lists
Provide Twilio data to SharePoint users as an external list.
-
Automated Continuous LaunchDarkly Replication to IBM DB2
Use CData Sync for automated, continuous, customizable LaunchDarkly replication to IBM DB2.
-
Integrate Email with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Email with External Services.
-
Build WooCommerce-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 WooCommerce data without replication.
-
Access IBM Cloud Object Storage 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 IBM Cloud Object Storage data.
-
Visualize Mistral AI Data in TIBCO Spotfire through ADO.NET
Integrate Mistral AI data into dashboards in TIBCO Spotfire.
-
How to Query SAP Fieldglass Data in MySQL Workbench
Execute MySQL queries against live SAP Fieldglass data from MySQL Workbench.
-
Integrate QuickBooks Time Data into Power Automate Desktop using CData Connect
CData Connect for QuickBooks Time Data enables you to integrate QuickBooks Time data into workflows built using Microsoft Power Automate Desktop.
-
Build Bannerbear-Connected Apps in Choreo
Use CData Connect AI to connect to Bannerbear Data from Choreo and build custom apps using live Bannerbear data.
-
Use Claude to Talk to Your Azure Table 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 Azure Table data for you.
-
Access Live SageHR Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to SageHR data from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Moving Data from SAS Data Sets to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live SAS Data Sets data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
How to Connect to Live Snapchat 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 Snapchat Ads data for you.
-
How to connect PolyBase to Drip
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Drip data.
-
Integrate Google Spanner with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Google Spanner with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Google Spanner data.
-
Connect Zoho Creator Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Zoho Creator data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Publish HubSpot-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live HubSpot data.
-
How to Connect to & Open Demio Data in Microsoft Excel
This article uses the CData ODBC driver for Demio to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
How to connect to GraphQL Data from IntelliJ
Integrate connectivity to GraphQL data with wizards in IntelliJ.
-
Freshservice Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Freshservice facts in real time.
-
Access Live Tavily Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Tavily data from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Create Greenhouse-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Greenhouse Data from OutSystems and build custom enterprise apps using live Greenhouse data.
-
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.
-
Import Real-Time Customer.io Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Customer.io data in ColdFusion.
-
How to connect to SendPulse Data from IntelliJ
Integrate connectivity to SendPulse data with wizards in IntelliJ.
-
Connect to Sage 200 Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Sage 200 to connect to Sage 200 data and execute queries in PowerBuilder.
-
Access Redshift Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Redshift data from HeidiSQL.
-
Connect to Salesloft Data in HULFT Integrate
Connect to Salesloft as a JDBC data source in HULFT Integrate
-
Connect to SAP Concur Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for SAP Concur and the Script function in FileMaker Pro to connect to SAP Concur and work with SAP Concur data in your FileMaker application.
-
Automated Continuous Intercom Replication to Snowflake
Use CData Sync for automated, continuous, customizable Intercom replication to Snowflake.
-
Integrate with FreshBooks Data in SnapLogic
Use CData Connect AI to connect to and integrate with live FreshBooks data in SnapLogic.
-
Migrating data from Oracle to Databricks using CData SSIS Components.
Easily push Oracle data to Databricks using the CData SSIS Tasks for Oracle and Databricks.
-
Connect to Autopilot Data from a Connection Pool in Jetty
The Autopilot JDBC Driver supports connection pooling: This article shows how to connect faster to Autopilot data from Web apps in Jetty.
-
Load CSV Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load CSV data to a database.
-
Connect to OpenWeatherMap Data in Aqua Data Studio
Access OpenWeatherMap data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Automated Continuous SAP Fieldglass Replication to Amazon S3
Use CData Sync for automated, continuous, customizable SAP Fieldglass replication to Amazon S3.
-
Connect to LinkedIn Data from a Connection Pool in JBoss
Integrate LinkedIn data into Java servlets: Use the Management Console in JBoss to install the LinkedIn JDBC Driver.
-
Migrating data from CockroachDB to Snowflake using CData SSIS Components.
Easily push CockroachDB data to Snowflake using the CData SSIS Tasks for CockroachDB and Snowflake.
-
Integrating Kiro with Mixpanel 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.
-
Access HDFS Data from MySQL in Amazon QuickSight
Connect to HDFS and build visualizations of HDFS data using a MySQL Connection in Amazon QuickSight.
-
How to Seamlessly Import Avro Data into IBM SPSS Modeler
Integrate Avro data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
How to Query Live SAP Hybris C4C Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live SAP Hybris C4C data data in natural language using Python.
-
Connect to SAP Business One Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to SAP Business One.
-
Use the CData ODBC Driver for ZarMoney from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for ZarMoney to connect to ZarMoney data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring ZarMoney data in Excel.
-
How to Query Live SharePoint Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live SharePoint data data in natural language using Python.
-
Calendly Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Calendly facts in real time.
-
Access Live Omnisend Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Omnisend data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Viewing Amazon DynamoDB Data in RAD Studio Data Explorer
How to view Amazon DynamoDB data in RAD Studio Data Explorer using the CData ODBC Driver for Amazon DynamoDB.
-
Stream Parquet Data into Apache Kafka Topics
Access and stream Parquet data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Automated Continuous Sentry Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Sentry replication to AlloyDB.
-
How to import Tanda Data into Apache Solr
Use the CData Software JDBC Driver for Tanda in Data Import Handler and create an automated import of Tanda data to Apache Solr Enterprise Search platform.
-
Access Microsoft Exchange Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Microsoft Exchange data from HeidiSQL.
-
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.