CData Software - Knowledge Base
Recent Articles
-
How to Access Live Sugar CRM Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Sugar CRM enables you to integrate Sugar CRM data into workflows built using Microsoft Power Automate Desktop.
-
View Reports on Real-Time Printful Data in Power BI Report Server
Use the CData ODBC Driver for Printful to visualize Printful data in Power BI Desktop and then publish them to Power BI Report Server.
-
Build Dashboards with Twitter Ads Data in DBxtra
Create dynamic dashboards and perform analytics based on Twitter Ads data in DBxtra.
-
Provide OData Services of Microsoft OneDrive Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Microsoft OneDrive data by developing a WCF Service Application.
-
Integrating Cursor with Bannerbear 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 Informatica Mappings From/To a JDBC Data Source for Codat
Create Codat data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
How to Connect Flowise AI Agents to Live Salesforce Pardot 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 Salesforce Pardot data without replication.
-
Replicate Cloudant Data from PowerShell
Write a quick PowerShell script to query Cloudant data. Use connectivity to the live data to replicate Cloudant data to SQL Server.
-
How to create an RPA flow for Mocean Data in UiPath Studio
Use the Mocean ODBC Driver to create workflows that access real-time Mocean data without any coding.
-
Use ChatGPT to Talk to Your HBase 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 HBase data for you.
-
Natively Connect to MySQL Data in PHP
The CData ODBC driver for MySQL enables you to create PHP applications with connectivity to MySQL data. Leverage the native support for ODBC in PHP.
-
ETL ClickUp in Oracle Data Integrator
This article shows how to transfer ClickUp data into a data warehouse using Oracle Data Integrator.
-
How to Use a Microsoft Access Database to Update Greenplum Data in Real Time
Update Greenplum data by creating a linked table in Microsoft Access with the CData Greenplum ODBC Driver.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Google Forms
Provide connectivity to Google Forms data through an SAP BusinessObjects universe.
-
How to create an RPA flow for Beeminder Data in UiPath Studio
Use the Beeminder ODBC Driver to create workflows that access real-time Beeminder data without any coding.
-
Publish Postmark-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Postmark data.
-
Integrate Google Calendar Data in the Pentaho Report Designer
Publish reports based on Google Calendar data in the Pentaho BI tool.
-
Manage Simplesat Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Simplesat.
-
Connecting Google Drive to an AI Document Agent with CData Connect AI
Step-by-step guide to building an AI document agent that connects to Google Drive using CData Connect AI and MCP. Configure permissions, convert documents to native Google Docs format, set up a Claude project system prompt, and validate live document retrieval.
-
Access Live Trello Data in Roo Code via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Roo Code agents to securely access and build applications with live Trello data through MCP integration.
-
Natively Connect to Microsoft Ads Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Microsoft Ads data. Leverage the native support for ODBC in PHP.
-
Integrating LlamaIndex with Microsoft Teams Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Microsoft Teams data in real time.
-
How to Access OData Services Using Entity Framework
This article shows how to access OData services using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Rapidly Develop Bitly-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 Bitly.
-
Publish WordPress-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live WordPress data.
-
Access Live SAP Fieldglass Data in Excel 365 Online (Excel for the web)
Connect to SAP Fieldglass data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Build Semantic Layer Views for Outreach.io Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Outreach.io data.
-
Replicate Multiple Bullhorn CRM Accounts
Replicate multiple Bullhorn CRM accounts to one or many databases.
-
Creating Suadeo-Connected Applications in Unqork
You can use CData Connect AI to feed Suadeo data to Unqork and build custom business apps.
-
Connect to Mailjet Data from Crystal Reports
Use CData Connect AI to connect to and report on live Mailjet data from Crystal Reports.
-
Replicate Helpscout Data to Multiple Databases
Replicate Helpscout data to disparate databases with a point-and-click configuration.
-
Back Up Google Contacts data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Google Contacts. In this article, we will employ an SSIS workflow to populate a database with Google Contacts data data.
-
Getting Started with the CData Power BI Connector for SingleStore
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for SingleStore.
-
Connecting Moonlit Workflow with Oracle Service Cloud 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 Oracle Service Cloud data in real time.
-
Integrate with SAP Netweaver Gateway Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy SAP Netweaver Gateway data to a JSON file on disk.
-
Build Visualizations of ShipStation Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of ShipStation data in Birst.
-
Rapidly Develop Yelp-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 Yelp.
-
Replicate Multiple Adobe Commerce Accounts
Replicate multiple Adobe Commerce accounts to one or many databases.
-
Publish Templated-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Templated data.
-
Build Data Flows from SAP Business One to SQL Server using SSIS
Easily back up SAP Business One data to SQL Server using the SSIS components for SAP Business One.
-
Connect to Toggl Data in HULFT Integrate
Connect to Toggl as a JDBC data source in HULFT Integrate
-
How to Connect Gong 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 Gong data in real time using natural language.
-
Visualize AfterShip Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to AfterShip data.
-
Publish SFTP-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live SFTP data.
-
Create GitHub Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time GitHub data access from reports, embedded analytics, and more.
-
Build Monday.com-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Monday.com data.
-
Object-Relational Mapping (ORM) with Avalara AvaTax 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 Avalara AvaTax data into a Java-based ORM framework, Hibernate.
-
Build Greenhouse-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Greenhouse Data and create custom apps in Bubble.
-
Connect to Sentry Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Sentry and the SQL Gateway to access Sentry data from Google Apps Script.
-
Connect to Coda Data from AWS Glue
Use CData Connect AI to gain access to live Coda data from your AWS Glue jobs.
-
Integrate Paymo with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Paymo with External Services.
-
Use Dash to Build to Web Apps on Asana Data
Create Python applications that use pandas and Dash to build Asana-connected web apps.
-
Build Dashboards with HDFS Data in Dundas BI
Create dynamic dashboards and perform analytics based on HDFS data in Dundas BI.
-
Integrate Marketo Data into Power Automate Desktop using CData Connect
CData Connect for Marketo Data enables you to integrate Marketo data into workflows built using Microsoft Power Automate Desktop.
-
How to use SQLAlchemy ORM to access Invoiced Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Invoiced data.
-
Access Live LinkedIn Data in Excel 365 Online (Excel for the web)
Connect to LinkedIn data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Write a Simple Go Application to work with Mailjet Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Mailjet data.
-
Visualize Live FreshBooks Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live FreshBooks data into custom reports in Power BI.
-
Use the CData Software ODBC Driver for CapsuleCRM in MicroStrategy Web
Connect to CapsuleCRM data in MicroStrategy Web using the CData Software ODBC Driver for CapsuleCRM.
-
How to Connect Twilio 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 Twilio data in real time using natural language.
-
Connect to Tickspot Data from PowerBuilder via JDBC
This article demonstrates how to access Tickspot data from PowerBuilder using the Tickspot JDBC Driver.
-
Analyze Live YouTube Analytics Data in SAS Viya
Use CData Connect AI to connect to YouTube Analytics data from SAS Viya and deploy self-service analytics using live YouTube Analytics data.
-
Publish Optimizely-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Optimizely data.
-
Automated Continuous Epicor Kinetic Replication to MySQL
Use CData Sync for automated, continuous, customizable Epicor Kinetic replication to MySQL.
-
Integrate Real-Time Access to Freshdesk in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Freshdesk data in real time.
-
Connect to Sugar CRM Data in DBeaver
Use the CData ODBC Driver to connect to Sugar CRM data in DBeaver.
-
How to use SQLAlchemy ORM to access Aweber Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Aweber data.
-
SQL Gateway SSH Tunneling Capabilities
Configure the SSH Tunnel on the SQL Gateway to create a reverse SSH tunnel to a publicly accessible SSH host.
-
How to Work with JobNimbus Data in AWS Glue Jobs Using JDBC
Connect to JobNimbus from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Integrate Short.io Data in the Pentaho Report Designer
Publish reports based on Short.io data in the Pentaho BI tool.
-
Automate PabblySubscriptions Data Replication to SAP HANA
Use CData Sync to customize and automate PabblySubscriptions data replication to SAP HANA.
-
Integrate Klipfolio Data in the Pentaho Report Designer
Publish reports based on Klipfolio data in the Pentaho BI tool.
-
Build Charts with Flowlu Data in Clear Analytics
Create dynamic charts and perform analytics based on Flowlu data in Clear Analytics.
-
Replicate Multiple Landbot Accounts via the CData Sync CLI
Replicate multiple Landbot accounts to one or many databases.
-
Query Live Active Directory 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 Active Directory data through a conversational interface.
-
Connect to Google Campaign Manager 360 Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Google Campaign Manager 360 Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Integrate Open WebUI with Live Timely Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Timely data from within the chat interface.
-
Create Power BI Reports on Real-Time Asana Data
Use the CData ODBC Driver for Asana to visualize Asana data in Power BI Desktop.
-
Integrate Live Google Ad Manager Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Google Ad Manager data and integrate live Google Ad Manager data into apps built in Microsoft Power Apps.
-
Viewing Amazon Marketplace Data in RAD Studio Data Explorer
How to view Amazon Marketplace data in RAD Studio Data Explorer using the CData ODBC Driver for Amazon Marketplace.
-
Getting Started with the CData Python Connector for Greenhouse
Learn to install and license the CData Python Connector and configure a connection to live Greenhouse data.
-
Connect to LeadDesk Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for LeadDesk data in the Denodo Virtual DataPort Administrator.
-
Replicate Multiple Templated Accounts
Replicate multiple Templated accounts to one or many databases.
-
Bridge Templated Connectivity with Apache NiFi
Access and process Templated data in Apache NiFi using the CData JDBC Driver.
-
Connect to Guru Data in RazorSQL
Connect to Guru from wizards and query Guru data from the GUI in the RazorSQL database management tool.
-
How to connect to Access Data with Squirrel SQL client
Connect to Access data and execute queries in the Squirrel SQL Client.
-
How to connect to AfterShip Data with Squirrel SQL client
Connect to AfterShip data and execute queries in the Squirrel SQL Client.
-
Use Microsoft Copilot Studio to talk to your Azure Analysis Services Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Microsoft Copilot Studio to securely answer questions and take actions on your Azure Analysis Services data for you.
-
Create eBay Analytics-Connected Business Apps in AppSheet
Connect to eBay Analytics Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to eBay Analytics data.
-
DataBind Klaviyo Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for Klaviyo with the DevExpress Windows Forms and Web controls to provide Klaviyo data to a chart.
-
Access BigCommerce Data from MySQL in PHP
Connect to BigCommerce through the standard MySQL libraries in PHP.
-
How to Connect to Live Mode Data from Claude Agent SDK (via CData Connect AI)
Leverage CData Connect AI to enable Claude Agent SDK applications to securely read and take actions on your Mode data for you.
-
Integrating LlamaIndex with xBase Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on xBase data in real time.
-
Integrate VWO with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate VWO with External Services.
-
Connect to Sage Cloud Accounting Data from AWS Glue
Use CData Connect AI to gain access to live Sage Cloud Accounting data from your AWS Glue jobs.
-
Connect to Hubstaff Data in HULFT Integrate
Connect to Hubstaff as a JDBC data source in HULFT Integrate
-
How to connect PolyBase to Vault CRM
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Vault CRM data.
-
Provide OData Services of SAP ByDesign Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for SAP ByDesign data by developing a WCF Service Application.
-
Automated Continuous SAP Ariba Procurement Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable SAP Ariba Procurement replication to PostgreSQL.
-
Integrate Live Slack Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Slack data and integrate live Slack data into apps built in Microsoft Power Apps.