CData Software - Knowledge Base
Recent Articles
-
Build Printful-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Printful data and build web apps with connectivity to live Printful data.
-
Create Datasets from Acumatica in Domo Workbench and Build Visualizations of Acumatica Data in Domo
Use the CData Software ODBC Driver for Acumatica to create datasets from Acumatica data in Domo Workbench and then build visualizations in the Domo service.
-
Replicate ZohoExpense Data to Multiple Databases via the CData Sync CLI
Replicate ZohoExpense data to disparate databases with a single configuration.
-
Integrating Dataiku with Sage Cloud Accounting Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Sage Cloud Accounting data.
-
Choosing the Best Method to Connect SpaceX to SQL Server: 5 Options Explained
Discover multiple ways to connect and use SpaceX data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Connect to HDFS Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live HDFS data from Filemaker Pro on Mac.
-
How to Work with Box Data in ETL Validator JDBC
Connect to Box from ETL Validator jobs using the CData Software JDBC Driver.
-
Build Presto-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Presto Data and create custom apps in Mendix.
-
Feed SAS xpt Data into FineReport
How to set SAS xpt data as a JDBC data source in FineReport.
-
Analyze AfterShip Data in Cognos Analytics
Use CData Connect AI to connect to AfterShip Data from Cognos Analytics and analyze live AfterShip data.
-
Visualize Live Amazon Athena Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Amazon Athena data.
-
Automate SageHR Data Replication to SAP HANA
Use CData Sync to customize and automate SageHR data replication to SAP HANA.
-
Access Live Dynamics CRM Data in Excel 365 Online (Excel for the web)
Connect to Dynamics CRM data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
How to connect to Cassandra Data from Spring Boot
Connect to Cassandra in a Spring Boot Application using the CData JDBC Driver for Cassandra
-
Natively Connect to Notion Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Notion data. Leverage the native support for ODBC in PHP.
-
Build Charts with Contentful Data in Clear Analytics
Create dynamic charts and perform analytics based on Contentful data in Clear Analytics.
-
Connect to Rootly Data from PowerBuilder via ADO.NET
This article demonstrates how to access Rootly data from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Connect to Teradata Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Teradata to connect to Teradata data and execute queries in PowerBuilder.
-
Automated Continuous Hubstaff Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Hubstaff replication to Google Cloud SQL.
-
Query Google Ads Data as a SQL Server Database in Node.js
Execute SQL Server queries against Google Ads data from Node.js.
-
How to Connect to Live Jumpseller 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 Jumpseller data for you.
-
Connect to AfterShip Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for AfterShip data in the Denodo Virtual DataPort Administrator.
-
Integrate Perplexity Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Perplexity data from Informatica Cloud.
-
Use the CData ODBC Driver for Foursquare from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Foursquare to connect to Foursquare data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Foursquare data in Excel.
-
Query VWO Data as a SQL Server Database in Node.js
Execute SQL Server queries against VWO data from Node.js.
-
Connecting Agentforce with Jira Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Agentforce to securely read and take actions on your Jira data for you.
-
Use the CData Software ODBC Driver for ZohoPeople in MicroStrategy Web
Connect to ZohoPeople data in MicroStrategy Web using the CData Software ODBC Driver for ZohoPeople.
-
Natively Connect to Azure Table Data in PHP
The CData ODBC driver for Azure Table enables you to create PHP applications with connectivity to Azure Table data. Leverage the native support for ODBC in PHP.
-
Query Google Drive Data in ColdFusion
Write standard ColdFusion data access code to connect to Google Drive data.
-
Connect to Salesforce CRM Analytics in SpagoBI
Create reports featuring live Salesforce CRM Analytics data in SpagoBI Studio. Host Salesforce CRM Analytics reports on SpagoBI Server.
-
DataBind Controls to Spark Data in C++Builder
DataBind to Spark data in C++Builder with standard components and controls.
-
Getting Started with the CData Python Connector for Simplesat
Learn to install and license the CData Python Connector and configure a connection to live Simplesat data.
-
ETL Opsgenie in Oracle Data Integrator
This article shows how to transfer Opsgenie data into a data warehouse using Oracle Data Integrator.
-
Use Databricks Agent Bricks to Talk to Your Greenhouse Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Greenhouse data for you.
-
Use the CData Software JDBC Driver for Invoiced in MicroStrategy
Connect to Invoiced data in MicroStrategy Developer using the CData Software JDBC Driver for Invoiced.
-
Visualize SAP Netweaver Gateway Data in TIBCO Spotfire through ADO.NET
Integrate SAP Netweaver Gateway data into dashboards in TIBCO Spotfire.
-
Automated Continuous SAP HANA Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable SAP HANA replication to delimited files (CSV/TSV).
-
Connect to Salesforce Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Salesforce as an External Source in Dremio.
-
How to Visualize ZeroBounce Data in Python with pandas
Use pandas and other modules to analyze and visualize live ZeroBounce data in Python.
-
Integrating LangGraph with Klipfolio Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Klipfolio data within automated workflows.
-
Create Informatica Mappings From/To an ODBC Data Source for DB2
Create an ODBC connection to DB2 in Informatica and browse and transfer DB2 data.
-
Dynamics CRM Reporting in OBIEE with the Dynamics CRM JDBC Driver
Deploy the Dynamics CRM JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Rapidly Develop Salesforce Marketing-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 Salesforce Marketing.
-
Query Live Gmail Data in Perplexity Desktop via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Perplexity Desktop to securely access and query live Gmail data through a conversational interface.
-
Create Datasets from Phoenix in Domo Workbench and Build Visualizations of Phoenix Data in Domo
Use the CData Software ODBC Driver for Phoenix to create datasets from Phoenix data in Domo Workbench and then build visualizations in the Domo service.
-
Automated Continuous RabbitMQ Replication to AlloyDB
Use CData Sync for automated, continuous, customizable RabbitMQ replication to AlloyDB.
-
Build Dashboards with Samanage Data in Dundas BI
Create dynamic dashboards and perform analytics based on Samanage data in Dundas BI.
-
Access Live Campaigner Data in AWS Lambda
Connect to live Campaigner data in AWS Lambda using the CData JDBC Driver.
-
Use CData Connect AI to Access Microsoft Entra ID Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Microsoft Entra ID data in the Power Pivot business intelligence tool.
-
Create HubDB-Connected Applications in Appsmith
Connect to HubDB Data via CData Connect AI in Appsmith and create custom business applications with real-time access to HubDB data.
-
Viewing Rootly Data in RAD Studio Data Explorer
How to view Rootly data in RAD Studio Data Explorer using the CData ODBC Driver for Rootly.
-
Create SSAS Tabular Models from VWO Data
How to build a SQL Server Analysis Service Tabular Model from VWO data using CData drivers.
-
Visualize Live Salesforce Pardot Data in the Power BI Service
Use CData Connect AI to connect to live Salesforce Pardot data and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Visualize Live SAP ByDesign Data in the Power BI Service
Use CData Connect AI to connect to live SAP ByDesign data and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Access Live Reckon Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Reckon data into the statistical analysis tools available in SAS JMP. This article shows how to use Reckon data in the Graph Builder and Query Builder.
-
Connect to Zendesk Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Zendesk data in Airbyte.
-
Connect to Highrise from a Connection Pool in WebLogic
Use the CData JDBC Driver for Highrise to connect to Highrise data from Web applications running on WebLogic.
-
Integrating Boomi Agentstudio with Kintone Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Kintone data, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Moving Data from Zendesk to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Zendesk data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Integrating LangGraph with Paylocity Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Paylocity data within automated workflows.
-
Migrating data from Foursquare to Snowflake using CData SSIS Components.
Easily push Foursquare data to Snowflake using the CData SSIS Tasks for Foursquare and Snowflake.
-
Connect to Notion Data in Jaspersoft Studio
Execute SQL to remote Notion data in Jaspersoft Studio.
-
ETL Twitter Ads in Oracle Data Integrator
This article shows how to transfer Twitter Ads data into a data warehouse using Oracle Data Integrator.
-
Analyze Microsoft OneDrive Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Microsoft OneDrive data and visualize live Microsoft OneDrive data in Infragistics Reveal.
-
Work with Hive Data in FoxPro
Load Hive data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Build a PostgreSQL Interface for Copper Data using the CData JDBC Driver
Use the Remoting features of the Copper JDBC Driver to create a PostgreSQL entry-point for data access.
-
Integrate with LinkedIn Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy LinkedIn data to a JSON file on disk.
-
Use Dash to Build Web Apps on SurveyMonkey Data via CData Connect AI
Build interactive Dash web apps on live SurveyMonkey data using pandas and the CData Connect AI Python SDK.
-
Automated Continuous Freshservice Replication to SQLite
Use CData Sync for automated, continuous, customizable Freshservice replication to SQLite.
-
Connect to Apollo Data from a Connection Pool in Jetty
The Apollo JDBC Driver supports connection pooling: This article shows how to connect faster to Apollo data from Web apps in Jetty.
-
Connect to and Query Oracle Eloqua Reporting Data in QlikView over ODBC
Create data visualizations with Oracle Eloqua Reporting data in QlikView.
-
Migrating data from PabblySubscriptions to Snowflake using CData SSIS Components.
Easily push PabblySubscriptions data to Snowflake using the CData SSIS Tasks for PabblySubscriptions and Snowflake.
-
Connect to Oracle Sales Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Oracle Sales Data and connect to Oracle Sales data in Akorbi Digital RunMyProcess.
-
Integrating GitHub Copilot with Insightly 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.
-
Integrate Google's Vertex AI Agent with Live SQL Server Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live SQL Server data within intelligent workflows.
-
Integrate Mailgun Data into Power Automate Desktop using CData Connect
CData Connect for Mailgun Data enables you to integrate Mailgun data into workflows built using Microsoft Power Automate Desktop.
-
Feed Bannerbear Data into FineReport
How to set Bannerbear data as a JDBC data source in FineReport.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for SharePoint
Provide connectivity to SharePoint data through an SAP BusinessObjects universe.
-
How to connect to Printify Data from IntelliJ
Integrate connectivity to Printify data with wizards in IntelliJ.
-
Build a Simple VCL Application for PhantomBuster Data
How to build a simple VCL Application to view PhantomBuster data in RAD Studio using the CData ODBC Driver for PhantomBuster.
-
Build Semantic Layer Views for SAP Fieldglass Data in APOS Live Data Gateway
Use the CData Connector for SAP Fieldglass in APOS Live Data Gateway to build Semantic Layer Views for SAP Fieldglass data.
-
Connect to Stripe Data in Google Apps Script via Connect AI
Use CData Connect AI to access Stripe data in Google Apps Script.
-
Connect to HubDB Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for HubDB and the SQL Gateway to access HubDB data from Google Apps Script.
-
Connect to Quickbase Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Quickbase data in the Denodo Virtual DataPort Administrator.
-
Use the CData ODBC Driver for Zuora from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Zuora to connect to Zuora data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Zuora data in Excel.
-
Integrate Live CapsuleCRM Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live CapsuleCRM data to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Integrate Goose with Live Dynamics NAV Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Dynamics NAV data from within the local AI agent.
-
Integrate BenchmarkEmail with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate BenchmarkEmail with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to BenchmarkEmail data.
-
Publish SageHR-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live SageHR data.
-
Use the CData Software ODBC Driver for Microsoft Dataverse in MicroStrategy
Connect to Microsoft Dataverse data in MicroStrategy Developer using the CData Software ODBC Driver for Microsoft Dataverse.
-
Build Dashboards with Bugsnag Data in Dundas BI
Create dynamic dashboards and perform analytics based on Bugsnag data in Dundas BI.
-
Import Real-Time Discord Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Discord data in ColdFusion.
-
Automated Continuous Ontraport Replication to SQL Server
Use CData Sync for automated, continuous, customizable Ontraport replication to SQL Server.
-
Connect to Wistia Data from PowerBuilder via ADO.NET
This article demonstrates how to access Wistia data from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Create Informatica Mappings From/To an ODBC Data Source for Sage Cloud Accounting
Create an ODBC connection to Sage Cloud Accounting in Informatica and browse and transfer Sage Cloud Accounting data.
-
Natively Connect to MariaDB Data in PHP
The CData ODBC driver for MariaDB enables you to create PHP applications with connectivity to MariaDB data. Leverage the native support for ODBC in PHP.
-
Box Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Box facts in real time.
-
Build Pipelines with Live Google Drive Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Google Drive from Google Cloud Data Fusion, enabling the integration of live Google Drive data into the building and management of effective data pipelines.
-
How to Query Salesforce CRM Analytics Data in MySQL Workbench
Execute MySQL queries against live Salesforce CRM Analytics data from MySQL Workbench.
-
How to Work with Marketo Data in AWS Glue Jobs Using JDBC
Connect to Marketo from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.