CData Software - Knowledge Base
Recent Articles
-
Build Charts with REST in Clear Analytics
Create dynamic charts and perform analytics based on REST in Clear Analytics.
-
How to Visualize JotForm Data in Python with pandas
Use pandas and other modules to analyze and visualize live JotForm in Python.
-
Analyze SharePoint in Looker
Use CData Connect AI to connect to SharePoint from Looker and build custom apps using live Microsoft SharePoint.
-
Analyze Authorize.Net in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Authorize.Net in Microsoft R Open.
-
Migrating data from SAS Data Sets to Databricks using CData SSIS Components.
Easily push SAS Data Sets to Databricks using the CData SSIS Tasks for SAS Data Sets and Databricks.
-
How to connect to Gmail from IntelliJ
Integrate connectivity to Gmail with wizards in IntelliJ.
-
Consume Wave Financial OData Feeds in PowerBuilder
This article demonstrates how to consume Wave Financial as OData feeds from PowerBuilder using the API Server.
-
Use JayDeBeApi to access QuickBooks in Python
Use standard Python scripting and the development environment of your choice to access live QuickBooks Desktop.
-
Query HBase using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume HBase entities in PHP by modeling them as objects.
-
Connecting Mastra with Google Calendar via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to enable Mastra agents to securely query, read, and act on real-time data across 300+ enterprise sources no replication required.
-
Integrating LangChain with MariaDB via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on MariaDB within automated workflows.
-
How to publish and share Azure Analysis Services dashboards with Tableau Server
The CData ODBC driver for Azure Analysis Services enables you integrate Azure Analysis Services into Tableau dashboards.
-
Create Datasets from SendGrid in Domo Workbench and Build Visualizations of SendGrid in Domo
Use the CData Software ODBC Driver for SendGrid to create datasets from SendGrid in Domo Workbench and then build visualizations in the Domo service.
-
Connect to Office 365 in DBArtisan
Use wizards in DBArtisan to configure Microsoft Office 365 as a data source.
-
Validate RSS Feeds with QuerySurge
Access and validate RSS Feeds in QuerySurge using the CData JDBC Driver.
-
Build Zendesk Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Zendesk and build visualizations in Tableau.
-
Access Live Amazon Athena in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Amazon Athena from your Excel spreadsheets.
-
Automated Continuous Phoenix Replication to SingleStore
Use CData Sync for automated, continuous, customizable Phoenix replication to SingleStore.
-
Build a Simple VCL Application for HBase
How to build a simple VCL Application to view Apache HBase in RAD Studio using the CData ODBC Driver for HBase.
-
DataBind Controls to SAP Hybris C4C in C++Builder
DataBind to SAP Hybris C4C in C++Builder with standard components and controls.
-
Visualize Live Spark in the Power BI Service
Use CData Connect AI to connect to live Apache Spark SQL and create custom reports in the Power BI Service through the On-Premises Gateway.
-
How to Query Live SuiteCRM in Claude Desktop
Connect to and query live SuiteCRM in Claude Desktop using the CData MCP Server.
-
Connecting GenSpark with Facebook 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.
-
Build Freshdesk Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Freshdesk and build visualizations in Tableau.
-
Provide OData Services of Sage Cloud Accounting from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Sage Business Cloud Accounting by developing a WCF Service Application.
-
Connect to SAP ByDesign from PowerBuilder via JDBC
This article demonstrates how to access SAP Business ByDesign from PowerBuilder using the SAP ByDesign JDBC Driver.
-
Work with Avalara AvaTax in FoxPro
Load Avalara AvaTax into a FoxPro database. This article includes full code and a walk-through of the process.
-
Connect to ADP in RazorSQL
Connect to ADP from wizards and query ADP from the GUI in the RazorSQL database management tool.
-
Access Live Shippo in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Shippo into the statistical analysis tools available in SAS JMP. This article shows how to use Shippo in the Graph Builder and Query Builder.
-
Build Zoho Inventory Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Zoho Inventory and build visualizations in Tableau.
-
How to connect PolyBase to Coinbase
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Coinbase.
-
Query xBase using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume xBase entities in PHP by modeling them as objects.
-
Stream Zoho Projects into Apache Kafka Topics
Access and stream Zoho Projects in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
View Reports on Real-Time Sage Intacct in Power BI Report Server
Use the CData ODBC Driver for Sage Intacct to visualize Sage Intacct in Power BI Desktop and then publish them to Power BI Report Server.
-
Analyze Greenplum in Cognos Analytics
Use CData Connect AI to connect to Greenplum from Cognos Analytics and analyze live Pivotal GreenPlum.
-
Build MVC Applications with Connectivity to Coinbase
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Coinbase from an ASP.NET MVC application.
-
DataBind Controls to SingleStore in Delphi
DataBind to SingleStore in Delphi with standard data access components and controls.
-
Load Lakebase to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Lakebase to a database.
-
DataBind Tally to the DevExpress Data Grid
Use the CData Software ADO.NET Provider for Tally with the DevExpress Windows Forms and Web controls to provide Tally ERP to a chart.
-
Publish IBM Cloud Object Storage-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live IBM Cloud Object Storage.
-
How to connect SharePoint with XML through external lists
Provide XML Files to SharePoint users as an external list.
-
Analyze ADP in Looker
Use CData Connect AI to connect to ADP from Looker and build custom apps using live ADP.
-
Use Dash to Build to Web Apps on Adobe Commerce
Create Python applications that use pandas and Dash to build Adobe Commerce-connected web apps.
-
Integrate Hive with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Hive with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Apache Hive.
-
How to connect to Zendesk with Squirrel SQL client
Connect to Zendesk and execute queries in the Squirrel SQL Client.
-
Access Live Google Sheets in AWS Lambda (with IntelliJ IDEA)
Connect to live Google Sheets in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Process & Analyze Pipedrive in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Pipedrive .
-
Connect to Google Data Catalog in Google Apps Script via SQL Gateway
Use the ODBC Driver for Google Data Catalog and the SQL Gateway to access Google Data Catalog from Google Apps Script.
-
Build Google Sheets Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Google Sheets and build visualizations in Tableau.
-
Connect to PostgreSQL from AWS Glue
Use CData Connect AI to gain access to live PostgreSQL from your AWS Glue jobs.
-
DataBind Controls to FHIR in C++Builder
DataBind to FHIR in C++Builder with standard components and controls.
-
Query Sage 50 UK from Node.js
Use the OData endpoint of the CData API Server to connect to your Sage 50 UK and perform CRUD operations on Sage 50 UK from Node.js.
-
Analyze CockroachDB in Infragistics Reveal
Use the CData API Server to create an OData API on top of CockroachDB and visualize live CockroachDB in Infragistics Reveal.
-
Use the CData Software ODBC Driver for Oracle HCM Cloud in MicroStrategy
Connect to Oracle HCM Cloud in MicroStrategy Developer using the CData Software ODBC Driver for Oracle HCM Cloud.
-
How to Connect to IBM Informix in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to IBM Informix. Leverage the pyodbc module for ODBC in Python.
-
Automated Continuous Sybase IQ Replication to SQL Server
Use CData Sync for automated, continuous, customizable Sybase IQ replication to SQL Server.
-
Work with Neo4J in FoxPro
Load Neo4J into a FoxPro database. This article includes full code and a walk-through of the process.
-
Connect to JSON Services in Ruby
Connect to JSON in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Replicate IBM Cloud Object Storage in Heroku for Use in Salesforce Connect
Replicate IBM Cloud Object Storage to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Getting Started with the CData Python Connector for Oracle Eloqua Reporting
Learn to install and license the CData Python Connector
-
Query, Visualize, and Share live FHIR in Redash
Use CData Connect AI to connect to live FHIR in Redash for querying, visualizing, and sharing.
-
Creating Impala-Connected Applications in Unqork
You can use CData Connect AI to feed Apache Impala to Unqork and build custom business apps.
-
Connect to Zoho CRM from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Zoho CRM to connect to Zoho CRM and execute queries in PowerBuilder.
-
Natively Connect to OneNote in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Microsoft OneNote. Leverage the native support for ODBC in PHP.
-
Process & Analyze Basecamp in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Basecamp .
-
Build a Simple VCL Application for Azure Data Lake Storage
How to build a simple VCL Application to view Azure Data Lake Storage in RAD Studio using the CData ODBC Driver for Azure Data Lake Storage.
-
Connect to BambooHR in Google Apps Script via SQL Gateway
Use the ODBC Driver for BambooHR and the SQL Gateway to access BambooHR from Google Apps Script.
-
Connect to Google Contacts in DBeaver
Use the CData ODBC Driver to connect to Google Contacts in DBeaver.
-
Connect to Instagram in DBArtisan
Use wizards in DBArtisan to configure Instagram as a data source.
-
Viewing LinkedIn Ads in RAD Studio Data Explorer
How to view LinkedIn Ads in RAD Studio Data Explorer using the CData ODBC Driver for LinkedIn Ads.
-
Query Shopify as a SQL Server Database in Node.js
Execute SQL Server queries against Shopify from Node.js.
-
Integrate Sugar CRM into Automated Tasks with Power Automate
Use CData Connect AI to connect to Sugar CRM and integrate live Sugar CRM into your Power Automate tasks.
-
Connect to Adobe Analytics in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Query Klaviyo in DataGrip
Create a Data Source for Klaviyo in DataGrip and use SQL to query live Klaviyo.
-
Extend Google Sheets with Zuora
Make calls to the API Server from Google Apps Script.
-
How to Build an ETL App for Clio in Python with CData
Create ETL applications and real-time data pipelines for Clio in Python with petl.
-
Use the CData Software ODBC Driver for Adobe Analytics in MicroStrategy Desktop
Connect to Adobe Analytics in MicroStrategy Desktop using the CData Software ODBC Driver for Adobe Analytics.
-
Create Power BI Reports on Real-Time Workday
Use the CData ODBC Driver for Workday to visualize Workday in Power BI Desktop.
-
Connect to ADP as an External Source in Dremio
Use the CData JDBC Driver to connect to ADP as an External Source in Dremio.
-
Automated Continuous Greenplum Replication to Oracle
Use CData Sync for automated, continuous, customizable Greenplum replication to Oracle.
-
How to connect to Stripe from IntelliJ
Integrate connectivity to Stripe with wizards in IntelliJ.
-
Explore Geographical Relationships in SAP Netweaver Gateway with Power Map
Create data visualizations with SAP Netweaver Gateway in Power Map.
-
Import Real-Time Raisers Edge NXT via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Raisers Edge NXT in ColdFusion.
-
Access Live ShipStation in Coginiti Pro
Connect to and query live ShipStation from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Connect to SAS xpt in HULFT Integrate
Connect to SAS xpt as a JDBC data source in HULFT Integrate
-
Create SSAS Tabular Models from SFTP
How to build a SQL Server Analysis Service Tabular Model from SFTP using CData drivers.
-
Automated Continuous EventBrite Replication to Snowflake
Use CData Sync for automated, continuous, customizable EventBrite replication to Snowflake.
-
Automated Continuous QuickBooks Time Replication to Amazon S3
Use CData Sync for automated, continuous, customizable QuickBooks Time replication to Amazon S3.
-
Connect to Outreach.io in HULFT Integrate
Connect to Outreach.io as a JDBC data source in HULFT Integrate
-
How to Work with SharePoint Excel Services in ETL Validator JDBC
Connect to SharePoint Excel Services from ETL Validator jobs using the CData Software JDBC Driver.
-
Connect to Todoist as an External Source in Dremio
Use the CData JDBC Driver to connect to Todoist as an External Source in Dremio.
-
How to Access Azure Table Using Entity Framework
This article shows how to access Azure Table Storage using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Build Gmail Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Gmail and build visualizations in Tableau.
-
Integrate Cursor with Live Oracle Service Cloud Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Oracle Service Cloud from within the editor.
-
Access Live HarperDB in AWS Lambda (with IntelliJ IDEA)
Connect to live HarperDB in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Create a Data Access Object for xBase using JDBI
A brief overview of creating a SQL Object API for xBase in JDBI.
-
Getting Started with the CData Excel Add-In for Google Calendar
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Google Calendar.
-
Automated Continuous CockroachDB Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable CockroachDB replication to Apache Cassandra.
-
How to Connect to SingleStore in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to SingleStore. Leverage the pyodbc module for ODBC in Python.
-
Integrate with Zoho Creator in SnapLogic
Use CData Connect AI to connect to and integrate with live Zoho Creator in SnapLogic.