CData Software - Knowledge Base
Recent Articles
-
How to connect SharePoint with Parquet Data through external lists
Provide Apache Parquet to SharePoint users as an external list.
-
How to Create Power BI Visual Reports with Real-Time CockroachDB Data
Use CData Power BI Connectors to visualize CockroachDB in Power BI.
-
Query Mailjet Data in DataGrip
Create a Data Source for Mailjet in DataGrip and use SQL to query live Mailjet.
-
Automated Continuous PabblySubscriptions Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable PabblySubscriptions replication to PostgreSQL.
-
How to Access Live Excel Online Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Excel Online enables you to integrate Microsoft Excel Online into workflows built using Microsoft Power Automate Desktop.
-
Automate Retently Data Replication to SAP HANA
Use CData Sync to customize and automate Retently replication to SAP HANA.
-
Use CData Connect AI to Access Elasticsearch Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Elasticsearch in the Power Pivot business intelligence tool.
-
Moving Data from Shopify to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Shopify data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Edit and Search External DB2 Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of IBM DB2 to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create DB2 Data objects that you can access from apps and the dashboard.
-
Use the CData Software ODBC Driver for ClickUp in MicroStrategy
Connect to ClickUp in MicroStrategy Developer using the CData Software ODBC Driver for ClickUp.
-
Automated Continuous ZohoPeople Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable ZohoPeople replication to OneLake in Microsoft Fabric.
-
Replicate Typeform Data to Multiple Databases
Replicate Typeform to disparate databases with a point-and-click configuration.
-
Create SAP Concur-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to SAP Concur Data from OutSystems and build custom enterprise apps using live SAP Concur.
-
Integrate Open WebUI with Live Instagram Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Instagram from within the chat interface.
-
Excel Spreadsheet Automation on PagerDuty Data with the QUERY Formula
Pull data from PagerDuty, automate spreadsheets, and more with the QUERY formula.
-
Connect to Campaigner Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Campaigner.
-
How to connect to Redis Data from Spring Boot
Connect to Redis in a Spring Boot Application using the CData JDBC Driver for Redis
-
Publish Reports with Salesforce Pardot Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Salesforce Pardot.
-
How to Work with BenchmarkEmail Data in ETL Validator JDBC
Connect to BenchmarkEmail from ETL Validator jobs using the CData Software JDBC Driver.
-
Bridge Box Connectivity with Apache NiFi
Access and process Box in Apache NiFi using the CData JDBC Driver.
-
Integrate Cursor with Live SAP SuccessFactors LMS Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live SAP SuccessFactors LMS from within the editor.
-
Connect to LDAP Objects in DBArtisan
Use wizards in DBArtisan to configure LDAP as a data source.
-
Use Grok to Talk to Your WordPress Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Grok AI to securely answer questions and take actions on your WordPress for you.
-
Build AI/ML Models with Live SAP Netweaver Gateway Data using Dataiku
Connect SAP Netweaver Gateway Data with Dataiku using the CData JDBC Driver for SAP Netweaver Gateway.
-
How to connect PolyBase to PhantomBuster
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live PhantomBuster.
-
Connect to QuickBooks Online Data from HeidiSQL
Use CData Connect AI to connect to and query live QuickBooks Online from HeidiSQL.
-
How to Visualize Phoenix Data in Python with pandas via CData Connect AI
Use the CData Connect AI Python SDK with pandas and Matplotlib to analyze and visualize live Apache Phoenix in Python.
-
Import and Visualize HubSpot Data in Power View
Create data visualizations based on HubSpot in Excel.
-
Analyze HDFS Data in Infragistics Reveal
Use the CData API Server to create an OData API on top of Apache HDFS and visualize live Apache HDFS in Infragistics Reveal.
-
How to Use a Microsoft Access Database to Update Act-On Data in Real Time
Update Act-On data by creating a linked table in Microsoft Access with the CData Act-On ODBC Driver.
-
How to connect Amazon QuickSight to Epicor Kinetic Data
Create a connection to Epicor Kinetic in CData Connect AI and insert Epicor Kinetic into Amazon QuickSight SPICE to build interactive dashboards.
-
How to connect PolyBase to Shippo
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Shippo.
-
Connect to MariaDB Data in RazorSQL
Connect to MariaDB from wizards and query MariaDB from the GUI in the RazorSQL database management tool.
-
Connect to Live ADP Data in PostGresSQL Interface through CData Connect AI
Create a live connection to ADP in CData Connect AI and connect to your ADP from PostgreSQL.
-
Working with Neo4J Data in LINQPad
Execute LINQ queries to Neo4J in LINQPad.
-
How to create PivotalTracker federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for PivotalTracker in MySQL .
-
Migrating data from Clockify to Google BigQuery using CData SSIS Components.
Easily push Clockify to Google BigQuery using the CData SSIS Tasks for Clockify and Google BigQuery.
-
Integrating Claude Code CLI with Pinecone 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.
-
How to connect to SAP ByDesign Data with Squirrel SQL client
Connect to SAP Business ByDesign and execute queries in the Squirrel SQL Client.
-
Connect to Dynamics CRM Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Microsoft Dynamics CRM using standard SQL.
-
Connect to Stack Exchange Data in DBeaver
Use the CData ODBC Driver to connect to Stack Exchange in DBeaver.
-
Automated Continuous Authorize.Net Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Authorize.Net replication to Apache Kafka.
-
Build Bullhorn CRM-Powered Applications in Cursor with CData MCP Server
Use the CData MCP Server for Bullhorn CRM to explore live Bullhorn CRM Data in Cursor to assist with building Bullhorn CRM-powered applications.
-
Integrating GitHub Copilot CLI with Aha! 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.
-
Build Amazon S3-Powered Applications in Cursor with CData MCP Server
Use the CData MCP Server for Amazon S3 to explore live Amazon S3 Data in Cursor to assist with building Amazon S3-powered applications.
-
Natively Connect to SAP Ariba Source Data in PHP
The CData ODBC driver for SAP Ariba Source enables you to create PHP applications with connectivity to SAP Ariba Source. Leverage the native support for ODBC in PHP.
-
Automate Sage Intacct Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Sage Intacct from PowerShell? This article demonstrates how to utilize the Sage Intacct Cmdlets for tasks like connecting to Sage Intacct, automating operations, downloading data, and more.
-
Integrate Redis Data in the Pentaho Report Designer
Publish reports based on Redis in the Pentaho BI tool.
-
How to import Retently Data into Apache Solr
Use the CData Software JDBC Driver for Retently in Data Import Handler and create an automated import of Retently to Apache Solr Enterprise Search platform.
-
Extract, Transform, and Load SageHR Data in Informatica PowerCenter
Create a simple Workflow for SageHR in Informatica PowerCenter.
-
Connect to GraphQL Data from Crystal Reports
Use CData Connect AI to connect to and report on live GraphQL from Crystal Reports.
-
Edit and Search Cloudant External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of IBM Cloudant to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create Cloudant objects that you can access from apps and the dashboard.
-
Connect to Avalara AvaTax Data from PowerBuilder via JDBC
This article demonstrates how to access Avalara AvaTax from PowerBuilder using the Avalara AvaTax JDBC Driver.
-
DataBind Controls to XML Data in C++Builder
DataBind to XML Files in C++Builder with standard components and controls.
-
Connect to Confluence Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Atlassian Confluence.
-
Create Twitter Ads Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Twitter Ads data access from reports, embedded analytics, and more.
-
How to Access Live Gorgias Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Gorgias enables you to integrate Gorgias into workflows built using Microsoft Power Automate Desktop.
-
Publish Crystal Reports on Shippo Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Shippo.
-
Creating Salesforce-Connected Applications in Unqork
You can use CData Connect AI to feed Salesforce & Force.com to Unqork and build custom business apps.
-
Create Power BI Reports on Real-Time Customer.io Data
Use the CData ODBC Driver for Customer.io to visualize Customer.io in Power BI Desktop.
-
Connect to Google Sheets Data in DBArtisan
Use wizards in DBArtisan to configure Google Sheets as a data source.
-
Visualize Live CapsuleCRM Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live CapsuleCRM using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Connect to SAP HANA Data in Ruby
Connect to SAP HANA in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
A PostgreSQL Interface for SAP Netweaver Gateway Data using the CData ODBC Driver
Use the SQL Gateway and SAP Netweaver Gateway ODBC Driver to create a PostgreSQL entry-point for data access.
-
Use the CData Software JDBC Driver for CapsuleCRM in MicroStrategy
Connect to CapsuleCRM in MicroStrategy Developer using the CData Software JDBC Driver for CapsuleCRM.
-
DataBind Controls to Invoiced Data in C++Builder
DataBind to Invoiced in C++Builder with standard components and controls.
-
Visualize Aircall 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 Aircall into TIBCO Spotfire.
-
Build Apps with Live Azure Data Catalog Data Using the Low-Code Development Platform of Mendix
Connect Azure Data Catalog with Mendix to build apps using the CData JDBC Driver for Azure Data Catalog.
-
How to create Visio diagrams from SAP Hybris C4C Data
Automatically update SAP Hybris C4C with the changes you make to Visio master shapes.
-
Connect Reckon Accounts Hosted Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Reckon Accounts Hosted using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Build Voice Agents in ElevenLabs with access to Live MySQL Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live MySQL.
-
Automate Tasks in Power Automate Using the CData API Server
Automate GitHub actions in Microsoft Flow — sending emails, posting to social media, or syncing CRM and ERP.
-
Integrate with LinkedIn Ads Data in JReport Designer
Create charts and reports based on LinkedIn Ads in JReport Designer.
-
Creating PostgreSQL-Connected Applications in Unqork
You can use CData Connect AI to feed PostgreSQL to Unqork and build custom business apps.
-
Migrating data from SAP Fieldglass to Snowflake using CData SSIS Components.
Easily push SAP Fieldglass to Snowflake using the CData SSIS Tasks for SAP Fieldglass and Snowflake.
-
How to Create Power BI Visual Reports with Real-Time SAP Hybris C4C Data
Use CData Power BI Connectors to visualize SAP Hybris C4C in Power BI.
-
How to Connect DBeaver to Rebilly via a JDBC Driver
Manage Rebilly with visual tools in DBeaver like the query browser.
-
Automate Tasks in Power Automate Using the CData API Server
Automate MariaDB actions in Microsoft Flow — sending emails, posting to social media, or syncing CRM and ERP.
-
Visualize Humanity Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Humanity.
-
How to Visualize Cloudflare Data in Python with pandas
Use pandas and other modules to analyze and visualize live Cloudflare in Python.
-
Connect to Hubstaff Data in RapidMiner
Integrate Hubstaff with standard components and data source configuration wizards in RapidMiner Studio.
-
Build a Simple VCL Application for XML Data
How to build a simple VCL Application to view XML Files in RAD Studio using the CData ODBC Driver for XML.
-
Connect to Short.io Data in DBArtisan
Use wizards in DBArtisan to configure Short.io as a data source.
-
Connect to and Query Coda Data in QlikView over ODBC
Create data visualizations with Coda in QlikView.
-
Visualize Perplexity Data in Sisense
Create an ElastiCube in Sisense app with access to Perplexity.
-
Connect to Amazon S3 Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Amazon S3 and the SQL Gateway to access Amazon S3 from Google Apps Script.
-
Use the CData Software ODBC Driver for SAP Business One in MicroStrategy Desktop
Connect to SAP Business One in MicroStrategy Desktop using the CData Software ODBC Driver for SAP Business One.
-
Analyze Freshservice Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Freshservice in Microsoft R Open.
-
Automate OnePageCrm Data Replication to Couchbase
Use CData Sync to Customize and automate OnePageCrm replication to Couchbase.
-
Automated Continuous Opsgenie Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Opsgenie replication to Azure SQL Database.
-
Natively Connect to Active Directory Data in PHP
The CData ODBC driver for Active Directory enables you to create PHP applications with connectivity to Active Directory. Leverage the native support for ODBC in PHP.
-
Create Dynamic SAP Grids Using the Infragistics XamDataGrid
Learn how you can connect SAP to Infragistics XamDataGrid to build dynamic grids.
-
Getting Started with the CData ODBC Driver for CSV
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for CSV.
-
Design BIRT Reports on MailerSend Data
Provide current MailerSend to your embedded analytics.
-
How to Connect DBeaver to JotForm via a JDBC Driver
Manage JotForm with visual tools in DBeaver like the query browser.
-
Automated Continuous Kintone Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Kintone replication to Apache Cassandra.
-
Visualize Live Optimizely Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Optimizely.
-
Build Voice Agents in ElevenLabs with access to Live ServiceNow Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live ServiceNow.
-
Query SAP BusinessObjects BI Data from Node.js
Use the OData endpoint of the CData API Server to connect to your SAP BusinessObjects BI and perform CRUD operations on SAP BusinessObjects BI from Node.js.
-
Connect to and Query Workday Data in QlikView over ODBC
Create data visualizations with Workday in QlikView.