CData Software - Knowledge Base
Recent Articles
-
Getting Started with the CData ADO.NET Provider for Microsoft OneDrive
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Microsoft OneDrive.
-
Build SAP Ariba Source-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to SAP Ariba Source Data from Zoho Analytics and import live SAP Ariba Source data.
-
Automated Continuous Facebook Replication to SQL Server
Use CData Sync for automated, continuous, customizable Facebook replication to SQL Server.
-
Connect to Autopilot Data in RazorSQL
Connect to Autopilot from wizards and query Autopilot data from the GUI in the RazorSQL database management tool.
-
Access Sendwithus Data from MySQL in Amazon QuickSight
Connect to Sendwithus and build visualizations of Sendwithus data using a MySQL Connection in Amazon QuickSight.
-
Import Real-Time SAS Data Sets Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use SAS Data Sets data in ColdFusion.
-
Create Greenplum Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Greenplum from PowerBI.com to create Power BI Dataflows with real-time data.
-
Automated Continuous Reply.io Replication to SingleStore
Use CData Sync for automated, continuous, customizable Reply.io replication to SingleStore.
-
Automated Continuous Campaigner Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Campaigner replication to Apache Cassandra.
-
Prepare, Blend, and Analyze Azure Synapse Data in Alteryx Designer (ODBC)
Build workflows to access live Azure Synapse data for self-service data analytics.
-
Integrate Stripe Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Stripe data from Informatica Cloud.
-
How to Build an ETL App for Salesforce Data 360 Data in Python with CData Connect AI
Extract and transform live Salesforce Data 360 data in Python with petl and the CData Connect AI Python SDK.
-
Automated Continuous Close Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Close replication to PostgreSQL.
-
Load Microsoft Teams Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Microsoft Teams data to a database.
-
Build AI/ML Models with Live SQL Analysis Services Data using Dataiku
Connect SQL Analysis Services Data with Dataiku using the CData JDBC Driver for SQL Analysis Services.
-
Replicate Twilio Data to Multiple Databases
Replicate Twilio data to disparate databases with a point-and-click configuration.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Acumatica
Provide connectivity to Acumatica data through an SAP BusinessObjects universe.
-
Visualize Live Kintone Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Kintone data into custom reports in Power BI.
-
Work with Live Tally Data in Power Query
Use CData Connect AI to connect to Tally data and work with live Tally data in Microsoft Power Query.
-
Operational Reporting on Access Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Access data.
-
LINQ to ZarMoney 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 ZarMoney Data Provider.
-
Integrate Oracle Sales Data in the Pentaho Report Designer
Publish reports based on Oracle Sales data in the Pentaho BI tool.
-
Automate DB2 for i Data Replication to Couchbase
Use CData Sync to Customize and automate DB2 for i data replication to Couchbase.
-
Query Google Forms Data as a MySQL Database in Node.js
Execute MySQL queries against Google Forms data from Node.js.
-
How to connect to Azure Table Data with Squirrel SQL client
Connect to Azure Table data and execute queries in the Squirrel SQL Client.
-
How to Connect to Todoist Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Todoist data. Leverage the pyodbc module for ODBC in Python.
-
How to Access Live Authorize.Net Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Authorize.Net enables you to integrate Authorize.Net data into workflows built using Microsoft Power Automate Desktop.
-
How to Connect the Power BI Service to Rebilly: Complete Guide
Connect to the CData Software Power BI Connector for Rebilly from PowerBI.com to provide real-time Rebilly data across the organization.
-
Bind Live SAP Fieldglass Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live SAP Fieldglass data and seamlessly connect and bind them to Wijmo's FlexGrid for real-time, interactive data access without manual data movement.
-
Automated Continuous Browserless Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Browserless data replication to OneLake in Microsoft Fabric.
-
Access Live Avalara AvaTax Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Avalara AvaTax data into the statistical analysis tools available in SAS JMP. This article shows how to use Avalara AvaTax data in the Graph Builder and Query Builder.
-
Connect Monday.com Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Monday.com data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Integrating GitHub Copilot with Samanage 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.
-
Integrate Live AgileCRM Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to AgileCRM data and integrate live AgileCRM data into apps built in Microsoft Power Apps.
-
Create Informatica Mappings From/To an ODBC Data Source for RSS
Create an ODBC connection to RSS in Informatica and browse and transfer RSS feeds.
-
Visualize Xero Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Xero data.
-
Connect to Deel Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Deel as an External Source in Dremio.
-
Integrating Boomi Agentstudio with Attio Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Attio data, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Build a Singer.io Tap for Coda With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Coda data using the CData Python Connector.
-
Query TaxJar Data as a MySQL Database in Node.js
Execute MySQL queries against TaxJar data from Node.js.
-
Getting Started with the CData JDBC Driver for Todoist
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Todoist.
-
Build Dashboards with SAP Ariba Procurement Data in DBxtra
Create dynamic dashboards and perform analytics based on SAP Ariba Procurement data in DBxtra.
-
How to Build an ETL App for Figshare Data in Python with CData
Create ETL applications and real-time data pipelines for Figshare data in Python with petl.
-
Build Charts with Insightly Data in Clear Analytics
Create dynamic charts and perform analytics based on Insightly data in Clear Analytics.
-
Connecting GenSpark with WooCommerce Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to WooCommerce data without any replication or custom integration required.
-
Build LinkedIn Ads-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for LinkedIn Ads Data and create custom apps in Mendix.
-
ADP Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to ADP data through CData Connect AI using different applications and tools.
-
Automated Continuous Foursquare Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Foursquare replication to Amazon S3.
-
Analyze Confluence Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Confluence data in Microsoft R Open.
-
Build Visualizations of CampaignMonitor Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of CampaignMonitor data in Birst.
-
Operational Reporting on Avaza Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Avaza data.
-
Create Informatica Mappings From/To an ODBC Data Source for Quickbase
Create an ODBC connection to Quickbase in Informatica and browse and transfer Quickbase data.
-
Connect Parallel to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Parallel data using the CData Python MCP Server.
-
Visualize Live Workday Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Workday data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Connect to Zendesk Data in Aqua Data Studio
Access Zendesk data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Build Google Search Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Google Search results and build visualizations in Tableau Cloud.
-
Visualize NASA Data in Tableau
The CData ODBC driver for NASA enables you integrate NASA data into Tableau dashboards.
-
Automate Clio Data Replication to Azure Data Lake
Use CData Sync to customize and automate Clio data replication to Azure Data Lake.
-
Operational Reporting on Rebilly Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Rebilly data.
-
Connect Outlook to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Outlook with IBM WebSphere for seamless data integration and connectivity.
-
Connect to ZohoMarketingHub from Asprova with CData Software ODBC Driver for ZohoMarketingHub
This article shows how to connect faster to ZohoMarketingHub data from Asprova.
-
Analyze SAP Ariba Procurement Data in Looker
Use CData Connect AI to connect to SAP Ariba Procurement Data from Looker and build custom apps using live SAP Ariba Procurement data.
-
How to use SQLAlchemy ORM to access LaunchDarkly Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of LaunchDarkly data.
-
Access Live Sage Intacct Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Sage Intacct data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Integrate Outreach.io with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Outreach.io with External Services.
-
Build an OLAP Cube in SSAS from Shippo Data
Establish a connection to Shippo data data from SQL Server Analysis Services, and use the Shippo Data Provider to build OLAP cubes for use in analytics and reporting.
-
Getting Started with the CData ODBC Driver for Tavily
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Tavily.
-
How to Easily Query Anaplan Data in OpenOffice Base
Connect to Anaplan data in OpenOffice Base using the CData ODBC Driver for Anaplan and generate reports with live data insights.
-
Create Kintone Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Kintone data access from reports, embedded analytics, and more.
-
Connect to Lakebase Data from a Connection Pool in Jetty
The Lakebase JDBC Driver supports connection pooling: This article shows how to connect faster to Lakebase data from Web apps in Jetty.
-
Access MYOB AccountRight Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access MYOB AccountRight data from your Oracle system.
-
Publish Harvest-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Harvest data.
-
Query Oracle Sales Data in ColdFusion
Write standard ColdFusion data access code to connect to Oracle Sales data.
-
Deploy the ADO.NET Provider for Coinbase on an SSRS Report Server
Connect to Coinbase data from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.
-
Build Automated Workflows with Live Raisers Edge NXT Data in Workato
Use CData Connect AI to connect to live Raisers Edge NXT data and build automated workflows in Workato.
-
Use the CData Software ODBC Driver for LightSpeedRetail in MicroStrategy Desktop
Connect to LightSpeedRetail data in MicroStrategy Desktop using the CData Software ODBC Driver for LightSpeedRetail.
-
Object-Relational Mapping (ORM) with Access Data Entities in Java
Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to Access data into a Java-based ORM framework, Hibernate.
-
A PostgreSQL Interface for Salesforce CRM Analytics Data using the CData ODBC Driver
Use the SQL Gateway and Salesforce CRM Analytics ODBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to Pinterest Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Pinterest Data and connect to Pinterest data in Akorbi Digital RunMyProcess.
-
Perform Batch Operations with Blackbaud FE NXT Data in Apache NiFi
Connect to Blackbaud FE NXT data and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Connect Chargebee to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Chargebee with IBM WebSphere for seamless data integration and connectivity.
-
Build AI/ML Models with Live SurveyMonkey Data using Dataiku
Connect SurveyMonkey Data with Dataiku using the CData JDBC Driver for SurveyMonkey.
-
Getting Started with the CData ADO.NET Provider for Landbot
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Use Dash to Build to Web Apps on GitHub Data
Create Python applications that use pandas and Dash to build GitHub-connected web apps.
-
Connect to Excel Online Data in Google Apps Script via Connect AI
Use CData Connect AI to access Excel Online data in Google Apps Script.
-
Integrating Claude Code with Zuora Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Zuora data within assisted coding and automated development workflows.
-
Use the CData Software ODBC Driver for SAP ByDesign in MicroStrategy
Connect to SAP ByDesign data in MicroStrategy Developer using the CData Software ODBC Driver for SAP ByDesign.
-
Automated Continuous Apify Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Apify data replication to OneLake in Microsoft Fabric.
-
Enable the eBay JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with eBay data.
-
How to Connect Stripe 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 Stripe data in real time using natural language.
-
Use the CData Software ODBC Driver for Power BI XMLA in SAS for Real-Time Reporting and Analytics
Connect to real-time Power BI XMLA data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Power BI XMLA.
-
Integrating Cursor with Tally 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.
-
Interact with Live Tavily Data in Meta Muse via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Muse to securely interact with live Tavily data.
-
Integrating Kiro with Keap 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.
-
Create Dashboards and Visualize Live Pinterest Data in Geckoboard
Use CData Connect AI to connect to live Pinterest data and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Build Visualizations of Google Ads Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Google Ads data in Birst.
-
Connect to FormSite from Asprova with CData Software ODBC Driver for FormSite
This article shows how to connect faster to FormSite data from Asprova.
-
Query Sage Cloud Accounting Data as a SQL Server Database in Node.js
Execute SQL Server queries against Sage Cloud Accounting data from Node.js.
-
Object-Relational Mapping (ORM) with Copper Data Entities in Java
Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to Copper data into a Java-based ORM framework, Hibernate.
-
DataBind Controls to Freshservice Data in C++Builder
DataBind to Freshservice data in C++Builder with standard components and controls.