CData Software - Knowledge Base
Recent Articles
-
Getting Started with the CData SSIS Components for SAP HANA XS Advanced
Complete guide to installing, licensing, and connecting with the CData SSIS Components for SAP HANA XS Advanced.
-
How to Connect to & Open Outreach.io Data in Microsoft Excel
This article uses the CData ODBC driver for Outreach.io to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Create Dynamic JSON Grids Using the Infragistics XamDataGrid
Learn how you can connect JSON to Infragistics XamDataGrid to build dynamic grids.
-
Create Apps from ZohoPeople Data in Qlik Sense Cloud
Use CData Connect AI to connect to ZohoPeople Data and build apps from live ZohoPeople data in Qlik Sense Cloud.
-
How to import Mailgun Data into Apache Solr
Use the CData Software JDBC Driver for Mailgun in Data Import Handler and create an automated import of Mailgun data to Apache Solr Enterprise Search platform.
-
Model Box Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Box, enabling the direct import of real-time Box data.
-
Connect to Dynamics 365 Data in CloverDX (formerly CloverETL)
Transfer Dynamics 365 data using the visual workflow in the CloverDX data integration tool.
-
How to work with Salesforce Marketing Data in Apache Spark using SQL
Access and process Salesforce Marketing Data in Apache Spark using the CData Software JDBC Driver.
-
Connect to Discourse Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Discourse and the SQL Gateway to access Discourse data from Google Apps Script.
-
ETL JotForm in Oracle Data Integrator
This article shows how to transfer JotForm data into a data warehouse using Oracle Data Integrator.
-
Getting Started with the CData ODBC Driver for ADP
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for ADP.
-
Automated Continuous Mocean Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Mocean replication to Apache Kafka.
-
Consume Salesloft OData Feeds in PowerBuilder
This article demonstrates how to consume Salesloft data as OData feeds from PowerBuilder using the API Server.
-
Visualize Live Invoiced Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Invoiced data.
-
Import and Visualize Missive Data in Power View
Create data visualizations based on Missive data in Excel.
-
How to Access Live LightSpeedRetail Data in Power Automate Desktop via ODBC
The CData ODBC Driver for LightSpeedRetail enables you to integrate LightSpeedRetail data into workflows built using Microsoft Power Automate Desktop.
-
Connecting Agentforce with Exa Data 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 Exa data for you.
-
A PostgreSQL Interface for PayPal Data (MySQL Remoting via JDBC)
Use the Remoting features of the PayPal JDBC Driver to create a PostgreSQL entry-point for data access.
-
Extract, Transform, and Load ClickUp Data in Informatica PowerCenter
Create a simple Workflow for ClickUp data in Informatica PowerCenter.
-
Query Zoho Books Data as a MySQL Database in Node.js
Execute MySQL queries against Zoho Books data from Node.js.
-
Integrate Redshift with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Redshift with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Redshift data.
-
Access Live Salesforce Pardot 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 Pardot data through MCP integration.
-
Getting Started with the CData Power BI Connector for VWO
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Connect to Basecamp from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Basecamp data, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Replicate Multiple Tickspot Accounts
Replicate multiple Tickspot accounts to one or many databases.
-
Integrate Unbounce Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Unbounce data from Informatica Cloud.
-
Automated Continuous LightSpeedRetail Replication to SQLite
Use CData Sync for automated, continuous, customizable LightSpeedRetail replication to SQLite.
-
How to Connect to Live Salesforce CRM Analytics Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Salesforce CRM Analytics data securely in real time.
-
View Reports on Real-Time Insightly Data in Power BI Report Server
Use the CData ODBC Driver for Insightly to visualize Insightly data in Power BI Desktop and then publish them to Power BI Report Server.
-
How to connect to ChartMogul Data with Squirrel SQL client
Connect to ChartMogul data and execute queries in the Squirrel SQL Client.
-
Use the CData Software JDBC Driver for Exa in MicroStrategy
Connect to Exa data in MicroStrategy Developer using the CData Software JDBC Driver for Exa.
-
Connect to and Visualize Live Pinecone Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Pinecone data.
-
Create Informatica Mappings From/To an ODBC Data Source for Insightly
Create an ODBC connection to Insightly in Informatica and browse and transfer Insightly data.
-
Excel Spreadsheet Automation on Oracle Sales Data with the QUERY Formula
Pull data from Oracle Sales, automate spreadsheets, and more with the QUERY formula.
-
Short.io Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Short.io facts in real time.
-
Process & Analyze BambooHR Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live BambooHR Data.
-
Write a Simple Go Application to work with Highrise Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Highrise data.
-
Use the CData Software ODBC Driver for PolarTeamPro in SAS for Real-Time Reporting and Analytics
Connect to real-time PolarTeamPro data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for PolarTeamPro.
-
Build AI Agents with SuiteCRM Data in IBM watsonx Orchestrate using CData Connect AI
Learn how to build intelligent agents in IBM watsonx Orchestrate that can securely access and act on live SuiteCRM data through CData Connect AI.
-
How to connect to Intercom Data in DBVisualizer
Integrate Intercom data with visual data analysis tools and data connection wizards in DBVisualizer
-
Automated Continuous Vertica Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Vertica replication to Amazon Redshift.
-
How to Connect to Live Stripe Data from crewAI Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable crewAI agents to securely read and take actions on your Stripe data for you.
-
Import Attio Data Using Azure Data Factory
Use CData Connect AI to connect to Attio Data from Azure Data Factory and import live Attio data.
-
Automated Continuous Microsoft Ads Replication to SQL Server
Use CData Sync for automated, continuous, customizable Microsoft Ads replication to SQL Server.
-
Natively Connect to CockroachDB Data in PHP
The CData ODBC driver for CockroachDB enables you to create PHP applications with connectivity to CockroachDB data. Leverage the native support for ODBC in PHP.
-
Access Live Avro Data in Coginiti Pro
Connect to and query live Avro data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Integrate FormSite with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate FormSite with External Services.
-
Replicate Excel Data in Heroku for Use in Salesforce Connect
Replicate Excel data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Build Visualizations of Azure Data Lake Storage Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Azure Data Lake Storage data in Birst.
-
Connect to Azure Analysis Services from a Connection Pool in WebLogic
Use the CData JDBC Driver for Azure Analysis Services to connect to Azure Analysis Services data from Web applications running on WebLogic.
-
How to integrate Metabase with WordPress Data
Use CData Connect AI to connect to live WordPress data and create an interactive dashboard in Metabase from WordPress data.
-
Automated Retently Data Replication to Teradata
Use CData Sync to Customize and automate Retently data replication to Teradata.
-
Create QuickBooks-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to QuickBooks Data from OutSystems and build custom enterprise apps using live QuickBooks data.
-
Interact with Live Google Drive Data in Meta Muse via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Muse to securely interact with live Google Drive data.
-
Automated Continuous Rootly Replication to Snowflake
Use CData Sync for automated, continuous, customizable Rootly replication to Snowflake.
-
Enable the Browserless JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Browserless data.
-
Build an OLAP Cube in SSAS from Wave Financial Data
Establish a connection to Wave Financial data data from SQL Server Analysis Services, and use the Wave Financial Data Provider to build OLAP cubes for use in analytics and reporting.
-
How to Build an ETL App for ServiceNow Data in Python with CData Connect AI
Extract and transform live ServiceNow data in Python with petl and the CData Connect AI Python SDK.
-
Getting Started with the CData Excel Add-In for NASA
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for NASA.
-
Integrating Dataiku with Google Analytics 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 Analytics data.
-
Build Semantic Layer Views for Azure Analysis Services Data in APOS Live Data Gateway
Use the CData Connector for Azure Analysis Services in APOS Live Data Gateway to build Semantic Layer Views for Azure Analysis Services data.
-
Automated Continuous Klaviyo Replication to MySQL
Use CData Sync for automated, continuous, customizable Klaviyo replication to MySQL.
-
Rapidly Develop Google Contacts-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 Google Contacts.
-
Connect to Microsoft Ads Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Microsoft Ads data in the Denodo Virtual DataPort Administrator.
-
Connect to Tally Data from a Connection Pool in Jetty
The Tally JDBC Driver supports connection pooling: This article shows how to connect faster to Tally data from Web apps in Jetty.
-
How to Query Live Lakebase Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Lakebase data data in natural language using Python.
-
Trigger Databricks IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for Databricks with standard wizards in Logic Apps.
-
Create Reports from Smartsheet Data in Looker Studio
Use CData Connect AI to gain access to live Smartsheet data and create custom reports in Looker Studio.
-
Choosing the Best Method to Connect Dropbox to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Dropbox data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
A PostgreSQL Interface for Square Data using the CData ODBC Driver
Use the SQL Gateway and Square ODBC Driver to create a PostgreSQL entry-point for data access.
-
Replicate Odoo Data to Multiple Databases via the CData Sync CLI
Replicate Odoo data to disparate databases with a single configuration.
-
Connect to OneNote Data in Google Apps Script via Connect AI
Use CData Connect AI to access OneNote data in Google Apps Script.
-
Replicate Multiple Timely Accounts via the CData Sync CLI
Replicate multiple Timely accounts to one or many databases.
-
How to Connect to Live Acumatica 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 Acumatica data for you.
-
How to Connect to Live BigQuery 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 BigQuery data for you.
-
Visualize Live AfterShip Data in the Power BI Service
Use CData Connect AI to connect to live AfterShip data and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Replicate Multiple RabbitMQ Accounts
Replicate multiple RabbitMQ accounts to one or many databases.
-
Connect to ConvertKit Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to ConvertKit.
-
Integrate with Google Ads Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Google Ads data to a JSON file on disk.
-
How to Visualize FHIR 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 FHIR data in Python.
-
Access Coda Data in Mule Applications Using the CData JDBC Driver
Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for Coda data.
-
Access Google Calendar Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Google Calendar data from HeidiSQL.
-
Migrating data from Customer.io to Databricks using CData SSIS Components.
Easily push Customer.io data to Databricks using the CData SSIS Tasks for Customer.io and Databricks.
-
Migrating data from Planio to Snowflake using CData SSIS Components.
Easily push Planio data to Snowflake using the CData SSIS Tasks for Planio and Snowflake.
-
Analyze SAP Business One Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of SAP Business One data and visualize SAP Business One data in SAP Analytics Cloud.
-
DataBind Charts to Splunk Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Splunk data 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.
-
Automated Continuous Excel Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Excel replication to Apache Cassandra.
-
Connect to Freshservice Data from Crystal Reports
Use CData Connect AI to connect to and report on live Freshservice data from Crystal Reports.
-
Visualize Oracle Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Oracle data.
-
How to Connect to Live ShipStation Data from OpenAI Python Applications (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable OpenAI-powered Python applications to securely read and take actions on your ShipStation data through natural language.
-
Connect to AlloyDB Data in DBeaver
Use the CData ODBC Driver to connect to AlloyDB data in DBeaver.
-
Building Dynamic Web Pages with Zoho Books Data Using AngularJS
Create single-page applications with live connectivity to Zoho Books using the CData API Server.
-
Replicate Multiple NetSuite SuiteAnalytics Accounts via the CData Sync CLI
Replicate multiple NetSuite SuiteAnalytics accounts to one or many databases.
-
Query Live Stripe Data in Zed Editor via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Zed Editor to securely access and query live Stripe data directly from the development environment.
-
How to Connect to Live MarkLogic 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 MarkLogic data for you.
-
LINQ to Jumpseller 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 Jumpseller Data Provider.
-
Connect to Raisers Edge NXT Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Raisers Edge NXT data.
-
Automated Continuous WooCommerce Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable WooCommerce replication to delimited files (CSV/TSV).
-
Connect to Parallel Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Parallel data.
-
How to Access JSON Services Using Entity Framework
This article shows how to access JSON services using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.