CData Software - Knowledge Base
Recent Articles
-
WooCommerce Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on WooCommerce facts in real time.
-
How to Build an ETL App for Google Forms Data in Python with CData Connect AI
Extract and transform live Google Forms data in Python with petl and the CData Connect AI Python SDK.
-
Automated Continuous Google Search Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Google Search replication to AlloyDB.
-
Build Exact Online-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Exact Online Data and create custom apps in Mendix.
-
Connect Google Directory to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Google Directory with IBM WebSphere for seamless data integration and connectivity.
-
Integrating OpenCode with Zoho Books 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.
-
Design BIRT Reports on Box Data
Provide current Box data to your embedded analytics.
-
DataBind Controls to Harvest Data in Delphi
DataBind to Harvest data in Delphi with standard data access components and controls.
-
Connect to JotForm Data in DBeaver
Use the CData ODBC Driver to connect to JotForm data in DBeaver.
-
Connect to Live Twilio Data in MicroStrategy through CData Connect AI
Create a live connection to Twilio Data in CData Connect AI and connect to your Twilio data from MicroStrategy.
-
Build a PostgreSQL Interface for Access Data using the CData JDBC Driver
Use the Remoting features of the Access JDBC Driver to create a PostgreSQL entry-point for data access.
-
Rapidly Develop Email-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 Email.
-
Automate LinkedIn Ads Data Replication to SAP HANA
Use CData Sync to customize and automate LinkedIn Ads data replication to SAP HANA.
-
Query SAP Data in DataGrip
Create a Data Source for SAP in DataGrip and use SQL to query live SAP data.
-
Use Databricks Agent Bricks to Talk to Your MailChimp Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your MailChimp data for you.
-
Use Claude to Talk to Your Impala 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 Impala data for you.
-
Automated Continuous Perplexity Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Perplexity replication to PostgreSQL.
-
Analyze BambooHR Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for BambooHR from Power Pivot. You will use the Table Import Wizard to load BambooHR data. You can visually build the import query or use any SQL supported by the driver.
-
Integrating Claude Code with SAP SuccessFactors Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on SAP SuccessFactors data within assisted coding and automated development workflows.
-
Connect to Microsoft Teams in SpagoBI
Create reports featuring live Microsoft Teams data in SpagoBI Studio. Host Microsoft Teams reports on SpagoBI Server.
-
Connect to Azure DevOps Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Azure DevOps Data and connect to Azure DevOps data in Akorbi Digital RunMyProcess.
-
Model Databricks Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Databricks, enabling the direct import of real-time Databricks data.
-
Build Cvent-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Cvent data.
-
Connect Raisers Edge NXT Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Raisers Edge NXT data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
How to import HCL Domino Data into Apache Solr
Use the CData Software JDBC Driver for HCL Domino in Data Import Handler and create an automated import of HCL Domino data to Apache Solr Enterprise Search platform.
-
Build Automated Workflows with Live FTP Data in Workato
Use CData Connect AI to connect to live FTP data and build automated workflows in Workato.
-
Bridge Grafana Connectivity with Apache NiFi
Access and process Grafana data in Apache NiFi using the CData JDBC Driver.
-
Use Claude to Talk to Your API 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 API data for you.
-
Manage ZohoDesk Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for ZohoDesk.
-
Create Power BI Reports on Real-Time DocuSign Data
Use the CData ODBC Driver for DocuSign to visualize DocuSign data in Power BI Desktop.
-
Create a Data Access Object for Twilio Data using JDBI
A brief overview of creating a SQL Object API for Twilio data in JDBI.
-
Integrate with Live Stripe Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Stripe from the MuleSoft Anypoint Platform to integrate live Stripe data into custom reports and dashboards.
-
Build Semantic Layer Views for Rootly Data in APOS Live Data Gateway
Use the CData Connector for Rootly in APOS Live Data Gateway to build Semantic Layer Views for Rootly data.
-
Connect to SurveyMonkey in SpagoBI
Create reports featuring live SurveyMonkey data in SpagoBI Studio. Host SurveyMonkey reports on SpagoBI Server.
-
Import Vertica Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Vertica Data and provide access to live Vertica data for custom reports in the Power BI Service.
-
Create Dynamic ZohoExpense Grids Using the Infragistics XamDataGrid
Learn how you can connect ZohoExpense to Infragistics XamDataGrid to build dynamic grids.
-
Create Webflow Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Webflow data access from reports, embedded analytics, and more.
-
Connect to Parquet Data in RazorSQL
Connect to Parquet from wizards and query Parquet data from the GUI in the RazorSQL database management tool.
-
Build Agents in Relevance AI with Access to Live Zoho Books Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Zoho Books data within intelligent agent workflows.
-
Natively Connect to PagerDuty Data in PHP
The CData ODBC driver for PagerDuty enables you to create PHP applications with connectivity to PagerDuty data. Leverage the native support for ODBC in PHP.
-
Publish Crystal Reports on Zuora Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Zuora data.
-
Integrate Cline with Live Vault CRM Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Vault CRM data from within your IDE.
-
Build Anaplan-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Anaplan data.
-
Automated Continuous Neo4J Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Neo4J data replication to OneLake in Microsoft Fabric.
-
Connect to SAP Netweaver Gateway Data from AWS Glue
Use CData Connect AI to gain access to live SAP Netweaver Gateway data from your AWS Glue jobs.
-
Connect to FreshBooks Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with FreshBooks Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
How to Access Live Avalara AvaTax Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Avalara AvaTax enables you to integrate Avalara AvaTax data into workflows built using Microsoft Power Automate Desktop.
-
How to Connect to Live Adobe Target 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 Adobe Target data without replication.
-
How to connect Amazon QuickSight to Phoenix Data
Create a connection to Phoenix data in CData Connect AI and insert Phoenix data into Amazon QuickSight SPICE to build interactive dashboards.
-
Build Google Analytics-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Google Analytics Data and create custom apps in Mendix.
-
Use the CData Software ODBC Driver for Azure DevOps in MicroStrategy
Connect to Azure DevOps data in MicroStrategy Developer using the CData Software ODBC Driver for Azure DevOps.
-
Connect to DB2 Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for DB2 data in Airbyte.
-
Build AI/ML Models with Live Jira Data using Dataiku
Connect Jira Data with Dataiku using the CData JDBC Driver for Jira.
-
Build Dynamics NAV Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Dynamics NAV data and build visualizations in Tableau.
-
Connect to Adobe Target Data in Ruby
Connect to Adobe Target data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Use the CData Software ODBC Driver for ClickTime in MicroStrategy Web
Connect to ClickTime data in MicroStrategy Web using the CData Software ODBC Driver for ClickTime.
-
Build Reckon Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Reckon data and build visualizations in Tableau Cloud.
-
Stream Paymo Data into Apache Kafka Topics
Access and stream Paymo data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
How to Connect to Codat Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Codat data. Leverage the pyodbc module for ODBC in Python.
-
How to connect PolyBase to Aweber
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Aweber data.
-
Integrate Cursor with Live MongoDB Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live MongoDB data from within the editor.
-
Publish Zoho Books-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Zoho Books data.
-
Integrate Theia IDE with Live Google Forms Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE's built-in AI agents to securely access and query live Google Forms data from within the development environment.
-
Build Apps with Live ADP data in Adalo using CData Connect AI
Use CData Connect AI to integrate live ADP data into the Adalo platform and build custom mobile and web applications with real-time ADP data.
-
Automated Continuous Stack Exchange Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Stack Exchange replication to Azure SQL Database.
-
How to work with Sage Intacct Data in Apache Spark using SQL
Access and process Sage Intacct Data in Apache Spark using the CData Software JDBC Driver.
-
Integrate Live HCL Domino Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to HCL Domino data and integrate live HCL Domino data into apps built in Microsoft Power Apps.
-
Analyze RSS Feeds in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze RSS feeds in Microsoft R Open.
-
Integrate MarkLogic Data in Pentaho Data Integration
Build ETL pipelines based on MarkLogic data in the Pentaho Data Integration tool.
-
Use the CData Software JDBC Driver for Authorize.Net in MicroStrategy Desktop
Connect to Authorize.Net data in MicroStrategy Desktop using the CData Software JDBC Driver for Authorize.Net.
-
Bridge Snapchat Ads Connectivity with Apache NiFi
Access and process Snapchat Ads data in Apache NiFi using the CData JDBC Driver.
-
Create Data Visualizations in Cognos BI with Contentful Data
Access Contentful data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Connect to PDFMonkey Data from PowerBuilder via JDBC
This article demonstrates how to access PDFMonkey data from PowerBuilder using the PDFMonkey JDBC Driver.
-
How to Access Basecamp Data Using Entity Framework
This article shows how to access Basecamp data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
How to connect SharePoint with Amazon Athena Data through external lists
Provide Amazon Athena data to SharePoint users as an external list.
-
Integrate Google's Antigravity Agent with Live Typeform Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Typeform data using the Model Context Protocol.
-
Connect to SAP SuccessFactors LMS Data in JRuby
Create a simple JRuby app with access to live SAP SuccessFactors LMS data.
-
Automated Continuous Reckon Accounts Hosted Replication to MySQL
Use CData Sync for automated, continuous, customizable Reckon Accounts Hosted replication to MySQL.
-
Connect to Amplitude Data in RazorSQL
Connect to Amplitude from wizards and query Amplitude data from the GUI in the RazorSQL database management tool.
-
Connect to Zoho Recruit Data in Ruby
Connect to Zoho Recruit data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
How to Connect Azure Data Lake Storage Data to Gemini Enterprise via CData Connect AI
Connect CData Connect AI Remote MCP to Gemini Enterprise to securely read and take actions on live Azure Data Lake Storage data in real time using natural language.
-
Easily Integrate Mailjet Data in Lazarus Pascal IDE
Learn how to easily integrate live Mailjet data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Rapidly Develop Mode-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 Mode.
-
Connect Shippo Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Shippo data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Connect to ZohoDesk Data in CloverDX (formerly CloverETL)
Transfer ZohoDesk data using the visual workflow in the CloverDX data integration tool.
-
Provide OData Services of ConstantContact Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for ConstantContact data by developing a WCF Service Application.
-
Use the CData ODBC Driver for QuickBooks Online from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for QuickBooks Online to connect to QuickBooks Online data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring QuickBooks Online data in Excel.
-
Publish Sage Cloud Accounting-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Sage Cloud Accounting data.
-
Use CData Connect AI to Access Supabase Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Supabase data in the Power Pivot business intelligence tool.
-
Automated Continuous Stack Exchange Replication to SQL Server
Use CData Sync for automated, continuous, customizable Stack Exchange replication to SQL Server.
-
Automated Continuous Spotify Replication to MySQL
Use CData Sync for automated, continuous, customizable Spotify replication to MySQL.
-
Use JayDeBeApi to access Epicor Kinetic Data in Python
Use standard Python scripting and the development environment of your choice to access live Epicor Kinetic data.
-
Visualize Optimizely Data in TIBCO Spotfire through ADO.NET
Integrate Optimizely data into dashboards in TIBCO Spotfire.
-
Operational Reporting on SAP HANA XS Advanced Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote SAP HANA XS Advanced data.
-
Connecting Pipedream with Square 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 Square data in real time.
-
Integrate Google's Vertex AI Agent with Live Microsoft Ads Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Microsoft Ads data within intelligent workflows.
-
Validate ElevenLabs Data with QuerySurge
Access and validate ElevenLabs data in QuerySurge using the CData JDBC Driver.
-
Connect to CSV Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time CSV data using standard SQL.
-
Viewing SAP HANA XS Advanced Data in RAD Studio Data Explorer
How to view SAP HANA XS Advanced data in RAD Studio Data Explorer using the CData ODBC Driver for SAP HANA XS Advanced.
-
Connecting Pipedream with SQL Server 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 SQL Server data in real time.