CData Software - Knowledge Base
Recent Articles
-
Access Printify 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 Printify.
-
Create Dynamic Everhour Grids Using the Infragistics XamDataGrid
Learn how you can connect Everhour to Infragistics XamDataGrid to build dynamic grids.
-
Consume Google Directory OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Google Directory feeds that reflect any changes in SAP Lumira.
-
Build AI Agents with SAS Data Sets 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 SAS Data Sets through CData Connect AI.
-
Automated Continuous Intercom Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Intercom replication to Apache Cassandra.
-
Getting Started with the CData JDBC Driver for Bugsnag
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Bugsnag.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for PingOne
Provide connectivity to PingOne through an SAP BusinessObjects universe.
-
Access Live Landbot Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Landbot in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
How to Work with SparkPost Data in ETL Validator JDBC
Connect to SparkPost from ETL Validator jobs using the CData Software JDBC Driver.
-
Connect to Freshteam Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Building Dynamic Web Pages with Instagram Data Using AngularJS
Create single-page applications with live connectivity to Instagram using the CData API Server.
-
Build Outreach.io-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Outreach.io Data from Zoho Analytics and import live Outreach.io.
-
How to Design Google Drive Power Apps with Database-Like Connectivity
Gain real-time, database-like connectivity to Google Drive from mobile and tablet Power Apps.
-
How to create an RPA flow for Azure DevOps Data in UiPath Studio
Use the Azure DevOps ODBC Driver to create workflows that access real-time Azure DevOps without any coding.
-
Integrate Cline with Live SAP Hybris C4C Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live SAP Hybris C4C from within your IDE.
-
How to Visualize MYOB AccountRight Data in Python with pandas
Use pandas and other modules to analyze and visualize live MYOB AccountRight in Python.
-
Connect to MailChimp Data in Google Apps Script via Connect AI
Use CData Connect AI to access MailChimp in Google Apps Script.
-
Build Dashboards with HubDB Data in Dundas BI
Create dynamic dashboards and perform analytics based on HubDB in Dundas BI.
-
Automated Continuous IBM Informix Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable IBM Informix replication to Apache Kafka.
-
Extract, Transform, and Load Float Data in Informatica PowerCenter
Create a simple Workflow for Float in Informatica PowerCenter.
-
Getting Started with the CData Excel Add-In for Parquet
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Parquet.
-
Connect to SAP Ariba Procurement Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for SAP Ariba Procurement in the Denodo Virtual DataPort Administrator.
-
How to work with Confluence Data in Apache Spark using SQL
Access and process Confluence Data in Apache Spark using the CData Software JDBC Driver.
-
Stream Mailjet Data into Apache Kafka Topics
Access and stream Mailjet in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
How to Connect Flowise AI Agents to Live Highrise Data via CData Connect AI
Integrate Flowise AI with the CData Connect AI MCP Server to enable agents to securely query and act on live Highrise CRM without replication.
-
LINQ to Insightly 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 Insightly Data Provider.
-
Connect to Simplesat Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Simplesat and the SQL Gateway to access Simplesat from Google Apps Script.
-
Automated Continuous Sage 200 Replication to MySQL
Use CData Sync for automated, continuous, customizable Sage 200 replication to MySQL.
-
How to Connect to ZohoPeople Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to ZohoPeople. Leverage the pyodbc module for ODBC in Python.
-
Create Informatica Mappings From/To a JDBC Data Source for PayPal
Create PayPal data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Visualize Teradata Data in Tableau
The CData ODBC driver for Teradata enables you integrate Teradata into Tableau dashboards.
-
Use JayDeBeApi to access Opsgenie Data in Python
Use standard Python scripting and the development environment of your choice to access live Opsgenie.
-
Create XML Dataflows on PowerBI.com
Connect to the CData Power BI Connector for XML from PowerBI.com to create Power BI Dataflows with real-time data.
-
Build Visualizations of Coinbase Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Coinbase in Birst.
-
Access Live Google Analytics Data in Emergent via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Emergent agents to securely access and build applications with live Google Analytics through MCP integration.
-
Use Microsoft Copilot Studio to talk to your SAP ByDesign Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Microsoft Copilot Studio to securely answer questions and take actions on your SAP Business ByDesign for you.
-
Dynamics 365 Reporting in OBIEE with the Dynamics 365 JDBC Driver
Deploy the Dynamics 365 JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Build a Simple VCL Application for SendGrid Data
How to build a simple VCL Application to view SendGrid in RAD Studio using the CData ODBC Driver for SendGrid.
-
Use Claude to Talk to Your Excel Online 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 Microsoft Excel Online for you.
-
Connect to Real-Time Marketo Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Marketo and Dataflow to import and use Marketo in Power Apps.
-
Automated Continuous Google Spanner Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Google Spanner replication to delimited files (CSV/TSV).
-
How to Easily Query Mocean Data in OpenOffice Base
Connect to Mocean data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Integrating Claude Code CLI with Hubstaff 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.
-
Bidirectional Access to Google Sheets Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Google Sheets in Filemaker Pro for Mac or Windows.
-
Integrate with FHIR Data in SnapLogic
Use CData Connect AI to connect to and integrate with live FHIR in SnapLogic.
-
Access Live IBM Cloud Object Storage Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live IBM Cloud Object Storage from your Excel spreadsheets.
-
Visualize Adobe Commerce Data in Tableau
The CData ODBC driver for Adobe Commerce enables you integrate Adobe Commerce into Tableau dashboards.
-
Create Reports with Egnyte Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Egnyte.
-
Moving Data from FTP to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live FTP data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Highrise
Provide connectivity to Highrise CRM through an SAP BusinessObjects universe.
-
Build Charts with MarkLogic Data in Clear Analytics
Create dynamic charts and perform analytics based on MarkLogic in Clear Analytics.
-
Getting Started with the CData Tableau Connector for Pingdom
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Publish Reports with SAP Business One Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date SAP Business One.
-
Build Agents in Relevance AI with Access to Live Splunk Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Splunk within intelligent agent workflows.
-
Use ChatGPT to Talk to Your Google Cloud Storage 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 Google Cloud Storage for you.
-
How to import Bugsnag Data into Apache Solr
Use the CData Software JDBC Driver for Bugsnag in Data Import Handler and create an automated import of Bugsnag to Apache Solr Enterprise Search platform.
-
Connect to SAP SuccessFactors Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for SAP SuccessFactors and the Script function in FileMaker Pro to connect to SAP SuccessFactors and work with SAP SuccessFactors in your FileMaker application.
-
A PostgreSQL Interface for Elorus Data using the CData ODBC Driver
Use the SQL Gateway and Elorus ODBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to Dynamics 365 Data in RazorSQL
Connect to Dynamics 365 from wizards and query Microsoft Dynamics 365 from the GUI in the RazorSQL database management tool.
-
Access MessageBird Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access MessageBird from your Oracle system.
-
Automated Continuous HCL Domino Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable HCL Domino replication to PostgreSQL.
-
Integrate SAP BusinessObjects BI Data in Pentaho Data Integration
Build ETL pipelines based on SAP BusinessObjects BI in the Pentaho Data Integration tool.
-
Create Simplesat Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Simplesat data access from reports, embedded analytics, and more.
-
How to connect to IBM Informix Data with Squirrel SQL client
Connect to IBM Informix and execute queries in the Squirrel SQL Client.
-
Import and Visualize AdRoll Data in Power View
Create data visualizations based on AdRoll in Excel.
-
Connect to Real-Time Exa Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Exa in Power Apps.
-
Build an OLAP Cube in SSAS from Paylocity Data
Establish a connection to Paylocity data from SQL Server Analysis Services, and use the Paylocity Data Provider to build OLAP cubes for use in analytics and reporting.
-
Create Power BI Reports on Real-Time SAP Ariba Procurement Data
Use the CData ODBC Driver for SAP Ariba Procurement to visualize SAP Ariba Procurement in Power BI Desktop.
-
Prepare, Blend, and Analyze REST Data in Alteryx Designer (ODBC)
Build workflows to access live REST for self-service data analytics.
-
Natively Connect to Instagram Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Instagram. Leverage the native support for ODBC in PHP.
-
Build Visualizations of Databricks Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Databricks in Birst.
-
Connecting Agentforce with Sugar CRM Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Agentforce to securely read and take actions on your Sugar CRM for you.
-
Publish Crystal Reports on LinkedIn Ads Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date LinkedIn Ads.
-
Use the CData ODBC Driver for Reply.io from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Reply.io to connect to Reply.io from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Reply.io in Excel.
-
Integrate Azure Analysis Services with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Azure Analysis Services with External Services.
-
Build Freshdesk Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Freshdesk and build visualizations in Tableau.
-
Access Egnyte 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 Egnyte.
-
Automated Continuous ZohoPeople Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable ZohoPeople replication to Apache Cassandra.
-
Integrate Real-Time Access to Anaplan in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Anaplan in real time.
-
Access Live Microsoft OneDrive Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Microsoft OneDrive into the statistical analysis tools available in SAS JMP. This article shows how to use Microsoft OneDrive in the Graph Builder and Query Builder.
-
Connect JSON Services to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your JSON using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Connect to Outreach.io Data in JRuby
Create a simple JRuby app with access to live Outreach.io.
-
How to Access Guru Data Using Entity Framework
This article shows how to access Guru using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Integrate Real-Time Access to Cloudant in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to IBM Cloudant in real time.
-
Build Dashboards with Square Data in DBxtra
Create dynamic dashboards and perform analytics based on Square in DBxtra.
-
Automated Continuous Azure Synapse Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Azure Synapse replication to PostgreSQL.
-
How to Easily Query BigCommerce Data in OpenOffice Base
Connect to BigCommerce data in OpenOffice Base using the CData ODBC Driver for BigCommerce and generate reports with live data insights.
-
Configure the CData JDBC Driver for Attio in a Connection Pool in Tomcat
Connect to Attio from a connection pool in Tomcat.
-
Automate HelloSign Data Replication to Couchbase
Use CData Sync to Customize and automate HelloSign replication to Couchbase.
-
A PostgreSQL Interface for FHIR Data (MySQL Remoting via JDBC)
Use the Remoting features of the FHIR JDBC Driver to create a PostgreSQL entry-point for data access.
-
Automated Continuous SpaceX Replication to MySQL
Use CData Sync for automated, continuous, customizable SpaceX replication to MySQL.
-
Build a Singer.io Tap for Authorize.Net With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Authorize.Net data using
-
Moving Data from Zoho CRM to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Zoho CRM data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Create Quaderno Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Quaderno from PowerBI.com to create Power BI Dataflows with real-time data.
-
Integrating Claude Code CLI with NASA 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.
-
Validate Suadeo Data with QuerySurge
Access and validate Suadeo in QuerySurge using the CData JDBC Driver.
-
How to Connect DBeaver to MariaDB via a JDBC Driver
Manage MariaDB with visual tools in DBeaver like the query browser.
-
Build Charts with FormSite Data in Clear Analytics
Create dynamic charts and perform analytics based on FormSite in Clear Analytics.
-
Use Agno to Talk to Your Google Spanner 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 Google Spanner for you.
-
Query CSV Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume CSV entities in PHP by modeling them as objects.