CData Software - Knowledge Base
Recent Articles
-
Integrate Parallel Data in Pentaho Data Integration
Build ETL pipelines based on Parallel in the Pentaho Data Integration tool.
-
Connect to Salesloft from a Connection Pool in WebLogic
Use the CData JDBC Driver for Salesloft to connect to Salesloft from Web applications running on WebLogic.
-
Integrating Kiro CLI with TaxJar 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 Access FreshBooks Data Using Entity Framework
This article shows how to access FreshBooks using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Integrate with OnePageCrm Data in JReport Designer
Create charts and reports based on OnePageCrm in JReport Designer.
-
Replicate Multiple CockroachDB Accounts
Replicate multiple CockroachDB accounts to one or many databases.
-
How to Connect to Live OneNote Data from OpenAI Python Applications (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable OpenAI-powered Python applications to securely read and take actions on your Microsoft OneNote through natural language.
-
How to Build an ETL App for LinkedIn Ads Data in Python with CData
Create ETL applications and real-time data pipelines for LinkedIn Ads in Python with petl.
-
A PostgreSQL Interface for SQL Server Data using the CData ODBC Driver
Use the SQL Gateway and SQL Server ODBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to and Query Odoo Data in QlikView over ODBC
Create data visualizations with Odoo ERP in QlikView.
-
Use Microsoft Copilot Studio to talk to your BambooHR 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 BambooHR for you.
-
Create a Data Access Object for Sybase Data using JDBI
A brief overview of creating a SQL Object API for Sybase in JDBI.
-
Automate NetSuite SuiteAnalytics Data Replication to Azure Data Lake
Use CData Sync to customize and automate NetSuite SuiteAnalytics replication to Azure Data Lake.
-
How to Access Live Oracle Service Cloud Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Oracle Service Cloud enables you to integrate Oracle Service Cloud into workflows built using Microsoft Power Automate Desktop.
-
Connect to Close Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Close and the SQL Gateway to access Close from Google Apps Script.
-
Establish a Live Connection with Freshdesk Data using Tableau Bridge
The CData ODBC Driver for Freshdesk enables you to integrate live Freshdesk into Tableau Cloud dashboards using the Tableau Bridge.
-
Using the CData Software ODBC Driver for AfterShip in PyCharm
Connect to AfterShip as an ODBC data source in PyCharm using the CData Software ODBC Driver for AfterShip.
-
Viewing Xero Data in RAD Studio Data Explorer
How to view Xero Accounting in RAD Studio Data Explorer using the CData ODBC Driver for Xero.
-
Use Azure AI Foundry to Talk to Your eBay 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 eBay for you.
-
Access Coinbase Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Coinbase from HeidiSQL.
-
Build Visualizations of Azure Analysis Services Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Azure Analysis Services in Birst.
-
Automated Continuous Teamwork Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Teamwork replication to PostgreSQL.
-
Viewing Onfleet Data in RAD Studio Data Explorer
How to view Onfleet in RAD Studio Data Explorer using the CData ODBC Driver for Onfleet.
-
Build Data Flows from Spark to SQL Server using SSIS
Easily back up Apache Spark SQL to SQL Server using the SSIS components for Spark.
-
How to Seamlessly Import Dynamics 365 Business Central Data into IBM SPSS Modeler
Integrate Dynamics 365 Business Central data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Connect to OpenWeatherMap Data as an External Source in Dremio
Use the CData JDBC Driver to connect to OpenWeatherMap as an External Source in Dremio.
-
How to connect to Google Ads Data in DBVisualizer
Integrate Google Ads with visual data analysis tools and data connection wizards in DBVisualizer
-
Automated Continuous Adobe Analytics Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Adobe Analytics replication to Azure SQL Database.
-
LINQ to GraphQL 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 GraphQL Data Provider.
-
Integrating Antigravity CLI with GitHub via CData CLI
Connect GitHub to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Build a Singer.io Tap for Adobe Commerce With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Adobe Commerce data using
-
Build Data Flows from BambooHR to SQL Server using SSIS
Easily back up BambooHR to SQL Server using the SSIS components for BambooHR.
-
Automated Continuous Sage Intacct Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Sage Intacct replication to Amazon Redshift.
-
How to Build an ETL App for QuickBooks Time Data in Python with CData Connect AI
Build ETL pipelines that read and write live QuickBooks Time in Python with petl and the CData Connect AI Python SDK.
-
Explore Geographical Relationships in Beeminder Data with Power Map
Create data visualizations with Beeminder in Power Map.
-
Replicate Mailgun Data to Multiple Databases
Replicate Mailgun to disparate databases with a point-and-click configuration.
-
Integrate Goose with Live eBay Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live eBay from within the local AI agent.
-
Bridge SingleStore Connectivity with Apache NiFi
Access and process SingleStore in Apache NiFi using the CData JDBC Driver.
-
Getting Started with the CData Tableau Connector for Slack
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Slack.
-
How to Access HCL Domino Data Using Entity Framework
This article shows how to access HCL Domino using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
How to Connect DBeaver to LaunchDarkly via a JDBC Driver
Manage LaunchDarkly with visual tools in DBeaver like the query browser.
-
Automated Continuous Microsoft Exchange Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Microsoft Exchange replication to AlloyDB.
-
Create Power BI Reports on Real-Time FreeAgent Data
Use the CData ODBC Driver for FreeAgent to visualize FreeAgent in Power BI Desktop.
-
Use Microsoft Copilot Studio and Microsoft Teams to Talk to Your Data via Connect AI
Leverage the CData Connect AI Remote MCP server to enable Microsoft Teams to securely answer questions and take actions on your data for you.
-
Consume HBase OData Feeds in SAP Lumira
Use the API Server to create data visualizations on HBase feeds that reflect any changes in SAP Lumira.
-
Replicate Greenplum Data to Multiple Databases
Replicate Pivotal GreenPlum to disparate databases with a point-and-click configuration.
-
Integrating Cursor CLI with PivotalTracker 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.
-
A PostgreSQL Interface for Close Data using the CData ODBC Driver
Use the SQL Gateway and Close ODBC Driver to create a PostgreSQL entry-point for data access.
-
Connect and Query Live GitLab Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live GitLab into Databricks
-
Edit and Search Workday External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of Workday to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create Workday objects that you can access from apps and the dashboard.
-
Getting Started with the CData Python Connector for Teamgate
Learn to install and license the CData Python Connector
-
Consume OneNote OData Feeds in SAP Lumira
Use the API Server to create data visualizations on OneNote feeds that reflect any changes in SAP Lumira.
-
Create SSAS Tabular Models from Todoist Data
How to build a SQL Server Analysis Service Tabular Model from Todoist using CData drivers.
-
Build an OLAP Cube in SSAS from xBase Data
Establish a connection to xBase data from SQL Server Analysis Services, and use the xBase Data Provider to build OLAP cubes for use in analytics and reporting.
-
Sage 300 Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Sage 300 facts in real time.
-
Getting Started with the CData Power BI Connector for Datadog
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
How to work with PolarTeamPro Data in Apache Spark using SQL
Access and process PolarTeamPro Data in Apache Spark using the CData Software JDBC Driver.
-
Getting Started with the CData Excel Add-In for Pinecone
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Pinecone.
-
Access Live Sage 200 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 Sage 200 through MCP integration.
-
DataBind Email Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for Email with the DevExpress Windows Forms and Web controls to provide Email to a chart.
-
Build CockroachDB-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for CockroachDB Data and create custom apps in Bubble.
-
How to work with Sendwithus Data in Apache Spark using SQL
Access and process Sendwithus Data in Apache Spark using the CData Software JDBC Driver.
-
Enable the Delighted JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Delighted.
-
Automate Shortcut Data Replication to Azure Data Lake
Use CData Sync to customize and automate Shortcut replication to Azure Data Lake.
-
ZohoMarketingHub Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on ZohoMarketingHub facts in real time.
-
Build AI/ML Models with Live Samanage Data using Dataiku
Connect Samanage Data with Dataiku using the CData API Driver for JDBC.
-
Automated Continuous Shopify Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Shopify replication to PostgreSQL.
-
How to Connect to Authorize.Net Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Authorize.Net. Leverage the pyodbc module for ODBC in Python.
-
Integrate Live MongoDB Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to MongoDB from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live MongoDB.
-
Integrating GitHub Copilot CLI with Aircall 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 Elorus Data from PowerBuilder via ADO.NET
This article demonstrates how to access Elorus from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
How to create Azure Synapse federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Azure Synapse in MySQL .
-
How to Connect to Redshift Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Amazon Redshift. Leverage the pyodbc module for ODBC in Python.
-
Access iContact Data from MySQL in Amazon QuickSight
Connect to iContact and build visualizations of iContact using a MySQL Connection in Amazon QuickSight.
-
Publish HDFS-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Apache HDFS.
-
Access Impala 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 Apache Impala.
-
Analyze Amazon S3 Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Amazon S3 in Microsoft R Open.
-
Connect to Sybase IQ Data in RazorSQL
Connect to Sybase IQ from wizards and query Sybase IQ from the GUI in the RazorSQL database management tool.
-
Build Semantic Layer Views for iContact Data in APOS Live Data Gateway
Use the CData Connector for iContact in APOS Live Data Gateway to build Semantic Layer Views for iContact.
-
Automate Teamgate Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Teamgate from PowerShell? This article demonstrates how to utilize the Teamgate Cmdlets for tasks like connecting to Teamgate, automating operations, downloading data, and more.
-
Connect to Dropbox Data in JRuby
Create a simple JRuby app with access to live Dropbox.
-
Connect to Salesforce Data 360 Data from PowerBuilder via ADO.NET
This article demonstrates how to access Salesforce Data 360 from Appeon PowerBuilder using the CData ADO.NET Provider for Salesforce Data 360.
-
Analyze Aircall Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Aircall in Microsoft R Open.
-
Access Live Pushbullet Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Pushbullet into the statistical analysis tools available in SAS JMP. This article shows how to use Pushbullet in the Graph Builder and Query Builder.
-
Model Oracle SCM Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Oracle SCM, enabling the direct import of real-time Oracle SCM.
-
Access Pipeliner CRM Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Pipeliner CRM from your Oracle system.
-
Connect to PostgreSQL Data from a Connection Pool in Jetty
The PostgreSQL JDBC Driver supports connection pooling: This article shows how to connect faster to PostgreSQL from Web apps in Jetty.
-
Integrate Stripe with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Stripe with External Services.
-
Connect to HubSpot Data in Claris FileMaker Pro
Use the CData ODBC Driver for HubSpot in FileMaker Pro to connect to HubSpot and work with HubSpot in your FileMaker applications.
-
Connect MailerLite to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live MailerLite using the CData Python MCP Server.
-
Write a Simple Go Application to work with Chargebee Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Chargebee.
-
Automated Continuous Shopify Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Shopify replication to Google BigQuery.
-
Analyze ZohoPeople Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for ZohoPeople from Power Pivot. You will use the Table Import Wizard to load ZohoPeople. You can visually build the import query or use any SQL supported by the driver.
-
Access TaxJar Data from MySQL in Amazon QuickSight
Connect to TaxJar and build visualizations of TaxJar using a MySQL Connection in Amazon QuickSight.
-
Automate Teamgate Data Replication to Couchbase
Use CData Sync to Customize and automate Teamgate replication to Couchbase.
-
Connect to Office 365 Data from HeidiSQL
Use CData Connect AI to connect to and query live Microsoft Office 365 from HeidiSQL.
-
Connect to xBase Data from a Connection Pool in JBoss
Integrate xBase into Java servlets: Use the Management Console in JBoss to install the xBase JDBC Driver.
-
Build AI Agents with Confluence Data in IBM watsonx Orchestrate using CData Connect AI
Learn how to build intelligent agents in IBM watsonx Orchestrate that can securely access and act on live Atlassian Confluence through CData Connect AI.
-
Integrate Real-Time Access to Slack in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Slack in real time.
-
Connect to Missive Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Missive using standard SQL.