CData Software - Knowledge Base
Recent Articles
-
Connect to Greenhouse Data in RazorSQL
Connect to Greenhouse from wizards and query Greenhouse from the GUI in the RazorSQL database management tool.
-
Query Sybase IQ Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Sybase IQ entities in PHP by modeling them as objects.
-
How to Query OneNote Data in MySQL Workbench
Execute MySQL queries against live Microsoft OneNote from MySQL Workbench.
-
Access SAP Netweaver Gateway 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 SAP Netweaver Gateway.
-
How to work with Freshservice Data in Apache Spark using SQL
Access and process Freshservice Data in Apache Spark using the CData Software JDBC Driver.
-
Connect Gumroad to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Gumroad with IBM WebSphere for seamless data integration and connectivity.
-
Replicate PayPal Data to Multiple Databases via the CData Sync CLI
Replicate PayPal to disparate databases with a single configuration.
-
Connect to and Visualize Live Elorus Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Elorus.
-
Oracle Eloqua Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Oracle Eloqua through CData Connect AI using different applications and tools.
-
Use CData Connect AI to Access IBM Informix Data in Microsoft Power Pivot
Use CData Connect AI to connect to live IBM Informix in the Power Pivot business intelligence tool.
-
Connecting Agentforce with Neo4J 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 Neo4J for you.
-
How to Build an ETL App for ZohoExpense Data in Python with CData
Create ETL applications and real-time data pipelines for ZohoExpense in Python with petl.
-
Connect to AlloyDB Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for AlloyDB Data and connect to Google AlloyDB in Akorbi Digital RunMyProcess.
-
How to work with RSS Feeds in Apache Spark using SQL
Access and process RSS Feeds in Apache Spark using the CData Software JDBC Driver.
-
Analyze SageHR Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for SageHR from Power Pivot. You will use the Table Import Wizard to load SageHR. You can visually build the import query or use any SQL supported by the driver.
-
DataBind Charts to Salesloft Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Salesloft 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.
-
Use Dash to Build Web Apps on Act-On Data via CData Connect AI
Build interactive Dash web apps on live Act-On using pandas and the CData Connect AI Python SDK.
-
Automated Continuous Splunk Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Splunk replication to Apache Kafka.
-
Automate Pipedrive Data Replication to SAP HANA
Use CData Sync to customize and automate Pipedrive replication to SAP HANA.
-
How to create ScrapingBee federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for ScrapingBee in MySQL .
-
Automate ZohoPeople Data Replication to Azure Synapse
Use CData Sync to customize and automate ZohoPeople replication to Azure Synapse.
-
Build Zoho Projects-Connected Apps in Choreo
Use CData Connect AI to connect to Zoho Projects Data from Choreo and build custom apps using live Zoho Projects.
-
Consume Access OData Feeds in PowerBuilder
This article demonstrates how to consume Microsoft Access as OData feeds from PowerBuilder using the API Server.
-
Configure the CData JDBC Driver for ZohoInvoice in a Connection Pool in Tomcat
Connect to ZohoInvoice from a connection pool in Tomcat.
-
Using the CData Software ODBC Driver for SAP ByDesign in PyCharm
Connect to SAP ByDesign as an ODBC data source in PyCharm using the CData Software ODBC Driver for SAP ByDesign.
-
Use the CData SSIS Components to Insert New or Update Existing Avalara AvaTax Records from SQL Server
Easily push SQL Server data to Avalara AvaTax using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Avalara AvaTax or update existing records with data from a SQL Server database.
-
Create SSAS Tabular Models from HelloSign Data
How to build a SQL Server Analysis Service Tabular Model from HelloSign using CData drivers.
-
Integrating Claude Code CLI with SAS Data Sets 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 Salesforce Pardot Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Salesforce Pardot and the Script function in FileMaker Pro to connect to Salesforce Pardot and work with Salesforce Pardot in your FileMaker application.
-
Connect to Live Asana Data in MicroStrategy through CData Connect AI
Create a live connection to Asana Data in CData Connect AI and connect to your Asana from MicroStrategy.
-
How to Connect to Live Elasticsearch Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Elasticsearch securely in real time.
-
Connect to Dotmailer Data in DBeaver
Use the CData ODBC Driver to connect to Dotmailer in DBeaver.
-
Use Biml to Build SSIS Tasks to Replicate Dropbox Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Dropbox to SQL Server.
-
Use Dash to Build to Web Apps on Zoho Books Data
Create Python applications that use pandas and Dash to build Zoho Books-connected web apps.
-
Work with Sage Cloud Accounting Data in FoxPro
Load Sage Business Cloud Accounting into a FoxPro database. This article includes full code and a walk-through of the process.
-
How to Access Live Redshift Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Redshift enables you to integrate Amazon Redshift into workflows built using Microsoft Power Automate Desktop.
-
Create Hive Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Hive data access from reports, embedded analytics, and more.
-
How to use SQLAlchemy ORM to access Gumroad Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Gumroad.
-
Connect to and Query Printify Data in QlikView over ODBC
Create data visualizations with Printify in QlikView.
-
Use the CData Software JDBC Driver for Zuora in MicroStrategy Desktop
Connect to Zuora in MicroStrategy Desktop using the CData Software JDBC Driver for Zuora.
-
Use Microsoft Copilot Studio to talk to your ActiveCampaign Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Microsoft Copilot Studio to securely answer questions and take actions on your ActiveCampaign for you.
-
Publish Crystal Reports on PhantomBuster Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date PhantomBuster.
-
Stream MarkLogic Data into Apache Kafka Topics
Access and stream MarkLogic in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Query Impala Data in ColdFusion
Write standard ColdFusion data access code to connect to Apache Impala.
-
Edit and Search SAP ByDesign External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of SAP Business ByDesign to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create SAP ByDesign objects that you can access from apps and the dashboard.
-
Analyze Exact Online Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Exact Online with the CData JDBC Driver for Exact Online.
-
Analyze Google Campaign Manager 360 Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Google Campaign Manager 360 from Power Pivot. You will use the Table Import Wizard to load Google Campaign Manager 360. You can visually build the import query or use any SQL supported by the driver.
-
How to Query Live Dropbox Data in Perplexity MacOS Desktop
Connect to and query live Dropbox Data in Perplexity Desktop using CData MCP Server.
-
Query Sybase Data as a MySQL Database in Node.js
Execute MySQL queries against Sybase from Node.js.
-
How to connect to Paylocity Data from Spring Boot
Connect to Paylocity in a Spring Boot Application using the CData JDBC Driver for Paylocity
-
Create Reports with Simplesat Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Simplesat.
-
Connect to Autopilot Data Using the Script Function in Claris FileMaker Pro
Use the CData API Driver for ODBC and the Script function in FileMaker Pro to connect to Autopilot and work with Autopilot in your FileMaker application.
-
Build Charts with Keap Data in Clear Analytics
Create dynamic charts and perform analytics based on Keap in Clear Analytics.
-
Connect to Azure Data Catalog Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Azure Data Catalog and the Script function in FileMaker Pro to connect to Azure Data Catalog and work with Azure Data Catalog in your FileMaker application.
-
Connect to Discord Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Discord and the SQL Gateway to access Discord from Google Apps Script.
-
Connect to Aircall Data from PowerBuilder via JDBC
This article demonstrates how to access Aircall from PowerBuilder using the Aircall JDBC Driver.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed FHIR to Power BI dashboards. Simply drag and drop FHIR into data visuals on the Power BI canvas.
-
Connect to JobNimbus Data in Aqua Data Studio
Access JobNimbus from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for SharePoint
Provide connectivity to Microsoft SharePoint through an SAP BusinessObjects universe.
-
Work with Live Redshift Data in Power Query
Use CData Connect AI to connect to Amazon Redshift and work with live Amazon Redshift in Microsoft Power Query.
-
Access Workable Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Workable from your Oracle system.
-
Use Biml to Build SSIS Tasks to Replicate Samanage Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Samanage to SQL Server.
-
Getting Started with the CData SSIS Components for Shippo
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Shippo.
-
Access BigCommerce Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access BigCommerce from your Oracle system.
-
Import Real-Time ClickTime Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use ClickTime in ColdFusion.
-
How to connect to Dynamics CRM Data from IntelliJ
Integrate connectivity to Microsoft Dynamics CRM with wizards in IntelliJ.
-
Viewing Zoho Books Data in RAD Studio Data Explorer
How to view Zoho Books in RAD Studio Data Explorer using the CData ODBC Driver for Zoho Books.
-
Automate ZohoSubscriptions Data Replication to Azure Synapse
Use CData Sync to customize and automate ZohoSubscriptions replication to Azure Synapse.
-
Connecting Pipedream with Basecamp 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 Basecamp data in real time.
-
Automated Continuous Slack Replication to SQLite
Use CData Sync for automated, continuous, customizable Slack replication to SQLite.
-
How to Create Power BI Visual Reports with Real-Time Pipeline CRM Data
Use CData Power BI Connectors to visualize Pipeline CRM in Power BI.
-
How to publish and share SpaceX Data dashboards with Tableau Server
The CData ODBC driver for SpaceX enables you integrate SpaceX into Tableau dashboards.
-
Connect to NASA Data in CloverDX (formerly CloverETL)
Transfer NASA using the visual workflow in the CloverDX data integration tool.
-
Use JayDeBeApi to access Clio Data in Python
Use standard Python scripting and the development environment of your choice to access live Clio.
-
Access Live NASA Data in Coginiti Pro
Connect to and query live NASA from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Connect to Google Directory Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Google Directory.
-
Replicate Discord Data to Multiple Databases via the CData Sync CLI
Replicate Discord to disparate databases with a single configuration.
-
Connect to Google Translate Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Google Translate using standard SQL.
-
Getting Started with the CData ODBC Driver for PDFMonkey
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for PDFMonkey.
-
Import SuiteCRM Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access SuiteCRM. In this article, you will use the OData format to import SuiteCRM into Microsoft Power Query.
-
How to Access Live SuiteCRM Data in Visual Studio Code via Cline
Run CData MCP Server for SuiteCRM on Windows Subsytem for Linux (WSL) and connect to live SuiteCRM from the Cline extension in Visual Studio Code.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Sugar CRM using the Model Context Protocol.
-
Visualize Live FreeAgent Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live FreeAgent.
-
Connect Slack to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Slack using the CData Python MCP Server.
-
Create Reports with BigCommerce Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date BigCommerce.
-
Viewing Microsoft Ads Data in RAD Studio Data Explorer
How to view Microsoft Ads in RAD Studio Data Explorer using the CData ODBC Driver for Microsoft Ads.
-
Build Voice Agents in ElevenLabs with access to Live Avro Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Apache Avro.
-
Easily Integrate Shopify Data in Lazarus Pascal IDE
Learn how to easily integrate live Shopify in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Build MVC Applications with Connectivity to Jodoo Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Jodoo from an ASP.NET MVC application.
-
Connect AdRoll Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your AdRoll using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
How to Access SAP Concur Data Using Entity Framework
This article shows how to access SAP Concur using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Connect to JDBC-ODBC Bridge Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for JDBC-ODBC Bridge in the Denodo Virtual DataPort Administrator.
-
How to Import Data from SharePoint into Google Sheets
Import Microsoft SharePoint into a Google spreadsheet that is automatically refreshed.
-
Import Salesforce Pardot Data Using Azure Data Factory
Use CData Connect AI to connect to Salesforce Pardot Data from Azure Data Factory and import live Salesforce Pardot.
-
Build LinkedIn Ads-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live LinkedIn Ads.
-
Integrating LlamaIndex with Slack Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Slack in real time.
-
How to Create Power BI Visual Reports with Real-Time Kintone Data
Use CData Power BI Connectors to visualize Kintone in Power BI.
-
Visualize Parallel 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 Parallel into TIBCO Spotfire.
-
Analyze Act CRM Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Act CRM from Power Pivot. You will use the Table Import Wizard to load Act CRM. You can visually build the import query or use any SQL supported by the driver.
-
Create SSAS Tabular Models from Oracle SCM Data
How to build a SQL Server Analysis Service Tabular Model from Oracle SCM using CData drivers.