CData Software - Knowledge Base
Recent Articles
-
Access Live Monday.com Data in AWS Lambda
Connect to live Monday.com in AWS Lambda using the CData JDBC Driver.
-
Query DB2 Data in DataGrip
Create a Data Source for DB2 in DataGrip and use SQL to query live IBM DB2.
-
Connect to Greenplum Data in HULFT Integrate
Connect to Greenplum as a JDBC data source in HULFT Integrate
-
Add Zoho Creator Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Zoho Creator with the Informatica Enterprise Data Catalog to classify and organize data.
-
Intercom Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Intercom facts in real time.
-
Integrate with ShipEngine Data in JReport Designer
Create charts and reports based on ShipEngine in JReport Designer.
-
Visualize Azure Data Catalog Data in TIBCO Spotfire through ADO.NET
Integrate Azure Data Catalog into dashboards in TIBCO Spotfire.
-
Automated Continuous eBay Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable eBay replication to Apache Kafka.
-
Build Semantic Layer Views for Printful Data in APOS Live Data Gateway
Use the CData Connector for Printful in APOS Live Data Gateway to build Semantic Layer Views for Printful.
-
Automate Instantly Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live Instantly and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
Integrate with NetSuite SuiteAnalytics Data in SnapLogic
Use CData Connect AI to connect to and integrate with live NetSuite SuiteAnalytics in SnapLogic.
-
Build MYOB AccountRight-Connected Apps in Choreo
Use CData Connect AI to connect to MYOB AccountRight Data from Choreo and build custom apps using live MYOB AccountRight.
-
Integrating Gumloop with ActiveCampaign Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on ActiveCampaign within automated workflows.
-
Integrate Real-Time Access to Sage 300 in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Sage 300 in real time.
-
Getting Started with the CData Power BI Connector for TigerGraph
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for TigerGraph.
-
Use the CData Software ODBC Driver for Clio in SAS for Real-Time Reporting and Analytics
Connect to real-time Clio in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Clio.
-
Use the CData Software ODBC Driver for Discord in MicroStrategy Desktop
Connect to Discord in MicroStrategy Desktop using the CData Software ODBC Driver for Discord.
-
How to Connect the Power BI Service to HBase: Complete Guide
Connect to the CData Software Power BI Connector for HBase from PowerBI.com to provide real-time Apache HBase across the organization.
-
Access Live Airtable Data in Emergent via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Emergent agents to securely access and build applications with live Airtable through MCP integration.
-
Build Voice Agents in ElevenLabs with access to Live Lakebase Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Lakebase.
-
Integrate Google Sheets Data in the Pentaho Report Designer
Publish reports based on Google Sheets in the Pentaho BI tool.
-
Analyze SAP Fieldglass Data in Looker
Use CData Connect AI to connect to SAP Fieldglass Data from Looker and build custom apps using live SAP Fieldglass.
-
Build Basecamp-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Basecamp.
-
Integrate Theia IDE with Live Snapchat Ads Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE
-
Integrating Cursor CLI with YouTube Analytics 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.
-
How to Connect to & Open ZohoDesk Data in Microsoft Excel
This article uses the CData ODBC driver for ZohoDesk to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
How to Easily Query Hive Data in OpenOffice Base
Connect to Hive data in OpenOffice Base using the CData ODBC Driver for Apache Hive and generate reports with live data insights.
-
Automated Continuous HDFS Replication to AlloyDB
Use CData Sync for automated, continuous, customizable HDFS replication to AlloyDB.
-
Visualize Live Outreach.io Data in the Power BI Service
Use CData Connect AI to connect to live Outreach.io and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Integrating Cursor CLI with Procore 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.
-
Analyze AgileCRM Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of AgileCRM and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Connect to Intercom Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Intercom.
-
Import Real-Time Short.io Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Short.io in ColdFusion.
-
Integrate with live MarkLogic Data in Jitterbit
Use CData Connect AI to connect to and integrate live MarkLogic in Jitterbit.
-
How to work with Teradata Data in Apache Spark using SQL
Access and process Teradata Data in Apache Spark using the CData Software JDBC Driver.
-
Access Cloudflare Data from MySQL in Amazon QuickSight
Connect to Cloudflare and build visualizations of Cloudflare using a MySQL Connection in Amazon QuickSight.
-
Rapidly Develop PhantomBuster-Driven Apps with Active Query Builder
Leverage the Active Query Builder SQL interface and .NET data access to create data-driven WinForms and ASP.NET apps backed by PhantomBuster.
-
Moving Data from Miro to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Miro data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
How to Work with Teamgate Data in AWS Glue Jobs Using JDBC
Connect to Teamgate from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
How to Connect the Power BI Service to Kintone: Complete Guide
Connect to the CData Software Power BI Connector for Kintone from PowerBI.com to provide real-time Kintone across the organization.
-
Back Up Greenhouse to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Greenhouse. In this article, we will employ an SSIS workflow to populate a database with Greenhouse data.
-
A PostgreSQL Interface for Teradata Data (MySQL Remoting via JDBC)
Use the Remoting features of the Teradata JDBC Driver to create a PostgreSQL entry-point for data access.
-
Visualize Live Paddle Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Paddle using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Connect to Keap Data in NetBeans
Connect to Keap in NetBeans with the data source configuration wizard.
-
Access Live Keap Data in Coginiti Pro
Connect to and query live Keap from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Connect to Gong Data from HeidiSQL
Use CData Connect AI to connect to and query live Gong from HeidiSQL.
-
How to Import Data from Odoo into Google Sheets
Import Odoo ERP into a Google spreadsheet that is automatically refreshed.
-
Use Dash to Build to Web Apps on Suadeo Data
Create Python applications that use pandas and Dash to build Suadeo-connected web apps.
-
Publish Clockify-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Clockify.
-
Build a PostgreSQL Interface for Eventbrite Data using the CData JDBC Driver
Use the Remoting features of the Eventbrite JDBC Driver to create a PostgreSQL entry-point for data access.
-
Integrating Cursor CLI with Yelp 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.
-
Migrating data from YouTube Analytics to Databricks using CData SSIS Components.
Easily push YouTube Analytics to Databricks using the CData SSIS Tasks for YouTube Analytics and Databricks.
-
Integrate with Landbot Data in JReport Designer
Create charts and reports based on Landbot in JReport Designer.
-
Integrating Codex CLI with Amazon DynamoDB 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.
-
Validate Splunk Data with QuerySurge
Access and validate Splunk in QuerySurge using the CData JDBC Driver.
-
View Reports on Real-Time Paymo Data in Power BI Report Server
Use the CData ODBC Driver for Paymo to visualize Paymo in Power BI Desktop and then publish them to Power BI Report Server.
-
Getting Started with the CData Tableau Connector for ScrapingBee
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Use the CData Software ODBC Driver for FormSite in MicroStrategy Desktop
Connect to FormSite in MicroStrategy Desktop using the CData Software ODBC Driver for FormSite.
-
Create Power BI Reports on Real-Time ConvertAPI Data
Use the CData ODBC Driver for ConvertAPI to visualize ConvertAPI in Power BI Desktop.
-
How to Import Data from SFTP into Google Sheets
Import SFTP into a Google spreadsheet that is automatically refreshed.
-
Publish Reports with Delighted Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Delighted.
-
Analyze Bitly Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Bitly from Power Pivot. You will use the Table Import Wizard to load Bitly. You can visually build the import query or use any SQL supported by the driver.
-
Integrating GitHub Copilot CLI with Samanage 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.
-
How to Connect to Live Adobe Commerce Data from Gemini CLI (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Gemini CLI to securely read and take actions on your Adobe Commerce for you.
-
Build MarkLogic-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to MarkLogic Data from Zoho Analytics and import live MarkLogic.
-
How to create Visio diagrams from Act CRM Data
Automatically update Act CRM with the changes you make to Visio master shapes.
-
How to work with Greenhouse Data in Apache Spark using SQL
Access and process Greenhouse Data in Apache Spark using the CData Software JDBC Driver.
-
Connect to Power BI XMLA Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Power BI XMLA and the SQL Gateway to access Power BI XMLA from Google Apps Script.
-
Connect to SendGrid Data from AWS Glue
Use CData Connect AI to gain access to live SendGrid from your AWS Glue jobs.
-
Visualize Live LinkedIn Ads Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live LinkedIn Ads using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Integrating Codex CLI with AfterShip 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.
-
Access Live SurveyMonkey Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to SurveyMonkey from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
How to load Humanity data into Elasticsearch via Logstash
Introducing a simple method to load Humanity data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Migrating data from ZohoSubscriptions to Databricks using CData SSIS Components.
Easily push ZohoSubscriptions to Databricks using the CData SSIS Tasks for ZohoSubscriptions and Databricks.
-
Automated Continuous Adobe Target Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Adobe Target replication to Apache Cassandra.
-
Connect and Query Live HBase Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Apache HBase into Databricks
-
Use the CData ODBC Driver for QuickBooks Online in Microsoft Power Query
You can use the CData QuickBooks Online ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import QuickBooks Online into Microsoft Power Query.
-
Automated Continuous SendPulse Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable SendPulse replication to PostgreSQL.
-
Connect to Freshservice from Asprova with CData Software ODBC Driver for Freshservice
This article shows how to connect faster to Freshservice data from Asprova.
-
Deploy the ADO.NET Provider for ConvertAPI on an SSRS Report Server
Connect to ConvertAPI 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.
-
Automated Continuous SageHR Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable SageHR replication to Apache Cassandra.
-
Connect to ZohoInvoice Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Connect to Freshservice Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Freshservice.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for ShipEngine
Provide connectivity to ShipEngine through an SAP BusinessObjects universe.
-
Query Facebook Data from Node.js
Use the OData endpoint of the CData API Server to connect to your Facebook and perform CRUD operations on Facebook from Node.js.
-
Automate iContact Data Replication to Couchbase
Use CData Sync to Customize and automate iContact replication to Couchbase.
-
Use JayDeBeApi to access Helpscout Data in Python
Use standard Python scripting and the development environment of your choice to access live Helpscout.
-
Establish a Live Connection with Webex Data using Tableau Bridge
The CData ODBC Driver for Webex enables you to integrate live Webex into Tableau Cloud dashboards using the Tableau Bridge.
-
Publish Crystal Reports on LaunchDarkly Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date LaunchDarkly.
-
Use ChatGPT to Talk to Your Azure Synapse 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 Azure Synapse for you.
-
Connect to Amazon S3 Data in RapidMiner
Integrate Amazon S3 with standard components and data source configuration wizards in RapidMiner Studio.
-
Use Dash to Build to Web Apps on Act CRM Data
Create Python applications that use pandas and Dash to build Act CRM-connected web apps.
-
Integrate LibreChat with Live Oracle Service Cloud Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Oracle Service Cloud from within the chat interface.
-
Visualize Live Reply.io Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Reply.io using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
How to Connect to & Open NASA Data in Microsoft Excel
This article uses the CData ODBC driver for NASA to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Build Apps with Live Microsoft OneNote in Adalo using CData Connect AI
Use CData Connect AI to integrate live Microsoft OneNote into the Adalo platform and build custom mobile and web applications with real-time Microsoft OneNote.
-
Import Real-Time IBM Cloud Object Storage Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use IBM Cloud Object Storage in ColdFusion.
-
Stream DocuSign Data into Apache Kafka Topics
Access and stream DocuSign in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Coda
Provide connectivity to Coda through an SAP BusinessObjects universe.
-
Analyze Asana Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Asana and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.