CData Software - Knowledge Base
Recent Articles
-
How to Connect to & Open Avro Data in Microsoft Excel
This article uses the CData ODBC driver for Avro to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Build Charts with Cosmos DB Data in Clear Analytics
Create dynamic charts and perform analytics based on Cosmos DB data in Clear Analytics.
-
Create Bitly-Connected Applications in Appsmith
Connect to Bitly Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Bitly data.
-
Publish FreshBooks-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live FreshBooks data.
-
Build Data Flows from Dropbox to SQL Server using SSIS
Easily back up Dropbox data to SQL Server using the SSIS components for Dropbox.
-
Connect to Coinbase Data from a Connection Pool in JBoss
Integrate Coinbase data into Java servlets: Use the Management Console in JBoss to install the Coinbase JDBC Driver.
-
Query CircleCI Data through ODBC in Node.js
Use node-odbc to execute SQL queries against CircleCI data from Node.js.
-
Use Dash to Build to Web Apps on Salesforce Pardot Data
Create Python applications that use pandas and Dash to build Salesforce Pardot-connected web apps.
-
How to Work with Wave Financial Data in ETL Validator JDBC
Connect to Wave Financial from ETL Validator jobs using the CData Software JDBC Driver.
-
Automated Continuous Phoenix Replication to SingleStore
Use CData Sync for automated, continuous, customizable Phoenix replication to SingleStore.
-
Use the CData Software JDBC Driver for Flowlu in MicroStrategy Web
Connect to Flowlu data in MicroStrategy Web using the CData Software JDBC Driver for Flowlu.
-
Automated Continuous CapsuleCRM Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable CapsuleCRM replication to Google Cloud SQL.
-
Connect to Keap Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to Keap.
-
Use Grok to Talk to Your TaxJar Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Grok AI to securely answer questions and take actions on your TaxJar data for you.
-
LINQ to Snapchat Ads 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 Snapchat Ads Data Provider.
-
Getting Started with the CData JDBC Driver for HelloSign
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for HelloSign.
-
Query, Visualize, and Share live SparkPost Data in Redash
Use CData Connect AI to connect to live SparkPost data in Redash for querying, visualizing, and sharing.
-
Build Google Forms-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Google Forms data.
-
Use ChatGPT to Talk to Your GitHub 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 GitHub data for you.
-
Migrating data from Microsoft OneDrive to Google BigQuery using CData SSIS Components.
Easily push Microsoft OneDrive data to Google BigQuery using the CData SSIS Tasks for Microsoft OneDrive and Google BigQuery.
-
Access Live Kafka Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Kafka data from your Google Sheets.
-
Bridge Webex Connectivity with Apache NiFi
Access and process Webex data in Apache NiFi using the CData JDBC Driver.
-
Access Live Spark 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 Spark data through MCP integration.
-
Build MVC Applications with Connectivity to Snapchat Ads Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Snapchat Ads from an ASP.NET MVC application.
-
Visualize Box Data in TIBCO Spotfire through OData
Integrate Box data into dashboards in TIBCO Spotfire.
-
Create a Data Access Object for Cloudflare Data using JDBI
A brief overview of creating a SQL Object API for Cloudflare data in JDBI.
-
Integrating Antigravity CLI with SendGrid data via CData CLI
Connect SendGrid data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Provide OData Services of MailerLite Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for MailerLite data by developing a WCF Service Application.
-
Build AI/ML Models with Live Landbot Data using Dataiku
Connect Landbot Data with Dataiku using the CData API Driver for JDBC.
-
Build Agents in Relevance AI with Access to Live Wistia Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Wistia data within intelligent agent workflows.
-
How to Connect to Live Amazon DynamoDB 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 Amazon DynamoDB data for you.
-
Publish Reports with Templated Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Templated data.
-
Integrate Shortcut with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Shortcut with External Services.
-
How to create an RPA flow for Moosend Data in UiPath Studio
Use the Moosend ODBC Driver to create workflows that access real-time Moosend data without any coding.
-
Access Live Pinecone Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Pinecone data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Extract, Transform, and Load Yelp Data in Informatica PowerCenter
Create a simple Workflow for Yelp data in Informatica PowerCenter.
-
Choosing the Best Method to Connect Google Analytics to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Google Analytics data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Build SAP Ariba Source-Connected Apps in Choreo
Use CData Connect AI to connect to SAP Ariba Source Data from Choreo and build custom apps using live SAP Ariba Source data.
-
Integrating Claude Code with eBay Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on eBay data within assisted coding and automated development workflows.
-
Connect to Apify Data from a Connection Pool in Jetty
The Apify JDBC Driver supports connection pooling: This article shows how to connect faster to Apify data from Web apps in Jetty.
-
Automated HCL Domino Data Replication to Teradata
Use CData Sync to Customize and automate HCL Domino data replication to Teradata.
-
Replicate Authorize.Net Data in Heroku for Use in Salesforce Connect
Replicate Authorize.Net data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Automate Marketo Data Replication to SAP HANA
Use CData Sync to customize and automate Marketo data replication to SAP HANA.
-
Connect to Mouseflow Data in CloverDX (formerly CloverETL)
Transfer Mouseflow data using the visual workflow in the CloverDX data integration tool.
-
Build Dotmailer-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Dotmailer data.
-
Build LinkedIn Visualizations in Tableau Cloud
Use CData Connect AI to connect to live LinkedIn data and build visualizations in Tableau Cloud.
-
How to Query Live Accelo Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Accelo data data in natural language using Python.
-
Process & Analyze LDAP Objects in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live LDAP Objects.
-
How to Connect the Power BI Service to GitHub: Complete Guide
Connect to the CData Software Power BI Connector for GitHub from PowerBI.com to provide real-time GitHub data across the organization.
-
Connect to PayPal Data from PowerBuilder via ADO.NET
This article demonstrates how to access PayPal data from Appeon PowerBuilder using the CData ADO.NET Provider for PayPal.
-
Excel Spreadsheet Automation on Access Data with the QUERY Formula
Pull data from Access, automate spreadsheets, and more with the QUERY formula.
-
Integrate Harvest Data in the Pentaho Report Designer
Publish reports based on Harvest data in the Pentaho BI tool.
-
Connect to Microsoft OneDrive Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Microsoft OneDrive data.
-
Rapidly Develop Helpscout-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 Helpscout.
-
Connect to Real-Time Coda Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Coda data in Power Apps.
-
Integrating OpenCode with Sage 300 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.
-
Model SuiteCRM Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and SuiteCRM, enabling the direct import of real-time SuiteCRM data.
-
Query BigCommerce Data in ColdFusion
Write standard ColdFusion data access code to connect to BigCommerce data.
-
Load Teamwork Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Teamwork data to a database.
-
Connect to OnePageCrm Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for OnePageCrm and the SQL Gateway to access OnePageCrm data from Google Apps Script.
-
Connect to Blackbaud FE NXT Data from PowerBuilder via ADO.NET
This article demonstrates how to access Blackbaud FE NXT data from Appeon PowerBuilder using the CData ADO.NET Provider for Blackbaud FE NXT.
-
How to Connect to Live Sybase IQ 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 Sybase IQ data for you.
-
Bridge Mailjet Connectivity with Apache NiFi
Access and process Mailjet data in Apache NiFi using the CData JDBC Driver.
-
Work with WordPress Data in FoxPro
Load WordPress data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Create Informatica Mappings From/To an ODBC Data Source for Close
Create an ODBC connection to Close in Informatica and browse and transfer Close data.
-
Interact with Live Jumpseller Data in Meta Muse via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Muse to securely interact with live Jumpseller data.
-
Build Voice Agents in ElevenLabs with access to Live Greenhouse Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Greenhouse data.
-
Automate Twilio Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Twilio data from PowerShell? This article demonstrates how to utilize the Twilio Cmdlets for tasks like connecting to Twilio data, automating operations, downloading data, and more.
-
Getting Started with the CData Connect AI Python SDK for Square
Install the CData Connect AI Python SDK to read and write live Square data with standard DB-API 2.0 Python code.
-
Consume HCL Domino OData Feeds in SAP Lumira
Use the API Server to create data visualizations on HCL Domino feeds that reflect any changes in SAP Lumira.
-
Access RSS Feeds 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 RSS feeds.
-
Access Toggl Data from MySQL in Amazon QuickSight
Connect to Toggl and build visualizations of Toggl data using a MySQL Connection in Amazon QuickSight.
-
Connecting Moonlit Workflow with EnterpriseDB Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Moonlit workflows to securely read and act on your EnterpriseDB data in real time.
-
View Reports on Real-Time Trello Data in Power BI Report Server
Use the CData ODBC Driver for Trello to visualize Trello data in Power BI Desktop and then publish them to Power BI Report Server.
-
Query Paylocity Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Paylocity entities in PHP by modeling them as objects.
-
Connect to and Query SingleStore Data in QlikView over ODBC
Create data visualizations with SingleStore data in QlikView.
-
Import Real-Time Greenhouse Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Greenhouse data in ColdFusion.
-
How to Work with Google Analytics Data in ETL Validator JDBC
Connect to Google Analytics from ETL Validator jobs using the CData Software JDBC Driver.
-
Connect to SAP Fieldglass Data as an External Source in Dremio
Use the CData JDBC Driver to connect to SAP Fieldglass as an External Source in Dremio.
-
Connect to Splunk from Asprova with CData Software ODBC Driver for Splunk
This article shows how to connect faster to Splunk data from Asprova.
-
Build Semantic Layer Views for Stripe Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Stripe data.
-
Integrate Trae with Live Shortcut Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Trae to securely access and query live Shortcut data from within the AI-powered IDE.
-
Replicate Multiple Google Search Accounts via the CData Sync CLI
Replicate multiple Google Search accounts to one or many databases.
-
Integrate Google Sheets with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Google Sheets with External Services.
-
Automate Drip Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Drip data from PowerShell? This article demonstrates how to utilize the Drip Cmdlets for tasks like connecting to Drip data, automating operations, downloading data, and more.
-
Viewing OpenWeatherMap Data in RAD Studio Data Explorer
How to view OpenWeatherMap data in RAD Studio Data Explorer using the CData ODBC Driver for OpenWeatherMap.
-
Visualize Live QuickBooks Time Data in the Power BI Service
Use CData Connect AI to connect to live QuickBooks Time data and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Integrate Live Toggl Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf's Cascade agent to securely access and query live Toggl data from within the IDE.
-
Connect to and Visualize Live ActiveCampaign Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live ActiveCampaign data.
-
How to integrate ChartMogul with Apache Airflow
Access and process ChartMogul data in Apache Airflow using the CData JDBC Driver.
-
Connect Shippo to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Shippo data using the CData Python MCP Server.
-
Integrate Dynamics CRM with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Dynamics CRM with External Services.
-
Integrate Stack Exchange with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Stack Exchange with External Services.
-
How to integrate Mailgun with Apache Airflow
Access and process Mailgun data in Apache Airflow using the CData JDBC Driver.
-
Integrate Shopify Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Shopify data and integrate live Shopify data into your Power Automate tasks.
-
Connect to Google Analytics 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 Google Analytics data.
-
Integrate Trae with Live Amazon Athena Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Trae to securely access and query live Amazon Athena data from within the AI-powered IDE.
-
Connect to PayPal Data in JRuby
Create a simple JRuby app with access to live PayPal data.
-
LINQ to Cvent 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 Cvent Data Provider.
-
Natively Connect to Xero Data in PHP
The CData ODBC driver for Xero enables you to create PHP applications with connectivity to Xero data. Leverage the native support for ODBC in PHP.