CData Software - Knowledge Base
Recent Articles
-
Automated Continuous Oracle Replication to SQLite
Use CData Sync for automated, continuous, customizable Oracle replication to SQLite.
-
Insert Invoices with the Excel Add-In for QuickBooks
The CData Excel Add-In for QuickBooks can be used to easily retrieve and insert QuickBooks data. In this article, you will insert an invoice into QuickBooks.
-
Integrating Antigravity CLI with Google Campaign Manager 360 via CData CLI
Connect Google Campaign Manager 360 to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Connect to Bitly Data in NetBeans
Connect to Bitly in NetBeans with the data source configuration wizard.
-
Integrate Everhour with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Everhour with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Everhour.
-
Configure the CData JDBC Driver for Freshservice in a Connection Pool in Tomcat
Connect to Freshservice from a connection pool in Tomcat.
-
Build Act CRM Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Act CRM and build visualizations in Tableau Cloud.
-
A PostgreSQL Interface for Klaviyo Data (MySQL Remoting via JDBC)
Use the Remoting features of the Klaviyo JDBC Driver to create a PostgreSQL entry-point for data access.
-
Build Automated Workflows with Live Elasticsearch Data in Workato
Use CData Connect AI to connect to live Elasticsearch and build automated workflows in Workato.
-
Integrate Cursor with Live eBay Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live eBay from within the editor.
-
Integrate Adobe Commerce Data in the Pentaho Report Designer
Publish reports based on Adobe Commerce in the Pentaho BI tool.
-
Connect to MailerLite Data from a Connection Pool in Jetty
The MailerLite JDBC Driver supports connection pooling: This article shows how to connect faster to MailerLite from Web apps in Jetty.
-
Publish SQL Server-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Microsoft SQL Server.
-
View Reports on Real-Time Odoo Data in Power BI Report Server
Use the CData ODBC Driver for Odoo to visualize Odoo ERP in Power BI Desktop and then publish them to Power BI Report Server.
-
Build a Singer.io Tap for Spark With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Spark data using
-
Connecting GenSpark with SAP BusinessObjects BI Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to SAP BusinessObjects BI without any replication or custom integration required.
-
Connect to Pingdom Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Pingdom in the Denodo Virtual DataPort Administrator.
-
Integrating Jira Assets Data in Talend Cloud Data Management Platform
Connect Jira Assets Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Jira Assets.
-
How to integrate Workable with Apache Airflow
Access and process Workable in Apache Airflow using the CData JDBC Driver.
-
Create Apps from Dynamics 365 Business Central Data in Qlik Sense Cloud
Use CData Connect AI to connect to Dynamics 365 Business Central Data and build apps from live Dynamics 365 Business Central in Qlik Sense Cloud.
-
Create Datasets from Webex in Domo Workbench and Build Visualizations of Webex Data in Domo
Use the CData Software ODBC Driver for Webex to create datasets from Webex in Domo Workbench and then build visualizations in the Domo service.
-
Getting Started with the CData Tableau Connector for Certinia
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Certinia.
-
Connect Databricks to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Databricks using the CData Python MCP Server.
-
Creating Power BI XMLA-Connected Applications in Unqork
You can use CData Connect AI to feed Power BI XMLA to Unqork and build custom business apps.
-
Prepare, Blend, and Analyze Optimizely Data in Alteryx Designer (ODBC)
Build workflows to access live Optimizely for self-service data analytics.
-
Replicate HubDB Data to Multiple Databases via the CData Sync CLI
Replicate HubDB to disparate databases with a single configuration.
-
Natively Connect to XML Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to XML Files. Leverage the native support for ODBC in PHP.
-
Access Live Cvent 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 Cvent through MCP integration.
-
Natively Connect to Bitly Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Bitly. Leverage the native support for ODBC in PHP.
-
Automated Continuous Highrise Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Highrise replication to AlloyDB.
-
How to Connect to Live PostgreSQL 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 PostgreSQL for you.
-
How to connect to Perigon Data from Spring Boot
Connect to Perigon in a Spring Boot Application using the CData API Driver for JDBC
-
Choosing the Best Method to Connect HelloSign to SQL Server: 5 Options Explained
Discover multiple ways to connect and use HelloSign from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Access Live SAS Data Sets 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 SAS Data Sets through MCP integration.
-
Automated Continuous Quaderno Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Quaderno replication to AlloyDB.
-
Connect to and Query Active Directory Data in QlikView over ODBC
Create data visualizations with Active Directory in QlikView.
-
Connect to Paylocity Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Paylocity as an External Source in Dremio.
-
How to Design REST Power Apps with Database-Like Connectivity
Gain real-time, database-like connectivity to REST from mobile and tablet Power Apps.
-
A PostgreSQL Interface for Salesforce Data using the CData ODBC Driver
Use the SQL Gateway and Salesforce ODBC Driver to create a PostgreSQL entry-point for data access.
-
Build a Simple VCL Application for Missive Data
How to build a simple VCL Application to view Missive in RAD Studio using the CData ODBC Driver for Missive.
-
How to connect to BigQuery Data in DBVisualizer
Integrate Google BigQuery with visual data analysis tools and data connection wizards in DBVisualizer
-
Getting Started with the CData SSIS Components for Google Contacts
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Google Contacts.
-
Connect to Snapchat Ads 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 Snapchat Ads.
-
Connect to Oracle Eloqua Reporting Data in Ruby
Connect to Oracle Eloqua Reporting in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Connect to MailerSend Data from PowerBuilder via JDBC
This article demonstrates how to access MailerSend from PowerBuilder using the MailerSend JDBC Driver.
-
Integrating Claude Code 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.
-
Connect to Cloudflare Data in DBeaver
Use the CData ODBC Driver to connect to Cloudflare in DBeaver.
-
Seamlessly Bring Zoho Inventory Data into Retool Using CData Connect AI
Integrate Zoho Inventory data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
LINQ to Bitly 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 Bitly Data Provider.
-
How to Build an ETL App for CSV Data in Python with CData
Create ETL applications and real-time data pipelines for CSV/TSV Files in Python with petl.
-
Connect to Paylocity Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Easily Integrate Splunk Data in Lazarus Pascal IDE
Learn how to easily integrate live Splunk in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Visualize Pipedrive Data in TIBCO Spotfire through ADO.NET
Integrate Pipedrive into dashboards in TIBCO Spotfire.
-
How to import Pinterest Data into Apache Solr
Use the CData Software JDBC Driver for Pinterest in Data Import Handler and create an automated import of Pinterest to Apache Solr Enterprise Search platform.
-
Connect to GraphQL Data from PowerBuilder via ADO.NET
This article demonstrates how to access GraphQL from Appeon PowerBuilder using the CData ADO.NET Provider for GraphQL.
-
Create Power BI Reports on Real-Time EnterpriseDB Data
Use the CData ODBC Driver for EnterpriseDB to visualize EnterpriseDB in Power BI Desktop.
-
Use the CData Software ODBC Driver for Tanda in MicroStrategy
Connect to Tanda in MicroStrategy Developer using the CData Software ODBC Driver for Tanda.
-
Build Pipelines with Live Greenhouse Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Greenhouse from Google Cloud Data Fusion, enabling the integration of live Greenhouse into the building and management of effective data pipelines.
-
How to use SQLAlchemy ORM to access Sage Intacct Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Sage Intacct.
-
How to connect PolyBase to Billsby
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Billsby.
-
How to connect to Blackbaud FE NXT Data from Spring Boot
Connect to Blackbaud FE NXT in a Spring Boot Application using the CData JDBC Driver for Blackbaud FE NXT
-
Create Couchbase-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Couchbase Data from OutSystems and build custom enterprise apps using live Couchbase.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Dropbox within intelligent workflows.
-
Access Live PayPal Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live PayPal data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
How to Query Live Hive Data in Claude Desktop
Connect to and query live Hive Data in Claude Desktop using CData MCP Server.
-
Integrate Cline with Live Snapchat Ads Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Snapchat Ads from within your IDE.
-
Integrating Kiro CLI with Dynamics NAV 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.
-
Use the CData ODBC Driver for HBase in Microsoft Power Query
You can use the CData HBase ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Apache HBase into Microsoft Power Query.
-
How to integrate Metabase with MariaDB Data
Use CData Connect AI to connect to live MariaDB and create an interactive dashboard in Metabase from MariaDB.
-
Automate REST Data Replication to Azure Synapse
Use CData Sync to customize and automate REST replication to Azure Synapse.
-
Connect to FTP Data in Aqua Data Studio
Access FTP Servers from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Connect Figshare Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Figshare using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
A PostgreSQL Interface for Cvent Data using the CData ODBC Driver
Use the SQL Gateway and Cvent ODBC Driver to create a PostgreSQL entry-point for data access.
-
DataBind Charts to ZohoExpense Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to ZohoExpense 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.
-
Connect to Google Sheets Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Google Sheets Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Create Informatica Mappings From/To an ODBC Data Source for Zuora
Create an ODBC connection to Zuora in Informatica and browse and transfer Zuora.
-
Connect to Sage Cloud Accounting Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Trigger Sybase IQ IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for Sybase IQ with standard wizards in Logic Apps.
-
Connect to Oracle Service Cloud Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Oracle Service Cloud.
-
Integrating Dataiku with Google Drive Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Google Drive.
-
How to Connect to Live SAP Ariba Procurement Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live SAP Ariba Procurement securely in real time.
-
Access Wistia Data from MySQL in Amazon QuickSight
Connect to Wistia and build visualizations of Wistia using a MySQL Connection in Amazon QuickSight.
-
Connect Paylocity to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Paylocity with IBM WebSphere for seamless data integration and connectivity.
-
ETL Elorus in Oracle Data Integrator
This article shows how to transfer Elorus into a data warehouse using Oracle Data Integrator.
-
Create Data Visualizations Based On Dropbox Data in Mode
Use CData Connect AI to connect to Dropbox Data from Mode and build visualizations using live
-
Visualize Trello Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Trello.
-
Access Live Zoom Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Zoom into the statistical analysis tools available in SAS JMP. This article shows how to use Zoom in the Graph Builder and Query Builder.
-
Build Placid-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Placid.
-
Access Live Parquet Data in AWS Lambda
Connect to live Apache Parquet in AWS Lambda using the CData JDBC Driver.
-
Connect to and Query Shortcut Data in QlikView over ODBC
Create data visualizations with Shortcut in QlikView.
-
Query Browserless Data as a MySQL Database in Node.js
Execute MySQL queries against Browserless from Node.js.
-
Connect to HubSpot from a Connection Pool in WebLogic
Use the CData JDBC Driver for HubSpot to connect to HubSpot from Web applications running on WebLogic.
-
Import Real-Time Azure Data Catalog Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Azure Data Catalog in ColdFusion.
-
Using the CData Software ODBC Driver for Dynamics CRM in PyCharm
Connect to Dynamics CRM as an ODBC data source in PyCharm using the CData Software ODBC Driver for Dynamics CRM.
-
Access Mailjet Data from MySQL in PHP
Connect to Mailjet through the standard MySQL libraries in PHP.
-
Visualize Live SingleStore Data in the Power BI Service
Use CData Connect AI to connect to live SingleStore and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Work with Access Data in FoxPro
Load Microsoft Access into a FoxPro database. This article includes full code and a walk-through of the process.
-
Use the CData Software ODBC Driver for Gumroad in SAS for Real-Time Reporting and Analytics
Connect to real-time Gumroad in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Gumroad.
-
Connect to Real-Time SAP Ariba Source Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for SAP Ariba Source and Dataflow to import and use SAP Ariba Source in Power Apps.
-
View Reports on Real-Time Guru Data in Power BI Report Server
Use the CData ODBC Driver for Guru to visualize Guru in Power BI Desktop and then publish them to Power BI Report Server.