CData Software - Knowledge Base
Recent Articles
-
Use Databricks Agent Bricks to Talk to Your ZohoMarketingHub Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your ZohoMarketingHub data for you.
-
Getting Started with the CData ODBC Driver for Microsoft Teams
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Microsoft Teams.
-
Integrating Antigravity CLI with Square data via CData CLI
Connect Square data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
How to connect to Coda Data in DBVisualizer
Integrate Coda data with visual data analysis tools and data connection wizards in DBVisualizer
-
Build a Singer.io Tap for Okta With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Okta data using the CData Python Connector.
-
Build Semantic Layer Views for SAP SuccessFactors LMS Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for SAP SuccessFactors LMS data.
-
Object-Relational Mapping (ORM) with Exa 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 Exa data into a Java-based ORM framework, Hibernate.
-
Use the CData Software ODBC Driver for SAP Business One in SAS for Real-Time Reporting and Analytics
Connect to real-time SAP Business One data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for SAP Business One.
-
Import Real-Time PDFMonkey Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use PDFMonkey data in ColdFusion.
-
Connect to and Visualize Live MailChimp Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live MailChimp data.
-
Feed Short.io Data into FineReport
How to set Short.io data as a JDBC data source in FineReport.
-
Analyze ActiveCampaign Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for ActiveCampaign from Power Pivot. You will use the Table Import Wizard to load ActiveCampaign data. You can visually build the import query or use any SQL supported by the driver.
-
Migrating data from Autopilot to Databricks using CData SSIS Components.
Easily push Autopilot data to Databricks using the CData SSIS Tasks for Autopilot and Databricks.
-
Integrating FreshBooks Data in Talend Cloud Data Management Platform
Connect FreshBooks Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Automated Continuous Qualaroo Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Qualaroo replication to Azure SQL Database.
-
Connect to Outlook Data in DBeaver
Use the CData ODBC Driver to connect to Outlook data in DBeaver.
-
Access Live ZohoSubscriptions Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live ZohoSubscriptions data from your Excel spreadsheets.
-
Rapidly Develop Google Analytics-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 Google Analytics.
-
How to Easily Query Teradata Data in OpenOffice Base
Connect to Teradata data in OpenOffice Base using the CData ODBC Driver for Teradata and generate reports with live data insights.
-
View Reports on Real-Time ZohoMarketingHub Data in Power BI Report Server
Use the CData ODBC Driver for ZohoMarketingHub to visualize ZohoMarketingHub data in Power BI Desktop and then publish them to Power BI Report Server.
-
Connect Freshteam to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Freshteam with IBM WebSphere for seamless data integration and connectivity.
-
Integrating OpenCode with Dynamics CRM 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.
-
Access Live Azure Data Lake Storage Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Azure Data Lake Storage data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Visualize Live PabblySubscriptions Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live PabblySubscriptions data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Natively Connect to Google Forms Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Google Forms data. Leverage the native support for ODBC in PHP.
-
Create Dynamic Sugar CRM Grids Using the Infragistics XamDataGrid
Learn how you can connect Sugar CRM to Infragistics XamDataGrid to build dynamic grids.
-
Import Real-Time EmailOctopus Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use EmailOctopus data in ColdFusion.
-
Back Up MongoDB data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for MongoDB. In this article, we will employ an SSIS workflow to populate a database with MongoDB data data.
-
Getting Started with the CData Python Connector for SurveyMonkey
Learn to install and license the CData Python Connector and configure a connection to live SurveyMonkey data.
-
Connect to VWO Data from a Connection Pool in JBoss
Integrate VWO data into Java servlets: Use the Management Console in JBoss to install the VWO JDBC Driver.
-
Write a Simple Go Application to work with Adobe Experience Manager Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Adobe Experience Manager data.
-
Create Dynamic QuickBooks Grids Using the Infragistics XamDataGrid
Learn how you can connect QuickBooks to Infragistics XamDataGrid to build dynamic grids.
-
Work with Salesforce Pardot Data in FoxPro
Load Salesforce Pardot data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Access Live ZohoMarketingHub Data in AWS Lambda
Connect to live ZohoMarketingHub data in AWS Lambda using the CData JDBC Driver.
-
Build Data Flows from Azure Synapse to SQL Server using SSIS
Easily back up Azure Synapse data to SQL Server using the SSIS components for Azure Synapse.
-
Create Reports from Salesforce Data in Looker Studio
Use CData Connect AI to gain access to live Salesforce data and create custom reports in Looker Studio.
-
How to create Visio diagrams from SingleStore Data
Automatically update SingleStore data with the changes you make to Visio master shapes.
-
Getting Started with the CData Excel Add-In for Google Analytics
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Google Analytics.
-
Visualize Live Access Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Access data.
-
Import Real-Time ZeroBounce Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use ZeroBounce data in ColdFusion.
-
How to Build an ETL App for Twitter Ads Data in Python with CData Connect AI
Extract and transform live Twitter Ads data in Python with petl and the CData Connect AI Python SDK.
-
Use the CData Software ODBC Driver for Exact Online in SAS for Real-Time Reporting and Analytics
Connect to real-time Exact Online data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Exact Online.
-
Replicate Toggl Data to Multiple Databases via the CData Sync CLI
Replicate Toggl data to disparate databases with a single configuration.
-
Create Apps from Couchbase Data in Qlik Sense Cloud
Use CData Connect AI to connect to Couchbase Data and build apps from live Couchbase data in Qlik Sense Cloud.
-
How to Connect to Live Amazon DynamoDB 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 Amazon DynamoDB data for you.
-
Getting Started with the CData ODBC Driver for Zendesk
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Zendesk.
-
Getting Started with the CData Python Connector for Vault CRM
Learn to install and license the CData Python Connector and configure a connection to live Vault CRM data.
-
Query Grafana Data in ColdFusion
Write standard ColdFusion data access code to connect to Grafana data.
-
Building Dynamic Web Pages with Excel Online Data Using AngularJS
Create single-page applications with live connectivity to Excel Online using the CData API Server.
-
Use JayDeBeApi to access Customer.io Data in Python
Use standard Python scripting and the development environment of your choice to access live Customer.io data.
-
Automated Continuous SAP HANA XS Advanced Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable SAP HANA XS Advanced data replication to OneLake in Microsoft Fabric.
-
Automated Continuous Todoist Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Todoist replication to Google Cloud SQL.
-
Easily Integrate Optimizely Data in Lazarus Pascal IDE
Learn how to easily integrate live Optimizely data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Opsgenie Reporting in OBIEE with the Opsgenie JDBC Driver
Deploy the Opsgenie JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
How to Work with Sendwithus Data in AWS Glue Jobs Using JDBC
Connect to Sendwithus from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
How to connect to Zoom Data from IntelliJ
Integrate connectivity to Zoom data with wizards in IntelliJ.
-
Connect to Trello Data from a Connection Pool in JBoss
Integrate Trello data into Java servlets: Use the Management Console in JBoss to install the Trello JDBC Driver.
-
Prepare, Blend, and Analyze SuiteCRM Data in Alteryx Designer (Connect AI)
Build workflows to access live SuiteCRM data for self-service data analytics.
-
Create Azure Analysis Services-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Azure Analysis Services Data from Klipfolio and build custom visualizations using live Azure Analysis Services data.
-
How to connect to SAP Ariba Source Data in DBVisualizer
Integrate SAP Ariba Source data with visual data analysis tools and data connection wizards in DBVisualizer
-
Create SAP HANA XS Advanced-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to SAP HANA XS Advanced Data from OutSystems and build custom enterprise apps using live SAP HANA XS Advanced data.
-
Build MVC Applications with Connectivity to Google Forms Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Google Forms from an ASP.NET MVC application.
-
Design BIRT Reports on LinkedIn Data
Provide current LinkedIn data to your embedded analytics.
-
Load Jumpseller Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Jumpseller data to a database.
-
Connect to Flowlu Data in Aqua Data Studio
Access Flowlu data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Use Biml to Build SSIS Tasks to Replicate Eventbrite Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Eventbrite data to SQL Server.
-
Connecting Moonlit Workflow with SAP Ariba Source 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 SAP Ariba Source data in real time.
-
Automated Continuous Box Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Box replication to Google Cloud SQL.
-
How to Connect the Power BI Service to Oracle Service Cloud: Complete Guide
Connect to the CData Software Power BI Connector for Oracle Service Cloud from PowerBI.com to provide real-time Oracle Service Cloud data across the organization.
-
Connect and Visualize Live Azure Table Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Azure Table data into the Databricks platform and create visualization dashboards with real-time Azure Table data.
-
Access Live Grafana 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 Grafana data through MCP integration.
-
Prepare, Blend, and Analyze Acumatica Data in Alteryx Designer (ODBC)
Build workflows to access live Acumatica data for self-service data analytics.
-
Integrate Cursor with Live Procore Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Procore data from within the editor.
-
Stream Box Data into Apache Kafka Topics
Access and stream Box data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Replicate Coinbase Data in Heroku for Use in Salesforce Connect
Replicate Coinbase data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
How to Easily Query CircleCI Data in OpenOffice Base
Connect to CircleCI data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Use Azure AI Foundry to Talk to Your Microsoft OneDrive 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 Microsoft OneDrive data for you.
-
Integrate Live Jira Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Jira data and integrate live Jira data into apps built in Microsoft Power Apps.
-
Build Dashboards with Azure Analysis Services Data in Dundas BI
Create dynamic dashboards and perform analytics based on Azure Analysis Services data in Dundas BI.
-
Connecting Moonlit Workflow with Microsoft Ads 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 Microsoft Ads data in real time.
-
Access Live Paylocity Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Paylocity data from your Google Sheets.
-
Use the CData Software ODBC Driver for Paylocity in MicroStrategy Web
Connect to Paylocity data in MicroStrategy Web using the CData Software ODBC Driver for Paylocity.
-
Connect to QuickBooks Time 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 QuickBooks Time data.
-
Extract, Transform, and Load Rebilly Data in Informatica PowerCenter
Create a simple Workflow for Rebilly data in Informatica PowerCenter.
-
Connect to Asana from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Asana data, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Build Voice Agents in ElevenLabs with access to Live LDAP Objects
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live LDAP objects.
-
Connect to IBM Informix Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for IBM Informix to connect to IBM Informix data and execute queries in PowerBuilder.
-
How to Connect Flowise AI Agents to Live Zoom Data via CData Connect AI
Integrate Flowise AI with the CData Connect AI MCP Server to enable agents to securely query and act on live Zoom data without replication.
-
Integrating LangChain with Salesforce Pardot Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Salesforce Pardot data within automated workflows.
-
Connect to and Query FreshBooks Data in QlikView over ODBC
Create data visualizations with FreshBooks data in QlikView.
-
Build Dashboards with Avaza Data in Dundas BI
Create dynamic dashboards and perform analytics based on Avaza data in Dundas BI.
-
Model Microsoft Teams Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Microsoft Teams, enabling the direct import of real-time Microsoft Teams data.
-
Access Browserless Data from MySQL in PHP
Connect to Browserless through the standard MySQL libraries in PHP.
-
Connect to Zendesk Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Zendesk data.
-
How to Build an ETL App for Moosend Data in Python with CData Connect AI
Extract and transform live Moosend data in Python with petl and the CData Connect AI Python SDK.
-
Connect to Google Ad Manager Data in Ruby
Connect to Google Ad Manager data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
How to Connect Dropbox 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 Dropbox data in real time using natural language.
-
Access FreshBooks 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 FreshBooks data.
-
How to publish and share Guru Data dashboards with Tableau Server
The CData ODBC driver for Guru enables you integrate Guru data into Tableau dashboards.
-
Query Live MariaDB 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 MariaDB data directly from the development environment.