CData Software - Knowledge Base
Recent Articles
-
Automated Continuous Cloudflare Replication to SQL Server
Use CData Sync for automated, continuous, customizable Cloudflare replication to SQL Server.
-
Use Biml to Build SSIS Tasks to Replicate SAP Fieldglass Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate SAP Fieldglass to SQL Server.
-
Automated Continuous SAP HANA Replication to Vertica
Use CData Sync for automated, continuous, customizable SAP HANA replication to Vertica.
-
Write a Simple Go Application to work with Xero Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Xero Accounting.
-
Object-Relational Mapping (ORM) with Apify 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 Apify into a Java-based ORM framework, Hibernate.
-
Build Zoho Books-Powered Applications in Claude Code with CData MCP Server
Use the CData MCP Server for Zoho Books to explore live Zoho Books Data in Claude Code to assist with building Zoho Books-powered applications.
-
Drift Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Drift facts in real time.
-
Edit and Search Blackbaud FE NXT External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of Blackbaud FE NXT to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create Blackbaud FE NXT objects that you can access from apps and the dashboard.
-
How to publish and share Microsoft Exchange Data dashboards with Tableau Server
The CData ODBC driver for Microsoft Exchange enables you integrate Microsoft Exchange into Tableau dashboards.
-
Connect to and Query SAP HANA XS Advanced Data in QlikView over ODBC
Create data visualizations with SAP HANA XS Advanced in QlikView.
-
Use the CData Software JDBC Driver for Nuclia in MicroStrategy Web
Connect to Nuclia in MicroStrategy Web using the CData Software JDBC Driver for Nuclia.
-
Use the CData Software ODBC Driver for MariaDB in MicroStrategy
Connect to MariaDB in MicroStrategy Developer using the CData Software ODBC Driver for MariaDB.
-
Analyze Avalara AvaTax Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Avalara AvaTax and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
LINQ to Copper 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 Copper Data Provider.
-
Model, Search, and Visualize Live Authorize.Net Data in ThoughtSpot
Use CData Connect AI to connect to live Authorize.Net for modeling, searching, and visualizing.
-
How to connect and process Contentful from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Contentful.
-
Publish Crystal Reports on Templated Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Templated.
-
Access Zoho Recruit Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Zoho Recruit from your Oracle system.
-
Process & Analyze HCL Domino Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live HCL Domino Data.
-
Visualize Live Google Calendar Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Google Calendar into custom reports in Power BI.
-
Getting Started with the CData SSIS Components for ServiceDesk Plus
Complete guide to installing, licensing, and connecting with the CData SSIS Components for ServiceDesk Plus.
-
How to Query Live Impala Data in Claude Desktop
Connect to and query live Impala Data in Claude Desktop using CData MCP Server.
-
Validate FreshBooks Data with QuerySurge
Access and validate FreshBooks in QuerySurge using the CData JDBC Driver.
-
Process & Analyze RSS Feeds in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live RSS Feeds.
-
Use JayDeBeApi to access SAP SuccessFactors Data in Python
Use standard Python scripting and the development environment of your choice to access live SAP SuccessFactors.
-
How to connect and process Apify from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Apify.
-
Getting Started with the CData ODBC Driver for Shopify
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Shopify.
-
How to Connect Flowise AI Agents to Live Jira Assets Data via CData Connect AI
Integrate Flowise AI with the CData Connect AI MCP Server to enable agents to securely query and act on live Jira Assets without replication.
-
Connect to SAP Netweaver Gateway Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time SAP Netweaver Gateway using standard SQL.
-
Access Live Amazon Athena Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Amazon Athena into the statistical analysis tools available in SAS JMP. This article shows how to use Amazon Athena in the Graph Builder and Query Builder.
-
Prepare, Blend, and Analyze Act CRM Data in Alteryx Designer (Connect AI)
Build workflows to access live Act CRM for self-service data analytics.
-
Connect to Dynamics 365 Business Central Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Dynamics 365 Business Central and the SQL Gateway to access Dynamics 365 Business Central from Google Apps Script.
-
Build MVC Applications with Connectivity to Oracle Eloqua Reporting Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Oracle Eloqua Reporting from an ASP.NET MVC application.
-
How to Connect to Live Office 365 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 Microsoft Office 365 for you.
-
Automate SAP Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live SAP ERP/NetWeaver and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
Operational Reporting on Notion Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Notion.
-
DataBind Charts to CockroachDB Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to CockroachDB 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.
-
How to Connect DBeaver to Insightly via a JDBC Driver
Manage Insightly with visual tools in DBeaver like the query browser.
-
Operational Reporting on Copper Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Copper.
-
Connect to Google Calendar Data in HULFT Integrate
Connect to Google Calendar as a JDBC data source in HULFT Integrate
-
Use Databricks Agent Bricks to Talk to Your GitLab Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your GitLab for you.
-
Build Vault CRM-Powered Applications in Gemini Code Assist with CData MCP Server
Use the CData MCP Server for Vault CRM to explore live Vault CRM Data in Gemini Code Assist to assist with building Vault CRM-powered applications.
-
Query Google Analytics Data as a MySQL Database in Node.js
Execute MySQL queries against Google Analytics from Node.js.
-
Visualize Zoho CRM 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 Zoho CRM into TIBCO Spotfire.
-
Access Live ServiceNow Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live ServiceNow from your Excel spreadsheets.
-
Integrate Attio Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Attio from Informatica Cloud.
-
How to connect to Paymo Data from IntelliJ
Integrate connectivity to Paymo with wizards in IntelliJ.
-
Build a PostgreSQL Interface for Autopilot Data using the CData JDBC Driver
Use the Remoting features of the Autopilot JDBC Driver to create a PostgreSQL entry-point for data access.
-
Migrating data from Strava to Databricks using CData SSIS Components.
Easily push Strava to Databricks using the CData SSIS Tasks for Strava and Databricks.
-
Integrate Adobe Experience Manager Data in the Pentaho Report Designer
Publish reports based on Adobe Experience Manager in the Pentaho BI tool.
-
Excel Spreadsheet Automation on Facebook Ads Data with the QUERY Formula
Pull data from Facebook Ads, automate spreadsheets, and more with the QUERY formula.
-
Connect to Short.io Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Short.io and work with Short.io in your FileMaker applications.
-
How to import SingleStore Data into Apache Solr
Use the CData Software JDBC Driver for SingleStore in Data Import Handler and create an automated import of SingleStore to Apache Solr Enterprise Search platform.
-
Connect to Office 365 Data in DBeaver
Use the CData ODBC Driver to connect to Microsoft Office 365 in DBeaver.
-
Build Google Spanner-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Google Spanner Data from Zoho Analytics and import live Google Spanner.
-
How to Connect to Live Snowflake Data from OpenAI Python Applications (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable OpenAI-powered Python applications to securely read and take actions on your Snowflake through natural language.
-
ETL XML in Oracle Data Integrator
This article shows how to transfer XML Files into a data warehouse using Oracle Data Integrator.
-
Create Dynamic Cosmos DB Grids Using the Infragistics XamDataGrid
Learn how you can connect Cosmos DB to Infragistics XamDataGrid to build dynamic grids.
-
Create SAP SuccessFactors LMS-Connected Dashboards in Grafana
Connect to SAP SuccessFactors LMS Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to SAP SuccessFactors LMS.
-
Build Semantic Layer Views for Sage Intacct Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Sage Intacct.
-
Automated Continuous RSS Replication to MySQL
Use CData Sync for automated, continuous, customizable RSS replication to MySQL.
-
Use the CData Software ODBC Driver for Egnyte in MicroStrategy Desktop
Connect to Egnyte in MicroStrategy Desktop using the CData Software ODBC Driver for Egnyte.
-
Integrating Cursor CLI with Instantly 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.
-
Analyze Hive Data in Looker
Use CData Connect AI to connect to Hive Data from Looker and build custom apps using live Apache Hive.
-
Analyze Quaderno Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Quaderno from Power Pivot. You will use the Table Import Wizard to load Quaderno. You can visually build the import query or use any SQL supported by the driver.
-
Create ConvertKit Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time ConvertKit data access from reports, embedded analytics, and more.
-
How to load Billsby data into Elasticsearch via Logstash
Introducing a simple method to load Billsby data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
How to Connect DBeaver to Freshservice via a JDBC Driver
Manage Freshservice with visual tools in DBeaver like the query browser.
-
Stream Apify Data into Apache Kafka Topics
Access and stream Apify in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Connect to ChartMogul from Asprova with CData Software ODBC Driver for ChartMogul
This article shows how to connect faster to ChartMogul data from Asprova.
-
Use the CData Software JDBC Driver for SAP Business One in MicroStrategy Web
Connect to SAP Business One in MicroStrategy Web using the CData Software JDBC Driver for SAP Business One.
-
Automated Continuous Calendly Replication to Snowflake
Use CData Sync for automated, continuous, customizable Calendly replication to Snowflake.
-
Query Dynamics NAV Data in DataGrip
Create a Data Source for Dynamics NAV in DataGrip and use SQL to query live Microsoft Dynamics NAV.
-
Analyze CapsuleCRM Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze CapsuleCRM with the CData JDBC Driver for CapsuleCRM.
-
Connect to Real-Time PabblySubscriptions Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use PabblySubscriptions in Power Apps.
-
Automated Continuous PabblySubscriptions Replication to Oracle
Use CData Sync for automated, continuous, customizable PabblySubscriptions replication to Oracle.
-
Create Apps from Twitter Ads Data in Qlik Sense Cloud
Use CData Connect AI to connect to Twitter Ads Data and build apps from live Twitter Ads in Qlik Sense Cloud.
-
Build IBM Informix-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to IBM Informix Data from Zoho Analytics and import live IBM Informix.
-
DataBind Controls to LightSpeedRetail Data in C++Builder
DataBind to LightSpeedRetail in C++Builder with standard components and controls.
-
Connect to IBM Cloud Object Storage Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Connecting GenSpark with Avro Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Apache Avro without any replication or custom integration required.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live MongoDB using the Model Context Protocol.
-
View Reports on Real-Time Salesforce Data in Power BI Report Server
Use the CData ODBC Driver for Salesforce to visualize Salesforce & Force.com in Power BI Desktop and then publish them to Power BI Report Server.
-
Create Dynamic Google Cloud Storage Grids Using the Infragistics XamDataGrid
Learn how you can connect Google Cloud Storage to Infragistics XamDataGrid to build dynamic grids.
-
DataBind ServiceNow Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for ServiceNow with the DevExpress Windows Forms and Web controls to provide ServiceNow to a chart.
-
Create Reports with Act-On Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Act-On.
-
CData SAP Driver Deep Dive: Access SAP S/4HANA CDS Views as OData Services
A simple guide for exposing SAP S/4HANA CDS Views to access them as OData Services using the CData SAP Driver.
-
How to Connect to SAP BusinessObjects BI Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to SAP BusinessObjects BI. Leverage the pyodbc module for ODBC in Python.
-
Automated Continuous Microsoft Ads Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Microsoft Ads replication to Azure SQL Database.
-
Build Monday.com-Powered Applications in Gemini Code Assist with CData MCP Server
Use the CData MCP Server for Monday.com to explore live Monday.com Data in Gemini Code Assist to assist with building Monday.com-powered applications.
-
Connect to Real-Time Salesforce Pardot Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Salesforce Pardot and Dataflow to import and use Salesforce Pardot in Power Apps.
-
Connect to DocuSign Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for DocuSign and the Script function in FileMaker Pro to connect to DocuSign and work with DocuSign in your FileMaker application.
-
Automate HCL Domino Data Replication to Azure Synapse
Use CData Sync to customize and automate HCL Domino replication to Azure Synapse.
-
Connect and Query Live Square Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Square into Databricks
-
Building Dynamic Web Pages with Twilio Data Using AngularJS
Create single-page applications with live connectivity to Twilio using the CData API Server.
-
Create Reports with LightSpeedRetail Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date LightSpeedRetail.
-
Connect to and Query Optimizely Data in QlikView over ODBC
Create data visualizations with Optimizely in QlikView.
-
Connect to MYOB AccountRight Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live MYOB AccountRight from Filemaker Pro on Mac.
-
Integrating Antigravity CLI with Testmonitor via CData CLI
Connect Testmonitor to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Connect to SAP ByDesign Data from AWS Glue
Use CData Connect AI to gain access to live SAP Business ByDesign from your AWS Glue jobs.