CData Software - Knowledge Base
Recent Articles
-
Edit and Search Drift External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of Drift to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create Drift objects that you can access from apps and the dashboard.
-
A PostgreSQL Interface for TigerGraph Data (MySQL Remoting via JDBC)
Use the Remoting features of the TigerGraph JDBC Driver to create a PostgreSQL entry-point for data access.
-
Apache Log4j2 Overview
CData is aware of the recently disclosed Apache Log4j2 vulnerability (CVE-2021-44228).
-
Connect to ZendeskSell Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
How to Query Live Freshteam Data in Claude Desktop
Connect to and query live Freshteam Data in Claude Desktop using CData MCP Server.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Azure Table
Provide connectivity to Azure Table Storage through an SAP BusinessObjects universe.
-
Edit and Search External Google Ads Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Google Ads to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Google Ads Data objects that you can access from apps and the dashboard.
-
Integrating Kiro CLI with Zuora 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.
-
Replicate Azure Synapse Data to Multiple Databases via the CData Sync CLI
Replicate Azure Synapse to disparate databases with a single configuration.
-
Visualize Live Telegram Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Telegram.
-
Connect SharePoint Excel Services to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live SharePoint Excel Services using the CData Python MCP Server.
-
Integrating Gumloop with Smartsheet Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Smartsheet within automated workflows.
-
Build Dashboards with Vercel Data in Dundas BI
Create dynamic dashboards and perform analytics based on Vercel in Dundas BI.
-
Import Real-Time AlloyDB Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Google AlloyDB in ColdFusion.
-
Extract, Transform, and Load Odoo Data in Informatica PowerCenter
Create a simple Workflow for Odoo ERP in Informatica PowerCenter.
-
How to connect to Basecamp Data in DBVisualizer
Integrate Basecamp with visual data analysis tools and data connection wizards in DBVisualizer
-
Getting Started with the CData ODBC Driver for Google Tasks
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Google Tasks.
-
Object-Relational Mapping (ORM) with Wrike 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 Wrike into a Java-based ORM framework, Hibernate.
-
How to integrate Sage 200 with Apache Airflow
Access and process Sage 200 in Apache Airflow using the CData JDBC Driver.
-
Connect JobNimbus to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect JobNimbus with IBM WebSphere for seamless data integration and connectivity.
-
Consume Paddle OData Feeds in PowerBuilder
This article demonstrates how to consume Paddle as OData feeds from PowerBuilder using the API Server.
-
Integrate Oracle with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Oracle with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Oracle Database.
-
Connecting Moonlit Workflow with Microsoft Entra ID 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 Microsoft Entra ID in real time.
-
Create Snowflake Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Snowflake data access from reports, embedded analytics, and more.
-
Use the CData ODBC Driver for Snapchat Ads in Microsoft Power Query
You can use the CData Snapchat Ads ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Snapchat Ads into Microsoft Power Query.
-
Visualize Procore Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Procore.
-
Configure the CData JDBC Driver for SendInBlue in a Connection Pool in Tomcat
Connect to SendInBlue from a connection pool in Tomcat.
-
Feed Mixpanel Data into FineReport
How to set Mixpanel as a JDBC data source in FineReport.
-
Add Mixpanel Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Mixpanel with the Informatica Enterprise Data Catalog to classify and organize data.
-
Model, Search, and Visualize Live Google Calendar Data in ThoughtSpot
Use CData Connect AI to connect to live Google Calendar for modeling, searching, and visualizing.
-
Connect to and Query Zoho Creator Data in QlikView over ODBC
Create data visualizations with Zoho Creator in QlikView.
-
Excel Spreadsheet Automation on QuickBooks Data with the QUERY Formula
Pull data from QuickBooks, automate spreadsheets, and more with the QUERY formula.
-
Connect to Facebook Ads Data from PowerBuilder via JDBC
This article demonstrates how to access Facebook Ads from PowerBuilder using the Facebook Ads JDBC Driver.
-
Connect to Auth0 from Asprova with CData Software ODBC Driver for Auth0
This article shows how to connect faster to Auth0 data from Asprova.
-
Import and Visualize Vimeo Data in Power View
Create data visualizations based on Vimeo in Excel.
-
Integrate Live Asana Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Asana from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Asana.
-
Getting Started with the CData Power BI Connector for Paylocity
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Paylocity.
-
Build Qualaroo-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData API Driver for MCP Server to explore live Qualaroo Data in GitHub Copilot to assist with building Qualaroo-powered applications.
-
Extract, Transform, and Load Parallel Data in Informatica PowerCenter
Create a simple Workflow for Parallel in Informatica PowerCenter.
-
Model, Search, and Visualize Live Highrise Data in ThoughtSpot
Use CData Connect AI to connect to live Highrise CRM for modeling, searching, and visualizing.
-
Connect to Coinbase Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Coinbase.
-
Query Parallel Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Parallel from Node.js.
-
How to connect to SAP Hybris C4C Data from Spring Boot
Connect to SAP Hybris C4C in a Spring Boot Application using the CData JDBC Driver for SAP Hybris C4C
-
Integrate Live Workday Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf
-
How to Build an ETL App for Google Calendar Data in Python with CData
Create ETL applications and real-time data pipelines for Google Calendar in Python with petl.
-
How to connect to Google Translate Data with Squirrel SQL client
Connect to Google Translate and execute queries in the Squirrel SQL Client.
-
Stream ZendeskSell Data into Apache Kafka Topics
Access and stream ZendeskSell in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Integrate Guru Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Guru from Informatica Cloud.
-
Use Agno to Talk to Your MailChimp Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Agno agents to securely answer questions and take actions on your MailChimp for you.
-
How to connect Amazon QuickSight to HBase Data
Create a connection to Apache HBase in CData Connect AI and insert Apache HBase into Amazon QuickSight SPICE to build interactive dashboards.
-
A PostgreSQL Interface for Spotify Data (MySQL Remoting via JDBC)
Use the Remoting features of the Spotify JDBC Driver to create a PostgreSQL entry-point for data access.
-
Access Live SAS xpt Data in AWS Lambda (with IntelliJ IDEA)
Connect to live SAS XPORT in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Build Gong Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Gong and build visualizations in Tableau.
-
View Reports on Real-Time ServiceDesk Plus Data in Power BI Report Server
Use the CData ODBC Driver for ServiceDesk Plus to visualize ServiceDesk Plus in Power BI Desktop and then publish them to Power BI Report Server.
-
Connecting Mastra with Dynamics CRM Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to enable Mastra agents to securely query, read, and act on real-time Microsoft Dynamics CRM, no replication required.
-
Build Semantic Layer Views for Sage Cloud Accounting Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Sage Business Cloud Accounting.
-
Integrating OpenCode Terminal with NetSuite 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.
-
Connect to HubDB Data in Ruby
Connect to HubDB in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Replicate SuiteCRM Data from PowerShell
Write a quick PowerShell script to query SuiteCRM. Use connectivity to the live data to replicate SuiteCRM to SQL Server.
-
Use the CData Software ODBC Driver for VWO in MicroStrategy Desktop
Connect to VWO in MicroStrategy Desktop using the CData Software ODBC Driver for VWO.
-
ChartMogul Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on ChartMogul facts in real time.
-
Replicate Act-On Data to Multiple Databases via the CData Sync CLI
Replicate Act-On to disparate databases with a single configuration.
-
Getting Started with the CData JDBC Driver for HubDB
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for HubDB.
-
Automated Continuous ShipStation Replication to MongoDB
Use CData Sync for automated, continuous, customizable ShipStation replication to MongoDB.
-
Extract, Transform, and Load SharePoint Data in Informatica PowerCenter
Create a simple Workflow for Microsoft SharePoint in Informatica PowerCenter.
-
Build MessageBird-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData API Driver for MCP Server to explore live MessageBird Data in GitHub Copilot to assist with building MessageBird-powered applications.
-
Connect to Microsoft Exchange Data in Aqua Data Studio
Access Microsoft Exchange from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Automated Continuous iContact Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable iContact replication to OneLake in Microsoft Fabric.
-
Getting Started with the CData Power BI Connector for Apollo
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Connect to Guru Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Guru in the Denodo Virtual DataPort Administrator.
-
How to connect to Dynamics CRM Data from Spring Boot
Connect to Dynamics CRM in a Spring Boot Application using the CData JDBC Driver for Dynamics CRM
-
Using the CData Software ODBC Driver for JSON in PyCharm
Connect to JSON as an ODBC data source in PyCharm using the CData Software ODBC Driver for JSON.
-
Build a Simple VCL Application for Auth0 Data
How to build a simple VCL Application to view Auth0 in RAD Studio using the CData ODBC Driver for Auth0.
-
Create Google Tasks Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Google Tasks data access from reports, embedded analytics, and more.
-
Build Apps with Live Dynamics 365 Data Using the Low-Code Development Platform of Mendix
Connect Microsoft Dynamics 365 with Mendix to build apps using the CData JDBC Driver for Dynamics 365.
-
Build Microsoft Dataverse-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Microsoft Dataverse (CDS) and build Microsoft Dataverse-connected web apps with Axios.
-
Getting Started with the CData SSIS Components for Zoho CRM
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Zoho CRM.
-
How to Connect the Power BI Service to Elorus: Complete Guide
Connect to the CData Software Power BI Connector for Elorus from PowerBI.com to provide real-time Elorus across the organization.
-
How to Work with Foursquare Data in ETL Validator JDBC
Connect to Foursquare from ETL Validator jobs using the CData Software JDBC Driver.
-
Getting Started with the CData Python Connector for Oracle
Learn to install and license the CData Python Connector
-
Build Dashboards with SendInBlue Data in DBxtra
Create dynamic dashboards and perform analytics based on SendInBlue in DBxtra.
-
Automated Continuous Helpscout Replication to Databricks
Use CData Sync for automated, continuous, customizable Helpscout replication to Databricks.
-
Build Data Flows from SQL Server to LDAP through SSIS
Easily push SQL Server data to LDAP using the CData SSIS Tasks for LDAP.
-
Use Dash to Build to Web Apps on Calendly Data
Create Python applications that use pandas and Dash to build Calendly-connected web apps.
-
Process & Analyze SageHR Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live SageHR Data.
-
Model Salesforce Marketing Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Salesforce Marketing, enabling the direct import of real-time Salesforce Marketing Cloud.
-
Import Power BI XMLA Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Power BI XMLA Data and provide access to live Power BI XMLA for custom reports in the Power BI Service.
-
Work with YouTube Analytics Data in FoxPro
Load YouTube Analytics into a FoxPro database. This article includes full code and a walk-through of the process.
-
Build Dashboards with Eventbrite Data in Dundas BI
Create dynamic dashboards and perform analytics based on Eventbrite in Dundas BI.
-
Access Freshteam Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Freshteam from HeidiSQL.
-
Access Live Hubstaff Data in TIBCO Data Virtualization
Use the CData API Driver for Tibco DV to create a Hubstaff data source in TIBCO Data Virtualization Studio and gain access to live Hubstaff from your TDV Server.
-
Build a PostgreSQL Interface for ZohoExpense Data using the CData JDBC Driver
Use the Remoting features of the ZohoExpense JDBC Driver to create a PostgreSQL entry-point for data access.
-
Configure the CData JDBC Driver for Vimeo in a Connection Pool in Tomcat
Connect to Vimeo from a connection pool in Tomcat.
-
Back Up xBase to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for xBase. In this article, we will employ an SSIS workflow to populate a database with xBase data.
-
Build Visualizations of Zoho Recruit Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Zoho Recruit in Birst.
-
Automated Continuous ZohoDesk Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable ZohoDesk replication to OneLake in Microsoft Fabric.
-
How to Access Live WordPress Data in Visual Studio Code via Cline
Run CData MCP Server for Wordpress on Windows Subsytem for Linux (WSL) and connect to live WordPress from the Cline extension in Visual Studio Code.
-
DataBind Controls to Shortcut Data in C++Builder
DataBind to Shortcut in C++Builder with standard components and controls.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed OpenWeatherMap to Power BI dashboards. Simply drag and drop OpenWeatherMap into data visuals on the Power BI canvas.
-
Build an OLAP Cube in SSAS from Paymo Data
Establish a connection to Paymo data from SQL Server Analysis Services, and use the Paymo Data Provider to build OLAP cubes for use in analytics and reporting.