CData Software - Knowledge Base
Recent Articles
-
Excel Spreadsheet Automation on Perigon Data with the QUERY Formula
Pull data from Perigon, automate spreadsheets, and more with the QUERY formula.
-
Query Square Data from Node.js
Use the OData endpoint of the CData API Server to connect to your Square and perform CRUD operations on Square from Node.js.
-
Automated Continuous Zoho Creator Replication to MongoDB
Use CData Sync for automated, continuous, customizable Zoho Creator replication to MongoDB.
-
How to use SQLAlchemy ORM to access Bannerbear Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Bannerbear.
-
Automated Continuous Chargebee Replication to Oracle
Use CData Sync for automated, continuous, customizable Chargebee replication to Oracle.
-
Provide OData Services of Apify Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Apify by developing a WCF Service Application.
-
How to connect to Telegram Data in DBVisualizer
Integrate Telegram with visual data analysis tools and data connection wizards in DBVisualizer
-
Use the CData Software JDBC Driver for Demio in MicroStrategy Desktop
Connect to Demio in MicroStrategy Desktop using the CData Software JDBC Driver for Demio.
-
Connect to Google Directory Data from HeidiSQL
Use CData Connect AI to connect to and query live Google Directory from HeidiSQL.
-
Build Oracle Financials Cloud-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Oracle Financials Cloud.
-
How to Access Live Vault CRM Data in Visual Studio Code via Cline
Run CData MCP Server for Vault CRM on Windows Subsytem for Linux (WSL) and connect to live Veeva Vault & Vault CRM from the Cline extension in Visual Studio Code.
-
How to Query Live Oracle Financials Cloud Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Oracle Financials Cloud data in natural language using Python.
-
Connect to DocuSign Data in HULFT Integrate
Connect to DocuSign as a JDBC data source in HULFT Integrate
-
Create Informatica Mappings From/To a JDBC Data Source for Mode
Create Mode data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
How to Access Live Hacker News Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Hacker News enables you to integrate Hacker News into workflows built using Microsoft Power Automate Desktop.
-
Work with Live Google Search Results in Power Query
Use CData Connect AI to connect to Google Search and work with live Google Search in Microsoft Power Query.
-
Replicate Office 365 Data from PowerShell
Write a quick PowerShell script to query Microsoft Office 365. Use connectivity to the live data to replicate Microsoft Office 365 to SQL Server.
-
How to Connect Klaviyo Data to Gemini Enterprise via CData Connect AI
Connect CData Connect AI Remote MCP to Gemini Enterprise to securely read and take actions on live Klaviyo data in real time using natural language.
-
Migrating data from Insightly to Databricks using CData SSIS Components.
Easily push Insightly to Databricks using the CData SSIS Tasks for Insightly and Databricks.
-
Feed Microsoft Teams Data into FineReport
How to set Microsoft Teams as a JDBC data source in FineReport.
-
Installation Guide: CData MCP Server
Learn how to install CData MCP Server and use it for AI-assisted code generation in Cursor.
-
Create Act-On-Connected Dashboards in Grafana
Connect to Act-On Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Act-On.
-
Automate Avro Data Replication to Couchbase
Use CData Sync to Customize and automate Apache Avro replication to Couchbase.
-
How to Connect the Power BI Service to Marketo: Complete Guide
Connect to the CData Software Power BI Connector for Marketo from PowerBI.com to provide real-time Marketo across the organization.
-
Process & Analyze ActiveCampaign Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live ActiveCampaign Data.
-
Connect to Live Sugar CRM Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Sugar CRM in CData Connect AI and connect to your Sugar CRM from PostgreSQL.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed Salesforce Marketing Cloud to Power BI dashboards. Simply drag and drop Salesforce Marketing Cloud into data visuals on the Power BI canvas.
-
Integrating Claude Code CLI with Pinterest 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 to TaxJar Data in DBVisualizer
Integrate TaxJar with visual data analysis tools and data connection wizards in DBVisualizer
-
Excel Spreadsheet Automation on Harvest Data with the QUERY Formula
Pull data from Harvest, automate spreadsheets, and more with the QUERY formula.
-
Integrating Cursor CLI with Unbounce 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.
-
Build Visualizations of Campaigner Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Campaigner in Birst.
-
Extract, Transform, and Load LightSpeedRetail Data in Informatica PowerCenter
Create a simple Workflow for LightSpeedRetail in Informatica PowerCenter.
-
Connect to Act-On Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Act-On using standard SQL.
-
How to Query Live Bugsnag Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Bugsnag data in natural language using Python.
-
How to Query Live Facebook Ads Data in Perplexity MacOS Desktop
Connect to and query live Facebook Ads Data in Perplexity Desktop using CData MCP Server.
-
DataBind Charts to Phoenix Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Apache Phoenix 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 Informatica Mappings From/To an ODBC Data Source for Rebilly
Create an ODBC connection to Rebilly in Informatica and browse and transfer Rebilly.
-
Access Live Greenplum Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Pivotal GreenPlum in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Import GraphQL Data Using Azure Data Factory
Use CData Connect AI to connect to GraphQL Data from Azure Data Factory and import live GraphQL.
-
Connect and Query Live Sybase Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Sybase into Databricks
-
Use Grok to Talk to Your Odoo 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 Odoo ERP for you.
-
Prepare, Blend, and Analyze Adobe Commerce Data in Alteryx Designer (ODBC)
Build workflows to access live Adobe Commerce for self-service data analytics.
-
How to Access Live Quickbase Data in Visual Studio Code via Cline
Run CData MCP Server for Quickbase on Windows Subsytem for Linux (WSL) and connect to live Quickbase from the Cline extension in Visual Studio Code.
-
Build Avalara AvaTax-Connected Apps in Choreo
Use CData Connect AI to connect to Avalara AvaTax Data from Choreo and build custom apps using live Avalara AvaTax.
-
Integrating Antigravity CLI with Wave Financial via CData CLI
Connect Wave Financial to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Connect to JDBC-ODBC Bridge Data as an External Source in Dremio
Use the CData JDBC Driver to connect to JDBC-ODBC Bridge as an External Source in Dremio.
-
Build MVC Applications with Connectivity to Lakebase Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Lakebase from an ASP.NET MVC application.
-
Extend Google Sheets with PayPal Data
Make calls to PayPal from Google Apps Script via the API Server.
-
Create Apps from Salesforce Data in Qlik Sense Cloud
Use CData Connect AI to connect to Salesforce Data and build apps from live Salesforce & Force.com in Qlik Sense Cloud.
-
Automated Continuous ZohoExpense Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable ZohoExpense replication to Google Cloud SQL.
-
Use Dash to Build Web Apps on Google Ad Manager Data via CData Connect AI
Build interactive Dash web apps on live Google Ad Manager using pandas and the CData Connect AI Python SDK.
-
Connect to Missive Data in NetBeans
Connect to Missive in NetBeans with the data source configuration wizard.
-
Import Real-Time SAP Business One Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use SAP Business One in ColdFusion.
-
Automated Continuous Presto Replication to Oracle
Use CData Sync for automated, continuous, customizable Presto replication to Oracle.
-
Integrating Claude Code with Jira Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Atlassian Jira within assisted coding and automated development workflows.
-
Automate Google Directory Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live Google Directory and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
Build Voice Agents in ElevenLabs with access to Live Office 365 Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Microsoft Office 365.
-
Enable the Intercom JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Intercom.
-
Integrating Cursor CLI with Telegram 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 FHIR Data as an External Source in Dremio
Use the CData JDBC Driver to connect to FHIR as an External Source in Dremio.
-
Automated Continuous ZendeskSell Replication to SQLite
Use CData Sync for automated, continuous, customizable ZendeskSell replication to SQLite.
-
Choosing the Best Method to Connect Act-On to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Act-On from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Use the CData Software ODBC Driver for SpaceX in MicroStrategy Web
Connect to SpaceX in MicroStrategy Web using the CData Software ODBC Driver for SpaceX.
-
How to import xBase Data into Apache Solr
Use the CData Software JDBC Driver for xBase in Data Import Handler and create an automated import of xBase to Apache Solr Enterprise Search platform.
-
How to Connect DBeaver to Teradata via a JDBC Driver
Manage Teradata with visual tools in DBeaver like the query browser.
-
Automated Continuous Sage Intacct Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Sage Intacct replication to delimited files (CSV/TSV).
-
Connect to Zoho Recruit Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Zoho Recruit using standard SQL.
-
How to Connect DBeaver to GraphQL via a JDBC Driver
Manage GraphQL with visual tools in DBeaver like the query browser.
-
Connect to FreeAgent Data in Jaspersoft Studio
Execute SQL to remote FreeAgent in Jaspersoft Studio.
-
Import and Visualize Adobe Analytics Data in Power View
Create data visualizations based on Adobe Analytics in Excel.
-
Migrating data from Hugging Face to Databricks using CData SSIS Components.
Easily push Hugging Face to Databricks using the CData SSIS Tasks for Hugging Face and Databricks.
-
Feed Oracle Data into FineReport
How to set Oracle Database as a JDBC data source in FineReport.
-
Analyze Autopilot Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Autopilot from Power Pivot. You will use the Table Import Wizard to load Autopilot. You can visually build the import query or use any SQL supported by the driver.
-
Integrating Codex CLI with CampaignMonitor 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 Keap Data in Ruby
Connect to Keap in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Perform Batch Operations with Google Campaign Manager 360 Data in Apache NiFi
Connect to Google Campaign Manager 360 and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Automated Continuous Bugsnag Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Bugsnag replication to IBM DB2.
-
Migrating data from Telegram to Databricks using CData SSIS Components.
Easily push Telegram to Databricks using the CData SSIS Tasks for Telegram and Databricks.
-
Access Live Highrise Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Highrise CRM from your Excel spreadsheets.
-
How to Connect Flowise AI Agents to Live Microsoft Exchange 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 Microsoft Exchange without replication.
-
Use Biml to Build SSIS Tasks to Replicate Reckon Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Reckon to SQL Server.
-
Use the CData API Server to Access Spark Data in Microsoft PowerPivot
Use the CData API Server to connect to live Apache Spark SQL in the Power Pivot business intelligence tool.
-
How to connect to Samanage Data from Spring Boot
Connect to Samanage in a Spring Boot Application using the CData API Driver for JDBC
-
Integrating GitHub Copilot CLI with OnePageCrm 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 Semantic Layer Views for Amazon S3 Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Amazon S3.
-
How to Visualize Strava Data in Python with pandas
Use pandas and other modules to analyze and visualize live Strava in Python.
-
Connect to MessageBird Data from PowerBuilder via ADO.NET
This article demonstrates how to access MessageBird from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Visualize Live Brex Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Brex.
-
Connect to OData Services as an External Source in Dremio
Use the CData JDBC Driver to connect to OData as an External Source in Dremio.
-
Manage Google Sheets Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Google Sheets.
-
How to Connect to Live Avro 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 Apache Avro for you.
-
Extract, Transform, and Load Opsgenie Data in Informatica PowerCenter
Create a simple Workflow for Opsgenie in Informatica PowerCenter.
-
Integrating Codex CLI with Helpscout 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 Dashboards with Omnisend Data in DBxtra
Create dynamic dashboards and perform analytics based on Omnisend in DBxtra.
-
Connect to Spark Data from a Connection Pool in JBoss
Integrate Apache Spark SQL into Java servlets: Use the Management Console in JBoss to install the Spark JDBC Driver.
-
Connect Google Analytics to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Google Analytics with IBM WebSphere for seamless data integration and connectivity.
-
Build Apps with Live Wrike Data Using the Low-Code Development Platform of Mendix
Connect Wrike with Mendix to build apps using the CData API Driver for JDBC.
-
Object-Relational Mapping (ORM) with Factorial 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 Factorial into a Java-based ORM framework, Hibernate.
-
Analyze Procore Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Procore and visualize Procore in SAP Analytics Cloud.