CData Software - Knowledge Base
Recent Articles
-
Use JayDeBeApi to access Salesforce Data 360 Data in Python
Use standard Python scripting and the development environment of your choice to access live Salesforce Data 360.
-
Integrating Cursor CLI with Vault CRM 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.
-
Build Azure DevOps Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Azure DevOps and build visualizations in Tableau Cloud.
-
How to connect to Qualaroo Data from Spring Boot
Connect to Qualaroo in a Spring Boot Application using the CData API Driver for JDBC
-
How to Query MYOB AccountRight Data in MySQL Workbench
Execute MySQL queries against live MYOB AccountRight from MySQL Workbench.
-
Connect to Clio Data in NetBeans
Connect to Clio in NetBeans with the data source configuration wizard.
-
Connect to Reply.io Data in Jaspersoft Studio
Execute SQL to remote Reply.io in Jaspersoft Studio.
-
How to Connect to Live Oracle HCM Cloud Data 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 Oracle HCM Cloud through natural language.
-
Visualize Smartsheet Data in Tableau
The CData ODBC driver for Smartsheet enables you integrate Smartsheet into Tableau dashboards.
-
Connect to and Query SAP SuccessFactors LMS Data in QlikView over ODBC
Create data visualizations with SAP SuccessFactors LMS in QlikView.
-
Visualize Sage 300 Data in Tableau
The CData ODBC driver for Sage 300 enables you integrate Sage 300 into Tableau dashboards.
-
How to Access Live OnePageCrm Data in Power Automate Desktop via ODBC
The CData ODBC Driver for OnePageCrm enables you to integrate OnePageCrm into workflows built using Microsoft Power Automate Desktop.
-
How to work with Elorus Data in Apache Spark using SQL
Access and process Elorus Data in Apache Spark using the CData Software JDBC Driver.
-
How to connect and process HelloSign from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live HelloSign.
-
Integrating Dataiku with Zuora Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Zuora.
-
Build MVC Applications with Connectivity to ShipStation Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access ShipStation from an ASP.NET MVC application.
-
Moving Data from Act-On to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Act-On data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Automated Continuous Sendwithus Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Sendwithus replication to delimited files (CSV/TSV).
-
Automated Continuous ActiveCampaign Replication to SingleStore
Use CData Sync for automated, continuous, customizable ActiveCampaign replication to SingleStore.
-
Create Datasets from SendGrid in Domo Workbench and Build Visualizations of SendGrid Data 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 Clockify Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Clockify in the Denodo Virtual DataPort Administrator.
-
Connect to Bright Data Data in CloverDX (formerly CloverETL)
Transfer Bright Data using the visual workflow in the CloverDX data integration tool.
-
Analyze CockroachDB Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze CockroachDB with the CData JDBC Driver for CockroachDB.
-
Integrate with Redis Data in JReport Designer
Create charts and reports based on Redis in JReport Designer.
-
Create Reports from Azure Analysis Services Data in Looker Studio
Use CData Connect AI to gain access to live Azure Analysis Services and create custom reports in Looker Studio.
-
Visualize Live SAP Fieldglass Data in the Power BI Service
Use CData Connect AI to connect to live SAP Fieldglass and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Create Data Visualizations in Cognos BI with Oracle SCM Data
Access Oracle SCM as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Connect to Splunk Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Splunk.
-
How to load LightSpeedRetail data into Elasticsearch via Logstash
Introducing a simple method to load LightSpeedRetail data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Access Live Asana Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Asana from your Excel spreadsheets.
-
Use ChatGPT to Talk to Your BigQuery 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 BigQuery for you.
-
Deploy the ADO.NET Provider for Pinecone on an SSRS Report Server
Connect to Pinecone 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.
-
Integrate CockroachDB Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live CockroachDB from Informatica Cloud.
-
Migrating data from Unbounce to Google BigQuery using CData SSIS Components.
Easily push Unbounce to Google BigQuery using the CData SSIS Tasks for Unbounce and Google BigQuery.
-
Create Reports from Cassandra Data in Looker Studio
Use CData Connect AI to gain access to live Apache Cassandra and create custom reports in Looker Studio.
-
How to Connect to Jodoo Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Jodoo. Leverage the pyodbc module for ODBC in Python.
-
ETL Dropbox in Oracle Data Integrator
This article shows how to transfer Dropbox into a data warehouse using Oracle Data Integrator.
-
Building Dynamic Web Pages with Sage 300 Data Using AngularJS
Create single-page applications with live connectivity to Sage 300 using the CData API Server.
-
Connect and Visualize Live NetSuite SuiteAnalytics Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live NetSuite SuiteAnalytics into the Databricks platform and create visualization dashboards with real-time NetSuite SuiteAnalytics.
-
Visualize Google Directory Data in Tableau
The CData ODBC driver for Google Directory enables you integrate Google Directory into Tableau dashboards.
-
Access eBay Analytics 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 eBay Analytics.
-
Validate Attio Data with QuerySurge
Access and validate Attio in QuerySurge using the CData JDBC Driver.
-
Create Informatica Mappings From/To an ODBC Data Source for Helpscout
Create an ODBC connection to Helpscout in Informatica and browse and transfer Helpscout.
-
Object-Relational Mapping (ORM) with Float 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 Float into a Java-based ORM framework, Hibernate.
-
Automated Continuous Quickbase Replication to Databricks
Use CData Sync for automated, continuous, customizable Quickbase replication to Databricks.
-
Load Microsoft Dataverse Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Microsoft Dataverse (CDS) to a database.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed Amazon DynamoDB to Power BI dashboards. Simply drag and drop Amazon DynamoDB into data visuals on the Power BI canvas.
-
Migrating data from NetSuite to Databricks using CData SSIS Components.
Easily push NetSuite CRM & ERP to Databricks using the CData SSIS Tasks for NetSuite and Databricks.
-
Integrate with Teamgate Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Teamgate to a JSON file on disk.
-
Publish Reports with Retently Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Retently.
-
Build Apps with Live SurveyMonkey Data Using the Low-Code Development Platform of Mendix
Connect SurveyMonkey with Mendix to build apps using the CData JDBC Driver for SurveyMonkey.
-
Query Helpscout Data as a MySQL Database in Node.js
Execute MySQL queries against Helpscout from Node.js.
-
How to load Cassandra data into Elasticsearch via Logstash
Introducing a simple method to load Cassandra data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Publish Crystal Reports on Cassandra Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Apache Cassandra.
-
Access Live Power BI XMLA Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Power BI XMLA in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Automated Continuous MySQL Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable MySQL replication to Apache Kafka.
-
Publish Outreach.io-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Outreach.io.
-
Back Up Cvent to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Cvent. In this article, we will employ an SSIS workflow to populate a database with Cvent data.
-
Getting Started with the CData Tableau Connector for Customer.io
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
How to Connect to ZohoDesk Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to ZohoDesk. Leverage the pyodbc module for ODBC in Python.
-
Integrate with live Microsoft Teams Data in Jitterbit
Use CData Connect AI to connect to and integrate live Microsoft Teams in Jitterbit.
-
Automated Continuous Google Forms Replication to SQL Server
Use CData Sync for automated, continuous, customizable Google Forms replication to SQL Server.
-
How to Work with NetSuite Data in ETL Validator JDBC
Connect to NetSuite from ETL Validator jobs using the CData Software JDBC Driver.
-
How to connect to NASA Data from Spring Boot
Connect to NASA in a Spring Boot Application using the CData API Driver for JDBC
-
Connect to Slack in SpagoBI
Create reports featuring live Slack in SpagoBI Studio. Host Slack reports on SpagoBI Server.
-
Edit and Search External Zoho Projects Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Zoho Projects to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Zoho Projects Data objects that you can access from apps and the dashboard.
-
Explore Geographical Relationships in Oracle Eloqua Data with Power Map
Create data visualizations with Oracle Eloqua in Power Map.
-
Connect and Query Live Bullhorn CRM Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Bullhorn CRM into Databricks
-
Automate ActiveCampaign Data Replication to Azure Data Lake
Use CData Sync to customize and automate ActiveCampaign replication to Azure Data Lake.
-
Integrating LlamaIndex with Google Contacts Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Google Contacts in real time.
-
Integrate Live Sage Cloud Accounting Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Sage Business Cloud Accounting and integrate live Sage Business Cloud Accounting into apps built in Microsoft Power Apps.
-
Connect to and Visualize Live NetSuite Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live NetSuite CRM & ERP.
-
Query Zoom Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Zoom from Node.js.
-
Getting Started with the CData Python Connector for Amazon Athena
Learn to install and license the CData Python Connector
-
Automate Microsoft Dataverse Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live Microsoft Dataverse (CDS) and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
How to work with PivotalTracker Data in Apache Spark using SQL
Access and process PivotalTracker Data in Apache Spark using the CData Software JDBC Driver.
-
DataBind Figshare Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Figshare to a chart.
-
Build a PostgreSQL Interface for Mouseflow Data using the CData JDBC Driver
Use the Remoting features of the Mouseflow JDBC Driver to create a PostgreSQL entry-point for data access.
-
Build Visualizations of Snapchat Ads Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Snapchat Ads in Birst.
-
Access eBay Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live eBay from HeidiSQL.
-
Connect to Sybase Data in RazorSQL
Connect to Sybase from wizards and query Sybase from the GUI in the RazorSQL database management tool.
-
Automated Continuous GetResponse Replication to Vertica
Use CData Sync for automated, continuous, customizable GetResponse replication to Vertica.
-
Connect to Amazon Marketplace Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Amazon Marketplace as an External Source in Dremio.
-
Automated Continuous ClickUp Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable ClickUp replication to Google BigQuery.
-
LINQ to MYOB AccountRight 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 MYOB AccountRight Data Provider.
-
Publish Outlook-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Outlook.
-
Integrating GitLab Data in Talend Cloud Data Management Platform
Connect GitLab Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
How to Build an ETL App for SAP Concur Data in Python with CData Connect AI
Build ETL pipelines that read and write live SAP Concur in Python with petl and the CData Connect AI Python SDK.
-
Access Twitter Ads Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Twitter Ads from your Oracle system.
-
Connect to and Visualize Live Ontraport Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Ontraport.
-
Excel Spreadsheet Automation on Azure DevOps Data with the QUERY Formula
Pull data from Azure DevOps, automate spreadsheets, and more with the QUERY formula.
-
Use Microsoft Copilot Studio to talk to your QuickBooks Online 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 QuickBooks Online for you.
-
Automated Continuous Pingdom Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Pingdom replication to Amazon S3.
-
Build Sage Cloud Accounting-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Sage Cloud Accounting Data from Zoho Analytics and import live Sage Business Cloud Accounting.
-
Create SSAS Tabular Models from Avro Data
How to build a SQL Server Analysis Service Tabular Model from Apache Avro using CData drivers.
-
Connect Anaplan to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Anaplan using the CData Python MCP Server.
-
How to Access Live ServiceDesk Plus Data in Power Automate Desktop via ODBC
The CData ODBC Driver for ServiceDesk Plus enables you to integrate ServiceDesk Plus into workflows built using Microsoft Power Automate Desktop.
-
How to Connect the Power BI Service to SAP HANA: Complete Guide
Connect to the CData Software Power BI Connector for SAP HANA from PowerBI.com to provide real-time SAP HANA across the organization.
-
Build Oracle Sales-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Oracle Sales Data from Zoho Analytics and import live Oracle Sales.
-
Automate Dynamics NAV Data Replication to Azure Synapse
Use CData Sync to customize and automate Microsoft Dynamics NAV replication to Azure Synapse.