CData Software - Knowledge Base
Recent Articles
-
Connect to Zoho Books Data from Crystal Reports
Use CData Connect AI to connect to and report on live Zoho Books from Crystal Reports.
-
Connect Parquet to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Apache Parquet using the CData Python MCP Server.
-
Replicate Multiple BambooHR Accounts
Replicate multiple BambooHR accounts to one or many databases.
-
Connect to WordPress Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for WordPress Data and connect to WordPress in Akorbi Digital RunMyProcess.
-
Connect to Google Calendar Data from a Connection Pool in JBoss
Integrate Google Calendar into Java servlets: Use the Management Console in JBoss to install the Google Calendar JDBC Driver.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Google Drive using the Model Context Protocol.
-
How to connect and process Paylocity from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Paylocity.
-
Moving Data from Discourse to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Discourse data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Use the CData API Server to Access Zoho Projects Data in Microsoft PowerPivot
Use the CData API Server to connect to live Zoho Projects in the Power Pivot business intelligence tool.
-
Enable the QuickBooks Time JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with QuickBooks Time.
-
Use the CData Software ODBC Driver for HelloSign in MicroStrategy Web
Connect to HelloSign in MicroStrategy Web using the CData Software ODBC Driver for HelloSign.
-
Use the CData Software ODBC Driver for Everhour in MicroStrategy Desktop
Connect to Everhour in MicroStrategy Desktop using the CData Software ODBC Driver for Everhour.
-
DataBind Controls to SAP Netweaver Gateway Data in Delphi
DataBind to SAP Netweaver Gateway in Delphi with standard data access components and controls.
-
Use Dash to Build Web Apps on NetSuite SuiteAnalytics Data via CData Connect AI
Build interactive Dash web apps on live NetSuite SuiteAnalytics using pandas and the CData Connect AI Python SDK.
-
Access Live Dropbox Data in AWS Lambda
Connect to live Dropbox in AWS Lambda using the CData JDBC Driver.
-
Use the CData Software JDBC Driver for BigCommerce in MicroStrategy Desktop
Connect to BigCommerce in MicroStrategy Desktop using the CData Software JDBC Driver for BigCommerce.
-
Connect to Todoist Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Todoist and work with Todoist in your FileMaker applications.
-
How to import FreeAgent Data into Apache Solr
Use the CData Software JDBC Driver for FreeAgent in Data Import Handler and create an automated import of FreeAgent to Apache Solr Enterprise Search platform.
-
Query Greenplum Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Pivotal GreenPlum from Node.js.
-
Create Dynamic Google Search Grids Using the Infragistics XamDataGrid
Learn how you can connect Google Search to Infragistics XamDataGrid to build dynamic grids.
-
Connect to Oracle Financials Cloud Data in CloverDX (formerly CloverETL)
Transfer Oracle Financials Cloud using the visual workflow in the CloverDX data integration tool.
-
How to Visualize SpaceX Data in Python with pandas
Use pandas and other modules to analyze and visualize live SpaceX in Python.
-
ETL Postmark in Oracle Data Integrator
This article shows how to transfer Postmark into a data warehouse using Oracle Data Integrator.
-
Analyze Okta Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Okta with the CData JDBC Driver for Okta.
-
Provide OData Services of OnePageCrm Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for OnePageCrm by developing a WCF Service Application.
-
Build Semantic Layer Views for LDAP Objects in APOS Live Data Gateway
Use the CData Connector for LDAP in APOS Live Data Gateway to build Semantic Layer Views for LDAP.
-
Manage Parquet Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Parquet.
-
Migrating data from Azure Data Catalog to Google BigQuery using CData SSIS Components.
Easily push Azure Data Catalog to Google BigQuery using the CData SSIS Tasks for Azure Data Catalog and Google BigQuery.
-
Automated Adobe Commerce Data Replication to Teradata
Use CData Sync to Customize and automate Adobe Commerce replication to Teradata.
-
Query Parallel Data in DataGrip
Create a Data Source for Parallel in DataGrip and use SQL to query live Parallel.
-
Create OneNote-Connected Dashboards in Grafana
Connect to OneNote Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Microsoft OneNote.
-
Build a Singer.io Tap for WordPress With the CData Python Connector
Learn how to easily build a Singer.io Tap for live WordPress data using
-
Automated Continuous Aircall Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Aircall replication to Apache Kafka.
-
How to Query Facebook Ads Data in MySQL Workbench
Execute MySQL queries against live Facebook Ads from MySQL Workbench.
-
Build Visualizations of Zuora Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Zuora in Birst.
-
Getting Started with the CData ODBC Driver for Float
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Float.
-
Integrating Kiro CLI with Wave Financial 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.
-
Build Shopify-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Shopify and build web apps with connectivity to live Shopify.
-
How to Connect the Power BI Service to Quaderno: Complete Guide
Connect to the CData Software Power BI Connector for Quaderno from PowerBI.com to provide real-time Quaderno across the organization.
-
Getting Started with the CData SSIS Components for SingleStore
Complete guide to installing, licensing, and connecting with the CData SSIS Components for SingleStore.
-
ETL Wave Financial in Oracle Data Integrator
This article shows how to transfer Wave Financial into a data warehouse using Oracle Data Integrator.
-
Import SAP HANA Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access SAP HANA. In this article, you will use the OData format to import SAP HANA into Microsoft Power Query.
-
Use CData Connect AI to Access Zoho Inventory Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Zoho Inventory in the Power Pivot business intelligence tool.
-
Access Live AfterShip Data in Coginiti Pro
Connect to and query live AfterShip from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
How to Access Live HCL Domino Data in Power Automate Desktop via ODBC
The CData ODBC Driver for HCL Domino enables you to integrate HCL Domino into workflows built using Microsoft Power Automate Desktop.
-
Connecting Pipedream with Zendesk 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 Zendesk data in real time.
-
LINQ to Samanage 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 Samanage Data Provider.
-
Build Smartsheet-Powered Applications in Claude Code with CData MCP Server
Use the CData MCP Server for Smartsheet to explore live Smartsheet Data in Claude Code to assist with building Smartsheet-powered applications.
-
Connect to Zendesk Data from AWS Glue
Use CData Connect AI to gain access to live Zendesk from your AWS Glue jobs.
-
How to create BigQuery federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Google BigQuery in MySQL .
-
How to connect to Acumatica Data from Spring Boot
Connect to Acumatica in a Spring Boot Application using the CData JDBC Driver for Acumatica
-
Connect to Microsoft Entra ID Data in Claris FileMaker Pro
Use the CData ODBC Driver for Microsoft Entra ID in FileMaker Pro to connect to Microsoft Entra ID and work with Microsoft Entra ID in your FileMaker applications.
-
How to Seamlessly Import Azure Synapse Data into IBM SPSS Modeler
Integrate Azure Synapse data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Create Data Visualizations Based On JSON Services in Mode
Use CData Connect AI to connect to JSON Services from Mode and build visualizations using live
-
Integrate with live Oracle HCM Cloud Data in Jitterbit
Use CData Connect AI to connect to and integrate live Oracle HCM Cloud in Jitterbit.
-
Build SharePoint-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to SharePoint Data from Zoho Analytics and import live Microsoft SharePoint.
-
Create Instagram-Connected Nintex Workflows
Use CData Connect AI to connect to Instagram Data from Nintex Workflow Cloud and build custom workflows using live Instagram.
-
Getting Started with the CData Power BI Connector for Pipeline CRM
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Establish a Live Connection with Front Data using Tableau Bridge
The CData ODBC Driver for Front enables you to integrate live Front into Tableau Cloud dashboards using the Tableau Bridge.
-
Visualize Excel Online Data in TIBCO Spotfire through ADO.NET
Integrate Microsoft Excel Online into dashboards in TIBCO Spotfire.
-
Connect to Dynamics 365 Data from a Connection Pool in JBoss
Integrate Microsoft Dynamics 365 into Java servlets: Use the Management Console in JBoss to install the Dynamics 365 JDBC Driver.
-
Import Salesforce Data Using Azure Data Factory
Use CData Connect AI to connect to Salesforce Data from Azure Data Factory and import live Salesforce & Force.com.
-
Connect to Certinia Data in RazorSQL
Connect to Certinia from wizards and query Certinia from the GUI in the RazorSQL database management tool.
-
Use Dash to Build to Web Apps on SAP BusinessObjects BI Data
Create Python applications that use pandas and Dash to build SAP BusinessObjects BI-connected web apps.
-
Choosing the Best Method to Connect LDAP to SQL Server: 5 Options Explained
Discover multiple ways to connect and use LDAP from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Mailjet
Provide connectivity to Mailjet through an SAP BusinessObjects universe.
-
Automated Continuous HCL Domino Replication to MySQL
Use CData Sync for automated, continuous, customizable HCL Domino replication to MySQL.
-
Automated Continuous MYOB AccountRight Replication to AlloyDB
Use CData Sync for automated, continuous, customizable MYOB AccountRight replication to AlloyDB.
-
Integrating Antigravity CLI with Sentry via CData CLI
Connect Sentry to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Build Microsoft Dataverse-Powered Applications in Gemini Code Assist with CData MCP Server
Use the CData MCP Server for Microsoft Dataverse to explore live Microsoft Dataverse Data in Gemini Code Assist to assist with building Microsoft Dataverse-powered applications.
-
Build Data Flows from Snapchat Ads to SQL Server using SSIS
Easily back up Snapchat Ads to SQL Server using the SSIS components for Snapchat Ads.
-
How to use SQLAlchemy ORM to access OnePageCrm Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of OnePageCrm.
-
How to Access Klipfolio Data Using Entity Framework
This article shows how to access Klipfolio using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Access Live SAS Data Sets Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live SAS Data Sets from your Excel spreadsheets.
-
Connect to Datadog Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Datadog in the Denodo Virtual DataPort Administrator.
-
Publish SAP ByDesign-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live SAP Business ByDesign.
-
Integrate with Square Data in JReport Designer
Create charts and reports based on Square in JReport Designer.
-
Work with Bugsnag Data in FoxPro
Load Bugsnag into a FoxPro database. This article includes full code and a walk-through of the process.
-
Use the CData Software JDBC Driver for Greenplum in MicroStrategy
Connect to Pivotal GreenPlum in MicroStrategy Developer using the CData Software JDBC Driver for Greenplum.
-
Connect to Act-On Data in Aqua Data Studio
Access Act-On from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Integrating LlamaIndex with MongoDB Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on MongoDB in real time.
-
How to Connect to Live Zoho Inventory 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 Zoho Inventory for you.
-
Integrating LangChain with Vault CRM Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Veeva Vault & Vault CRM within automated workflows.
-
Integrate Open WebUI with Live Neo4J Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Neo4J from within the chat interface.
-
Create eBay-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to eBay Data from OutSystems and build custom enterprise apps using live eBay.
-
How to import Exa Data into Apache Solr
Use the CData Software JDBC Driver for Exa in Data Import Handler and create an automated import of Exa to Apache Solr Enterprise Search platform.
-
How to Visualize Freshservice Data in Python with pandas
Use pandas and other modules to analyze and visualize live Freshservice in Python.
-
Use Grok to Talk to Your Workday Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Grok AI to securely answer questions and take actions on your Workday for you.
-
Access Live TigerGraph Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate TigerGraph into the statistical analysis tools available in SAS JMP. This article shows how to use TigerGraph in the Graph Builder and Query Builder.
-
Automate Jira Data Replication to SAP HANA
Use CData Sync to customize and automate Atlassian Jira replication to SAP HANA.
-
Create SSAS Tabular Models from Clockify Data
How to build a SQL Server Analysis Service Tabular Model from Clockify using CData drivers.
-
How to Import Data from Spark into Google Sheets
Import Apache Spark SQL into a Google spreadsheet that is automatically refreshed.
-
DataBind Controls to Act-On Data in Delphi
DataBind to Act-On in Delphi with standard data access components and controls.
-
Integrating Antigravity CLI with Shortcut via CData CLI
Connect Shortcut to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Automated Continuous Airtable Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Airtable replication to Google BigQuery.
-
Integrating GitHub Copilot CLI with Apache HBase 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.
-
Using the CData Software ODBC Driver for Zoho Recruit in PyCharm
Connect to Zoho Recruit as an ODBC data source in PyCharm using the CData Software ODBC Driver for Zoho Recruit.
-
ETL Stack Exchange in Oracle Data Integrator
This article shows how to transfer Stack Exchange into a data warehouse using Oracle Data Integrator.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Neo4J using the Model Context Protocol.
-
Integrate LibreChat with Live Azure Synapse Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Azure Synapse from within the chat interface.