CData Software - Knowledge Base
Recent Articles
-
Build Automated JSON-Connected Workflows in Zapier
Use CData Connect AI to connect to live JSON services and build automated workflows in Zapier.
-
Visualize Live TaxJar Data in the Power BI Service
Use CData Connect AI to connect to live TaxJar data and create custom reports in the Power BI Service through the On-Premises Gateway.
-
How to connect to Zoho Books Data with Squirrel SQL client
Connect to Zoho Books data and execute queries in the Squirrel SQL Client.
-
Getting Started with the CData ADO.NET Provider for Oracle Financials Cloud
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Oracle Financials Cloud.
-
Integrate Theia IDE with Live Apollo 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 Apollo data from within the development environment.
-
Migrating data from Bitly to Databricks using CData SSIS Components.
Easily push Bitly data to Databricks using the CData SSIS Tasks for Bitly and Databricks.
-
Publish Reports with Postmark Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Postmark data.
-
Write a Simple Go Application to work with Teamwork Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Teamwork data.
-
DataBind Controls to ZohoPeople Data in Delphi
DataBind to ZohoPeople data in Delphi with standard data access components and controls.
-
Getting Started with the CData JDBC Driver for Box
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Box.
-
Integrate Sage 300 Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Sage 300 data and integrate live Sage 300 data into your Power Automate tasks.
-
Migrating data from Billsby to Snowflake using CData SSIS Components.
Easily push Billsby data to Snowflake using the CData SSIS Tasks for Billsby and Snowflake.
-
How to integrate Metabase with NetSuite Data
Use CData Connect AI to connect to live NetSuite data and create an interactive dashboard in Metabase from NetSuite data.
-
Connect to Mailjet Data in HULFT Integrate
Connect to Mailjet as a JDBC data source in HULFT Integrate
-
Configure the CData JDBC Driver for Google Tasks in a Connection Pool in Tomcat
Connect to Google Tasks data from a connection pool in Tomcat.
-
Create ClickUp-Connected Dashboards in Grafana
Connect to ClickUp Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to ClickUp data.
-
Process & Analyze Impala Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Impala Data.
-
Getting Started with the CData Tableau Connector for Zoho Creator
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Zoho Creator.
-
Build Data Flows from SQL Server to Redshift through SSIS
Easily push SQL Server data to Redshift using the CData SSIS Tasks for Redshift.
-
Create Informatica Mappings From/To an ODBC Data Source for Elasticsearch
Create an ODBC connection to Elasticsearch in Informatica and browse and transfer Elasticsearch data.
-
Prepare, Blend, and Analyze SharePoint Data in Alteryx Designer (ODBC)
Build workflows to access live SharePoint data for self-service data analytics.
-
Integrate with Campaigner Data in JReport Designer
Create charts and reports based on Campaigner data in JReport Designer.
-
Integrate with Perplexity Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Perplexity data to a JSON file on disk.
-
How to integrate Metabase with Google Analytics Data
Use CData Connect AI to connect to live Google Analytics data and create an interactive dashboard in Metabase from Google Analytics data.
-
Connect to Jodoo Data from PowerBuilder via JDBC
This article demonstrates how to access Jodoo data from PowerBuilder using the Jodoo JDBC Driver.
-
How to create an RPA flow for Google Sheets Data in UiPath Studio
Use the Google Sheets ODBC Driver to create workflows that access real-time Google Sheets data without any coding.
-
Build Dashboards with Harvest Data in DBxtra
Create dynamic dashboards and perform analytics based on Harvest data in DBxtra.
-
Visualize Oracle Eloqua Data in Tableau
The CData ODBC driver for Oracle Eloqua enables you integrate Oracle Eloqua data into Tableau dashboards.
-
Create Reports from Oracle Eloqua Data in Looker Studio
Use CData Connect AI to gain access to live Oracle Eloqua data and create custom reports in Looker Studio.
-
Connect to and Visualize Live Front Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Front data.
-
Visualize Live HubSpot Data in the Power BI Service
Use CData Connect AI to connect to live HubSpot data and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Configure the CData JDBC Driver for Close in a Connection Pool in Tomcat
Connect to Close data from a connection pool in Tomcat.
-
Publish Crystal Reports on Campaigner Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Campaigner data.
-
Create Power BI Reports on Real-Time Beeminder Data
Use the CData ODBC Driver for Beeminder to visualize Beeminder data in Power BI Desktop.
-
Create Reports with Marketo Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Marketo data.
-
How to Create Power BI Visual Reports with Real-Time Salesforce CRM Analytics Data
Use CData Power BI Connectors to visualize Salesforce CRM Analytics data in Power BI.
-
Automated Continuous QuickBooks Online Replication to MongoDB
Use CData Sync for automated, continuous, customizable QuickBooks Online replication to MongoDB.
-
Connect to ConstantContact Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for ConstantContact Data and connect to ConstantContact data in Akorbi Digital RunMyProcess.
-
Integrating Codex with WooCommerce 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.
-
Using the CData Software ODBC Driver for PostgreSQL in PyCharm
Connect to PostgreSQL as an ODBC data source in PyCharm using the CData Software ODBC Driver for PostgreSQL.
-
Visualize Live SAP Fieldglass Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live SAP Fieldglass data into custom reports in Power BI.
-
How to Connect to Live Redis 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 Redis data for you.
-
Integrating LlamaIndex with Azure Table Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Azure Table data in real time.
-
Automated Continuous Mailjet Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Mailjet replication to Amazon Redshift.
-
Connect to Office 365 Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Office 365 and the Script function in FileMaker Pro to connect to Office 365 and work with Office 365 data in your FileMaker application.
-
Build a Simple VCL Application for ZohoInvoice Data
How to build a simple VCL Application to view ZohoInvoice data in RAD Studio using the CData ODBC Driver for ZohoInvoice.
-
Connect to Zoho Creator Data in JRuby
Create a simple JRuby app with access to live Zoho Creator data.
-
Integrate Theia IDE with Live Jumpseller 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 Jumpseller data from within the development environment.
-
Build a Singer.io Tap for PayPal With the CData Python Connector
Learn how to easily build a Singer.io Tap for live PayPal data using the CData Python Connector.
-
How to Connect to Live Snapchat Ads Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Snapchat Ads data securely in real time.
-
Connect Access Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Access data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Connect to Oracle Service Cloud from Asprova with CData Software ODBC Driver for Oracle Service Cloud
This article shows how to connect faster to Oracle Service Cloud data from Asprova.
-
Build Apps with Live LaunchDarkly Data Using the Low-Code Development Platform of Mendix
Connect LaunchDarkly data with Mendix to build apps using the CData API Driver for JDBC.
-
Integrate Google Sheets Data into Power Automate Desktop using CData Connect
CData Connect for Google Sheets Data enables you to integrate Google Sheets data into workflows built using Microsoft Power Automate Desktop.
-
Migrating data from Qualaroo to Google BigQuery using CData SSIS Components.
Easily push Qualaroo data to Google BigQuery using the CData SSIS Tasks for Qualaroo and Google BigQuery.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for QuickBooks Time
Provide connectivity to QuickBooks Time data through an SAP BusinessObjects universe.
-
Migrating data from SAP Ariba Procurement to Databricks using CData SSIS Components.
Easily push SAP Ariba Procurement data to Databricks using the CData SSIS Tasks for SAP Ariba Procurement and Databricks.
-
Trigger Vault CRM IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for Vault CRM with standard wizards in Logic Apps.
-
How to create Email federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Email data in MySQL .
-
Build a Simple VCL Application for Splunk Data
How to build a simple VCL Application to view Splunk data in RAD Studio using the CData ODBC Driver for Splunk.
-
Integrating Cursor with JSON Services 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.
-
LINQ to Salesforce 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 Salesforce Data Provider.
-
DataBind ShipEngine Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide ShipEngine data to a chart.
-
Integrate TigerGraph Data in Pentaho Data Integration
Build ETL pipelines based on TigerGraph data in the Pentaho Data Integration tool.
-
Use the CData Software JDBC Driver for Everhour in MicroStrategy Desktop
Connect to Everhour data in MicroStrategy Desktop using the CData Software JDBC Driver for Everhour.
-
Automated Continuous Xero Replication to MySQL
Use CData Sync for automated, continuous, customizable Xero replication to MySQL.
-
Extract, Transform, and Load Bugsnag Data in Informatica PowerCenter
Create a simple Workflow for Bugsnag data in Informatica PowerCenter.
-
Replicate ZohoPeople Data from PowerShell
Write a quick PowerShell script to query ZohoPeople data. Use connectivity to the live data to replicate ZohoPeople data to SQL Server.
-
Integrate OpenCode with Live EnterpriseDB Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable OpenCode to securely access and query live EnterpriseDB data from within your AI coding agent.
-
Getting Started with the CData ODBC Driver for Deel
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Deel.
-
Use Databricks Agent Bricks to Talk to Your Typeform Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Typeform data for you.
-
Connect to Instantly Data from a Connection Pool in Jetty
The Instantly JDBC Driver supports connection pooling: This article shows how to connect faster to Instantly data from Web apps in Jetty.
-
How to Connect to Live HBase 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 HBase data for you.
-
Feed iContact Data into FineReport
How to set iContact data as a JDBC data source in FineReport.
-
Connecting Pipedream with Google Directory Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Pipedream workflows to securely read and take actions on Google Directory data in real time.
-
How to work with Clockify Data in Apache Spark using SQL
Access and process Clockify Data in Apache Spark using the CData Software JDBC Driver.
-
Load Cloudant Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Cloudant data to a database.
-
Build a Singer.io Tap for Tickspot With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Tickspot data using the CData Python Connector.
-
Connect MessageBird Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your MessageBird data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Integrate Cline with Live Office 365 Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Office 365 data from within your IDE.
-
Getting Started with the CData Tableau Connector for LinkedIn
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for LinkedIn.
-
Integrate Trae with Live MailChimp Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Trae to securely access and query live MailChimp data from within the AI-powered IDE.
-
Connect to Azure Synapse 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 Azure Synapse data.
-
LINQ to Demio 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 Demio Data Provider.
-
Use Agno to Talk to Your Avro 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 Avro data for you.
-
How to Connect to Live Okta Data from OpenAI Python Applications (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable OpenAI-powered Python applications to securely read and take actions on your Okta data through natural language.
-
Create Reports with Confluence Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Confluence data.
-
Use Biml to Build SSIS Tasks to Replicate SpaceX Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate SpaceX data to SQL Server.
-
How to Access Live SAP HANA Data in Power Automate Desktop via ODBC
The CData ODBC Driver for SAP HANA enables you to integrate SAP HANA data into workflows built using Microsoft Power Automate Desktop.
-
LINQ to OneNote 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 OneNote Data Provider.
-
Use Manus AI to Talk to Your Elasticsearch 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 Elasticsearch data.
-
How to Connect the Power BI Service to Webflow: Complete Guide
Connect to the CData Software Power BI Connector for Webflow from PowerBI.com to provide real-time Webflow data across the organization.
-
How to work with Shortcut Data in Apache Spark using SQL
Access and process Shortcut Data in Apache Spark using the CData Software JDBC Driver.
-
Connecting Pipedream with Cloudflare Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Pipedream workflows to securely read and take actions on Cloudflare data in real time.
-
Create Informatica Mappings From/To an ODBC Data Source for Samanage
Create an ODBC connection to Samanage in Informatica and browse and transfer Samanage data.
-
Import and Visualize Avalara AvaTax Data in Power View
Create data visualizations based on Avalara AvaTax data in Excel.
-
How to Work with Xero Data in ETL Validator JDBC
Connect to Xero from ETL Validator jobs using the CData Software JDBC Driver.
-
Build Apps with Live Mistral AI Data Using the Low-Code Development Platform of Mendix
Connect Mistral AI data with Mendix to build apps using the CData API Driver for JDBC.
-
Automate Opsgenie Data Replication to Azure Synapse
Use CData Sync to customize and automate Opsgenie data replication to Azure Synapse.
-
Access Live CouchDB Data in Excel 365 Online (Excel for the web)
Connect to CouchDB data from Excel 365 Online (Excel for the web) with CData Connect AI.