CData Software - Knowledge Base
Recent Articles
-
Connect to Copper Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Copper data.
-
How to connect and process Kintone data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Kintone data.
-
Query, Visualize, and Share live Spark Data in Redash
Use CData Connect AI to connect to live Spark data in Redash for querying, visualizing, and sharing.
-
Use the CData ODBC Driver for Postmark in Microsoft Power Query
You can use the CData Postmark ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Postmark data into Microsoft Power Query.
-
Use the CData Software ODBC Driver for Freshdesk in SAS for Real-Time Reporting and Analytics
Connect to real-time Freshdesk data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Freshdesk.
-
Build Automated Workflows with Live AfterShip Data in Workato
Use CData Connect AI to connect to live AfterShip data and build automated workflows in Workato.
-
Using the CData Software ODBC Driver for Klipfolio in PyCharm
Connect to Klipfolio as an ODBC data source in PyCharm using the CData Software ODBC Driver for Klipfolio.
-
Use Agno to Talk to Your DB2 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 DB2 data for you.
-
Create Dashboards and Visualize Live Bannerbear Data in Geckoboard
Use CData Connect AI to connect to live Bannerbear data and create dashboards for real-time monitoring and visualization in Geckoboard.
-
How to Connect DBeaver to ScrapingBee via a JDBC Driver
Manage ScrapingBee data with visual tools in DBeaver like the query browser.
-
Integrate Live Bitly Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Bitly data and integrate live Bitly data into apps built in Microsoft Power Apps.
-
Integrate Google's Antigravity Agent with Live Salesloft Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Salesloft data using the Model Context Protocol.
-
Integrating LlamaIndex with GetResponse Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on GetResponse data in real time.
-
Use the CData Software JDBC Driver for FreshBooks in MicroStrategy
Connect to FreshBooks data in MicroStrategy Developer using the CData Software JDBC Driver for FreshBooks.
-
Automated Continuous Avro Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Avro replication to Amazon Redshift.
-
Query Sage Cloud Accounting Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Sage Cloud Accounting entities in PHP by modeling them as objects.
-
Connect to GraphQL from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from GraphQL data, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Create a Data Access Object for Vimeo Data using JDBI
A brief overview of creating a SQL Object API for Vimeo data in JDBI.
-
Query Microsoft Entra ID Data in ColdFusion
Write standard ColdFusion data access code to connect to Microsoft Entra ID data.
-
Integrate Dotmailer Data in the Pentaho Report Designer
Publish reports based on Dotmailer data in the Pentaho BI tool.
-
Use the CData Software JDBC Driver for Wave Financial in MicroStrategy Web
Connect to Wave Financial data in MicroStrategy Web using the CData Software JDBC Driver for Wave Financial.
-
Use JayDeBeApi to access Paddle Data in Python
Use standard Python scripting and the development environment of your choice to access live Paddle data.
-
Build Apps with Live Tally Data Using the Low-Code Development Platform of Mendix
Connect Tally data with Mendix to build apps using the CData JDBC Driver for Tally.
-
Visualize Azure DevOps Data in Tableau
The CData ODBC driver for Azure DevOps enables you integrate Azure DevOps data into Tableau dashboards.
-
Integrating GitHub Copilot with Testmonitor 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 QuickBooks Online-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to QuickBooks Online Data from OutSystems and build custom enterprise apps using live QuickBooks Online data.
-
Use the CData Software ODBC Driver for Google Cloud Storage in MicroStrategy Desktop
Connect to Google Cloud Storage data in MicroStrategy Desktop using the CData Software ODBC Driver for Google Cloud Storage.
-
Integrating Cursor with SAP Business One 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.
-
Manage ConvertAPI Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for ConvertAPI.
-
How to Query MariaDB Data in MySQL Workbench
Execute MySQL queries against live MariaDB data from MySQL Workbench.
-
Import QuickBooks Data Using Azure Data Factory
Use CData Connect AI to connect to QuickBooks Data from Azure Data Factory and import live QuickBooks data.
-
Connect to Redis Data as an External Data Source using PolyBase
Use CData Connect AI and PolyBase to create an external data source in SQL Swerver with access to live Redis data.
-
Connecting Pipedream with SAP HANA XS Advanced 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 SAP HANA XS Advanced data in real time.
-
Create Reports with Google Contacts Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Google Contacts data.
-
How to connect SharePoint with Adobe Commerce Data through external lists
Provide Adobe Commerce data to SharePoint users as an external list.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Nethunt
Provide connectivity to Nethunt data through an SAP BusinessObjects universe.
-
Back Up Google Calendar data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Google Calendar. In this article, we will employ an SSIS workflow to populate a database with Google Calendar data data.
-
Visualize Live PagerDuty Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live PagerDuty data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Model, Search, and Visualize Live ZohoExpense Data in ThoughtSpot
Use CData Connect AI to connect to live ZohoExpense data for modeling, searching, and visualizing.
-
Integrate Dify with Live Elasticsearch 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 Elasticsearch data.
-
Create Apps from Jira Assets Data in Qlik Sense Cloud
Use CData Connect AI to connect to Jira Assets Data and build apps from live Jira Assets data in Qlik Sense Cloud.
-
Access Live Aircall Data in AWS Lambda
Connect to live Aircall data in AWS Lambda using the CData JDBC Driver.
-
Connect to Omnisend Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Omnisend and work with Omnisend data in your FileMaker applications.
-
Connect to Workday Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Workday data in Airbyte.
-
Deploy the ADO.NET Provider for Authorize.Net on an SSRS Report Server
Connect to Authorize.Net data from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.
-
How to Connect to Live Dynamics 365 Business Central Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Dynamics 365 Business Central data securely in real time.
-
Use Dash to Build to Web Apps on Salesforce Data 360 Data
Create Python applications that use pandas and Dash to build Salesforce Data 360-connected web apps.
-
Build Cosmos DB-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Cosmos DB data and build web apps with connectivity to live Cosmos DB data.
-
Building Dynamic Web Pages with Vault CRM Data Using AngularJS
Create single-page applications with live connectivity to Vault CRM using the CData API Server.
-
Creating Pipedrive-Connected Applications in Unqork
You can use CData Connect AI to feed Pipedrive data to Unqork and build custom business apps.
-
Create Informatica Mappings From/To an ODBC Data Source for Tally
Create an ODBC connection to Tally in Informatica and browse and transfer Tally data.
-
Consume Monday.com OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Monday.com feeds that reflect any changes in SAP Lumira.
-
Query QuickBooks Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume QuickBooks entities in PHP by modeling them as objects.
-
Access Live FHIR Data in Excel 365 Online (Excel for the web)
Connect to FHIR data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
How to Visualize Hive Data in Python with pandas
Use pandas and other modules to analyze and visualize live Hive data in Python.
-
Automated Continuous Outlook Replication to MySQL
Use CData Sync for automated, continuous, customizable Outlook replication to MySQL.
-
Use the CData Software ODBC Driver for Typeform in MicroStrategy
Connect to Typeform data in MicroStrategy Developer using the CData Software ODBC Driver for Typeform.
-
Publish Workable-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Workable data.
-
Connect to Zoho Projects Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Zoho Projects as an External Source in Dremio.
-
Create Tavily Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Tavily from PowerBI.com to create Power BI Dataflows with real-time data.
-
Build Dashboards with Recurly Data in Dundas BI
Create dynamic dashboards and perform analytics based on Recurly data in Dundas BI.
-
Build a PostgreSQL Interface for PDFMonkey Data using the CData JDBC Driver
Use the Remoting features of the PDFMonkey JDBC Driver to create a PostgreSQL entry-point for data access.
-
Mouseflow Reporting in OBIEE with the Mouseflow JDBC Driver
Deploy the Mouseflow JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Create Reports from Google Sheets Data in Looker Studio
Use CData Connect AI to gain access to live Google Sheets data and create custom reports in Looker Studio.
-
Automate Salesloft Data Replication to Couchbase
Use CData Sync to Customize and automate Salesloft data replication to Couchbase.
-
Connect to Stack Exchange Data in JRuby
Create a simple JRuby app with access to live Stack Exchange data.
-
Build MVC Applications with Connectivity to ZohoDesk Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access ZohoDesk from an ASP.NET MVC application.
-
Operational Reporting on Bitbucket Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Bitbucket data.
-
Access Live SpaceX Data in AWS Lambda (with IntelliJ IDEA)
Connect to live SpaceX data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Import Real-Time Salesforce CRM Analytics Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Salesforce CRM Analytics data in ColdFusion.
-
Connecting Pipedream with SAP Ariba Procurement 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 SAP Ariba Procurement data in real time.
-
Integrate Jira Assets Data in Pentaho Data Integration
Build ETL pipelines based on Jira Assets data in the Pentaho Data Integration tool.
-
Automated Continuous Mode Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Mode replication to Azure SQL Database.
-
Connect to Placid Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Placid data.
-
Use the CData Software ODBC Driver for Klaviyo in SAS for Real-Time Reporting and Analytics
Connect to real-time Klaviyo data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Klaviyo.
-
Enable the GetResponse JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with GetResponse data.
-
Connect to Lakebase Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Lakebase data in Airbyte.
-
Create Dynamic MessageBird Grids Using the Infragistics XamDataGrid
Learn how you can connect MessageBird to Infragistics XamDataGrid to build dynamic grids.
-
Connect to Trello Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Trello data.
-
Create Informatica Mappings From/To an ODBC Data Source for Deel
Create an ODBC connection to Deel in Informatica and browse and transfer Deel data.
-
DataBind Controls to Salesforce Data 360 Data in Delphi
DataBind to Salesforce Data 360 data in Delphi with standard data access components and controls.
-
How to connect to Oracle Data in DBVisualizer
Integrate Oracle data with visual data analysis tools and data connection wizards in DBVisualizer
-
Access Azure Table Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Azure Table data from HeidiSQL.
-
Access Sybase Data from MySQL in Amazon QuickSight
Connect to Sybase and build visualizations of Sybase data using a MySQL Connection in Amazon QuickSight.
-
Connect to and Visualize Live Azure Table Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Azure Table data.
-
Establish a Live Connection with FTP Data using Tableau Bridge
The CData ODBC Driver for FTP enables you to integrate live FTP data into Tableau Cloud dashboards using the Tableau Bridge.
-
Build ZohoDesk-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to ZohoDesk Data from Zoho Analytics and import live ZohoDesk data.
-
Build PolarTeamPro-Connected Apps in Choreo
Use CData Connect AI to connect to PolarTeamPro Data from Choreo and build custom apps using live PolarTeamPro data.
-
Access Live SuiteCRM Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live SuiteCRM data from your Excel spreadsheets.
-
Connect to and Query MySQL Data in QlikView over ODBC
Create data visualizations with MySQL data in QlikView.
-
Model QuickBooks Online Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and QuickBooks Online, enabling the direct import of real-time QuickBooks Online data.
-
Use the CData Software ODBC Driver for ShipEngine in MicroStrategy
Connect to ShipEngine data in MicroStrategy Developer using the CData Software ODBC Driver for ShipEngine.
-
Create a Data Access Object for ZohoInvoice Data using JDBI
A brief overview of creating a SQL Object API for ZohoInvoice data in JDBI.
-
Build a Singer.io Tap for Billsby With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Billsby data using the CData Python Connector.
-
Replicate Aircall Data from PowerShell
Write a quick PowerShell script to query Aircall data. Use connectivity to the live data to replicate Aircall data to SQL Server.
-
Build Apps with Live Omnisend data in Adalo using CData Connect AI
Use CData Connect AI to integrate live Omnisend data into the Adalo platform and build custom mobile and web applications with real-time Omnisend data.
-
Query BigCommerce Data as a SQL Server Database in Node.js
Execute SQL Server queries against BigCommerce data from Node.js.
-
Publish Crystal Reports on Rebilly Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Rebilly data.
-
Integrate with XML Data in SnapLogic
Use CData Connect AI to connect to and integrate with live XML data in SnapLogic.
-
Build Apps with Live VWO data in Adalo using CData Connect AI
Use CData Connect AI to integrate live VWO data into the Adalo platform and build custom mobile and web applications with real-time VWO data.