CData Software - Knowledge Base
Recent Articles
-
Getting Started with the CData Power BI Connector for Planio
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Connect to Real-Time Sage Intacct Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Sage Intacct and Dataflow to import and use Sage Intacct data in Power Apps.
-
Access Live Templated Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Templated data into the statistical analysis tools available in SAS JMP. This article shows how to use Templated data in the Graph Builder and Query Builder.
-
How to connect to Vault CRM Data from Spring Boot
Connect to Vault CRM in a Spring Boot Application using the CData JDBC Driver for Vault CRM
-
Visualize RabbitMQ 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 RabbitMQ data into TIBCO Spotfire.
-
How to Connect to Live Google Forms Data from OpenAI Python Applications (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable OpenAI-powered Python applications to securely read and take actions on your Google Forms data through natural language.
-
Connect to Oracle HCM Cloud Data from a Connection Pool in JBoss
Integrate Oracle HCM Cloud data into Java servlets: Use the Management Console in JBoss to install the Oracle HCM Cloud JDBC Driver.
-
How to create Visio diagrams from Office 365 Data
Automatically update Office 365 data with the changes you make to Visio master shapes.
-
Integrate Live Printify 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 Printify data from within the IDE.
-
Use Dash to Build to Web Apps on Pingdom Data
Create Python applications that use pandas and Dash to build Pingdom-connected web apps.
-
Build Microsoft Planner Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Microsoft Planner data and build visualizations in Tableau.
-
Visualize Blackbaud FE NXT Data in Sisense
Create an ElastiCube in Sisense app with access to Blackbaud FE NXT data.
-
Getting Started with the CData Tableau Connector for Clockify
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Integrate Figshare with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Figshare with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Figshare data.
-
Import Real-Time Guru Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Guru data in ColdFusion.
-
Interact with Live ZohoInvoice Data in Meta Muse via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Muse to securely interact with live ZohoInvoice data.
-
Connect ConstantContact Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your ConstantContact data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Automated Continuous Google Spanner Replication to Databricks
Use CData Sync for automated, continuous, customizable Google Spanner replication to Databricks.
-
How to Connect to & Open Amazon S3 Data in Microsoft Excel
This article uses the CData ODBC driver for Amazon S3 to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Automated Continuous FreeAgent Replication to Databricks
Use CData Sync for automated, continuous, customizable FreeAgent replication to Databricks.
-
Integrate Insightly with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Insightly with External Services.
-
Connect to FreshBooks from Asprova with CData Software ODBC Driver for FreshBooks
This article shows how to connect faster to FreshBooks data from Asprova.
-
Automated Continuous Epicor Kinetic Replication to Snowflake
Use CData Sync for automated, continuous, customizable Epicor Kinetic replication to Snowflake.
-
Automated Continuous API Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable API replication to Amazon Redshift.
-
How to Seamlessly Import Teamgate Data into IBM SPSS Modeler
Integrate Teamgate data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Connect Landbot to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Landbot data using the CData Python MCP Server.
-
Connect to Ontraport Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to Ontraport.
-
Use the CData Software JDBC Driver for Google Directory in MicroStrategy Web
Connect to Google Directory data in MicroStrategy Web using the CData Software JDBC Driver for Google Directory.
-
Use the CData SSIS Components to Insert New or Update Existing Salesforce Pardot Records from SQL Server
Easily push SQL Server data to Salesforce Pardot using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Salesforce Pardot or update existing records with data from a SQL Server database.
-
Access Facebook Data from MySQL in Amazon QuickSight
Connect to Facebook and build visualizations of Facebook data using a MySQL Connection in Amazon QuickSight.
-
Create SSAS Tabular Models from REST Data
How to build a SQL Server Analysis Service Tabular Model from REST data using CData drivers.
-
Automated Continuous PayPal Replication to SingleStore
Use CData Sync for automated, continuous, customizable PayPal replication to SingleStore.
-
Use the CData Software ODBC Driver for SpaceX in MicroStrategy
Connect to SpaceX data in MicroStrategy Developer using the CData Software ODBC Driver for SpaceX.
-
Validate Opsgenie Data with QuerySurge
Access and validate Opsgenie data in QuerySurge using the CData JDBC Driver.
-
Use the CData ODBC Driver for Procore from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Procore to connect to Procore data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Procore data in Excel.
-
A PostgreSQL Interface for Teamgate Data (MySQL Remoting via JDBC)
Use the Remoting features of the Teamgate JDBC Driver to create a PostgreSQL entry-point for data access.
-
How to Connect to Live SAP Fieldglass 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 SAP Fieldglass data for you.
-
Access SAP HANA Data from MySQL in PHP
Connect to SAP HANA through the standard MySQL libraries in PHP.
-
Query, Visualize, and Share live Twilio Data in Redash
Use CData Connect AI to connect to live Twilio data in Redash for querying, visualizing, and sharing.
-
Getting Started with the CData ODBC Driver for Exact Online
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Exact Online.
-
Write a Simple Go Application to work with OneNote Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to OneNote data.
-
Connect to and Query Adobe Commerce Data in QlikView over ODBC
Create data visualizations with Adobe Commerce data in QlikView.
-
Connect to Google Drive from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Google Drive data, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
How to Connect DBeaver to Placid via a JDBC Driver
Manage Placid data with visual tools in DBeaver like the query browser.
-
Create SSAS Tabular Models from Vercel Data
How to build a SQL Server Analysis Service Tabular Model from Vercel data using CData drivers.
-
Automated Continuous Simplesat Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Simplesat replication to PostgreSQL.
-
Use Databricks Agent Bricks to Talk to Your Basecamp Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Basecamp data for you.
-
Use JayDeBeApi to access Hugging Face Data in Python
Use standard Python scripting and the development environment of your choice to access live Hugging Face data.
-
Integrate Live SingleStore Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to SingleStore data and integrate live SingleStore data into apps built in Microsoft Power Apps.
-
Automated Continuous OpenWeatherMap Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable OpenWeatherMap data replication to OneLake in Microsoft Fabric.
-
How to create Visio diagrams from Impala Data
Automatically update Impala data with the changes you make to Visio master shapes.
-
Automated Continuous Nuclia Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Nuclia replication to Apache Kafka.
-
Connecting Moonlit Workflow with Yelp Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Moonlit workflows to securely read and act on your Yelp data in real time.
-
Publish EnterpriseDB-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live EnterpriseDB data.
-
Connecting GenSpark with eBay Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to eBay data without any replication or custom integration required.
-
Visualize Live SpaceX Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live SpaceX data.
-
Automated Continuous Sage 300 Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Sage 300 data replication to OneLake in Microsoft Fabric.
-
Publish Crystal Reports on Excel Online Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Excel Online data.
-
Integrate Theia IDE with Live Phoenix 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 Phoenix data from within the development environment.
-
Create a Data Access Object for Front Data using JDBI
A brief overview of creating a SQL Object API for Front data in JDBI.
-
How to Work with WooCommerce Data in AWS Glue Jobs Using JDBC
Connect to WooCommerce from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Use the CData Software ODBC Driver for Float in MicroStrategy
Connect to Float data in MicroStrategy Developer using the CData Software ODBC Driver for Float.
-
Build AI Agents with Google Calendar 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 Google Calendar data through CData Connect AI.
-
Connect to Sendwithus Data in ACL Analytics
Connect to Sendwithus data via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Sendwithus data.
-
Visualize Zoho Books Data in TIBCO Spotfire through ADO.NET
Integrate Zoho Books data into dashboards in TIBCO Spotfire.
-
Connect Customer.io Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Customer.io data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Automated Continuous Parquet Replication to MySQL
Use CData Sync for automated, continuous, customizable Parquet replication to MySQL.
-
Connect to Mouseflow Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Mouseflow data using standard SQL.
-
Replicate Multiple ConvertAPI Accounts
Replicate multiple ConvertAPI accounts to one or many databases.
-
Replicate Multiple Zoho CRM Accounts
Replicate multiple Zoho CRM accounts to one or many databases.
-
Connect to Sage Cloud Accounting Data in RazorSQL
Connect to Sage Cloud Accounting from wizards and query Sage Cloud Accounting data from the GUI in the RazorSQL database management tool.
-
Getting Started with the CData Excel Add-In for MYOB AccountRight
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for MYOB AccountRight.
-
Create Google Calendar-Connected Nintex Workflows
Use CData Connect AI to connect to Google Calendar Data from Nintex Workflow Cloud and build custom workflows using live Google Calendar data.
-
Integrate Google's Antigravity Agent with Live OneNote Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live OneNote data using the Model Context Protocol.
-
Automated Continuous Nethunt Replication to Oracle
Use CData Sync for automated, continuous, customizable Nethunt replication to Oracle.
-
How to Build an ETL App for Notion Data in Python with CData Connect AI
Extract and transform live Notion data in Python with petl and the CData Connect AI Python SDK.
-
Build Telegram-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Telegram data and build web apps with connectivity to live Telegram data.
-
Build Quickbase-Connected Apps in Choreo
Use CData Connect AI to connect to Quickbase Data from Choreo and build custom apps using live Quickbase data.
-
How to connect to SendPulse Data in DBVisualizer
Integrate SendPulse data with visual data analysis tools and data connection wizards in DBVisualizer
-
Create Datasets from Exa in Domo Workbench and Build Visualizations of Exa Data in Domo
Use the CData Software ODBC Driver for Exa to create datasets from Exa data in Domo Workbench and then build visualizations in the Domo service.
-
Automated Continuous Twitter Ads Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Twitter Ads replication to Apache Kafka.
-
Connect to Flowlu Data in RazorSQL
Connect to Flowlu from wizards and query Flowlu data from the GUI in the RazorSQL database management tool.
-
Connect to ServiceDesk Plus Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time ServiceDesk Plus data using standard SQL.
-
Connecting Agentforce with SAP BusinessObjects BI Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Agentforce to securely read and take actions on your SAP BusinessObjects BI data for you.
-
Creating Cloudflare-Connected Applications in Unqork
You can use CData Connect AI to feed Cloudflare data to Unqork and build custom business apps.
-
Natively Connect to SpaceX Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to SpaceX data. Leverage the native support for ODBC in PHP.
-
Build Dashboards with SAP BusinessObjects BI Data in DBxtra
Create dynamic dashboards and perform analytics based on SAP BusinessObjects BI data in DBxtra.
-
Query Paylocity Data as a SQL Server Database in Node.js
Execute SQL Server queries against Paylocity data from Node.js.
-
Build Apps with Live FreshBooks data in Adalo using CData Connect AI
Use CData Connect AI to integrate live FreshBooks data into the Adalo platform and build custom mobile and web applications with real-time FreshBooks data.
-
Connect to Typeform Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Typeform data in the Denodo Virtual DataPort Administrator.
-
Access Certinia Data from MySQL in PHP
Connect to Certinia through the standard MySQL libraries in PHP.
-
Build Semantic Layer Views for Shippo Data in APOS Live Data Gateway
Use the CData Connector for Shippo in APOS Live Data Gateway to build Semantic Layer Views for Shippo data.
-
Build MVC Applications with Connectivity to HubDB Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access HubDB from an ASP.NET MVC application.
-
Connect to Salesloft Data from a Connection Pool in Jetty
The Salesloft JDBC Driver supports connection pooling: This article shows how to connect faster to Salesloft data from Web apps in Jetty.
-
Query Asana Data in DataGrip
Create a Data Source for Asana in DataGrip and use SQL to query live Asana data.
-
Use Dash to Build to Web Apps on Cvent Data
Create Python applications that use pandas and Dash to build Cvent-connected web apps.
-
How to integrate Tally with Apache Airflow
Access and process Tally data in Apache Airflow using the CData JDBC Driver.
-
Deploy the ADO.NET Provider for JotForm on an SSRS Report Server
Connect to JotForm 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.
-
Consume Sage 200 OData Feeds in PowerBuilder
This article demonstrates how to consume Sage 200 data as OData feeds from PowerBuilder using the API Server.
-
Import Real-Time Instagram Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Instagram data in ColdFusion.