CData Software - Knowledge Base
Recent Articles
-
How to Create Power BI Visual Reports with Real-Time ZarMoney Data
Use CData Power BI Connectors to visualize ZarMoney in Power BI.
-
Replicate ZarMoney Data from PowerShell
Write a quick PowerShell script to query ZarMoney. Use connectivity to the live data to replicate ZarMoney to SQL Server.
-
Add SQL Analysis Services Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for SQL Analysis Services with the Informatica Enterprise Data Catalog to classify and organize data.
-
Integrating Claude Code with Azure Synapse Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Azure Synapse within assisted coding and automated development workflows.
-
Automated Continuous Unbounce Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Unbounce replication to delimited files (CSV/TSV).
-
Query Azure Table Data as a SQL Server Database in Node.js
Execute SQL Server queries against Azure Table Storage from Node.js.
-
Access Live Microsoft Ads Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Microsoft Ads in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Integrating Amazon Marketplace Data in Talend Cloud Data Management Platform
Connect Amazon Marketplace Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Amazon Marketplace.
-
Automated Continuous LinkedIn Replication to Oracle
Use CData Sync for automated, continuous, customizable LinkedIn replication to Oracle.
-
View Reports on Real-Time Dropbox Data in Power BI Report Server
Use the CData ODBC Driver for Dropbox to visualize Dropbox in Power BI Desktop and then publish them to Power BI Report Server.
-
Automated Continuous Klipfolio Replication to Oracle
Use CData Sync for automated, continuous, customizable Klipfolio replication to Oracle.
-
Building Dynamic Web Pages with Raisers Edge NXT Data Using AngularJS
Create single-page applications with live connectivity to Raisers Edge NXT using the CData API Server.
-
Connect to Greenhouse Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Greenhouse as an External Source in Dremio.
-
How to connect to Ontraport Data in DBVisualizer
Integrate Ontraport with visual data analysis tools and data connection wizards in DBVisualizer
-
Automated Continuous IBM Cloud Object Storage Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable IBM Cloud Object Storage replication to Google Cloud SQL.
-
Connect LightSpeedRetail Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your LightSpeedRetail using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Connect to Impala Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Impala and the SQL Gateway to access Apache Impala from Google Apps Script.
-
Build Agents in Relevance AI with Access to Live Procore Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Procore within intelligent agent workflows.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Helpscout
Provide connectivity to Helpscout through an SAP BusinessObjects universe.
-
Add Rebilly Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Rebilly with the Informatica Enterprise Data Catalog to classify and organize data.
-
Connect to PagerDuty Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Back Up Zoho Inventory to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Zoho Inventory. In this article, we will employ an SSIS workflow to populate a database with Zoho Inventory data.
-
Access Live Dynamics NAV Data in AWS Lambda
Connect to live Microsoft Dynamics NAV in AWS Lambda using the CData JDBC Driver.
-
Model, Search, and Visualize Live ServiceNow Data in ThoughtSpot
Use CData Connect AI to connect to live ServiceNow for modeling, searching, and visualizing.
-
Publish Reports with SAP SuccessFactors Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date SAP SuccessFactors.
-
Analyze Azure DevOps Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Azure DevOps with the CData JDBC Driver for Azure DevOps.
-
Getting Started with the CData Tableau Connector for PabblySubscriptions
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Access Live Odoo Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live Odoo data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Connect to ZohoMarketingHub Data from a Connection Pool in JBoss
Integrate ZohoMarketingHub into Java servlets: Use the Management Console in JBoss to install the ZohoMarketingHub JDBC Driver.
-
Analyze Qualaroo Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Qualaroo from Power Pivot. You will use the Table Import Wizard to load Qualaroo. You can visually build the import query or use any SQL supported by the driver.
-
Build OData-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData MCP Server for OData to explore live OData Services in GitHub Copilot to assist with building OData-powered applications.
-
How to Connect Marketo 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 Marketo data in real time using natural language.
-
Replicate ZohoInvoice Data to Multiple Databases via the CData Sync CLI
Replicate ZohoInvoice to disparate databases with a single configuration.
-
Connect to Hubstaff Data in Aqua Data Studio
Access Hubstaff from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Getting Started with the CData Python Connector for Quaderno
Learn to install and license the CData Python Connector
-
Build Dashboards with Phoenix Data in DBxtra
Create dynamic dashboards and perform analytics based on Apache Phoenix in DBxtra.
-
Use JayDeBeApi to access Salesforce Pardot Data in Python
Use standard Python scripting and the development environment of your choice to access live Salesforce Pardot.
-
Connect to Intercom Data in DBArtisan
Use wizards in DBArtisan to configure Intercom as a data source.
-
Migrating data from Facebook to Google BigQuery using CData SSIS Components.
Easily push Facebook to Google BigQuery using the CData SSIS Tasks for Facebook and Google BigQuery.
-
Create Datasets from Tanda in Domo Workbench and Build Visualizations of Tanda Data in Domo
Use the CData Software ODBC Driver for Tanda to create datasets from Tanda in Domo Workbench and then build visualizations in the Domo service.
-
Use the CData Software ODBC Driver for Microsoft Teams in MicroStrategy Desktop
Connect to Microsoft Teams in MicroStrategy Desktop using the CData Software ODBC Driver for Microsoft Teams.
-
Build Dashboards with SparkPost Data in Dundas BI
Create dynamic dashboards and perform analytics based on SparkPost in Dundas BI.
-
Build Gmail-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Gmail.
-
Access Live Act CRM Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Act CRM from your Excel spreadsheets.
-
Visualize Moosend Data in TIBCO Spotfire through ADO.NET
Integrate Moosend into dashboards in TIBCO Spotfire.
-
Connect AI Guide: Derived Views, Saved Queries, and Custom Reports
A basic guide to creating Derived Views, Saved Queries, and Custom Reports in Connect AI.
-
How to create an RPA flow for Instagram Data in UiPath Studio
Use the Instagram ODBC Driver to create workflows that access real-time Instagram without any coding.
-
Connect to Discord Data in CloverDX (formerly CloverETL)
Transfer Discord using the visual workflow in the CloverDX data integration tool.
-
How to create Brex federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Brex in MySQL .
-
How to connect to Flowlu Data in DBVisualizer
Integrate Flowlu with visual data analysis tools and data connection wizards in DBVisualizer
-
Build FreshBooks Visualizations in Tableau Desktop
Use CData Connect AI to connect to live FreshBooks and build visualizations in Tableau.
-
Analyze MySQL Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of MySQL and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Getting Started with the CData Python Connector for Amazon DynamoDB
Learn to install and license the CData Python Connector
-
Use the CData Software JDBC Driver for Adobe Target in MicroStrategy Desktop
Connect to Adobe Target in MicroStrategy Desktop using the CData Software JDBC Driver for Adobe Target.
-
Integrate PolarTeamPro Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live PolarTeamPro from Informatica Cloud.
-
Connect to Airtable Data in Jaspersoft Studio
Execute SQL to remote Airtable in Jaspersoft Studio.
-
Create SAS xpt-Connected Nintex Workflows
Use CData Connect AI to connect to SAS xpt Data from Nintex Workflow Cloud and build custom workflows using live SAS XPORT.
-
ZohoPeople Reporting in OBIEE with the ZohoPeople JDBC Driver
Deploy the ZohoPeople JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Integrating Clari Data in Talend Cloud Data Management Platform
Connect Clari Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Publish Reports with MailerLite Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date MailerLite.
-
Getting Started with the CData Power BI Connector for SendPulse
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Choosing the Best Method to Connect Google Spanner to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Google Spanner from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Query ActiveCampaign Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume ActiveCampaign entities in PHP by modeling them as objects.
-
Connect to Azure Synapse Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Establish a Live Connection with SAP Business One Data using Tableau Bridge
The CData ODBC Driver for SAP Business One enables you to integrate live SAP Business One into Tableau Cloud dashboards using the Tableau Bridge.
-
How to create MessageBird federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for MessageBird in MySQL .
-
How to Query Live Klipfolio Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Klipfolio data in natural language using Python.
-
Connect to Wistia Data from PowerBuilder via JDBC
This article demonstrates how to access Wistia from PowerBuilder using the Wistia JDBC Driver.
-
Use the CData ODBC Driver for Pushbullet in Microsoft Power Query
You can use the CData Pushbullet ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Pushbullet into Microsoft Power Query.
-
Configure the CData JDBC Driver for Discord in a Connection Pool in Tomcat
Connect to Discord from a connection pool in Tomcat.
-
Automated Continuous Float Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Float replication to AlloyDB.
-
Connect to Azure Table Data in DBArtisan
Use wizards in DBArtisan to configure Azure Table Storage as a data source.
-
Work with Live EnterpriseDB Data in Power Query
Use CData Connect AI to connect to EnterpriseDB and work with live EnterpriseDB in Microsoft Power Query.
-
Build BigCommerce-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live BigCommerce.
-
Integrating Codex CLI with Parallel 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 Xero Data in JReport Designer
Create charts and reports based on Xero Accounting in JReport Designer.
-
Connect to Real-Time Foursquare Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Foursquare in Power Apps.
-
How to Seamlessly Import AgileCRM Data into IBM SPSS Modeler
Integrate AgileCRM data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Bridge LinkedIn Ads Connectivity with Apache NiFi
Access and process LinkedIn Ads in Apache NiFi using the CData JDBC Driver.
-
Integrate Cline with Live Amazon S3 Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Amazon S3 from within your IDE.
-
Connecting Moonlit Workflow with Zoho Inventory Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Moonlit workflows to securely read and act on your Zoho Inventory in real time.
-
Automate MYOB AccountRight Data Replication to Azure Data Lake
Use CData Sync to customize and automate MYOB AccountRight replication to Azure Data Lake.
-
Automated Continuous DocuSign Replication to AlloyDB
Use CData Sync for automated, continuous, customizable DocuSign replication to AlloyDB.
-
How to load Vault CRM data into Elasticsearch via Logstash
Introducing a simple method to load Vault CRM data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Connect to Salesforce CRM Analytics Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Salesforce CRM Analytics and the SQL Gateway to access Salesforce CRM Analytics from Google Apps Script.
-
Connect to Cohere Data in NetBeans
Connect to Cohere in NetBeans with the data source configuration wizard.
-
Provide OData Services of Aweber Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Aweber by developing a WCF Service Application.
-
Use the CData Software ODBC Driver for Stack Exchange in MicroStrategy Web
Connect to Stack Exchange in MicroStrategy Web using the CData Software ODBC Driver for Stack Exchange.
-
Query Instagram Data as a SQL Server Database in Node.js
Execute SQL Server queries against Instagram from Node.js.
-
Build Visualizations of QuickBooks Online Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of QuickBooks Online in Birst.
-
Access SurveyMonkey Data from MySQL in PHP
Connect to SurveyMonkey through the standard MySQL libraries in PHP.
-
Visualize Drift Data in Tableau
The CData ODBC driver for Drift enables you integrate Drift into Tableau dashboards.
-
Import SAP Ariba Procurement Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access SAP Ariba Procurement. In this article, you will use the OData format to import SAP Ariba Procurement into Microsoft Power Query.
-
Create Reckon Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Reckon from PowerBI.com to create Power BI Dataflows with real-time data.
-
Automated Continuous Omnisend Replication to SingleStore
Use CData Sync for automated, continuous, customizable Omnisend replication to SingleStore.
-
Integrating OpenCode Terminal with CSV 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 LibreChat with Live Oracle Financials Cloud Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Oracle Financials Cloud from within the chat interface.
-
How to Connect to & Open Salesforce CRM Analytics Data in Microsoft Excel
This article uses the CData ODBC driver for Salesforce CRM Analytics to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Connect and Visualize Live Outreach.io Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Outreach.io into the Databricks platform and create visualization dashboards with real-time Outreach.io.
-
Connect to Cassandra Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Cassandra and the SQL Gateway to access Apache Cassandra from Google Apps Script.