CData Software - Knowledge Base
Recent Articles
-
Connect to Airtable Data in Google Apps Script via Connect AI
Use CData Connect AI to access Airtable data in Google Apps Script.
-
Access Live Shippo Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Shippo data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Access Live Salesforce CRM Analytics 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 Salesforce CRM Analytics data through MCP integration.
-
Migrating data from Databricks to Google BigQuery using CData SSIS Components.
Easily push Databricks data to Google BigQuery using the CData SSIS Tasks for Databricks and Google BigQuery.
-
Query iContact Data as a SQL Server Database in Node.js
Execute SQL Server queries against iContact data from Node.js.
-
Create Informatica Mappings From/To a JDBC Data Source for Freshteam
Create Freshteam data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Excel Spreadsheet Automation on OneNote Data with the QUERY Formula
Pull data from OneNote, automate spreadsheets, and more with the QUERY formula.
-
Replicate Multiple Toggl Accounts via the CData Sync CLI
Replicate multiple Toggl accounts to one or many databases.
-
How to connect and process Couchbase data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Couchbase data.
-
How to connect to Salesloft Data with Squirrel SQL client
Connect to Salesloft data and execute queries in the Squirrel SQL Client.
-
Connect to Campaigner Data from a Connection Pool in JBoss
Integrate Campaigner data into Java servlets: Use the Management Console in JBoss to install the Campaigner JDBC Driver.
-
Design BIRT Reports on AdRoll Data
Provide current AdRoll data to your embedded analytics.
-
Replicate CampaignMonitor Data to Multiple Databases
Replicate CampaignMonitor data to disparate databases with a point-and-click configuration.
-
Integrate Everhour Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Everhour data from Informatica Cloud.
-
Build a Singer.io Tap for Hubstaff With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Hubstaff data using the CData Python Connector.
-
Automated Continuous Dynamics NAV Replication to SingleStore
Use CData Sync for automated, continuous, customizable Dynamics NAV replication to SingleStore.
-
Build an OLAP Cube in SSAS from PhantomBuster Data
Establish a connection to PhantomBuster data data from SQL Server Analysis Services, and use the PhantomBuster Data Provider to build OLAP cubes for use in analytics and reporting.
-
Automated Continuous Placid Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Placid replication to AlloyDB.
-
Natively Connect to Flowlu Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Flowlu data. Leverage the native support for ODBC in PHP.
-
Import and Visualize MySQL Data in Power View
Create data visualizations based on MySQL data in Excel.
-
DataBind Controls to Act-On Data in C++Builder
DataBind to Act-On data in C++Builder with standard components and controls.
-
How to connect to SAP Business One Data with Squirrel SQL client
Connect to SAP Business One data and execute queries in the Squirrel SQL Client.
-
Connect to Printify Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Printify and the SQL Gateway to access Printify data from Google Apps Script.
-
Connect to HDFS Data in Aqua Data Studio
Access HDFS data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
How to Visualize HDFS 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 HDFS data in Python.
-
Automated Continuous Mouseflow Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Mouseflow replication to Apache Cassandra.
-
Use JayDeBeApi to access Rebilly Data in Python
Use standard Python scripting and the development environment of your choice to access live Rebilly data.
-
Connect to xBase Data in JRuby
Create a simple JRuby app with access to live xBase data.
-
Visualize ZohoMarketingHub Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to ZohoMarketingHub data.
-
Access ZohoDesk Data from MySQL in Amazon QuickSight
Connect to ZohoDesk and build visualizations of ZohoDesk data using a MySQL Connection in Amazon QuickSight.
-
How to Connect to & Open QuickBooks Time Data in Microsoft Excel
This article uses the CData ODBC driver for QuickBooks Time to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Access Live Coda Data in Excel 365 Online (Excel for the web)
Connect to Coda data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Deploy the ADO.NET Provider for Factorial on an SSRS Report Server
Connect to Factorial data from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.
-
How to Connect to & Open ZohoSubscriptions Data in Microsoft Excel
This article uses the CData ODBC driver for ZohoSubscriptions to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Migrating data from YouTube Analytics to Snowflake using CData SSIS Components.
Easily push YouTube Analytics data to Snowflake using the CData SSIS Tasks for YouTube Analytics and Snowflake.
-
How to Connect to Live Google Ads 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 Google Ads data for you.
-
Query Supabase Data as a SQL Server Database in Node.js
Execute SQL Server queries against Supabase data from Node.js.
-
Connect to Customer.io in SpagoBI
Create reports featuring live Customer.io data in SpagoBI Studio. Host Customer.io reports on SpagoBI Server.
-
How to connect to Vault CRM Data from IntelliJ
Integrate connectivity to Vault CRM data with wizards in IntelliJ.
-
Connect Basecamp to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Basecamp data using the CData Python MCP Server.
-
Connecting Mastra with Amazon Marketplace Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to enable Mastra agents to securely query, read, and act on real-time Amazon Marketplace data, no replication required.
-
Build DB2-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for DB2 Data and create custom apps in Mendix.
-
Create SurveyMonkey-Connected Business Apps in AppSheet
Connect to SurveyMonkey Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to SurveyMonkey data.
-
How to Build an ETL App for Cosmos DB Data in Python with CData
Create ETL applications and real-time data pipelines for Cosmos DB data in Python with petl.
-
Consume SQL Server OData Feeds in SAP Lumira
Use the API Server to create data visualizations on SQL Server feeds that reflect any changes in SAP Lumira.
-
Integrate Cline with Live SharePoint Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live SharePoint data from within your IDE.
-
How to Query Live Amazon S3 Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Amazon S3 data data in natural language using Python.
-
Visualize Sugar CRM Data in TIBCO Spotfire through ADO.NET
Integrate Sugar CRM data into dashboards in TIBCO Spotfire.
-
Integrate LibreChat with Live Blackbaud FE NXT Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Blackbaud FE NXT data from within the chat interface.
-
Integrate Live Oracle Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Oracle from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Oracle data.
-
Build Dashboards with Drip Data in Dundas BI
Create dynamic dashboards and perform analytics based on Drip data in Dundas BI.
-
Establish a Live Connection with BigQuery Data using Tableau Bridge
The CData ODBC Driver for BigQuery enables you to integrate live BigQuery data into Tableau Cloud dashboards using the Tableau Bridge.
-
How to Connect to Live Freshteam Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Freshteam data securely in real time.
-
Integrating Datadog Data in Talend Cloud Data Management Platform
Connect Datadog Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Working with Gmail Data in LINQPad
Execute LINQ queries to Gmail data in LINQPad.
-
Use CData Connect AI to Access TaxJar Data in Microsoft Power Pivot
Use CData Connect AI to connect to live TaxJar data in the Power Pivot business intelligence tool.
-
Add JotForm Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for JotForm with the Informatica Enterprise Data Catalog to classify and organize data.
-
Model HDFS Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and HDFS, enabling the direct import of real-time HDFS data.
-
Automated Continuous Helpscout Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Helpscout replication to delimited files (CSV/TSV).
-
How to Connect to Live Confluence 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 Confluence data for you.
-
How to integrate Smartsheet with Apache Airflow
Access and process Smartsheet data in Apache Airflow using the CData JDBC Driver.
-
Build Google Ad Manager-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Google Ad Manager data.
-
Use Dash to Build to Web Apps on Codat Data
Create Python applications that use pandas and Dash to build Codat-connected web apps.
-
How to connect and process Splunk data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Splunk data.
-
How to connect PolyBase to Float
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Float data.
-
How to Connect to Live Hive Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Hive data securely in real time.
-
How to load Square data into Elasticsearch via Logstash
Introducing a simple method to load Square data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Use Databricks Agent Bricks to Talk to Your Asana Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Asana data for you.
-
Build Dashboards with Elasticsearch Data in DBxtra
Create dynamic dashboards and perform analytics based on Elasticsearch data in DBxtra.
-
Replicate MailChimp Data to Multiple Databases via the CData Sync CLI
Replicate MailChimp data to disparate databases with a single configuration.
-
Provide OData Services of Front Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Front data by developing a WCF Service Application.
-
Integrate Snowflake with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Snowflake with External Services.
-
Automate Outreach.io Data Replication to Azure Data Lake
Use CData Sync to customize and automate Outreach.io data replication to Azure Data Lake.
-
Automate Apollo Data Replication to Azure Data Lake
Use CData Sync to customize and automate Apollo data replication to Azure Data Lake.
-
Connect to iContact Data from a Connection Pool in JBoss
Integrate iContact data into Java servlets: Use the Management Console in JBoss to install the iContact JDBC Driver.
-
Use Microsoft Copilot Studio to talk to your Samanage Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Microsoft Copilot Studio to securely answer questions and take actions on your Samanage data for you.
-
Integrate Dify with Live Avalara AvaTax Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Dify agents and workflows to securely access and query live Avalara AvaTax data.
-
Connect to SQL Analysis Services Data in JRuby
Create a simple JRuby app with access to live SQL Analysis Services data.
-
Connect Toggl Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Toggl data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Connect to Azure Data Catalog Data in Jaspersoft Studio
Execute SQL to remote Azure Data Catalog data in Jaspersoft Studio.
-
Discord Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Discord facts in real time.
-
Use the CData ODBC Driver for Printify in Microsoft Power Query
You can use the CData Printify ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Printify data into Microsoft Power Query.
-
Connect to Close Data in NetBeans
Connect to Close data in NetBeans with the data source configuration wizard.
-
Connect to Cassandra Data in DBeaver
Use the CData ODBC Driver to connect to Cassandra data in DBeaver.
-
Connecting Agentforce with OData Services via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Agentforce to securely read and take actions on your OData services for you.
-
Publish Procore-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Procore data.
-
Create Twitter Ads-Connected Business Apps in AppSheet
Connect to Twitter Ads Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Twitter Ads data.
-
How to connect to Couchbase Data with Squirrel SQL client
Connect to Couchbase data and execute queries in the Squirrel SQL Client.
-
Connect to ZendeskSell 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 ZendeskSell and work with ZendeskSell data in your FileMaker application.
-
Working with Oracle Eloqua Data in LINQPad
Execute LINQ queries to Oracle Eloqua data in LINQPad.
-
Analyze IBM Informix Data in Looker
Use CData Connect AI to connect to IBM Informix Data from Looker and build custom apps using live IBM Informix data.
-
Integrate QuickBooks Data into Power Automate Desktop using CData Connect
CData Connect for QuickBooks Data enables you to integrate QuickBooks data into workflows built using Microsoft Power Automate Desktop.
-
Replicate Multiple xBase Accounts via the CData Sync CLI
Replicate multiple xBase accounts to one or many databases.
-
Natively Connect to Certinia Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Certinia data. Leverage the native support for ODBC in PHP.
-
Replicate Slack Data from PowerShell
Write a quick PowerShell script to query Slack data. Use connectivity to the live data to replicate Slack data to SQL Server.
-
Create SSAS Tabular Models from SFTP Data
How to build a SQL Server Analysis Service Tabular Model from SFTP data using CData drivers.
-
Build a Simple VCL Application for Insightly Data
How to build a simple VCL Application to view Insightly data in RAD Studio using the CData ODBC Driver for Insightly.
-
How to load ClickUp data into Elasticsearch via Logstash
Introducing a simple method to load ClickUp data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Import and Visualize Salesforce CRM Analytics Data in Power View
Create data visualizations based on Salesforce CRM Analytics data in Excel.
-
Access Azure Table Data from MySQL in PHP
Connect to Azure Table through the standard MySQL libraries in PHP.