CData Software - Knowledge Base
Recent Articles
-
Prepare, Blend, and Analyze HCL Domino Data in Alteryx Designer (ODBC)
Build workflows to access live HCL Domino for self-service data analytics.
-
How to Connect Email 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 Email data in real time using natural language.
-
Connect to Scrapfly from a Connection Pool in WebLogic
Use the CData JDBC Driver for Scrapfly to connect to Scrapfly from Web applications running on WebLogic.
-
Create Zoho Creator Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Zoho Creator data access from reports, embedded analytics, and more.
-
How to connect to Google Tasks Data from IntelliJ
Integrate connectivity to Google Tasks with wizards in IntelliJ.
-
How to publish and share Mixpanel Data dashboards with Tableau Server
The CData ODBC driver for Mixpanel enables you integrate Mixpanel into Tableau dashboards.
-
Rapidly Develop Zoho Projects-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 Zoho Projects.
-
Integrate Cursor with Live Phoenix Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Apache Phoenix from within the editor.
-
Integrate Real-Time Access to xBase in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to xBase in real time.
-
Integrate Presto Data in Pentaho Data Integration
Build ETL pipelines based on Presto in the Pentaho Data Integration tool.
-
Connect to Oracle HCM Cloud Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Oracle HCM Cloud to connect to Oracle HCM Cloud and execute queries in PowerBuilder.
-
Use the CData API Server to Access Certinia Data in Microsoft PowerPivot
Use the CData API Server to connect to live Certinia in the Power Pivot business intelligence tool.
-
Work with Tickspot Data in FoxPro
Load Tickspot into a FoxPro database. This article includes full code and a walk-through of the process.
-
How to connect to Cohere Data from Spring Boot
Connect to Cohere in a Spring Boot Application using the CData API Driver for JDBC
-
Consume Microsoft Exchange OData Feeds in PowerBuilder
This article demonstrates how to consume Microsoft Exchange as OData feeds from PowerBuilder using the API Server.
-
Use the CData Software ODBC Driver for Discord in MicroStrategy
Connect to Discord in MicroStrategy Developer using the CData Software ODBC Driver for Discord.
-
How to Create Power BI Visual Reports with Real-Time AgileCRM Data
Use CData Power BI Connectors to visualize AgileCRM in Power BI.
-
How to Connect to Live MySQL Data in Mistral AI Workflows
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live MySQL without replication.
-
Build Semantic Layer Views for SQL Server Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Microsoft SQL Server.
-
Automated Cloudflare Data Replication to Teradata
Use CData Sync to Customize and automate Cloudflare replication to Teradata.
-
Connect to Zendesk Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Zendesk from Filemaker Pro on Mac.
-
Connecting GenSpark with Google Spanner Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Google Spanner without any replication or custom integration required.
-
Access Live Front Data in AWS Lambda
Connect to live Front in AWS Lambda using the CData JDBC Driver.
-
Import Power BI XMLA Data Using Azure Data Factory
Use CData Connect AI to connect to Power BI XMLA Data from Azure Data Factory and import live Power BI XMLA.
-
Use the CData Software ODBC Driver for ServiceNow in MicroStrategy
Connect to ServiceNow in MicroStrategy Developer using the CData Software ODBC Driver for ServiceNow.
-
Integrating Kiro CLI with LightSpeedRetail 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.
-
Feed Google Tasks Data into FineReport
How to set Google Tasks as a JDBC data source in FineReport.
-
Integrating Antigravity CLI with MailChimp via CData CLI
Connect MailChimp to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Build SingleStore-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for SingleStore Data and create custom apps in Mendix.
-
Getting Started with the CData Power BI Connector for Freshdesk
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Freshdesk.
-
How to connect SharePoint with Sage Cloud Accounting Data through external lists
Provide Sage Business Cloud Accounting to SharePoint users as an external list.
-
Create NetSuite SuiteAnalytics-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to NetSuite SuiteAnalytics Data from Klipfolio and build custom visualizations using live NetSuite SuiteAnalytics.
-
How to Easily Query OneNote Data in OpenOffice Base
Connect to OneNote data in OpenOffice Base using the CData ODBC Driver for OneNote and generate reports with live data insights.
-
Create Power BI Reports on Real-Time BambooHR Data
Use the CData ODBC Driver for BambooHR to visualize BambooHR in Power BI Desktop.
-
Moving Data from Microsoft Exchange to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Microsoft Exchange data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
How to connect SharePoint with GitHub Data through external lists
Provide GitHub to SharePoint users as an external list.
-
Asana Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Asana facts in real time.
-
Bridge Workday Connectivity with Apache NiFi
Access and process Workday in Apache NiFi using the CData JDBC Driver.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Monday.com within intelligent workflows.
-
Integrate Drip Data in the Pentaho Report Designer
Publish reports based on Drip in the Pentaho BI tool.
-
Prepare, Blend, and Analyze Clari Data in Alteryx Designer (ODBC)
Build workflows to access live Clari for self-service data analytics.
-
Build Azure Data Catalog-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Azure Data Catalog and build web apps with connectivity to live Azure Data Catalog.
-
Integrate with Calendly Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Calendly to a JSON file on disk.
-
Excel Spreadsheet Automation on Nuclia Data with the QUERY Formula
Pull data from Nuclia, automate spreadsheets, and more with the QUERY formula.
-
Connect to Moosend Data in NetBeans
Connect to Moosend in NetBeans with the data source configuration wizard.
-
Connecting Moonlit Workflow with Amazon Marketplace Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Moonlit workflows to securely read and act on your Amazon Marketplace in real time.
-
Migrating data from Omnisend to Snowflake using CData SSIS Components.
Easily push Omnisend to Snowflake using the CData SSIS Tasks for Omnisend and Snowflake.
-
Build a Singer.io Tap for MarkLogic With the CData Python Connector
Learn how to easily build a Singer.io Tap for live MarkLogic data using
-
Feed Cloudflare Data into FineReport
How to set Cloudflare as a JDBC data source in FineReport.
-
Build Automated Reckon Accounts Hosted-Connected Workflows in Zapier
Use CData Connect AI to connect to live Reckon Accounts Hosted and build automated workflows in Zapier.
-
Consume Active Directory OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Active Directory feeds that reflect any changes in SAP Lumira.
-
Back Up Typeform to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData API Driver for ADO.NET. In this article, we will employ an SSIS workflow to populate a database with Typeform data.
-
DataBind Perigon Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Perigon to a chart.
-
Replicate SAP Hybris C4C Data in Heroku for Use in Salesforce Connect
Replicate SAP Hybris C4C to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
How to import Codat Data into Apache Solr
Use the CData Software JDBC Driver for Codat in Data Import Handler and create an automated import of Codat to Apache Solr Enterprise Search platform.
-
How to Import Data from Kintone into Google Sheets
Import Kintone into a Google spreadsheet that is automatically refreshed.
-
How to Connect the Power BI Service to ZohoInvoice: Complete Guide
Connect to the CData Software Power BI Connector for ZohoInvoice from PowerBI.com to provide real-time ZohoInvoice across the organization.
-
How to Visualize Pipeline CRM Data in Python with pandas
Use pandas and other modules to analyze and visualize live Pipeline CRM in Python.
-
View Reports on Real-Time Apollo Data in Power BI Report Server
Use the CData ODBC Driver for Apollo to visualize Apollo in Power BI Desktop and then publish them to Power BI Report Server.
-
How to Connect to Live EnterpriseDB 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 EnterpriseDB for you.
-
How to work with BigQuery Data in Apache Spark using SQL
Access and process BigQuery Data in Apache Spark using the CData Software JDBC Driver.
-
Access SharePoint Excel Services Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live SharePoint Excel Services from HeidiSQL.
-
Build Dashboards with JSON Services in Dundas BI
Create dynamic dashboards and perform analytics based on JSON in Dundas BI.
-
Build Redshift-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Redshift Data and create custom apps in Bubble.
-
Connect to Lakebase Data in RazorSQL
Connect to Lakebase from wizards and query Lakebase from the GUI in the RazorSQL database management tool.
-
Automated Continuous Autopilot Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Autopilot replication to Google BigQuery.
-
Automate Airtable Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Airtable from PowerShell? This article demonstrates how to utilize the Airtable Cmdlets for tasks like connecting to Airtable, automating operations, downloading data, and more.
-
Automate VWO Data Replication to Azure Data Lake
Use CData Sync to customize and automate VWO replication to Azure Data Lake.
-
Automated Continuous Coinbase Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Coinbase replication to Apache Cassandra.
-
Import Real-Time Toggl Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Toggl in ColdFusion.
-
Analyze Microsoft Dataverse Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Microsoft Dataverse (CDS) in Microsoft R Open.
-
A PostgreSQL Interface for Mouseflow Data using the CData ODBC Driver
Use the SQL Gateway and Mouseflow ODBC Driver to create a PostgreSQL entry-point for data access.
-
How to connect and process Google Contacts from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Google Contacts.
-
Create Datasets from Pinterest in Domo Workbench and Build Visualizations of Pinterest Data in Domo
Use the CData Software ODBC Driver for Pinterest to create datasets from Pinterest in Domo Workbench and then build visualizations in the Domo service.
-
Getting Started with the CData SSIS Components for Close
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Close.
-
Use Azure AI Foundry to Talk to Your WordPress 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 WordPress for you.
-
Build Data Flows from SendGrid to SQL Server using SSIS
Easily back up SendGrid to SQL Server using the SSIS components for SendGrid.
-
Creating PayPal-Connected Applications in Unqork
You can use CData Connect AI to feed PayPal to Unqork and build custom business apps.
-
Integrate Goose with Live Salesforce Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Salesforce & Force.com from within the local AI agent.
-
Work with Customer.io Data in FoxPro
Load Customer.io into a FoxPro database. This article includes full code and a walk-through of the process.
-
Connect to PayPal Data in DBArtisan
Use wizards in DBArtisan to configure PayPal as a data source.
-
Automate SAP Concur Data Replication to Azure Data Lake
Use CData Sync to customize and automate SAP Concur replication to Azure Data Lake.
-
Create Miro Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Miro data access from reports, embedded analytics, and more.
-
Automated Continuous ClickUp Replication to MySQL
Use CData Sync for automated, continuous, customizable ClickUp replication to MySQL.
-
Connect to and Query Discourse Data in QlikView over ODBC
Create data visualizations with Discourse in QlikView.
-
Viewing Workable Data in RAD Studio Data Explorer
How to view Workable in RAD Studio Data Explorer using the CData ODBC Driver for Workable.
-
Use the CData Software ODBC Driver for PDFMonkey in MicroStrategy Desktop
Connect to PDFMonkey in MicroStrategy Desktop using the CData Software ODBC Driver for PDFMonkey.
-
Visualize Xero Data in Sisense
Create an ElastiCube in Sisense app with access to Xero Accounting.
-
Automated Continuous Epicor Kinetic Replication to MongoDB
Use CData Sync for automated, continuous, customizable Epicor Kinetic replication to MongoDB.
-
Migrating data from Outlook to Databricks using CData SSIS Components.
Easily push Outlook to Databricks using the CData SSIS Tasks for Outlook and Databricks.
-
How to Access Reckon Data Using Entity Framework
This article shows how to access Reckon using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Add Blackbaud FE NXT Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Blackbaud FE NXT with the Informatica Enterprise Data Catalog to classify and organize data.
-
Integrate Live ServiceNow Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to ServiceNow and integrate live ServiceNow into apps built in Microsoft Power Apps.
-
Build a PostgreSQL Interface for CSV Data using the CData JDBC Driver
Use the Remoting features of the CSV JDBC Driver to create a PostgreSQL entry-point for data access.
-
Configure the CData JDBC Driver for SAP HANA in a Connection Pool in Tomcat
Connect to SAP HANA from a connection pool in Tomcat.
-
A PostgreSQL Interface for Shopify Data (MySQL Remoting via JDBC)
Use the Remoting features of the Shopify JDBC Driver to create a PostgreSQL entry-point for data access.
-
Getting Started with the CData SSIS Components for MailChimp
Complete guide to installing, licensing, and connecting with the CData SSIS Components for MailChimp.
-
Automated Continuous Rebilly Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Rebilly replication to PostgreSQL.
-
Import and Visualize Clari Data in Power View
Create data visualizations based on Clari in Excel.
-
How to Connect to Live Salesforce CRM Analytics 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 Salesforce CRM Analytics for you.