CData Software - Knowledge Base
Recent Articles
-
Connect to NetSuite SuiteAnalytics Data in Google Apps Script via Connect AI
Use CData Connect AI to access NetSuite SuiteAnalytics in Google Apps Script.
-
Access Live Okta Data in Coginiti Pro
Connect to and query live Okta from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
A PostgreSQL Interface for Perplexity Data using the CData ODBC Driver
Use the SQL Gateway and Perplexity ODBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to Pipedrive Data in Aqua Data Studio
Access Pipedrive from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
How to integrate Metabase with Raisers Edge NXT Data
Use CData Connect AI to connect to live Raisers Edge NXT and create an interactive dashboard in Metabase from Raisers Edge NXT.
-
Connect to Browserless Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Browserless to connect to Browserless and execute queries in PowerBuilder.
-
Import WooCommerce Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access WooCommerce. In this article, you will use the OData format to import WooCommerce into Microsoft Power Query.
-
Access Live BigCommerce Data in TIBCO Data Virtualization
Use the BigCommerce Tibco DV Adapter to create a BigCommerce data source in TIBCO Data Virtualization Studio and gain access to live BigCommerce from your TDV Server.
-
How to Connect to & Open Paymo Data in Microsoft Excel
This article uses the CData ODBC driver for Paymo to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Connect to Google Drive Data from HeidiSQL
Use CData Connect AI to connect to and query live Google Drive from HeidiSQL.
-
Automated Continuous Presto Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Presto replication to OneLake in Microsoft Fabric.
-
Connect to Clockify in SpagoBI
Create reports featuring live Clockify in SpagoBI Studio. Host Clockify reports on SpagoBI Server.
-
Visualize LDAP Objects in Tableau
The CData ODBC driver for LDAP enables you integrate LDAP 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. Leverage the native support for ODBC in PHP.
-
Use the CData Software ODBC Driver for Zoho Projects in MicroStrategy
Connect to Zoho Projects 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
-
Integrating Cursor CLI 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 Microsoft Office 365 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.
-
Connect to Zoho Inventory Data in JRuby
Create a simple JRuby app with access to live Zoho Inventory.
-
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 into Microsoft Power Query.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed Stripe to Power BI dashboards. Simply drag and drop Stripe into data visuals on the Power BI canvas.
-
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 into Microsoft Power Query.
-
Connect to ZohoPeople Data in HULFT Integrate
Connect to ZohoPeople as a JDBC data source in HULFT Integrate
-
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.
-
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 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 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.
-
Load Presto Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Presto 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 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.
-
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 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 from within the editor.
-
Integrating Codex CLI with Delighted 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.
-
Use the CData Software ODBC Driver for Office 365 in MicroStrategy Web
Connect to Microsoft Office 365 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 to Google BigQuery using the CData SSIS Tasks for Shopify and Google BigQuery.
-
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 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 in Clear Analytics.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Coinbase
Provide connectivity to Coinbase through an SAP BusinessObjects universe.
-
Feed Square Data into FineReport
How to set Square 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 source in TIBCO Data Virtualization Studio and gain access to live Zuora from your TDV Server.
-
Build Automated QuickBooks Online-Connected Workflows in Zapier
Use CData Connect AI to connect to live QuickBooks Online and build automated workflows in Zapier.
-
Integrate with Perplexity Data in JReport Designer
Create charts and reports based on Perplexity 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 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 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.
-
Access Anaplan Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Anaplan 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 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 to Apache Solr Enterprise Search platform.
-
ETL DB2 in Oracle Data Integrator
This article shows how to transfer IBM DB2 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 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 in SnapLogic.
-
How to Create Power BI Visual Reports with Real-Time Perplexity Data
Use CData Power BI Connectors to visualize Perplexity in Power BI.
-
How to connect to Rebilly Data with Squirrel SQL client
Connect to Rebilly 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.
-
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.
-
ETL Google Ad Manager in Oracle Data Integrator
This article shows how to transfer Google Ad Manager 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 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 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 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 Amazon Redshift 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 for you.
-
Bridge Google Ads Connectivity with Apache NiFi
Access and process Google Ads 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.
-
Replicate MYOB AccountRight Data to Multiple Databases via the CData Sync CLI
Replicate MYOB AccountRight 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 Amazon Redshift 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 Amazon Redshift data.
-
Visualize SQL Server Data in Tableau
The CData ODBC driver for SQL Server enables you integrate Microsoft SQL Server into Tableau dashboards.
-
Import Presto Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Presto. In this article, you will use the OData format to import Presto into Microsoft Power Query.
-
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.
-
Connect to Unbounce Data in DBeaver
Use the CData ODBC Driver to connect to Unbounce in DBeaver.
-
Integrate Landbot Data in Pentaho Data Integration
Build ETL pipelines based on Landbot in the Pentaho Data Integration tool.
-
Creating Zendesk-Connected Applications in Unqork
You can use CData Connect AI to feed Zendesk to Unqork and build custom business apps.
-
Migrating data from Sybase IQ to Databricks using CData SSIS Components.
Easily push Sybase IQ 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.
-
Integrate MongoDB Data into Power Automate Desktop using CData Connect
CData Connect for MongoDB Data enables you to integrate MongoDB 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 IBM DB2 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 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 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 in your FileMaker application.
-
Query Instagram Data in DataGrip
Create a Data Source for Instagram in DataGrip and use SQL to query live Instagram.
-
Connect to Paymo Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Paymo using standard SQL.
-
Connect to Omnisend Data in NetBeans
Connect to Omnisend in NetBeans with the data source configuration wizard.
-
Extend Google Sheets with MySQL Data
Make calls to MySQL from Google Apps Script via the API Server.
-
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. Leverage the native support for ODBC in PHP.
-
Connect to Missive Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital