CData Software - Knowledge Base
Recent Articles
-
Query, Visualize, and Share live Marketo Data in Redash
Use CData Connect AI to connect to live Marketo in Redash for querying, visualizing, and sharing.
-
How to connect to Adobe Analytics Data from IntelliJ
Integrate connectivity to Adobe Analytics with wizards in IntelliJ.
-
Integrating Cursor CLI with Harvest 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.
-
Provide OData Services of Oracle Financials Cloud Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Oracle Financials Cloud by developing a WCF Service Application.
-
Access Live Gong Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Gong from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Use the CData Software ODBC Driver for IBM Cloud Object Storage in MicroStrategy
Connect to IBM Cloud Object Storage in MicroStrategy Developer using the CData Software ODBC Driver for IBM Cloud Object Storage.
-
Connect to Mocean Data in HULFT Integrate
Connect to Mocean as a JDBC data source in HULFT Integrate
-
Prepare, Blend, and Analyze Postmark Data in Alteryx Designer (ODBC)
Build workflows to access live Postmark for self-service data analytics.
-
Build Dashboards with Azure Analysis Services Data in DBxtra
Create dynamic dashboards and perform analytics based on Azure Analysis Services in DBxtra.
-
Getting Started with the CData JDBC Driver for Keap
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Keap.
-
Hive Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Hive facts in real time.
-
Connect to Klaviyo 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 Klaviyo.
-
Connect to and Visualize Live REST Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live REST.
-
Create Kintone-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Kintone Data from Klipfolio and build custom visualizations using live Kintone.
-
Create Informatica Mappings From/To a JDBC Data Source for Mailjet
Create Mailjet data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Connect to Mistral AI Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Mistral AI in the Denodo Virtual DataPort Administrator.
-
Integrating Antigravity CLI with Brex via CData CLI
Connect Brex to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Validate Access Data with QuerySurge
Access and validate Microsoft Access in QuerySurge using the CData JDBC Driver.
-
Automate Couchbase Data Replication to Azure Data Lake
Use CData Sync to customize and automate Couchbase replication to Azure Data Lake.
-
How to Design Cloudant Power Apps with Database-Like Connectivity
Gain real-time, database-like connectivity to Cloudant from mobile and tablet Power Apps.
-
Analyze Oracle Data in Looker
Use CData Connect AI to connect to Oracle Data from Looker and build custom apps using live Oracle Database.
-
Automated Continuous Drift Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Drift replication to OneLake in Microsoft Fabric.
-
Add TaxJar Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for TaxJar with the Informatica Enterprise Data Catalog to classify and organize data.
-
Bridge Jodoo Connectivity with Apache NiFi
Access and process Jodoo in Apache NiFi using the CData JDBC Driver.
-
Rapidly Develop QuickBooks-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 QuickBooks.
-
Build Google Directory-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Google Directory Data and create custom apps in Mendix.
-
Automated Continuous Airtable Replication to MongoDB
Use CData Sync for automated, continuous, customizable Airtable replication to MongoDB.
-
Use Claude to Talk to Your eBay Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your eBay for you.
-
How to connect and process Google AlloyDB from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Google AlloyDB.
-
ETL BenchmarkEmail in Oracle Data Integrator
This article shows how to transfer BenchmarkEmail into a data warehouse using Oracle Data Integrator.
-
Connect to Tickspot Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Tickspot.
-
Add Microsoft Exchange Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Microsoft Exchange with the Informatica Enterprise Data Catalog to classify and organize data.
-
Model, Search, and Visualize Live FHIR Data in ThoughtSpot
Use CData Connect AI to connect to live FHIR for modeling, searching, and visualizing.
-
Integrate with Live Airtable Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Airtable from the MuleSoft Anypoint Platform to integrate live Airtable into custom reports and dashboards.
-
How to Connect to Live Klaviyo 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 Klaviyo through natural language.
-
Build AI/ML Models with Live ZohoExpense Data using Dataiku
Connect ZohoExpense Data with Dataiku using the CData API Driver for JDBC.
-
Integrate with ClickTime Data in JReport Designer
Create charts and reports based on ClickTime in JReport Designer.
-
Analyze Missive Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Missive with the CData JDBC Driver for Missive.
-
Build Voice Agents in ElevenLabs with access to Live SAP SuccessFactors Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live SAP SuccessFactors.
-
Build a Singer.io Tap for LinkedIn Ads With the CData Python Connector
Learn how to easily build a Singer.io Tap for live LinkedIn Ads data using
-
How to connect PolyBase to ZeroBounce
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live ZeroBounce.
-
Use CData Connect AI to Access Paylocity Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Paylocity in the Power Pivot business intelligence tool.
-
Build a Singer.io Tap for ConvertAPI With the CData Python Connector
Learn how to easily build a Singer.io Tap for live ConvertAPI data using
-
DataBind Delighted Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Delighted to a chart.
-
Use the CData ODBC Driver for Testmonitor in Microsoft Power Query
You can use the CData Testmonitor ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Testmonitor into Microsoft Power Query.
-
Extract, Transform, and Load SingleStore Data in Informatica PowerCenter
Create a simple Workflow for SingleStore in Informatica PowerCenter.
-
Connecting Moonlit Workflow with Basecamp 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 Basecamp in real time.
-
LINQ to ZohoExpense 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 ZohoExpense Data Provider.
-
Moving Data from TigerGraph to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live TigerGraph data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Integrating Kiro CLI with Azure Analysis 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 Grafana Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Grafana replication to IBM DB2.
-
Build Dashboards with Beeminder Data in Dundas BI
Create dynamic dashboards and perform analytics based on Beeminder in Dundas BI.
-
Visualize Pinecone Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Pinecone.
-
Establish a Live Connection with Zoom Data using Tableau Bridge
The CData ODBC Driver for Zoom enables you to integrate live Zoom into Tableau Cloud dashboards using the Tableau Bridge.
-
Build Oracle Eloqua Reporting-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Oracle Eloqua Reporting and build web apps with connectivity to live Oracle Eloqua Reporting.
-
Access Live Act CRM Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Act CRM from your Google Sheets.
-
Use the CData Software JDBC Driver for Excel Online in MicroStrategy
Connect to Microsoft Excel Online in MicroStrategy Developer using the CData Software JDBC Driver for Excel Online.
-
Connect to Stack Exchange in SpagoBI
Create reports featuring live Stack Exchange in SpagoBI Studio. Host Stack Exchange reports on SpagoBI Server.
-
Connect to MYOB AccountRight Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for MYOB AccountRight and the SQL Gateway to access MYOB AccountRight from Google Apps Script.
-
How to Query Live NetSuite Data in Claude Desktop
Connect to and query live NetSuite Data in Claude Desktop using CData MCP Server.
-
Replicate Facebook Data to Multiple Databases
Replicate Facebook to disparate databases with a point-and-click configuration.
-
Integrating Codex CLI with Anaplan 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 Informatica Mappings From/To a JDBC Data Source for Confluence
Create Confluence data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Build a Singer.io Tap for Google Sheets With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Google Sheets data using
-
Integrate LibreChat with Live Zuora Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Zuora from within the chat interface.
-
PolarTeamPro Reporting in OBIEE with the PolarTeamPro JDBC Driver
Deploy the PolarTeamPro JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Automated Continuous Confluence Replication to Vertica
Use CData Sync for automated, continuous, customizable Confluence replication to Vertica.
-
Use ChatGPT to Talk to Your Google Ad Manager 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 Google Ad Manager for you.
-
Use the CData Software JDBC Driver for Phoenix in MicroStrategy
Connect to Apache Phoenix in MicroStrategy Developer using the CData Software JDBC Driver for Phoenix.
-
Using the CData Software ODBC Driver for Bitbucket in PyCharm
Connect to Bitbucket as an ODBC data source in PyCharm using the CData Software ODBC Driver for Bitbucket.
-
Create Dashboards and Visualize Live SurveyMonkey Data in Geckoboard
Use CData Connect AI to connect to live SurveyMonkey and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Visualize Live Vercel Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Vercel using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Integrate Gmail Data in Pentaho Data Integration
Build ETL pipelines based on Gmail in the Pentaho Data Integration tool.
-
Integrate LibreChat with Live SAP Concur Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live SAP Concur from within the chat interface.
-
Connect to Cvent Data in Ruby
Connect to Cvent in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
How to publish and share Sage 300 Data dashboards with Tableau Server
The CData ODBC driver for Sage 300 enables you integrate Sage 300 into Tableau dashboards.
-
Visualize Live Clari Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Clari.
-
Connect to ShipStation Data from AWS Glue
Use CData Connect AI to gain access to live ShipStation from your AWS Glue jobs.
-
Build Dashboards with CockroachDB Data in DBxtra
Create dynamic dashboards and perform analytics based on CockroachDB in DBxtra.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Lakebase using the Model Context Protocol.
-
Visualize Timely Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Timely.
-
Extract, Transform, and Load Snowflake Data in Informatica PowerCenter
Create a simple Workflow for Snowflake in Informatica PowerCenter.
-
Use the CData Software ODBC Driver for XML in MicroStrategy Desktop
Connect to XML Files in MicroStrategy Desktop using the CData Software ODBC Driver for XML.
-
Connect to SAP SuccessFactors Data in Google Apps Script via Connect AI
Use CData Connect AI to access SAP SuccessFactors in Google Apps Script.
-
Use JayDeBeApi to access GitHub Data in Python
Use standard Python scripting and the development environment of your choice to access live GitHub.
-
Access Live Anaplan Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Anaplan into the statistical analysis tools available in SAS JMP. This article shows how to use Anaplan in the Graph Builder and Query Builder.
-
Connect to Live Google Ad Manager Data in MicroStrategy through CData Connect AI
Create a live connection to Google Ad Manager Data in CData Connect AI and connect to your Google Ad Manager from MicroStrategy.
-
Creating BambooHR-Connected Applications in Unqork
You can use CData Connect AI to feed BambooHR to Unqork and build custom business apps.
-
Build AI Agents with Azure Table Data in IBM watsonx Orchestrate using CData Connect AI
Learn how to build intelligent agents in IBM watsonx Orchestrate that can securely access and act on live Azure Table Storage through CData Connect AI.
-
Automate Anaplan Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Anaplan from PowerShell? This article demonstrates how to utilize the Anaplan Cmdlets for tasks like connecting to Anaplan, automating operations, downloading data, and more.
-
How to connect to Superchat Data from IntelliJ
Integrate connectivity to Superchat with wizards in IntelliJ.
-
Analyze CouchDB Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Apache CouchDB and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
How to Easily Query ZohoInvoice Data in OpenOffice Base
Connect to ZohoInvoice data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Trigger NetSuite IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for NetSuite with standard wizards in Logic Apps.
-
Integrating Dataiku with Bullhorn CRM Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Bullhorn CRM.
-
Use the CData Software JDBC Driver for Authorize.Net in MicroStrategy
Connect to Authorize.Net in MicroStrategy Developer using the CData Software JDBC Driver for Authorize.Net.
-
Automated Continuous Basecamp Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Basecamp replication to OneLake in Microsoft Fabric.
-
Validate Quaderno Data with QuerySurge
Access and validate Quaderno in QuerySurge using the CData JDBC Driver.
-
Connect to Oracle Eloqua Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Oracle Eloqua.
-
Migrating data from Adobe Analytics to Databricks using CData SSIS Components.
Easily push Adobe Analytics to Databricks using the CData SSIS Tasks for Adobe Analytics and Databricks.