CData Software - Knowledge Base
Recent Articles
-
Create Informatica Mappings From/To a JDBC Data Source for Act-On
Create Act-On data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
LINQ to ChargeOver 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 ChargeOver Data Provider.
-
Build Pipelines with Live Freshservice Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Freshservice from Google Cloud Data Fusion, enabling the integration of live Freshservice into the building and management of effective data pipelines.
-
Working with Workday Data in LINQPad
Execute LINQ queries to Workday in LINQPad.
-
Automated Continuous ActiveCampaign Replication to Amazon S3
Use CData Sync for automated, continuous, customizable ActiveCampaign replication to Amazon S3.
-
Automated Continuous Paymo Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Paymo replication to AlloyDB.
-
Using the CData Software ODBC Driver for ElevenLabs in PyCharm
Connect to ElevenLabs as an ODBC data source in PyCharm using the CData Software ODBC Driver for ElevenLabs.
-
Access Notion Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Notion from HeidiSQL.
-
How to create Visio diagrams from Odoo Data
Automatically update Odoo ERP with the changes you make to Visio master shapes.
-
Access Live Microsoft Exchange Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Microsoft Exchange from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Use the CData Software ODBC Driver for Google Cloud Storage in MicroStrategy Web
Connect to Google Cloud Storage in MicroStrategy Web using the CData Software ODBC Driver for Google Cloud Storage.
-
How to Connect to Live Gong Data from crewAI Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable crewAI agents to securely read and take actions on your Gong for you.
-
How to Connect to Simplesat Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Simplesat. Leverage the pyodbc module for ODBC in Python.
-
Integrating GitHub Copilot CLI with ChargeOver 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 Kafka-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Apache Kafka.
-
Deploy the ADO.NET Provider for Google Campaign Manager 360 on an SSRS Report Server
Connect to Google Campaign Manager 360 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.
-
Feed SAP ByDesign Data into FineReport
How to set SAP Business ByDesign as a JDBC data source in FineReport.
-
How to Query Live Postmark Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Postmark data in natural language using Python.
-
Connect to Access Data from a Connection Pool in JBoss
Integrate Microsoft Access into Java servlets: Use the Management Console in JBoss to install the Access JDBC Driver.
-
Create Data Visualizations in Cognos BI with Delighted Data
Access Delighted as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Automated FormSite Data Replication to Teradata
Use CData Sync to Customize and automate FormSite replication to Teradata.
-
Access Live Email Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Email in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Integrate with Anaplan Data in JReport Designer
Create charts and reports based on Anaplan in JReport Designer.
-
Access Airtable 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 Airtable.
-
Use CData Connect AI to Access Greenhouse Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Greenhouse in the Power Pivot business intelligence tool.
-
Access Live YouTube Analytics Data in AWS Lambda
Connect to live YouTube Analytics in AWS Lambda using the CData JDBC Driver.
-
Automated Continuous Recurly Replication to Databricks
Use CData Sync for automated, continuous, customizable Recurly replication to Databricks.
-
Connect to ScrapingBee Data in RapidMiner
Integrate ScrapingBee with standard components and data source configuration wizards in RapidMiner Studio.
-
Build Automated Confluence-Connected Workflows in Zapier
Use CData Connect AI to connect to live Atlassian Confluence and build automated workflows in Zapier.
-
Bind Live AlloyDB Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live AlloyDB data
-
Use the CData Software ODBC Driver for Strava in SAS for Real-Time Reporting and Analytics
Connect to real-time Strava in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Strava.
-
Access Live Instagram Data in Roo Code via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Roo Code agents to securely access and build applications with live Instagram through MCP integration.
-
Connect to Paylocity Data from a Connection Pool in JBoss
Integrate Paylocity into Java servlets: Use the Management Console in JBoss to install the Paylocity JDBC Driver.
-
Build Bullhorn CRM-Powered Applications in Gemini Code Assist with CData MCP Server
Use the CData MCP Server for Bullhorn CRM to explore live Bullhorn CRM Data in Gemini Code Assist to assist with building Bullhorn CRM-powered applications.
-
How to Connect to & Open Coinbase Data in Microsoft Excel
This article uses the CData ODBC driver for Coinbase to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Visualize Live Bugsnag Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Bugsnag.
-
Load PingOne Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load PingOne to a database.
-
Create Dynamics CRM-Connected Business Apps in AppSheet
Connect to Dynamics CRM Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Microsoft Dynamics CRM.
-
Build LinkedIn Ads-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live LinkedIn Ads.
-
Create Informatica Mappings From/To an ODBC Data Source for Aweber
Create an ODBC connection to Aweber in Informatica and browse and transfer Aweber.
-
Create Salesloft Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Salesloft from PowerBI.com to create Power BI Dataflows with real-time data.
-
Build a Singer.io Tap for Mode With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Mode data using
-
Rapidly Develop Hacker News-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 Hacker News.
-
Replicate Discourse Data from PowerShell
Write a quick PowerShell script to query Discourse. Use connectivity to the live data to replicate Discourse to SQL Server.
-
Create Power BI Reports on Real-Time EmailOctopus Data
Use the CData ODBC Driver for EmailOctopus to visualize EmailOctopus in Power BI Desktop.
-
Getting Started with the CData Power BI Connector for Browserless
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Connect and Visualize Live Asana Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Asana into the Databricks platform and create visualization dashboards with real-time Asana.
-
Getting Started with the CData Python Connector for SingleStore
Learn to install and license the CData Python Connector
-
Validate CloudConvert Data with QuerySurge
Access and validate CloudConvert in QuerySurge using the CData JDBC Driver.
-
Connect to Customer.io Data in CloverDX (formerly CloverETL)
Transfer Customer.io using the visual workflow in the CloverDX data integration tool.
-
Query Sybase IQ Data in ColdFusion
Write standard ColdFusion data access code to connect to Sybase IQ.
-
Build Apps with Live BambooHR Data Using the Low-Code Development Platform of Mendix
Connect BambooHR with Mendix to build apps using the CData API Driver for JDBC.
-
Replicate Multiple DB2 for i Accounts
Replicate multiple DB2 for i accounts to one or many databases.
-
Automated Continuous Shippo Replication to SQL Server
Use CData Sync for automated, continuous, customizable Shippo replication to SQL Server.
-
Connect to JSON Services from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time JSON using standard SQL.
-
Connect to Quaderno Data in Jaspersoft Studio
Execute SQL to remote Quaderno in Jaspersoft Studio.
-
Use the CData Software JDBC Driver for ClickUp in MicroStrategy Desktop
Connect to ClickUp in MicroStrategy Desktop using the CData Software JDBC Driver for ClickUp.
-
Connect to and Query Instagram Data in QlikView over ODBC
Create data visualizations with Instagram in QlikView.
-
Process & Analyze ZohoDesk Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live ZohoDesk Data.
-
How to Connect to PDFMonkey Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to PDFMonkey. Leverage the pyodbc module for ODBC in Python.
-
How to connect to Authorize.Net Data in DBVisualizer
Integrate Authorize.Net with visual data analysis tools and data connection wizards in DBVisualizer
-
Connect to GitHub Data from PowerBuilder via JDBC
This article demonstrates how to access GitHub from PowerBuilder using the GitHub JDBC Driver.
-
Connect to Live Monday.com Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Monday.com in CData Connect AI and connect to your Monday.com from PostgreSQL.
-
Build Voice Agents in ElevenLabs with access to Live Zendesk Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Zendesk.
-
Create Power BI Reports on Real-Time Everhour Data
Use the CData ODBC Driver for Everhour to visualize Everhour in Power BI Desktop.
-
Integrate with Kintone Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Kintone to a JSON file on disk.
-
How to Work with Outreach.io Data in ETL Validator JDBC
Connect to Outreach.io from ETL Validator jobs using the CData Software JDBC Driver.
-
How to Query Live Microsoft OneDrive Data in Claude Desktop
Connect to and query live Microsoft OneDrive Data in Claude Desktop using CData MCP Server.
-
Use the CData Software ODBC Driver for BigCommerce in SAS for Real-Time Reporting and Analytics
Connect to real-time BigCommerce in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for BigCommerce.
-
How to Connect the Power BI Service to Amazon S3: Complete Guide
Connect to the CData Software Power BI Connector for Amazon S3 from PowerBI.com to provide real-time Amazon S3 across the organization.
-
ETL TaxJar in Oracle Data Integrator
This article shows how to transfer TaxJar into a data warehouse using Oracle Data Integrator.
-
Prepare, Blend, and Analyze Teradata Data in Alteryx Designer (ODBC)
Build workflows to access live Teradata for self-service data analytics.
-
Access Live SAP Netweaver Gateway Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live SAP Netweaver Gateway from your Excel spreadsheets.
-
Visualize Zuora Data in Sisense
Create an ElastiCube in Sisense app with access to Zuora.
-
Choosing the Best Method to Connect Paymo to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Paymo from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Getting Started with the CData ODBC Driver for ClickUp
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for ClickUp.
-
Write a Simple Go Application to work with Coda Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Coda.
-
Connect to Helpscout Data from a Connection Pool in JBoss
Integrate Helpscout into Java servlets: Use the Management Console in JBoss to install the Helpscout JDBC Driver.
-
Build MVC Applications with Connectivity to Mixpanel Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Mixpanel from an ASP.NET MVC application.
-
Publish Scrapfly-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Scrapfly.
-
Edit and Search Access External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of Microsoft Access to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create Access objects that you can access from apps and the dashboard.
-
How to Connect to Live Sage 200 Data from Gemini CLI (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Gemini CLI to securely read and take actions on your Sage 200 for you.
-
Build CSV-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live CSV/TSV Files and build CSV-connected web apps with Axios.
-
Connect to CouchDB Data in Jaspersoft Studio
Execute SQL to remote Apache CouchDB in Jaspersoft Studio.
-
Use Microsoft Copilot Studio to talk to your Epicor Kinetic 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 Epicor Kinetic for you.
-
Use Databricks Agent Bricks to Talk to Your Dynamics CRM Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Microsoft Dynamics CRM for you.
-
Integrate Live Sugar CRM Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Sugar CRM to Blue Prism using the CData ODBC Driver for Sugar CRM to create automated workflows for repetitive business tasks.
-
Automated Continuous Power BI XMLA Replication to Vertica
Use CData Sync for automated, continuous, customizable Power BI XMLA replication to Vertica.
-
Model, Search, and Visualize Live Workday Data in ThoughtSpot
Use CData Connect AI to connect to live Workday for modeling, searching, and visualizing.
-
Query Oracle Eloqua Data from Node.js
Use the OData endpoint of the CData API Server to connect to your Oracle Eloqua and perform CRUD operations on Oracle Eloqua from Node.js.
-
Import and Visualize HCL Domino Data in Power View
Create data visualizations based on HCL Domino in Excel.
-
Analyze ChartMogul Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for ChartMogul from Power Pivot. You will use the Table Import Wizard to load ChartMogul. You can visually build the import query or use any SQL supported by the driver.
-
Import Real-Time Bitbucket Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Bitbucket in ColdFusion.
-
DataBind ShipStation Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for ShipStation with the DevExpress Windows Forms and Web controls to provide ShipStation to a chart.
-
How to Build an ETL App for SharePoint Data in Python with CData Connect AI
Build ETL pipelines that read and write live Microsoft SharePoint in Python with petl and the CData Connect AI Python SDK.
-
How to Access Live SuiteCRM Data in Power Automate Desktop via ODBC
The CData ODBC Driver for SuiteCRM enables you to integrate SuiteCRM into workflows built using Microsoft Power Automate Desktop.
-
Visualize Live BigCommerce Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live BigCommerce using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Getting Started with the CData ADO.NET Provider for Scrapfly
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Connect to Avro Data in Claris FileMaker Pro
Use the CData ODBC Driver for Avro in FileMaker Pro to connect to Avro and work with Apache Avro in your FileMaker applications.
-
Use the CData Software ODBC Driver for Bannerbear in MicroStrategy Web
Connect to Bannerbear in MicroStrategy Web using the CData Software ODBC Driver for Bannerbear.