CData Software - Knowledge Base
Recent Articles
-
Build Visualizations of Planio Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Planio in Birst.
-
Access Cloudant Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live IBM Cloudant from HeidiSQL.
-
How to Work with Workable Data in ETL Validator JDBC
Connect to Workable from ETL Validator jobs using the CData Software JDBC Driver.
-
Excel Spreadsheet Automation on Nethunt Data with the QUERY Formula
Pull data from Nethunt, automate spreadsheets, and more with the QUERY formula.
-
How to Query CapsuleCRM Data in MySQL Workbench
Execute MySQL queries against live CapsuleCRM from MySQL Workbench.
-
Getting Started with the CData JDBC Driver for SpaceX
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for SpaceX.
-
Consume Amazon Marketplace OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Amazon Marketplace feeds that reflect any changes in SAP Lumira.
-
Use ChatGPT to Talk to Your Office 365 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 Microsoft Office 365 for you.
-
Extract, Transform, and Load Neo4J Data in Informatica PowerCenter
Create a simple Workflow for Neo4J in Informatica PowerCenter.
-
Connect to and Visualize Live Yelp Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Yelp.
-
Access Live Salesloft Data in Coginiti Pro
Connect to and query live Salesloft from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Viewing JobNimbus Data in RAD Studio Data Explorer
How to view JobNimbus in RAD Studio Data Explorer using the CData ODBC Driver for JobNimbus.
-
How to Connect to ClickTime Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to ClickTime. Leverage the pyodbc module for ODBC in Python.
-
Automated Continuous Helpscout Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Helpscout replication to IBM DB2.
-
How to Build an ETL App for XML Data in Python with CData
Create ETL applications and real-time data pipelines for XML Files in Python with petl.
-
Viewing JSON Services in RAD Studio Data Explorer
How to view JSON in RAD Studio Data Explorer using the CData ODBC Driver for JSON.
-
A PostgreSQL Interface for Eventbrite Data using the CData ODBC Driver
Use the SQL Gateway and Eventbrite ODBC Driver to create a PostgreSQL entry-point for data access.
-
Publish BenchmarkEmail-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live BenchmarkEmail.
-
Connect to CampaignMonitor Data in Ruby
Connect to CampaignMonitor in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Getting Started with the CData JDBC Driver for Chargebee
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Chargebee.
-
Manage JotForm Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for JotForm.
-
Use the CData Software JDBC Driver for IBM Informix in MicroStrategy Web
Connect to IBM Informix in MicroStrategy Web using the CData Software JDBC Driver for IBM Informix.
-
Connect to Pipedrive Data in JRuby
Create a simple JRuby app with access to live Pipedrive.
-
Analyze Avalara AvaTax Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Avalara AvaTax and visualize live Avalara AvaTax in Infragistics Reveal.
-
Using the CData Software ODBC Driver for ServiceNow in PyCharm
Connect to ServiceNow as an ODBC data source in PyCharm using the CData Software ODBC Driver for ServiceNow.
-
A PostgreSQL Interface for Basecamp Data using the CData ODBC Driver
Use the SQL Gateway and Basecamp ODBC Driver to create a PostgreSQL entry-point for data access.
-
Xero Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Xero facts in real time.
-
Build Box-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Box and build web apps with connectivity to live Box.
-
Integrate Theia IDE with Live Zoho Projects Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE
-
Connect to Sendwithus Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Sendwithus using standard SQL.
-
Connect Act CRM to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Act CRM with IBM WebSphere for seamless data integration and connectivity.
-
How to connect to XML Data from IntelliJ
Integrate connectivity to XML Files with wizards in IntelliJ.
-
Replicate Teamwork Data to Multiple Databases
Replicate Teamwork to disparate databases with a point-and-click configuration.
-
How to create an RPA flow for Snapchat Ads Data in UiPath Studio
Use the Snapchat Ads ODBC Driver to create workflows that access real-time Snapchat Ads without any coding.
-
Create a Data Access Object for Placid Data using JDBI
A brief overview of creating a SQL Object API for Placid in JDBI.
-
Integrate Salesloft with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Salesloft with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Salesloft.
-
Automated Continuous ClickUp Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable ClickUp replication to Azure SQL Database.
-
Build Apps with Live Attio Data Using the Low-Code Development Platform of Mendix
Connect Attio with Mendix to build apps using the CData API Driver for JDBC.
-
Integrating Gumloop with Redshift Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Amazon Redshift within automated workflows.
-
Build Microsoft Entra ID Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Microsoft Entra ID and build visualizations in Tableau Cloud.
-
Prepare, Blend, and Analyze Jumpseller Data in Alteryx Designer (ODBC)
Build workflows to access live Jumpseller for self-service data analytics.
-
Use the CData Software ODBC Driver for Shopify in SAS for Real-Time Reporting and Analytics
Connect to real-time Shopify in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Shopify.
-
Connect to Outlook from Asprova with CData Software ODBC Driver for Outlook
This article shows how to connect faster to Outlook data from Asprova.
-
Build Data Flows from Mocean to SQL Server using SSIS
Easily back up Mocean to SQL Server using the SSIS components for Mocean.
-
ChargeOver Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on ChargeOver facts in real time.
-
Integrating Claude Code CLI with SharePoint Excel Services 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.
-
Automated Continuous AdRoll Replication to MongoDB
Use CData Sync for automated, continuous, customizable AdRoll replication to MongoDB.
-
Load Yelp Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Yelp to a database.
-
Visualize Egnyte Data in Sisense
Create an ElastiCube in Sisense app with access to Egnyte.
-
How to Connect to Live Sage Cloud Accounting Data from Google ADK Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Google ADK agents to securely read and take actions on your Sage Business Cloud Accounting for you.
-
Snowflake Drivers: How to Setup and Use OAuth Authentication
A guide on configuring OAuth authentication in Snowflake and using OAuth authentication with CData Snowflake solutions.
-
Use the CData API Server to Access Sybase Data in Microsoft PowerPivot
Use the CData API Server to connect to live Sybase in the Power Pivot business intelligence tool.
-
Automate MySQL Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live MySQL and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
How to integrate Metabase with Instagram Data
Use CData Connect AI to connect to live Instagram and create an interactive dashboard in Metabase from Instagram.
-
Write a Simple Go Application to work with QuickBooks Time Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to QuickBooks Time.
-
Analyze Kintone Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Kintone from Power Pivot. You will use the Table Import Wizard to load Kintone. You can visually build the import query or use any SQL supported by the driver.
-
Integrating Intercom Data in Talend Cloud Data Management Platform
Connect Intercom Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Access ShipEngine Data from MySQL in PHP
Connect to ShipEngine through the standard MySQL libraries in PHP.
-
Connect to and Visualize Live Discord Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Discord.
-
Query Sendwithus Data as a MySQL Database in Node.js
Execute MySQL queries against Sendwithus from Node.js.
-
How to Connect Google Calendar Data to Gemini Enterprise via CData Connect AI
Connect CData Connect AI Remote MCP to Gemini Enterprise to securely read and take actions on live Google Calendar data in real time using natural language.
-
Connect to Wrike Data in CloverDX (formerly CloverETL)
Transfer Wrike using the visual workflow in the CloverDX data integration tool.
-
Access Live Salesloft Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Salesloft into the statistical analysis tools available in SAS JMP. This article shows how to use Salesloft in the Graph Builder and Query Builder.
-
Import Google Spanner Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Google Spanner Data and provide access to live Google Spanner for custom reports in the Power BI Service.
-
Bidirectional Access to Elorus Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Elorus in Filemaker Pro for Mac or Windows.
-
Automated Continuous QuickBooks Online Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable QuickBooks Online replication to OneLake in Microsoft Fabric.
-
Integrate SAS Data Sets Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live SAS Data Sets from Informatica Cloud.
-
Visualize Dynamics CRM Data in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load Microsoft Dynamics CRM into TIBCO Spotfire.
-
Choosing the Best Method to Connect Delighted to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Delighted from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Connect to Real-Time BigQuery Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for BigQuery and Dataflow to import and use Google BigQuery in Power Apps.
-
How to Create Power BI Visual Reports with Real-Time LionDesk Data
Use CData Power BI Connectors to visualize LionDesk in Power BI.
-
Integrate Pinecone Data in Pentaho Data Integration
Build ETL pipelines based on Pinecone in the Pentaho Data Integration tool.
-
Connect to Zoho Recruit Data from a Connection Pool in JBoss
Integrate Zoho Recruit into Java servlets: Use the Management Console in JBoss to install the Zoho Recruit JDBC Driver.
-
Connect PayPal to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live PayPal using the CData Python MCP Server.
-
Bridge Mouseflow Connectivity with Apache NiFi
Access and process Mouseflow in Apache NiFi using the CData JDBC Driver.
-
Query Live Google Search Results 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 Google Search directly from the development environment.
-
Integrate with Live CouchDB Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to CouchDB from the MuleSoft Anypoint Platform to integrate live Apache CouchDB into custom reports and dashboards.
-
Query Foursquare Data in DataGrip
Create a Data Source for Foursquare in DataGrip and use SQL to query live Foursquare.
-
Integrating Dataiku with Gmail Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Gmail.
-
Automated Continuous API Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable API replication to OneLake in Microsoft Fabric.
-
Automate Eventbrite Data Replication to Azure Data Lake
Use CData Sync to customize and automate Eventbrite replication to Azure Data Lake.
-
Query eBay Analytics Data through ODBC in Node.js
Use node-odbc to execute SQL queries against eBay Analytics from Node.js.
-
LINQ to Gumroad 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 Gumroad Data Provider.
-
How to connect to Placid Data in DBVisualizer
Integrate Placid with visual data analysis tools and data connection wizards in DBVisualizer
-
Visualize Google Forms Data in Tableau
The CData ODBC driver for Google Forms enables you integrate Google Forms into Tableau dashboards.
-
Manage Hacker News Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Hacker News.
-
Operational Reporting on JSON Services from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote JSON.
-
Create Strava Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Strava from PowerBI.com to create Power BI Dataflows with real-time data.
-
Automated Continuous Clari Replication to SingleStore
Use CData Sync for automated, continuous, customizable Clari replication to SingleStore.
-
Create Datasets from Google Sheets in Domo Workbench and Build Visualizations of Google Sheets Data in Domo
Use the CData Software ODBC Driver for Google Sheets to create datasets from Google Sheets in Domo Workbench and then build visualizations in the Domo service.
-
Use Biml to Build SSIS Tasks to Replicate HCL Domino Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate HCL Domino to SQL Server.
-
Integrating Gumloop with Klaviyo Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Klaviyo within automated workflows.
-
How to work with SAP Business One Data in Apache Spark using SQL
Access and process SAP Business One Data in Apache Spark using the CData Software JDBC Driver.
-
How to Seamlessly Import BenchmarkEmail Data into IBM SPSS Modeler
Integrate BenchmarkEmail data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Query Trello Data as a SQL Server Database in Node.js
Execute SQL Server queries against Trello from Node.js.
-
Import LinkedIn Ads Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to LinkedIn Ads Data and provide access to live LinkedIn Ads for custom reports in the Power BI Service.
-
Use Dash to Build to Web Apps on Qualaroo Data
Create Python applications that use pandas and Dash to build Qualaroo-connected web apps.
-
How to Create Power BI Visual Reports with Real-Time Zoho Creator Data
Use CData Power BI Connectors to visualize Zoho Creator in Power BI.
-
Build Zoho Books Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Zoho Books and build visualizations in Tableau Cloud.
-
Analyze Timely Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Timely with the CData JDBC Driver for Timely.