CData Software - Knowledge Base
Recent Articles
-
Access Live Retently Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Retently into the statistical analysis tools available in SAS JMP. This article shows how to use Retently in the Graph Builder and Query Builder.
-
Visualize Live Monday.com Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Monday.com using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Visualize Live Microsoft Dataverse Data in the Power BI Service
Use CData Connect AI to connect to live Microsoft Dataverse (CDS) and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Create SSAS Tabular Models from Exact Online Data
How to build a SQL Server Analysis Service Tabular Model from Exact Online using CData drivers.
-
Connect to and Visualize Live Bright Data Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Bright Data.
-
Getting Started with the CData JDBC Driver for Cohere
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Cohere.
-
Connect to SAP SuccessFactors Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Natively Connect to ZohoDesk Data in PHP
The CData ODBC driver for ZohoDesk enables you to create PHP applications with connectivity to ZohoDesk. Leverage the native support for ODBC in PHP.
-
How to import Clockify Data into Apache Solr
Use the CData Software JDBC Driver for Clockify in Data Import Handler and create an automated import of Clockify to Apache Solr Enterprise Search platform.
-
Create Informatica Mappings From/To an ODBC Data Source for Smartsheet
Create an ODBC connection to Smartsheet in Informatica and browse and transfer Smartsheet.
-
Getting Started with the CData Excel Add-In for Reckon
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Reckon.
-
Choosing the Best Method to Connect Nethunt to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Nethunt from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Access Live Microsoft Planner Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Microsoft Planner into the statistical analysis tools available in SAS JMP. This article shows how to use Microsoft Planner in the Graph Builder and Query Builder.
-
How to Connect to Live Freshdesk Data from crewAI Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable crewAI agents to securely read and take actions on your Freshdesk for you.
-
Object-Relational Mapping (ORM) with OpenWeatherMap 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 OpenWeatherMap into a Java-based ORM framework, Hibernate.
-
Query ElevenLabs Data through ODBC in Node.js
Use node-odbc to execute SQL queries against ElevenLabs from Node.js.
-
Connect to Live Oracle Eloqua Data in MicroStrategy through CData Connect AI
Create a live connection to Oracle Eloqua Data in CData Connect AI and connect to your Oracle Eloqua from MicroStrategy.
-
Connect SurveyMonkey to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect SurveyMonkey with IBM WebSphere for seamless data integration and connectivity.
-
Use the CData Software ODBC Driver for Teamwork in MicroStrategy Web
Connect to Teamwork in MicroStrategy Web using the CData Software ODBC Driver for Teamwork.
-
Connect to Real-Time FHIR Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for FHIR and Dataflow to import and use FHIR in Power Apps.
-
Import Adobe Analytics Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Adobe Analytics Data and provide access to live Adobe Analytics for custom reports in the Power BI Service.
-
Connect to Wrike Data in RazorSQL
Connect to Wrike from wizards and query Wrike from the GUI in the RazorSQL database management tool.
-
Visualize Live Moosend Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Moosend.
-
Connect and Visualize Live SAP SuccessFactors Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live SAP SuccessFactors into the Databricks platform and create visualization dashboards with real-time SAP SuccessFactors.
-
How to connect to IBM Cloud Object Storage Data from Spring Boot
Connect to IBM Cloud Object Storage in a Spring Boot Application using the CData JDBC Driver for IBM Cloud Object Storage
-
Easily Integrate FormSite Data in Lazarus Pascal IDE
Learn how to easily integrate live FormSite in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Build Dynamics 365 Business Central-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Dynamics 365 Business Central Data and create custom apps in Bubble.
-
Connecting Agentforce with Blackbaud FE NXT 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 Blackbaud FE NXT for you.
-
Access Live Salesforce Pardot Data in Coginiti Pro
Connect to and query live Salesforce Pardot from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Trigger Google Ad Manager IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for Google Ad Manager with standard wizards in Logic Apps.
-
Seamlessly Bring JSON Services into Retool Using CData Connect AI
Integrate JSON data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Access Live Klaviyo Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Klaviyo from your Google Sheets.
-
Access Live ZendeskSell Data in Coginiti Pro
Connect to and query live ZendeskSell from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
How to integrate CockroachDB with Apache Airflow
Access and process CockroachDB in Apache Airflow using the CData JDBC Driver.
-
Automated Continuous NetSuite SuiteAnalytics Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable NetSuite SuiteAnalytics replication to Apache Cassandra.
-
Access PhantomBuster Data from MySQL in Amazon QuickSight
Connect to PhantomBuster and build visualizations of PhantomBuster using a MySQL Connection in Amazon QuickSight.
-
View Reports on Real-Time SFTP Data in Power BI Report Server
Use the CData ODBC Driver for SFTP to visualize SFTP in Power BI Desktop and then publish them to Power BI Report Server.
-
Integrate Kafka with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Kafka with External Services.
-
How to connect SharePoint with DB2 Data through external lists
Provide IBM DB2 to SharePoint users as an external list.
-
Connect to Twitter Ads Data in JRuby
Create a simple JRuby app with access to live Twitter Ads.
-
Build a PostgreSQL Interface for ChartMogul Data using the CData JDBC Driver
Use the Remoting features of the ChartMogul JDBC Driver to create a PostgreSQL entry-point for data access.
-
Build Agents in Relevance AI with Access to Live Facebook Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Facebook within intelligent agent workflows.
-
How to Connect to Kintone Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Kintone. Leverage the pyodbc module for ODBC in Python.
-
How to work with Avalara AvaTax Data in Apache Spark using SQL
Access and process Avalara AvaTax Data in Apache Spark using the CData Software JDBC Driver.
-
How to Connect to Instantly Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Instantly. Leverage the pyodbc module for ODBC in Python.
-
How to connect to Sage Intacct Data with Squirrel SQL client
Connect to Sage Intacct and execute queries in the Squirrel SQL Client.
-
How to Connect to Suadeo Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Suadeo. Leverage the pyodbc module for ODBC in Python.
-
Migrating data from Smartsheet to Snowflake using CData SSIS Components.
Easily push Smartsheet to Snowflake using the CData SSIS Tasks for Smartsheet and Snowflake.
-
Build Cosmos DB-Powered Applications in Claude Code with CData MCP Server
Use the CData MCP Server for Cosmos DB to explore live Cosmos DB Data in Claude Code to assist with building Cosmos DB-powered applications.
-
Integrating Gumloop with Oracle Eloqua Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Oracle Eloqua within automated workflows.
-
How to Easily Query Klaviyo Data in OpenOffice Base
Connect to Klaviyo data in OpenOffice Base using the CData ODBC Driver for Klaviyo and generate reports with live data insights.
-
Integrate Blackbaud FE NXT Data into Power Automate Desktop using CData Connect
CData Connect for Blackbaud FE NXT Data enables you to integrate Blackbaud FE NXT into workflows built using Microsoft Power Automate Desktop.
-
Create Power BI Reports on Real-Time Strava Data
Use the CData ODBC Driver for Strava to visualize Strava in Power BI Desktop.
-
Bridge Pipeline CRM Connectivity with Apache NiFi
Access and process Pipeline CRM in Apache NiFi using the CData JDBC Driver.
-
Connect to and Visualize Live HelloSign Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live HelloSign.
-
Build Dashboards with Copper Data in Dundas BI
Create dynamic dashboards and perform analytics based on Copper in Dundas BI.
-
Connecting GenSpark with SAP Business One Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to SAP Business One without any replication or custom integration required.
-
Automated Continuous PabblySubscriptions Replication to SingleStore
Use CData Sync for automated, continuous, customizable PabblySubscriptions replication to SingleStore.
-
Process & Analyze Sage 300 Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Sage 300 Data.
-
Getting Started with the CData ODBC Driver for Moosend
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Moosend.
-
Edit and Search Zendesk External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of Zendesk to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create Zendesk objects that you can access from apps and the dashboard.
-
Use the CData Software JDBC Driver for Highrise in MicroStrategy
Connect to Highrise CRM in MicroStrategy Developer using the CData Software JDBC Driver for Highrise.
-
Automated Continuous Moosend Replication to SQLite
Use CData Sync for automated, continuous, customizable Moosend replication to SQLite.
-
Working with Zuora Data in LINQPad
Execute LINQ queries to Zuora in LINQPad.
-
Query Aweber Data in ColdFusion
Write standard ColdFusion data access code to connect to Aweber.
-
Enable the Azure Synapse JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Azure Synapse.
-
Moving Data from FreshBooks to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live FreshBooks data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Build Apps with Live Oracle Eloqua Data Using the Low-Code Development Platform of Mendix
Connect Oracle Eloqua with Mendix to build apps using the CData JDBC Driver for Oracle Eloqua.
-
Connect to Epicor Kinetic Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Epicor Kinetic and the SQL Gateway to access Epicor Kinetic from Google Apps Script.
-
Build AI Agents with Procore Data in IBM watsonx Orchestrate using CData Connect AI
Learn how to build intelligent agents in IBM watsonx Orchestrate that can securely access and act on live Procore through CData Connect AI.
-
Replicate QuickBooks Online Data from PowerShell
Write a quick PowerShell script to query QuickBooks Online. Use connectivity to the live data to replicate QuickBooks Online to SQL Server.
-
Object-Relational Mapping (ORM) with ClickTime 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 ClickTime into a Java-based ORM framework, Hibernate.
-
Create Reports with Zuora Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Zuora.
-
Getting Started with the CData Python Connector for Wrike
Learn to install and license the CData Python Connector
-
Analyze Salesforce Marketing Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Salesforce Marketing Cloud and visualize live Salesforce Marketing Cloud in Infragistics Reveal.
-
Automated Continuous MarkLogic Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable MarkLogic replication to Amazon Redshift.
-
Build Visualizations of SAP Hybris C4C Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of SAP Hybris C4C in Birst.
-
Integrate with Pinecone Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Pinecone to a JSON file on disk.
-
Analyze Zuora Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Zuora from Power Pivot. You will use the Table Import Wizard to load Zuora. You can visually build the import query or use any SQL supported by the driver.
-
Create Google Cloud Storage Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Google Cloud Storage from PowerBI.com to create Power BI Dataflows with real-time data.
-
Design BIRT Reports on SAP SuccessFactors Data
Provide current SAP SuccessFactors to your embedded analytics.
-
Connect to Mode Data in RapidMiner
Integrate Mode with standard components and data source configuration wizards in RapidMiner Studio.
-
How to connect to Dropbox Data with Squirrel SQL client
Connect to Dropbox and execute queries in the Squirrel SQL Client.
-
How to Build an ETL App for BenchmarkEmail Data in Python with CData
Create ETL applications and real-time data pipelines for BenchmarkEmail in Python with petl.
-
Moving Data from Gorgias to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Gorgias data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Connect to and Visualize Live Telegram Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Telegram.
-
Integrate with Live Shopify Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Shopify from the MuleSoft Anypoint Platform to integrate live Shopify into custom reports and dashboards.
-
How to Query Live Azure DevOps Data in Claude Desktop
Connect to and query live Azure DevOps Data in Claude Desktop using CData MCP Server.
-
How to Create Power BI Visual Reports with Real-Time PolarTeamPro Data
Use CData Power BI Connectors to visualize PolarTeamPro in Power BI.
-
Getting Started with the CData Excel Add-In for Teamgate
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Teamgate.
-
How to Query Live Wave Financial Data in Claude Desktop
Connect to and query live Wave Financial Data in Claude Desktop using CData MCP Server.
-
Connecting Moonlit Workflow with Jira 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 Atlassian Jira in real time.
-
Connect to eBay Analytics Data in HULFT Integrate
Connect to eBay Analytics as a JDBC data source in HULFT Integrate
-
Build a PostgreSQL Interface for Nethunt Data using the CData JDBC Driver
Use the Remoting features of the Nethunt JDBC Driver to create a PostgreSQL entry-point for data access.
-
Work with Certinia Data in FoxPro
Load Certinia into a FoxPro database. This article includes full code and a walk-through of the process.
-
Use the CData ODBC Driver for ShipStation from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for ShipStation to connect to ShipStation from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring ShipStation in Excel.
-
Create Informatica Mappings From/To an ODBC Data Source for PagerDuty
Create an ODBC connection to PagerDuty in Informatica and browse and transfer PagerDuty.
-
Publish Google Spanner-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Google Spanner.
-
How to Query Live xBase Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live xBase data in natural language using Python.
-
Feed Splunk Data into FineReport
How to set Splunk as a JDBC data source in FineReport.