CData Software - Knowledge Base
Recent Articles
-
Access Live Sugar CRM Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Sugar CRM data from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Automated Continuous Pipeline CRM Replication to Databricks
Use CData Sync for automated, continuous, customizable Pipeline CRM replication to Databricks.
-
Connect to Front Data in DBeaver
Use the CData ODBC Driver to connect to Front data in DBeaver.
-
Visualize Live iContact Data in the Power BI Service
Use CData Connect AI to connect to live iContact data and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Create Supabase Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Supabase data access from reports, embedded analytics, and more.
-
Analyze Live Monday.com Data in SAS Viya
Use CData Connect AI to connect to Monday.com data from SAS Viya and deploy self-service analytics using live Monday.com data.
-
Access Live Freshteam Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Freshteam data from your Excel spreadsheets.
-
Getting Started with the CData Tableau Connector for OnePageCrm
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Connect to Chargebee Data in CloverDX (formerly CloverETL)
Transfer Chargebee data using the visual workflow in the CloverDX data integration tool.
-
Build Dashboards with Codat Data in DBxtra
Create dynamic dashboards and perform analytics based on Codat data in DBxtra.
-
Design BIRT Reports on Google Ad Manager Data
Provide current Google Ad Manager data to your embedded analytics.
-
Visualize Jira Assets Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Jira Assets data.
-
Connect Adobe Target to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Adobe Target with IBM WebSphere for seamless data integration and connectivity.
-
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.
-
Import and Visualize JotForm Data in Power View
Create data visualizations based on JotForm data in Excel.
-
Replicate QuickBooks Data from PowerShell
Write a quick PowerShell script to query QuickBooks data. Use connectivity to the live data to replicate QuickBooks data to SQL Server.
-
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.
-
Easily Integrate Wrike Data in Lazarus Pascal IDE
Learn how to easily integrate live Wrike data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Integrate OpenCode with Live Airtable Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable OpenCode to securely access and query live Airtable data from within your AI coding agent.
-
Use the CData ODBC Driver for Zoho CRM in Microsoft Power Query
You can use the CData Zoho CRM ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Zoho CRM data into Microsoft Power Query.
-
Access Live Grafana Data in Coginiti Pro
Connect to and query live Grafana data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Visualize Figshare Data in Sisense
Create an ElastiCube in Sisense app with access to Figshare data.
-
Integrating LangChain with MYOB AccountRight Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on MYOB AccountRight data within automated workflows.
-
Integrate Live Google Drive Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Google Drive from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Google Drive data.
-
Integrating Kiro with Amazon Athena 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 Clio Data from MySQL in PHP
Connect to Clio through the standard MySQL libraries in PHP.
-
Google Cloud Storage Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Google Cloud Storage data through CData Connect AI using different applications and tools.
-
How to connect to Cvent Data from IntelliJ
Integrate connectivity to Cvent data with wizards in IntelliJ.
-
Connect to GitLab Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live GitLab data from Filemaker Pro on Mac.
-
Create SSAS Tabular Models from Shortcut Data
How to build a SQL Server Analysis Service Tabular Model from Shortcut data using CData drivers.
-
Access LeadDesk Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live LeadDesk data from HeidiSQL.
-
Migrating data from LightSpeedRetail to Snowflake using CData SSIS Components.
Easily push LightSpeedRetail data to Snowflake using the CData SSIS Tasks for LightSpeedRetail and Snowflake.
-
Analyze Klipfolio Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Klipfolio data in Microsoft R Open.
-
Getting Started with the CData JDBC Driver for Accelo
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Accelo.
-
Connecting Mastra with Coda 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 Coda data, no replication required.
-
Analyze LinkedIn Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of LinkedIn data and visualize live LinkedIn data 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 data 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.
-
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.
-
Migrating data from Adobe Experience Manager to Snowflake using CData SSIS Components.
Easily push Adobe Experience Manager data to Snowflake using the CData SSIS Tasks for Adobe Experience Manager and Snowflake.
-
Integrate Dify with Live ADP 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 ADP data.
-
Use the CData Software JDBC Driver for Tickspot in MicroStrategy
Connect to Tickspot data in MicroStrategy Developer using the CData Software JDBC Driver for Tickspot.
-
Use Biml to Build SSIS Tasks to Replicate Simplesat Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Simplesat data to SQL Server.
-
Connect to Google Directory Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Google Directory data using standard SQL.
-
Connect to Google Forms from a Connection Pool in WebLogic
Use the CData JDBC Driver for Google Forms to connect to Google Forms data from Web applications running on WebLogic.
-
Import Adobe Analytics Data Using Azure Data Factory
Use CData Connect AI to connect to Adobe Analytics Data from Azure Data Factory and import live Adobe Analytics data.
-
Build CircleCI-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to CircleCI data and build web apps with connectivity to live CircleCI data.
-
Connect to Pipeliner CRM Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Pipeliner CRM data.
-
Natively Connect to Brex Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Brex data. Leverage the native support for ODBC in PHP.
-
Analyze GetResponse Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of GetResponse data and visualize live GetResponse data in Infragistics Reveal.
-
Create Data Visualizations in Cognos BI with Instantly Data
Access Instantly data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Natively Connect to Workday Data in PHP
The CData ODBC driver for Workday enables you to create PHP applications with connectivity to Workday data. Leverage the native support for ODBC in PHP.
-
Analyze Zoho CRM Data in Looker
Use CData Connect AI to connect to Zoho CRM Data from Looker and build custom apps using live Zoho CRM data.
-
Publish Exa-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Exa data.
-
Integrate Theia IDE with Live HBase Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE's built-in AI agents to securely access and query live HBase data from within the development environment.
-
Create SSAS Tabular Models from Cloudflare Data
How to build a SQL Server Analysis Service Tabular Model from Cloudflare data using CData drivers.
-
Visualize Tickspot Data in Tableau
The CData ODBC driver for Tickspot enables you integrate Tickspot data into Tableau dashboards.
-
Integrating Kiro with Shopify 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.
-
How to publish and share Gmail Data dashboards with Tableau Server
The CData ODBC driver for Gmail enables you integrate Gmail data into Tableau dashboards.
-
Provide OData Services of Excel Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Excel data by developing a WCF Service Application.
-
Create Reports with Toggl Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Toggl data.
-
How to Query Zoho Inventory Data in MySQL Workbench
Execute MySQL queries against live Zoho Inventory data from MySQL Workbench.
-
Connect to Vault CRM Data in CloverDX (formerly CloverETL)
Transfer Vault CRM data using the visual workflow in the CloverDX data integration tool.
-
Explore Geographical Relationships in Everhour Data with Power Map
Create data visualizations with Everhour data in Power Map.
-
Create SSAS Tabular Models from MongoDB Data
How to build a SQL Server Analysis Service Tabular Model from MongoDB data using CData drivers.
-
Use the CData Software JDBC Driver for Phoenix in MicroStrategy Desktop
Connect to Phoenix data in MicroStrategy Desktop using the CData Software JDBC Driver for Phoenix.
-
Integrating Kiro with WordPress 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 Goose with Live eBay Analytics Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live eBay Analytics data from within the local AI agent.
-
Integrate Dify with Live Square 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 Square data.
-
How to Connect to & Open Templated Data in Microsoft Excel
This article uses the CData ODBC driver for Templated to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
How to import Printful Data into Apache Solr
Use the CData Software JDBC Driver for Printful in Data Import Handler and create an automated import of Printful data to Apache Solr Enterprise Search platform.
-
Create Datasets from ServiceNow in Domo Workbench and Build Visualizations of ServiceNow Data in Domo
Use the CData Software ODBC Driver for ServiceNow to create datasets from ServiceNow data in Domo Workbench and then build visualizations in the Domo service.
-
Integrate Live Google Contacts Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Google Contacts data to Blue Prism using the CData ODBC Driver for Google Contacts to create automated workflows for repetitive business tasks.
-
Integrating LangChain with Mode Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Mode data within automated workflows.
-
Publish Crystal Reports on Salesforce Pardot Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Salesforce Pardot data.
-
Visualize Live ClickTime Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live ClickTime data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Visualize Drip Data in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load Drip data into TIBCO Spotfire.
-
Build a PostgreSQL Interface for Helpscout Data using the CData JDBC Driver
Use the Remoting features of the Helpscout JDBC Driver to create a PostgreSQL entry-point for data access.
-
Create Outreach.io-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Outreach.io Data from OutSystems and build custom enterprise apps using live Outreach.io data.
-
Build Automated YouTube Analytics-Connected Workflows in Zapier
Use CData Connect AI to connect to live YouTube Analytics data and build automated workflows in Zapier.
-
Create Dashboards and Visualize Live ZohoInvoice Data in Geckoboard
Use CData Connect AI to connect to live ZohoInvoice data and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Visualize Telegram Data in Tableau
The CData ODBC driver for Telegram enables you integrate Telegram data into Tableau dashboards.
-
How to connect and process Zoho Creator data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Zoho Creator data.
-
DataBind Controls to Salesforce Pardot Data in Delphi
DataBind to Salesforce Pardot data in Delphi with standard data access components and controls.
-
Integrate PolarTeamPro Data into Power Automate Desktop using CData Connect
CData Connect for PolarTeamPro Data enables you to integrate PolarTeamPro data into workflows built using Microsoft Power Automate Desktop.
-
Viewing Cassandra Data in RAD Studio Data Explorer
How to view Cassandra data in RAD Studio Data Explorer using the CData ODBC Driver for Cassandra.
-
Analyze FreshBooks Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of FreshBooks data and visualize FreshBooks data in SAP Analytics Cloud.
-
Connect to Teamgate Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Teamgate data using standard SQL.
-
How to connect to Slack Data from Spring Boot
Connect to Slack in a Spring Boot Application using the CData JDBC Driver for Slack
-
Feed SAS Data Sets Data into FineReport
How to set SAS Data Sets data as a JDBC data source in FineReport.
-
Publish Mailjet-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Mailjet data.
-
How to connect to Invoiced Data in DBVisualizer
Integrate Invoiced data with visual data analysis tools and data connection wizards in DBVisualizer
-
Integrate Dify with Live Kafka 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 Kafka data.
-
Automated Continuous Oracle Eloqua Replication to Databricks
Use CData Sync for automated, continuous, customizable Oracle Eloqua replication to Databricks.
-
How to Create Power BI Visual Reports with Real-Time Timely Data
Use CData Power BI Connectors to visualize Timely data in Power BI.
-
Getting Started with the CData SSIS Components for HDFS
Complete guide to installing, licensing, and connecting with the CData SSIS Components for HDFS.
-
Using the CData Software ODBC Driver for OneNote in PyCharm
Connect to OneNote as an ODBC data source in PyCharm using the CData Software ODBC Driver for OneNote.
-
Build a Singer.io Tap for Drip With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Drip data using the CData Python Connector.
-
Build Dashboards with Parquet Data in DBxtra
Create dynamic dashboards and perform analytics based on Parquet data in DBxtra.
-
How to Connect to Live Microsoft Ads 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 Microsoft Ads data for you.