CData Software - Knowledge Base
Recent Articles
-
Automate Avalara AvaTax Data Replication to Azure Data Lake
Use CData Sync to customize and automate Avalara AvaTax replication to Azure Data Lake.
-
Integrate Cursor with Live Cloudant Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live IBM Cloudant from within the editor.
-
Create Data Visualizations in Cognos BI with Discord Data
Access Discord as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
How to Easily Query Templated Data in OpenOffice Base
Connect to Templated data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
How to Connect to & Open Gmail Data in Microsoft Excel
This article uses the CData ODBC driver for Gmail to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Integrate Live Redshift Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Amazon Redshift and integrate live Amazon Redshift into apps built in Microsoft Power Apps.
-
How to Connect Flowise AI Agents to Live Quickbase 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 Quickbase without replication.
-
A PostgreSQL Interface for CockroachDB Data using the CData ODBC Driver
Use the SQL Gateway and CockroachDB ODBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to SAP Ariba Source Data from PowerBuilder via ADO.NET
This article demonstrates how to access SAP Ariba Source from Appeon PowerBuilder using the CData ADO.NET Provider for SAP Ariba Source.
-
Integrate Live Oracle HCM Cloud Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Oracle HCM Cloud from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Oracle HCM Cloud.
-
Build AI/ML Models with Live Telegram Data using Dataiku
Connect Telegram Data with Dataiku using the CData API Driver for JDBC.
-
How to create Hugging Face federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Hugging Face in MySQL .
-
Provide OData Services of Amazon DynamoDB Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Amazon DynamoDB by developing a WCF Service Application.
-
Consume Jira Assets OData Feeds in PowerBuilder
This article demonstrates how to consume Jira Assets as OData feeds from PowerBuilder using the API Server.
-
Use Databricks Agent Bricks to Talk to Your ADP Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your ADP for you.
-
Getting Started with the CData Python Connector for YouTube Analytics
Learn to install and license the CData Python Connector
-
Create a Data Access Object for XML Data using JDBI
A brief overview of creating a SQL Object API for XML Files in JDBI.
-
Connect to Webflow Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Webflow and the SQL Gateway to access Webflow from Google Apps Script.
-
Access Live Avaza Data in Coginiti Pro
Connect to and query live Avaza from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Getting Started with the CData Excel Add-In for CircleCI
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for CircleCI.
-
Connect to Google Directory Data in NetBeans
Connect to Google Directory in NetBeans with the data source configuration wizard.
-
Automated Continuous Zuora Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Zuora replication to Google BigQuery.
-
View Reports on Real-Time Azure Table Data in Power BI Report Server
Use the CData ODBC Driver for Azure Table to visualize Azure Table Storage in Power BI Desktop and then publish them to Power BI Report Server.
-
LINQ to Bugsnag 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 Bugsnag Data Provider.
-
Access Discourse Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Discourse from your Oracle system.
-
Visualize Snapchat Ads Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Snapchat Ads.
-
Connect to Sage Cloud Accounting Data in Ruby
Connect to Sage Business Cloud Accounting in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Use Claude to Talk to Your LinkedIn 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 LinkedIn for you.
-
Connect to Superchat 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 Superchat and work with Superchat in your FileMaker application.
-
Operational Reporting on REST Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote REST.
-
Build HelloSign-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live HelloSign.
-
Access HelloSign Data from MySQL in PHP
Connect to HelloSign through the standard MySQL libraries in PHP.
-
Visualize Live LightSpeedRetail Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live LightSpeedRetail using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Use the CData Software JDBC Driver for Aweber in MicroStrategy Desktop
Connect to Aweber in MicroStrategy Desktop using the CData Software JDBC Driver for Aweber.
-
Automated Continuous Act-On Replication to SQLite
Use CData Sync for automated, continuous, customizable Act-On replication to SQLite.
-
Build Apps with Live Klaviyo Data Using the Low-Code Development Platform of Mendix
Connect Klaviyo with Mendix to build apps using the CData JDBC Driver for Klaviyo.
-
Use the CData Software ODBC Driver for Mouseflow in MicroStrategy Web
Connect to Mouseflow in MicroStrategy Web using the CData Software ODBC Driver for Mouseflow.
-
Build a Singer.io Tap for Azure Data Lake Storage With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Azure Data Lake Storage data using
-
Connect to EmailOctopus Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Access Live Exact Online Data in Emergent via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Emergent agents to securely access and build applications with live Exact Online through MCP integration.
-
Import Real-Time Asana Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Asana in ColdFusion.
-
Connect to Sentry Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Sentry using standard SQL.
-
Establish a Live Connection with Google Forms Data using Tableau Bridge
The CData ODBC Driver for Google Forms enables you to integrate live Google Forms into Tableau Cloud dashboards using the Tableau Bridge.
-
How to Work with Brex Data in AWS Glue Jobs Using JDBC
Connect to Brex from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Build a PostgreSQL Interface for Calendly Data using the CData JDBC Driver
Use the Remoting features of the Calendly JDBC Driver to create a PostgreSQL entry-point for data access.
-
How to connect and process Oracle Sales from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Oracle Sales.
-
Natively Connect to Copper Data in PHP
The CData ODBC driver for Copper enables you to create PHP applications with connectivity to Copper. Leverage the native support for ODBC in PHP.
-
Replicate SAP Ariba Procurement Data from PowerShell
Write a quick PowerShell script to query SAP Ariba Procurement. Use connectivity to the live data to replicate SAP Ariba Procurement to SQL Server.
-
Validate Paddle Data with QuerySurge
Access and validate Paddle in QuerySurge using the CData JDBC Driver.
-
Build Sugar CRM-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Sugar CRM Data from Zoho Analytics and import live Sugar CRM.
-
Automated Continuous Facebook Ads Replication to MySQL
Use CData Sync for automated, continuous, customizable Facebook Ads replication to MySQL.
-
DataBind Controls to Zoho Creator Data in Delphi
DataBind to Zoho Creator in Delphi with standard data access components and controls.
-
Integrating Gumloop with Sybase IQ Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Sybase IQ within automated workflows.
-
How to Connect to & Open Certinia Data in Microsoft Excel
This article uses the CData ODBC driver for Certinia to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Use the CData ODBC Driver for ZeroBounce from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for ZeroBounce to connect to ZeroBounce from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring ZeroBounce in Excel.
-
Access Procore Data from MySQL in Amazon QuickSight
Connect to Procore and build visualizations of Procore using a MySQL Connection in Amazon QuickSight.
-
Object-Relational Mapping (ORM) with Redis Data Entities in Java
Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to Redis into a Java-based ORM framework, Hibernate.
-
LINQ to Placid 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 Placid Data Provider.
-
Connect to ZendeskSell Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to ZendeskSell and work with ZendeskSell in your FileMaker applications.
-
Integrate NASA Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live NASA from Informatica Cloud.
-
How to Access Live Typeform Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Typeform enables you to integrate Typeform into workflows built using Microsoft Power Automate Desktop.
-
Build Zoho Creator-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData MCP Server for Zoho Creator to explore live Zoho Creator Data in GitHub Copilot to assist with building Zoho Creator-powered applications.
-
Create GitLab-Connected Nintex Workflows
Use CData Connect AI to connect to GitLab Data from Nintex Workflow Cloud and build custom workflows using live GitLab.
-
Create Informatica Mappings From/To a JDBC Data Source for Drift
Create Drift data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Build AI Agents with Zoom Data in IBM watsonx Orchestrate using CData Connect AI
Learn how to build intelligent agents in IBM watsonx Orchestrate that can securely access and act on live Zoom through CData Connect AI.
-
Seamlessly Bring SAP Netweaver Gateway Data into Retool Using CData Connect AI
Integrate SAP Netweaver Gateway data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Access Cloudant Data in Mule Applications Using the CData JDBC Driver
Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for IBM Cloudant.
-
Analyze FTP Data in Cognos Analytics
Use CData Connect AI to connect to FTP Data from Cognos Analytics and analyze live FTP Servers.
-
Process & Analyze ZeroBounce Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live ZeroBounce Data.
-
Automated Continuous LDAP Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable LDAP replication to delimited files (CSV/TSV).
-
Migrating data from Avro to Google BigQuery using CData SSIS Components.
Easily push Apache Avro to Google BigQuery using the CData SSIS Tasks for Avro and Google BigQuery.
-
Access Live Spark Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Apache Spark SQL from your Google Sheets.
-
Back Up Quickbase to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Quickbase. In this article, we will employ an SSIS workflow to populate a database with Quickbase data.
-
Create Datasets from DB2 in Domo Workbench and Build Visualizations of DB2 Data in Domo
Use the CData Software ODBC Driver for DB2 to create datasets from IBM DB2 in Domo Workbench and then build visualizations in the Domo service.
-
Import Real-Time Todoist Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Todoist in ColdFusion.
-
How to Import Data from Lakebase into Google Sheets
Import Lakebase into a Google spreadsheet that is automatically refreshed.
-
Prepare, Blend, and Analyze Avro Data in Alteryx Designer (ODBC)
Build workflows to access live Apache Avro for self-service data analytics.
-
How to Access Live SpaceX Data in Power Automate Desktop via ODBC
The CData ODBC Driver for SpaceX enables you to integrate SpaceX into workflows built using Microsoft Power Automate Desktop.
-
Access Browserless Data from MySQL in Amazon QuickSight
Connect to Browserless and build visualizations of Browserless using a MySQL Connection in Amazon QuickSight.
-
Extract, Transform, and Load PingOne Data in Informatica PowerCenter
Create a simple Workflow for PingOne in Informatica PowerCenter.
-
Object-Relational Mapping (ORM) with SAS Data Sets Data Entities in Java
Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to SAS Data Sets into a Java-based ORM framework, Hibernate.
-
Work with Live Splunk Data in Power Query
Use CData Connect AI to connect to Splunk and work with live Splunk in Microsoft Power Query.
-
Integrate with Zoho Projects Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Zoho Projects to a JSON file on disk.
-
Use Agno to Talk to Your Google Ad Manager Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Agno agents to securely answer questions and take actions on your Google Ad Manager for you.
-
Create SSAS Tabular Models from Splunk Data
How to build a SQL Server Analysis Service Tabular Model from Splunk using CData drivers.
-
How to Query Live Omnisend Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Omnisend data in natural language using Python.
-
Create HBase-Connected Applications in Appsmith
Connect to HBase Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Apache HBase.
-
Excel Spreadsheet Automation on SAP Concur Data with the QUERY Formula
Pull data from SAP Concur, automate spreadsheets, and more with the QUERY formula.
-
Connect to Testmonitor in SpagoBI
Create reports featuring live Testmonitor in SpagoBI Studio. Host Testmonitor reports on SpagoBI Server.
-
How to load Bitbucket data into Elasticsearch via Logstash
Introducing a simple method to load Bitbucket data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
LINQ to SharePoint Excel Services 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 SharePoint Excel Services Data Provider.
-
Object-Relational Mapping (ORM) with MailerSend Data Entities in Java
Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to MailerSend into a Java-based ORM framework, Hibernate.
-
Import Azure DevOps Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Azure DevOps Data and provide access to live Azure DevOps for custom reports in the Power BI Service.
-
Getting Started with the CData SSIS Components for ZendeskSell
Complete guide to installing, licensing, and connecting with the CData SSIS Components for ZendeskSell.
-
Integrating OpenCode Terminal with Marketo 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 Workday to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Workday using the CData Python MCP Server.
-
Connect to Shippo Data in HULFT Integrate
Connect to Shippo as a JDBC data source in HULFT Integrate
-
Deploy the ADO.NET Provider for ConstantContact on an SSRS Report Server
Connect to ConstantContact from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.
-
Connect to Amazon Marketplace Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Amazon Marketplace and the SQL Gateway to access Amazon Marketplace from Google Apps Script.
-
Create Quickbase-Connected Nintex Workflows
Use CData Connect AI to connect to Quickbase Data from Nintex Workflow Cloud and build custom workflows using live Quickbase.