CData Software - Knowledge Base
Recent Articles
-
Use the CData Software ODBC Driver for SendInBlue in MicroStrategy Web
Connect to SendInBlue in MicroStrategy Web using the CData Software ODBC Driver for SendInBlue.
-
Query, Visualize, and Share live Sugar CRM Data in Redash
Use CData Connect AI to connect to live Sugar CRM in Redash for querying, visualizing, and sharing.
-
Connect to AdRoll Data as an External Source in Dremio
Use the CData JDBC Driver to connect to AdRoll as an External Source in Dremio.
-
ETL LinkedIn Ads in Oracle Data Integrator
This article shows how to transfer LinkedIn Ads into a data warehouse using Oracle Data Integrator.
-
Integrating LangChain with Sybase Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Sybase within automated workflows.
-
How to Connect to Live Sage 200 Data in Mistral AI Workflows
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live Sage 200 without replication.
-
Connect to FreshBooks Data in ACL Analytics
Connect to FreshBooks via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to FreshBooks.
-
Transfer Google Calendars to SharePoint in Talend
Access SharePoint data in Talend using the CData JDBC Driver for SharePoint.
-
Visualize SAP HANA Data in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load SAP HANA into TIBCO Spotfire.
-
Connect to Real-Time NetSuite Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for NetSuite and Dataflow to import and use NetSuite CRM & ERP in Power Apps.
-
Connect to Jumpseller from Asprova with CData Software ODBC Driver for Jumpseller
This article shows how to connect faster to Jumpseller data from Asprova.
-
Connect to Typeform Data in NetBeans
Connect to Typeform in NetBeans with the data source configuration wizard.
-
Analyze CockroachDB Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for CockroachDB from Power Pivot. You will use the Table Import Wizard to load CockroachDB. You can visually build the import query or use any SQL supported by the driver.
-
Getting Started with the CData Python Connector for ShipStation
Learn to install and license the CData Python Connector
-
How to Build an ETL App for Sage Intacct Data in Python with CData
Create ETL applications and real-time data pipelines for Sage Intacct in Python with petl.
-
Integrate Adobe Analytics Data in Pentaho Data Integration
Build ETL pipelines based on Adobe Analytics in the Pentaho Data Integration tool.
-
Missive Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Missive facts in real time.
-
Integrating Gumloop with Marketo Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Marketo within automated workflows.
-
Analyze LeadDesk Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze LeadDesk in Microsoft R Open.
-
Automated Continuous GetResponse Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable GetResponse replication to OneLake in Microsoft Fabric.
-
Automated Continuous SpaceX Replication to SQLite
Use CData Sync for automated, continuous, customizable SpaceX replication to SQLite.
-
Connect and Query Live Sage Cloud Accounting Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Sage Business Cloud Accounting into Databricks
-
Integrate Goose with Live Gong Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Gong from within the local AI agent.
-
How to Visualize Zoho Books Data in Python with pandas
Use pandas and other modules to analyze and visualize live Zoho Books in Python.
-
Publish Reckon-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Reckon.
-
Process & Analyze Calendly Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Calendly Data.
-
Automated ClickUp Data Replication to Teradata
Use CData Sync to Customize and automate ClickUp replication to Teradata.
-
Build a PostgreSQL Interface for VWO Data using the CData JDBC Driver
Use the Remoting features of the VWO JDBC Driver to create a PostgreSQL entry-point for data access.
-
Gorgias Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Gorgias facts in real time.
-
DataBind Controls to Basecamp Data in Delphi
DataBind to Basecamp in Delphi with standard data access components and controls.
-
Manage LDAP Objects in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for LDAP.
-
Query, Visualize, and Share live Dynamics 365 Data in Redash
Use CData Connect AI to connect to live Microsoft Dynamics 365 in Redash for querying, visualizing, and sharing.
-
Excel Spreadsheet Automation on Unbounce Data with the QUERY Formula
Pull data from Unbounce, automate spreadsheets, and more with the QUERY formula.
-
Build Apps with Live Miro Data Using the Low-Code Development Platform of Mendix
Connect Miro with Mendix to build apps using the CData API Driver for JDBC.
-
Connect to WooCommerce Data in RazorSQL
Connect to WooCommerce from wizards and query WooCommerce from the GUI in the RazorSQL database management tool.
-
Connect to Microsoft Ads Data from a Connection Pool in JBoss
Integrate Microsoft Ads into Java servlets: Use the Management Console in JBoss to install the Microsoft Ads JDBC Driver.
-
How to Connect to Live Azure Table 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 Azure Table Storage for you.
-
Connect to Contentful Data in CloverDX (formerly CloverETL)
Transfer Contentful using the visual workflow in the CloverDX data integration tool.
-
Use Biml to Build SSIS Tasks to Replicate Calendly Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Calendly to SQL Server.
-
Connect to Splunk Data in ACL Analytics
Connect to Splunk via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Splunk.
-
Use Azure AI Foundry to Talk to Your Sage 200 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 Sage 200 for you.
-
Easily Integrate Shippo Data in Lazarus Pascal IDE
Learn how to easily integrate live Shippo in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Object-Relational Mapping (ORM) with Stack Exchange 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 Stack Exchange into a Java-based ORM framework, Hibernate.
-
Build a Singer.io Tap for Cosmos DB With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Cosmos DB data using
-
How to load Figshare data into Elasticsearch via Logstash
Introducing a simple method to load Figshare data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Vimeo
Provide connectivity to Vimeo through an SAP BusinessObjects universe.
-
Getting Started with the CData JDBC Driver for HubSpot
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for HubSpot.
-
Analyze Toggl Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Toggl in Microsoft R Open.
-
Connect to Gmail Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Gmail using standard SQL.
-
Access Live XML Data in AWS Lambda (with IntelliJ IDEA)
Connect to live XML Files in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Bridge RSS Connectivity with Apache NiFi
Access and process RSS Feeds in Apache NiFi using the CData JDBC Driver.
-
Build a PostgreSQL Interface for Clari Data using the CData JDBC Driver
Use the Remoting features of the Clari JDBC Driver to create a PostgreSQL entry-point for data access.
-
View Reports on Real-Time Smartsheet Data in Power BI Report Server
Use the CData ODBC Driver for Smartsheet to visualize Smartsheet in Power BI Desktop and then publish them to Power BI Report Server.
-
Getting Started with the CData Power BI Connector for eBay
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for eBay.
-
Use the CData API Server to Access SuiteCRM Data in Microsoft PowerPivot
Use the CData API Server to connect to live SuiteCRM in the Power Pivot business intelligence tool.
-
Use the CData ODBC Driver for Oracle Eloqua in Microsoft Power Query
You can use the CData Oracle Eloqua ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Oracle Eloqua into Microsoft Power Query.
-
A PostgreSQL Interface for Bitbucket Data using the CData ODBC Driver
Use the SQL Gateway and Bitbucket ODBC Driver to create a PostgreSQL entry-point for data access.
-
Build Semantic Layer Views for ScrapingBee Data in APOS Live Data Gateway
Use the CData Connector for ScrapingBee in APOS Live Data Gateway to build Semantic Layer Views for ScrapingBee.
-
Build a Simple VCL Application for Miro Data
How to build a simple VCL Application to view Miro in RAD Studio using the CData ODBC Driver for Miro.
-
Use the CData Software ODBC Driver for Pipeline CRM in MicroStrategy
Connect to Pipeline CRM in MicroStrategy Developer using the CData Software ODBC Driver for Pipeline CRM.
-
Connect to Authorize.Net 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 Authorize.Net.
-
Build a Singer.io Tap for CloudConvert With the CData Python Connector
Learn how to easily build a Singer.io Tap for live CloudConvert data using
-
How to Visualize Square Data in Python with pandas
Use pandas and other modules to analyze and visualize live Square in Python.
-
Build a Simple VCL Application for OData Services
How to build a simple VCL Application to view OData in RAD Studio using the CData ODBC Driver for OData.
-
Stream Microsoft Planner Data into Apache Kafka Topics
Access and stream Microsoft Planner in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
How to connect PolyBase to Sage 300
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Sage 300.
-
Connect ZarMoney to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live ZarMoney using the CData Python MCP Server.
-
Integrate Cline with Live Freshdesk Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Freshdesk from within your IDE.
-
Automated Opsgenie Data Replication to Teradata
Use CData Sync to Customize and automate Opsgenie replication to Teradata.
-
Provide OData Services of Hive Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Apache Hive by developing a WCF Service Application.
-
Manage QuickBooks Online Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for QuickBooks Online.
-
Query MariaDB Data through ODBC in Node.js
Use node-odbc to execute SQL queries against MariaDB from Node.js.
-
Visualize FreeAgent Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to FreeAgent.
-
Analyze Cloudant Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze IBM Cloudant in Microsoft R Open.
-
Query SAP Business One Data as a SQL Server Database in Node.js
Execute SQL Server queries against SAP Business One from Node.js.
-
How to Connect to Live WooCommerce Data from Google ADK Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Google ADK agents to securely read and take actions on your WooCommerce for you.
-
How to Connect the Power BI Service to Sentry: Complete Guide
Connect to the CData Software Power BI Connector for Sentry from PowerBI.com to provide real-time Sentry across the organization.
-
How to import Discord Data into Apache Solr
Use the CData Software JDBC Driver for Discord in Data Import Handler and create an automated import of Discord to Apache Solr Enterprise Search platform.
-
Access Live Klaviyo 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 Klaviyo through MCP integration.
-
Build AI/ML Models with Live Parallel Data using Dataiku
Connect Parallel Data with Dataiku using the CData API Driver for JDBC.
-
Integrate Goose with Live Raisers Edge NXT Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Raisers Edge NXT from within the local AI agent.
-
Build MVC Applications with Connectivity to ZarMoney Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access ZarMoney from an ASP.NET MVC application.
-
Integrate Exact Online Data in the Pentaho Report Designer
Publish reports based on Exact Online in the Pentaho BI tool.
-
Access Live Zoho Books Data in Excel 365 Online (Excel for the web)
Connect to Zoho Books from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Connect to Workday Data from PowerBuilder via JDBC
This article demonstrates how to access Workday from PowerBuilder using the Workday JDBC Driver.
-
Automated Continuous NetSuite SuiteAnalytics Replication to MySQL
Use CData Sync for automated, continuous, customizable NetSuite SuiteAnalytics replication to MySQL.
-
How to Create Power BI Visual Reports with Real-Time NetSuite Data
Use CData Power BI Connectors to visualize NetSuite CRM & ERP in Power BI.
-
How to Visualize Shopify Data in Python with pandas via CData Connect AI
Use the CData Connect AI Python SDK with pandas and Matplotlib to analyze and visualize live Shopify in Python.
-
Integrate with live Avro Data in Jitterbit
Use CData Connect AI to connect to and integrate live Apache Avro in Jitterbit.
-
Import Gmail Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Gmail. In this article, you will use the OData format to import Gmail into Microsoft Power Query.
-
Connecting GenSpark with Box Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Box without any replication or custom integration required.
-
Query, Visualize, and Share live Dynamics 365 Business Central Data in Redash
Use CData Connect AI to connect to live Dynamics 365 Business Central in Redash for querying, visualizing, and sharing.
-
Query Adobe Analytics Data from Node.js
Use the OData endpoint of the CData API Server to connect to your Adobe Analytics and perform CRUD operations on Adobe Analytics from Node.js.
-
How to connect and process CockroachDB from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live CockroachDB.
-
Integrating GitHub Copilot CLI with SQL Analysis Services 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 Salesforce Pardot 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 Salesforce Pardot data in real time using natural language.
-
Connect to Real-Time Wave Financial Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Wave Financial and Dataflow to import and use Wave Financial in Power Apps.
-
Integrating GitHub Copilot CLI with Raisers Edge NXT 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.
-
Create Informatica Mappings From/To a JDBC Data Source for Autopilot
Create Autopilot data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Access FTP Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live FTP Servers from HeidiSQL.