CData Software - Knowledge Base
Recent Articles
-
Connect to Smartsheet from Asprova with CData Software ODBC Driver for Smartsheet
This article shows how to connect faster to Smartsheet data from Asprova.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed Raisers Edge NXT to Power BI dashboards. Simply drag and drop Raisers Edge NXT into data visuals on the Power BI canvas.
-
Use the CData Software ODBC Driver for ZohoMarketingHub in MicroStrategy Web
Connect to ZohoMarketingHub in MicroStrategy Web using the CData Software ODBC Driver for ZohoMarketingHub.
-
Create Dashboards and Visualize Live Spark Data in Geckoboard
Use CData Connect AI to connect to live Apache Spark SQL and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Create Apps from Workday Data in Qlik Sense Cloud
Use CData Connect AI to connect to Workday Data and build apps from live Workday in Qlik Sense Cloud.
-
Automated Continuous SAP Ariba Procurement Replication to MongoDB
Use CData Sync for automated, continuous, customizable SAP Ariba Procurement replication to MongoDB.
-
How to Build an ETL App for Pingdom Data in Python with CData
Create ETL applications and real-time data pipelines for Pingdom in Python with petl.
-
Build Productboard-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Productboard and build web apps with connectivity to live Productboard.
-
ETL Kintone in Oracle Data Integrator
This article shows how to transfer Kintone into a data warehouse using Oracle Data Integrator.
-
How to Easily Query Azure Synapse Data in OpenOffice Base
Connect to Azure Synapse data in OpenOffice Base using the CData ODBC Driver for Azure Synapse and generate reports with live data insights.
-
Build Zoho Projects-Powered Applications in Cursor with CData MCP Server
Use the CData MCP Server for Zoho Projects to explore live Zoho Projects Data in Cursor to assist with building Zoho Projects-powered applications.
-
Visualize Spark Data in Tableau
The CData ODBC driver for Spark enables you integrate Apache Spark SQL into Tableau dashboards.
-
Integrate with Coinbase Data in JReport Designer
Create charts and reports based on Coinbase in JReport Designer.
-
DataBind Freshteam Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Freshteam to a chart.
-
Automated Continuous Aweber Replication to SQL Server
Use CData Sync for automated, continuous, customizable Aweber replication to SQL Server.
-
DataBind Controls to BambooHR Data in Delphi
DataBind to BambooHR in Delphi with standard data access components and controls.
-
Automate SAS xpt Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live SAS XPORT and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
Connect Raisers Edge NXT to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Raisers Edge NXT using the CData Python MCP Server.
-
Integrate Live Pipedrive Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Pipedrive from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Pipedrive.
-
Getting Started with the CData Excel Add-In for Shippo
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Shippo.
-
Access Live MYOB AccountRight Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate MYOB AccountRight into the statistical analysis tools available in SAS JMP. This article shows how to use MYOB AccountRight in the Graph Builder and Query Builder.
-
Configure the CData JDBC Driver for Superchat in a Connection Pool in Tomcat
Connect to Superchat from a connection pool in Tomcat.
-
Query Live Oracle Service Cloud Data in Zed Editor via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Zed Editor to securely access and query live Oracle Service Cloud directly from the development environment.
-
Build SAP BusinessObjects BI-Powered Applications in Cursor with CData MCP Server
Use the CData MCP Server for SAP BusinessObjects BI to explore live SAP BusinessObjects BI Data in Cursor to assist with building SAP BusinessObjects BI-powered applications.
-
Create a Data Access Object for Supabase Data using JDBI
A brief overview of creating a SQL Object API for Supabase in JDBI.
-
Connect Oracle Sales to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Oracle Sales using the CData Python MCP Server.
-
How to connect to Suadeo Data from IntelliJ
Integrate connectivity to Suadeo with wizards in IntelliJ.
-
Natively Connect to Trello Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Trello. Leverage the native support for ODBC in PHP.
-
Connect to Rootly Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Rootly and the SQL Gateway to access Rootly from Google Apps Script.
-
Feed Hugging Face Data into FineReport
How to set Hugging Face as a JDBC data source in FineReport.
-
Connecting GenSpark with FreshBooks Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to FreshBooks without any replication or custom integration required.
-
Connecting Agentforce with Acumatica 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 Acumatica ERP for you.
-
How to Query Live Spark Data in Claude Desktop
Connect to and query live Spark Data in Claude Desktop using CData MCP Server.
-
DataBind MailChimp Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for MailChimp with the DevExpress Windows Forms and Web controls to provide MailChimp to a chart.
-
Automated Continuous Oracle Eloqua Reporting Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Oracle Eloqua Reporting replication to Amazon S3.
-
Create Data Visualizations in Cognos BI with Mouseflow Data
Access Mouseflow as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Migrating data from Google Drive to Google BigQuery using CData SSIS Components.
Easily push Google Drive to Google BigQuery using the CData SSIS Tasks for Google Drive and Google BigQuery.
-
Publish GetResponse-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live GetResponse.
-
Provide OData Services of ClickUp Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for ClickUp by developing a WCF Service Application.
-
Deploy the ADO.NET Provider for Instantly on an SSRS Report Server
Connect to Instantly 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.
-
Connect to Gorgias from a Connection Pool in WebLogic
Use the CData JDBC Driver for Gorgias to connect to Gorgias from Web applications running on WebLogic.
-
Create Data Visualizations in Cognos BI with FTP Data
Access FTP Servers as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Access Basecamp Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Basecamp from your Oracle system.
-
Automated Continuous Aircall Replication to MongoDB
Use CData Sync for automated, continuous, customizable Aircall replication to MongoDB.
-
Back Up Demio to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData API Driver for ADO.NET. In this article, we will employ an SSIS workflow to populate a database with Demio data.
-
Build Google Campaign Manager 360 Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Google Campaign Manager 360 and build visualizations in Tableau.
-
Integrating Codex CLI with Billsby 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.
-
Use JayDeBeApi to access WooCommerce Data in Python
Use standard Python scripting and the development environment of your choice to access live WooCommerce.
-
Getting Started with the CData Python Connector for Azure Table
Learn to install and license the CData Python Connector
-
Easily Integrate Jodoo Data in Lazarus Pascal IDE
Learn how to easily integrate live Jodoo in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Replicate Parquet Data from PowerShell
Write a quick PowerShell script to query Apache Parquet. Use connectivity to the live data to replicate Apache Parquet to SQL Server.
-
Create SSAS Tabular Models from Lakebase Data
How to build a SQL Server Analysis Service Tabular Model from Lakebase using CData drivers.
-
Access Live Salesforce Pardot Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Salesforce Pardot from your Google Sheets.
-
Use Biml to Build SSIS Tasks to Replicate PivotalTracker Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate PivotalTracker to SQL Server.
-
How to connect and process Salesforce Marketing Cloud from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Salesforce Marketing Cloud.
-
Publish Reports with ZohoMarketingHub Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date ZohoMarketingHub.
-
Connect to Instantly Data in DBArtisan
Use wizards in DBArtisan to configure Instantly as a data source.
-
Load HDFS Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Apache HDFS to a database.
-
Access Google Translate 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 Google Translate.
-
Query Cassandra Data in ColdFusion
Write standard ColdFusion data access code to connect to Apache Cassandra.
-
Access Live SAP SuccessFactors LMS Data in Excel 365 Online (Excel for the web)
Connect to SAP SuccessFactors LMS from Excel 365 Online (Excel for the web) with CData Connect AI.
-
View Reports on Real-Time Sentry Data in Power BI Report Server
Use the CData ODBC Driver for Sentry to visualize Sentry in Power BI Desktop and then publish them to Power BI Report Server.
-
How to connect to ConvertAPI Data in DBVisualizer
Integrate ConvertAPI with visual data analysis tools and data connection wizards in DBVisualizer
-
Connecting Pipedream with Redshift 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 Redshift data in real time.
-
Visualize Live Wrike Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Wrike using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Connect to Spark 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 Apache Spark SQL.
-
Connect to PabblySubscriptions Data in Ruby
Connect to PabblySubscriptions in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Connect to SendGrid from a Connection Pool in WebLogic
Use the CData JDBC Driver for SendGrid to connect to SendGrid from Web applications running on WebLogic.
-
Automated Continuous Sage Intacct Replication to MongoDB
Use CData Sync for automated, continuous, customizable Sage Intacct replication to MongoDB.
-
How to Query HBase Data in MySQL Workbench
Execute MySQL queries against live Apache HBase from MySQL Workbench.
-
Build Agents in Relevance AI with Access to Live WooCommerce Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on WooCommerce within intelligent agent workflows.
-
Integrating Microsoft Planner Data in Talend Cloud Data Management Platform
Connect Microsoft Planner Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Microsoft Planner.
-
Connect and Query Live IBM Informix Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live IBM Informix into Databricks
-
How to Create Power BI Visual Reports with Real-Time JobNimbus Data
Use CData Power BI Connectors to visualize JobNimbus in Power BI.
-
Visualize Live BambooHR Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live BambooHR using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
How to Create Power BI Visual Reports with Real-Time Shortcut Data
Use CData Power BI Connectors to visualize Shortcut in Power BI.
-
Analyze Okta Data in Infragistics Reveal
Use the CData API Server to create an OData API on top of Okta and visualize live Okta in Infragistics Reveal.
-
Publish Reports with Salesforce CRM Analytics Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Salesforce CRM Analytics.
-
Integrate with HubSpot Data in SnapLogic
Use CData Connect AI to connect to and integrate with live HubSpot in SnapLogic.
-
Create Power BI Reports on Real-Time Campaigner Data
Use the CData ODBC Driver for Campaigner to visualize Campaigner in Power BI Desktop.
-
How to Access Live Mixpanel Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Mixpanel enables you to integrate Mixpanel into workflows built using Microsoft Power Automate Desktop.
-
Connect to Vimeo Data from PowerBuilder via ADO.NET
This article demonstrates how to access Vimeo from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Connecting Moonlit Workflow with Twitter Ads 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 Twitter Ads in real time.
-
Integrate Cline with Live Jira Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Atlassian Jira from within your IDE.
-
Use the CData API Server to Access ADP Data in Microsoft PowerPivot
Use the CData API Server to connect to live ADP in the Power Pivot business intelligence tool.
-
Connect to Databricks Data in DBArtisan
Use wizards in DBArtisan to configure Databricks as a data source.
-
Connect to Procore Data in Aqua Data Studio
Access Procore from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Connect to TaxJar from Asprova with CData Software ODBC Driver for TaxJar
This article shows how to connect faster to TaxJar data from Asprova.
-
Build Pipelines with Live SAP HANA Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to SAP HANA from Google Cloud Data Fusion, enabling the integration of live SAP HANA into the building and management of effective data pipelines.
-
Analyze eBay Analytics Data in Infragistics Reveal
Use the CData API Server to create an OData API on top of eBay Analytics and visualize live eBay Analytics in Infragistics Reveal.
-
Creating API Driver API Profiles
Create a new API Profiles to enable SQL access to a new API.
-
Automated Continuous SAP HANA Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable SAP HANA replication to Azure SQL Database.
-
How to integrate Placid with Apache Airflow
Access and process Placid in Apache Airflow using the CData JDBC Driver.
-
Access Power BI XMLA Data from MySQL in PHP
Connect to Power BI XMLA through the standard MySQL libraries in PHP.
-
How to Easily Query Customer.io Data in OpenOffice Base
Connect to Customer.io data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
How to Visualize Quickbase Data in Python with pandas via CData Connect AI
Use the CData Connect AI Python SDK with pandas and Matplotlib to analyze and visualize live Quickbase in Python.
-
Integrate Egnyte Data in the Pentaho Report Designer
Publish reports based on Egnyte in the Pentaho BI tool.
-
Query Workable Data in DataGrip
Create a Data Source for Workable in DataGrip and use SQL to query live Workable.
-
Automate CSV Data Replication to Azure Synapse
Use CData Sync to customize and automate CSV/TSV Files replication to Azure Synapse.
-
Build JSON Visualizations in Tableau Desktop
Use CData Connect AI to connect to live JSON and build visualizations in Tableau.