CData Software - Knowledge Base
Recent Articles
-
Automated Continuous Presto Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Presto data replication to OneLake in Microsoft Fabric.
-
Connect to Clockify in SpagoBI
Create reports featuring live Clockify data in SpagoBI Studio. Host Clockify reports on SpagoBI Server.
-
Visualize LDAP Objects in Tableau
The CData ODBC driver for LDAP enables you integrate LDAP objects into Tableau dashboards.
-
Cloudflare Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Cloudflare facts in real time.
-
Getting Started with the CData ODBC Driver for Factorial
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Factorial.
-
Natively Connect to Egnyte Data in PHP
The CData ODBC driver for Egnyte enables you to create PHP applications with connectivity to Egnyte data. Leverage the native support for ODBC in PHP.
-
Use the CData Software ODBC Driver for Zoho Projects in MicroStrategy
Connect to Zoho Projects data in MicroStrategy Developer using the CData Software ODBC Driver for Zoho Projects.
-
Create Data Visualizations Based On Act-On Data in Mode
Use CData Connect AI to connect to Act-On Data from Mode and build visualizations using live Act-On data.
-
Integrating Cursor with MailChimp 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.
-
How to Build an ETL App for Office 365 Data in Python with CData Connect AI
Build ETL pipelines that read and write live Office 365 data in Python with petl and the CData Connect AI Python SDK.
-
Create Shopify-Connected Nintex Workflows
Use CData Connect AI to connect to Shopify Data from Nintex Workflow Cloud and build custom workflows using live Shopify data.
-
Connect to Zoho Inventory Data in JRuby
Create a simple JRuby app with access to live Zoho Inventory data.
-
Use the CData ODBC Driver for Marketo in Microsoft Power Query
You can use the CData Marketo ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Marketo data into Microsoft Power Query.
-
Use the CData ODBC Driver for OnePageCrm in Microsoft Power Query
You can use the CData OnePageCrm ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import OnePageCrm data into Microsoft Power Query.
-
Connect to ZohoPeople Data in HULFT Integrate
Connect to ZohoPeople as a JDBC data source in HULFT Integrate
-
Create Dashboards and Visualize Live Egnyte Data in Geckoboard
Use CData Connect AI to connect to live Egnyte data and create dashboards for real-time monitoring and visualization in Geckoboard.
-
A PostgreSQL Interface for Jira Data (MySQL Remoting via JDBC)
Use the Remoting features of the Jira JDBC Driver to create a PostgreSQL entry-point for data access.
-
Integrate Trae with Live Bannerbear Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Trae to securely access and query live Bannerbear data from within the AI-powered IDE.
-
How to publish and share SAP Business Warehouse Data dashboards with Tableau Server
The CData ODBC driver for SAP Business Warehouse enables you integrate SAP Business Warehouse data into Tableau dashboards.
-
Create a Data Access Object for Adobe Target Data using JDBI
A brief overview of creating a SQL Object API for Adobe Target data in JDBI.
-
Python Connector installation: Upgrading Anaconda Distribution to 3.8 On Mac
In this entry, you will find the proper procedure for preparing a Python 3.8 environment for the Mac environment, which will allow you to install the Python 3.8 Mac wheel to your Anaconda distribution.
-
Build Grafana-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Grafana data and build Grafana-connected web apps with Axios.
-
Load Presto Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Presto data to a database.
-
Analyze IBM Informix Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of IBM Informix data and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Automated Continuous LightSpeedRetail Replication to SingleStore
Use CData Sync for automated, continuous, customizable LightSpeedRetail replication to SingleStore.
-
Visualize Live Grafana Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Grafana data.
-
Connect to Teradata Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Teradata as an External Source in Dremio.
-
How to Access Live SharePoint Excel Services Data in Power Automate Desktop via ODBC
The CData ODBC Driver for SharePoint Excel Services enables you to integrate SharePoint Excel Services data into workflows built using Microsoft Power Automate Desktop.
-
Integrate Cursor with Live SAP Hybris C4C Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live SAP Hybris C4C data from within the editor.
-
Integrate OpenCode with Live SAP ByDesign Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable OpenCode to securely access and query live SAP ByDesign data from within your AI coding agent.
-
Use the CData Software ODBC Driver for Office 365 in MicroStrategy Web
Connect to Office 365 data in MicroStrategy Web using the CData Software ODBC Driver for Office 365.
-
Migrating data from Shopify to Google BigQuery using CData SSIS Components.
Easily push Shopify data to Google BigQuery using the CData SSIS Tasks for Shopify and Google BigQuery.
-
Build Pipelines with Live RSS Feeds in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to RSS from Google Cloud Data Fusion, enabling the integration of live RSS feeds into the building and management of effective data pipelines.
-
Query Microsoft OneDrive Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Microsoft OneDrive entities in PHP by modeling them as objects.
-
DataBind Neo4J Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for Neo4J with the DevExpress Windows Forms and Web controls to provide Neo4J data to a chart.
-
Integrating Claude Code CLI with Grafana 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 Charts with ServiceDesk Plus Data in Clear Analytics
Create dynamic charts and perform analytics based on ServiceDesk Plus data in Clear Analytics.
-
How to Connect to Live Shortcut 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 Shortcut data for you.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Coinbase
Provide connectivity to Coinbase data through an SAP BusinessObjects universe.
-
Feed Square Data into FineReport
How to set Square data as a JDBC data source in FineReport.
-
Access Live Zuora Data in TIBCO Data Virtualization
Use the Zuora Tibco DV Adapter to create a Zuora data data source in TIBCO Data Virtualization Studio and gain access to live Zuora data from your TDV Server.
-
Build Automated QuickBooks Online-Connected Workflows in Zapier
Use CData Connect AI to connect to live QuickBooks Online data and build automated workflows in Zapier.
-
Integrate with Perplexity Data in JReport Designer
Create charts and reports based on Perplexity data in JReport Designer.
-
Integrate with Zoho Recruit Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Zoho Recruit data to a JSON file on disk.
-
DataBind PayPal Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for PayPal with the DevExpress Windows Forms and Web controls to provide PayPal data to a chart.
-
Build a PostgreSQL Interface for SAP Concur Data using the CData JDBC Driver
Use the Remoting features of the SAP Concur JDBC Driver to create a PostgreSQL entry-point for data access.
-
How to Seamlessly Import Adobe Experience Manager Data into IBM SPSS Modeler
Integrate Adobe Experience Manager data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Use JayDeBeApi to access Reckon Data in Python
Use standard Python scripting and the development environment of your choice to access live Reckon data.
-
Access Anaplan Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Anaplan data from HeidiSQL.
-
Provide OData Services of LDAP Objects from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for LDAP objects by developing a WCF Service Application.
-
How to import Timely Data into Apache Solr
Use the CData Software JDBC Driver for Timely in Data Import Handler and create an automated import of Timely data to Apache Solr Enterprise Search platform.
-
ETL DB2 in Oracle Data Integrator
This article shows how to transfer DB2 data into a data warehouse using Oracle Data Integrator.
-
How to Work with SAP Netweaver Gateway Data in ETL Validator JDBC
Connect to SAP Netweaver Gateway from ETL Validator jobs using the CData Software JDBC Driver.
-
Work with ZohoMarketingHub Data in FoxPro
Load ZohoMarketingHub data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Integrate with GitLab Data in SnapLogic
Use CData Connect AI to connect to and integrate with live GitLab data in SnapLogic.
-
How to Create Power BI Visual Reports with Real-Time Perplexity Data
Use CData Power BI Connectors to visualize Perplexity data in Power BI.
-
How to connect to Rebilly Data with Squirrel SQL client
Connect to Rebilly data and execute queries in the Squirrel SQL Client.
-
Build Oracle HCM Cloud-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Oracle HCM Cloud Data and create custom apps in Mendix.
-
How to Connect Flowise AI Agents to Live Wistia 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 Wistia data without replication.
-
Automated Continuous Microsoft OneLake Replication to SQLite
Use CData Sync for automated, continuous, customizable Microsoft OneLake replication to SQLite.
-
Automated Continuous Instagram Replication to SQLite
Use CData Sync for automated, continuous, customizable Instagram replication to SQLite.
-
Create Amazon Athena-Connected Nintex Workflows
Use CData Connect AI to connect to Amazon Athena Data from Nintex Workflow Cloud and build custom workflows using live Amazon Athena data.
-
ETL Google Ad Manager in Oracle Data Integrator
This article shows how to transfer Google Ad Manager data into a data warehouse using Oracle Data Integrator.
-
Connect to Monday.com Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Monday.com and the SQL Gateway to access Monday.com data from Google Apps Script.
-
Create Datasets from Aweber in Domo Workbench and Build Visualizations of Aweber Data in Domo
Use the CData Software ODBC Driver for Aweber to create datasets from Aweber data in Domo Workbench and then build visualizations in the Domo service.
-
Create Coda Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Coda data access from reports, embedded analytics, and more.
-
Connect to SAP BusinessObjects BI Data from a Connection Pool in JBoss
Integrate SAP BusinessObjects BI data into Java servlets: Use the Management Console in JBoss to install the SAP BusinessObjects BI JDBC Driver.
-
Integrating Claude Code with Redshift Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Redshift data within assisted coding and automated development workflows.
-
Use Claude to Talk to Your Power BI XMLA Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your Power BI XMLA data for you.
-
Bridge Google Ads Connectivity with Apache NiFi
Access and process Google Ads data in Apache NiFi using the CData JDBC Driver.
-
Using the CData Software ODBC Driver for Customer.io in PyCharm
Connect to Customer.io as an ODBC data source in PyCharm using the CData Software ODBC Driver for Customer.io.
-
Search External ServiceDesk Plus Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of ServiceDesk Plus data to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create ServiceDesk Plus Data objects that you can access from apps and the dashboard.
-
Replicate MYOB AccountRight Data to Multiple Databases via the CData Sync CLI
Replicate MYOB AccountRight data to disparate databases with a single configuration.
-
Process & Analyze Paylocity Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Paylocity Data.
-
Back Up Redshift data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Redshift. In this article, we will employ an SSIS workflow to populate a database with Redshift data data.
-
Visualize SQL Server Data in Tableau
The CData ODBC driver for SQL Server enables you integrate SQL Server data into Tableau dashboards.
-
Connect to ClickUp Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for ClickUp data.
-
Connect to Unbounce Data in DBeaver
Use the CData ODBC Driver to connect to Unbounce data in DBeaver.
-
Integrate Landbot Data in Pentaho Data Integration
Build ETL pipelines based on Landbot data in the Pentaho Data Integration tool.
-
How to Visualize Optimizely Data in Python with pandas via CData Connect AI
Use the CData Connect AI Python SDK with pandas and Matplotlib to analyze and visualize live Optimizely data in Python.
-
Creating Zendesk-Connected Applications in Unqork
You can use CData Connect AI to feed Zendesk data to Unqork and build custom business apps.
-
Migrating data from Sybase IQ to Databricks using CData SSIS Components.
Easily push Sybase IQ data to Databricks using the CData SSIS Tasks for Sybase IQ and Databricks.
-
Automated Continuous ActiveCampaign Replication to Snowflake
Use CData Sync for automated, continuous, customizable ActiveCampaign replication to Snowflake.
-
Build a PostgreSQL Interface for Dynamics NAV Data using the CData JDBC Driver
Use the Remoting features of the Dynamics NAV JDBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to Testmonitor Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Testmonitor data from Filemaker Pro on Mac.
-
Integrate MongoDB Data into Power Automate Desktop using CData Connect
CData Connect for MongoDB Data enables you to integrate MongoDB data into workflows built using Microsoft Power Automate Desktop.
-
Getting Started with the CData ODBC Driver for Highrise
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Highrise.
-
Access Live DB2 Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live DB2 data from your Excel spreadsheets.
-
Integrate Open WebUI with Live Amazon Marketplace Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Amazon Marketplace data from within the chat interface.
-
DataBind Zoho Recruit Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Zoho Recruit data to a chart.
-
Connect to LightSpeedRetail 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 LightSpeedRetail and work with LightSpeedRetail data in your FileMaker application.
-
Query Instagram Data in DataGrip
Create a Data Source for Instagram in DataGrip and use SQL to query live Instagram data.
-
Connect to Paymo Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Paymo data using standard SQL.
-
Connect to Omnisend Data in NetBeans
Connect to Omnisend data in NetBeans with the data source configuration wizard.
-
Natively Connect to Exact Online Data in PHP
The CData ODBC driver for Exact Online enables you to create PHP applications with connectivity to Exact Online data. Leverage the native support for ODBC in PHP.
-
Connect to Missive Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to Missive.
-
Seamlessly Bring Snowflake Data into Retool Using CData Connect AI
Integrate Snowflake data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Connect to Sugar CRM Data from a Connection Pool in Jetty
The Sugar CRM JDBC Driver supports connection pooling: This article shows how to connect faster to Sugar CRM data from Web apps in Jetty.
-
Query AlloyDB Data in DataGrip
Create a Data Source for AlloyDB in DataGrip and use SQL to query live AlloyDB data.
-
Use the CData ODBC Driver for Freshdesk in Microsoft Power Query
You can use the CData Freshdesk ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Freshdesk data into Microsoft Power Query.