CData Software - Knowledge Base
Recent Articles
-
Automated Continuous HelloSign Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable HelloSign replication to delimited files (CSV/TSV).
-
Excel Spreadsheet Automation on Sugar CRM Data with the QUERY Formula
Pull data from Sugar CRM, automate spreadsheets, and more with the QUERY formula.
-
Access Live Coinbase Data in Coginiti Pro
Connect to and query live Coinbase from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
ETL PagerDuty in Oracle Data Integrator
This article shows how to transfer PagerDuty into a data warehouse using Oracle Data Integrator.
-
Connect to xBase Data in RazorSQL
Connect to xBase from wizards and query xBase from the GUI in the RazorSQL database management tool.
-
Use the CData Software JDBC Driver for Dynamics 365 in MicroStrategy
Connect to Microsoft Dynamics 365 in MicroStrategy Developer using the CData Software JDBC Driver for Dynamics 365.
-
Connect to Unbounce Data in Jaspersoft Studio
Execute SQL to remote Unbounce in Jaspersoft Studio.
-
Connect to Calendly Data in NetBeans
Connect to Calendly in NetBeans with the data source configuration wizard.
-
Connect to SendInBlue Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time SendInBlue using standard SQL.
-
Build Dashboards with Mailgun Data in Dundas BI
Create dynamic dashboards and perform analytics based on Mailgun in Dundas BI.
-
Use the CData Software ODBC Driver for Miro in MicroStrategy Desktop
Connect to Miro in MicroStrategy Desktop using the CData Software ODBC Driver for Miro.
-
Configure the CData JDBC Driver for Missive in a Connection Pool in Tomcat
Connect to Missive from a connection pool in Tomcat.
-
Connect to Live Sage Cloud Accounting Data in MicroStrategy through CData Connect AI
Create a live connection to Sage Cloud Accounting Data in CData Connect AI and connect to your Sage Business Cloud Accounting from MicroStrategy.
-
Integrate Open WebUI with Live Airtable Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Airtable from within the chat interface.
-
Connect to Dynamics CRM Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Microsoft Dynamics CRM in Airbyte.
-
Replicate Sage 300 Data from PowerShell
Write a quick PowerShell script to query Sage 300. Use connectivity to the live data to replicate Sage 300 to SQL Server.
-
How to publish and share Azure Table Data dashboards with Tableau Server
The CData ODBC driver for Azure Table enables you integrate Azure Table Storage into Tableau dashboards.
-
Connect to Flowlu Data in NetBeans
Connect to Flowlu in NetBeans with the data source configuration wizard.
-
Automated Continuous Dynamics 365 Replication to Snowflake
Use CData Sync for automated, continuous, customizable Dynamics 365 replication to Snowflake.
-
Create Dynamic PayPal Grids Using the Infragistics XamDataGrid
Learn how you can connect PayPal to Infragistics XamDataGrid to build dynamic grids.
-
Build an OLAP Cube in SSAS from Amazon S3 Data
Establish a connection to Amazon S3 data from SQL Server Analysis Services, and use the Amazon S3 Data Provider to build OLAP cubes for use in analytics and reporting.
-
Access LionDesk Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access LionDesk from your Oracle system.
-
How to Easily Query Discord Data in OpenOffice Base
Connect to Discord data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for PabblySubscriptions
Provide connectivity to PabblySubscriptions through an SAP BusinessObjects universe.
-
Visualize Pingdom Data in Sisense
Create an ElastiCube in Sisense app with access to Pingdom.
-
Replicate Twitter Ads Data to Multiple Databases
Replicate Twitter Ads to disparate databases with a point-and-click configuration.
-
Build Visualizations of YouTube Analytics Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of YouTube Analytics in Birst.
-
Connect to Opsgenie Data in Aqua Data Studio
Access Opsgenie from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Integrating Antigravity CLI with PingOne via CData CLI
Connect PingOne to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
How to Connect to Live Box Data from Claude Agent SDK (via CData Connect AI)
Leverage CData Connect AI to enable Claude Agent SDK applications to securely read and take actions on your Box for you.
-
Connect to Acumatica Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Acumatica and the Script function in FileMaker Pro to connect to Acumatica and work with Acumatica ERP in your FileMaker application.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Oracle HCM Cloud
Provide connectivity to Oracle HCM Cloud through an SAP BusinessObjects universe.
-
Create Datasets from Power BI XMLA in Domo Workbench and Build Visualizations of Power BI XMLA Data in Domo
Use the CData Software ODBC Driver for Power BI XMLA to create datasets from Power BI XMLA in Domo Workbench and then build visualizations in the Domo service.
-
Bidirectional Access to Templated Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Templated in Filemaker Pro for Mac or Windows.
-
Integrate MariaDB Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live MariaDB from Informatica Cloud.
-
Connect to Delighted Data from a Connection Pool in Jetty
The Delighted JDBC Driver supports connection pooling: This article shows how to connect faster to Delighted from Web apps in Jetty.
-
Automate Amazon DynamoDB Data Replication to Azure Synapse
Use CData Sync to customize and automate Amazon DynamoDB replication to Azure Synapse.
-
Query Outreach.io Data as a MySQL Database in Node.js
Execute MySQL queries against Outreach.io from Node.js.
-
Back Up Bullhorn CRM to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Bullhorn CRM. In this article, we will employ an SSIS workflow to populate a database with Bullhorn CRM data.
-
Automated Continuous Google Directory Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Google Directory replication to Apache Cassandra.
-
Connect to Lakebase Data from Crystal Reports
Use CData Connect AI to connect to and report on live Lakebase from Crystal Reports.
-
Manage MessageBird Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for MessageBird.
-
Excel Spreadsheet Automation on Accelo Data with the QUERY Formula
Pull data from Accelo, automate spreadsheets, and more with the QUERY formula.
-
Build Parquet-Powered Applications in Cursor with CData MCP Server
Use the CData MCP Server for Parquet to explore live Parquet Data in Cursor to assist with building Parquet-powered applications.
-
Bridge SAP SuccessFactors Connectivity with Apache NiFi
Access and process SAP SuccessFactors in Apache NiFi using the CData JDBC Driver.
-
Connecting Moonlit Workflow with GraphQL 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 GraphQL in real time.
-
Getting Started with the CData Python Connector for Google Analytics
Learn to install and license the CData Python Connector
-
Integrate Goose with Live Couchbase Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Couchbase from within the local AI agent.
-
Connect to SendGrid Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
How to import Mode Data into Apache Solr
Use the CData Software JDBC Driver for Mode in Data Import Handler and create an automated import of Mode to Apache Solr Enterprise Search platform.
-
Connect to and Query PingOne Data in QlikView over ODBC
Create data visualizations with PingOne in QlikView.
-
Manage WooCommerce Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for WooCommerce.
-
Integrate with Google Calendar Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Google Calendar to a JSON file on disk.
-
Connect to Real-Time Freshservice Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Freshservice in Power Apps.
-
Integrating Claude Code CLI with ShipEngine 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 PolyBase to Google Search
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Google Search.
-
Connect to MYOB AccountRight Data from AWS Glue
Use CData Connect AI to gain access to live MYOB AccountRight from your AWS Glue jobs.
-
How to import eBay Analytics Data into Apache Solr
Use the CData Software JDBC Driver for eBay Analytics in Data Import Handler and create an automated import of eBay Analytics to Apache Solr Enterprise Search platform.
-
Rapidly Develop Excel-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 Excel.
-
Import Real-Time Freshsales Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Freshsales in ColdFusion.
-
Integrate Raisers Edge NXT Data into Power Automate Desktop using CData Connect
CData Connect for Raisers Edge NXT Data enables you to integrate Raisers Edge NXT into workflows built using Microsoft Power Automate Desktop.
-
DataBind Controls to Humanity Data in C++Builder
DataBind to Humanity in C++Builder with standard components and controls.
-
Replicate LinkedIn Data from PowerShell
Write a quick PowerShell script to query LinkedIn. Use connectivity to the live data to replicate LinkedIn to SQL Server.
-
Using the CData Software ODBC Driver for QuickBooks Online in PyCharm
Connect to QuickBooks Online as an ODBC data source in PyCharm using the CData Software ODBC Driver for QuickBooks Online.
-
How to Access Live LeadDesk Data in Power Automate Desktop via ODBC
The CData ODBC Driver for LeadDesk enables you to integrate LeadDesk into workflows built using Microsoft Power Automate Desktop.
-
Seamlessly Bring Amazon Athena Data into Retool Using CData Connect AI
Integrate Amazon Athena data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Integrate Cline with Live Greenhouse Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Greenhouse from within your IDE.
-
Integrate Live NetSuite Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live NetSuite CRM & ERP to Blue Prism using the CData ODBC Driver for NetSuite to create automated workflows for repetitive business tasks.
-
Build Salesloft-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Salesloft and build web apps with connectivity to live Salesloft.
-
Migrating data from CampaignMonitor to Google BigQuery using CData SSIS Components.
Easily push CampaignMonitor to Google BigQuery using the CData SSIS Tasks for CampaignMonitor and Google BigQuery.
-
How to integrate Metabase with Act CRM Data
Use CData Connect AI to connect to live Act CRM and create an interactive dashboard in Metabase from Act CRM.
-
Integrating Kiro CLI with Mistral AI 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.
-
Automated Continuous NetSuite Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable NetSuite replication to Apache Kafka.
-
Import Real-Time Amazon S3 Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Amazon S3 in ColdFusion.
-
Analyze Live Sybase IQ Data in SAS Viya
Use CData Connect AI to connect to Sybase IQ from SAS Viya and deploy self-service analytics using live Sybase IQ.
-
Process & Analyze Humanity Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Humanity Data.
-
Object-Relational Mapping (ORM) with Browserless 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 Browserless into a Java-based ORM framework, Hibernate.
-
Use the CData Software ODBC Driver for NASA in MicroStrategy
Connect to NASA in MicroStrategy Developer using the CData Software ODBC Driver for NASA.
-
How to connect PolyBase to Salesloft
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Salesloft.
-
Manage Snapchat Ads Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Snapchat Ads.
-
Query HelloSign Data as a MySQL Database in Node.js
Execute MySQL queries against HelloSign from Node.js.
-
How to publish and share OpenWeatherMap Data dashboards with Tableau Server
The CData ODBC driver for OpenWeatherMap enables you integrate OpenWeatherMap into Tableau dashboards.
-
Access Live EnterpriseDB Data in AWS Lambda
Connect to live EnterpriseDB in AWS Lambda using the CData JDBC Driver.
-
Build Pipelines with Live SAP ByDesign Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to SAP ByDesign from Google Cloud Data Fusion, enabling the integration of live SAP Business ByDesign into the building and management of effective data pipelines.
-
Connect to Cvent from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Cvent, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Analyze Tickspot Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Tickspot with the CData JDBC Driver for Tickspot.
-
Connect to Email from Asprova with CData Software ODBC Driver for Email
This article shows how to connect faster to Email data from Asprova.
-
Connect to Retently Data in HULFT Integrate
Connect to Retently as a JDBC data source in HULFT Integrate
-
Visualize Live ScrapingBee Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live ScrapingBee using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Rapidly Develop Landbot-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 Landbot.
-
How to create an RPA flow for OpenWeatherMap Data in UiPath Studio
Use the OpenWeatherMap ODBC Driver to create workflows that access real-time OpenWeatherMap without any coding.
-
Publish Reports with Yelp Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Yelp.
-
How to Connect Flowise AI Agents to Live Acumatica 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 Acumatica ERP without replication.
-
How to Connect to & Open Timely Data in Microsoft Excel
This article uses the CData ODBC driver for Timely to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Connect to JobNimbus Data in JRuby
Create a simple JRuby app with access to live JobNimbus.
-
How to Connect Amazon Marketplace 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 Amazon Marketplace data in real time using natural language.
-
Automated Continuous Email Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Email replication to Azure SQL Database.
-
Automated Continuous HubDB Replication to Amazon S3
Use CData Sync for automated, continuous, customizable HubDB replication to Amazon S3.
-
Connect Discord Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Discord using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Use the CData Software JDBC Driver for FHIR in MicroStrategy Desktop
Connect to FHIR in MicroStrategy Desktop using the CData Software JDBC Driver for FHIR.