CData Software - Knowledge Base
Recent Articles
-
Connect to OnePageCrm Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for OnePageCrm to connect to OnePageCrm and execute queries in PowerBuilder.
-
Zoho Books Reporting in OBIEE with the Zoho Books JDBC Driver
Deploy the Zoho Books JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
How to Work with Stripe Data in AWS Glue Jobs Using JDBC
Connect to Stripe from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
How to Connect to Coinbase Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Coinbase. Leverage the pyodbc module for ODBC in Python.
-
Integrate Google Sheets Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Google Sheets and integrate live Google Sheets into your Power Automate tasks.
-
Migrating data from Greenplum to Databricks using CData SSIS Components.
Easily push Pivotal GreenPlum to Databricks using the CData SSIS Tasks for Greenplum and Databricks.
-
Connect to Active Directory Data from AWS Glue
Use CData Connect AI to gain access to live Active Directory from your AWS Glue jobs.
-
Connect to Amazon S3 Data in Aqua Data Studio
Access Amazon S3 from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Edit and Search Microsoft Dataverse External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of Microsoft Dataverse (CDS) to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create Microsoft Dataverse objects that you can access from apps and the dashboard.
-
Build AI/ML Models with Live Helpscout Data using Dataiku
Connect Helpscout Data with Dataiku using the CData API Driver for JDBC.
-
How to Query Live Airtable Data in Perplexity MacOS Desktop
Connect to and query live Airtable Data in Perplexity Desktop using CData MCP Server.
-
ETL Nuclia in Oracle Data Integrator
This article shows how to transfer Nuclia into a data warehouse using Oracle Data Integrator.
-
Integrating Claude Code CLI with Google Campaign Manager 360 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.
-
Getting Started with the CData Connect AI Python SDK for Greenhouse
Install the CData Connect AI Python SDK to read and write live Greenhouse with standard DB-API 2.0 Python code.
-
Stream Avaza Data into Apache Kafka Topics
Access and stream Avaza in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Access Email Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Email from your Oracle system.
-
Connect to Zoom from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Zoom, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Publish Crystal Reports on Kintone Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Kintone.
-
Avro Reporting in OBIEE with the Avro JDBC Driver
Deploy the Avro JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Connecting Pipedream with Sybase IQ Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Pipedream workflows to securely read and take actions on Sybase IQ data in real time.
-
Automated Continuous Front Replication to SQL Server
Use CData Sync for automated, continuous, customizable Front replication to SQL Server.
-
Access Live ServiceNow Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live ServiceNow from your Google Sheets.
-
Natively Connect to Access Data in PHP
The CData ODBC driver for Access enables you to create PHP applications with connectivity to Microsoft Access. Leverage the native support for ODBC in PHP.
-
Create Oracle SCM Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Oracle SCM from PowerBI.com to create Power BI Dataflows with real-time data.
-
Automated Continuous Power BI XMLA Replication to SQLite
Use CData Sync for automated, continuous, customizable Power BI XMLA replication to SQLite.
-
Use the CData Software JDBC Driver for HubSpot in MicroStrategy Desktop
Connect to HubSpot in MicroStrategy Desktop using the CData Software JDBC Driver for HubSpot.
-
How to Connect to & Open Shopify Data in Microsoft Excel
This article uses the CData ODBC driver for Shopify to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
How to connect to Salesloft Data from Spring Boot
Connect to Salesloft in a Spring Boot Application using the CData JDBC Driver for Salesloft
-
Connect to Guru Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Guru to connect to Guru and execute queries in PowerBuilder.
-
Analyze SAP SuccessFactors Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of SAP SuccessFactors and visualize live SAP SuccessFactors in Infragistics Reveal.
-
How to integrate Square with Apache Airflow
Access and process Square in Apache Airflow using the CData JDBC Driver.
-
Replicate Multiple Authorize.Net Accounts
Replicate multiple Authorize.Net accounts to one or many databases.
-
Feed Discord Data into FineReport
How to set Discord as a JDBC data source in FineReport.
-
Create Apps from Certinia Data in Qlik Sense Cloud
Use CData Connect AI to connect to Certinia Data and build apps from live Certinia in Qlik Sense Cloud.
-
Getting Started with the CData Tableau Connector for REST
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for REST.
-
Use the CData Software ODBC Driver for QuickBooks Time in MicroStrategy Web
Connect to QuickBooks Time in MicroStrategy Web using the CData Software ODBC Driver for QuickBooks Time.
-
Publish Acumatica-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Acumatica ERP.
-
Connecting Moonlit Workflow with Instagram Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Moonlit workflows to securely read and act on your Instagram in real time.
-
Import SAP HANA XS Advanced Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access SAP HANA XS Advanced. In this article, you will use the OData format to import SAP HANA XS Advanced into Microsoft Power Query.
-
Integrating Boomi Agentstudio with Azure Data Lake Storage Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Azure Data Lake Storage, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Integrate ScrapingBee Data in the Pentaho Report Designer
Publish reports based on ScrapingBee in the Pentaho BI tool.
-
Use the CData Software JDBC Driver for Teamgate in MicroStrategy Desktop
Connect to Teamgate in MicroStrategy Desktop using the CData Software JDBC Driver for Teamgate.
-
How to use SQLAlchemy ORM to access LDAP Objects in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of LDAP.
-
How to Connect DBeaver to Bullhorn CRM via a JDBC Driver
Manage Bullhorn CRM with visual tools in DBeaver like the query browser.
-
Use Dash to Build to Web Apps on Blackbaud FE NXT Data
Create Python applications that use pandas and Dash to build Blackbaud FE NXT-connected web apps.
-
Integrate with Kafka Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Apache Kafka to a JSON file on disk.
-
Connect to Avro Data from a Connection Pool in Jetty
The Avro JDBC Driver supports connection pooling: This article shows how to connect faster to Apache Avro from Web apps in Jetty.
-
Replicate Salesforce CRM Analytics Data to Multiple Databases
Replicate Salesforce CRM Analytics to disparate databases with a point-and-click configuration.
-
Use the CData Software JDBC Driver for Certinia in MicroStrategy
Connect to Certinia in MicroStrategy Developer using the CData Software JDBC Driver for Certinia.
-
Viewing Discourse Data in RAD Studio Data Explorer
How to view Discourse in RAD Studio Data Explorer using the CData ODBC Driver for Discourse.
-
Bridge SQL Server Connectivity with Apache NiFi
Access and process Microsoft SQL Server in Apache NiFi using the CData JDBC Driver.
-
Operational Reporting on Gong Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Gong.
-
Build a Simple VCL Application for SAP BusinessObjects BI Data
How to build a simple VCL Application to view SAP BusinessObjects BI in RAD Studio using the CData ODBC Driver for SAP BusinessObjects BI.
-
Build Dashboards with SQL Analysis Services Data in DBxtra
Create dynamic dashboards and perform analytics based on SQL Analysis Services in DBxtra.
-
Choosing the Best Method to Connect Acumatica to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Acumatica ERP from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Analyze Live NetSuite Data in SAS Viya
Use CData Connect AI to connect to NetSuite CRM & ERP from SAS Viya and deploy self-service analytics using live NetSuite CRM & ERP.
-
Integrate Live Amplitude Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Amplitude to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Operational Reporting on Autopilot Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Autopilot.
-
How to publish and share Front Data dashboards with Tableau Server
The CData ODBC driver for Front enables you integrate Front into Tableau dashboards.
-
Create Data Visualizations Based On HubSpot Data in Mode
Use CData Connect AI to connect to HubSpot Data from Mode and build visualizations using live
-
Build a Singer.io Tap for PostgreSQL With the CData Python Connector
Learn how to easily build a Singer.io Tap for live PostgreSQL data using
-
How to load HCL Domino data into Elasticsearch via Logstash
Introducing a simple method to load HCL Domino data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Write a Simple Go Application to work with NetSuite Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to NetSuite CRM & ERP.
-
DataBind Controls to FreshBooks Data in C++Builder
DataBind to FreshBooks in C++Builder with standard components and controls.
-
Publish Crystal Reports on Blackbaud FE NXT Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Blackbaud FE NXT.
-
Excel Spreadsheet Automation on Tally Data with the QUERY Formula
Pull data from Tally, automate spreadsheets, and more with the QUERY formula.
-
Automated Continuous Oracle Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Oracle replication to Amazon Redshift.
-
Prepare, Blend, and Analyze HelloSign Data in Alteryx Designer (ODBC)
Build workflows to access live HelloSign for self-service data analytics.
-
Connect to YouTube Analytics from a Connection Pool in WebLogic
Use the CData JDBC Driver for YouTube Analytics to connect to YouTube Analytics from Web applications running on WebLogic.
-
Connect to ZarMoney Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for ZarMoney.
-
Build Semantic Layer Views for CouchDB Data in APOS Live Data Gateway
Use the CData Connector for CouchDB in APOS Live Data Gateway to build Semantic Layer Views for Apache CouchDB.
-
How to Connect to Live Quickbase 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 Quickbase for you.
-
Integrate Live Tally Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf
-
Migrating data from SpaceX to Google BigQuery using CData SSIS Components.
Easily push SpaceX to Google BigQuery using the CData SSIS Tasks for SpaceX and Google BigQuery.
-
Create Informatica Mappings From/To an ODBC Data Source for Outreach.io
Create an ODBC connection to Outreach.io in Informatica and browse and transfer Outreach.io.
-
Connecting Agentforce with Zoho Creator 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 Zoho Creator for you.
-
Deploy the ADO.NET Provider for SAP Hybris C4C on an SSRS Report Server
Connect to SAP Hybris C4C 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.
-
Getting Started with the CData Excel Add-In for Outlook
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Outlook.
-
Publish Reports with Grafana Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Grafana.
-
Replicate Multiple Salesforce Marketing Accounts
Replicate multiple Salesforce Marketing accounts to one or many databases.
-
Getting Started with the CData JDBC Driver for ZohoPeople
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for ZohoPeople.
-
Design BIRT Reports on Google Search Results
Provide current Google Search to your embedded analytics.
-
How to Seamlessly Import SAP HANA Data into IBM SPSS Modeler
Integrate SAP HANA data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Build a Singer.io Tap for Kintone With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Kintone data using
-
Use JayDeBeApi to access HubDB Data in Python
Use standard Python scripting and the development environment of your choice to access live HubDB.
-
Visualize Live CampaignMonitor Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live CampaignMonitor.
-
Integrate Theia IDE with Live Freshdesk Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE
-
Connect to Live Workday Data in MicroStrategy through CData Connect AI
Create a live connection to Workday Data in CData Connect AI and connect to your Workday from MicroStrategy.
-
Perform Batch Operations with NetSuite Data in Apache NiFi
Connect to NetSuite CRM & ERP and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Integrate Real-Time Access to Sage Cloud Accounting in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Sage Business Cloud Accounting in real time.
-
Connect to Workday Data in NetBeans
Connect to Workday in NetBeans with the data source configuration wizard.
-
Integrating HCL Domino Data in Talend Cloud Data Management Platform
Connect HCL Domino Data with Talend Cloud Data Management Platform using the CData JDBC Driver for HCL Domino.
-
Automated Continuous Impala Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Impala replication to Google BigQuery.
-
Integrate Facebook with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Facebook with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Facebook.
-
Migrating data from Microsoft Exchange to Snowflake using CData SSIS Components.
Easily push Microsoft Exchange to Snowflake using the CData SSIS Tasks for Microsoft Exchange and Snowflake.
-
Use the CData Software JDBC Driver for Google Campaign Manager 360 in MicroStrategy Web
Connect to Google Campaign Manager 360 in MicroStrategy Web using the CData Software JDBC Driver for Google Campaign Manager 360.
-
Connect to Shippo Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Connect to Salesforce CRM Analytics Data 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 Salesforce CRM Analytics.
-
How to import Certinia Data into Apache Solr
Use the CData Software JDBC Driver for Certinia in Data Import Handler and create an automated import of Certinia to Apache Solr Enterprise Search platform.
-
How to Create Power BI Visual Reports with Real-Time SAP Netweaver Gateway Data
Use CData Power BI Connectors to visualize SAP Netweaver Gateway in Power BI.