CData Software - Knowledge Base
Recent Articles
-
Automated Continuous Acumatica Replication to Oracle
Use CData Sync for automated, continuous, customizable Acumatica replication to Oracle.
-
Automated Continuous Marketo Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Marketo replication to Google Cloud SQL.
-
Use ChatGPT to Talk to Your Act CRM 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 Act CRM data for you.
-
Build Apps with Live IBM Informix data in Adalo using CData Connect AI
Use CData Connect AI to integrate live IBM Informix data into the Adalo platform and build custom mobile and web applications with real-time IBM Informix data.
-
Connect to Smartsheet Data in DBArtisan
Use wizards in DBArtisan to configure Smartsheet data as a data source.
-
Integrating Boomi Agentstudio with Certinia Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Certinia data, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Use Agno to Talk to Your AgileCRM 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 AgileCRM data for you.
-
Visualize Zoom Data in TIBCO Spotfire through ADO.NET
Integrate Zoom data into dashboards in TIBCO Spotfire.
-
How to Connect to Live DB2 Data in n8n Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable n8n to securely read and take actions on your DB2 data for you.
-
Visualize Exact Online Data in TIBCO Spotfire through OData
Integrate Exact Online data into dashboards in TIBCO Spotfire.
-
Use Dash to Build to Web Apps on Paymo Data
Create Python applications that use pandas and Dash to build Paymo-connected web apps.
-
Integrate with Freshservice Data in JReport Designer
Create charts and reports based on Freshservice data in JReport Designer.
-
Automate ConstantContact Integration Tasks from PowerShell
Are you in search of a quick and easy way to access ConstantContact data from PowerShell? This article demonstrates how to utilize the ConstantContact Cmdlets for tasks like connecting to ConstantContact data, automating operations, downloading data, and more.
-
Integrate Open WebUI with Live Dynamics NAV Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Dynamics NAV data from within the chat interface.
-
Integrate Trae with Live Cosmos DB Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Trae to securely access and query live Cosmos DB data from within the AI-powered IDE.
-
Build a Singer.io Tap for Amazon Marketplace With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Amazon Marketplace data using the CData Python Connector.
-
Explore Geographical Relationships in Blackbaud FE NXT Data with Power Map
Create data visualizations with Blackbaud FE NXT data in Power Map.
-
Consume Bullhorn CRM OData Feeds in PowerBuilder
This article demonstrates how to consume Bullhorn CRM data as OData feeds from PowerBuilder using the API Server.
-
Configure the CData JDBC Driver for Opsgenie in a Connection Pool in Tomcat
Connect to Opsgenie data from a connection pool in Tomcat.
-
Access Pipeline CRM 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 Pipeline CRM data.
-
Model Lakebase Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Lakebase, enabling the direct import of real-time Lakebase data.
-
How to Connect the Power BI Service to HDFS: Complete Guide
Connect to the CData Software Power BI Connector for HDFS from PowerBI.com to provide real-time HDFS data across the organization.
-
Use Agno to Talk to Your SAP SuccessFactors LMS 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 SAP SuccessFactors LMS data for you.
-
Migrating data from Humanity to Google BigQuery using CData SSIS Components.
Easily push Humanity data to Google BigQuery using the CData SSIS Tasks for Humanity and Google BigQuery.
-
Connect to Printful Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Printful data using standard SQL.
-
Back Up Zoho Projects data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Zoho Projects. In this article, we will employ an SSIS workflow to populate a database with Zoho Projects data data.
-
Build MVC Applications with Connectivity to Dynamics CRM Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Dynamics CRM from an ASP.NET MVC application.
-
How to Build an ETL App for PostgreSQL Data in Python with CData
Create ETL applications and real-time data pipelines for PostgreSQL data in Python with petl.
-
Connect to and Visualize Live Cvent Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Cvent data.
-
Visualize ZohoDesk Data in TIBCO Spotfire through ADO.NET
Integrate ZohoDesk data into dashboards in TIBCO Spotfire.
-
Connect to Spotify Data in RapidMiner
Integrate Spotify data with standard components and data source configuration wizards in RapidMiner Studio.
-
Analyze DB2 Data in Cognos Analytics
Use CData Connect AI to connect to DB2 Data from Cognos Analytics and analyze live DB2 data.
-
Model, Search, and Visualize Live ServiceDesk Plus Data in ThoughtSpot
Use CData Connect AI to connect to live ServiceDesk Plus data for modeling, searching, and visualizing.
-
Connect to Real-Time CouchDB Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for CouchDB and Dataflow to import and use CouchDB data in Power Apps.
-
Integrate Trae with Live Okta Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Trae to securely access and query live Okta data from within the AI-powered IDE.
-
Connect to Basecamp 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 Basecamp data.
-
Build AI Agents with FHIR 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 FHIR data through CData Connect AI.
-
Integrate Factorial Data in the Pentaho Report Designer
Publish reports based on Factorial data in the Pentaho BI tool.
-
Access Live ServiceDesk Plus Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate ServiceDesk Plus data into the statistical analysis tools available in SAS JMP. This article shows how to use ServiceDesk Plus data in the Graph Builder and Query Builder.
-
Connect to Bannerbear Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to Bannerbear.
-
Connect to ADP Data in Ruby
Connect to ADP data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
How to Connect to & Open Jumpseller Data in Microsoft Excel
This article uses the CData ODBC driver for Jumpseller to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Viewing HDFS Data in RAD Studio Data Explorer
How to view HDFS data in RAD Studio Data Explorer using the CData ODBC Driver for HDFS.
-
Connect to Confluence Data in DBArtisan
Use wizards in DBArtisan to configure Confluence data as a data source.
-
Access Live Grafana Data in AWS Lambda
Connect to live Grafana data in AWS Lambda using the CData JDBC Driver.
-
Query iContact Data as a MySQL Database in Node.js
Execute MySQL queries against iContact data from Node.js.
-
Prepare, Blend, and Analyze SendPulse Data in Alteryx Designer (ODBC)
Build workflows to access live SendPulse data for self-service data analytics.
-
Connect to Cvent Data in Aqua Data Studio
Access Cvent 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 Oracle Sales Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Oracle Sales data to SQL Server.
-
Access Pingdom Data from MySQL in Amazon QuickSight
Connect to Pingdom and build visualizations of Pingdom data using a MySQL Connection in Amazon QuickSight.
-
Automated Continuous OpenWeatherMap Replication to SQL Server
Use CData Sync for automated, continuous, customizable OpenWeatherMap replication to SQL Server.
-
Build Apps with Live Snapchat Ads Data Using the Low-Code Development Platform of Mendix
Connect Snapchat Ads data with Mendix to build apps using the CData JDBC Driver for Snapchat Ads.
-
Connect to Microsoft OneDrive Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Microsoft OneDrive Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
How to Work with LinkedIn Ads Data in ETL Validator JDBC
Connect to LinkedIn Ads from ETL Validator jobs using the CData Software JDBC Driver.
-
How to Seamlessly Import NetSuite Data into IBM SPSS Modeler
Integrate NetSuite data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Establish a Live Connection with Azure Analysis Services Data using Tableau Bridge
The CData ODBC Driver for Azure Analysis Services enables you to integrate live Azure Analysis Services data into Tableau Cloud dashboards using the Tableau Bridge.
-
Automated Continuous JSON Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable JSON replication to Google BigQuery.
-
Automate Tanda Data Replication to Azure Data Lake
Use CData Sync to customize and automate Tanda data replication to Azure Data Lake.
-
Connect to Bitbucket Data in CloverDX (formerly CloverETL)
Transfer Bitbucket data using the visual workflow in the CloverDX data integration tool.
-
Create Optimizely-Connected Applications in Appsmith
Connect to Optimizely Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Optimizely data.
-
Automate SAP SuccessFactors Data Replication to SAP HANA
Use CData Sync to customize and automate SAP SuccessFactors data replication to SAP HANA.
-
Use the CData Software ODBC Driver for Greenplum in MicroStrategy
Connect to Greenplum data in MicroStrategy Developer using the CData Software ODBC Driver for Greenplum.
-
Bridge MariaDB Connectivity with Apache NiFi
Access and process MariaDB data in Apache NiFi using the CData JDBC Driver.
-
Use the CData Software JDBC Driver for Freshservice in MicroStrategy Web
Connect to Freshservice data in MicroStrategy Web using the CData Software JDBC Driver for Freshservice.
-
Design BIRT Reports on Google Drive Data
Provide current Google Drive data to your embedded analytics.
-
Building Dynamic Web Pages with Sage Cloud Accounting Data Using AngularJS
Create single-page applications with live connectivity to Sage Cloud Accounting using the CData API Server.
-
Getting Started with the CData ADO.NET Provider for Sage 300
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Sage 300.
-
Use Claude to Talk to Your Google Forms 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 Google Forms data for you.
-
Write a Simple Go Application to work with Google Drive Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Google Drive data.
-
How to integrate Oracle HCM Cloud with Apache Airflow
Access and process Oracle HCM Cloud data in Apache Airflow using the CData JDBC Driver.
-
Integrate Live LinkedIn Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live LinkedIn data to Blue Prism using the CData ODBC Driver for LinkedIn to create automated workflows for repetitive business tasks.
-
Integrate Dify with Live Gong Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Dify agents and workflows to securely access and query live Gong data.
-
Build HCL Domino-Connected Apps in Choreo
Use CData Connect AI to connect to HCL Domino Data from Choreo and build custom apps using live HCL Domino data.
-
Connect to AdRoll Data in DBeaver
Use the CData ODBC Driver to connect to AdRoll data in DBeaver.
-
Analyze Greenplum Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Greenplum data and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Enable the PDFMonkey JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with PDFMonkey data.
-
How to Access Toggl Data Using Entity Framework
This article shows how to access Toggl data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Automated Continuous OneNote Replication to Databricks
Use CData Sync for automated, continuous, customizable OneNote replication to Databricks.
-
Creating GetResponse-Connected Applications in Unqork
You can use CData Connect AI to feed GetResponse data to Unqork and build custom business apps.
-
Access Live Marketo Data in Coginiti Pro
Connect to and query live Marketo data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Build MVC Applications with Connectivity to FTP Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access FTP from an ASP.NET MVC application.
-
Getting Started with the CData Excel Add-In for ConvertAPI
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for ConvertAPI.
-
How to Connect to Microsoft OneDrive Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Microsoft OneDrive data. Leverage the pyodbc module for ODBC in Python.
-
Natively Connect to Lakebase Data in PHP
The CData ODBC driver for Lakebase enables you to create PHP applications with connectivity to Lakebase data. Leverage the native support for ODBC in PHP.
-
Validate BambooHR Data with QuerySurge
Access and validate BambooHR data in QuerySurge using the CData JDBC Driver.
-
Rapidly Develop SingleStore-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 SingleStore.
-
Access WooCommerce Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live WooCommerce data from HeidiSQL.
-
How to connect to ScrapingBee Data in DBVisualizer
Integrate ScrapingBee data with visual data analysis tools and data connection wizards in DBVisualizer
-
Use Manus AI to Talk to Your Google Contacts 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 Google Contacts data.
-
Prepare, Blend, and Analyze Auth0 Data in Alteryx Designer (ODBC)
Build workflows to access live Auth0 data for self-service data analytics.
-
Build Semantic Layer Views for Teradata Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Teradata data.
-
Integrating Codex with OpenWeatherMap 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 Everhour Replication to MySQL
Use CData Sync for automated, continuous, customizable Everhour replication to MySQL.
-
How to Connect to Live Pinterest Data in n8n Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable n8n to securely read and take actions on your Pinterest data for you.
-
Connect to Adobe Experience Manager Data from HeidiSQL
Use CData Connect AI to connect to and query live Adobe Experience Manager data from HeidiSQL.
-
Getting Started with the CData Power BI Connector for Figshare
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Establish a Live Connection with Act-On Data using Tableau Bridge
The CData ODBC Driver for Act-On enables you to integrate live Act-On data into Tableau Cloud dashboards using the Tableau Bridge.
-
How to Build an ETL App for MongoDB Data in Python with CData
Create ETL applications and real-time data pipelines for MongoDB data in Python with petl.
-
Create ConstantContact-Connected Dashboards in Grafana
Connect to ConstantContact Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to ConstantContact data.
-
Access Live Avalara AvaTax Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Avalara AvaTax data from your Excel spreadsheets.