CData Software - Knowledge Base
Recent Articles
-
Getting Started with the CData Excel Add-In for QuickBooks Online
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for QuickBooks Online.
-
Access ZohoExpense Data from MySQL in Amazon QuickSight
Connect to ZohoExpense and build visualizations of ZohoExpense using a MySQL Connection in Amazon QuickSight.
-
Analyze Authorize.Net Data in Infragistics Reveal
Use the CData API Server to create an OData API on top of Authorize.Net and visualize live Authorize.Net in Infragistics Reveal.
-
Replicate Multiple Perplexity Accounts
Replicate multiple Perplexity accounts to one or many databases.
-
Connect and Query Live SAP Hybris C4C Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live SAP Hybris C4C into Databricks
-
Import Act-On Data Using Azure Data Factory
Use CData Connect AI to connect to Act-On Data from Azure Data Factory and import live Act-On.
-
Replicate Multiple ZohoMarketingHub Accounts
Replicate multiple ZohoMarketingHub accounts to one or many databases.
-
Connect to Freshteam Data in Ruby
Connect to Freshteam 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 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 using the CData Python MCP Server.
-
NetSuite Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to NetSuite CRM & ERP 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/TSV Files.
-
Import and Visualize Parquet Data in Power View
Create data visualizations based on Apache Parquet 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 Apache Hive 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 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 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.
-
How to Access Zoho Projects Data Using Entity Framework
This article shows how to access Zoho Projects 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 in natural language using Python.
-
Easily Integrate Freshdesk Data in Lazarus Pascal IDE
Learn how to easily integrate live Freshdesk 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 into workflows built using Microsoft Power Automate Desktop.
-
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.
-
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.
-
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 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 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 in the Pentaho BI tool.
-
Perform API Operations Using the CData SharePoint Task
The CData SharePoint Task allows you to easily call stored procedures to perform SharePoint API operations.
-
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 to disparate databases with a single configuration.
-
Automated Continuous LionDesk Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable LionDesk replication to Google Cloud SQL.
-
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.
-
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 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 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 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 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 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 from Google Apps Script.
-
How to connect SharePoint with Twilio Data through external lists
Provide Twilio 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.
-
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.
-
Visualize Mistral AI Data in TIBCO Spotfire through ADO.NET
Integrate Mistral AI into dashboards in TIBCO Spotfire.
-
How to Query SAP Fieldglass Data in MySQL Workbench
Execute MySQL queries against live SAP Fieldglass 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 into workflows built using Microsoft Power Automate Desktop.
-
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 Storage for you.
-
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 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.
-
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.
-
Connect Zoho Creator Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Zoho Creator 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.
-
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 with wizards in IntelliJ.
-
Freshservice Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Freshservice facts in real time.
-
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.
-
Import Real-Time Customer.io Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Customer.io in ColdFusion.
-
How to connect to SendPulse Data from IntelliJ
Integrate connectivity to SendPulse 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 and execute queries in PowerBuilder.
-
Access Redshift Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Amazon Redshift 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 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 in SnapLogic.
-
Migrating data from Oracle to Databricks using CData SSIS Components.
Easily push Oracle Database 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 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/TSV Files to a database.
-
Connect to OpenWeatherMap Data in Aqua Data Studio
Access OpenWeatherMap 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 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 to Snowflake using the CData SSIS Tasks for CockroachDB and Snowflake.
-
Integrating Kiro CLI 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 Apache HDFS 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 in natural language using Python.
-
Connect to SAP Business One Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
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 from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring ZarMoney in Excel.
-
How to Query Live SharePoint Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Microsoft SharePoint 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 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 in RAD Studio Data Explorer using the CData ODBC Driver for Amazon DynamoDB.
-
Stream Parquet Data into Apache Kafka Topics
Access and stream Apache Parquet in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
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 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 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.
-
Create Avalara AvaTax-Connected Business Apps in AppSheet
Connect to Avalara AvaTax Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Avalara AvaTax.
-
Use the CData ODBC Driver for AlloyDB from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for AlloyDB to connect to Google AlloyDB from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Google AlloyDB in Excel.
-
Connect to Dotmailer Data in DBArtisan
Use wizards in DBArtisan to configure Dotmailer as a data source.
-
Connect to EmailOctopus Data in Aqua Data Studio
Access EmailOctopus from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.