CData Software - Knowledge Base
Recent Articles
-
Configure the CData JDBC Driver for GetResponse in a Connection Pool in Tomcat
Connect to GetResponse data from a connection pool in Tomcat.
-
Rapidly Develop ServiceDesk Plus-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 ServiceDesk Plus.
-
How to Connect to Facebook Ads Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Facebook Ads data. Leverage the pyodbc module for ODBC in Python.
-
Visualize Microsoft Dataverse 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 Microsoft Dataverse data into TIBCO Spotfire.
-
Connecting GenSpark with ZohoSubscriptions Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to ZohoSubscriptions data without any replication or custom integration required.
-
Build Cosmos DB-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Cosmos DB data and build Cosmos DB-connected web apps with Axios.
-
Automated Continuous Pushbullet Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Pushbullet replication to Amazon Redshift.
-
Build an OLAP Cube in SSAS from HubSpot Data
Establish a connection to HubSpot data data from SQL Server Analysis Services, and use the HubSpot Data Provider to build OLAP cubes for use in analytics and reporting.
-
Import Real-Time Facebook Ads Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Facebook Ads data in ColdFusion.
-
DataBind ClickTime Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide ClickTime data to a chart.
-
Integrating Claude Code CLI with Wrike 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 Moosend Data in the Power BI Service
Use CData Connect AI to connect to live Moosend data and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Analyze Epicor Kinetic Data in Cognos Analytics
Use CData Connect AI to connect to Epicor Kinetic Data from Cognos Analytics and analyze live Epicor Kinetic data.
-
How to Work with Twilio Data in AWS Glue Jobs Using JDBC
Connect to Twilio from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Publish Factorial-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Factorial data.
-
Connect to Live Optimizely Data in MicroStrategy through CData Connect AI
Create a live connection to Optimizely Data in CData Connect AI and connect to your Optimizely data from MicroStrategy.
-
Build Workable-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Workable data and build web apps with connectivity to live Workable data.
-
Integrate Cursor with Live ZohoMarketingHub Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live ZohoMarketingHub data from within the editor.
-
Analyze ChargeOver Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for ChargeOver from Power Pivot. You will use the Table Import Wizard to load ChargeOver data. You can visually build the import query or use any SQL supported by the driver.
-
Create SSAS Tabular Models from OpenWeatherMap Data
How to build a SQL Server Analysis Service Tabular Model from OpenWeatherMap data using CData drivers.
-
DataBind eBay Analytics Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for eBay Analytics with the DevExpress Windows Forms and Web controls to provide eBay Analytics data to a chart.
-
Access Live Dynamics CRM Data in TIBCO Data Virtualization
Use the Dynamics CRM Tibco DV Adapter to create a Dynamics CRM data data source in TIBCO Data Virtualization Studio and gain access to live Dynamics CRM data from your TDV Server.
-
Connect to OData Services in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for OData services in Airbyte.
-
Creating HubDB-Connected Applications in Unqork
You can use CData Connect AI to feed HubDB data to Unqork and build custom business apps.
-
Connect to ClickUp Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with ClickUp Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
How to Connect DBeaver to Productboard via a JDBC Driver
Manage Productboard data with visual tools in DBeaver like the query browser.
-
Connect to Adobe Analytics Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to Adobe Analytics.
-
How to connect SharePoint with Xero Data through external lists
Provide Xero data to SharePoint users as an external list.
-
Build Pipelines with Live Office 365 Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Office 365 from Google Cloud Data Fusion, enabling the integration of live Office 365 data into the building and management of effective data pipelines.
-
Viewing BenchmarkEmail Data in RAD Studio Data Explorer
How to view BenchmarkEmail data in RAD Studio Data Explorer using the CData ODBC Driver for BenchmarkEmail.
-
How to publish and share Zoho Inventory Data dashboards with Tableau Server
The CData ODBC driver for Zoho Inventory enables you integrate Zoho Inventory data into Tableau dashboards.
-
How to connect to SendGrid Data in DBVisualizer
Integrate SendGrid data with visual data analysis tools and data connection wizards in DBVisualizer
-
Connect to Scrapfly Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Scrapfly data using standard SQL.
-
Connect to Freshdesk Data from PowerBuilder via ADO.NET
This article demonstrates how to access Freshdesk data from Appeon PowerBuilder using the CData ADO.NET Provider for Freshdesk.
-
Visualize Live Clari Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Clari data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Connect to GitHub Data in CloverDX (formerly CloverETL)
Transfer GitHub data using the visual workflow in the CloverDX data integration tool.
-
Automated Continuous FormSite Replication to Oracle
Use CData Sync for automated, continuous, customizable FormSite replication to Oracle.
-
Create Informatica Mappings From/To an ODBC Data Source for OData
Create an ODBC connection to OData in Informatica and browse and transfer OData services.
-
Getting Started with the CData Power BI Connector for Google Directory
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Google Directory.
-
Automated Continuous Xero Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Xero replication to delimited files (CSV/TSV).
-
Access Testmonitor 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 Testmonitor data.
-
Connect to Bullhorn CRM Data from a Connection Pool in Jetty
The Bullhorn CRM JDBC Driver supports connection pooling: This article shows how to connect faster to Bullhorn CRM data from Web apps in Jetty.
-
Migrating data from Mixpanel to Google BigQuery using CData SSIS Components.
Easily push Mixpanel data to Google BigQuery using the CData SSIS Tasks for Mixpanel and Google BigQuery.
-
Connect ActiveCampaign Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your ActiveCampaign data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Connect to Klipfolio from Asprova with CData Software ODBC Driver for Klipfolio
This article shows how to connect faster to Klipfolio data from Asprova.
-
How to Connect to Live Oracle Service Cloud 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 Oracle Service Cloud data for you.
-
Write a Simple Go Application to work with Todoist Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Todoist data.
-
Build MongoDB-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for MongoDB Data and create custom apps in Mendix.
-
Marketo Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Marketo data through CData Connect AI using different applications and tools.
-
How to Query Amplitude Data in MySQL Workbench
Execute MySQL queries against live Amplitude data from MySQL Workbench.
-
How to Connect to & Open Dynamics CRM Data in Microsoft Excel
This article uses the CData ODBC driver for Dynamics CRM to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Integrate Live Lakebase 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 Lakebase data from within the IDE.
-
Build Visualizations of Suadeo Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Suadeo data in Birst.
-
How to connect to ZohoExpense Data from Spring Boot
Connect to ZohoExpense in a Spring Boot Application using the CData API Driver for JDBC
-
Operational Reporting on Harvest Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Harvest data.
-
Connect to Pipeline CRM from a Connection Pool in WebLogic
Use the CData JDBC Driver for Pipeline CRM to connect to Pipeline CRM data from Web applications running on WebLogic.
-
Use ChatGPT to Talk to Your Google Analytics 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 Google Analytics data for you.
-
Use the CData Software ODBC Driver for Wrike in SAS for Real-Time Reporting and Analytics
Connect to real-time Wrike data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Wrike.
-
Connecting Agentforce with eBay Analytics 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 eBay Analytics data for you.
-
Design BIRT Reports on Azure Synapse Data
Provide current Azure Synapse data to your embedded analytics.
-
Back Up Accelo 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 Accelo data data.
-
Integrate with Live Adobe Target Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Adobe Target from the MuleSoft Anypoint Platform to integrate live Adobe Target data into custom reports and dashboards.
-
How to Connect to Live Snowflake 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 Snowflake data without replication.
-
How to Connect to Live Google Ad Manager 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 Google Ad Manager data for you.
-
Connect to Okta Data from a Connection Pool in JBoss
Integrate Okta data into Java servlets: Use the Management Console in JBoss to install the Okta JDBC Driver.
-
Operational Reporting on Zoho Inventory Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Zoho Inventory data.
-
Choosing the Best Method to Connect Bright Data to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Bright Data data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Access SharePoint Excel Services Data from MySQL in PHP
Connect to SharePoint Excel Services through the standard MySQL libraries in PHP.
-
Publish Clio-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Clio data.
-
Access Live Epicor Kinetic 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 Epicor Kinetic data through MCP integration.
-
Access Live Tally Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Tally data from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Getting Started with the CData ODBC Driver for Supabase
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Supabase.
-
Automate Zoho Inventory Data Replication to Couchbase
Use CData Sync to Customize and automate Zoho Inventory data replication to Couchbase.
-
Operational Reporting on Tavily Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Tavily data.
-
Getting Started with the CData ADO.NET Provider for CampaignMonitor
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Connect to ServiceDesk Plus Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for ServiceDesk Plus and the SQL Gateway to access ServiceDesk Plus data from Google Apps Script.
-
Build AI/ML Models with Live Zoho CRM Data using Dataiku
Connect Zoho CRM Data with Dataiku using the CData JDBC Driver for Zoho CRM.
-
Object-Relational Mapping (ORM) with Figshare 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 Figshare data into a Java-based ORM framework, Hibernate.
-
Connect to SQL Server Data from PowerBuilder via JDBC
This article demonstrates how to access SQL Server data from PowerBuilder using the SQL Server JDBC Driver.
-
Natively Connect to EmailOctopus Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to EmailOctopus data. Leverage the native support for ODBC in PHP.
-
Replicate Odoo Data in Heroku for Use in Salesforce Connect
Replicate Odoo data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Use the CData ODBC Driver for PayPal from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for PayPal to connect to PayPal data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring PayPal data in Excel.
-
Automated Continuous Google Calendar Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Google Calendar replication to Google Cloud SQL.
-
View Reports on Real-Time Landbot Data in Power BI Report Server
Use the CData ODBC Driver for Landbot to visualize Landbot data in Power BI Desktop and then publish them to Power BI Report Server.
-
Replicate SageHR Data to Multiple Databases
Replicate SageHR data to disparate databases with a point-and-click configuration.
-
Build Klaviyo Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Klaviyo data and build visualizations in Tableau Cloud.
-
Automated Continuous Shippo Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Shippo replication to AlloyDB.
-
Add Oracle Eloqua Reporting Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Oracle Eloqua Reporting with the Informatica Enterprise Data Catalog to classify and organize data.
-
How to publish and share Notion Data dashboards with Tableau Server
The CData ODBC driver for Notion enables you integrate Notion data into Tableau dashboards.
-
Create Marketo-Connected Business Apps in AppSheet
Connect to Marketo Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Marketo data.
-
How to Connect to Live Attio 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 Attio data for you.
-
Query EmailOctopus Data as a MySQL Database in Node.js
Execute MySQL queries against EmailOctopus data from Node.js.
-
Use the CData ODBC Driver for Customer.io in Microsoft Power Query
You can use the CData Customer.io ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Customer.io data into Microsoft Power Query.
-
Connect to CapsuleCRM Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for CapsuleCRM and the SQL Gateway to access CapsuleCRM data from Google Apps Script.
-
Working with AgileCRM Data in LINQPad
Execute LINQ queries to AgileCRM data in LINQPad.
-
Build AI Agents with Salesforce 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 Salesforce data through CData Connect AI.
-
Connect to Stripe Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Stripe data.
-
How to Seamlessly Import Harvest Data into IBM SPSS Modeler
Integrate Harvest data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Choosing the Best Method to Connect Gorgias to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Gorgias data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Create a Data Access Object for Discourse Data using JDBI
A brief overview of creating a SQL Object API for Discourse data in JDBI.