CData Software - Knowledge Base
Recent Articles
-
Explore Geographical Relationships in RSS Feeds with Power Map
Create data visualizations with RSS Feeds in Power Map.
-
Build Semantic Layer Views for HBase Data in APOS Live Data Gateway
Use the CData Connector for HBase in APOS Live Data Gateway to build Semantic Layer Views for Apache HBase.
-
Use CData Connect AI to Access Google Directory Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Google Directory in the Power Pivot business intelligence tool.
-
Integrating LlamaIndex with Kintone Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Kintone in real time.
-
Replicate JotForm Data to Multiple Databases via the CData Sync CLI
Replicate JotForm to disparate databases with a single configuration.
-
Extend Google Sheets with Zoho Projects Data
Make calls to Zoho Projects from Google Apps Script via the API Server.
-
How to create Visio diagrams from HubDB Data
Automatically update HubDB with the changes you make to Visio master shapes.
-
How to publish and share Redshift Data dashboards with Tableau Server
The CData ODBC driver for Redshift enables you integrate Amazon Redshift into Tableau dashboards.
-
Integrate Live Slack Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Slack to Blue Prism using the CData ODBC Driver for Slack to create automated workflows for repetitive business tasks.
-
Replicate Multiple Stack Exchange Accounts via the CData Sync CLI
Replicate multiple Stack Exchange accounts to one or many databases.
-
DataBind Controls to Miro Data in C++Builder
DataBind to Miro in C++Builder with standard components and controls.
-
Perform Batch Operations with MySQL Data in Apache NiFi
Connect to MySQL and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Connect to Azure Table Data in Aqua Data Studio
Access Azure Table Storage from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Analyze Perplexity Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Perplexity with the CData JDBC Driver for Perplexity.
-
Getting Started with the CData ADO.NET Provider for Cvent
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Cvent.
-
Connect to Hacker News 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 Hacker News and work with Hacker News in your FileMaker application.
-
Connect to Office 365 Data in RazorSQL
Connect to Office 365 from wizards and query Microsoft Office 365 from the GUI in the RazorSQL database management tool.
-
Build AI/ML Models with Live Kintone Data using Dataiku
Connect Kintone Data with Dataiku using the CData JDBC Driver for Kintone.
-
How to connect PolyBase to Tavily
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Tavily.
-
Natively Connect to SAP Netweaver Gateway Data in PHP
The CData ODBC driver for SAP Netweaver Gateway enables you to create PHP applications with connectivity to SAP Netweaver Gateway. Leverage the native support for ODBC in PHP.
-
How to Connect to & Open Aircall Data in Microsoft Excel
This article uses the CData ODBC driver for Aircall to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Extract, Transform, and Load Zendesk Data in Informatica PowerCenter
Create a simple Workflow for Zendesk in Informatica PowerCenter.
-
Integrating Antigravity CLI with Apollo via CData CLI
Connect Apollo to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
How to load Reply.io data into Elasticsearch via Logstash
Introducing a simple method to load Reply.io data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
A PostgreSQL Interface for Notion Data (MySQL Remoting via JDBC)
Use the Remoting features of the Notion JDBC Driver to create a PostgreSQL entry-point for data access.
-
Create Dynamic Tanda Grids Using the Infragistics XamDataGrid
Learn how you can connect Tanda to Infragistics XamDataGrid to build dynamic grids.
-
How to connect to Active Directory Data in DBVisualizer
Integrate Active Directory with visual data analysis tools and data connection wizards in DBVisualizer
-
Create Power BI Reports on Real-Time Front Data
Use the CData ODBC Driver for Front to visualize Front in Power BI Desktop.
-
Integrate Live SendGrid Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to SendGrid from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live SendGrid.
-
Import Real-Time Oracle Financials Cloud Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Oracle Financials Cloud in ColdFusion.
-
Import and Visualize Facebook Data in Power View
Create data visualizations based on Facebook in Excel.
-
Consume Impala OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Impala feeds that reflect any changes in SAP Lumira.
-
Connect to Real-Time Elasticsearch Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Elasticsearch and Dataflow to import and use Elasticsearch in Power Apps.
-
Manage Zoho Projects Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Zoho Projects.
-
Load ZohoSubscriptions Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load ZohoSubscriptions to a database.
-
How to Connect to & Open Dotmailer Data in Microsoft Excel
This article uses the CData ODBC driver for Dotmailer to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Use the CData Software ODBC Driver for Gmail in SAS for Real-Time Reporting and Analytics
Connect to real-time Gmail in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Gmail.
-
How to Access Live Freshservice Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Freshservice enables you to integrate Freshservice into workflows built using Microsoft Power Automate Desktop.
-
How to integrate Beeminder with Apache Airflow
Access and process Beeminder in Apache Airflow using the CData JDBC Driver.
-
Using the CData Software ODBC Driver for Microsoft Teams in PyCharm
Connect to Microsoft Teams as an ODBC data source in PyCharm using the CData Software ODBC Driver for Microsoft Teams.
-
Perform Batch Operations with SAP Ariba Source Data in Apache NiFi
Connect to SAP Ariba Source and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Build Odoo Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Odoo ERP and build visualizations in Tableau.
-
Automated Continuous Sybase IQ Replication to SQLite
Use CData Sync for automated, continuous, customizable Sybase IQ replication to SQLite.
-
Build Data Flows from Elasticsearch to SQL Server using SSIS
Easily back up Elasticsearch to SQL Server using the SSIS components for Elasticsearch.
-
Work with Epicor Kinetic Data in FoxPro
Load Epicor Kinetic into a FoxPro database. This article includes full code and a walk-through of the process.
-
Bind Live Zendesk Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Zendesk data
-
Build Automated Adobe Commerce-Connected Workflows in Zapier
Use CData Connect AI to connect to live Adobe Commerce and build automated workflows in Zapier.
-
Connect to Coda Data in Jaspersoft Studio
Execute SQL to remote Coda in Jaspersoft Studio.
-
Integrating OpenCode Terminal with Nethunt 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.
-
Connecting Pipedream with Adobe Commerce 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 Adobe Commerce data in real time.
-
Create Reports with Salesloft Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Salesloft.
-
How to connect PolyBase to LinkedIn Ads
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live LinkedIn Ads.
-
Integrate with Live BigCommerce Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to BigCommerce from the MuleSoft Anypoint Platform to integrate live BigCommerce into custom reports and dashboards.
-
Build Automated Workflows with Live Amazon DynamoDB Data in Workato
Use CData Connect AI to connect to live Amazon DynamoDB and build automated workflows in Workato.
-
Moving Data from ServiceNow to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live ServiceNow data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Publish Crystal Reports on Placid Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Placid.
-
Automated Continuous Zoho Books Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Zoho Books replication to Apache Cassandra.
-
Working with NetSuite Data in LINQPad
Execute LINQ queries to NetSuite CRM & ERP in LINQPad.
-
Anaplan Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Anaplan facts in real time.
-
Access Live Paylocity Data in AWS Lambda
Connect to live Paylocity in AWS Lambda using the CData JDBC Driver.
-
Getting Started with the CData Python Connector for Pinterest
Learn to install and license the CData Python Connector
-
Use the CData Software ODBC Driver for SharePoint Excel Services in MicroStrategy
Connect to SharePoint Excel Services in MicroStrategy Developer using the CData Software ODBC Driver for SharePoint Excel Services.
-
Connect to Perplexity Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Perplexity and work with Perplexity in your FileMaker applications.
-
Back Up Zoho CRM to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Zoho CRM. In this article, we will employ an SSIS workflow to populate a database with Zoho CRM data.
-
Validate MailerLite Data with QuerySurge
Access and validate MailerLite in QuerySurge using the CData JDBC Driver.
-
Integrate Live Asana Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf
-
Create Informatica Mappings From/To an ODBC Data Source for CouchDB
Create an ODBC connection to CouchDB in Informatica and browse and transfer Apache CouchDB.
-
Getting Started with the CData Excel Add-In for ZohoExpense
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for ZohoExpense.
-
Connect to CapsuleCRM Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to CapsuleCRM and work with CapsuleCRM in your FileMaker applications.
-
Analyze Facebook Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Facebook and visualize live Facebook in Infragistics Reveal.
-
Enable the CloudConvert JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with CloudConvert.
-
Automated Continuous Aha! Replication to Oracle
Use CData Sync for automated, continuous, customizable Aha! replication to Oracle.
-
Replicate Multiple Oracle Sales Accounts via the CData Sync CLI
Replicate multiple Oracle Sales accounts to one or many databases.
-
Use the CData Software JDBC Driver for Yelp in MicroStrategy Desktop
Connect to Yelp in MicroStrategy Desktop using the CData Software JDBC Driver for Yelp.
-
DataBind Controls to Amazon DynamoDB Data in Delphi
DataBind to Amazon DynamoDB in Delphi with standard data access components and controls.
-
Integrate Tally Data in Pentaho Data Integration
Build ETL pipelines based on Tally ERP in the Pentaho Data Integration tool.
-
Connect to SendInBlue Data from a Connection Pool in JBoss
Integrate SendInBlue into Java servlets: Use the Management Console in JBoss to install the SendInBlue JDBC Driver.
-
Analyze eBay Data in Infragistics Reveal
Use the CData API Server to create an OData API on top of eBay and visualize live eBay in Infragistics Reveal.
-
Model, Search, and Visualize Live SAP Netweaver Gateway Data in ThoughtSpot
Use CData Connect AI to connect to live SAP Netweaver Gateway for modeling, searching, and visualizing.
-
Seamlessly Bring Cosmos DB Data into Retool Using CData Connect AI
Integrate Cosmos DB data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Access Tally Data from MySQL in PHP
Connect to Tally through the standard MySQL libraries in PHP.
-
Natively Connect to Azure Analysis Services Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Azure Analysis Services. Leverage the native support for ODBC in PHP.
-
Validate ChargeOver Data with QuerySurge
Access and validate ChargeOver in QuerySurge using the CData JDBC Driver.
-
Add GraphQL Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for GraphQL with the Informatica Enterprise Data Catalog to classify and organize data.
-
Build AI/ML Models with Live Salesforce Data using Dataiku
Connect Salesforce Data with Dataiku using the CData JDBC Driver for Salesforce.
-
Replicate CSV Data to Multiple Databases
Replicate CSV/TSV Files to disparate databases with a point-and-click configuration.
-
How to Connect to Live Google Cloud Storage 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 Google Cloud Storage for you.
-
LINQ to AgileCRM 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 AgileCRM Data Provider.
-
Build a PostgreSQL Interface for Perigon Data using the CData JDBC Driver
Use the Remoting features of the Perigon JDBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to Klaviyo Data in Aqua Data Studio
Access Klaviyo from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Connect to Amazon DynamoDB from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Amazon DynamoDB, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Query Cvent Data as a MySQL Database in Node.js
Execute MySQL queries against Cvent from Node.js.
-
Connect to Certinia in SpagoBI
Create reports featuring live Certinia in SpagoBI Studio. Host Certinia reports on SpagoBI Server.
-
Connect to CSV Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for CSV and the SQL Gateway to access CSV/TSV Files from Google Apps Script.
-
How to Access Acumatica Data Using Entity Framework
This article shows how to access Acumatica ERP using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Visualize Live Amazon DynamoDB Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Amazon DynamoDB.
-
Integrating Dataiku with Presto Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Presto.
-
Integrate with Blackbaud FE NXT Data in JReport Designer
Create charts and reports based on Blackbaud FE NXT in JReport Designer.
-
How to integrate Simplesat with Apache Airflow
Access and process Simplesat in Apache Airflow using the CData JDBC Driver.
-
Create Dynamic Highrise Grids Using the Infragistics XamDataGrid
Learn how you can connect Highrise to Infragistics XamDataGrid to build dynamic grids.