CData Software - Knowledge Base
Recent Articles
-
Automate Greenplum Data Replication to SAP HANA
Use CData Sync to customize and automate Greenplum data replication to SAP HANA.
-
Build MVC Applications with Connectivity to Adobe Analytics Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Adobe Analytics from an ASP.NET MVC application.
-
Build Data Flows from Recurly to SQL Server using SSIS
Easily back up Recurly data to SQL Server using the SSIS components for Recurly.
-
Automate DocuSign Data Replication to Azure Synapse
Use CData Sync to customize and automate DocuSign data replication to Azure Synapse.
-
Connect to Short.io Data from PowerBuilder via JDBC
This article demonstrates how to access Short.io data from PowerBuilder using the Short.io JDBC Driver.
-
Integrate Live Couchbase Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf's Cascade agent to securely access and query live Couchbase data from within the IDE.
-
Connect to Trello Data in NetBeans
Connect to Trello data in NetBeans with the data source configuration wizard.
-
How to Connect to Live ADP 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 ADP data for you.
-
Visualize Live ZohoPeople Data in the Power BI Service
Use CData Connect AI to connect to live ZohoPeople data and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Connect Basecamp Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Basecamp data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Build Automated Workflows with Live Tally Data in Workato
Use CData Connect AI to connect to live Tally data and build automated workflows in Workato.
-
Analyze ZohoExpense Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze ZohoExpense data in Microsoft R Open.
-
Integrate Live Clari Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Clari data to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Use Manus AI to Talk to Your Omnisend 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 Omnisend data.
-
Integrate Live HubSpot Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live HubSpot data to Blue Prism using the CData ODBC Driver for HubSpot to create automated workflows for repetitive business tasks.
-
Integrating LangGraph with Amazon Marketplace Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Amazon Marketplace data within automated workflows.
-
Connect to Pingdom Data in NetBeans
Connect to Pingdom data in NetBeans with the data source configuration wizard.
-
Provide OData Services of Amazon Athena Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Amazon Athena data by developing a WCF Service Application.
-
Access Live Mailgun Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Mailgun data from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
How to Connect to Live Discord 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 Discord data for you.
-
Connect to Jodoo Data Using the Script Function in Claris FileMaker Pro
Use the CData API Driver for ODBC and the Script function in FileMaker Pro to connect to Jodoo and work with Jodoo data in your FileMaker application.
-
Getting Started with the CData Python Connector for HubDB
Learn to install and license the CData Python Connector and configure a connection to live HubDB data.
-
Model GetResponse Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and GetResponse, enabling the direct import of real-time GetResponse data.
-
Migrating data from OneNote to Databricks using CData SSIS Components.
Easily push OneNote data to Databricks using the CData SSIS Tasks for OneNote and Databricks.
-
Connect to Miro Data from PowerBuilder via ADO.NET
This article demonstrates how to access Miro data from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Analyze Facebook Ads Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Facebook Ads data and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Import Real-Time Perplexity Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Perplexity data in ColdFusion.
-
Prepare, Blend, and Analyze AlloyDB Data in Alteryx Designer (Connect AI)
Build workflows to access live AlloyDB data for self-service data analytics.
-
Back Up Calendly data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData API Driver for ADO.NET. In this article, we will employ an SSIS workflow to populate a database with Calendly data data.
-
Replicate iContact Data in Heroku for Use in Salesforce Connect
Replicate iContact data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Analyze Gmail Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Gmail data with the CData JDBC Driver for Gmail.
-
Integrating LangChain with Epicor Kinetic Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Epicor Kinetic data within automated workflows.
-
Connect to MySQL Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to MySQL.
-
Work with Live Power BI XMLA Data in Power Query
Use CData Connect AI to connect to Power BI XMLA data and work with live Power BI XMLA data in Microsoft Power Query.
-
Connect to Real-Time Printful Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Printful data in Power Apps.
-
Access Live Tavily Data in Excel 365 Online (Excel for the web)
Connect to Tavily data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Build Automated Hive-Connected Workflows in Zapier
Use CData Connect AI to connect to live Hive data and build automated workflows in Zapier.
-
Object-Relational Mapping (ORM) with Webex 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 Webex data into a Java-based ORM framework, Hibernate.
-
Integrate Open WebUI with Live Authorize.Net Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Authorize.Net data from within the chat interface.
-
Access Splunk Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Splunk data from HeidiSQL.
-
Interact with Live Sendwithus Data in Meta Muse via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Muse to securely interact with live Sendwithus data.
-
Explore Geographical Relationships in Close Data with Power Map
Create data visualizations with Close data in Power Map.
-
Query Live ZohoExpense 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 ZohoExpense data directly from the development environment.
-
Publish Crystal Reports on Google Sheets Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Google Sheets data.
-
Visualize OpenWeatherMap Data in Sisense
Create an ElastiCube in Sisense app with access to OpenWeatherMap data.
-
Connect to OData Services in HULFT Integrate
Connect to OData as a JDBC data source in HULFT Integrate
-
Query Live Discord 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 Discord data directly from the development environment.
-
Integrate Devin with Live Azure Data Lake Storage Data Using CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Devin, the AI software engineer, to securely access and query live Azure Data Lake Storage data.
-
Build Agents in Relevance AI with Access to Live Klaviyo Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Klaviyo data within intelligent agent workflows.
-
Replicate Gorgias Data to Multiple Databases
Replicate Gorgias data to disparate databases with a point-and-click configuration.
-
Enable the Workable JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Workable data.
-
How to Connect to & Open Suadeo Data in Microsoft Excel
This article uses the CData ODBC driver for Suadeo to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Rapidly Develop Drip-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 Drip.
-
Access Live MySQL Data in Excel 365 Online (Excel for the web)
Connect to MySQL data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Automated Continuous Paylocity Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Paylocity replication to Apache Cassandra.
-
How to Build an ETL App for Wrike Data in Python with CData
Create ETL applications and real-time data pipelines for Wrike data in Python with petl.
-
Build a Singer.io Tap for LightSpeedRetail With the CData Python Connector
Learn how to easily build a Singer.io Tap for live LightSpeedRetail data using the CData Python Connector.
-
Connect to Unbounce Data Using the Script Function in Claris FileMaker Pro
Use the CData API Driver for ODBC and the Script function in FileMaker Pro to connect to Unbounce and work with Unbounce data in your FileMaker application.
-
Use ChatGPT to Talk to Your Cosmos DB 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 Cosmos DB data for you.
-
Connect to Live SAP Netweaver Gateway Data in MicroStrategy through CData Connect AI
Create a live connection to SAP Netweaver Gateway Data in CData Connect AI and connect to your SAP Netweaver Gateway data from MicroStrategy.
-
Integrate Live Google Campaign Manager 360 Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Google Campaign Manager 360 from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Google Campaign Manager 360 data.
-
Visualize Live MessageBird Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live MessageBird data.
-
How to Connect to Live Cloudflare 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 Cloudflare data for you.
-
Visualize Live Strava Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Strava data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Create Dynamic Demio Grids Using the Infragistics XamDataGrid
Learn how you can connect Demio to Infragistics XamDataGrid to build dynamic grids.
-
Query Wrike Data in DataGrip
Create a Data Source for Wrike in DataGrip and use SQL to query live Wrike data.
-
Model, Search, and Visualize Live Sage Intacct Data in ThoughtSpot
Use CData Connect AI to connect to live Sage Intacct data for modeling, searching, and visualizing.
-
Integrate Dynamics 365 Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Dynamics 365 data from Informatica Cloud.
-
Connect to ConvertKit Data in HULFT Integrate
Connect to ConvertKit as a JDBC data source in HULFT Integrate
-
How to Connect to Live HDFS 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 HDFS data for you.
-
Access Live Rebilly Data in Coginiti Pro
Connect to and query live Rebilly data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
How to connect to Sugar CRM Data in DBVisualizer
Integrate Sugar CRM data with visual data analysis tools and data connection wizards in DBVisualizer
-
Operational Reporting on Smartsheet Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Smartsheet data.
-
Operational Reporting on FreshBooks Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote FreshBooks data.
-
Connect and Visualize Live Salesloft Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Salesloft data into the Databricks platform and create visualization dashboards with real-time Salesloft data.
-
How to Connect to Live Adobe Experience Manager 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 Adobe Experience Manager data for you.
-
Automated Continuous Shopify Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Shopify replication to Amazon S3.
-
Visualize Live GraphQL Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live GraphQL data.
-
A PostgreSQL Interface for Bright Data Data (MySQL Remoting via JDBC)
Use the Remoting features of the Bright Data JDBC Driver to create a PostgreSQL entry-point for data access.
-
Visualize Microsoft Ads Data in TIBCO Spotfire through OData
Integrate Microsoft Ads data into dashboards in TIBCO Spotfire.
-
Add Act CRM Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Act CRM with the Informatica Enterprise Data Catalog to classify and organize data.
-
Build AI/ML Models with Live ScrapingBee Data using Dataiku
Connect ScrapingBee Data with Dataiku using the CData API Driver for JDBC.
-
Connect to Sybase Data from a Connection Pool in Jetty
The Sybase JDBC Driver supports connection pooling: This article shows how to connect faster to Sybase data from Web apps in Jetty.
-
Analyze Live SAP Ariba Source Data in SAS Viya
Use CData Connect AI to connect to SAP Ariba Source data from SAS Viya and deploy self-service analytics using live SAP Ariba Source data.
-
Build Data Flows from eBay to SQL Server using SSIS
Easily back up eBay data to SQL Server using the SSIS components for eBay.
-
Integrating LangChain with Facebook Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Facebook data within automated workflows.
-
Connect to FreshBooks Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for FreshBooks data.
-
Build Campaigner Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Campaigner data and build visualizations in Tableau.
-
Use the CData Software ODBC Driver for Amazon S3 in MicroStrategy
Connect to Amazon S3 data in MicroStrategy Developer using the CData Software ODBC Driver for Amazon S3.
-
Integrate Live Reckon Accounts Hosted Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Reckon Accounts Hosted data and integrate live Reckon Accounts Hosted data into apps built in Microsoft Power Apps.
-
Integrate Live BigQuery Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live BigQuery data to Blue Prism using the CData ODBC Driver for BigQuery to create automated workflows for repetitive business tasks.
-
Build Agents in Relevance AI with Access to Live Gong Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Gong data within intelligent agent workflows.
-
Add Elasticsearch Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Elasticsearch with the Informatica Enterprise Data Catalog to classify and organize data.
-
Moving Data from Teamwork to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Teamwork data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Create Reports with Templated Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Templated data.
-
Integrating Google Calendar Data in Talend Cloud Data Management Platform
Connect Google Calendar Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Google Calendar.
-
Create Bugsnag Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Bugsnag from PowerBI.com to create Power BI Dataflows with real-time data.
-
Integrating Boomi Agentstudio with Timely Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Timely data, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Integrate with Snowflake Data in JReport Designer
Create charts and reports based on Snowflake data in JReport Designer.
-
Query Live AlloyDB 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 AlloyDB data through a conversational interface.