CData Software - Knowledge Base
Recent Articles
-
Use the CData Software ODBC Driver for GetResponse in MicroStrategy Desktop
Connect to GetResponse in MicroStrategy Desktop using the CData Software ODBC Driver for GetResponse.
-
How to create Visio diagrams from Email Data
Automatically update Email with the changes you make to Visio master shapes.
-
Automate VWO Integration Tasks from PowerShell
Are you in search of a quick and easy way to access VWO from PowerShell? This article demonstrates how to utilize the VWO Cmdlets for tasks like connecting to VWO, automating operations, downloading data, and more.
-
Integrate Cline with Live Snowflake Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Snowflake from within your IDE.
-
Visualize Gumroad Data in TIBCO Spotfire through OData
Integrate Gumroad into dashboards in TIBCO Spotfire.
-
Build Data Flows from Google Cloud Storage to SQL Server using SSIS
Easily back up Google Cloud Storage to SQL Server using the SSIS components for Google Cloud Storage.
-
Create Active Directory-Connected Business Apps in AppSheet
Connect to Active Directory Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Active Directory.
-
Edit and Search Avaza External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of Avaza to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create Avaza objects that you can access from apps and the dashboard.
-
Create Cassandra Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Cassandra data access from reports, embedded analytics, and more.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed Apache Impala to Power BI dashboards. Simply drag and drop Apache Impala into data visuals on the Power BI canvas.
-
How to connect and process Tanda from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Tanda.
-
Using the CData Software ODBC Driver for Figshare in PyCharm
Connect to Figshare as an ODBC data source in PyCharm using the CData Software ODBC Driver for Figshare.
-
Access Live Jira Assets 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 Jira Assets through MCP integration.
-
How to connect to Reckon Accounts Hosted Data with Squirrel SQL client
Connect to Reckon Accounts Hosted and execute queries in the Squirrel SQL Client.
-
Replicate Trello Data from PowerShell
Write a quick PowerShell script to query Trello. Use connectivity to the live data to replicate Trello to SQL Server.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Couchbase using the Model Context Protocol.
-
How to load Egnyte data into Elasticsearch via Logstash
Introducing a simple method to load Egnyte data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Migrating data from Freshservice to Snowflake using CData SSIS Components.
Easily push Freshservice to Snowflake using the CData SSIS Tasks for Freshservice and Snowflake.
-
Build Semantic Layer Views for ZohoInvoice Data in APOS Live Data Gateway
Use the CData Connector for ZohoInvoice in APOS Live Data Gateway to build Semantic Layer Views for ZohoInvoice.
-
Visualize Adobe Commerce Data in Sisense
Create an ElastiCube in Sisense app with access to Adobe Commerce.
-
How to Connect DBeaver to WooCommerce via a JDBC Driver
Manage WooCommerce with visual tools in DBeaver like the query browser.
-
How to Query Live Tally Data in Claude Desktop
Connect to and query live Tally Data in Claude Desktop using CData MCP Server.
-
Use Databricks Agent Bricks to Talk to Your Freshdesk Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Freshdesk for you.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Oracle Sales
Provide connectivity to Oracle Sales through an SAP BusinessObjects universe.
-
Access Live ActiveCampaign Data in AWS Lambda (with IntelliJ IDEA)
Connect to live ActiveCampaign in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Build Charts with Sage 300 Data in Clear Analytics
Create dynamic charts and perform analytics based on Sage 300 in Clear Analytics.
-
How to integrate SAP Business Warehouse with Apache Airflow
Access and process SAP Business Warehouse in Apache Airflow using the CData JDBC Driver.
-
Build Dashboards with Vimeo Data in Dundas BI
Create dynamic dashboards and perform analytics based on Vimeo in Dundas BI.
-
How to connect and process Oracle Eloqua Reporting from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Oracle Eloqua Reporting.
-
Use the CData Software JDBC Driver for Perigon in MicroStrategy
Connect to Perigon in MicroStrategy Developer using the CData Software JDBC Driver for Perigon.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed CloudConvert to Power BI dashboards. Simply drag and drop CloudConvert into data visuals on the Power BI canvas.
-
How to Connect to & Open Ontraport Data in Microsoft Excel
This article uses the CData ODBC driver for Ontraport to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Create SAP Hybris C4C-Connected Applications in Appsmith
Connect to SAP Hybris C4C Data via CData Connect AI in Appsmith and create custom business applications with real-time access to SAP Hybris C4C.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed Authorize.Net to Power BI dashboards. Simply drag and drop Authorize.Net into data visuals on the Power BI canvas.
-
Getting Started with the CData SSIS Components for Templated
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Templated.
-
Connect to Front Data in DBeaver
Use the CData ODBC Driver to connect to Front in DBeaver.
-
Integrating OpenCode Terminal with Acumatica 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.
-
Use the CData Software JDBC Driver for CSV in MicroStrategy Web
Connect to CSV/TSV Files in MicroStrategy Web using the CData Software JDBC Driver for CSV.
-
Getting Started with the CData Tableau Connector for OnePageCrm
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
A PostgreSQL Interface for Omnisend Data (MySQL Remoting via JDBC)
Use the Remoting features of the Omnisend JDBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to Chargebee Data in CloverDX (formerly CloverETL)
Transfer Chargebee using the visual workflow in the CloverDX data integration tool.
-
Visualize Jira Assets Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Jira Assets.
-
Seamlessly Bring Microsoft Teams Data into Retool Using CData Connect AI
Integrate Microsoft Teams data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Excel Spreadsheet Automation on Google Translate Data with the QUERY Formula
Pull data from Google Translate, automate spreadsheets, and more with the QUERY formula.
-
How to work with Ontraport Data in Apache Spark using SQL
Access and process Ontraport Data in Apache Spark using the CData Software JDBC Driver.
-
Create SAP Ariba Procurement Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time SAP Ariba Procurement data access from reports, embedded analytics, and more.
-
Getting Started with the CData Power BI Connector for JSON
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for JSON.
-
How to update NetSuite from Excel
This article explains how to transfer data from Excel to NetSuite using the Excel Add-In for NetSuite.
-
Connect to Accelo Data in DBeaver
Use the CData ODBC Driver to connect to Accelo in DBeaver.
-
Rapidly Develop Rootly-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 Rootly.
-
Analyze eBay Data in Looker
Use CData Connect AI to connect to eBay Data from Looker and build custom apps using live eBay.
-
Connect to Dropbox Data in Claris FileMaker Pro
Use the CData ODBC Driver for Dropbox in FileMaker Pro to connect to Dropbox and work with Dropbox in your FileMaker applications.
-
How to connect SharePoint with SendInBlue Data through external lists
Provide SendInBlue to SharePoint users as an external list.
-
Automated Continuous MariaDB Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable MariaDB replication to PostgreSQL.
-
Excel Spreadsheet Automation on Google Sheets Data with the QUERY Formula
Pull data from Google Sheets, automate spreadsheets, and more with the QUERY formula.
-
Rapidly Develop Zoho Inventory-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 Zoho Inventory.
-
Working with Gorgias Data in LINQPad
Execute LINQ queries to Gorgias in LINQPad.
-
Analyze Google Contacts Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Google Contacts and visualize live Google Contacts in Infragistics Reveal.
-
Create Data Visualizations Based On Slack Data in Mode
Use CData Connect AI to connect to Slack Data from Mode and build visualizations using live
-
Connect to GitLab Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live GitLab from Filemaker Pro on Mac.
-
Getting Started with the CData ADO.NET Provider for Outreach.io
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Outreach.io.
-
Working with Gumroad Data in LINQPad
Execute LINQ queries to Gumroad in LINQPad.
-
Natively Connect to Simplesat Data in PHP
The CData ODBC driver for Simplesat enables you to create PHP applications with connectivity to Simplesat. Leverage the native support for ODBC in PHP.
-
Build Dashboards with SharePoint Data in DBxtra
Create dynamic dashboards and perform analytics based on Microsoft SharePoint in DBxtra.
-
Analyze LinkedIn Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of LinkedIn and visualize live LinkedIn in Infragistics Reveal.
-
Query Live Azure Synapse 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 Azure Synapse directly from the development environment.
-
Getting Started with the CData Tableau Connector for AgileCRM
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Establish a Live Connection with Google Campaign Manager 360 Data using Tableau Bridge
The CData ODBC Driver for Google Campaign Manager 360 enables you to integrate live Google Campaign Manager 360 into Tableau Cloud dashboards using the Tableau Bridge.
-
Access Live TaxJar Data in AWS Lambda
Connect to live TaxJar in AWS Lambda using the CData JDBC Driver.
-
Query Live Adobe Analytics 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 Adobe Analytics directly from the development environment.
-
Feed BigQuery Data into FineReport
How to set Google BigQuery as a JDBC data source in FineReport.
-
Model, Search, and Visualize Live Email Data in ThoughtSpot
Use CData Connect AI to connect to live Email for modeling, searching, and visualizing.
-
Build FreshBooks-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to FreshBooks Data from Zoho Analytics and import live FreshBooks.
-
Integrating Claude Code CLI with ElevenLabs 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.
-
Access Live Access Data in TIBCO Data Virtualization
Use the Access Tibco DV Adapter to create a Microsoft Access data source in TIBCO Data Virtualization Studio and gain access to live Microsoft Access from your TDV Server.
-
Connect Zoho Recruit to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Zoho Recruit with IBM WebSphere for seamless data integration and connectivity.
-
How to Seamlessly Import Ontraport Data into IBM SPSS Modeler
Integrate Ontraport data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Connect to VWO Data in JRuby
Create a simple JRuby app with access to live VWO.
-
Natively Connect to ZendeskSell Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to ZendeskSell. Leverage the native support for ODBC in PHP.
-
Connect to Google Forms from a Connection Pool in WebLogic
Use the CData JDBC Driver for Google Forms to connect to Google Forms from Web applications running on WebLogic.
-
Build a PostgreSQL Interface for SQL Server Data using the CData JDBC Driver
Use the Remoting features of the SQL Server JDBC Driver to create a PostgreSQL entry-point for data access.
-
Automated Continuous YouTube Analytics Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable YouTube Analytics replication to OneLake in Microsoft Fabric.
-
A PostgreSQL Interface for Eventbrite Data (MySQL Remoting via JDBC)
Use the Remoting features of the Eventbrite JDBC Driver to create a PostgreSQL entry-point for data access.
-
How to integrate Metabase with Azure Data Lake Storage Data
Use CData Connect AI to connect to live Azure Data Lake Storage and create an interactive dashboard in Metabase from Azure Data Lake Storage.
-
Analyze LeadDesk Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of LeadDesk and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Automated Continuous Unbounce Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Unbounce replication to Google BigQuery.
-
Use the CData Software ODBC Driver for PhantomBuster in MicroStrategy Web
Connect to PhantomBuster in MicroStrategy Web using the CData Software ODBC Driver for PhantomBuster.
-
Natively Connect to Brex Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Brex. Leverage the native support for ODBC in PHP.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed SpaceX to Power BI dashboards. Simply drag and drop SpaceX into data visuals on the Power BI canvas.
-
Build Dashboards with Facebook Data in Dundas BI
Create dynamic dashboards and perform analytics based on Facebook in Dundas BI.
-
Consume RabbitMQ OData Feeds in PowerBuilder
This article demonstrates how to consume RabbitMQ as OData feeds from PowerBuilder using the API Server.
-
Query Keap Data as a MySQL Database in Node.js
Execute MySQL queries against Keap from Node.js.
-
Use the CData Software JDBC Driver for ZohoSubscriptions in MicroStrategy Web
Connect to ZohoSubscriptions in MicroStrategy Web using the CData Software JDBC Driver for ZohoSubscriptions.
-
Build a PostgreSQL Interface for ClickUp Data using the CData JDBC Driver
Use the Remoting features of the ClickUp JDBC Driver to create a PostgreSQL entry-point for data access.
-
Publish Exa-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Exa.
-
Create Reports with Toggl Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Toggl.
-
Automated Continuous Teradata Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Teradata replication to Google Cloud SQL.
-
Integrating Codex CLI with Quickbase 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.
-
Automate Hive Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live Apache Hive and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
How to Query Live Freshservice Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Freshservice data in natural language using Python.