CData Software - Knowledge Base
Recent Articles
-
How to Connect to Reckon Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Reckon data. Leverage the pyodbc module for ODBC in Python.
-
Import Vault CRM Data Using Azure Data Factory
Use CData Connect AI to connect to Vault CRM Data from Azure Data Factory and import live Vault CRM data.
-
How to Connect to Live Redis Data in Mistral AI Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live Redis data without replication.
-
Connect to Live Freshdesk Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Freshdesk in CData Connect AI and connect to your Freshdesk data from PostgreSQL.
-
Integrate with Chargebee Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Chargebee data to a JSON file on disk.
-
Access Live Stripe 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 Stripe data through MCP integration.
-
Access Live Grafana Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Grafana data into the statistical analysis tools available in SAS JMP. This article shows how to use Grafana data in the Graph Builder and Query Builder.
-
DataBind Controls to MessageBird Data in C++Builder
DataBind to MessageBird data in C++Builder with standard components and controls.
-
Build AI Agents with Freshservice 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 Freshservice data through CData Connect AI.
-
Establish a Live Connection with Missive Data using Tableau Bridge
The CData ODBC Driver for Missive enables you to integrate live Missive data into Tableau Cloud dashboards using the Tableau Bridge.
-
Replicate Multiple ZohoPeople Accounts via the CData Sync CLI
Replicate multiple ZohoPeople accounts to one or many databases.
-
Configure the CData JDBC Driver for Xero in a Connection Pool in Tomcat
Connect to Xero data from a connection pool in Tomcat.
-
Import and Visualize Cloudant Data in Power View
Create data visualizations based on Cloudant data in Excel.
-
How to Query Live CloudConvert Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live CloudConvert data data in natural language using Python.
-
How to Query Salesforce Marketing Data in MySQL Workbench
Execute MySQL queries against live Salesforce Marketing data from MySQL Workbench.
-
Connect to Jumpseller Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Jumpseller data from Filemaker Pro on Mac.
-
Connect to Salesforce Marketing from Asprova with CData Software ODBC Driver for Salesforce Marketing
This article shows how to connect faster to Salesforce Marketing data from Asprova.
-
Use JayDeBeApi to access Nuclia Data in Python
Use standard Python scripting and the development environment of your choice to access live Nuclia data.
-
Choosing the Best Method to Connect Guru to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Guru data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Automated Continuous Procore Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Procore replication to Azure SQL Database.
-
Build AI/ML Models with Live Blackbaud FE NXT Data using Dataiku
Connect Blackbaud FE NXT Data with Dataiku using the CData JDBC Driver for Blackbaud FE NXT.
-
DataBind Controls to SharePoint Excel Services Data in Delphi
DataBind to SharePoint Excel Services data in Delphi with standard data access components and controls.
-
DataBind Lakebase Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for Lakebase with the DevExpress Windows Forms and Web controls to provide Lakebase data to a chart.
-
Access Live MYOB AccountRight Data in Coginiti Pro
Connect to and query live MYOB AccountRight data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Connect to Browserless Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Browserless data using standard SQL.
-
How to Connect to Shopify Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Shopify data. Leverage the pyodbc module for ODBC in Python.
-
Migrating data from SAP Netweaver Gateway to Databricks using CData SSIS Components.
Easily push SAP Netweaver Gateway data to Databricks using the CData SSIS Tasks for SAP Netweaver Gateway and Databricks.
-
Connect to Spotify Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Spotify data using standard SQL.
-
How to create an RPA flow for VWO Data in UiPath Studio
Use the VWO ODBC Driver to create workflows that access real-time VWO data without any coding.
-
Create a Data Access Object for Egnyte Data using JDBI
A brief overview of creating a SQL Object API for Egnyte data in JDBI.
-
How to Connect to Live Oracle 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 Oracle data for you.
-
Access Live LinkedIn 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 LinkedIn data through MCP integration.
-
Analyze Box Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Box from Power Pivot. You will use the Table Import Wizard to load Box data. You can visually build the import query or use any SQL supported by the driver.
-
Building Dynamic Web Pages with Bitbucket Data Using AngularJS
Create single-page applications with live connectivity to Bitbucket using the CData API Server.
-
Integrate Apify with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Apify with External Services.
-
Use CData Connect AI to Access Authorize.Net Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Authorize.Net data in the Power Pivot business intelligence tool.
-
Connect to Mailgun Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Mailgun Data and connect to Mailgun data in Akorbi Digital RunMyProcess.
-
Connect to Live QuickBooks Online Data in PostGresSQL Interface through CData Connect AI
Create a live connection to QuickBooks Online in CData Connect AI and connect to your QuickBooks Online data from PostgreSQL.
-
Build Dashboards with Mailgun Data in DBxtra
Create dynamic dashboards and perform analytics based on Mailgun data in DBxtra.
-
How to Access Live AgileCRM Data in Power Automate Desktop via ODBC
The CData ODBC Driver for AgileCRM enables you to integrate AgileCRM data into workflows built using Microsoft Power Automate Desktop.
-
Connect to Square Data from a Connection Pool in Jetty
The Square JDBC Driver supports connection pooling: This article shows how to connect faster to Square data from Web apps in Jetty.
-
Create Avro-Connected Nintex Workflows
Use CData Connect AI to connect to Avro Data from Nintex Workflow Cloud and build custom workflows using live Avro data.
-
A PostgreSQL Interface for SAP SuccessFactors Data (MySQL Remoting via JDBC)
Use the Remoting features of the SAP SuccessFactors JDBC Driver to create a PostgreSQL entry-point for data access.
-
Automate Pinecone Data Replication to Couchbase
Use CData Sync to Customize and automate Pinecone data replication to Couchbase.
-
Work with Live HubSpot Data in Power Query
Use CData Connect AI to connect to HubSpot data and work with live HubSpot data in Microsoft Power Query.
-
Create Tavily-Connected Applications in Appsmith
Connect to Tavily Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Tavily data.
-
Integrate Rootly Data in Pentaho Data Integration
Build ETL pipelines based on Rootly data in the Pentaho Data Integration tool.
-
Analyze Amazon Marketplace Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Amazon Marketplace data and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Access Live Bugsnag Data in Coginiti Pro
Connect to and query live Bugsnag data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Connect Active Directory Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Active Directory data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Create Reports with Adobe Experience Manager Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Adobe Experience Manager data.
-
How to Access Live Gong Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Gong enables you to integrate Gong data into workflows built using Microsoft Power Automate Desktop.
-
Connect to QuickBooks Data in JRuby
Create a simple JRuby app with access to live QuickBooks data.
-
Working with Brex Data in LINQPad
Execute LINQ queries to Brex data in LINQPad.
-
Create Dashboards and Visualize Live SageHR Data in Geckoboard
Use CData Connect AI to connect to live SageHR data and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Build Dotmailer-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Dotmailer data and build web apps with connectivity to live Dotmailer data.
-
How to update Salesforce CRM Analytics from Excel
This article explains how to transfer data from Excel to Salesforce CRM Analytics using the Excel Add-In for Salesforce CRM Analytics.
-
How to Connect to & Open Act CRM Data in Microsoft Excel
This article uses the CData ODBC driver for Act CRM to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Integrate with live SAP SuccessFactors LMS Data in Jitterbit
Use CData Connect AI to connect to and integrate live SAP SuccessFactors LMS data in Jitterbit.
-
How to Build an ETL App for Databricks Data in Python with CData
Create ETL applications and real-time data pipelines for Databricks data in Python with petl.
-
Connect to Cosmos DB Data in ACL Analytics
Connect to Cosmos DB data via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Cosmos DB data.
-
How to Connect to Live SAP Netweaver Gateway 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 SAP Netweaver Gateway data through natural language.
-
Connect to Google Directory Data in RazorSQL
Connect to Google Directory from wizards and query Google Directory data from the GUI in the RazorSQL database management tool.
-
Build Semantic Layer Views for CircleCI Data in APOS Live Data Gateway
Use the CData Connector for CircleCI in APOS Live Data Gateway to build Semantic Layer Views for CircleCI data.
-
Use the CData Software ODBC Driver for Azure Analysis Services in MicroStrategy
Connect to Azure Analysis Services data in MicroStrategy Developer using the CData Software ODBC Driver for Azure Analysis Services.
-
Integrating Claude Code CLI with Drip 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 Live Okta Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Okta data securely in real time.
-
DataBind Controls to Odoo Data in C++Builder
DataBind to Odoo data in C++Builder with standard components and controls.
-
Connect to LDAP Objects from PowerBuilder via ADO.NET
This article demonstrates how to access LDAP objects from Appeon PowerBuilder using the CData ADO.NET Provider for LDAP.
-
Connect to TigerGraph Data in Claris FileMaker Pro
Use the CData ODBC Driver for TigerGraph in FileMaker Pro to connect to TigerGraph and work with TigerGraph data in your FileMaker applications.
-
Creating Greenhouse-Connected Applications in Unqork
You can use CData Connect AI to feed Greenhouse data to Unqork and build custom business apps.
-
Access Live Avro Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Avro data into the statistical analysis tools available in SAS JMP. This article shows how to use Avro data in the Graph Builder and Query Builder.
-
Use JayDeBeApi to access MarkLogic Data in Python
Use standard Python scripting and the development environment of your choice to access live MarkLogic data.
-
Automated Continuous Outreach.io Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Outreach.io replication to Google BigQuery.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for SendInBlue
Provide connectivity to SendInBlue data through an SAP BusinessObjects universe.
-
Query Guru Data in ColdFusion
Write standard ColdFusion data access code to connect to Guru data.
-
How to create an RPA flow for Google Drive Data in UiPath Studio
Use the Google Drive ODBC Driver to create workflows that access real-time Google Drive data without any coding.
-
Automate Accelo Data Replication to Azure Data Lake
Use CData Sync to customize and automate Accelo data replication to Azure Data Lake.
-
Access Live Zoho Projects 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 Zoho Projects data through MCP integration.
-
Publish Google Ads-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Google Ads data.
-
Build AI Agents with iContact 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 iContact data through CData Connect AI.
-
Build AI/ML Models with Live Tickspot Data using Dataiku
Connect Tickspot Data with Dataiku using the CData API Driver for JDBC.
-
Automated Continuous Exa Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Exa replication to Apache Cassandra.
-
Excel Spreadsheet Automation on Moosend Data with the QUERY Formula
Pull data from Moosend, automate spreadsheets, and more with the QUERY formula.
-
Use the CData Software ODBC Driver for Testmonitor in MicroStrategy Web
Connect to Testmonitor data in MicroStrategy Web using the CData Software ODBC Driver for Testmonitor.
-
Access Live Kafka 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 Kafka data through MCP integration.
-
Write a Simple Go Application to work with Presto Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Presto data.
-
DataBind Controls to Vercel Data in C++Builder
DataBind to Vercel data in C++Builder with standard components and controls.
-
Automated Continuous BenchmarkEmail Replication to Oracle
Use CData Sync for automated, continuous, customizable BenchmarkEmail replication to Oracle.
-
Model, Search, and Visualize Live Procore Data in ThoughtSpot
Use CData Connect AI to connect to live Procore data for modeling, searching, and visualizing.
-
How to Seamlessly Import Gumroad Data into IBM SPSS Modeler
Integrate Gumroad data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Query Dotmailer Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Dotmailer data from Node.js.
-
DataBind Charts to SAP Fieldglass Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to SAP Fieldglass data 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.
-
Creating CockroachDB-Connected Applications in Unqork
You can use CData Connect AI to feed CockroachDB data to Unqork and build custom business apps.
-
Use Claude to Talk to Your Reckon Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your Reckon data for you.
-
Integrate Cline with Live CockroachDB Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live CockroachDB data from within your IDE.
-
Use the CData ODBC Driver for Brex from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Brex to connect to Brex data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Brex data in Excel.
-
Access Live Slack Data in Excel 365 Online (Excel for the web)
Connect to Slack data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
LINQ to Highrise 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 Highrise Data Provider.
-
Connecting Pipedream with Sage 200 Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Pipedream workflows to securely read and take actions on Sage 200 data in real time.