CData Software - Knowledge Base
Recent Articles
-
Integrate SageHR with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate SageHR with External Services.
-
Automate GraphQL Data Replication to Azure Synapse
Use CData Sync to customize and automate GraphQL replication to Azure Synapse.
-
Use the CData Software JDBC Driver for Cloudant in MicroStrategy Desktop
Connect to IBM Cloudant in MicroStrategy Desktop using the CData Software JDBC Driver for Cloudant.
-
Integrating Codex CLI with Zoom 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.
-
Getting Started with the CData Excel Add-In for SparkPost
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for SparkPost.
-
Load Simplesat Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Simplesat to a database.
-
Integrating GitHub Copilot CLI with Attio 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.
-
Use the CData Software JDBC Driver for Amazon S3 in MicroStrategy
Connect to Amazon S3 in MicroStrategy Developer using the CData Software JDBC Driver for Amazon S3.
-
Integrating Kiro CLI with Cloudflare 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.
-
Connect to Authorize.Net Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Authorize.Net Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
How to publish and share Salesforce CRM Analytics Data dashboards with Tableau Server
The CData ODBC driver for Salesforce CRM Analytics enables you integrate Salesforce CRM Analytics into Tableau dashboards.
-
Build Dashboards with SharePoint Excel Services Data in DBxtra
Create dynamic dashboards and perform analytics based on SharePoint Excel Services in DBxtra.
-
Analyze Avaza Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Avaza in Microsoft R Open.
-
Publish SAP SuccessFactors-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live SAP SuccessFactors.
-
Build Google Contacts-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData MCP Server for Google Contacts to explore live Google Contacts Data in GitHub Copilot to assist with building Google Contacts-powered applications.
-
Prepare, Blend, and Analyze Strava Data in Alteryx Designer (ODBC)
Build workflows to access live Strava for self-service data analytics.
-
How to work with SAP Data in Apache Spark using SQL
Access and process SAP Data in Apache Spark using the CData Software JDBC Driver.
-
Visualize Live GitLab Data in the Power BI Service
Use CData Connect AI to connect to live GitLab and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Connect LionDesk to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live LionDesk using the CData Python MCP Server.
-
Integrate Redshift Data into Power Automate Desktop using CData Connect
CData Connect for Redshift Data enables you to integrate Amazon Redshift into workflows built using Microsoft Power Automate Desktop.
-
How to connect to Neo4J Data with Squirrel SQL client
Connect to Neo4J and execute queries in the Squirrel SQL Client.
-
Integrate Real-Time Access to Pinterest in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Pinterest in real time.
-
Connect to Printful Data in CloverDX (formerly CloverETL)
Transfer Printful using the visual workflow in the CloverDX data integration tool.
-
Use the CData Software JDBC Driver for eBay Analytics in MicroStrategy Web
Connect to eBay Analytics in MicroStrategy Web using the CData Software JDBC Driver for eBay Analytics.
-
Access Live VWO Data in Coginiti Pro
Connect to and query live VWO from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Import Real-Time Impala Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Apache Impala in ColdFusion.
-
Integrate Bitbucket with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Bitbucket with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Bitbucket.
-
LINQ to Missive 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 Missive Data Provider.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live MYOB AccountRight using the Model Context Protocol.
-
Perform Batch Operations with Microsoft Dataverse Data in Apache NiFi
Connect to Microsoft Dataverse (CDS) and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Integrating Cursor CLI with Hive 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.
-
Migrating data from Oracle HCM Cloud to Snowflake using CData SSIS Components.
Easily push Oracle HCM Cloud to Snowflake using the CData SSIS Tasks for Oracle HCM Cloud and Snowflake.
-
Build Agents in Relevance AI with Access to Live SAP Netweaver Gateway Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on SAP Netweaver Gateway within intelligent agent workflows.
-
How to connect to PolarTeamPro Data from IntelliJ
Integrate connectivity to PolarTeamPro with wizards in IntelliJ.
-
Connect to Coda from a Connection Pool in WebLogic
Use the CData JDBC Driver for Coda to connect to Coda from Web applications running on WebLogic.
-
Access Live Kintone Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live Kintone data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Integrate with OData Services in JReport Designer
Create charts and reports based on OData in JReport Designer.
-
Automate ZendeskSell Data Replication to Couchbase
Use CData Sync to Customize and automate ZendeskSell replication to Couchbase.
-
Connect to Paymo Data from a Connection Pool in Jetty
The Paymo JDBC Driver supports connection pooling: This article shows how to connect faster to Paymo from Web apps in Jetty.
-
Build an OLAP Cube in SSAS from SendGrid Data
Establish a connection to SendGrid data from SQL Server Analysis Services, and use the SendGrid Data Provider to build OLAP cubes for use in analytics and reporting.
-
How to publish and share SendGrid Data dashboards with Tableau Server
The CData ODBC driver for SendGrid enables you integrate SendGrid into Tableau dashboards.
-
Connect to Stripe Data in Ruby
Connect to Stripe in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
How to connect to SFTP Data in DBVisualizer
Integrate SFTP with visual data analysis tools and data connection wizards in DBVisualizer
-
Consume Workday OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Workday feeds that reflect any changes in SAP Lumira.
-
Use the CData Software ODBC Driver for Xero in MicroStrategy Desktop
Connect to Xero Accounting in MicroStrategy Desktop using the CData Software ODBC Driver for Xero.
-
How to load SingleStore data into Elasticsearch via Logstash
Introducing a simple method to load SingleStore data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Automated Continuous Yelp Replication to Oracle
Use CData Sync for automated, continuous, customizable Yelp replication to Oracle.
-
Use the CData Software ODBC Driver for Tanda in MicroStrategy Web
Connect to Tanda in MicroStrategy Web using the CData Software ODBC Driver for Tanda.
-
Visualize Live Xero Data in the Power BI Service
Use CData Connect AI to connect to live Xero Accounting and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Create Shopify-Connected Applications in Appsmith
Connect to Shopify Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Shopify.
-
Write a Simple Go Application to work with Paylocity Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Paylocity.
-
Use the CData Software ODBC Driver for Front in MicroStrategy Web
Connect to Front in MicroStrategy Web using the CData Software ODBC Driver for Front.
-
Publish Reports with Epicor Kinetic Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Epicor Kinetic.
-
Import Real-Time Moosend Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Moosend in ColdFusion.
-
Integrate Live PagerDuty Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live PagerDuty to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Suadeo
Provide connectivity to Suadeo through an SAP BusinessObjects universe.
-
Use the CData Software JDBC Driver for ZarMoney in MicroStrategy
Connect to ZarMoney in MicroStrategy Developer using the CData Software JDBC Driver for ZarMoney.
-
Create SingleStore-Connected Dashboards in Grafana
Connect to SingleStore Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to SingleStore.
-
Create SSAS Tabular Models from Close Data
How to build a SQL Server Analysis Service Tabular Model from Close using CData drivers.
-
Build Visualizations of FreeAgent Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of FreeAgent in Birst.
-
ETL Typeform in Oracle Data Integrator
This article shows how to transfer Typeform into a data warehouse using Oracle Data Integrator.
-
How to Access Oracle Sales Data Using Entity Framework
This article shows how to access Oracle Sales using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Build Visualizations of AgileCRM Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of AgileCRM in Birst.
-
Perform Batch Operations with Exact Online Data in Apache NiFi
Connect to Exact Online and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Create Reports from WordPress Data in Looker Studio
Use CData Connect AI to gain access to live WordPress and create custom reports in Looker Studio.
-
DataBind Controls to Insightly Data in Delphi
DataBind to Insightly in Delphi with standard data access components and controls.
-
Automate Sendwithus Data Replication to Azure Synapse
Use CData Sync to customize and automate Sendwithus replication to Azure Synapse.
-
Operational Reporting on Kafka Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Apache Kafka.
-
How to connect to Clari Data from IntelliJ
Integrate connectivity to Clari with wizards in IntelliJ.
-
How to Connect to Live Acumatica Data from Google ADK Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Google ADK agents to securely read and take actions on your Acumatica ERP for you.
-
Query Supabase Data as a MySQL Database in Node.js
Execute MySQL queries against Supabase from Node.js.
-
Build Google Drive-Powered Applications in Claude Code with CData MCP Server
Use the CData MCP Server for Google Drive to explore live Google Drive Data in Claude Code to assist with building Google Drive-powered applications.
-
How to Query Live SAP HANA Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live SAP HANA data in natural language using Python.
-
Bidirectional Access to Klipfolio Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Klipfolio in Filemaker Pro for Mac or Windows.
-
Build Agents in Relevance AI with Access to Live MariaDB Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on MariaDB within intelligent agent workflows.
-
Getting Started with the CData ODBC Driver for Quickbase
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Quickbase.
-
Getting Started with the CData ADO.NET Provider for Wave Financial
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Wave Financial.
-
Manage SAP SuccessFactors Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for SAP SuccessFactors.
-
Connect to Recurly Data in DBArtisan
Use wizards in DBArtisan to configure Recurly as a data source.
-
Edit and Search Zuora External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of Zuora to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create Zuora objects that you can access from apps and the dashboard.
-
Visualize Live HubSpot Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live HubSpot into custom reports in Power BI.
-
Natively Connect to SAP Ariba Procurement Data in PHP
The CData ODBC driver for SAP Ariba Procurement enables you to create PHP applications with connectivity to SAP Ariba Procurement. Leverage the native support for ODBC in PHP.
-
How to Connect to Live Google Calendar 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 Google Calendar through natural language.
-
How to connect and process Bright Data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Bright Data.
-
Access Live Microsoft OneDrive Data in AWS Lambda
Connect to live Microsoft OneDrive in AWS Lambda using the CData JDBC Driver.
-
Create Dashboards and Visualize Live NetSuite Data in Geckoboard
Use CData Connect AI to connect to live NetSuite CRM & ERP and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Visualize Google Ads Data in Tableau
The CData ODBC driver for Google Ads enables you integrate Google Ads into Tableau dashboards.
-
Use ChatGPT to Talk to Your SAS Data Sets Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable ChatGPT to securely answer questions and take actions on your SAS Data Sets for you.
-
Build Automated Workflows with Live PayPal Data in Workato
Use CData Connect AI to connect to live PayPal and build automated workflows in Workato.
-
Extend Google Sheets with SAP HANA Data
Make calls to SAP HANA from Google Apps Script via the API Server.
-
Use the CData Software JDBC Driver for SAP Netweaver Gateway in MicroStrategy Desktop
Connect to SAP Netweaver Gateway in MicroStrategy Desktop using the CData Software JDBC Driver for SAP Netweaver Gateway.
-
Access Live Cassandra Data in AWS Lambda
Connect to live Apache Cassandra in AWS Lambda using the CData JDBC Driver.
-
Use the CData Software JDBC Driver for Rootly in MicroStrategy
Connect to Rootly in MicroStrategy Developer using the CData Software JDBC Driver for Rootly.
-
How to use SQLAlchemy ORM to access MessageBird Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of MessageBird.
-
Connect to Microsoft Entra ID Data in Ruby
Connect to Microsoft Entra ID in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Connect to Mistral AI Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Mistral AI using standard SQL.
-
Automated Continuous Sage Intacct Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Sage Intacct replication to Apache Cassandra.
-
Build Pipelines with Live Azure DevOps Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Azure DevOps from Google Cloud Data Fusion, enabling the integration of live Azure DevOps into the building and management of effective data pipelines.
-
Connect to Google Search Results in CloverDX (formerly CloverETL)
Transfer Google Search using the visual workflow in the CloverDX data integration tool.
-
Choosing the Best Method to Connect Qualaroo to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Qualaroo from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.