CData Software - Knowledge Base
Recent Articles
-
Import Real-Time Azure Table Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Azure Table data in ColdFusion.
-
Connect to Vercel in SpagoBI
Create reports featuring live Vercel data in SpagoBI Studio. Host Vercel reports on SpagoBI Server.
-
Access Live Jira Assets Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Jira Assets data into the statistical analysis tools available in SAS JMP. This article shows how to use Jira Assets data in the Graph Builder and Query Builder.
-
Automated Continuous CockroachDB Replication to AlloyDB
Use CData Sync for automated, continuous, customizable CockroachDB replication to AlloyDB.
-
Automated Continuous Odoo Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Odoo replication to Amazon S3.
-
Use the CData Software ODBC Driver for Shortcut in SAS for Real-Time Reporting and Analytics
Connect to real-time Shortcut data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Shortcut.
-
How to Connect Facebook Data to Gemini Enterprise via CData Connect AI
Connect CData Connect AI Remote MCP to Gemini Enterprise to securely read and take actions on live Facebook data in real time using natural language.
-
Build Kintone-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Kintone data and build Kintone-connected web apps with Axios.
-
Use Biml to Build SSIS Tasks to Replicate Supabase Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Supabase data to SQL Server.
-
Connect to and Query Twitter Ads Data in QlikView over ODBC
Create data visualizations with Twitter Ads data in QlikView.
-
Create SSAS Tabular Models from Snowflake Data
How to build a SQL Server Analysis Service Tabular Model from Snowflake data using CData drivers.
-
Automate Amazon Athena Data Replication to SAP HANA
Use CData Sync to customize and automate Amazon Athena data replication to SAP HANA.
-
Getting Started with the CData ODBC Driver for Smartsheet
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Smartsheet.
-
Build AI/ML Models with Live Qualaroo Data using Dataiku
Connect Qualaroo Data with Dataiku using the CData API Driver for JDBC.
-
How to connect to Facebook Ads Data in DBVisualizer
Integrate Facebook Ads data with visual data analysis tools and data connection wizards in DBVisualizer
-
Create Sugar CRM-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Sugar CRM Data from Klipfolio and build custom visualizations using live Sugar CRM data.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for CSV
Provide connectivity to CSV data through an SAP BusinessObjects universe.
-
Access Live Email Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Email data from your Google Sheets.
-
How to Access EnterpriseDB Data Using Entity Framework
This article shows how to access EnterpriseDB data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Automate Microsoft Exchange Data Replication to Couchbase
Use CData Sync to Customize and automate Microsoft Exchange data replication to Couchbase.
-
Build Data Flows from SQL Server to ActiveCampaign through SSIS
Easily push SQL Server data to ActiveCampaign using the CData SSIS Tasks for ActiveCampaign.
-
Automated Continuous Qualaroo Replication to MongoDB
Use CData Sync for automated, continuous, customizable Qualaroo replication to MongoDB.
-
Access Live Google Directory 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 Google Directory data through MCP integration.
-
Stream Recurly Data into Apache Kafka Topics
Access and stream Recurly data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Automated Continuous Sendwithus Replication to Vertica
Use CData Sync for automated, continuous, customizable Sendwithus replication to Vertica.
-
Getting Started with the CData Tableau Connector for Clio
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Replicate WordPress Data in Heroku for Use in Salesforce Connect
Replicate WordPress data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Build AI Agents with ZohoExpense 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 ZohoExpense data through CData Connect AI.
-
How to connect to Deel Data with Squirrel SQL client
Connect to Deel data and execute queries in the Squirrel SQL Client.
-
Connect to Clari Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Clari data in the Denodo Virtual DataPort Administrator.
-
Create Instagram Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Instagram from PowerBI.com to create Power BI Dataflows with real-time data.
-
Connect to HubSpot Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for HubSpot data in Airbyte.
-
Integrate Dynamics CRM Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Dynamics CRM data and integrate live Dynamics CRM data into your Power Automate tasks.
-
Integrate EnterpriseDB Data into Power Automate Desktop using CData Connect
CData Connect for EnterpriseDB Data enables you to integrate EnterpriseDB data into workflows built using Microsoft Power Automate Desktop.
-
Integrate Goose with Live Aweber Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Aweber data from within the local AI agent.
-
Connect to ServiceDesk Plus Data in ACL Analytics
Connect to ServiceDesk Plus data via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to ServiceDesk Plus data.
-
Connect PhantomBuster to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect PhantomBuster with IBM WebSphere for seamless data integration and connectivity.
-
Use JayDeBeApi to access Google Spanner Data in Python
Use standard Python scripting and the development environment of your choice to access live Google Spanner data.
-
Explore Geographical Relationships in WordPress Data with Power Map
Create data visualizations with WordPress data in Power Map.
-
Use Dash to Build to Web Apps on SageHR Data
Create Python applications that use pandas and Dash to build SageHR-connected web apps.
-
Connect to Live WooCommerce Data in MicroStrategy through CData Connect AI
Create a live connection to WooCommerce Data in CData Connect AI and connect to your WooCommerce data from MicroStrategy.
-
Connect to Google Forms Data in RazorSQL
Connect to Google Forms from wizards and query Google Forms data from the GUI in the RazorSQL database management tool.
-
Integrate Opsgenie Data in the Pentaho Report Designer
Publish reports based on Opsgenie data in the Pentaho BI tool.
-
Use Agno to Talk to Your HubSpot 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 HubSpot data for you.
-
Analyze Sage 300 Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Sage 300 data and visualize Sage 300 data in SAP Analytics Cloud.
-
Query Facebook Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Facebook entities in PHP by modeling them as objects.
-
Build Microsoft Ads-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Microsoft Ads data and build Microsoft Ads-connected web apps with Axios.
-
How to Connect to Sage Intacct Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Sage Intacct data. Leverage the pyodbc module for ODBC in Python.
-
Connect to Google Spanner Data in NetBeans
Connect to Google Spanner data in NetBeans with the data source configuration wizard.
-
Integrating Gumloop with Sybase Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Sybase data within automated workflows.
-
How to Query Live SharePoint Excel Services Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live SharePoint Excel Services data data in natural language using Python.
-
Integrating OpenCode with SingleStore 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.
-
Analyze AgileCRM Data in Cognos Analytics
Use CData Connect AI to connect to AgileCRM Data from Cognos Analytics and analyze live AgileCRM data.
-
How to Connect to Live AfterShip 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 AfterShip data for you.
-
Rapidly Develop Avro-Driven Apps with Active Query Builder
Leverage the Active Query Builder SQL interface and .NET data access to create data-driven WinForms and ASP.NET apps backed by Avro.
-
Migrating data from SAP SuccessFactors to Databricks using CData SSIS Components.
Easily push SAP SuccessFactors data to Databricks using the CData SSIS Tasks for SAP SuccessFactors and Databricks.
-
How to Seamlessly Import Google Contacts Data into IBM SPSS Modeler
Integrate Google Contacts data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Connect to SpaceX Data in NetBeans
Connect to SpaceX data in NetBeans with the data source configuration wizard.
-
Connect to Zoho Creator Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Zoho Creator to connect to Zoho Creator data and execute queries in PowerBuilder.
-
Automated Continuous Mode Replication to MongoDB
Use CData Sync for automated, continuous, customizable Mode replication to MongoDB.
-
Create Informatica Mappings From/To a JDBC Data Source for OpenWeatherMap
Create OpenWeatherMap data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
How to Connect to Live SingleStore 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 SingleStore data for you.
-
Visualize Google Spanner 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 Google Spanner data into TIBCO Spotfire.
-
How to Build an ETL App for Yelp Data in Python with CData
Create ETL applications and real-time data pipelines for Yelp data in Python with petl.
-
How to Connect to Live Bannerbear 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 Bannerbear data for you.
-
Automate Presto Data Replication to SAP HANA
Use CData Sync to customize and automate Presto data replication to SAP HANA.
-
Build an OLAP Cube in SSAS from CouchDB Data
Establish a connection to CouchDB data data from SQL Server Analysis Services, and use the CouchDB Data Provider to build OLAP cubes for use in analytics and reporting.
-
Enable the Cloudant JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Cloudant data.
-
Use Biml to Build SSIS Tasks to Replicate Mixpanel Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Mixpanel data to SQL Server.
-
Build MVC Applications with Connectivity to Exa Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Exa from an ASP.NET MVC application.
-
Access Live AdRoll Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate AdRoll data into the statistical analysis tools available in SAS JMP. This article shows how to use AdRoll data in the Graph Builder and Query Builder.
-
Access Live ZohoExpense Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to ZohoExpense data from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Build Automated Dropbox-Connected Workflows in Zapier
Use CData Connect AI to connect to live Dropbox data and build automated workflows in Zapier.
-
Connect to Coda Data in NetBeans
Connect to Coda data in NetBeans with the data source configuration wizard.
-
Build IBM Informix-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to IBM Informix data and build web apps with connectivity to live IBM Informix data.
-
Connect Copper to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Copper data using the CData Python MCP Server.
-
Build Automated Bullhorn CRM-Connected Workflows in Zapier
Use CData Connect AI to connect to live Bullhorn CRM data and build automated workflows in Zapier.
-
Automated Continuous Google Campaign Manager 360 Replication to Snowflake
Use CData Sync for automated, continuous, customizable Google Campaign Manager 360 replication to Snowflake.
-
A PostgreSQL Interface for Short.io Data using the CData ODBC Driver
Use the SQL Gateway and Short.io ODBC Driver to create a PostgreSQL entry-point for data access.
-
Analyze Act CRM Data in Cognos Analytics
Use CData Connect AI to connect to Act CRM Data from Cognos Analytics and analyze live Act CRM data.
-
Integrating Boomi Agentstudio with Apify Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Apify data, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Publish SparkPost-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live SparkPost data.
-
Replicate Multiple ZohoSubscriptions Accounts via the CData Sync CLI
Replicate multiple ZohoSubscriptions accounts to one or many databases.
-
Connect to PagerDuty Data in DBeaver
Use the CData ODBC Driver to connect to PagerDuty data in DBeaver.
-
Use the CData Software ODBC Driver for LightSpeedRetail in MicroStrategy Web
Connect to LightSpeedRetail data in MicroStrategy Web using the CData Software ODBC Driver for LightSpeedRetail.
-
ETL Demio in Oracle Data Integrator
This article shows how to transfer Demio data into a data warehouse using Oracle Data Integrator.
-
Access Live Azure Data Lake Storage Data in AWS Lambda
Connect to live Azure Data Lake Storage data in AWS Lambda using the CData JDBC Driver.
-
How to publish and share Dynamics 365 Data dashboards with Tableau Server
The CData ODBC driver for Dynamics 365 enables you integrate Dynamics 365 data into Tableau dashboards.
-
View Reports on Real-Time Front Data in Power BI Report Server
Use the CData ODBC Driver for Front to visualize Front data in Power BI Desktop and then publish them to Power BI Report Server.
-
Use Agno to Talk to Your BigQuery 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 BigQuery data for you.
-
Access Gorgias Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Gorgias data from your Oracle system.
-
Visualize Live Pipeline CRM Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Pipeline CRM data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Load Invoiced Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Invoiced data to a database.
-
Connect to Avaza Data in RazorSQL
Connect to Avaza from wizards and query Avaza data from the GUI in the RazorSQL database management tool.
-
Automated Continuous JobNimbus Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable JobNimbus replication to PostgreSQL.
-
Build AgileCRM-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for AgileCRM Data and create custom apps in Bubble.
-
How to integrate Metabase with Grafana Data
Use CData Connect AI to connect to live Grafana data and create an interactive dashboard in Metabase from Grafana data.
-
Query Demio Data in DataGrip
Create a Data Source for Demio in DataGrip and use SQL to query live Demio data.
-
Analyze Zoho Creator Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Zoho Creator data in Microsoft R Open.
-
Integrating Codex with Airtable 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.