CData Software - Knowledge Base
Recent Articles
-
How to Connect to Live Reckon Accounts Hosted Data from Gemini CLI (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Gemini CLI to securely read and take actions on your Reckon Accounts Hosted for you.
-
Integrate Theia IDE with Live Cassandra Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE
-
Automate LinkedIn Data Replication to Azure Data Lake
Use CData Sync to customize and automate LinkedIn replication to Azure Data Lake.
-
Natively Connect to Box Data in PHP
The CData ODBC driver for Box enables you to create PHP applications with connectivity to Box. Leverage the native support for ODBC in PHP.
-
Use the CData Software JDBC Driver for Webex in MicroStrategy Desktop
Connect to Webex in MicroStrategy Desktop using the CData Software JDBC Driver for Webex.
-
Integrating Antigravity CLI with Strava via CData CLI
Connect Strava to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Work with Apify Data in FoxPro
Load Apify into a FoxPro database. This article includes full code and a walk-through of the process.
-
Automated Continuous Databricks Replication to Oracle
Use CData Sync for automated, continuous, customizable Databricks replication to Oracle.
-
Build a Singer.io Tap for xBase With the CData Python Connector
Learn how to easily build a Singer.io Tap for live xBase data using
-
Using SQL to Query Gmail
The CData Gmail Data Providers provide access to the full search capabilities of IMAP using standard SQL. This article will explore some examples to demonstrate the ease of creating powerful custom queries to search your Gmail account.
-
How to connect and process Lakebase from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Lakebase.
-
Build Apps with Live Wave Financial Data Using the Low-Code Development Platform of Mendix
Connect Wave Financial with Mendix to build apps using the CData JDBC Driver for Wave Financial.
-
Integrate Cline with Live SendGrid Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live SendGrid from within your IDE.
-
Integrate LibreChat with Live Airtable Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Airtable from within the chat interface.
-
Connect to SAP Netweaver Gateway Data in RapidMiner
Integrate SAP Netweaver Gateway with standard components and data source configuration wizards in RapidMiner Studio.
-
Integrating Antigravity CLI with Todoist via CData CLI
Connect Todoist to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Replicate AfterShip Data to Multiple Databases
Replicate AfterShip to disparate databases with a point-and-click configuration.
-
How to Connect to Confluence Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Atlassian Confluence. Leverage the pyodbc module for ODBC in Python.
-
Automated Continuous Oracle Financials Cloud Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Oracle Financials Cloud replication to Apache Cassandra.
-
How to Access Live SendInBlue Data in Power Automate Desktop via ODBC
The CData ODBC Driver for SendInBlue enables you to integrate SendInBlue into workflows built using Microsoft Power Automate Desktop.
-
How to connect to Greenhouse Data with Squirrel SQL client
Connect to Greenhouse and execute queries in the Squirrel SQL Client.
-
How to create Webex federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Webex in MySQL .
-
Write a Simple Go Application to work with Clari Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Clari.
-
How to Connect to Live Microsoft Exchange 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 Microsoft Exchange for you.
-
Process & Analyze Avro Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Avro Data.
-
Integrating Antigravity CLI with SQL Analysis Services via CData CLI
Connect SQL Analysis Services to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Connect to Teamwork from Asprova with CData Software ODBC Driver for Teamwork
This article shows how to connect faster to Teamwork data from Asprova.
-
Connect to Avro Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Apache Avro using standard SQL.
-
How to use SQLAlchemy ORM to access ADP Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of ADP.
-
Create Informatica Mappings From/To an ODBC Data Source for Teamgate
Create an ODBC connection to Teamgate in Informatica and browse and transfer Teamgate.
-
Visualize Bitly Data in Sisense
Create an ElastiCube in Sisense app with access to Bitly.
-
Automated Continuous Clio Replication to Oracle
Use CData Sync for automated, continuous, customizable Clio replication to Oracle.
-
Build a Singer.io Tap for Dynamics NAV With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Dynamics NAV data using
-
How to work with Toggl Data in Apache Spark using SQL
Access and process Toggl Data in Apache Spark using the CData Software JDBC Driver.
-
Create Exact Online-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Exact Online Data from Klipfolio and build custom visualizations using live Exact Online.
-
Connect to Templated Data in RapidMiner
Integrate Templated with standard components and data source configuration wizards in RapidMiner Studio.
-
Visualize Live ZohoInvoice Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live ZohoInvoice using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
How to Query Live ServiceNow Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live ServiceNow data in natural language using Python.
-
Connect to Qualaroo Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Qualaroo and the SQL Gateway to access Qualaroo from Google Apps Script.
-
Build Cvent-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Cvent Data and create custom apps in Mendix.
-
Visualize Live Pipedrive Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Pipedrive using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Create Informatica Mappings From/To a JDBC Data Source for Paylocity
Create Paylocity data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Automated Continuous SAP Fieldglass Replication to IBM DB2
Use CData Sync for automated, continuous, customizable SAP Fieldglass replication to IBM DB2.
-
Access Live Google Drive Data in Coginiti Pro
Connect to and query live Google Drive from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Connect to Microsoft Ads Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Microsoft Ads and the SQL Gateway to access Microsoft Ads from Google Apps Script.
-
How to Visualize Sage Cloud Accounting 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 Sage Business Cloud Accounting in Python.
-
How to Connect the Power BI Service to ConvertKit: Complete Guide
Connect to the CData Software Power BI Connector for ConvertKit from PowerBI.com to provide real-time ConvertKit across the organization.
-
Bridge Sage Cloud Accounting Connectivity with Apache NiFi
Access and process Sage Business Cloud Accounting in Apache NiFi using the CData JDBC Driver.
-
Replicate Multiple FreshBooks Accounts
Replicate multiple FreshBooks accounts to one or many databases.
-
How to Visualize QuickBooks Data in Python with pandas
Use pandas and other modules to analyze and visualize live QuickBooks Desktop in Python.
-
Use ChatGPT to Talk to Your AlloyDB Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable ChatGPT to securely answer questions and take actions on your Google AlloyDB for you.
-
Integrating Kiro CLI with Nuclia 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 Power BI XMLA Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Power BI XMLA replication to PostgreSQL.
-
Analyze Greenplum Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Pivotal GreenPlum with the CData JDBC Driver for Greenplum.
-
Connect to Smartsheet Data in HULFT Integrate
Connect to Smartsheet as a JDBC data source in HULFT Integrate
-
Visualize Typeform Data in Tableau
The CData ODBC driver for Typeform enables you integrate Typeform into Tableau dashboards.
-
Connect to Square Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Square as an External Source in Dremio.
-
Analyze Bullhorn CRM Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Bullhorn CRM from Power Pivot. You will use the Table Import Wizard to load Bullhorn CRM. You can visually build the import query or use any SQL supported by the driver.
-
Replicate Multiple Oracle Service Cloud Accounts
Replicate multiple Oracle Service Cloud accounts to one or many databases.
-
Use the CData Software JDBC Driver for Vercel in MicroStrategy
Connect to Vercel in MicroStrategy Developer using the CData Software JDBC Driver for Vercel.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Insightly
Provide connectivity to Insightly through an SAP BusinessObjects universe.
-
Access Live ShipStation Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live ShipStation from your Excel spreadsheets.
-
Connect to and Query Front Data in QlikView over ODBC
Create data visualizations with Front in QlikView.
-
Use Biml to Build SSIS Tasks to Replicate JSON Services to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate JSON to SQL Server.
-
DataBind Controls to AfterShip Data in C++Builder
DataBind to AfterShip in C++Builder with standard components and controls.
-
How to connect to ClickUp Data from Spring Boot
Connect to ClickUp in a Spring Boot Application using the CData API Driver for JDBC
-
How to Seamlessly Import Missive Data into IBM SPSS Modeler
Integrate Missive data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Replicate Multiple Amazon Athena Accounts via the CData Sync CLI
Replicate multiple Amazon Athena accounts to one or many databases.
-
How to Connect to Live Google Calendar 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 Google Calendar without replication.
-
How to publish and share Freshservice Data dashboards with Tableau Server
The CData ODBC driver for Freshservice enables you integrate Freshservice into Tableau dashboards.
-
Access Mouseflow Data from MySQL in Amazon QuickSight
Connect to Mouseflow and build visualizations of Mouseflow using a MySQL Connection in Amazon QuickSight.
-
Build LinkedIn Ads-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to LinkedIn Ads and build web apps with connectivity to live LinkedIn Ads.
-
Connect to SAP Data as an External Source in Dremio
Use the CData JDBC Driver to connect to SAP as an External Source in Dremio.
-
Create ZendeskSell Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time ZendeskSell data access from reports, embedded analytics, and more.
-
Automated Continuous LDAP Replication to SQLite
Use CData Sync for automated, continuous, customizable LDAP replication to SQLite.
-
A PostgreSQL Interface for Tavily Data using the CData ODBC Driver
Use the SQL Gateway and Tavily ODBC Driver to create a PostgreSQL entry-point for data access.
-
Automated Continuous JotForm Replication to Amazon S3
Use CData Sync for automated, continuous, customizable JotForm replication to Amazon S3.
-
How to Connect to Live Oracle Financials Cloud Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Oracle Financials Cloud securely in real time.
-
Use the CData Software ODBC Driver for SAP in MicroStrategy
Connect to SAP ERP/NetWeaver in MicroStrategy Developer using the CData Software ODBC Driver for SAP.
-
Integrating LlamaIndex with NetSuite SuiteAnalytics Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on NetSuite SuiteAnalytics in real time.
-
A PostgreSQL Interface for Pingdom Data (MySQL Remoting via JDBC)
Use the Remoting features of the Pingdom JDBC Driver to create a PostgreSQL entry-point for data access.
-
Enable the Grafana JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Grafana.
-
How to connect to Hubstaff Data with Squirrel SQL client
Connect to Hubstaff and execute queries in the Squirrel SQL Client.
-
Publish 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.
-
Automate Printify Data Replication to Azure Data Lake
Use CData Sync to customize and automate Printify replication to Azure Data Lake.
-
Use JayDeBeApi to access PDFMonkey Data in Python
Use standard Python scripting and the development environment of your choice to access live PDFMonkey.
-
Connecting Pipedream with SingleStore 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 SingleStore data in real time.
-
Build Automated Workflows with Live NetSuite SuiteAnalytics Data in Workato
Use CData Connect AI to connect to live NetSuite SuiteAnalytics and build automated workflows in Workato.
-
How to Access Live GraphQL Data in Power Automate Desktop via ODBC
The CData ODBC Driver for GraphQL enables you to integrate GraphQL into workflows built using Microsoft Power Automate Desktop.
-
Automated Continuous Printful Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Printful replication to Azure SQL Database.
-
Build Dashboards with Factorial Data in DBxtra
Create dynamic dashboards and perform analytics based on Factorial in DBxtra.
-
Replicate Multiple Datadog Accounts via the CData Sync CLI
Replicate multiple Datadog accounts to one or many databases.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Splunk
Provide connectivity to Splunk through an SAP BusinessObjects universe.
-
Analyze Retently Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Retently from Power Pivot. You will use the Table Import Wizard to load Retently. You can visually build the import query or use any SQL supported by the driver.
-
Integrating Cursor CLI with Nuclia 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.
-
Build Jira Assets-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Jira Assets and build web apps with connectivity to live Jira Assets.
-
DataBind Controls to Vimeo Data in Delphi
DataBind to Vimeo in Delphi with standard data access components and controls.
-
Viewing Spark Data in RAD Studio Data Explorer
How to view Apache Spark SQL in RAD Studio Data Explorer using the CData ODBC Driver for Spark.
-
How to connect to SendGrid Data from IntelliJ
Integrate connectivity to SendGrid with wizards in IntelliJ.
-
Create a Data Access Object for Mailjet Data using JDBI
A brief overview of creating a SQL Object API for Mailjet in JDBI.