CData Software - Knowledge Base
Recent Articles
-
SFTP Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to SFTP data through CData Connect AI using different applications and tools.
-
How to import Mixpanel Data into Apache Solr
Use the CData Software JDBC Driver for Mixpanel in Data Import Handler and create an automated import of Mixpanel data to Apache Solr Enterprise Search platform.
-
Create Vertica-Connected Applications in Appsmith
Connect to Vertica Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Vertica data.
-
Visualize Live Microsoft Ads Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Microsoft Ads data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Use Claude to Talk to Your Salesforce 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 Salesforce data for you.
-
Add Tally Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Tally with the Informatica Enterprise Data Catalog to classify and organize data.
-
How to Create Power BI Visual Reports with Real-Time Webflow Data
Use CData Power BI Connectors to visualize Webflow data in Power BI.
-
How to Work with RSS Feeds in ETL Validator JDBC
Connect to RSS from ETL Validator jobs using the CData Software JDBC Driver.
-
Work with Live Zendesk Data in Power Query
Use CData Connect AI to connect to Zendesk data and work with live Zendesk data in Microsoft Power Query.
-
Connect to Freshservice Data from a Connection Pool in JBoss
Integrate Freshservice data into Java servlets: Use the Management Console in JBoss to install the Freshservice JDBC Driver.
-
How to Connect to Live Snowflake Data from crewAI Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable crewAI agents to securely read and take actions on your Snowflake data for you.
-
Analyze Amazon DynamoDB Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Amazon DynamoDB data and visualize live Amazon DynamoDB data in Infragistics Reveal.
-
Connect to Live Smartsheet Data in MicroStrategy through CData Connect AI
Create a live connection to Smartsheet Data in CData Connect AI and connect to your Smartsheet data from MicroStrategy.
-
Bridge Freshteam Connectivity with Apache NiFi
Access and process Freshteam data in Apache NiFi using the CData JDBC Driver.
-
Connect to Google Ads Data in DBeaver
Use the CData ODBC Driver to connect to Google Ads data in DBeaver.
-
How to publish and share Microsoft Teams Data dashboards with Tableau Server
The CData ODBC driver for Microsoft Teams enables you integrate Microsoft Teams data into Tableau dashboards.
-
Getting Started with the CData Power BI Connector for Reckon
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Reckon.
-
Unbounce Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Unbounce facts in real time.
-
Create Data Visualizations Based On SAP Concur Data in Mode
Use CData Connect AI to connect to SAP Concur Data from Mode and build visualizations using live SAP Concur data.
-
Integrating GitHub Copilot with Everhour 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.
-
Access Live Yelp Data in Coginiti Pro
Connect to and query live Yelp data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Configure the CData JDBC Driver for Freshteam in a Connection Pool in Tomcat
Connect to Freshteam data from a connection pool in Tomcat.
-
Build AI Agents with LDAP 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 LDAP objects through CData Connect AI.
-
How to connect Amazon QuickSight to Google Drive Data
Create a connection to Google Drive data in CData Connect AI and insert Google Drive data into Amazon QuickSight SPICE to build interactive dashboards.
-
Automated Continuous FormSite Replication to SQL Server
Use CData Sync for automated, continuous, customizable FormSite replication to SQL Server.
-
Create Mode-Connected Dashboards in Grafana
Connect to Mode Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Mode data.
-
Create Instantly Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Instantly data access from reports, embedded analytics, and more.
-
Feed Auth0 Data into FineReport
How to set Auth0 data as a JDBC data source in FineReport.
-
Connect to Salesforce Data in Ruby
Connect to Salesforce data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Automate Drip Data Replication to Azure Data Lake
Use CData Sync to customize and automate Drip data replication to Azure Data Lake.
-
Create Tally Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Tally data access from reports, embedded analytics, and more.
-
Connect to Gong Data in CloverDX (formerly CloverETL)
Transfer Gong data using the visual workflow in the CloverDX data integration tool.
-
Connect and Visualize Live Azure Synapse Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Azure Synapse data into the Databricks platform and create visualization dashboards with real-time Azure Synapse data.
-
Connect to Bannerbear Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Bannerbear Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Link Hugging Face with FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Hugging Face data in Filemaker Pro for Mac or Windows.
-
How to Work with NetSuite Data in AWS Glue Jobs Using JDBC
Connect to NetSuite from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Connect to Kintone Data in ACL Analytics
Connect to Kintone data via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Kintone data.
-
Connect to Freshsales Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Freshsales data using standard SQL.
-
How to Work with QuickBooks Online Data in ETL Validator JDBC
Connect to QuickBooks Online from ETL Validator jobs using the CData Software JDBC Driver.
-
How to create SingleStore federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for SingleStore data in MySQL .
-
Integrating LangGraph with Pinterest Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Pinterest data within automated workflows.
-
Query Outlook Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Outlook data from Node.js.
-
Automated Continuous Wrike Replication to Snowflake
Use CData Sync for automated, continuous, customizable Wrike replication to Snowflake.
-
Access Live NetSuite Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate NetSuite data into the statistical analysis tools available in SAS JMP. This article shows how to use NetSuite data in the Graph Builder and Query Builder.
-
Connect to Impala Data from HeidiSQL
Use CData Connect AI to connect to and query live Impala data from HeidiSQL.
-
Edit and Search External ADP Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of ADP data to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create ADP Data objects that you can access from apps and the dashboard.
-
Connect to Sugar CRM Data from PowerBuilder via ADO.NET
This article demonstrates how to access Sugar CRM data from Appeon PowerBuilder using the CData ADO.NET Provider for Sugar CRM.
-
Integrate Devin with Live Google Directory 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 Google Directory data.
-
Getting Started with the CData JDBC Driver for ZohoMarketingHub
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for ZohoMarketingHub.
-
Build Semantic Layer Views for Act CRM Data in APOS Live Data Gateway
Use the CData Connector for Act CRM in APOS Live Data Gateway to build Semantic Layer Views for Act CRM data.
-
Query Sage 300 Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Sage 300 entities in PHP by modeling them as objects.
-
How to connect SharePoint with Pipedrive Data through external lists
Provide Pipedrive data to SharePoint users as an external list.
-
Automated Continuous Tickspot Replication to MySQL
Use CData Sync for automated, continuous, customizable Tickspot replication to MySQL.
-
Connecting Mastra with Couchbase Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to enable Mastra agents to securely query, read, and act on real-time Couchbase data, no replication required.
-
Getting Started with the CData JDBC Driver for JSON
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for JSON.
-
Access Sage Intacct 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 Sage Intacct data.
-
A PostgreSQL Interface for Cohere Data (MySQL Remoting via JDBC)
Use the Remoting features of the Cohere JDBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to Workday Data in RazorSQL
Connect to Workday from wizards and query Workday data from the GUI in the RazorSQL database management tool.
-
Access Live Airtable Data in Excel 365 Online (Excel for the web)
Connect to Airtable data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Query NASA Data through ODBC in Node.js
Use node-odbc to execute SQL queries against NASA data from Node.js.
-
Prepare, Blend, and Analyze Lakebase Data in Alteryx Designer (ODBC)
Build workflows to access live Lakebase data for self-service data analytics.
-
Use the CData ODBC Driver for Perplexity from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Perplexity to connect to Perplexity data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Perplexity data in Excel.
-
Automated Continuous Dynamics 365 Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Dynamics 365 replication to Amazon S3.
-
Integrate Google's Antigravity Agent with Live Sage 300 Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Sage 300 data using the Model Context Protocol.
-
Rapidly Develop Paddle-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 Paddle.
-
Integrate Basecamp Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Basecamp data and integrate live Basecamp data into your Power Automate tasks.
-
How to publish and share BenchmarkEmail Data dashboards with Tableau Server
The CData ODBC driver for BenchmarkEmail enables you integrate BenchmarkEmail data into Tableau dashboards.
-
Connect to Gmail Data in RapidMiner
Integrate Gmail data with standard components and data source configuration wizards in RapidMiner Studio.
-
How to connect PolyBase to Clari
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Clari data.
-
Access Live Ontraport Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Ontraport data into the statistical analysis tools available in SAS JMP. This article shows how to use Ontraport data in the Graph Builder and Query Builder.
-
Automate Tally Data Replication to Couchbase
Use CData Sync to Customize and automate Tally data replication to Couchbase.
-
Operational Reporting on Opsgenie Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Opsgenie data.
-
Automated Continuous BenchmarkEmail Replication to IBM DB2
Use CData Sync for automated, continuous, customizable BenchmarkEmail replication to IBM DB2.
-
Connect ScrapingBee to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect ScrapingBee with IBM WebSphere for seamless data integration and connectivity.
-
Consume Databricks OData Feeds in PowerBuilder
This article demonstrates how to consume Databricks data as OData feeds from PowerBuilder using the API Server.
-
How to Connect to & Open JobNimbus Data in Microsoft Excel
This article uses the CData ODBC driver for JobNimbus to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Automated Continuous Azure Synapse Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Azure Synapse replication to delimited files (CSV/TSV).
-
Using the CData Software ODBC Driver for Jodoo in PyCharm
Connect to Jodoo as an ODBC data source in PyCharm using the CData Software ODBC Driver for Jodoo.
-
Connect to Zoho Recruit Data in JRuby
Create a simple JRuby app with access to live Zoho Recruit data.
-
Query Pinterest Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Pinterest data from Node.js.
-
Automate FormSite Integration Tasks from PowerShell
Are you in search of a quick and easy way to access FormSite data from PowerShell? This article demonstrates how to utilize the FormSite Cmdlets for tasks like connecting to FormSite data, automating operations, downloading data, and more.
-
Link ZohoMarketingHub with FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate ZohoMarketingHub data in Filemaker Pro for Mac or Windows.
-
Configure the CData JDBC Driver for Greenplum in a Connection Pool in Tomcat
Connect to Greenplum data from a connection pool in Tomcat.
-
Automate Dynamics NAV Data Replication to Couchbase
Use CData Sync to Customize and automate Dynamics NAV data replication to Couchbase.
-
Create WooCommerce-Connected Nintex Workflows
Use CData Connect AI to connect to WooCommerce Data from Nintex Workflow Cloud and build custom workflows using live WooCommerce data.
-
Build Bitly-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Bitly Data and create custom apps in Bubble.
-
How to Access JobNimbus Data Using Entity Framework
This article shows how to access JobNimbus data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Natively Connect to Smartsheet Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Smartsheet data. Leverage the native support for ODBC in PHP.
-
Connect to QuickBooks Online from Asprova with CData Software ODBC Driver for QuickBooks Online
This article shows how to connect faster to QuickBooks Online data from Asprova.
-
Connect to SAP Business One Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for SAP Business One data in Airbyte.
-
Create OneNote-Connected Business Apps in AppSheet
Connect to OneNote Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to OneNote data.
-
How to Connect to Live Procore 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 Procore data for you.
-
Use Dash to Build to Web Apps on Redshift Data
Create Python applications that use pandas and Dash to build Redshift-connected web apps.
-
Connect to Live SAP Netweaver Gateway Data in PostGresSQL Interface through CData Connect AI
Create a live connection to SAP Netweaver Gateway in CData Connect AI and connect to your SAP Netweaver Gateway data from PostgreSQL.
-
Visualize DB2 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 DB2 data into TIBCO Spotfire.
-
Create Power BI Reports on Real-Time ScrapingBee Data
Use the CData ODBC Driver for ScrapingBee to visualize ScrapingBee data in Power BI Desktop.
-
Connect to BigQuery Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for BigQuery Data and connect to BigQuery data in Akorbi Digital RunMyProcess.
-
How to Connect SAP ByDesign 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 SAP ByDesign data in real time using natural language.
-
Use Agno to Talk to Your Supabase 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 Supabase data for you.
-
Extract, Transform, and Load Clari Data in Informatica PowerCenter
Create a simple Workflow for Clari data in Informatica PowerCenter.