CData Software - Knowledge Base
Recent Articles
-
Design BIRT Reports on MySQL Data
Provide current MySQL to your embedded analytics.
-
How to connect to ZeroBounce Data from IntelliJ
Integrate connectivity to ZeroBounce with wizards in IntelliJ.
-
How to integrate Metabase with MailChimp Data
Use CData Connect AI to connect to live MailChimp and create an interactive dashboard in Metabase from MailChimp.
-
Integrate Mode Data in the Pentaho Report Designer
Publish reports based on Mode in the Pentaho BI tool.
-
ETL HBase in Oracle Data Integrator
This article shows how to transfer Apache HBase into a data warehouse using Oracle Data Integrator.
-
Bridge ClickUp Connectivity with Apache NiFi
Access and process ClickUp in Apache NiFi using the CData JDBC Driver.
-
How to Work with PivotalTracker Data in ETL Validator JDBC
Connect to PivotalTracker from ETL Validator jobs using the CData Software JDBC Driver.
-
Create Power BI Reports on Real-Time ZarMoney Data
Use the CData ODBC Driver for ZarMoney to visualize ZarMoney in Power BI Desktop.
-
How to Connect to Live SAS Data Sets 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 SAS Data Sets for you.
-
How to Work with Gorgias Data in ETL Validator JDBC
Connect to Gorgias from ETL Validator jobs using the CData Software JDBC Driver.
-
Connect to and Query YouTube Analytics Data in QlikView over ODBC
Create data visualizations with YouTube Analytics in QlikView.
-
Connect to ZohoDesk Data in RazorSQL
Connect to ZohoDesk from wizards and query ZohoDesk from the GUI in the RazorSQL database management tool.
-
Connect to Email Data from a Connection Pool in Jetty
The Email JDBC Driver supports connection pooling: This article shows how to connect faster to Email from Web apps in Jetty.
-
DataBind Charts to Zoho CRM Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Zoho CRM from controls in the Visual Studio toolbox. This article demonstrates a graphical approach using wizards in Visual Studio, as well as how to databind with only a few lines of code.
-
Replicate Multiple Teradata Accounts
Replicate multiple Teradata accounts to one or many databases.
-
Explore Geographical Relationships in Simplesat Data with Power Map
Create data visualizations with Simplesat in Power Map.
-
Working with Adobe Analytics Data in LINQPad
Execute LINQ queries to Adobe Analytics in LINQPad.
-
Connect to EnterpriseDB Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for EnterpriseDB Data and connect to EnterpriseDB in Akorbi Digital RunMyProcess.
-
Connect Zoho Creator to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Zoho Creator with IBM WebSphere for seamless data integration and connectivity.
-
How to Create Power BI Visual Reports with Real-Time Cohere Data
Use CData Power BI Connectors to visualize Cohere in Power BI.
-
How to connect to Azure Table Data from Spring Boot
Connect to Azure Table in a Spring Boot Application using the CData JDBC Driver for Azure Table
-
Load Tally Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Tally ERP to a database.
-
Visualize Google Analytics Data in Tableau
The CData ODBC driver for Google Analytics enables you integrate Google Analytics into Tableau dashboards.
-
Connect to ZohoPeople Data from a Connection Pool in JBoss
Integrate ZohoPeople into Java servlets: Use the Management Console in JBoss to install the ZohoPeople JDBC Driver.
-
Use Dash to Build Web Apps on Salesforce Marketing Data via CData Connect AI
Build interactive Dash web apps on live Salesforce Marketing Cloud using pandas and the CData Connect AI Python SDK.
-
Visualize Live Salesloft Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Salesloft using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed Microsoft Dynamics 365 to Power BI dashboards. Simply drag and drop Microsoft Dynamics 365 into data visuals on the Power BI canvas.
-
Access Live Sage 200 Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Sage 200 from your Excel spreadsheets.
-
Connect to ChargeOver Data in HULFT Integrate
Connect to ChargeOver as a JDBC data source in HULFT Integrate
-
View Reports on Real-Time CampaignMonitor Data in Power BI Report Server
Use the CData ODBC Driver for CampaignMonitor to visualize CampaignMonitor in Power BI Desktop and then publish them to Power BI Report Server.
-
Import Real-Time Basecamp Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Basecamp in ColdFusion.
-
Automated Continuous QuickBooks Time Replication to SingleStore
Use CData Sync for automated, continuous, customizable QuickBooks Time replication to SingleStore.
-
Automated Continuous SpaceX Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable SpaceX replication to Apache Kafka.
-
Build Salesforce Marketing-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Salesforce Marketing Cloud.
-
Query Live QuickBooks Time Data in Zed Editor via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Zed Editor to securely access and query live QuickBooks Time directly from the development environment.
-
Automated Continuous AgileCRM Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable AgileCRM replication to delimited files (CSV/TSV).
-
Build Charts with Miro Data in Clear Analytics
Create dynamic charts and perform analytics based on Miro in Clear Analytics.
-
Connect Zoho Inventory to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Zoho Inventory using the CData Python MCP Server.
-
Access REST Data from MySQL in Amazon QuickSight
Connect to REST and build visualizations of REST using a MySQL Connection in Amazon QuickSight.
-
Connect to SparkPost Data in Ruby
Connect to SparkPost in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Connect SAP ByDesign to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live SAP Business ByDesign using the CData Python MCP Server.
-
How to Connect to Live Cvent Data from Claude Agent SDK (via CData Connect AI)
Leverage CData Connect AI to enable Claude Agent SDK applications to securely read and take actions on your Cvent for you.
-
Consume SAP HANA XS Advanced OData Feeds in SAP Lumira
Use the API Server to create data visualizations on SAP HANA XS Advanced feeds that reflect any changes in SAP Lumira.
-
Access Live Salesforce CRM Analytics Data in Roo Code via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Roo Code agents to securely access and build applications with live Salesforce CRM Analytics through MCP integration.
-
Build Avro-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Apache Avro and build web apps with connectivity to live Apache Avro.
-
Getting Started with the CData ODBC Driver for Avaza
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Avaza.
-
Work with Live Sage 200 Data in Power Query
Use CData Connect AI to connect to Sage 200 and work with live Sage 200 in Microsoft Power Query.
-
DataBind Controls to Salesforce Marketing Data in C++Builder
DataBind to Salesforce Marketing Cloud in C++Builder with standard components and controls.
-
Integrate Cursor with Live Kintone Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Kintone from within the editor.
-
Create Informatica Mappings From/To a JDBC Data Source for Superchat
Create Superchat data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Integrating Bitly Data in Talend Cloud Data Management Platform
Connect Bitly Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Creating Confluence-Connected Applications in Unqork
You can use CData Connect AI to feed Atlassian Confluence to Unqork and build custom business apps.
-
How to Connect to CapsuleCRM Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to CapsuleCRM. Leverage the pyodbc module for ODBC in Python.
-
Use the CData Software ODBC Driver for Hive in SAS for Real-Time Reporting and Analytics
Connect to real-time Apache Hive in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Hive.
-
How to connect to Google Directory Data from Spring Boot
Connect to Google Directory in a Spring Boot Application using the CData JDBC Driver for Google Directory
-
Easily Integrate Dropbox Data in Lazarus Pascal IDE
Learn how to easily integrate live Dropbox in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Automated Continuous Reckon Accounts Hosted Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Reckon Accounts Hosted replication to IBM DB2.
-
Use the CData ODBC Driver for Nethunt in Microsoft Power Query
You can use the CData Nethunt ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Nethunt into Microsoft Power Query.
-
Integrating Kiro CLI with Parallel 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.
-
How to connect to PostgreSQL Data in DBVisualizer
Integrate PostgreSQL with visual data analysis tools and data connection wizards in DBVisualizer
-
Connect to SendGrid Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for SendGrid in Airbyte.
-
Work with Qualaroo Data in FoxPro
Load Qualaroo into a FoxPro database. This article includes full code and a walk-through of the process.
-
Connect to Zoho Inventory Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Zoho Inventory using standard SQL.
-
Connect to and Visualize Live Microsoft Entra ID Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Microsoft Entra ID.
-
How to integrate Metabase with Stripe Data
Use CData Connect AI to connect to live Stripe and create an interactive dashboard in Metabase from Stripe.
-
Integrate Cursor with Live Adobe Analytics Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Adobe Analytics from within the editor.
-
Use ChatGPT to Talk to Your HCL Domino 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 HCL Domino for you.
-
Build Dashboards with SAS Data Sets Data in Dundas BI
Create dynamic dashboards and perform analytics based on SAS Data Sets in Dundas BI.
-
Build an OLAP Cube in SSAS from Zoho Creator Data
Establish a connection to Zoho Creator data from SQL Server Analysis Services, and use the Zoho Creator Data Provider to build OLAP cubes for use in analytics and reporting.
-
Write a Simple Go Application to work with PhantomBuster Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to PhantomBuster.
-
Access Klipfolio Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Klipfolio from HeidiSQL.
-
Build FreshBooks-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live FreshBooks.
-
Provide OData Services of ZohoSubscriptions Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for ZohoSubscriptions by developing a WCF Service Application.
-
How to connect to Keap Data from IntelliJ
Integrate connectivity to Keap with wizards in IntelliJ.
-
Connect to SAP ByDesign Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for SAP Business ByDesign.
-
How to work with Dropbox Data in Apache Spark using SQL
Access and process Dropbox Data in Apache Spark using the CData Software JDBC Driver.
-
Access Live Power BI XMLA Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live Power BI XMLA data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Automated Continuous Instagram Replication to SQL Server
Use CData Sync for automated, continuous, customizable Instagram replication to SQL Server.
-
Visualize Stack Exchange Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Stack Exchange.
-
How to create Visio diagrams from Outreach.io Data
Automatically update Outreach.io with the changes you make to Visio master shapes.
-
Connect to Square Data from PowerBuilder via ADO.NET
This article demonstrates how to access Square from Appeon PowerBuilder using the CData ADO.NET Provider for Square.
-
Integrate with DocuSign Data in JReport Designer
Create charts and reports based on DocuSign in JReport Designer.
-
Connect to Float Data in DBeaver
Use the CData ODBC Driver to connect to Float in DBeaver.
-
Connect to Mailjet from Asprova with CData Software ODBC Driver for Mailjet
This article shows how to connect faster to Mailjet data from Asprova.
-
Access Live PayPal Data in Excel 365 Online (Excel for the web)
Connect to PayPal from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Connect to ActiveCampaign Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for ActiveCampaign and the Script function in FileMaker Pro to connect to ActiveCampaign and work with ActiveCampaign in your FileMaker application.
-
Connect to Demio Data from PowerBuilder via ADO.NET
This article demonstrates how to access Demio from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Automated Continuous LaunchDarkly Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable LaunchDarkly replication to Azure SQL Database.
-
Access Browserless 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 Browserless.
-
Automated Continuous Klipfolio Replication to MySQL
Use CData Sync for automated, continuous, customizable Klipfolio replication to MySQL.
-
Use the CData Software JDBC Driver for Paddle in MicroStrategy Desktop
Connect to Paddle in MicroStrategy Desktop using the CData Software JDBC Driver for Paddle.
-
Bridge Sage Intacct Connectivity with Apache NiFi
Access and process Sage Intacct in Apache NiFi using the CData JDBC Driver.
-
Build AI/ML Models with Live Marketo Data using Dataiku
Connect Marketo Data with Dataiku using the CData JDBC Driver for Marketo.
-
Publish Crystal Reports on Sage Cloud Accounting Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Sage Business Cloud Accounting.
-
Build Oracle SCM Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Oracle SCM and build visualizations in Tableau.
-
Integrate BambooHR Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live BambooHR from Informatica Cloud.
-
Build Zoho CRM-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Zoho CRM.
-
View Reports on Real-Time Perigon Data in Power BI Report Server
Use the CData ODBC Driver for Perigon to visualize Perigon in Power BI Desktop and then publish them to Power BI Report Server.
-
Automated Continuous Calendly Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Calendly replication to Amazon Redshift.
-
Migrating data from Sage 200 to Google BigQuery using CData SSIS Components.
Easily push Sage 200 to Google BigQuery using the CData SSIS Tasks for Sage 200 and Google BigQuery.