CData Software - Knowledge Base
Recent Articles
-
Create Paddle Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Paddle data access from reports, embedded analytics, and more.
-
Automated Continuous OnePageCrm Replication to IBM DB2
Use CData Sync for automated, continuous, customizable OnePageCrm replication to IBM DB2.
-
Connect to Shopify Data from a Connection Pool in JBoss
Integrate Shopify data into Java servlets: Use the Management Console in JBoss to install the Shopify JDBC Driver.
-
Connecting Agentforce with Freshteam Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Agentforce to securely read and take actions on your Freshteam data for you.
-
Connect to Dynamics 365 Data from a Connection Pool in Jetty
The Dynamics 365 JDBC Driver supports connection pooling: This article shows how to connect faster to Dynamics 365 data from Web apps in Jetty.
-
How to Connect DBeaver to Kafka via a JDBC Driver
Manage Kafka data with visual tools in DBeaver like the query browser.
-
Build Dashboards with ChargeOver Data in DBxtra
Create dynamic dashboards and perform analytics based on ChargeOver data in DBxtra.
-
Visualize Live Attio Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Attio data.
-
Work with NetSuite Data in FoxPro
Load NetSuite data into a FoxPro database. This article includes full code and a walk-through of the process.
-
How to Connect to Live IBM Informix 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 IBM Informix data for you.
-
How to connect and process Adobe Commerce data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Adobe Commerce data.
-
Integrate Confluence Data in the Pentaho Report Designer
Publish reports based on Confluence data in the Pentaho BI tool.
-
Use Dash to Build Web Apps on YouTube Analytics Data via CData Connect AI
Build interactive Dash web apps on live YouTube Analytics data using pandas and the CData Connect AI Python SDK.
-
Start with CData Sync Part 1: Licensing, Creating Connections, and Creating a Replication Job
Use CData Sync to create a replication job.
-
Perform Batch Operations with Cosmos DB Data in Apache NiFi
Connect to Cosmos DB data and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
How to Connect to Live Kafka Data from Google ADK Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Google ADK agents to securely read and take actions on your Kafka data for you.
-
Access Live Omnisend Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Omnisend data into the statistical analysis tools available in SAS JMP. This article shows how to use Omnisend data in the Graph Builder and Query Builder.
-
Publish Notion-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Notion data.
-
Query Dynamics NAV Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Dynamics NAV data from Node.js.
-
Use the CData Software ODBC Driver for GitLab in SAS for Real-Time Reporting and Analytics
Connect to real-time GitLab data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for GitLab.
-
Query Typeform Data as a MySQL Database in Node.js
Execute MySQL queries against Typeform data from Node.js.
-
Create QuickBooks Online-Connected Dashboards in Grafana
Connect to QuickBooks Online Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to QuickBooks Online data.
-
Build Semantic Layer Views for Landbot Data in APOS Live Data Gateway
Use the CData Connector for Landbot in APOS Live Data Gateway to build Semantic Layer Views for Landbot data.
-
Publish Stripe-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Stripe data.
-
Viewing Blackbaud FE NXT Data in RAD Studio Data Explorer
How to view Blackbaud FE NXT data in RAD Studio Data Explorer using the CData ODBC Driver for Blackbaud FE NXT.
-
Operational Reporting on Front Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Front data.
-
Access Teradata 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 Teradata data.
-
Getting Started with the CData Power BI Connector for Avaza
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Connect to MarkLogic Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live MarkLogic data.
-
Feed Strava Data into FineReport
How to set Strava data as a JDBC data source in FineReport.
-
Natively Connect to ScrapingBee Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to ScrapingBee data. Leverage the native support for ODBC in PHP.
-
How to Connect to Live JSON Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live JSON services securely in real time.
-
How to Connect to Browserless Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Browserless data. Leverage the pyodbc module for ODBC in Python.
-
Moving Data from SendGrid to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live SendGrid data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Import Real-Time Bright Data Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Bright Data data in ColdFusion.
-
Use the CData Software JDBC Driver for Parallel in MicroStrategy Desktop
Connect to Parallel data in MicroStrategy Desktop using the CData Software JDBC Driver for Parallel.
-
Explore Geographical Relationships in Typeform Data with Power Map
Create data visualizations with Typeform data in Power Map.
-
Connecting Pipedream with Google Calendar Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Pipedream workflows to securely read and take actions on Google Calendar data in real time.
-
Publish Crystal Reports on Oracle Financials Cloud Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Oracle Financials Cloud data.
-
Visualize Live Outreach.io Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Outreach.io data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Configure the CData JDBC Driver for TigerGraph in a Connection Pool in Tomcat
Connect to TigerGraph data from a connection pool in Tomcat.
-
Integrating OpenCode with Zoho CRM 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 Adobe Commerce Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Adobe Commerce replication to Amazon Redshift.
-
Create Twilio-Connected Nintex Workflows
Use CData Connect AI to connect to Twilio Data from Nintex Workflow Cloud and build custom workflows using live Twilio data.
-
Connecting GenSpark with Spark Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Spark data without any replication or custom integration required.
-
How to connect to Strava Data from Spring Boot
Connect to Strava in a Spring Boot Application using the CData API Driver for JDBC
-
Automated Continuous SharePoint Excel Services Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable SharePoint Excel Services replication to Apache Cassandra.
-
Connect to Zoho Inventory Data in Ruby
Connect to Zoho Inventory data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Use the CData Software ODBC Driver for LightSpeedRetail in MicroStrategy
Connect to LightSpeedRetail data in MicroStrategy Developer using the CData Software ODBC Driver for LightSpeedRetail.
-
Use ChatGPT to Talk to Your Klaviyo 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 Klaviyo data for you.
-
Visualize Live Amplitude Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Amplitude data.
-
LINQ to QuickBooks
LINQ provides general-purpose query facilities in .NET Framework 3.0 and above and provides one easy way to programmatically access data through from CData Data Providers for ADO.NET. This example uses LINQ to access information from the QuickBooks Data Provider.
-
A PostgreSQL Interface for Pinterest Data using the CData ODBC Driver
Use the SQL Gateway and Pinterest ODBC Driver to create a PostgreSQL entry-point for data access.
-
Design BIRT Reports on QuickBooks Online Data
Provide current QuickBooks Online data to your embedded analytics.
-
Build Aweber-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 Aweber data without replication.
-
Integrating Cursor with Google Ad Manager 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.
-
Visualize Live Omnisend Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Omnisend data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Build an OLAP Cube in SSAS from Bitly Data
Establish a connection to Bitly data data from SQL Server Analysis Services, and use the Bitly Data Provider to build OLAP cubes for use in analytics and reporting.
-
Create Apps from Printify Data in Qlik Sense Cloud
Use CData Connect AI to connect to Printify Data and build apps from live Printify data in Qlik Sense Cloud.
-
Analyze Kintone Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Kintone data with the CData JDBC Driver for Kintone.
-
Connect to IBM Cloud Object Storage Data from AWS Glue
Use CData Connect AI to gain access to live IBM Cloud Object Storage data from your AWS Glue jobs.
-
Integrating Gumloop with ZohoMarketingHub Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on ZohoMarketingHub data within automated workflows.
-
Connect to Apify Data in RapidMiner
Integrate Apify data with standard components and data source configuration wizards in RapidMiner Studio.
-
Use JayDeBeApi to access Miro Data in Python
Use standard Python scripting and the development environment of your choice to access live Miro data.
-
Connect to AfterShip Data in NetBeans
Connect to AfterShip data in NetBeans with the data source configuration wizard.
-
How to import Exact Online Data into Apache Solr
Use the CData Software JDBC Driver for Exact Online in Data Import Handler and create an automated import of Exact Online data to Apache Solr Enterprise Search platform.
-
Use the CData Software ODBC Driver for Amazon Marketplace in SAS for Real-Time Reporting and Analytics
Connect to real-time Amazon Marketplace data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Amazon Marketplace.
-
Use the CData ODBC Driver for EnterpriseDB from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for EnterpriseDB to connect to EnterpriseDB data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring EnterpriseDB data in Excel.
-
How to Work with Salesloft Data in AWS Glue Jobs Using JDBC
Connect to Salesloft from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Replicate Multiple Planio Accounts via the CData Sync CLI
Replicate multiple Planio accounts to one or many databases.
-
Easily Integrate SendGrid Data in Lazarus Pascal IDE
Learn how to easily integrate live SendGrid data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Automated Pingdom Data Replication to Teradata
Use CData Sync to Customize and automate Pingdom data replication to Teradata.
-
Integrate Yelp Data in the Pentaho Report Designer
Publish reports based on Yelp data in the Pentaho BI tool.
-
Access Timely Data from MySQL in PHP
Connect to Timely through the standard MySQL libraries in PHP.
-
Visualize AfterShip Data in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load AfterShip data into TIBCO Spotfire.
-
How to Connect to Live Jira 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 Jira data without replication.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Supabase
Provide connectivity to Supabase data through an SAP BusinessObjects universe.
-
Integrate ZohoPeople Data into Power Automate Desktop using CData Connect
CData Connect for ZohoPeople Data enables you to integrate ZohoPeople data into workflows built using Microsoft Power Automate Desktop.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for MailChimp
Provide connectivity to MailChimp data through an SAP BusinessObjects universe.
-
Connect to Real-Time SuiteCRM Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for SuiteCRM and Dataflow to import and use SuiteCRM data in Power Apps.
-
Automated Continuous Freshsales Replication to SQLite
Use CData Sync for automated, continuous, customizable Freshsales replication to SQLite.
-
Access Act CRM Data from MySQL in PHP
Connect to Act CRM through the standard MySQL libraries in PHP.
-
How to Access SparkPost Data Using Entity Framework
This article shows how to access SparkPost data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Build Klaviyo-Connected Apps in Choreo
Use CData Connect AI to connect to Klaviyo Data from Choreo and build custom apps using live Klaviyo data.
-
Viewing MYOB AccountRight Data in RAD Studio Data Explorer
How to view MYOB AccountRight data in RAD Studio Data Explorer using the CData ODBC Driver for MYOB AccountRight.
-
Integrate iContact Data into Power Automate Desktop using CData Connect
CData Connect for iContact Data enables you to integrate iContact data into workflows built using Microsoft Power Automate Desktop.
-
Analyze BenchmarkEmail Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze BenchmarkEmail data in Microsoft R Open.
-
Visualize Printful Data in Tableau
The CData ODBC driver for Printful enables you integrate Printful data into Tableau dashboards.
-
Connect to SuiteCRM Data in Jaspersoft Studio
Execute SQL to remote SuiteCRM data in Jaspersoft Studio.
-
Access Live YouTube Analytics Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to YouTube Analytics data from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
LINQ to GitHub 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 GitHub Data Provider.
-
Connect to Parallel Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Parallel data using standard SQL.
-
Work with Browserless Data in FoxPro
Load Browserless data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Integrate Devin with Live Stripe Data Using CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Devin, the AI software engineer, to securely access and query live Stripe data.
-
Integrate LibreChat with Live HubSpot Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live HubSpot data from within the chat interface.
-
Use the CData SSIS Components to Insert New or Update Existing Outreach.io Records from SQL Server
Easily push SQL Server data to Outreach.io using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Outreach.io or update existing records with data from a SQL Server database.
-
Connect to FreeAgent Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to FreeAgent and work with FreeAgent data in your FileMaker applications.
-
Rapidly Develop Rebilly-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 Rebilly.
-
How to use SQLAlchemy ORM to access Shopify Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Shopify data.
-
Integrating OpenCode with Reckon 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.