CData Software - Knowledge Base
Recent Articles
-
Create Dashboards and Visualize Live Shopify Data in Geckoboard
Use CData Connect AI to connect to live Shopify data and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Create Reports from MailerLite Data in Looker Studio
Use CData Connect AI to gain access to live MailerLite data and create custom reports in Looker Studio.
-
Connect to Live Slack Data in MicroStrategy through CData Connect AI
Create a live connection to Slack Data in CData Connect AI and connect to your Slack data from MicroStrategy.
-
Automated Continuous Tally Replication to Snowflake
Use CData Sync for automated, continuous, customizable Tally replication to Snowflake.
-
Build Raisers Edge NXT-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Raisers Edge NXT data.
-
Connect to Typeform Data in JRuby
Create a simple JRuby app with access to live Typeform data.
-
Analyze Teamwork Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Teamwork data with the CData JDBC Driver for Teamwork.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for QuickBooks
Provide connectivity to QuickBooks data through an SAP BusinessObjects universe.
-
Use the CData ODBC Driver for OneNote in Microsoft Power Query
You can use the CData OneNote ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import OneNote data into Microsoft Power Query.
-
Getting Started with the CData Power BI Connector for JotForm
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Getting Started with the CData Connect AI Python SDK for OneNote
Install the CData Connect AI Python SDK to read and write live OneNote data with standard DB-API 2.0 Python code.
-
Create Google Contacts-Connected Business Apps in AppSheet
Connect to Google Contacts Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Google Contacts data.
-
Getting Started with the CData Tableau Connector for SparkPost
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Create SSAS Tabular Models from Factorial Data
How to build a SQL Server Analysis Service Tabular Model from Factorial data using CData drivers.
-
Create LinkedIn-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to LinkedIn Data from Klipfolio and build custom visualizations using live LinkedIn data.
-
Integrate ClickTime Data in the Pentaho Report Designer
Publish reports based on ClickTime data in the Pentaho BI tool.
-
Integrate Live Grafana 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 Grafana data from within the IDE.
-
Use Biml to Build SSIS Tasks to Replicate BigQuery Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate BigQuery data to SQL Server.
-
How to Connect to Live CouchDB Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live CouchDB data securely in real time.
-
Import Real-Time Reply.io Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Reply.io data in ColdFusion.
-
Build Semantic Layer Views for Onfleet Data in APOS Live Data Gateway
Use the CData Connector for Onfleet in APOS Live Data Gateway to build Semantic Layer Views for Onfleet data.
-
Build Automated Workflows with Live AgileCRM Data in Workato
Use CData Connect AI to connect to live AgileCRM data and build automated workflows in Workato.
-
Connect to Gumroad 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 Gumroad and work with Gumroad data in your FileMaker application.
-
Use the CData Software JDBC Driver for Samanage in MicroStrategy Desktop
Connect to Samanage data in MicroStrategy Desktop using the CData Software JDBC Driver for Samanage.
-
How to Query Live Spark Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Spark data data in natural language using Python.
-
Build Data Flows from ZohoPeople to SQL Server using SSIS
Easily back up ZohoPeople data to SQL Server using the SSIS components for ZohoPeople.
-
How to integrate Quickbase with Apache Airflow
Access and process Quickbase data in Apache Airflow using the CData JDBC Driver.
-
Access NetSuite Sales Orders in Dynamics CRM
Improve your sales team’s visibility into the needs of your business and customers by accessing your NetSuite sales orders from Dynamics CRM.
-
Provide OData Services of SAP Ariba Procurement Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for SAP Ariba Procurement data by developing a WCF Service Application.
-
Visualize Cosmos DB Data in Sisense
Create an ElastiCube in Sisense app with access to Cosmos DB data.
-
Build Dashboards with Azure Data Catalog Data in DBxtra
Create dynamic dashboards and perform analytics based on Azure Data Catalog data in DBxtra.
-
Deploy the ADO.NET Provider for Parquet on an SSRS Report Server
Connect to Parquet 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.
-
Automate Exa Data Replication to Couchbase
Use CData Sync to Customize and automate Exa data replication to Couchbase.
-
Connect Impala to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Impala data using the CData Python MCP Server.
-
Use ChatGPT to Talk to Your Azure Table Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable ChatGPT to securely answer questions and take actions on your Azure Table data for you.
-
Create Coda-Connected Dashboards in Grafana
Connect to Coda Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Coda data.
-
Use the CData Software ODBC Driver for Instantly in MicroStrategy Web
Connect to Instantly data in MicroStrategy Web using the CData Software ODBC Driver for Instantly.
-
Connect ZohoExpense to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live ZohoExpense data using the CData Python MCP Server.
-
Connecting Moonlit Workflow with Phoenix 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 Phoenix data in real time.
-
Link Attio with FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Attio data in Filemaker Pro for Mac or Windows.
-
Automated Continuous SAP BusinessObjects BI Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable SAP BusinessObjects BI replication to Google BigQuery.
-
Use Biml to Build SSIS Tasks to Replicate Bright Data Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Bright Data data to SQL Server.
-
Access SendGrid Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live SendGrid data from HeidiSQL.
-
How to Connect to LeadDesk Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to LeadDesk data. Leverage the pyodbc module for ODBC in Python.
-
Query BambooHR Data through ODBC in Node.js
Use node-odbc to execute SQL queries against BambooHR data from Node.js.
-
Create Informatica Mappings From/To a JDBC Data Source for xBase
Create xBase data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Missive Reporting in OBIEE with the Missive JDBC Driver
Deploy the Missive JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Configure the CData JDBC Driver for Unbounce in a Connection Pool in Tomcat
Connect to Unbounce data from a connection pool in Tomcat.
-
Work with Missive Data in FoxPro
Load Missive data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Integrating Codex with JDBC-ODBC Bridge 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.
-
Use Agno to Talk to Your Highrise 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 Highrise data for you.
-
Connect to Real-Time Coinbase Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Coinbase data in Power Apps.
-
Process & Analyze Blackbaud FE NXT Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Blackbaud FE NXT Data.
-
Excel Spreadsheet Automation on MailerSend Data with the QUERY Formula
Pull data from MailerSend, automate spreadsheets, and more with the QUERY formula.
-
Natively Connect to Monday.com Data in PHP
The CData ODBC driver for Monday.com enables you to create PHP applications with connectivity to Monday.com data. Leverage the native support for ODBC in PHP.
-
Extract, Transform, and Load CSV Data in Informatica PowerCenter
Create a simple Workflow for CSV data in Informatica PowerCenter.
-
How to Seamlessly Import CampaignMonitor Data into IBM SPSS Modeler
Integrate CampaignMonitor data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Load Google Calendar Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Google Calendar data to a database.
-
Build Data Flows from Google Ad Manager to SQL Server using SSIS
Easily back up Google Ad Manager data to SQL Server using the SSIS components for Google Ad Manager.
-
Easily Integrate Yelp Data in Lazarus Pascal IDE
Learn how to easily integrate live Yelp data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Write a Simple Go Application to work with Toggl Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Toggl data.
-
Integrate with ZohoExpense Data in SnapLogic
Use CData Connect AI to connect to and integrate with live ZohoExpense data in SnapLogic.
-
Build MYOB AccountRight-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live MYOB AccountRight data and build MYOB AccountRight-connected web apps with Axios.
-
Use Manus AI to Talk to Your Anaplan 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 Anaplan data.
-
Connect to YouTube Analytics Data from HeidiSQL
Use CData Connect AI to connect to and query live YouTube Analytics data from HeidiSQL.
-
Getting Started with the CData Excel Add-In for ChargeOver
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for ChargeOver.
-
Access Microsoft Teams Data in Mule Applications Using the CData JDBC Driver
Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for Microsoft Teams data.
-
Integrating Claude Code with SAP Hybris C4C Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on SAP Hybris C4C data within assisted coding and automated development workflows.
-
Build an OLAP Cube in SSAS from Oracle HCM Cloud Data
Establish a connection to Oracle HCM Cloud data data from SQL Server Analysis Services, and use the Oracle HCM Cloud Data Provider to build OLAP cubes for use in analytics and reporting.
-
Create Reports with Tavily Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Tavily data.
-
Work with Live IBM Cloud Object Storage Data in Power Query
Use CData Connect AI to connect to IBM Cloud Object Storage data and work with live IBM Cloud Object Storage data in Microsoft Power Query.
-
A PostgreSQL Interface for Supabase Data using the CData ODBC Driver
Use the SQL Gateway and Supabase ODBC Driver to create a PostgreSQL entry-point for data access.
-
Model NetSuite SuiteAnalytics Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and NetSuite SuiteAnalytics, enabling the direct import of real-time NetSuite SuiteAnalytics data.
-
Create Dynamic Acumatica Grids Using the Infragistics XamDataGrid
Learn how you can connect Acumatica to Infragistics XamDataGrid to build dynamic grids.
-
Automated Continuous Mocean Replication to SQLite
Use CData Sync for automated, continuous, customizable Mocean replication to SQLite.
-
Connect to Power BI XMLA Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Power BI XMLA data in Airbyte.
-
Query Live CockroachDB 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 CockroachDB data through a conversational interface.
-
Integrate Live Gmail 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 Gmail data from within the IDE.
-
Connect to RSS Feeds from PowerBuilder via ADO.NET
This article demonstrates how to access RSS feeds from Appeon PowerBuilder using the CData ADO.NET Provider for RSS.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Stack Exchange
Provide connectivity to Stack Exchange data through an SAP BusinessObjects universe.
-
Write a Simple Go Application to work with Landbot Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Landbot data.
-
How to connect to Excel Data from Spring Boot
Connect to Excel in a Spring Boot Application using the CData JDBC Driver for Excel
-
Connect to JSON Services Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for JSON and the Script function in FileMaker Pro to connect to JSON and work with JSON services in your FileMaker application.
-
Connect to QuickBooks Time Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with QuickBooks Time Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Analyze MariaDB Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of MariaDB data and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Access Live Attio Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Attio data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Query BigQuery Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume BigQuery entities in PHP by modeling them as objects.
-
Interact with Live SAP SuccessFactors LMS Data in Meta Muse via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Muse to securely interact with live SAP SuccessFactors LMS data.
-
Query, Visualize, and Share live Adobe Analytics Data in Redash
Use CData Connect AI to connect to live Adobe Analytics data in Redash for querying, visualizing, and sharing.
-
Query MYOB AccountRight Data as a MySQL Database in Node.js
Execute MySQL queries against MYOB AccountRight data from Node.js.
-
Connect to and Query Teamwork Data in QlikView over ODBC
Create data visualizations with Teamwork data in QlikView.
-
How to Easily Query Trello Data in OpenOffice Base
Connect to Trello data in OpenOffice Base using the CData ODBC Driver for Trello and generate reports with live data insights.
-
Natively Connect to Facebook Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Facebook data. Leverage the native support for ODBC in PHP.
-
Use the CData Software JDBC Driver for Calendly in MicroStrategy Web
Connect to Calendly data in MicroStrategy Web using the CData Software JDBC Driver for Calendly.
-
Use the CData Software JDBC Driver for LinkedIn in MicroStrategy Desktop
Connect to LinkedIn data in MicroStrategy Desktop using the CData Software JDBC Driver for LinkedIn.
-
ETL Freshteam in Oracle Data Integrator
This article shows how to transfer Freshteam data into a data warehouse using Oracle Data Integrator.
-
Connect to Live QuickBooks Online Data in MicroStrategy through CData Connect AI
Create a live connection to QuickBooks Online Data in CData Connect AI and connect to your QuickBooks Online data from MicroStrategy.
-
How to connect to OData Services from Spring Boot
Connect to OData in a Spring Boot Application using the CData JDBC Driver for OData
-
A PostgreSQL Interface for Keap Data (MySQL Remoting via JDBC)
Use the Remoting features of the Keap JDBC Driver to create a PostgreSQL entry-point for data access.
-
Create Grafana-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Grafana Data from Klipfolio and build custom visualizations using live Grafana data.