CData Software - Knowledge Base
Recent Articles
-
Automated Continuous Qualaroo Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Qualaroo data replication to OneLake in Microsoft Fabric.
-
Create Informatica Mappings From/To a JDBC Data Source for Codat
Create Codat data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Build MailerLite-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live MailerLite data and build MailerLite-connected web apps with Axios.
-
Automated Continuous Drip Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Drip replication to Apache Cassandra.
-
Integrating Kiro with Basecamp 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.
-
Integrate with CockroachDB Data in SnapLogic
Use CData Connect AI to connect to and integrate with live CockroachDB data in SnapLogic.
-
How to Use a Microsoft Access Database to Update Greenplum Data in Real Time
Update Greenplum data by creating a linked table in Microsoft Access with the CData Greenplum ODBC Driver.
-
Integrate MailerLite with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate MailerLite with External Services.
-
Import Real-Time SuiteCRM Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use SuiteCRM data in ColdFusion.
-
How to Access Live Superchat Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Superchat enables you to integrate Superchat data into workflows built using Microsoft Power Automate Desktop.
-
Operational Reporting on Twitter Ads Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Twitter Ads data.
-
Automated Continuous Helpscout Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Helpscout replication to AlloyDB.
-
How to Build an ETL App for ClickUp Data in Python with CData Connect AI
Extract and transform live ClickUp data in Python with petl and the CData Connect AI Python SDK.
-
Connect to and Query Google Analytics Data in QlikView over ODBC
Create data visualizations with Google Analytics data in QlikView.
-
Integrating Epicor Kinetic Data in Talend Cloud Data Management Platform
Connect Epicor Kinetic Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Epicor Kinetic.
-
How to Connect to & Open Microsoft Dataverse Data in Microsoft Excel
This article uses the CData ODBC driver for Microsoft Dataverse to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Connect Sendwithus to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Sendwithus data using the CData Python MCP Server.
-
Integrating GitHub Copilot with SFTP 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.
-
Bidirectional Access to Avalara AvaTax Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Avalara AvaTax data in Filemaker Pro for Mac or Windows.
-
Migrating data from Exact Online to Snowflake using CData SSIS Components.
Easily push Exact Online data to Snowflake using the CData SSIS Tasks for Exact Online and Snowflake.
-
Publish PayPal-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live PayPal data.
-
Automated Continuous Bugsnag Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Bugsnag data replication to OneLake in Microsoft Fabric.
-
Connecting Pipedream with Box 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 Box data in real time.
-
Rapidly Develop Yelp-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 Yelp.
-
Access Live FTP 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 FTP data through MCP integration.
-
Connect to Toggl Data in HULFT Integrate
Connect to Toggl as a JDBC data source in HULFT Integrate
-
Connect to ADP in SpagoBI
Create reports featuring live ADP data in SpagoBI Studio. Host ADP reports on SpagoBI Server.
-
How to Connect Gong 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 Gong data in real time using natural language.
-
How to Build an ETL App for Beeminder Data in Python with CData
Create ETL applications and real-time data pipelines for Beeminder data in Python with petl.
-
Integrate YouTube Analytics Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live YouTube Analytics data from Informatica Cloud.
-
How to import Google Campaign Manager 360 Data into Apache Solr
Use the CData Software JDBC Driver for Google Campaign Manager 360 in Data Import Handler and create an automated import of Google Campaign Manager 360 data to Apache Solr Enterprise Search platform.
-
Automated Continuous Zoho Creator Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Zoho Creator replication to Amazon S3.
-
Natively Connect to Recurly Data in PHP
The CData ODBC driver for Recurly enables you to create PHP applications with connectivity to Recurly data. Leverage the native support for ODBC in PHP.
-
Import PingOne Data Using Azure Data Factory
Use CData Connect AI to connect to PingOne Data from Azure Data Factory and import live PingOne data.
-
Query, Visualize, and Share live MongoDB Data in Redash
Use CData Connect AI to connect to live MongoDB data in Redash for querying, visualizing, and sharing.
-
Integrate with Factorial Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Factorial data to a JSON file on disk.
-
Connect to QuickBooks Data from PowerBuilder via JDBC
This article demonstrates how to access QuickBooks data from PowerBuilder using the QuickBooks JDBC Driver.
-
Getting Started with the CData ADO.NET Provider for Bullhorn CRM
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Bullhorn CRM.
-
Build Apps with Live Amazon Marketplace Data Using the Low-Code Development Platform of Mendix
Connect Amazon Marketplace data with Mendix to build apps using the CData JDBC Driver for Amazon Marketplace.
-
Search External Testmonitor Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Testmonitor data to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Testmonitor Data objects that you can access from apps and the dashboard.
-
Getting Started with the CData ADO.NET Provider for Front
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Gong Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Gong facts in real time.
-
Getting Started with the CData Tableau Connector for Salesloft
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Salesloft.
-
How to Create Power BI Visual Reports with Real-Time Excel Online Data
Use CData Power BI Connectors to visualize Excel Online data in Power BI.
-
Publish ZohoPeople-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live ZohoPeople data.
-
Analyze Live YouTube Analytics Data in SAS Viya
Use CData Connect AI to connect to YouTube Analytics data from SAS Viya and deploy self-service analytics using live YouTube Analytics data.
-
Publish Optimizely-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Optimizely data.
-
Integrate Real-Time Access to Freshdesk in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Freshdesk data in real time.
-
Access Live Azure Synapse Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Azure Synapse data into the statistical analysis tools available in SAS JMP. This article shows how to use Azure Synapse data in the Graph Builder and Query Builder.
-
Automated Continuous Marketo Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Marketo replication to delimited files (CSV/TSV).
-
Replicate Multiple Adobe Target Accounts via the CData Sync CLI
Replicate multiple Adobe Target accounts to one or many databases.
-
Query Hive Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Hive data from Node.js.
-
Integrate Short.io Data in the Pentaho Report Designer
Publish reports based on Short.io data in the Pentaho BI tool.
-
Write a Simple Go Application to work with Unbounce Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Unbounce data.
-
Connect SAP Ariba Procurement to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect SAP Ariba Procurement with IBM WebSphere for seamless data integration and connectivity.
-
Connect to Printify Data Using the Script Function in Claris FileMaker Pro
Use the CData API Driver for ODBC and the Script function in FileMaker Pro to connect to Printify and work with Printify data in your FileMaker application.
-
Use Grok to Talk to Your Pipedrive Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Grok AI to securely answer questions and take actions on your Pipedrive data for you.
-
Integrate Cursor with Live GraphQL Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live GraphQL data from within the editor.
-
Automated Continuous Helpscout Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Helpscout replication to PostgreSQL.
-
Natively Connect to Google Ads Data in PHP
The CData ODBC driver for Google Ads enables you to create PHP applications with connectivity to Google Ads data. Leverage the native support for ODBC in PHP.
-
How to create Bugsnag federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Bugsnag data in MySQL .
-
Automated Continuous Shortcut Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Shortcut replication to IBM DB2.
-
Connect to CouchDB Data in RapidMiner
Integrate CouchDB data with standard components and data source configuration wizards in RapidMiner Studio.
-
Query Elasticsearch Data as a SQL Server Database in Node.js
Execute SQL Server queries against Elasticsearch data from Node.js.
-
Automated Continuous Teamgate Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Teamgate replication to IBM DB2.
-
Create Power BI Reports on Real-Time Asana Data
Use the CData ODBC Driver for Asana to visualize Asana data in Power BI Desktop.
-
Connect to Exa Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Exa and the SQL Gateway to access Exa data from Google Apps Script.
-
Automate SingleStore Integration Tasks from PowerShell
Are you in search of a quick and easy way to access SingleStore data from PowerShell? This article demonstrates how to utilize the SingleStore Cmdlets for tasks like connecting to SingleStore data, automating operations, downloading data, and more.
-
Replicate Multiple Templated Accounts
Replicate multiple Templated accounts to one or many databases.
-
How to connect to Access Data with Squirrel SQL client
Connect to Access data and execute queries in the Squirrel SQL Client.
-
How to Easily Query CSV Data in OpenOffice Base
Connect to CSV data in OpenOffice Base using the CData ODBC Driver for CSV and generate reports with live data insights.
-
Use the CData Software JDBC Driver for SAP in MicroStrategy Desktop
Connect to SAP data in MicroStrategy Desktop using the CData Software JDBC Driver for SAP.
-
Access Unbounce Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Unbounce data from HeidiSQL.
-
Automate Oracle Data Replication to Azure Synapse
Use CData Sync to customize and automate Oracle data replication to Azure Synapse.
-
Easily Integrate Pushbullet Data in Lazarus Pascal IDE
Learn how to easily integrate live Pushbullet data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Integrate with live Aweber Data in Jitterbit
Use CData Connect AI to connect to and integrate live Aweber data in Jitterbit.
-
Integrate VWO with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate VWO with External Services.
-
Connect Opsgenie to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Opsgenie data using the CData Python MCP Server.
-
Connect to Discord Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Discord and work with Discord data in your FileMaker applications.
-
Build Authorize.Net-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Authorize.Net Data and create custom apps in Mendix.
-
Integrating Kiro with GraphQL 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.
-
Import and Visualize Grafana Data in Power View
Create data visualizations based on Grafana data in Excel.
-
Visualize Live ChargeOver Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live ChargeOver data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Connecting GenSpark with Freshservice Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Freshservice data without any replication or custom integration required.
-
Replicate Elorus Data to Multiple Databases via the CData Sync CLI
Replicate Elorus data to disparate databases with a single configuration.
-
How to Query Live SpaceX Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live SpaceX data data in natural language using Python.
-
Build SAP HANA Visualizations in Tableau Desktop
Use CData Connect AI to connect to live SAP HANA data and build visualizations in Tableau.
-
Create Reports with Azure DevOps Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Azure DevOps data.
-
Use the CData ODBC Driver for SAP Fieldglass from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for SAP Fieldglass to connect to SAP Fieldglass data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring SAP Fieldglass data in Excel.
-
Access Auth0 Data from MySQL in PHP
Connect to Auth0 through the standard MySQL libraries in PHP.
-
How to integrate Gorgias with Apache Airflow
Access and process Gorgias data in Apache Airflow using the CData JDBC Driver.
-
A PostgreSQL Interface for JSON Services (MySQL Remoting via JDBC)
Use the Remoting features of the JSON JDBC Driver to create a PostgreSQL entry-point for data access.
-
How to Access Live ClickUp Data in Power Automate Desktop via ODBC
The CData ODBC Driver for ClickUp enables you to integrate ClickUp data into workflows built using Microsoft Power Automate Desktop.
-
Connect to Google Cloud Storage Data from a Connection Pool in JBoss
Integrate Google Cloud Storage data into Java servlets: Use the Management Console in JBoss to install the Google Cloud Storage JDBC Driver.
-
Model, Search, and Visualize Live SparkPost Data in ThoughtSpot
Use CData Connect AI to connect to live SparkPost data for modeling, searching, and visualizing.
-
Bridge Zoom Connectivity with Apache NiFi
Access and process Zoom data in Apache NiFi using the CData JDBC Driver.
-
Automated Continuous BigCommerce Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable BigCommerce replication to Google Cloud SQL.
-
Connect to Zoho CRM Data from Crystal Reports
Use CData Connect AI to connect to and report on live Zoho CRM data from Crystal Reports.
-
Automated Continuous Amazon Athena Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Amazon Athena replication to Amazon Redshift.
-
Connect to ServiceDesk Plus Data in DBeaver
Use the CData ODBC Driver to connect to ServiceDesk Plus data in DBeaver.