CData Software - Knowledge Base
Recent Articles
-
Automated Continuous DB2 Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable DB2 replication to Google BigQuery.
-
Access Act-On Data from MySQL in Amazon QuickSight
Connect to Act-On and build visualizations of Act-On using a MySQL Connection in Amazon QuickSight.
-
Connect to ServiceNow Data in ACL Analytics
Connect to ServiceNow via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to ServiceNow.
-
Load QuickBooks Online Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load QuickBooks Online to a database.
-
Visualize Suadeo Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Suadeo.
-
Build a Simple VCL Application for Eventbrite Data
How to build a simple VCL Application to view Eventbrite in RAD Studio using the CData ODBC Driver for Eventbrite.
-
Access Live Paddle Data in AWS Lambda
Connect to live Paddle in AWS Lambda using the CData JDBC Driver.
-
Automated Continuous Attio Replication to SQL Server
Use CData Sync for automated, continuous, customizable Attio replication to SQL Server.
-
Use CData Connect AI to Access Microsoft Planner Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Microsoft Planner in the Power Pivot business intelligence tool.
-
How to create an RPA flow for OnePageCrm Data in UiPath Studio
Use the OnePageCrm ODBC Driver to create workflows that access real-time OnePageCrm without any coding.
-
How to Work with LionDesk Data in ETL Validator JDBC
Connect to LionDesk from ETL Validator jobs using the CData Software JDBC Driver.
-
Access Live Microsoft Teams 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 Microsoft Teams through MCP integration.
-
Connect to ChargeOver Data in Jaspersoft Studio
Execute SQL to remote ChargeOver in Jaspersoft Studio.
-
How to Import Data from AlloyDB into Google Sheets
Import Google AlloyDB into a Google spreadsheet that is automatically refreshed.
-
Use the CData Software ODBC Driver for Toggl in MicroStrategy Desktop
Connect to Toggl in MicroStrategy Desktop using the CData Software ODBC Driver for Toggl.
-
Connecting GenSpark with Bullhorn CRM Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Bullhorn CRM without any replication or custom integration required.
-
Publish Reports with eBay Analytics Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date eBay Analytics.
-
Explore Geographical Relationships in BenchmarkEmail Data with Power Map
Create data visualizations with BenchmarkEmail in Power Map.
-
Create Informatica Mappings From/To a JDBC Data Source for Paddle
Create Paddle data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Build Klaviyo-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Klaviyo Data from Zoho Analytics and import live Klaviyo.
-
Integrate Cursor with Live Workday Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Workday from within the editor.
-
Create a Data Access Object for Parquet Data using JDBI
A brief overview of creating a SQL Object API for Apache Parquet in JDBI.
-
How to Connect DBeaver to Typeform via a JDBC Driver
Manage Typeform with visual tools in DBeaver like the query browser.
-
Create Reports from ActiveCampaign Data in Looker Studio
Use CData Connect AI to gain access to live ActiveCampaign and create custom reports in Looker Studio.
-
Create Reports with Excel Online Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Microsoft Excel Online.
-
Connect to Live DocuSign Data in PostGresSQL Interface through CData Connect AI
Create a live connection to DocuSign in CData Connect AI and connect to your DocuSign from PostgreSQL.
-
Connect to Hubstaff Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Hubstaff using standard SQL.
-
Integrate Cursor with Live Klaviyo Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Klaviyo from within the editor.
-
Connect Strava to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Strava with IBM WebSphere for seamless data integration and connectivity.
-
Create Datasets from WordPress in Domo Workbench and Build Visualizations of WordPress Data in Domo
Use the CData Software ODBC Driver for WordPress to create datasets from WordPress in Domo Workbench and then build visualizations in the Domo service.
-
Query Dropbox Data from Node.js
Use the OData endpoint of the CData API Server to connect to your Dropbox and perform CRUD operations on Dropbox from Node.js.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Missive
Provide connectivity to Missive through an SAP BusinessObjects universe.
-
Automated Continuous ClickTime Replication to MySQL
Use CData Sync for automated, continuous, customizable ClickTime replication to MySQL.
-
Visualize VWO 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 VWO into TIBCO Spotfire.
-
How to connect to Discourse Data from Spring Boot
Connect to Discourse in a Spring Boot Application using the CData API Driver for JDBC
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed Sage Intacct to Power BI dashboards. Simply drag and drop Sage Intacct into data visuals on the Power BI canvas.
-
Automated Continuous WooCommerce Replication to SingleStore
Use CData Sync for automated, continuous, customizable WooCommerce replication to SingleStore.
-
Rapidly Develop MongoDB-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 MongoDB.
-
Excel Spreadsheet Automation on Gumroad Data with the QUERY Formula
Pull data from Gumroad, automate spreadsheets, and more with the QUERY formula.
-
Build Charts with Zoho Projects Data in Clear Analytics
Create dynamic charts and perform analytics based on Zoho Projects in Clear Analytics.
-
Perform Batch Operations with Marketo Data in Apache NiFi
Connect to Marketo and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Integrate Open WebUI with Live Procore Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Procore from within the chat interface.
-
Object-Relational Mapping (ORM) with MySQL 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 MySQL into a Java-based ORM framework, Hibernate.
-
Create Reports from Vertica Data in Looker Studio
Use CData Connect AI to gain access to live Vertica and create custom reports in Looker Studio.
-
Build DB2-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData MCP Server for DB2 to explore live DB2 Data in GitHub Copilot to assist with building DB2-powered applications.
-
Create Dynamic SAP SuccessFactors Grids Using the Infragistics XamDataGrid
Learn how you can connect SAP SuccessFactors to Infragistics XamDataGrid to build dynamic grids.
-
Connect to Intercom Data in HULFT Integrate
Connect to Intercom as a JDBC data source in HULFT Integrate
-
LINQ to Freshsales 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 Freshsales Data Provider.
-
Create a Data Access Object for Eventbrite Data using JDBI
A brief overview of creating a SQL Object API for Eventbrite in JDBI.
-
How to Connect to Live Procore Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Procore securely in real time.
-
Integrate with QuickBooks Online Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy QuickBooks Online to a JSON file on disk.
-
DataBind Gmail Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for Gmail with the DevExpress Windows Forms and Web controls to provide Gmail to a chart.
-
Explore Geographical Relationships in SharePoint Excel Services Data with Power Map
Create data visualizations with SharePoint Excel Services in Power Map.
-
Build AI/ML Models with Live DocuSign Data using Dataiku
Connect DocuSign Data with Dataiku using the CData JDBC Driver for DocuSign.
-
Use Grok to Talk to Your HBase Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Grok AI to securely answer questions and take actions on your Apache HBase for you.
-
Access OpenWeatherMap Data from MySQL in PHP
Connect to OpenWeatherMap through the standard MySQL libraries in PHP.
-
Connect to Google Directory Data in JRuby
Create a simple JRuby app with access to live Google Directory.
-
Automated Continuous Outreach.io Replication to SQL Server
Use CData Sync for automated, continuous, customizable Outreach.io replication to SQL Server.
-
A PostgreSQL Interface for RSS Feeds using the CData ODBC Driver
Use the SQL Gateway and RSS ODBC Driver to create a PostgreSQL entry-point for data access.
-
Automated Continuous Omnisend Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Omnisend replication to Google BigQuery.
-
Connect to Live Amazon Athena Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Amazon Athena in CData Connect AI and connect to your Amazon Athena from PostgreSQL.
-
Connect to Raisers Edge NXT Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Raisers Edge NXT Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Integrate Cursor with Live Jira Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Atlassian Jira from within the editor.
-
Connect to Teradata from a Connection Pool in WebLogic
Use the CData JDBC Driver for Teradata to connect to Teradata from Web applications running on WebLogic.
-
Provide OData Services of Dotmailer Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Dotmailer by developing a WCF Service Application.
-
Getting Started with the CData Power BI Connector for SFTP
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for SFTP.
-
Write a Simple Go Application to work with Pipedrive Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Pipedrive.
-
Connect to Bitbucket Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Bitbucket.
-
Publish Reports with MySQL Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date MySQL.
-
Build Visualizations of Coda Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Coda in Birst.
-
Getting Started with the CData Power BI Connector for MailChimp
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for MailChimp.
-
Create Dynamic Timely Grids Using the Infragistics XamDataGrid
Learn how you can connect Timely to Infragistics XamDataGrid to build dynamic grids.
-
Getting Started with the CData Power BI Connector for JobNimbus
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
DataBind Controls to SAP BusinessObjects BI Data in Delphi
DataBind to SAP BusinessObjects BI in Delphi with standard data access components and controls.
-
Build Dashboards with Keap Data in DBxtra
Create dynamic dashboards and perform analytics based on Keap in DBxtra.
-
Automated Continuous SharePoint Excel Services Replication to Snowflake
Use CData Sync for automated, continuous, customizable SharePoint Excel Services replication to Snowflake.
-
Integrating Kiro CLI with Pinecone 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.
-
Connect to LinkedIn Ads Data as an External Data Source using PolyBase
Use CData Connect AI and PolyBase to create an external data source in SQL Swerver with access to live LinkedIn Ads.
-
How to create Microsoft Dataverse federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Microsoft Dataverse (CDS) in MySQL .
-
Deploy the ADO.NET Provider for Foursquare on an SSRS Report Server
Connect to Foursquare 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.
-
ETL Azure DevOps in Oracle Data Integrator
This article shows how to transfer Azure DevOps into a data warehouse using Oracle Data Integrator.
-
Back Up Instantly 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 Instantly data.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed PostgreSQL to Power BI dashboards. Simply drag and drop PostgreSQL into data visuals on the Power BI canvas.
-
Connect BigCommerce to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live BigCommerce using the CData Python MCP Server.
-
Access HubSpot Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live HubSpot from HeidiSQL.
-
Automated Continuous HBase Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable HBase replication to delimited files (CSV/TSV).
-
How to Easily Query SAP Hybris C4C Data in OpenOffice Base
Connect to SAP Hybris C4C data in OpenOffice Base using the CData ODBC Driver for SAP Hybris C4C and generate reports with live data insights.
-
Visualize Supabase Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Supabase.
-
DataBind Drift Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Drift to a chart.
-
How to Connect to iContact Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to iContact. Leverage the pyodbc module for ODBC in Python.
-
Getting Started with the CData Connect AI Python SDK for CouchDB
Install the CData Connect AI Python SDK to read and write live Apache CouchDB with standard DB-API 2.0 Python code.
-
Write a Simple Go Application to work with Pinecone Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Pinecone.
-
Working with SQL Analysis Services Data in LINQPad
Execute LINQ queries to SQL Analysis Services in LINQPad.
-
Automated Continuous Phoenix Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Phoenix replication to Google Cloud SQL.
-
How to Work with Avalara AvaTax Data in AWS Glue Jobs Using JDBC
Connect to Avalara AvaTax from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Access Live Dynamics 365 Business Central Data in TIBCO Data Virtualization
Use the Dynamics 365 Business Central Tibco DV Adapter to create a Dynamics 365 Business Central data source in TIBCO Data Virtualization Studio and gain access to live Dynamics 365 Business Central from your TDV Server.
-
Access Live Marketo Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Marketo into the statistical analysis tools available in SAS JMP. This article shows how to use Marketo in the Graph Builder and Query Builder.
-
Object-Relational Mapping (ORM) with Oracle Financials Cloud 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 Oracle Financials Cloud into a Java-based ORM framework, Hibernate.
-
Integrating Claude Code CLI with Dropbox 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.
-
Query PhantomBuster Data as a MySQL Database in Node.js
Execute MySQL queries against PhantomBuster from Node.js.