CData Software - Knowledge Base
Recent Articles
-
Connect to FreshBooks Data from PowerBuilder via ADO.NET
This article demonstrates how to access FreshBooks from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Connect Paymo to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Paymo using the CData Python MCP Server.
-
Getting Started with the CData ODBC Driver for Copper
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Copper.
-
Integrating OpenCode Terminal with Opsgenie 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 connect and process Gumroad from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Gumroad.
-
Create Informatica Mappings From/To a JDBC Data Source for CouchDB
Create CouchDB data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Use Azure AI Foundry to Talk to Your Snowflake Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Azure AI Foundry agents to securely answer questions and take actions on your Snowflake for you.
-
Use Microsoft Copilot Studio to talk to your SAP Hybris C4C Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Microsoft Copilot Studio to securely answer questions and take actions on your SAP Hybris C4C for you.
-
Integrating Codex CLI with PivotalTracker 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 Connect the Power BI Service to Hive: Complete Guide
Connect to the CData Software Power BI Connector for Hive from PowerBI.com to provide real-time Apache Hive across the organization.
-
Automated Everhour Data Replication to Teradata
Use CData Sync to Customize and automate Everhour replication to Teradata.
-
Connect to Real-Time Azure Table Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Azure Table and Dataflow to import and use Azure Table Storage in Power Apps.
-
Automated Continuous FreeAgent Replication to SingleStore
Use CData Sync for automated, continuous, customizable FreeAgent replication to SingleStore.
-
Visualize Live SAS xpt Data in the Power BI Service
Use CData Connect AI to connect to live SAS XPORT and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Build Charts with Microsoft Dataverse Data in Clear Analytics
Create dynamic charts and perform analytics based on Microsoft Dataverse (CDS) in Clear Analytics.
-
Getting Started with the CData JDBC Driver for GitLab
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for GitLab.
-
Access YouTube Analytics Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live YouTube Analytics from HeidiSQL.
-
How to Connect DBeaver to Odoo via a JDBC Driver
Manage Odoo ERP with visual tools in DBeaver like the query browser.
-
Integrate with Databricks Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Databricks to a JSON file on disk.
-
Query SQL Server Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume SQL Server entities in PHP by modeling them as objects.
-
Query PivotalTracker Data in ColdFusion
Write standard ColdFusion data access code to connect to PivotalTracker.
-
Build Visualizations of Customer.io Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Customer.io in Birst.
-
Replicate Couchbase Data in Heroku for Use in Salesforce Connect
Replicate Couchbase to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Publish Crystal Reports on Tickspot Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Tickspot.
-
Integrating LangGraph with Stripe Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Stripe within automated workflows.
-
Integrate SAP Hybris C4C with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate SAP Hybris C4C with External Services.
-
Build Apps with Live Sybase IQ in Adalo using CData Connect AI
Use CData Connect AI to integrate live Sybase IQ into the Adalo platform and build custom mobile and web applications with real-time Sybase IQ.
-
Create SSAS Tabular Models from Google Ad Manager Data
How to build a SQL Server Analysis Service Tabular Model from Google Ad Manager using CData drivers.
-
Marketo Reporting in OBIEE with the Marketo JDBC Driver
Deploy the Marketo JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Visualize Unbounce Data in Tableau
The CData ODBC driver for Unbounce enables you integrate Unbounce into Tableau dashboards.
-
Automated Continuous Sugar CRM Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Sugar CRM replication to Apache Cassandra.
-
How to connect to Timely Data from Spring Boot
Connect to Timely in a Spring Boot Application using the CData API Driver for JDBC
-
A PostgreSQL Interface for Xero Data (MySQL Remoting via JDBC)
Use the Remoting features of the Xero JDBC Driver to create a PostgreSQL entry-point for data access.
-
Create Data Visualizations in Cognos BI with Pipeline CRM Data
Access Pipeline CRM as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Create Pipedrive-Connected Dashboards in Grafana
Connect to Pipedrive Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Pipedrive.
-
Use the CData ODBC Driver for PingOne from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for PingOne to connect to PingOne from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring PingOne in Excel.
-
Connecting Mastra with Facebook Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to enable Mastra agents to securely query, read, and act on real-time Facebook, no replication required.
-
Create Dynamic Shopify Grids Using the Infragistics XamDataGrid
Learn how you can connect Shopify to Infragistics XamDataGrid to build dynamic grids.
-
Access Live Google Search Results in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Google Search from your Excel spreadsheets.
-
Integrate Highrise Data into Power Automate Desktop using CData Connect
CData Connect for Highrise Data enables you to integrate Highrise CRM into workflows built using Microsoft Power Automate Desktop.
-
Visualize Zuora Data in TIBCO Spotfire through OData
Integrate Zuora into dashboards in TIBCO Spotfire.
-
Connect and Visualize Live Avalara AvaTax Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Avalara AvaTax into the Databricks platform and create visualization dashboards with real-time Avalara AvaTax.
-
Choosing the Best Method to Connect Pipeline CRM to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Pipeline CRM from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Connect to Intercom Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Intercom and work with Intercom in your FileMaker applications.
-
Excel Spreadsheet Automation on PhantomBuster Data with the QUERY Formula
Pull data from PhantomBuster, automate spreadsheets, and more with the QUERY formula.
-
Automated Continuous Snapchat Ads Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Snapchat Ads replication to OneLake in Microsoft Fabric.
-
Build Pipelines with Live Jira Assets Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Jira Assets from Google Cloud Data Fusion, enabling the integration of live Jira Assets into the building and management of effective data pipelines.
-
Import Active Directory Data Using Azure Data Factory
Use CData Connect AI to connect to Active Directory Data from Azure Data Factory and import live Active Directory.
-
Automated Continuous Wave Financial Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Wave Financial replication to Amazon S3.
-
Automate Keap Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Keap from PowerShell? This article demonstrates how to utilize the Keap Cmdlets for tasks like connecting to Keap, automating operations, downloading data, and more.
-
Automated Continuous ConstantContact Replication to MySQL
Use CData Sync for automated, continuous, customizable ConstantContact replication to MySQL.
-
Integrate Live Neo4J Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf
-
Automate Tasks in Power Automate Using the CData API Server
Automate Sage Cloud Accounting actions in Microsoft Flow — sending emails, posting to social media, or syncing CRM and ERP.
-
How to Import Data from Microsoft Teams into Google Sheets
Import Microsoft Teams into a Google spreadsheet that is automatically refreshed.
-
Visualize Salesforce Data in TIBCO Spotfire through OData
Integrate Salesforce & Force.com into dashboards in TIBCO Spotfire.
-
Build a Singer.io Tap for Paylocity With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Paylocity data using
-
Integrate Real-Time Access to AlloyDB in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Google AlloyDB in real time.
-
How to Visualize Gong Data in Python with pandas
Use pandas and other modules to analyze and visualize live Gong in Python.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed Microsoft Excel Online to Power BI dashboards. Simply drag and drop Microsoft Excel Online into data visuals on the Power BI canvas.
-
DataBind Postmark Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Postmark to a chart.
-
How to connect SharePoint with Sage 300 Data through external lists
Provide Sage 300 to SharePoint users as an external list.
-
Bridge ZendeskSell Connectivity with Apache NiFi
Access and process ZendeskSell in Apache NiFi using the CData JDBC Driver.
-
Import Exact Online Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Exact Online. In this article, you will use the OData format to import Exact Online into Microsoft Power Query.
-
How to connect PolyBase to Couchbase
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Couchbase.
-
Replicate SingleStore Data from PowerShell
Write a quick PowerShell script to query SingleStore. Use connectivity to the live data to replicate SingleStore to SQL Server.
-
Automated Continuous Figshare Replication to Vertica
Use CData Sync for automated, continuous, customizable Figshare replication to Vertica.
-
Connect to Todoist Data in Jaspersoft Studio
Execute SQL to remote Todoist in Jaspersoft Studio.
-
Use the CData API Server to Access YouTube Analytics Data in Microsoft PowerPivot
Use the CData API Server to connect to live YouTube Analytics in the Power Pivot business intelligence tool.
-
Stream Guru Data into Apache Kafka Topics
Access and stream Guru in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
How to Connect to Live FreshBooks 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 FreshBooks for you.
-
DataBind Charts to ZohoInvoice Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to ZohoInvoice 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.
-
Publish Reports with Mocean Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Mocean.
-
SharePoint Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Microsoft SharePoint through CData Connect AI using different applications and tools.
-
Build Oracle HCM Cloud-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData MCP Server for Oracle HCM Cloud to explore live Oracle HCM Cloud Data in GitHub Copilot to assist with building Oracle HCM Cloud-powered applications.
-
Build Google Drive-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData MCP Server for Google Drive to explore live Google Drive Data in GitHub Copilot to assist with building Google Drive-powered applications.
-
Build Hive-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Hive Data from Zoho Analytics and import live Apache Hive.
-
Use Azure AI Foundry to Talk to Your Elasticsearch Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Azure AI Foundry agents to securely answer questions and take actions on your Elasticsearch for you.
-
How to Connect DBeaver to Printify via a JDBC Driver
Manage Printify with visual tools in DBeaver like the query browser.
-
Extract, Transform, and Load Campaigner Data in Informatica PowerCenter
Create a simple Workflow for Campaigner in Informatica PowerCenter.
-
Integrate Live Gmail Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Gmail and integrate live Gmail into apps built in Microsoft Power Apps.
-
Work with Pushbullet Data in FoxPro
Load Pushbullet into a FoxPro database. This article includes full code and a walk-through of the process.
-
How to connect to Coinbase Data from Spring Boot
Connect to Coinbase in a Spring Boot Application using the CData API Driver for JDBC
-
Automated Continuous Mouseflow Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Mouseflow replication to PostgreSQL.
-
Moving Data from LaunchDarkly to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live LaunchDarkly data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Provide OData Services of Presto Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Presto by developing a WCF Service Application.
-
Use the CData Software ODBC Driver for Keap in MicroStrategy Desktop
Connect to Keap in MicroStrategy Desktop using the CData Software ODBC Driver for Keap.
-
Build MVC Applications with Connectivity to Productboard Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Productboard from an ASP.NET MVC application.
-
Create Informatica Mappings From/To a JDBC Data Source for LinkedIn Ads
Create LinkedIn Ads data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Connect to Salesforce Pardot Data in DBArtisan
Use wizards in DBArtisan to configure Salesforce Pardot as a data source.
-
Connect Coinbase to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Coinbase using the CData Python MCP Server.
-
Work with LaunchDarkly Data in FoxPro
Load LaunchDarkly into a FoxPro database. This article includes full code and a walk-through of the process.
-
Use the CData Software JDBC Driver for Redshift in MicroStrategy Desktop
Connect to Amazon Redshift in MicroStrategy Desktop using the CData Software JDBC Driver for Redshift.
-
How to load Pipeliner CRM data into Elasticsearch via Logstash
Introducing a simple method to load Pipeliner CRM data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Use Biml to Build SSIS Tasks to Replicate Google Contacts Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Google Contacts to SQL Server.
-
Work with Azure Analysis Services Data in FoxPro
Load Azure Analysis Services into a FoxPro database. This article includes full code and a walk-through of the process.
-
Automated Continuous Helpscout Replication to SQLite
Use CData Sync for automated, continuous, customizable Helpscout replication to SQLite.
-
Create Reports with Freshteam Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Freshteam.
-
Build a Singer.io Tap for Insightly With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Insightly data using
-
Building Dynamic Web Pages with MySQL Data Using AngularJS
Create single-page applications with live connectivity to MySQL using the CData API Server.
-
LINQ to Google Cloud Storage 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 Google Cloud Storage Data Provider.