CData Software - Knowledge Base
Recent Articles
-
Connecting Agentforce with Salesforce Marketing Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Agentforce to securely read and take actions on your Salesforce Marketing Cloud for you.
-
Create Demio Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Demio from PowerBI.com to create Power BI Dataflows with real-time data.
-
Build a Simple VCL Application for SendInBlue Data
How to build a simple VCL Application to view SendInBlue in RAD Studio using the CData ODBC Driver for SendInBlue.
-
Access Live Azure DevOps Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Azure DevOps into the statistical analysis tools available in SAS JMP. This article shows how to use Azure DevOps in the Graph Builder and Query Builder.
-
Integrating Dataiku with API Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live API.
-
Integrate Airtable Data in Pentaho Data Integration
Build ETL pipelines based on Airtable in the Pentaho Data Integration tool.
-
DataBind Foursquare Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Foursquare to a chart.
-
Tanda Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Tanda facts in real time.
-
Connect to Paylocity Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Paylocity from Filemaker Pro on Mac.
-
Integrating LangGraph with Act CRM Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Act CRM within automated workflows.
-
How to Query Live Google Cloud Storage Data in Claude Desktop
Connect to and query live Google Cloud Storage Data in Claude Desktop using CData MCP Server.
-
Rapidly Develop Impala-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 Impala.
-
Getting Started with the CData Power BI Connector for LinkedIn Ads
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for LinkedIn Ads.
-
Create Informatica Mappings From/To an ODBC Data Source for Gong
Create an ODBC connection to Gong in Informatica and browse and transfer Gong.
-
View Reports on Real-Time SAP Ariba Procurement Data in Power BI Report Server
Use the CData ODBC Driver for SAP Ariba Procurement to visualize SAP Ariba Procurement in Power BI Desktop and then publish them to Power BI Report Server.
-
How to Connect to & Open Freshteam Data in Microsoft Excel
This article uses the CData ODBC driver for Freshteam to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Query GitHub Data through ODBC in Node.js
Use node-odbc to execute SQL queries against GitHub from Node.js.
-
Build Cvent-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Cvent.
-
Connect to RSS Feeds from PowerBuilder via JDBC
This article demonstrates how to access RSS Feeds from PowerBuilder using the RSS JDBC Driver.
-
How to Connect DBeaver to Oracle Financials Cloud via a JDBC Driver
Manage Oracle Financials Cloud with visual tools in DBeaver like the query browser.
-
Validate WordPress Data with QuerySurge
Access and validate WordPress in QuerySurge using the CData JDBC Driver.
-
Choosing the Best Method to Connect Foursquare to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Foursquare from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Create Phoenix Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Phoenix from PowerBI.com to create Power BI Dataflows with real-time data.
-
Visualize Microsoft Entra ID 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 Entra ID into TIBCO Spotfire.
-
Natively Connect to Stripe Data in PHP
The CData ODBC driver for Stripe enables you to create PHP applications with connectivity to Stripe. Leverage the native support for ODBC in PHP.
-
Excel Spreadsheet Automation on TaxJar Data with the QUERY Formula
Pull data from TaxJar, automate spreadsheets, and more with the QUERY formula.
-
How to publish and share Gong Data dashboards with Tableau Server
The CData ODBC driver for Gong enables you integrate Gong into Tableau dashboards.
-
Integrating Gumloop with Amazon Athena Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Amazon Athena within automated workflows.
-
Rapidly Develop Instantly-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 Instantly.
-
Build a PostgreSQL Interface for Gorgias Data using the CData JDBC Driver
Use the Remoting features of the Gorgias JDBC Driver to create a PostgreSQL entry-point for data access.
-
Integrate Splunk with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Splunk with External Services.
-
Use the CData Software ODBC Driver for Cosmos DB in MicroStrategy Web
Connect to Azure Cosmos DB in MicroStrategy Web using the CData Software ODBC Driver for Cosmos DB.
-
How to use SQLAlchemy ORM to access Reply.io Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Reply.io.
-
Use the CData Software ODBC Driver for Templated in MicroStrategy
Connect to Templated in MicroStrategy Developer using the CData Software ODBC Driver for Templated.
-
Query Facebook Ads Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Facebook Ads from Node.js.
-
Integrate LibreChat with Live Google Analytics Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Google Analytics from within the chat interface.
-
Analyze Salesforce Pardot Data in Infragistics Reveal
Use the CData API Server to create an OData API on top of Salesforce Pardot and visualize live Salesforce Pardot in Infragistics Reveal.
-
Automated Continuous Amplitude Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Amplitude replication to Apache Cassandra.
-
Integrating Kiro CLI with Instantly 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.
-
PayPal Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on PayPal facts in real time.
-
Replicate LinkedIn Ads Data to Multiple Databases
Replicate LinkedIn Ads to disparate databases with a point-and-click configuration.
-
Manage LinkedIn Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for LinkedIn.
-
Automated Continuous Aircall Replication to SQL Server
Use CData Sync for automated, continuous, customizable Aircall replication to SQL Server.
-
Connect to Snapchat Ads Data in RapidMiner
Integrate Snapchat Ads with standard components and data source configuration wizards in RapidMiner Studio.
-
Use Grok to Talk to Your Azure Synapse 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 Azure Synapse for you.
-
Build MVC Applications with Connectivity to Zoho Creator Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Zoho Creator from an ASP.NET MVC application.
-
Use the CData Software JDBC Driver for ChargeOver in MicroStrategy Web
Connect to ChargeOver in MicroStrategy Web using the CData Software JDBC Driver for ChargeOver.
-
Build Data Flows from HBase to SQL Server using SSIS
Easily back up Apache HBase to SQL Server using the SSIS components for HBase.
-
Integrate MYOB AccountRight Data into Power Automate Desktop using CData Connect
CData Connect for MYOB AccountRight Data enables you to integrate MYOB AccountRight into workflows built using Microsoft Power Automate Desktop.
-
Connect to Clio Data in Jaspersoft Studio
Execute SQL to remote Clio in Jaspersoft Studio.
-
Visualize Webex Data in Tableau
The CData ODBC driver for Webex enables you integrate Webex into Tableau dashboards.
-
Use Agno to Talk to Your Kintone 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 Kintone for you.
-
How to publish and share Unbounce Data dashboards with Tableau Server
The CData ODBC driver for Unbounce enables you integrate Unbounce into Tableau dashboards.
-
Connect to Google Search Results from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Google Search from Filemaker Pro on Mac.
-
Connect to and Query Cvent Data in QlikView over ODBC
Create data visualizations with Cvent in QlikView.
-
Connect to ZendeskSell Data as an External Source in Dremio
Use the CData JDBC Driver to connect to ZendeskSell as an External Source in Dremio.
-
Analyze ZohoSubscriptions Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for ZohoSubscriptions from Power Pivot. You will use the Table Import Wizard to load ZohoSubscriptions. You can visually build the import query or use any SQL supported by the driver.
-
Integrate WordPress with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate WordPress with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to WordPress.
-
Automated Continuous ChargeOver Replication to SQL Server
Use CData Sync for automated, continuous, customizable ChargeOver replication to SQL Server.
-
How to Query Live Dynamics NAV Data in Claude Desktop
Connect to and query live Dynamics NAV Data in Claude Desktop using CData MCP Server.
-
Model, Search, and Visualize Live DB2 Data in ThoughtSpot
Use CData Connect AI to connect to live IBM DB2 for modeling, searching, and visualizing.
-
Query OneNote Data as a SQL Server Database in Node.js
Execute SQL Server queries against Microsoft OneNote from Node.js.
-
Integrate Real-Time Access to Lakebase in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Lakebase in real time.
-
Design BIRT Reports on Elasticsearch Data
Provide current Elasticsearch to your embedded analytics.
-
Model Splunk Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Splunk, enabling the direct import of real-time Splunk.
-
Natively Connect to RSS Feeds in PHP
The CData ODBC driver for RSS enables you to create PHP applications with connectivity to RSS Feeds. Leverage the native support for ODBC in PHP.
-
Build Sage Cloud Accounting-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Sage Cloud Accounting Data and create custom apps in Mendix.
-
Automated Continuous Jodoo Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Jodoo replication to OneLake in Microsoft Fabric.
-
Connect to Xero Data from PowerBuilder via JDBC
This article demonstrates how to access Xero Accounting from PowerBuilder using the Xero JDBC Driver.
-
Connect Kintone to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Kintone with IBM WebSphere for seamless data integration and connectivity.
-
Connect to OneNote from Asprova with CData Software ODBC Driver for OneNote
This article shows how to connect faster to OneNote data from Asprova.
-
How to Connect Flowise AI Agents to Live Pipedrive Data via CData Connect AI
Integrate Flowise AI with the CData Connect AI MCP Server to enable agents to securely query and act on live Pipedrive without replication.
-
Replicate Rebilly Data to Multiple Databases via the CData Sync CLI
Replicate Rebilly to disparate databases with a single configuration.
-
Connect to Klaviyo Data from a Connection Pool in JBoss
Integrate Klaviyo into Java servlets: Use the Management Console in JBoss to install the Klaviyo JDBC Driver.
-
Build Marketo-Connected Apps in Choreo
Use CData Connect AI to connect to Marketo Data from Choreo and build custom apps using live Marketo.
-
How to Connect DBeaver to SharePoint via a JDBC Driver
Manage Microsoft SharePoint with visual tools in DBeaver like the query browser.
-
How to connect to ChargeOver Data with Squirrel SQL client
Connect to ChargeOver and execute queries in the Squirrel SQL Client.
-
Manage PivotalTracker Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for PivotalTracker.
-
Visualize Zendesk Data in TIBCO Spotfire through OData
Integrate Zendesk into dashboards in TIBCO Spotfire.
-
Create Datasets from CockroachDB in Domo Workbench and Build Visualizations of CockroachDB Data in Domo
Use the CData Software ODBC Driver for CockroachDB to create datasets from CockroachDB in Domo Workbench and then build visualizations in the Domo service.
-
Replicate Elorus Data to Multiple Databases
Replicate Elorus to disparate databases with a point-and-click configuration.
-
Design BIRT Reports on Scrapfly Data
Provide current Scrapfly to your embedded analytics.
-
Connect to Excel Online from a Connection Pool in WebLogic
Use the CData JDBC Driver for Excel Online to connect to Microsoft Excel Online from Web applications running on WebLogic.
-
Connect to NetSuite Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for NetSuite CRM & ERP.
-
Deploy the ADO.NET Provider for Presto on an SSRS Report Server
Connect to Presto 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.
-
How to Access Google Calendar Information with a Service Account
Learn how to set up service account authentication with Google Calendar and then authenticate for live Google Calendar access.
-
Connect to ZendeskSell Data from PowerBuilder via ADO.NET
This article demonstrates how to access ZendeskSell from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Connect to PabblySubscriptions Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for PabblySubscriptions.
-
Automated Continuous LionDesk Replication to IBM DB2
Use CData Sync for automated, continuous, customizable LionDesk replication to IBM DB2.
-
Working with IBM Informix Data in LINQPad
Execute LINQ queries to IBM Informix in LINQPad.
-
Integrate Open WebUI with Live Sage Cloud Accounting Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Sage Business Cloud Accounting from within the chat interface.
-
Rapidly Develop SAP-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 SAP.
-
Connect and Visualize Live Google Calendar Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Google Calendar into the Databricks platform and create visualization dashboards with real-time Google Calendar.
-
Visualize Scrapfly Data in Sisense
Create an ElastiCube in Sisense app with access to Scrapfly.
-
How to create Typeform federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Typeform in MySQL .
-
Connect to MariaDB Data in ACL Analytics
Connect to MariaDB via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to MariaDB.
-
Automated Continuous Wave Financial Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Wave Financial replication to IBM DB2.
-
Getting Started with the CData Excel Add-In for XML
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for XML.
-
Design BIRT Reports on Webex Data
Provide current Webex to your embedded analytics.
-
Stream Deel Data into Apache Kafka Topics
Access and stream Deel in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.