CData Software - Knowledge Base
Recent Articles
-
Automated Continuous Humanity Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Humanity replication to Apache Kafka.
-
Build Apps with Live Toggl Data Using the Low-Code Development Platform of Mendix
Connect Toggl with Mendix to build apps using the CData API Driver for JDBC.
-
Build Data Flows from Zoho Recruit to SQL Server using SSIS
Easily back up Zoho Recruit to SQL Server using the SSIS components for Zoho Recruit.
-
Create Reports with Helpscout Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Helpscout.
-
How to Easily Query Gumroad Data in OpenOffice Base
Connect to Gumroad data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Access Live Dynamics CRM Data in AWS Lambda
Connect to live Microsoft Dynamics CRM in AWS Lambda using the CData JDBC Driver.
-
How to Connect to & Open Basecamp Data in Microsoft Excel
This article uses the CData ODBC driver for Basecamp to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Manage NASA Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for NASA.
-
Visualize Missive 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 Missive into TIBCO Spotfire.
-
Explore Geographical Relationships in Marketo Data with Power Map
Create data visualizations with Marketo in Power Map.
-
Automate Google Ad Manager Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live Google Ad Manager and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
How to Work with Azure Table Data in ETL Validator JDBC
Connect to Azure Table from ETL Validator jobs using the CData Software JDBC Driver.
-
Import and Visualize HelloSign Data in Power View
Create data visualizations based on HelloSign in Excel.
-
Create SSAS Tabular Models from Amplitude Data
How to build a SQL Server Analysis Service Tabular Model from Amplitude using CData drivers.
-
Connect to Foursquare Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Foursquare.
-
Connect to and Visualize Live MySQL Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live MySQL.
-
How to Query Live Access Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Microsoft Access data in natural language using Python.
-
Build Apps with Live Certinia in Adalo using CData Connect AI
Use CData Connect AI to integrate live Certinia into the Adalo platform and build custom mobile and web applications with real-time Certinia.
-
Integrate with Klaviyo Data in JReport Designer
Create charts and reports based on Klaviyo in JReport Designer.
-
Connect to Factorial Data in RapidMiner
Integrate Factorial with standard components and data source configuration wizards in RapidMiner Studio.
-
Access Webflow Data from MySQL in Amazon QuickSight
Connect to Webflow and build visualizations of Webflow using a MySQL Connection in Amazon QuickSight.
-
Automated Continuous ActiveCampaign Replication to SQLite
Use CData Sync for automated, continuous, customizable ActiveCampaign replication to SQLite.
-
How to Connect to Live Salesforce Marketing 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 Salesforce Marketing Cloud for you.
-
Integrate Open WebUI with Live OneNote Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Microsoft OneNote from within the chat interface.
-
Build Apps with Live Retently Data Using the Low-Code Development Platform of Mendix
Connect Retently with Mendix to build apps using the CData API Driver for JDBC.
-
Connect to Close Data in CloverDX (formerly CloverETL)
Transfer Close using the visual workflow in the CloverDX data integration tool.
-
Enable the DocuSign JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with DocuSign.
-
Access Zoho Books 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 Zoho Books.
-
Connect to Oracle in SpagoBI
Create reports featuring live Oracle Database in SpagoBI Studio. Host Oracle reports on SpagoBI Server.
-
How to Visualize Google Search Results in Python with pandas via CData Connect AI
Use the CData Connect AI Python SDK with pandas and Matplotlib to analyze and visualize live Google Search in Python.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Acumatica
Provide connectivity to Acumatica ERP through an SAP BusinessObjects universe.
-
Connect DocuSign to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live DocuSign using the CData Python MCP Server.
-
Provide OData Services of Google Search Results from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Google Search by developing a WCF Service Application.
-
How to import Datadog Data into Apache Solr
Use the CData Software JDBC Driver for Datadog in Data Import Handler and create an automated import of Datadog to Apache Solr Enterprise Search platform.
-
Use Azure AI Foundry to Talk to Your CSV Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Azure AI Foundry agents to securely answer questions and take actions on your CSV/TSV Files for you.
-
Access Live Oracle Financials Cloud Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Oracle Financials Cloud into the statistical analysis tools available in SAS JMP. This article shows how to use Oracle Financials Cloud in the Graph Builder and Query Builder.
-
Getting Started with the CData Connect AI Python SDK for Redshift
Install the CData Connect AI Python SDK to read and write live Amazon Redshift with standard DB-API 2.0 Python code.
-
Create Informatica Mappings From/To an ODBC Data Source for Databricks
Create an ODBC connection to Databricks in Informatica and browse and transfer Databricks.
-
Moving Data from OneNote to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live OneNote data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
How to Create Power BI Visual Reports with Real-Time Oracle Service Cloud Data
Use CData Power BI Connectors to visualize Oracle Service Cloud in Power BI.
-
Use the CData Software ODBC Driver for TigerGraph in MicroStrategy Desktop
Connect to TigerGraph in MicroStrategy Desktop using the CData Software ODBC Driver for TigerGraph.
-
Automated Continuous Zendesk Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Zendesk replication to Amazon Redshift.
-
Getting Started with the CData Power BI Connector for Sage Cloud Accounting
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Sage Cloud Accounting.
-
Use the CData ODBC Driver for Google Drive from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Google Drive to connect to Google Drive from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Google Drive in Excel.
-
Viewing Microsoft Exchange Data in RAD Studio Data Explorer
How to view Microsoft Exchange in RAD Studio Data Explorer using the CData ODBC Driver for Microsoft Exchange.
-
Migrating data from Databricks to Google BigQuery using CData SSIS Components.
Easily push Databricks to Google BigQuery using the CData SSIS Tasks for Databricks and Google BigQuery.
-
Build SAP Fieldglass-Powered Applications in Cursor with CData MCP Server
Use the CData MCP Server for SAP Fieldglass to explore live SAP Fieldglass Data in Cursor to assist with building SAP Fieldglass-powered applications.
-
Connecting GenSpark with Azure Synapse Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Azure Synapse without any replication or custom integration required.
-
Connect to and Query Dynamics 365 Data in QlikView over ODBC
Create data visualizations with Microsoft Dynamics 365 in QlikView.
-
Connect to ServiceNow Data in JRuby
Create a simple JRuby app with access to live ServiceNow.
-
Build Dashboards with Deel Data in Dundas BI
Create dynamic dashboards and perform analytics based on Deel in Dundas BI.
-
Access Live Sage 200 Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Sage 200 from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
How to Connect to Live Microsoft Exchange Data from Gemini CLI (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Gemini CLI to securely read and take actions on your Microsoft Exchange for you.
-
Use the CData Software ODBC Driver for WooCommerce in MicroStrategy
Connect to WooCommerce in MicroStrategy Developer using the CData Software ODBC Driver for WooCommerce.
-
Publish Google Search-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Google Search.
-
Replicate Wrike Data from PowerShell
Write a quick PowerShell script to query Wrike. Use connectivity to the live data to replicate Wrike to SQL Server.
-
Add Float Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Float with the Informatica Enterprise Data Catalog to classify and organize data.
-
Integrate Live Freshservice Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Freshservice from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Freshservice.
-
Automated Continuous Excel Online Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Excel Online replication to Google Cloud SQL.
-
Getting Started with the CData Excel Add-In for Clari
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Clari.
-
Integrate with Live Adobe Commerce Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Adobe Commerce from the MuleSoft Anypoint Platform to integrate live Adobe Commerce into custom reports and dashboards.
-
How to Visualize SAP BusinessObjects BI Data in Python with pandas
Use pandas and other modules to analyze and visualize live SAP BusinessObjects BI in Python.
-
Getting Started with the CData JDBC Driver for Mode
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Mode.
-
Natively Connect to Flowlu Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Flowlu. Leverage the native support for ODBC in PHP.
-
Design BIRT Reports on MailerLite Data
Provide current MailerLite to your embedded analytics.
-
How to Seamlessly Import MessageBird Data into IBM SPSS Modeler
Integrate MessageBird data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Extend Google Sheets with Exact Online Data
Make calls to Exact Online from Google Apps Script via the API Server.
-
Connect to Elasticsearch Data in RapidMiner
Integrate Elasticsearch with standard components and data source configuration wizards in RapidMiner Studio.
-
Analyze DB2 Data in Infragistics Reveal
Use the CData API Server to create an OData API on top of IBM DB2 and visualize live IBM DB2 in Infragistics Reveal.
-
Build Pipelines with Live Spark Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Spark from Google Cloud Data Fusion, enabling the integration of live Apache Spark SQL into the building and management of effective data pipelines.
-
Connect to Printify Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Printify and the SQL Gateway to access Printify from Google Apps Script.
-
Building Dynamic Web Pages with BigQuery Data Using AngularJS
Create single-page applications with live connectivity to BigQuery using the CData API Server.
-
Use the CData Software JDBC Driver for Moosend in MicroStrategy Desktop
Connect to Moosend in MicroStrategy Desktop using the CData Software JDBC Driver for Moosend.
-
Visualize Intercom Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Intercom.
-
Analyze Hubstaff Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Hubstaff in Microsoft R Open.
-
DataBind Controls to Freshdesk Data in Delphi
DataBind to Freshdesk in Delphi with standard data access components and controls.
-
Connect to Gong from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Gong, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Use the CData Software ODBC Driver for Mode in MicroStrategy Web
Connect to Mode in MicroStrategy Web using the CData Software ODBC Driver for Mode.
-
Choosing the Best Method to Connect Azure Data Catalog to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Azure Data Catalog from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Use the CData Software ODBC Driver for ZeroBounce in MicroStrategy Web
Connect to ZeroBounce in MicroStrategy Web using the CData Software ODBC Driver for ZeroBounce.
-
Build an OLAP Cube in SSAS from ClickTime Data
Establish a connection to ClickTime data from SQL Server Analysis Services, and use the ClickTime Data Provider to build OLAP cubes for use in analytics and reporting.
-
Visualize Live Bullhorn CRM Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Bullhorn CRM using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Integrate LibreChat with Live Microsoft Entra ID Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Microsoft Entra ID from within the chat interface.
-
Integrate MailChimp Data in Pentaho Data Integration
Build ETL pipelines based on MailChimp in the Pentaho Data Integration tool.
-
Create SAP BusinessObjects BI-Connected Business Apps in AppSheet
Connect to SAP BusinessObjects BI Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to SAP BusinessObjects BI.
-
Trigger CouchDB IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for CouchDB with standard wizards in Logic Apps.
-
Seamlessly Bring Paylocity Data into Retool Using CData Connect AI
Integrate Paylocity data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
How to Connect to & Open ZohoSubscriptions Data in Microsoft Excel
This article uses the CData ODBC driver for ZohoSubscriptions to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Create Dynamic Bitbucket Grids Using the Infragistics XamDataGrid
Learn how you can connect Bitbucket to Infragistics XamDataGrid to build dynamic grids.
-
Access Live DB2 Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live IBM DB2 from your Excel spreadsheets.
-
How to Work with SparkPost Data in AWS Glue Jobs Using JDBC
Connect to SparkPost from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Query Lakebase Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Lakebase entities in PHP by modeling them as objects.
-
Connect Basecamp to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Basecamp using the CData Python MCP Server.
-
Create SurveyMonkey-Connected Business Apps in AppSheet
Connect to SurveyMonkey Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to SurveyMonkey.
-
Automated Continuous Amazon DynamoDB Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Amazon DynamoDB replication to IBM DB2.
-
Add ShipEngine Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for ShipEngine with the Informatica Enterprise Data Catalog to classify and organize data.
-
How to Connect to Live SAP Business One Data from Google ADK Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Google ADK agents to securely read and take actions on your SAP Business One for you.
-
Explore Geographical Relationships in Todoist Data with Power Map
Create data visualizations with Todoist in Power Map.
-
Integrating Boomi Agentstudio with Excel Online Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Microsoft Excel Online, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Connect to Microsoft Teams Data from PowerBuilder via ADO.NET
This article demonstrates how to access Microsoft Teams from Appeon PowerBuilder using the CData ADO.NET Provider for Microsoft Teams.