CData Software - Knowledge Base
Recent Articles
-
Replicate MYOB AccountRight to Multiple Databases
Replicate MYOB AccountRight to disparate databases with a point-and-click configuration.
-
Bind Live SAP HANA XS Advanced Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live SAP HANA XS Advanced data
-
Integrate Real-Time Access to Google Calendar in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Google Calendar in real time.
-
Integrate Zuora in Pentaho Data Integration
Build ETL pipelines based on Zuora in the Pentaho Data Integration tool.
-
Build MVC Applications with Connectivity to Wave Financial
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Wave Financial from an ASP.NET MVC application.
-
Connect to Sage Intacct from PowerBuilder via ADO.NET
This article demonstrates how to access Sage Intacct from Appeon PowerBuilder using the CData ADO.NET Provider for Sage Intacct.
-
Connect to Stripe as an External Data Source using PolyBase
Use CData Connect AI and PolyBase to create an external data source in SQL Swerver with access to live Stripe.
-
Access eBay from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live eBay from HeidiSQL.
-
Operational Reporting on Google Search Results from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Google Search.
-
Build Dynamics 365-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Dynamics 365 and create custom apps in Bubble.
-
Build a PostgreSQL Interface for SurveyMonkey using the CData JDBC Driver
Use the Remoting features of the SurveyMonkey JDBC Driver to create a PostgreSQL entry-point for data access.
-
How to connect PolyBase to Printful
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Printful.
-
How to connect Amazon QuickSight to Xero
Create a connection to Xero Accounting in CData Connect AI and insert Xero Accounting into Amazon QuickSight SPICE to build interactive dashboards.
-
Automated Continuous Couchbase Replication to Snowflake
Use CData Sync for automated, continuous, customizable Couchbase replication to Snowflake.
-
Build Couchbase-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Couchbase and build web apps with connectivity to live Couchbase.
-
Connect to MariaDB in HULFT Integrate
Connect to MariaDB as a JDBC data source in HULFT Integrate
-
Excel Spreadsheet Automation on Airtable with the QUERY Formula
Pull data, automate spreadsheets, and more with the QUERY formula.
-
Connect to Sage 200 in RazorSQL
Connect to Sage 200 from wizards and query Sage 200 from the GUI in the RazorSQL database management tool.
-
SAP Drivers Overview
In this entry, you will find an overview of the SAP products supported by CData as well as the interfaces used to surface their data.
-
Stream Oracle Service Cloud into Apache Kafka Topics
Access and stream Oracle Service Cloud in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Extend Google Sheets with eBay Analytics
Make calls to the API Server from Google Apps Script.
-
Building Dynamic Web Pages with SuiteCRM Using AngularJS
Create single-page applications with live connectivity to SuiteCRM using the CData API Server.
-
Automate Xero Replication to SAP HANA
Use CData Sync to customize and automate Xero Accounting replication to SAP HANA.
-
Replicate Multiple SAP Netweaver Gateway Accounts via the CData Sync CLI
Replicate multiple SAP Netweaver Gateway accounts to one or many databases.
-
Integrate Live Active Directory into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Active Directory and integrate live Active Directory into apps built in Microsoft Power Apps.
-
How to create Certinia federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Certinia in MySQL .
-
Configure the CData JDBC Driver for Box in a Connection Pool in Tomcat
Connect to Box from a connection pool in Tomcat.
-
Create Zendesk-Connected Business Apps in AppSheet
Connect to Zendesk via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Zendesk.
-
Extract, Transform, and Load SAP Concur in Informatica PowerCenter
Create a simple Workflow for SAP Concur in Informatica PowerCenter.
-
Replicate SharePoint Excel Services in Heroku for Use in Salesforce Connect
Replicate SharePoint Excel Services to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Build Charts with Oracle Sales in Clear Analytics
Create dynamic charts and perform analytics based on Oracle Sales in Clear Analytics.
-
DataBind Office 365 to the DevExpress Data Grid
Use the CData Software ADO.NET Provider for Office 365 with the DevExpress Windows Forms and Web controls to provide Microsoft Office 365 to a chart.
-
How to Access Live Pipedrive in Power Automate Desktop via ODBC
The CData ODBC Driver for Pipedrive enables you to integrate Pipedrive into workflows built using Microsoft Power Automate Desktop.
-
Create Dynamic Basecamp Grids Using the Infragistics XamDataGrid
Learn how you can connect Basecamp to Infragistics XamDataGrid to build dynamic grids.
-
Integrating LangGraph with Quickbase via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Quickbase within automated workflows.
-
How to Connect to Live WooCommerce 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 WooCommerce through natural language.
-
How to integrate Parquet with Apache Airflow
Access and process Apache Parquet in Apache Airflow using the CData JDBC Driver.
-
Automated Continuous Lakebase Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Lakebase replication to AlloyDB.
-
DataBind Controls to Highrise in C++Builder
DataBind to Highrise CRM in C++Builder with standard components and controls.
-
Visualize Live Facebook in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Facebook into custom reports in Power BI.
-
Connect to Authorize.Net in RazorSQL
Connect to Authorize.Net from wizards and query Authorize.Net from the GUI in the RazorSQL database management tool.
-
Automated Continuous Google Contacts Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Google Contacts replication to delimited files (CSV/TSV).
-
Automated Continuous Microsoft OneLake Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Microsoft OneLake replication to AlloyDB.
-
Build a PostgreSQL Interface for Twitter Ads using the CData JDBC Driver
Use the Remoting features of the Twitter Ads JDBC Driver to create a PostgreSQL entry-point for data access.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed QuickBooks Online to Power BI dashboards. Simply drag and drop QuickBooks Online into data visuals on the Power BI canvas.
-
Create Data Visualizations in Cognos BI with Bitbucket
Access Bitbucket as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Integrate with Amazon S3 in SnapLogic
Use CData Connect AI to connect to and integrate with live Amazon S3 in SnapLogic.
-
Query YouTube Analytics using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume YouTube Analytics entities in PHP by modeling them as objects.
-
Use the CData Software JDBC Driver for SQL Server in MicroStrategy Desktop
Connect to Microsoft SQL Server in MicroStrategy Desktop using the CData Software JDBC Driver for SQL Server.
-
Automated Continuous LDAP Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable LDAP replication to Apache Cassandra.
-
Connect to Hive in JRuby
Create a simple JRuby app with access to live Apache Hive.
-
Visualize Cloudant in Tableau
The CData ODBC driver for Cloudant enables you integrate IBM Cloudant into Tableau dashboards.
-
Extend Google Sheets with Exact Online
Make calls to the API Server from Google Apps Script.
-
How to Query Live Salesforce Data Cloud Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Salesforce Data Cloud data in natural language using Python.
-
Use Azure AI Foundry to Talk to Your Presto via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Azure AI Foundry agents to securely answer questions and take actions on your Presto for you.
-
How to Connect to Live Kintone 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 Kintone for you.
-
Configure the CData JDBC Driver for Azure DevOps in a Connection Pool in Tomcat
Connect to Azure DevOps from a connection pool in Tomcat.
-
DataBind Controls to Azure Active Directory in Delphi
DataBind to Azure Active Directory in Delphi with standard data access components and controls.
-
Connecting GenSpark with CockroachDB via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to enterprise data across 300+ systems without any replication or custom integration required.
-
Operational Reporting on Sage 300 from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Sage 300.
-
Integrate Reckon in Pentaho Data Integration
Build ETL pipelines based on Reckon in the Pentaho Data Integration tool.
-
Connect to Act CRM in SpagoBI
Create reports featuring live Act CRM in SpagoBI Studio. Host Act CRM reports on SpagoBI Server.
-
Build a Simple VCL Application for Blackbaud FE NXT
How to build a simple VCL Application to view Blackbaud FE NXT in RAD Studio using the CData ODBC Driver for Blackbaud FE NXT.
-
Use the CData Software JDBC Driver for Raisers Edge NXT in MicroStrategy
Connect to Raisers Edge NXT in MicroStrategy Developer using the CData Software JDBC Driver for Raisers Edge NXT.
-
ETL SAP in Oracle Data Integrator
This article shows how to transfer SAP ERP/NetWeaver into a data warehouse using Oracle Data Integrator.
-
Connect to Sugar CRM from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Sugar CRM from Filemaker Pro on Mac.
-
Connect Todoist to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Todoist using the CData Python MCP Server.
-
Automated Continuous Oracle Eloqua Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Oracle Eloqua replication to Amazon Redshift.
-
How to connect to Zoho CRM in DBVisualizer
Integrate Zoho CRM with visual data analysis tools and data connection wizards in DBVisualizer
-
Bind Live SAS xpt Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live SAS xpt data
-
Getting Started with the CData SSIS Components for Excel Online
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Excel Online.
-
Natively Connect to Zoho Projects in PHP
The CData ODBC driver for Zoho Projects enables you to create PHP applications with connectivity to Zoho Projects. Leverage the native support for ODBC in PHP.
-
Model, Search, and Visualize Live Jira Service Management in ThoughtSpot
Use CData Connect AI to connect to live Atlassian Jira Service Management for modeling, searching, and visualizing.
-
How to connect to Google Drive from IntelliJ
Integrate connectivity to Google Drive with wizards in IntelliJ.
-
Connect to Amazon Athena in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Amazon Athena and connect to Amazon Athena in Akorbi Digital RunMyProcess.
-
Integrate QuickBooks with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate QuickBooks with External Services.
-
Visualize SharePoint Excel Services in TIBCO Spotfire through OData
Integrate SharePoint Excel Services into dashboards in TIBCO Spotfire.
-
Object-Relational Mapping (ORM) with Zoom 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 Zoom into a Java-based ORM framework, Hibernate.
-
Connect to Kintone as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Kintone.
-
How to Connect to Jira in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Atlassian Jira. Leverage the pyodbc module for ODBC in Python.
-
Access Live Drift in TIBCO Data Virtualization
-