CData Software - Knowledge Base
Recent Articles
-
View Reports on Real-Time GitHub Data in Power BI Report Server
Use the CData ODBC Driver for GitHub to visualize GitHub in Power BI Desktop and then publish them to Power BI Report Server.
-
Query Odoo Data as a SQL Server Database in Node.js
Execute SQL Server queries against Odoo ERP from Node.js.
-
Use Grok to Talk to Your Blackbaud FE NXT Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Grok AI to securely answer questions and take actions on your Blackbaud FE NXT for you.
-
Connect to Shippo in SpagoBI
Create reports featuring live Shippo in SpagoBI Studio. Host Shippo reports on SpagoBI Server.
-
How to import Dynamics CRM Data into Apache Solr
Use the CData Software JDBC Driver for Dynamics CRM in Data Import Handler and create an automated import of Microsoft Dynamics CRM to Apache Solr Enterprise Search platform.
-
Build Google Ad Manager-Powered Applications in Cursor with CData MCP Server
Use the CData MCP Server for Google Ad Manager to explore live Google Ad Manager Data in Cursor to assist with building Google Ad Manager-powered applications.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Harvest
Provide connectivity to Harvest through an SAP BusinessObjects universe.
-
Access Live Oracle SCM Data in Roo Code via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Roo Code agents to securely access and build applications with live Oracle SCM through MCP integration.
-
Create Power BI Reports on Real-Time Adobe Analytics Data
Use the CData ODBC Driver for Adobe Analytics to visualize Adobe Analytics in Power BI Desktop.
-
DataBind Controls to Redis Data in C++Builder
DataBind to Redis in C++Builder with standard components and controls.
-
Connect to Rootly Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Rootly to connect to Rootly and execute queries in PowerBuilder.
-
Use the CData Software JDBC Driver for GetResponse in MicroStrategy
Connect to GetResponse in MicroStrategy Developer using the CData Software JDBC Driver for GetResponse.
-
Automated Continuous AgileCRM Replication to IBM DB2
Use CData Sync for automated, continuous, customizable AgileCRM replication to IBM DB2.
-
Automated Continuous Planio Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Planio replication to Google BigQuery.
-
Access Live Short.io Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Short.io into the statistical analysis tools available in SAS JMP. This article shows how to use Short.io in the Graph Builder and Query Builder.
-
Explore Geographical Relationships in Cvent Data with Power Map
Create data visualizations with Cvent in Power Map.
-
Connect and Visualize Live Snowflake Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Snowflake into the Databricks platform and create visualization dashboards with real-time Snowflake.
-
Build Postmark-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Postmark and build web apps with connectivity to live Postmark.
-
Replicate Multiple Xero Accounts
Replicate multiple Xero accounts to one or many databases.
-
Automated Continuous Teamwork Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Teamwork replication to Apache Kafka.
-
Import Real-Time Act CRM Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Act CRM in ColdFusion.
-
Publish Dynamics CRM-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Microsoft Dynamics CRM.
-
Work with Egnyte Data in FoxPro
Load Egnyte into a FoxPro database. This article includes full code and a walk-through of the process.
-
Integrate Google Tasks Data in Pentaho Data Integration
Build ETL pipelines based on Google Tasks in the Pentaho Data Integration tool.
-
Excel Spreadsheet Automation on Sage Intacct Data with the QUERY Formula
Pull data from Sage Intacct, automate spreadsheets, and more with the QUERY formula.
-
Replicate Multiple Marketo Accounts
Replicate multiple Marketo accounts to one or many databases.
-
Build a Singer.io Tap for MailChimp With the CData Python Connector
Learn how to easily build a Singer.io Tap for live MailChimp data using
-
Connect to Dynamics CRM Data in NetBeans
Connect to Microsoft Dynamics CRM in NetBeans with the data source configuration wizard.
-
Query CSV Data from Node.js
Use the OData endpoint of the CData API Server to connect to your CSV/TSV Files and perform CRUD operations on CSV from Node.js.
-
Build an OLAP Cube in SSAS from LionDesk Data
Establish a connection to LionDesk data from SQL Server Analysis Services, and use the LionDesk Data Provider to build OLAP cubes for use in analytics and reporting.
-
Access Live CSV Data in Excel 365 Online (Excel for the web)
Connect to CSV/TSV Files from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Automated Continuous NetSuite SuiteAnalytics Replication to Databricks
Use CData Sync for automated, continuous, customizable NetSuite SuiteAnalytics replication to Databricks.
-
Building Dynamic Web Pages with Certinia Data Using AngularJS
Create single-page applications with live connectivity to Certinia using the CData API Server.
-
Visualize Live Salesforce Data 360 Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Salesforce Data 360 using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
How to Seamlessly Import Azure Table Data into IBM SPSS Modeler
Integrate Azure Table data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Access Live Zoho Recruit Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Zoho Recruit into the statistical analysis tools available in SAS JMP. This article shows how to use Zoho Recruit in the Graph Builder and Query Builder.
-
Explore Geographical Relationships in Attio Data with Power Map
Create data visualizations with Attio in Power Map.
-
Connect to Confluence Data in JRuby
Create a simple JRuby app with access to live Atlassian Confluence.
-
Integrating Antigravity CLI with Basecamp via CData CLI
Connect Basecamp to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Consume SAP SuccessFactors OData Feeds in PowerBuilder
This article demonstrates how to consume SAP SuccessFactors as OData feeds from PowerBuilder using the API Server.
-
Create Clio Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Clio data access from reports, embedded analytics, and more.
-
Automated Continuous Pingdom Replication to SQLite
Use CData Sync for automated, continuous, customizable Pingdom replication to SQLite.
-
Automate ChargeOver Data Replication to Azure Data Lake
Use CData Sync to customize and automate ChargeOver replication to Azure Data Lake.
-
Build an OLAP Cube in SSAS from Customer.io Data
Establish a connection to Customer.io data from SQL Server Analysis Services, and use the Customer.io Data Provider to build OLAP cubes for use in analytics and reporting.
-
Use the CData Software JDBC Driver for Microsoft Ads in MicroStrategy
Connect to Microsoft Ads in MicroStrategy Developer using the CData Software JDBC Driver for Microsoft Ads.
-
Replicate Multiple Clockify Accounts via the CData Sync CLI
Replicate multiple Clockify accounts to one or many databases.
-
How to Connect to Guru Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Guru. Leverage the pyodbc module for ODBC in Python.
-
Create Data Visualizations in Cognos BI with ChargeOver Data
Access ChargeOver as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Integrating LangGraph with ActiveCampaign Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on ActiveCampaign within automated workflows.
-
Build WordPress-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live WordPress.
-
How to Visualize Zoho Creator 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 Zoho Creator in Python.
-
Integrating Kiro CLI with Avalara AvaTax 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.
-
Create Azure Table Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Azure Table from PowerBI.com to create Power BI Dataflows with real-time data.
-
Build Cloudant-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live IBM Cloudant.
-
Integrating GitHub Copilot CLI with Microsoft Dynamics 365 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.
-
Choosing the Best Method to Connect Landbot to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Landbot from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Replicate Instantly Data from PowerShell
Write a quick PowerShell script to query Instantly. Use connectivity to the live data to replicate Instantly to SQL Server.
-
Create Epicor Kinetic-Connected Dashboards in Grafana
Connect to Epicor Kinetic Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Epicor Kinetic.
-
Use the CData ODBC Driver for FHIR in Microsoft Power Query
You can use the CData FHIR ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import FHIR into Microsoft Power Query.
-
How to Query Zoho Recruit Data in MySQL Workbench
Execute MySQL queries against live Zoho Recruit from MySQL Workbench.
-
Connect to Exact Online Data from HeidiSQL
Use CData Connect AI to connect to and query live Exact Online from HeidiSQL.
-
Automated Continuous PolarTeamPro Replication to MySQL
Use CData Sync for automated, continuous, customizable PolarTeamPro replication to MySQL.
-
Build an OLAP Cube in SSAS from Chargebee Data
Establish a connection to Chargebee data from SQL Server Analysis Services, and use the Chargebee Data Provider to build OLAP cubes for use in analytics and reporting.
-
Object-Relational Mapping (ORM) with SAS xpt 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 SAS XPORT into a Java-based ORM framework, Hibernate.
-
Access Act CRM Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Act CRM from HeidiSQL.
-
Access Live Adobe Analytics Data in Coginiti Pro
Connect to and query live Adobe Analytics from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Getting Started with the CData Tableau Connector for Gorgias
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Perform Batch Operations with QuickBooks Data in Apache NiFi
Connect to QuickBooks Desktop and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Build Dashboards with LinkedIn Data in Dundas BI
Create dynamic dashboards and perform analytics based on LinkedIn in Dundas BI.
-
Build Semantic Layer Views for Slack Data in APOS Live Data Gateway
Use the CData Connector for Slack in APOS Live Data Gateway to build Semantic Layer Views for Slack.
-
How to Connect to Live SurveyMonkey 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 SurveyMonkey through natural language.
-
Automated Continuous SAP Ariba Procurement Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable SAP Ariba Procurement replication to delimited files (CSV/TSV).
-
Choosing the Best Method to Connect ADP to SQL Server: 5 Options Explained
Discover multiple ways to connect and use ADP from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Creating Sage Cloud Accounting-Connected Applications in Unqork
You can use CData Connect AI to feed Sage Business Cloud Accounting to Unqork and build custom business apps.
-
Visualize Gmail Data in Tableau
The CData ODBC driver for Gmail enables you integrate Gmail into Tableau dashboards.
-
Create Datasets from Greenhouse in Domo Workbench and Build Visualizations of Greenhouse Data in Domo
Use the CData Software ODBC Driver for Greenhouse to create datasets from Greenhouse in Domo Workbench and then build visualizations in the Domo service.
-
How to Access Live Supabase Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Supabase enables you to integrate Supabase into workflows built using Microsoft Power Automate Desktop.
-
Connect to Marketo Data from Crystal Reports
Use CData Connect AI to connect to and report on live Marketo from Crystal Reports.
-
Build CSV-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for CSV Data and create custom apps in Bubble.
-
How to connect to Telegram Data from Spring Boot
Connect to Telegram in a Spring Boot Application using the CData API Driver for JDBC
-
Publish ZendeskSell-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live ZendeskSell.
-
Process & Analyze ShipStation Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live ShipStation Data.
-
How to Design Email Power Apps with Database-Like Connectivity
Gain real-time, database-like connectivity to Email from mobile and tablet Power Apps.
-
Working with ZohoDesk Data in LINQPad
Execute LINQ queries to ZohoDesk in LINQPad.
-
Establish a Live Connection with Discourse Data using Tableau Bridge
The CData ODBC Driver for Discourse enables you to integrate live Discourse into Tableau Cloud dashboards using the Tableau Bridge.
-
Analyze iContact Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for iContact from Power Pivot. You will use the Table Import Wizard to load iContact. You can visually build the import query or use any SQL supported by the driver.
-
View Reports on Real-Time IBM Informix Data in Power BI Report Server
Use the CData ODBC Driver for IBM Informix to visualize IBM Informix in Power BI Desktop and then publish them to Power BI Report Server.
-
Query Couchbase Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Couchbase entities in PHP by modeling them as objects.
-
Add Wrike Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Wrike with the Informatica Enterprise Data Catalog to classify and organize data.
-
Import Suadeo Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Suadeo. In this article, you will use the OData format to import Suadeo into Microsoft Power Query.
-
Seamlessly Bring Zuora Data into Retool Using CData Connect AI
Integrate Zuora data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Integrate with MessageBird Data in JReport Designer
Create charts and reports based on MessageBird in JReport Designer.
-
Query Google Directory Data in ColdFusion
Write standard ColdFusion data access code to connect to Google Directory.
-
Create Data Visualizations Based On OneNote Data in Mode
Use CData Connect AI to connect to OneNote Data from Mode and build visualizations using live
-
Automated Continuous BigCommerce Replication to Snowflake
Use CData Sync for automated, continuous, customizable BigCommerce replication to Snowflake.
-
Integrate Avaza Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Avaza from Informatica Cloud.
-
Build Data Flows from Moosend to SQL Server using SSIS
Easily back up Moosend to SQL Server using the SSIS components for Moosend.
-
How to load Everhour data into Elasticsearch via Logstash
Introducing a simple method to load Everhour data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Analyze PostgreSQL Data in Infragistics Reveal
Use the CData API Server to create an OData API on top of PostgreSQL and visualize live PostgreSQL in Infragistics Reveal.
-
How to Visualize Nuclia Data in Python with pandas
Use pandas and other modules to analyze and visualize live Nuclia in Python.