CData Software - Knowledge Base
Recent Articles
-
Access Live Sybase Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Sybase data from your Google Sheets.
-
How to import Dynamics 365 Data into Apache Solr
Use the CData Software JDBC Driver for Dynamics 365 in Data Import Handler and create an automated import of Dynamics 365 data to Apache Solr Enterprise Search platform.
-
Add Workable Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Workable with the Informatica Enterprise Data Catalog to classify and organize data.
-
Integrate Notion Data in Pentaho Data Integration
Build ETL pipelines based on Notion data in the Pentaho Data Integration tool.
-
Access Sendwithus Data from MySQL in PHP
Connect to Sendwithus through the standard MySQL libraries in PHP.
-
Visualize Live ZohoPeople Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live ZohoPeople data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Integrating Gumloop with Paylocity Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Paylocity data within automated workflows.
-
Use Databricks Agent Bricks to Talk to Your Blackbaud FE NXT Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Blackbaud FE NXT data for you.
-
Extract, Transform, and Load Perplexity Data in Informatica PowerCenter
Create a simple Workflow for Perplexity data in Informatica PowerCenter.
-
Object-Relational Mapping (ORM) with Nuclia Data Entities in Java
Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to Nuclia data into a Java-based ORM framework, Hibernate.
-
Access Live Zoho CRM Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Zoho CRM data from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Publish Crystal Reports on Odoo Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Odoo data.
-
Integrating Kiro with SAP ByDesign 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 Dashboards and Visualize Live Xero Data in Geckoboard
Use CData Connect AI to connect to live Xero data and create dashboards for real-time monitoring and visualization in Geckoboard.
-
How to Connect to Live ZohoExpense 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 ZohoExpense data through natural language.
-
Query Live Microsoft Entra ID 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 Microsoft Entra ID data directly from the development environment.
-
How to connect SharePoint with Monday.com Data through external lists
Provide Monday.com data to SharePoint users as an external list.
-
How to use SQLAlchemy ORM to access Gorgias Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Gorgias data.
-
Build WooCommerce-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live WooCommerce data.
-
Excel Spreadsheet Automation on FreshBooks Data with the QUERY Formula
Pull data from FreshBooks, automate spreadsheets, and more with the QUERY formula.
-
Automated Continuous SAP ByDesign Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable SAP ByDesign replication to Apache Cassandra.
-
Getting Started with the CData SSIS Components for Workday
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Workday.
-
Create Reports with Mode Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Mode data.
-
Import Real-Time Sage 300 Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Sage 300 data in ColdFusion.
-
Link Azure Data Lake Storage with FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Azure Data Lake Storage data in Filemaker Pro for Mac or Windows.
-
Use the CData ODBC Driver for Salesforce Marketing from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Salesforce Marketing to connect to Salesforce Marketing data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Salesforce Marketing data in Excel.
-
Create Data Visualizations in Cognos BI with Google Ad Manager Data
Access Google Ad Manager data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Automated Continuous Jira Replication to Databricks
Use CData Sync for automated, continuous, customizable Jira replication to Databricks.
-
Create Data Visualizations Based On TaxJar Data in Mode
Use CData Connect AI to connect to TaxJar Data from Mode and build visualizations using live TaxJar data.
-
Integrating Dataiku with Cloudflare Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Cloudflare data.
-
How to Connect to Live Azure Table Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Azure Table data securely in real time.
-
Excel Spreadsheet Automation on Zoho Projects Data with the QUERY Formula
Pull data from Zoho Projects, automate spreadsheets, and more with the QUERY formula.
-
Automate ServiceDesk Plus Data Replication to Azure Data Lake
Use CData Sync to customize and automate ServiceDesk Plus data replication to Azure Data Lake.
-
Integrate with Zoho Creator Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Zoho Creator data to a JSON file on disk.
-
Use Databricks Agent Bricks to Talk to Your SAP Concur Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your SAP Concur data for you.
-
Query SharePoint Data as a SQL Server Database in Node.js
Execute SQL Server queries against SharePoint data from Node.js.
-
How to Access Templated Data Using Entity Framework
This article shows how to access Templated data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Getting Started with the CData ODBC Driver for Basecamp
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Basecamp.
-
Integrate Goose with Live Excel Online Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Excel Online data from within the local AI agent.
-
How to Connect to Live NetSuite SuiteAnalytics 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 NetSuite SuiteAnalytics data through natural language.
-
Connect MongoDB Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your MongoDB data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Replicate Aircall Data in Heroku for Use in Salesforce Connect
Replicate Aircall data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Connect to Live Attio Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Attio in CData Connect AI and connect to your Attio data from PostgreSQL.
-
ETL FormSite in Oracle Data Integrator
This article shows how to transfer FormSite data into a data warehouse using Oracle Data Integrator.
-
Analyze Telegram Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Telegram data in Microsoft R Open.
-
Build Semantic Layer Views for AlloyDB Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for AlloyDB data.
-
Use Claude to Talk to Your Snapchat Ads Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your Snapchat Ads data for you.
-
How to Build an ETL App for Intercom Data in Python with CData
Create ETL applications and real-time data pipelines for Intercom data in Python with petl.
-
Access Live Attio Data in Coginiti Pro
Connect to and query live Attio data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
How to Connect to Live Oracle HCM Cloud Data from Google ADK Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Google ADK agents to securely read and take actions on your Oracle HCM Cloud data for you.
-
Publish Crystal Reports on Oracle Service Cloud Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Oracle Service Cloud data.
-
Build Visualizations of LaunchDarkly Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of LaunchDarkly data in Birst.
-
Create Apps from Reckon Data in Qlik Sense Cloud
Use CData Connect AI to connect to Reckon Data and build apps from live Reckon data in Qlik Sense Cloud.
-
Use Azure AI Foundry to Talk to Your Mailgun 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 Mailgun data for you.
-
Connecting Agentforce with Dynamics CRM 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 Dynamics CRM data for you.
-
Connect to MySQL Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live MySQL data from Filemaker Pro on Mac.
-
Build Quickbase Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Quickbase data and build visualizations in Tableau Cloud.
-
Build Tavily-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Tavily data and build Tavily-connected web apps with Axios.
-
Getting Started with the CData ADO.NET Provider for Supabase
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Write a Simple Go Application to work with Zoho Books Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Zoho Books data.
-
How to connect PolyBase to Recurly
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Recurly data.
-
How to connect to Amazon Marketplace Data with Squirrel SQL client
Connect to Amazon Marketplace data and execute queries in the Squirrel SQL Client.
-
Visualize CloudConvert Data in Tableau
The CData ODBC driver for CloudConvert enables you integrate CloudConvert data into Tableau dashboards.
-
Connect to Google Ad Manager Data from PowerBuilder via JDBC
This article demonstrates how to access Google Ad Manager data from PowerBuilder using the Google Ad Manager JDBC Driver.
-
Work with Freshteam Data in FoxPro
Load Freshteam data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Automated Continuous Aha! Replication to SQL Server
Use CData Sync for automated, continuous, customizable Aha! replication to SQL Server.
-
Access SAP BusinessObjects BI Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live SAP BusinessObjects BI data from HeidiSQL.
-
Build Semantic Layer Views for Omnisend Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Omnisend data.
-
Connect to Neo4J Data from HeidiSQL
Use CData Connect AI to connect to and query live Neo4J data from HeidiSQL.
-
Connect to SharePoint Excel Services Data from PowerBuilder via JDBC
This article demonstrates how to access SharePoint Excel Services data from PowerBuilder using the SharePoint Excel Services JDBC Driver.
-
Import Discord Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Discord Data and provide access to live Discord data for custom reports in the Power BI Service.
-
Automated Continuous Microsoft Teams Replication to SQL Server
Use CData Sync for automated, continuous, customizable Microsoft Teams replication to SQL Server.
-
Analyze SAP HANA XS Advanced Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze SAP HANA XS Advanced data with the CData JDBC Driver for SAP HANA XS Advanced.
-
Visualize Live SurveyMonkey Data in the Power BI Service
Use CData Connect AI to connect to live SurveyMonkey data and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Operational Reporting on Mixpanel Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Mixpanel data.
-
Viewing Salesloft Data in RAD Studio Data Explorer
How to view Salesloft data in RAD Studio Data Explorer using the CData ODBC Driver for Salesloft.
-
Query Gumroad Data in ColdFusion
Write standard ColdFusion data access code to connect to Gumroad data.
-
How to Access Redis Data Using Entity Framework
This article shows how to access Redis data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Automated Continuous Splunk Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Splunk replication to Google BigQuery.
-
Replicate Oracle Service Cloud Data to Multiple Databases via the CData Sync CLI
Replicate Oracle Service Cloud data to disparate databases with a single configuration.
-
Extract, Transform, and Load SAP Concur Data in Informatica PowerCenter
Create a simple Workflow for SAP Concur data in Informatica PowerCenter.
-
Work with Timely Data in FoxPro
Load Timely data into a FoxPro database. This article includes full code and a walk-through of the process.
-
A PostgreSQL Interface for BigCommerce Data (MySQL Remoting via JDBC)
Use the Remoting features of the BigCommerce JDBC Driver to create a PostgreSQL entry-point for data access.
-
Access Live Figshare 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 Figshare data through MCP integration.
-
Publish XML-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live XML data.
-
Connect to Productboard Data from PowerBuilder via JDBC
This article demonstrates how to access Productboard data from PowerBuilder using the Productboard JDBC Driver.
-
Use Manus AI to Talk to Your Zoho Books 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 Zoho Books data.
-
Load Elorus Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Elorus data to a database.
-
Use the CData Software ODBC Driver for Procore in SAS for Real-Time Reporting and Analytics
Connect to real-time Procore data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Procore.
-
Build MVC Applications with Connectivity to Mode Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Mode from an ASP.NET MVC application.
-
Create Informatica Mappings From/To a JDBC Data Source for Aircall
Create Aircall data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Access Deel Data from MySQL in PHP
Connect to Deel through the standard MySQL libraries in PHP.
-
Integrate Google's Vertex AI Agent with Live Snowflake Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Snowflake data within intelligent workflows.
-
Automated Continuous Tavily Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Tavily replication to Google Cloud SQL.
-
Explore Geographical Relationships in Anaplan Data with Power Map
Create data visualizations with Anaplan data in Power Map.
-
Automated Continuous Active Directory Replication to Vertica
Use CData Sync for automated, continuous, customizable Active Directory replication to Vertica.
-
Automated Continuous Azure DevOps Replication to Vertica
Use CData Sync for automated, continuous, customizable Azure DevOps replication to Vertica.
-
Create Trello-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Trello Data from Klipfolio and build custom visualizations using live Trello data.
-
How to Build an ETL App for SAP Concur Data in Python with CData
Create ETL applications and real-time data pipelines for SAP Concur data in Python with petl.
-
Access Live Clockify Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Clockify data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.