CData Software - Knowledge Base
Recent Articles
-
LINQ to Freshdesk 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 Freshdesk Data Provider.
-
Visualize Live PolarTeamPro Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live PolarTeamPro using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Integrate ClickTime with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate ClickTime with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to ClickTime.
-
Automated Continuous Microsoft Entra ID Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Microsoft Entra ID replication to AlloyDB.
-
Migrating data from FreshBooks to Databricks using CData SSIS Components.
Easily push FreshBooks to Databricks using the CData SSIS Tasks for FreshBooks and Databricks.
-
Visualize Mailgun 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 Mailgun into TIBCO Spotfire.
-
Build Apps with Live Dropbox Data Using the Low-Code Development Platform of Mendix
Connect Dropbox with Mendix to build apps using the CData JDBC Driver for Dropbox.
-
Publish Hive-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Apache Hive.
-
How to create Visio diagrams from Snapchat Ads Data
Automatically update Snapchat Ads with the changes you make to Visio master shapes.
-
Back Up Gorgias 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 Gorgias data.
-
Visualize Marketo Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Marketo.
-
Use the CData API Server to Access Smartsheet Data in Microsoft PowerPivot
Use the CData API Server to connect to live Smartsheet in the Power Pivot business intelligence tool.
-
Viewing Everhour Data in RAD Studio Data Explorer
How to view Everhour in RAD Studio Data Explorer using the CData ODBC Driver for Everhour.
-
A PostgreSQL Interface for SAP SuccessFactors Data using the CData ODBC Driver
Use the SQL Gateway and SAP SuccessFactors ODBC Driver to create a PostgreSQL entry-point for data access.
-
Integrate with Supabase Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Supabase to a JSON file on disk.
-
How to Work with Google Directory Data in ETL Validator JDBC
Connect to Google Directory from ETL Validator jobs using the CData Software JDBC Driver.
-
How to Connect to Live Avro Data in Mistral AI Workflows
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live Apache Avro without replication.
-
Integrate MYOB AccountRight Data in the Pentaho Report Designer
Publish reports based on MYOB AccountRight in the Pentaho BI tool.
-
How to work with Gmail Data in Apache Spark using SQL
Access and process Gmail Data in Apache Spark using the CData Software JDBC Driver.
-
Connect to Cloudflare in SpagoBI
Create reports featuring live Cloudflare in SpagoBI Studio. Host Cloudflare reports on SpagoBI Server.
-
Connect to Sage 200 Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Sage 200.
-
Integrating Antigravity CLI with TaxJar via CData CLI
Connect TaxJar to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Build MarkLogic-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for MarkLogic Data and create custom apps in Bubble.
-
Visualize MariaDB 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 MariaDB into TIBCO Spotfire.
-
Create MailChimp-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to MailChimp Data from Klipfolio and build custom visualizations using live MailChimp.
-
Extract, Transform, and Load ZohoPeople Data in Informatica PowerCenter
Create a simple Workflow for ZohoPeople in Informatica PowerCenter.
-
Working with Miro Data in LINQPad
Execute LINQ queries to Miro in LINQPad.
-
How to Work with Gmail Data in ETL Validator JDBC
Connect to Gmail from ETL Validator jobs using the CData Software JDBC Driver.
-
Publish Reports with Mode Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Mode.
-
Getting Started with the CData JDBC Driver for Authorize.Net
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Authorize.Net.
-
Integrating OpenCode Terminal with Google Spanner 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.
-
Bridge Amazon S3 Connectivity with Apache NiFi
Access and process Amazon S3 in Apache NiFi using the CData JDBC Driver.
-
Automated Continuous Email Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Email replication to IBM DB2.
-
How to create Visio diagrams from MailChimp Data
Automatically update MailChimp with the changes you make to Visio master shapes.
-
Connect to EmailOctopus from a Connection Pool in WebLogic
Use the CData JDBC Driver for EmailOctopus to connect to EmailOctopus from Web applications running on WebLogic.
-
Build MVC Applications with Connectivity to Insightly Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Insightly from an ASP.NET MVC application.
-
Use the CData ODBC Driver for Email from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Email to connect to Email from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Email in Excel.
-
Connect to Stripe Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Stripe from Filemaker Pro on Mac.
-
Create Cvent-Connected Nintex Workflows
Use CData Connect AI to connect to Cvent Data from Nintex Workflow Cloud and build custom workflows using live Cvent.
-
Analyze DocuSign Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze DocuSign in Microsoft R Open.
-
Migrating data from Onfleet to Google BigQuery using CData SSIS Components.
Easily push Onfleet to Google BigQuery using the CData SSIS Tasks for Onfleet and Google BigQuery.
-
Build GraphQL-Powered Applications in Gemini Code Assist with CData MCP Server
Use the CData MCP Server for GraphQL to explore live GraphQL Data in Gemini Code Assist to assist with building GraphQL-powered applications.
-
Automated Continuous Azure Blob Storage Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Azure Blob Storage replication to PostgreSQL.
-
Automate Reckon Accounts Hosted Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Reckon Accounts Hosted from PowerShell? This article demonstrates how to utilize the Reckon Accounts Hosted Cmdlets for tasks like connecting to Reckon Accounts Hosted, automating operations, downloading data, and more.
-
Connect to Eventbrite Data in CloverDX (formerly CloverETL)
Transfer Eventbrite using the visual workflow in the CloverDX data integration tool.
-
Connect to Drift Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Drift and the SQL Gateway to access Drift from Google Apps Script.
-
Build Pipelines with Live FHIR Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to FHIR from Google Cloud Data Fusion, enabling the integration of live FHIR into the building and management of effective data pipelines.
-
How to Connect to Live Cosmos DB 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 Azure Cosmos DB for you.
-
Extract, Transform, and Load WooCommerce Data in Informatica PowerCenter
Create a simple Workflow for WooCommerce in Informatica PowerCenter.
-
Use the CData Software ODBC Driver for RabbitMQ in MicroStrategy Web
Connect to RabbitMQ in MicroStrategy Web using the CData Software ODBC Driver for RabbitMQ.
-
Automated Continuous MySQL Replication to Amazon S3
Use CData Sync for automated, continuous, customizable MySQL replication to Amazon S3.
-
Bridge Wave Financial Connectivity with Apache NiFi
Access and process Wave Financial in Apache NiFi using the CData JDBC Driver.
-
Connect to SageHR Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for SageHR and the SQL Gateway to access SageHR from Google Apps Script.
-
Publish Demio-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Demio.
-
How to Connect to Live Odoo 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 Odoo ERP for you.
-
Import Real-Time Marketo Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Marketo in ColdFusion.
-
How to connect to Azure Data Catalog Data from IntelliJ
Integrate connectivity to Azure Data Catalog with wizards in IntelliJ.
-
Build AI Agents with Hive 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 Apache Hive through CData Connect AI.
-
Use Manus AI to Talk to Your Microsoft Entra ID 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 Microsoft Entra ID.
-
Automated Continuous JSON Replication to Amazon S3
Use CData Sync for automated, continuous, customizable JSON replication to Amazon S3.
-
Connect to Printful Data in RazorSQL
Connect to Printful from wizards and query Printful from the GUI in the RazorSQL database management tool.
-
How to integrate Metabase with Elasticsearch Data
Use CData Connect AI to connect to live Elasticsearch and create an interactive dashboard in Metabase from Elasticsearch.
-
Integrate Asana Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Asana from Informatica Cloud.
-
Access Microsoft Entra ID Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Microsoft Entra ID from your Oracle system.
-
Getting Started with the CData ADO.NET Provider for Placid
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Build eBay-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for eBay Data and create custom apps in Mendix.
-
Automate Phoenix Data Replication to Azure Data Lake
Use CData Sync to customize and automate Apache Phoenix replication to Azure Data Lake.
-
Connect to Act CRM Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Act CRM Data and connect to Act CRM in Akorbi Digital RunMyProcess.
-
Create SSAS Tabular Models from Reckon Data
How to build a SQL Server Analysis Service Tabular Model from Reckon using CData drivers.
-
Access Live ActiveCampaign Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live ActiveCampaign from your Excel spreadsheets.
-
How to connect to Raisers Edge NXT Data with Squirrel SQL client
Connect to Raisers Edge NXT and execute queries in the Squirrel SQL Client.
-
Connect to Azure Table Data in Google Apps Script via Connect AI
Use CData Connect AI to access Azure Table Storage in Google Apps Script.
-
Access Live Box Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Box from your Excel spreadsheets.
-
Automated Continuous Pingdom Replication to Vertica
Use CData Sync for automated, continuous, customizable Pingdom replication to Vertica.
-
Connect to Todoist Data in HULFT Integrate
Connect to Todoist as a JDBC data source in HULFT Integrate
-
Access Live MariaDB Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live MariaDB data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Build Oracle Financials Cloud-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Oracle Financials Cloud and build Oracle Financials Cloud-connected web apps with Axios.
-
How to Connect DBeaver to Square via a JDBC Driver
Manage Square with visual tools in DBeaver like the query browser.
-
Back Up Azure Synapse to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Azure Synapse. In this article, we will employ an SSIS workflow to populate a database with Azure Synapse data.
-
Automated Continuous ZohoMarketingHub Replication to MySQL
Use CData Sync for automated, continuous, customizable ZohoMarketingHub replication to MySQL.
-
Use CData Connect AI to Access Tally Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Tally ERP in the Power Pivot business intelligence tool.
-
Automated Continuous ServiceNow Replication to Snowflake
Use CData Sync for automated, continuous, customizable ServiceNow replication to Snowflake.
-
Build Dashboards with ConstantContact Data in DBxtra
Create dynamic dashboards and perform analytics based on ConstantContact in DBxtra.
-
Query SAP Hybris C4C Data as a MySQL Database in Node.js
Execute MySQL queries against SAP Hybris C4C from Node.js.
-
Build Apps with Live Instagram in Adalo using CData Connect AI
Use CData Connect AI to integrate live Instagram into the Adalo platform and build custom mobile and web applications with real-time Instagram.
-
Connect to Confluence Data in RapidMiner
Integrate Atlassian Confluence with standard components and data source configuration wizards in RapidMiner Studio.
-
Getting Started with the CData Power BI Connector for Snapchat Ads
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Snapchat Ads.
-
Edit and Search Facebook External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of Facebook to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create Facebook objects that you can access from apps and the dashboard.
-
Connecting GenSpark with Azure Table Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Azure Table Storage without any replication or custom integration required.
-
Use Databricks Agent Bricks to Talk to Your Amazon S3 Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Amazon S3 for you.
-
Visualize Live NetSuite Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live NetSuite CRM & ERP.
-
Replicate Square Data in Heroku for Use in Salesforce Connect
Replicate Square to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Connect to Neo4J Data in RazorSQL
Connect to Neo4J from wizards and query Neo4J from the GUI in the RazorSQL database management tool.
-
Connect to Tanda Data in Jaspersoft Studio
Execute SQL to remote Tanda in Jaspersoft Studio.
-
Connect and Visualize Live WordPress Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live WordPress into the Databricks platform and create visualization dashboards with real-time WordPress.
-
Create SendGrid-Connected Nintex Workflows
Use CData Connect AI to connect to SendGrid Data from Nintex Workflow Cloud and build custom workflows using live SendGrid.
-
Integrating OpenCode Terminal with Keap 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.
-
Integrating Claude Code CLI with Dynamics NAV 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 Sybase IQ Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Sybase IQ replication to Amazon S3.
-
Visualize PhantomBuster Data in Tableau
The CData ODBC driver for PhantomBuster enables you integrate PhantomBuster into Tableau dashboards.