CData Software - Knowledge Base
Recent Articles
-
Query Printful Data in DataGrip
Create a Data Source for Printful in DataGrip and use SQL to query live Printful data.
-
Create Power BI XMLA-Connected Nintex Workflows
Use CData Connect AI to connect to Power BI XMLA Data from Nintex Workflow Cloud and build custom workflows using live Power BI XMLA data.
-
Build Dashboards with Moosend Data in DBxtra
Create dynamic dashboards and perform analytics based on Moosend data in DBxtra.
-
Bidirectional Access to Cvent Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Cvent data in Filemaker Pro for Mac or Windows.
-
Integrate Cursor with Live Avro Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Avro data from within the editor.
-
Automate IBM Informix Data Replication to Azure Synapse
Use CData Sync to customize and automate IBM Informix data replication to Azure Synapse.
-
Replicate Multiple Highrise Accounts via the CData Sync CLI
Replicate multiple Highrise accounts to one or many databases.
-
Automated Continuous Oracle SCM Replication to SQLite
Use CData Sync for automated, continuous, customizable Oracle SCM replication to SQLite.
-
Automate Ontraport Data Replication to Azure Synapse
Use CData Sync to customize and automate Ontraport data replication to Azure Synapse.
-
Feed Microsoft Dataverse Data into FineReport
How to set Microsoft Dataverse data as a JDBC data source in FineReport.
-
Seamlessly Bring VWO Data into Retool Using CData Connect AI
Integrate VWO data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Build Visualizations of TigerGraph Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of TigerGraph data in Birst.
-
Access Live Sugar CRM Data in AWS Lambda
Connect to live Sugar CRM data in AWS Lambda using the CData JDBC Driver.
-
How to Connect to Planio Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Planio data. Leverage the pyodbc module for ODBC in Python.
-
Automated Productboard Data Replication to Teradata
Use CData Sync to Customize and automate Productboard data replication to Teradata.
-
Automated Continuous JSON Replication to SQLite
Use CData Sync for automated, continuous, customizable JSON replication to SQLite.
-
Analyze IBM Cloud Object Storage Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for IBM Cloud Object Storage from Power Pivot. You will use the Table Import Wizard to load IBM Cloud Object Storage data. You can visually build the import query or use any SQL supported by the driver.
-
Publish Reports with SQL Server Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date SQL Server data.
-
Automated Continuous Outreach.io Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Outreach.io replication to Amazon Redshift.
-
Access Live Figshare Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Figshare data from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Use Microsoft Copilot Studio to talk to your Salesloft 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 Salesloft data for you.
-
Use the CData ODBC Driver for PabblySubscriptions from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for PabblySubscriptions to connect to PabblySubscriptions data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring PabblySubscriptions data in Excel.
-
Connect to and Visualize Live Simplesat Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Simplesat data.
-
Connect to Eventbrite Data Using the Script Function in Claris FileMaker Pro
Use the CData API Driver for ODBC and the Script function in FileMaker Pro to connect to Eventbrite and work with Eventbrite data in your FileMaker application.
-
DataBind Controls to FormSite Data in Delphi
DataBind to FormSite data in Delphi with standard data access components and controls.
-
Integrate Google's Antigravity Agent with Live Facebook Ads Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Facebook Ads data using the Model Context Protocol.
-
Build Data Flows from Freshteam to SQL Server using SSIS
Easily back up Freshteam data to SQL Server using the SSIS components for Freshteam.
-
Query ZohoMarketingHub Data in ColdFusion
Write standard ColdFusion data access code to connect to ZohoMarketingHub data.
-
Build ZohoPeople Visualizations in Tableau Cloud
Use CData Connect AI to connect to live ZohoPeople data and build visualizations in Tableau Cloud.
-
Use the CData ODBC Driver for Workday in Microsoft Power Query
You can use the CData Workday ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Workday data into Microsoft Power Query.
-
Publish Crystal Reports on Pipeliner CRM Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Pipeliner CRM data.
-
Connect to Hive Data in ACL Analytics
Connect to Hive data via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Hive data.
-
Replicate Aweber Data to Multiple Databases
Replicate Aweber data to disparate databases with a point-and-click configuration.
-
How to connect and process IBM Cloud Object Storage data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live IBM Cloud Object Storage data.
-
Integrate Dify with Live SurveyMonkey 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 SurveyMonkey data.
-
A PostgreSQL Interface for Lakebase Data using the CData ODBC Driver
Use the SQL Gateway and Lakebase ODBC Driver to create a PostgreSQL entry-point for data access.
-
How to use SQLAlchemy ORM to access AlloyDB Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of AlloyDB data.
-
Query Live SAP Hybris C4C Data in Perplexity Desktop via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Perplexity Desktop to securely access and query live SAP Hybris C4C data through a conversational interface.
-
Connect to Guru Data in DBeaver
Use the CData ODBC Driver to connect to Guru data in DBeaver.
-
Use Agno to Talk to Your Procore Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Agno agents to securely answer questions and take actions on your Procore data for you.
-
SAP SuccessFactors Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to SAP SuccessFactors data through CData Connect AI using different applications and tools.
-
Automated Continuous Notion Replication to Vertica
Use CData Sync for automated, continuous, customizable Notion replication to Vertica.
-
Stream Rootly Data into Apache Kafka Topics
Access and stream Rootly data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Build Pipelines with Live Zendesk Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Zendesk from Google Cloud Data Fusion, enabling the integration of live Zendesk data into the building and management of effective data pipelines.
-
Natively Connect to NASA Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to NASA data. Leverage the native support for ODBC in PHP.
-
Integrate Live AgileCRM Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf's Cascade agent to securely access and query live AgileCRM data from within the IDE.
-
Add Everhour Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Everhour with the Informatica Enterprise Data Catalog to classify and organize data.
-
Replicate Pipeliner CRM Data to Multiple Databases via the CData Sync CLI
Replicate Pipeliner CRM data to disparate databases with a single configuration.
-
Access Live Microsoft Dataverse Data in Coginiti Pro
Connect to and query live Microsoft Dataverse data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Integrate Live Google Calendar Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Google Calendar data and integrate live Google Calendar data into apps built in Microsoft Power Apps.
-
Import Real-Time Cassandra Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Cassandra data in ColdFusion.
-
Access Live Act CRM 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 Act CRM data through MCP integration.
-
Query, Visualize, and Share live Authorize.Net Data in Redash
Use CData Connect AI to connect to live Authorize.Net data in Redash for querying, visualizing, and sharing.
-
Build Visualizations of Pushbullet Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Pushbullet data in Birst.
-
Excel Spreadsheet Automation on OpenWeatherMap Data with the QUERY Formula
Pull data from OpenWeatherMap, automate spreadsheets, and more with the QUERY formula.
-
Use Azure AI Foundry to Talk to Your CockroachDB Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Azure AI Foundry agents to securely answer questions and take actions on your CockroachDB data for you.
-
Integrating Codex with XML 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 SAP Ariba Source Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable SAP Ariba Source replication to Apache Cassandra.
-
Import Real-Time Wave Financial Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Wave Financial data in ColdFusion.
-
Create Reports from Microsoft OneDrive Data in Looker Studio
Use CData Connect AI to gain access to live Microsoft OneDrive data and create custom reports in Looker Studio.
-
Connect to Teamwork Data in DBeaver
Use the CData ODBC Driver to connect to Teamwork data in DBeaver.
-
Easily Integrate Egnyte Data in Lazarus Pascal IDE
Learn how to easily integrate live Egnyte data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Getting Started with the CData Tableau Connector for Eventbrite
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
How to Connect to Live WooCommerce Data from Gemini CLI (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Gemini CLI to securely read and take actions on your WooCommerce data for you.
-
Integrating Kiro with Cloudant 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 Trae with Live SAP Ariba Procurement Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Trae to securely access and query live SAP Ariba Procurement data from within the AI-powered IDE.
-
Access Live Spark Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Spark data from your Excel spreadsheets.
-
Create Dashboards and Visualize Live Grafana Data in Geckoboard
Use CData Connect AI to connect to live Grafana data and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Integrate OpenCode with Live Google Spanner Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable OpenCode to securely access and query live Google Spanner data from within your AI coding agent.
-
Connect to and Query Greenhouse Data in QlikView over ODBC
Create data visualizations with Greenhouse data in QlikView.
-
Integrate with Telegram Data in JReport Designer
Create charts and reports based on Telegram data in JReport Designer.
-
A PostgreSQL Interface for Anaplan Data using the CData ODBC Driver
Use the SQL Gateway and Anaplan ODBC Driver to create a PostgreSQL entry-point for data access.
-
Access Live Contentful Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Contentful data into the statistical analysis tools available in SAS JMP. This article shows how to use Contentful data in the Graph Builder and Query Builder.
-
Connect Retently Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Retently data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Integrating ServiceDesk Plus Data in Talend Cloud Data Management Platform
Connect ServiceDesk Plus Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Connect Dynamics NAV to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Dynamics NAV data using the CData Python MCP Server.
-
How to Easily Query Ontraport Data in OpenOffice Base
Connect to Ontraport data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Connect to PayPal from a Connection Pool in WebLogic
Use the CData JDBC Driver for PayPal to connect to PayPal data from Web applications running on WebLogic.
-
Automated Continuous Facebook Replication to Snowflake
Use CData Sync for automated, continuous, customizable Facebook replication to Snowflake.
-
How to Query Dynamics NAV Data in MySQL Workbench
Execute MySQL queries against live Dynamics NAV data from MySQL Workbench.
-
Integrate Zoho Creator Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Zoho Creator data from Informatica Cloud.
-
Connect to Elasticsearch Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Elasticsearch and the Script function in FileMaker Pro to connect to Elasticsearch and work with Elasticsearch data in your FileMaker application.
-
Automate Wave Financial Data Replication to Azure Data Lake
Use CData Sync to customize and automate Wave Financial data replication to Azure Data Lake.
-
Connect to Elasticsearch in SpagoBI
Create reports featuring live Elasticsearch data in SpagoBI Studio. Host Elasticsearch reports on SpagoBI Server.
-
Query Live MailerLite 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 MailerLite data directly from the development environment.
-
Visualize Live MailerLite Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live MailerLite data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Analyze Sugar CRM Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Sugar CRM data and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Build Charts with PostgreSQL Data in Clear Analytics
Create dynamic charts and perform analytics based on PostgreSQL data in Clear Analytics.
-
Access FormSite Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access FormSite data from your Oracle system.
-
Replicate Multiple Freshsales Accounts
Replicate multiple Freshsales accounts to one or many databases.
-
Integrate Live Google Calendar Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Google Calendar data to Blue Prism using the CData ODBC Driver for Google Calendar to create automated workflows for repetitive business tasks.
-
Connecting Pipedream with Microsoft Planner Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Pipedream workflows to securely read and take actions on Microsoft Planner data in real time.
-
Analyze API Data in Looker
Use CData Connect AI to connect to API Data from Looker and build custom apps using live API data.
-
Use Dash to Build to Web Apps on Wave Financial Data
Create Python applications that use pandas and Dash to build Wave Financial-connected web apps.
-
Use Agno to Talk to Your PingOne Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Agno agents to securely answer questions and take actions on your PingOne data for you.
-
A PostgreSQL Interface for LinkedIn Ads Data (MySQL Remoting via JDBC)
Use the Remoting features of the LinkedIn Ads JDBC Driver to create a PostgreSQL entry-point for data access.
-
Analyze Live eBay Analytics Data in SAS Viya
Use CData Connect AI to connect to eBay Analytics data from SAS Viya and deploy self-service analytics using live eBay Analytics data.
-
How to connect to Presto Data with Squirrel SQL client
Connect to Presto data and execute queries in the Squirrel SQL Client.
-
Moving Data from PolarTeamPro to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live PolarTeamPro data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Build Hive Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Hive data and build visualizations in Tableau Cloud.