CData Software - Knowledge Base
Recent Articles
-
How to Create Power BI Visual Reports with Real-Time Tavily Data
Use CData Power BI Connectors to visualize Tavily in Power BI.
-
Edit and Search NetSuite External Objects in Salesforce
Consume NetSuite objects in Salesforce filter lists.
-
Establish a Live Connection with Short.io Data using Tableau Bridge
The CData ODBC Driver for Short.io enables you to integrate live Short.io into Tableau Cloud dashboards using the Tableau Bridge.
-
Automated Continuous LinkedIn Ads Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable LinkedIn Ads replication to OneLake in Microsoft Fabric.
-
Use the CData Software JDBC Driver for Twilio in MicroStrategy
Connect to Twilio in MicroStrategy Developer using the CData Software JDBC Driver for Twilio.
-
Extend Google Sheets with Power BI XMLA Data
Make calls to Power BI XMLA from Google Apps Script via the API Server.
-
Create Power BI Reports on Real-Time FTP Data
Use the CData ODBC Driver for FTP to visualize FTP Servers in Power BI Desktop.
-
How to create Superchat federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Superchat in MySQL .
-
Automated Continuous Airtable Replication to SingleStore
Use CData Sync for automated, continuous, customizable Airtable replication to SingleStore.
-
Analyze Dynamics 365 Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Microsoft Dynamics 365 in Microsoft R Open.
-
Create Power BI Reports on Real-Time Azure Synapse Data
Use the CData ODBC Driver for Azure Synapse to visualize Azure Synapse in Power BI Desktop.
-
How to publish and share AlloyDB Data dashboards with Tableau Server
The CData ODBC driver for AlloyDB enables you integrate Google AlloyDB into Tableau dashboards.
-
Migrating data from Dynamics CRM to Databricks using CData SSIS Components.
Easily push Microsoft Dynamics CRM to Databricks using the CData SSIS Tasks for Dynamics CRM and Databricks.
-
Integrating Cursor CLI with Zoho Inventory 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.
-
Automated Continuous Dynamics 365 Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Dynamics 365 replication to Azure SQL Database.
-
Import SAP Ariba Source Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to SAP Ariba Source Data and provide access to live SAP Ariba Source for custom reports in the Power BI Service.
-
Access ADP Data from MySQL in Amazon QuickSight
Connect to ADP and build visualizations of ADP using a MySQL Connection in Amazon QuickSight.
-
Analyze Coinbase Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Coinbase with the CData JDBC Driver for Coinbase.
-
Design BIRT Reports on Browserless Data
Provide current Browserless to your embedded analytics.
-
Connect to Sage 300 Data in Jaspersoft Studio
Execute SQL to remote Sage 300 in Jaspersoft Studio.
-
Use JayDeBeApi to access Recurly Data in Python
Use standard Python scripting and the development environment of your choice to access live Recurly.
-
Use Claude to Talk to Your ActiveCampaign Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your ActiveCampaign for you.
-
How to Connect to AdRoll Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to AdRoll. Leverage the pyodbc module for ODBC in Python.
-
Build Visualizations of FormSite Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of FormSite in Birst.
-
Publish Reports with JotForm Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date JotForm.
-
Getting Started with the CData Excel Add-In for Microsoft Entra ID
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Microsoft Entra ID.
-
How to import Cloudflare Data into Apache Solr
Use the CData Software JDBC Driver for Cloudflare in Data Import Handler and create an automated import of Cloudflare to Apache Solr Enterprise Search platform.
-
Build Exact Online-Powered Applications in Gemini Code Assist with CData MCP Server
Use the CData MCP Server for Exact Online to explore live Exact Online Data in Gemini Code Assist to assist with building Exact Online-powered applications.
-
Build Automated Workflows with Live HBase Data in Workato
Use CData Connect AI to connect to live Apache HBase and build automated workflows in Workato.
-
Easily Integrate Google Tasks Data in Lazarus Pascal IDE
Learn how to easily integrate live Google Tasks in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
How to Query Live Retently Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Retently data in natural language using Python.
-
Natively Connect to Confluence Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Atlassian Confluence. Leverage the native support for ODBC in PHP.
-
Integrating Kiro CLI with Certinia 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.
-
Connect to Salesforce Pardot Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Salesforce Pardot in Airbyte.
-
Establish a Live Connection with Google Ads Data using Tableau Bridge
The CData ODBC Driver for Google Ads enables you to integrate live Google Ads into Tableau Cloud dashboards using the Tableau Bridge.
-
How to Work with AgileCRM Data in AWS Glue Jobs Using JDBC
Connect to AgileCRM from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Integrating Claude Code with Active Directory Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Active Directory within assisted coding and automated development workflows.
-
How to Seamlessly Import Freshsales Data into IBM SPSS Modeler
Integrate Freshsales data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Query Authorize.Net Data from Node.js
Use the OData endpoint of the CData API Server to connect to your Authorize.Net and perform CRUD operations on Authorize.Net from Node.js.
-
Import Snowflake Data Using Azure Data Factory
Use CData Connect AI to connect to Snowflake Data from Azure Data Factory and import live Snowflake.
-
Prepare, Blend, and Analyze Jira Data in Alteryx Designer (Connect AI)
Build workflows to access live Atlassian Jira for self-service data analytics.
-
Create Reports from Sage Cloud Accounting Data in Looker Studio
Use CData Connect AI to gain access to live Sage Business Cloud Accounting and create custom reports in Looker Studio.
-
Process & Analyze QuickBooks Time Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live QuickBooks Time Data.
-
Visualize Auth0 Data in Tableau
The CData ODBC driver for Auth0 enables you integrate Auth0 into Tableau dashboards.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Apache Hive within intelligent workflows.
-
Work with Cloudant Data in FoxPro
Load IBM Cloudant into a FoxPro database. This article includes full code and a walk-through of the process.
-
Bridge LaunchDarkly Connectivity with Apache NiFi
Access and process LaunchDarkly in Apache NiFi using the CData JDBC Driver.
-
Import Real-Time QuickBooks Online Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use QuickBooks Online in ColdFusion.
-
Creating Active Directory-Connected Applications in Unqork
You can use CData Connect AI to feed Active Directory to Unqork and build custom business apps.
-
How to Connect to & Open MarkLogic Data in Microsoft Excel
This article uses the CData ODBC driver for MarkLogic to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Add Sage Cloud Accounting Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Sage Cloud Accounting with the Informatica Enterprise Data Catalog to classify and organize data.
-
Build a PostgreSQL Interface for Epicor Kinetic Data using the CData JDBC Driver
Use the Remoting features of the Epicor Kinetic JDBC Driver to create a PostgreSQL entry-point for data access.
-
Build AI Agents with Apollo 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 Apollo through CData Connect AI.
-
How to create an RPA flow for Wave Financial Data in UiPath Studio
Use the Wave Financial ODBC Driver to create workflows that access real-time Wave Financial without any coding.
-
Connect to Shortcut in SpagoBI
Create reports featuring live Shortcut in SpagoBI Studio. Host Shortcut reports on SpagoBI Server.
-
ETL Google Campaign Manager 360 in Oracle Data Integrator
This article shows how to transfer Google Campaign Manager 360 into a data warehouse using Oracle Data Integrator.
-
Use Microsoft Copilot Studio to talk to your ServiceNow 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 ServiceNow for you.
-
How to create an RPA flow for Snowflake Data in UiPath Studio
Use the Snowflake ODBC Driver to create workflows that access real-time Snowflake without any coding.
-
How to Build an ETL App for ZohoDesk Data in Python with CData
Create ETL applications and real-time data pipelines for ZohoDesk in Python with petl.
-
Integrate with live Act CRM Data in Jitterbit
Use CData Connect AI to connect to and integrate live Act CRM in Jitterbit.
-
Build Dashboards with Amazon Athena Data in DBxtra
Create dynamic dashboards and perform analytics based on Amazon Athena in DBxtra.
-
How to connect to Freshservice Data with Squirrel SQL client
Connect to Freshservice and execute queries in the Squirrel SQL Client.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Strava
Provide connectivity to Strava through an SAP BusinessObjects universe.
-
Create Freshservice Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Freshservice from PowerBI.com to create Power BI Dataflows with real-time data.
-
Access Live Recurly Data in Coginiti Pro
Connect to and query live Recurly from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Replicate Multiple Grafana Accounts
Replicate multiple Grafana accounts to one or many databases.
-
Replicate Multiple Tally Accounts
Replicate multiple Tally accounts to one or many databases.
-
Connect to VWO from Asprova with CData Software ODBC Driver for VWO
This article shows how to connect faster to VWO data from Asprova.
-
Use Manus AI to Talk to Your Couchbase Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Manus AI agents to securely answer questions and take actions on Couchbase.
-
Replicate CircleCI Data from PowerShell
Write a quick PowerShell script to query CircleCI. Use connectivity to the live data to replicate CircleCI to SQL Server.
-
DataBind Nuclia Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Nuclia to a chart.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Sage Intacct
Provide connectivity to Sage Intacct through an SAP BusinessObjects universe.
-
Use the CData Software ODBC Driver for Keap in MicroStrategy Web
Connect to Keap in MicroStrategy Web using the CData Software ODBC Driver for Keap.
-
Model, Search, and Visualize Live BigQuery Data in ThoughtSpot
Use CData Connect AI to connect to live Google BigQuery for modeling, searching, and visualizing.
-
Use the CData Software JDBC Driver for LinkedIn Ads in MicroStrategy Web
Connect to LinkedIn Ads in MicroStrategy Web using the CData Software JDBC Driver for LinkedIn Ads.
-
Connect to Azure DevOps Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Azure DevOps.
-
Model, Search, and Visualize Live LinkedIn Ads Data in ThoughtSpot
Use CData Connect AI to connect to live LinkedIn Ads for modeling, searching, and visualizing.
-
Replicate Google Directory Data to Multiple Databases
Replicate Google Directory to disparate databases with a point-and-click configuration.
-
Process & Analyze Salesforce Data 360 Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Salesforce Data 360 Data.
-
Build an OLAP Cube in SSAS from Cloudflare Data
Establish a connection to Cloudflare data from SQL Server Analysis Services, and use the Cloudflare Data Provider to build OLAP cubes for use in analytics and reporting.
-
Trigger Microsoft Teams IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for Microsoft Teams with standard wizards in Logic Apps.
-
Configure the CData JDBC Driver for SurveyMonkey in a Connection Pool in Tomcat
Connect to SurveyMonkey from a connection pool in Tomcat.
-
Getting Started with the CData Power BI Connector for Demio
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Consume Wave Financial OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Wave Financial feeds that reflect any changes in SAP Lumira.
-
Integrate Klipfolio Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Klipfolio from Informatica Cloud.
-
Create Data Visualizations in Cognos BI with Bannerbear Data
Access Bannerbear as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
How to Design Zoho Projects Power Apps with Database-Like Connectivity
Gain real-time, database-like connectivity to Zoho Projects from mobile and tablet Power Apps.
-
How to connect Amazon QuickSight to Adobe Commerce Data
Create a connection to Adobe Commerce in CData Connect AI and insert Adobe Commerce into Amazon QuickSight SPICE to build interactive dashboards.
-
Integrating Claude Code CLI with Impala 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.
-
Create MySQL-Connected Business Apps in AppSheet
Connect to MySQL Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to MySQL.
-
Import Real-Time Spotify Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Spotify in ColdFusion.
-
Connect to Toggl Data in RazorSQL
Connect to Toggl from wizards and query Toggl from the GUI in the RazorSQL database management tool.
-
Automated Continuous Office 365 Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Office 365 replication to delimited files (CSV/TSV).
-
A PostgreSQL Interface for Sybase IQ Data using the CData ODBC Driver
Use the SQL Gateway and Sybase IQ ODBC Driver to create a PostgreSQL entry-point for data access.
-
Create SAP Ariba Source-Connected Business Apps in AppSheet
Connect to SAP Ariba Source Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to SAP Ariba Source.
-
Build Semantic Layer Views for Parallel Data in APOS Live Data Gateway
Use the CData Connector for Parallel in APOS Live Data Gateway to build Semantic Layer Views for Parallel.
-
Connect to SAP Fieldglass Data in Jaspersoft Studio
Execute SQL to remote SAP Fieldglass in Jaspersoft Studio.
-
How to connect PolyBase to Close
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Close.
-
Automated Continuous Jira Assets Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Jira Assets replication to Google Cloud SQL.
-
Automated Continuous Power BI XMLA Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Power BI XMLA replication to Google BigQuery.