CData Software - Knowledge Base
Recent Articles
-
Connect to Dropbox Data from PowerBuilder via JDBC
This article demonstrates how to access Dropbox data from PowerBuilder using the Dropbox JDBC Driver.
-
Design BIRT Reports on Tickspot Data
Provide current Tickspot data to your embedded analytics.
-
Getting Started with the CData Python Connector for Paylocity
Learn to install and license the CData Python Connector and configure a connection to live Paylocity data.
-
Working with Simplesat Data in LINQPad
Execute LINQ queries to Simplesat data in LINQPad.
-
How to Connect to Live Zoho Projects 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 Zoho Projects data for you.
-
How to Easily Query ZeroBounce Data in OpenOffice Base
Connect to ZeroBounce data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Use Claude to Talk to Your Sage 300 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 Sage 300 data for you.
-
Replicate ZohoPeople Data to Multiple Databases
Replicate ZohoPeople data to disparate databases with a point-and-click configuration.
-
How to Connect to Live Greenhouse Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Greenhouse data securely in real time.
-
Create Dynamic Google Analytics Grids Using the Infragistics XamDataGrid
Learn how you can connect Google Analytics to Infragistics XamDataGrid to build dynamic grids.
-
Integrating LlamaIndex with Zoho Books Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Zoho Books data in real time.
-
Connect to Acumatica Data in Aqua Data Studio
Access Acumatica data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Automate Samanage Data Replication to Couchbase
Use CData Sync to Customize and automate Samanage data replication to Couchbase.
-
Build MVC Applications with Connectivity to ZohoMarketingHub Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access ZohoMarketingHub from an ASP.NET MVC application.
-
Integrate Google's Antigravity Agent with Live Cosmos DB Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Cosmos DB data using the Model Context Protocol.
-
Query Demio Data in ColdFusion
Write standard ColdFusion data access code to connect to Demio data.
-
Connect to Amazon S3 Data from PowerBuilder via JDBC
This article demonstrates how to access Amazon S3 data from PowerBuilder using the Amazon S3 JDBC Driver.
-
Connect to Bitbucket Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Bitbucket data in the Denodo Virtual DataPort Administrator.
-
Use Manus AI to Talk to Your Snowflake 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 Snowflake data.
-
Build AI Agents with Office 365 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 Office 365 data through CData Connect AI.
-
Connect to Real-Time TigerGraph Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for TigerGraph and Dataflow to import and use TigerGraph data in Power Apps.
-
Getting Started with the CData ADO.NET Provider for Azure DevOps
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Azure DevOps.
-
Use the CData ODBC Driver for HDFS from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for HDFS to connect to HDFS data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring HDFS data in Excel.
-
Connect to Google Directory Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Google Directory and the Script function in FileMaker Pro to connect to Google Directory and work with Google Directory data in your FileMaker application.
-
Use the CData Software ODBC Driver for Missive in SAS for Real-Time Reporting and Analytics
Connect to real-time Missive data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Missive.
-
Connect to Cassandra Data in Google Apps Script via Connect AI
Use CData Connect AI to access Cassandra data in Google Apps Script.
-
Integrate Theia IDE with Live SAS Data Sets 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 SAS Data Sets data from within the development environment.
-
Automated Continuous Demio Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Demio replication to Amazon S3.
-
Getting Started with the CData Excel Add-In for Adobe Target
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Adobe Target.
-
How to publish and share Zoho CRM Data dashboards with Tableau Server
The CData ODBC driver for Zoho CRM enables you integrate Zoho CRM data into Tableau dashboards.
-
Create Reports from SAP Concur Data in Looker Studio
Use CData Connect AI to gain access to live SAP Concur data and create custom reports in Looker Studio.
-
Visualize Live AlloyDB Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live AlloyDB data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Analyze Excel Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Excel data with the CData JDBC Driver for Excel.
-
Connect to Discord from a Connection Pool in WebLogic
Use the CData JDBC Driver for Discord to connect to Discord data from Web applications running on WebLogic.
-
Trigger Reckon IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for Reckon with standard wizards in Logic Apps.
-
How to create HelloSign federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for HelloSign data in MySQL .
-
How to Connect to Live Pipedrive Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Pipedrive data securely in real time.
-
Back Up SFTP data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for SFTP. In this article, we will employ an SSIS workflow to populate a database with SFTP data data.
-
Integrate LibreChat with Live Sybase Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Sybase data from within the chat interface.
-
Access Aweber 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 Aweber data.
-
How to Connect to Live Outreach.io 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 Outreach.io data for you.
-
Integrate with Azure Data Catalog Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Azure Data Catalog data to a JSON file on disk.
-
Access Live Sugar CRM 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 Sugar CRM data through MCP integration.
-
Work with BambooHR Data in FoxPro
Load BambooHR data into a FoxPro database. This article includes full code and a walk-through of the process.
-
How to integrate Adobe Analytics with Apache Airflow
Access and process Adobe Analytics data in Apache Airflow using the CData JDBC Driver.
-
Visualize Live SAP Ariba Source Data in the Power BI Service
Use CData Connect AI to connect to live SAP Ariba Source data and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Automated Continuous SharePoint Replication to SQL Server
Use CData Sync for automated, continuous, customizable SharePoint replication to SQL Server.
-
Connect to MarkLogic Data in DBeaver
Use the CData ODBC Driver to connect to MarkLogic data in DBeaver.
-
Connect and Query Live Trello Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Trello data into Databricks and enable direct, live querying and analysis without replication.
-
Automated Continuous Authorize.Net Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Authorize.Net replication to Apache Cassandra.
-
Use Dash to Build Web Apps on Jira Assets Data via CData Connect AI
Build interactive Dash web apps on live Jira Assets data using pandas and the CData Connect AI Python SDK.
-
How to Easily Query Teamwork Data in OpenOffice Base
Connect to Teamwork data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Integrating OpenCode with Unbounce 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.
-
Automated Continuous Zoho CRM Replication to MySQL
Use CData Sync for automated, continuous, customizable Zoho CRM replication to MySQL.
-
Access Live Monday.com Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Monday.com data into the statistical analysis tools available in SAS JMP. This article shows how to use Monday.com data in the Graph Builder and Query Builder.
-
Automated Continuous ServiceDesk Plus Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable ServiceDesk Plus data replication to OneLake in Microsoft Fabric.
-
Build Excel Online-Connected Apps in Choreo
Use CData Connect AI to connect to Excel Online Data from Choreo and build custom apps using live Excel Online data.
-
Create a Data Access Object for CloudConvert Data using JDBI
A brief overview of creating a SQL Object API for CloudConvert data in JDBI.
-
Access Live Retently Data in AWS Lambda
Connect to live Retently data in AWS Lambda using the CData JDBC Driver.
-
Replicate Helpscout Data to Multiple Databases via the CData Sync CLI
Replicate Helpscout data to disparate databases with a single configuration.
-
Integrate Zoho CRM with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Zoho CRM with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Zoho CRM data.
-
Operational Reporting on Supabase Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Supabase data.
-
Build AI/ML Models with Live Smartsheet Data using Dataiku
Connect Smartsheet Data with Dataiku using the CData JDBC Driver for Smartsheet.
-
Build Toggl-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Toggl data and build web apps with connectivity to live Toggl data.
-
Create Toggl Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Toggl data access from reports, embedded analytics, and more.
-
Connect to Webex Data in HULFT Integrate
Connect to Webex as a JDBC data source in HULFT Integrate
-
How to Visualize Elorus Data in Python with pandas
Use pandas and other modules to analyze and visualize live Elorus data in Python.
-
Integrate Mixpanel Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Mixpanel data from Informatica Cloud.
-
Seamlessly Bring BambooHR Data into Retool Using CData Connect AI
Integrate BambooHR data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
How to integrate Metabase with Tavily Data
Use CData Connect AI to connect to live Tavily data and create an interactive dashboard in Metabase from Tavily data.
-
Model, Search, and Visualize Live Apollo Data in ThoughtSpot
Use CData Connect AI to connect to live Apollo data for modeling, searching, and visualizing.
-
Build AI/ML Models with Live Microsoft Exchange Data using Dataiku
Connect Microsoft Exchange Data with Dataiku using the CData JDBC Driver for Microsoft Exchange.
-
Use Biml to Build SSIS Tasks to Replicate Tavily Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Tavily data to SQL Server.
-
Build Rebilly-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Rebilly data and build web apps with connectivity to live Rebilly data.
-
How to integrate Mocean with Apache Airflow
Access and process Mocean data in Apache Airflow using the CData JDBC Driver.
-
Use the CData ODBC Driver for Paylocity in Microsoft Power Query
You can use the CData Paylocity ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Paylocity data into Microsoft Power Query.
-
Getting Started with the CData Power BI Connector for Klipfolio
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Build Couchbase-Connected Applications in Kiro with CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Kiro to securely access, query, and take action on live Couchbase data without replication.
-
How to Work with BigQuery Data in AWS Glue Jobs Using JDBC
Connect to BigQuery from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Query SpaceX Data in DataGrip
Create a Data Source for SpaceX in DataGrip and use SQL to query live SpaceX data.
-
Visualize Chargebee 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 Chargebee data into TIBCO Spotfire.
-
How to Access Teamwork Data Using Entity Framework
This article shows how to access Teamwork data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Build Databricks Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Databricks data and build visualizations in Tableau Cloud.
-
Integrate Live Helpscout Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Helpscout data to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Build Apps with Live Facebook Ads Data Using the Low-Code Development Platform of Mendix
Connect Facebook Ads data with Mendix to build apps using the CData JDBC Driver for Facebook Ads.
-
Connecting GenSpark with Snowflake Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Snowflake data without any replication or custom integration required.
-
Add ADP Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for ADP with the Informatica Enterprise Data Catalog to classify and organize data.
-
Load Miro Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Miro data to a database.
-
Choosing the Best Method to Connect Outlook to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Outlook data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Integrate MessageBird with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate MessageBird with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to MessageBird data.
-
Build Excel Online-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Excel Online Data from Zoho Analytics and import live Excel Online data.
-
Migrating data from Samanage to Databricks using CData SSIS Components.
Easily push Samanage data to Databricks using the CData SSIS Tasks for Samanage and Databricks.
-
Build a Simple VCL Application for CloudConvert Data
How to build a simple VCL Application to view CloudConvert data in RAD Studio using the CData ODBC Driver for CloudConvert.
-
Visualize SAP Netweaver Gateway Data in Sisense
Create an ElastiCube in Sisense app with access to SAP Netweaver Gateway data.
-
Build Semantic Layer Views for Klipfolio Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Klipfolio data.
-
Integrate Live GraphQL Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to GraphQL data and integrate live GraphQL data into apps built in Microsoft Power Apps.
-
LINQ to Eventbrite Data
LINQ offers versatile querying capabilities within the .NET Framework (v3.0+), offering a straightforward method for programmatic data access through CData ADO.NET Data Providers. In this article, we demonstrate the use of LINQ to retrieve information from the Eventbrite Data Provider.
-
Replicate Multiple ADP Accounts
Replicate multiple ADP accounts to one or many databases.
-
Connect to NASA Data in HULFT Integrate
Connect to NASA as a JDBC data source in HULFT Integrate
-
Connect to Oracle Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Oracle and the Script function in FileMaker Pro to connect to Oracle and work with Oracle data in your FileMaker application.