CData Software - Knowledge Base
Recent Articles
-
Import Real-Time Keap Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Keap in ColdFusion.
-
Build Webex-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Webex.
-
Connect to HubSpot Data from PowerBuilder via ADO.NET
This article demonstrates how to access HubSpot from Appeon PowerBuilder using the CData ADO.NET Provider for HubSpot.
-
Integrate Google Ads Data into Power Automate Desktop using CData Connect
CData Connect for Google Ads Data enables you to integrate Google Ads into workflows built using Microsoft Power Automate Desktop.
-
Connect to SAP Fieldglass Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for SAP Fieldglass Data and connect to SAP Fieldglass in Akorbi Digital RunMyProcess.
-
Creating Salesforce Marketing-Connected Applications in Unqork
You can use CData Connect AI to feed Salesforce Marketing Cloud to Unqork and build custom business apps.
-
Replicate Kintone Data to Multiple Databases via the CData Sync CLI
Replicate Kintone to disparate databases with a single configuration.
-
Connect to Oracle HCM Cloud Data as an External Data Source using PolyBase
Use CData Connect AI and PolyBase to create an external data source in SQL Swerver with access to live Oracle HCM Cloud.
-
Create Reports with Rootly Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Rootly.
-
DataBind Charts to Oracle Sales Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Oracle Sales from controls in the Visual Studio toolbox. This article demonstrates a graphical approach using wizards in Visual Studio, as well as how to databind with only a few lines of code.
-
Create Reports from MailChimp Data in Looker Studio
Use CData Connect AI to gain access to live MailChimp and create custom reports in Looker Studio.
-
Extract, Transform, and Load EnterpriseDB Data in Informatica PowerCenter
Create a simple Workflow for EnterpriseDB in Informatica PowerCenter.
-
Access Live Sugar CRM Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Sugar CRM from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Rapidly Develop Everhour-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 Everhour.
-
Automated Continuous Pipedrive Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Pipedrive replication to AlloyDB.
-
Edit and Search External Xero Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Xero Accounting to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Xero Data objects that you can access from apps and the dashboard.
-
Automated Continuous Aha! Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Aha! replication to Amazon Redshift.
-
Write a Simple Go Application to work with ConvertKit Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to ConvertKit.
-
Publish Crystal Reports on Reckon Accounts Hosted Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Reckon Accounts Hosted.
-
Integrating Claude Code CLI with Postmark 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.
-
Connect to ConvertAPI Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to ConvertAPI and work with ConvertAPI in your FileMaker applications.
-
Use JayDeBeApi to access Microsoft Planner Data in Python
Use standard Python scripting and the development environment of your choice to access live Microsoft Planner.
-
Easily Integrate Auth0 Data in Lazarus Pascal IDE
Learn how to easily integrate live Auth0 in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Add EmailOctopus Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for EmailOctopus with the Informatica Enterprise Data Catalog to classify and organize data.
-
Bridge MailerLite Connectivity with Apache NiFi
Access and process MailerLite in Apache NiFi using the CData JDBC Driver.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Outreach.io
Provide connectivity to Outreach.io through an SAP BusinessObjects universe.
-
Prepare, Blend, and Analyze XML Data in Alteryx Designer (ODBC)
Build workflows to access live XML Files for self-service data analytics.
-
How to Access SpaceX Data Using Entity Framework
This article shows how to access SpaceX using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Replicate VWO Data to Multiple Databases via the CData Sync CLI
Replicate VWO to disparate databases with a single configuration.
-
Publish Reports with GitLab Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date GitLab.
-
Import Real-Time Pushbullet Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Pushbullet in ColdFusion.
-
Use Databricks Agent Bricks to Talk to Your Google Drive Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Google Drive for you.
-
Automate Impala Data Replication to Couchbase
Use CData Sync to Customize and automate Apache Impala replication to Couchbase.
-
Connect to Impala Data from a Connection Pool in JBoss
Integrate Apache Impala into Java servlets: Use the Management Console in JBoss to install the Impala JDBC Driver.
-
Query Drift Data in DataGrip
Create a Data Source for Drift in DataGrip and use SQL to query live Drift.
-
Automated Continuous IBM Informix Replication to Amazon S3
Use CData Sync for automated, continuous, customizable IBM Informix replication to Amazon S3.
-
Analyze Discourse Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Discourse with the CData JDBC Driver for Discourse.
-
Connect to PabblySubscriptions Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to PabblySubscriptions and work with PabblySubscriptions in your FileMaker applications.
-
Getting Started with the CData JDBC Driver for Accelo
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Accelo.
-
Write a Simple Go Application to work with PivotalTracker Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to PivotalTracker.
-
Connect to xBase Data in CloverDX (formerly CloverETL)
Transfer xBase using the visual workflow in the CloverDX data integration tool.
-
Migrating data from Chargebee to Google BigQuery using CData SSIS Components.
Easily push Chargebee to Google BigQuery using the CData SSIS Tasks for Chargebee and Google BigQuery.
-
Working with Jodoo Data in LINQPad
Execute LINQ queries to Jodoo in LINQPad.
-
Access Live Exact Online Data in AWS Lambda
Connect to live Exact Online in AWS Lambda using the CData JDBC Driver.
-
Connect to Missive Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Missive and work with Missive in your FileMaker applications.
-
Build Agents in Relevance AI with Access to Live Google Campaign Manager 360 Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Google Campaign Manager 360 within intelligent agent workflows.
-
Connect to Qualaroo Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Qualaroo and work with Qualaroo in your FileMaker applications.
-
Use Biml to Build SSIS Tasks to Replicate Simplesat Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Simplesat to SQL Server.
-
Query Xero Data as a SQL Server Database in Node.js
Execute SQL Server queries against Xero Accounting from Node.js.
-
Use ChatGPT to Talk to Your Freshservice Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable ChatGPT to securely answer questions and take actions on your Freshservice for you.
-
Build CircleCI-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to CircleCI and build web apps with connectivity to live CircleCI.
-
Connect to Pipeliner CRM Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Pipeliner CRM.
-
Build Automated SQL Server-Connected Workflows in Zapier
Use CData Connect AI to connect to live Microsoft SQL Server and build automated workflows in Zapier.
-
Getting Started with the CData Excel Add-In for Cosmos DB
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Cosmos DB.
-
Query Blackbaud FE NXT Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Blackbaud FE NXT from Node.js.
-
Visualize Email Data in TIBCO Spotfire through ADO.NET
Integrate Email into dashboards in TIBCO Spotfire.
-
Connect to Salesforce Marketing Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Salesforce Marketing Cloud.
-
Replicate Sybase Data to Multiple Databases via the CData Sync CLI
Replicate Sybase to disparate databases with a single configuration.
-
Create SharePoint Excel Services Dataflows on PowerBI.com
Connect to the CData Power BI Connector for SharePoint Excel Services from PowerBI.com to create Power BI Dataflows with real-time data.
-
Bridge Keap Connectivity with Apache NiFi
Access and process Keap in Apache NiFi using the CData JDBC Driver.
-
How to integrate Metabase with GitLab Data
Use CData Connect AI to connect to live GitLab and create an interactive dashboard in Metabase from GitLab.
-
Integrate Google Ads Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Google Ads from Informatica Cloud.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Azure Data Lake Storage
Provide connectivity to Azure Data Lake Storage through an SAP BusinessObjects universe.
-
Integrate Live Customer.io Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Customer.io to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Integrating Antigravity CLI with Kintone via CData CLI
Connect Kintone to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Connect to Microsoft Teams Data in Aqua Data Studio
Access Microsoft Teams from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Publish Crystal Reports on CouchDB Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Apache CouchDB.
-
Connect to Jira Data in NetBeans
Connect to Atlassian Jira in NetBeans with the data source configuration wizard.
-
Build MVC Applications with Connectivity to LDAP Objects
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access LDAP from an ASP.NET MVC application.
-
Operational Reporting on Grafana Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Grafana.
-
How to Create Power BI Visual Reports with Real-Time ChartMogul Data
Use CData Power BI Connectors to visualize ChartMogul in Power BI.
-
Integrate Live Google Contacts Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Google Contacts to Blue Prism using the CData ODBC Driver for Google Contacts to create automated workflows for repetitive business tasks.
-
DataBind YouTube Analytics Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for YouTube Analytics with the DevExpress Windows Forms and Web controls to provide YouTube Analytics to a chart.
-
How to Create Power BI Visual Reports with Real-Time Billsby Data
Use CData Power BI Connectors to visualize Billsby in Power BI.
-
Connect to Adobe Commerce Data from PowerBuilder via ADO.NET
This article demonstrates how to access Adobe Commerce from Appeon PowerBuilder using the CData ADO.NET Provider for Adobe Commerce.
-
How to Connect DBeaver to Avaza via a JDBC Driver
Manage Avaza with visual tools in DBeaver like the query browser.
-
Import Real-Time Google Tasks Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Google Tasks in ColdFusion.
-
Visualize Drip 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 Drip into TIBCO Spotfire.
-
LINQ to Accelo Data
LINQ offers versatile querying capabilities within the .NET Framework (v3.0+), offering a straightforward method for programmatic data access through CData ADO.NET Data Providers. In this article, we demonstrate the use of LINQ to retrieve information from the Accelo Data Provider.
-
Analyze ClickUp Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for ClickUp from Power Pivot. You will use the Table Import Wizard to load ClickUp. You can visually build the import query or use any SQL supported by the driver.
-
Visualize Telegram Data in Tableau
The CData ODBC driver for Telegram enables you integrate Telegram into Tableau dashboards.
-
Use JayDeBeApi to access Close Data in Python
Use standard Python scripting and the development environment of your choice to access live Close.
-
Visualize Office 365 Data in TIBCO Spotfire through OData
Integrate Microsoft Office 365 into dashboards in TIBCO Spotfire.
-
Getting Started with the CData Excel Add-In for REST
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for REST.
-
How to Access Live SparkPost Data in Power Automate Desktop via ODBC
The CData ODBC Driver for SparkPost enables you to integrate SparkPost into workflows built using Microsoft Power Automate Desktop.
-
Create Dynamic Accelo Grids Using the Infragistics XamDataGrid
Learn how you can connect Accelo to Infragistics XamDataGrid to build dynamic grids.
-
Import Real-Time IBM Cloud Object Storage Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use IBM Cloud Object Storage in ColdFusion.
-
How to create Oracle HCM Cloud federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Oracle HCM Cloud in MySQL .
-
How to Query Live Google Translate Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Google Translate data in natural language using Python.
-
How to Work with Planio Data in AWS Glue Jobs Using JDBC
Connect to Planio from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Access Live Oracle Data in Coginiti Pro
Connect to and query live Oracle Database from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Create Dynamic Twilio Grids Using the Infragistics XamDataGrid
Learn how you can connect Twilio to Infragistics XamDataGrid to build dynamic grids.
-
Natively Connect to SAP BusinessObjects BI Data in PHP
The CData ODBC driver for SAP BusinessObjects BI enables you to create PHP applications with connectivity to SAP BusinessObjects BI. Leverage the native support for ODBC in PHP.
-
Build Google Analytics-Connected Apps in Choreo
Use CData Connect AI to connect to Google Analytics Data from Choreo and build custom apps using live Google Analytics.
-
Connect to Paymo Data from a Connection Pool in JBoss
Integrate Paymo into Java servlets: Use the Management Console in JBoss to install the Paymo JDBC Driver.
-
Humanity Reporting in OBIEE with the Humanity JDBC Driver
Deploy the Humanity JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Integrating Codex CLI with Scrapfly 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.
-
Access Bullhorn CRM Data from MySQL in Amazon QuickSight
Connect to Bullhorn CRM and build visualizations of Bullhorn CRM using a MySQL Connection in Amazon QuickSight.
-
Build Automated Workflows with Live Gmail Data in Workato
Use CData Connect AI to connect to live Gmail and build automated workflows in Workato.
-
Access AlloyDB Data from MySQL in Amazon QuickSight
Connect to AlloyDB and build visualizations of Google AlloyDB using a MySQL Connection in Amazon QuickSight.