CData Software - Knowledge Base
Recent Articles
-
Use CData Connect AI to Access Cloudant Data in Microsoft Power Pivot
Use CData Connect AI to connect to live IBM Cloudant in the Power Pivot business intelligence tool.
-
Integrate Wistia Data in Pentaho Data Integration
Build ETL pipelines based on Wistia in the Pentaho Data Integration tool.
-
Getting Started with the CData ADO.NET Provider for Stack Exchange
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Integrating OpenCode Terminal with Azure Synapse 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.
-
Integrate Adobe Analytics Data in the Pentaho Report Designer
Publish reports based on Adobe Analytics in the Pentaho BI tool.
-
Validate Salesforce Pardot Data with QuerySurge
Access and validate Salesforce Pardot in QuerySurge using the CData JDBC Driver.
-
How to Visualize Amplitude Data in Python with pandas
Use pandas and other modules to analyze and visualize live Amplitude in Python.
-
How to Connect DBeaver to ChargeOver via a JDBC Driver
Manage ChargeOver with visual tools in DBeaver like the query browser.
-
Build Charts with OnePageCrm Data in Clear Analytics
Create dynamic charts and perform analytics based on OnePageCrm in Clear Analytics.
-
Replicate Avalara AvaTax Data in Heroku for Use in Salesforce Connect
Replicate Avalara AvaTax to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Migrating data from WooCommerce to Google BigQuery using CData SSIS Components.
Easily push WooCommerce to Google BigQuery using the CData SSIS Tasks for WooCommerce and Google BigQuery.
-
Integrate Goose with Live Okta Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Okta from within the local AI agent.
-
Integrating Cursor CLI with Sybase 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.
-
Use the CData Software JDBC Driver for Square in MicroStrategy Web
Connect to Square in MicroStrategy Web using the CData Software JDBC Driver for Square.
-
Build Quaderno-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Quaderno and build web apps with connectivity to live Quaderno.
-
How to Connect to Live Facebook Data in n8n Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable n8n to securely read and take actions on your Facebook for you.
-
Integrating OpenCode Terminal with Autopilot 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 Tally Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Tally from Power Pivot. You will use the Table Import Wizard to load Tally ERP. You can visually build the import query or use any SQL supported by the driver.
-
Integrating Kiro CLI with Discord 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 Exa Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Use the CData Software ODBC Driver for Google Directory in MicroStrategy
Connect to Google Directory in MicroStrategy Developer using the CData Software ODBC Driver for Google Directory.
-
Integrate Real-Time Access to Impala in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Apache Impala in real time.
-
Connect to Dynamics 365 Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Build Dashboards with Discord Data in Dundas BI
Create dynamic dashboards and perform analytics based on Discord in Dundas BI.
-
How to Build an ETL App for MessageBird Data in Python with CData
Create ETL applications and real-time data pipelines for MessageBird in Python with petl.
-
Connect to Printful Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Use Dash to Build to Web Apps on Sentry Data
Create Python applications that use pandas and Dash to build Sentry-connected web apps.
-
How to load Sugar CRM data into Elasticsearch via Logstash
Introducing a simple method to load Sugar CRM data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Create Informatica Mappings From/To an ODBC Data Source for eBay Analytics
Create an ODBC connection to eBay Analytics in Informatica and browse and transfer eBay Analytics.
-
Build Charts with SAP BusinessObjects BI Data in Clear Analytics
Create dynamic charts and perform analytics based on SAP BusinessObjects BI in Clear Analytics.
-
Integrate BigQuery with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate BigQuery with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Google BigQuery.
-
Connect to Oracle Data from HeidiSQL
Use CData Connect AI to connect to and query live Oracle Database from HeidiSQL.
-
Automated Continuous Wrike Replication to Databricks
Use CData Sync for automated, continuous, customizable Wrike replication to Databricks.
-
Access Office 365 Data from MySQL in PHP
Connect to Office 365 through the standard MySQL libraries in PHP.
-
Connect to Unbounce Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Unbounce.
-
Visualize PayPal Data in TIBCO Spotfire through OData
Integrate PayPal into dashboards in TIBCO Spotfire.
-
Automate BigCommerce Data Replication to Couchbase
Use CData Sync to Customize and automate BigCommerce replication to Couchbase.
-
Connect to Live Cosmos DB Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Cosmos DB in CData Connect AI and connect to your Azure Cosmos DB from PostgreSQL.
-
Automated Continuous Teradata Replication to MongoDB
Use CData Sync for automated, continuous, customizable Teradata replication to MongoDB.
-
Connect Optimizely to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Optimizely with IBM WebSphere for seamless data integration and connectivity.
-
DataBind Controls to Paylocity Data in C++Builder
DataBind to Paylocity in C++Builder with standard components and controls.
-
Easily Integrate Clockify Data in Lazarus Pascal IDE
Learn how to easily integrate live Clockify in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Integrating Cursor CLI with Trello 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.
-
Getting Started with the CData Python Connector for VWO
Learn to install and license the CData Python Connector
-
Create Dynamic Toggl Grids Using the Infragistics XamDataGrid
Learn how you can connect Toggl to Infragistics XamDataGrid to build dynamic grids.
-
Integrate QuickBooks Online Data in the Pentaho Report Designer
Publish reports based on QuickBooks Online in the Pentaho BI tool.
-
DataBind MYOB AccountRight Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for MYOB AccountRight with the DevExpress Windows Forms and Web controls to provide MYOB AccountRight to a chart.
-
Build QuickBooks-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to QuickBooks Desktop and build web apps with connectivity to live QuickBooks Desktop.
-
How to Build an ETL App for Google Search Results in Python with CData
Create ETL applications and real-time data pipelines for Google Search in Python with petl.
-
Connect and Query Live Amazon Marketplace Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Amazon Marketplace into Databricks
-
Create Dynamic PivotalTracker Grids Using the Infragistics XamDataGrid
Learn how you can connect PivotalTracker to Infragistics XamDataGrid to build dynamic grids.
-
Access Live Marketo Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Marketo from your Google Sheets.
-
Natively Connect to Klipfolio Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Klipfolio. Leverage the native support for ODBC in PHP.
-
Analyze Facebook Ads Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Facebook Ads from Power Pivot. You will use the Table Import Wizard to load Facebook Ads. You can visually build the import query or use any SQL supported by the driver.
-
Getting Started with the CData JDBC Driver for Datadog
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Datadog.
-
Integrate Live OData Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf
-
Using the CData Software ODBC Driver for Google Drive in PyCharm
Connect to Google Drive as an ODBC data source in PyCharm using the CData Software ODBC Driver for Google Drive.
-
Manage Paymo Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Paymo.
-
Provide OData Services of Dropbox Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Dropbox by developing a WCF Service Application.
-
Connect to Shopify Data in DBeaver
Use the CData ODBC Driver to connect to Shopify in DBeaver.
-
Build a Simple VCL Application for SAP Ariba Procurement Data
How to build a simple VCL Application to view SAP Ariba Procurement in RAD Studio using the CData ODBC Driver for SAP Ariba Procurement.
-
Choosing the Best Method to Connect PabblySubscriptions to SQL Server: 5 Options Explained
Discover multiple ways to connect and use PabblySubscriptions from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Query IBM Cloud Object Storage Data as a SQL Server Database in Node.js
Execute SQL Server queries against IBM Cloud Object Storage from Node.js.
-
Integrate LibreChat with Live Databricks Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Databricks from within the chat interface.
-
Use Biml to Build SSIS Tasks to Replicate Insightly Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Insightly to SQL Server.
-
Build MVC Applications with Connectivity to Square Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Square from an ASP.NET MVC application.
-
How to Visualize Aircall Data in Python with pandas
Use pandas and other modules to analyze and visualize live Aircall in Python.
-
Getting Started with the CData Excel Add-In for Samanage
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Samanage.
-
Provide OData Services of Klaviyo Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Klaviyo by developing a WCF Service Application.
-
Build Dashboards with Instantly Data in DBxtra
Create dynamic dashboards and perform analytics based on Instantly in DBxtra.
-
Create SAS xpt-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to SAS xpt Data from Klipfolio and build custom visualizations using live SAS XPORT.
-
Connect to Guru Data from PowerBuilder via JDBC
This article demonstrates how to access Guru from PowerBuilder using the Guru JDBC Driver.
-
Create Data Visualizations Based On Amazon S3 Data in Mode
Use CData Connect AI to connect to Amazon S3 Data from Mode and build visualizations using live
-
Query QuickBooks Online Data in ColdFusion
Write standard ColdFusion data access code to connect to QuickBooks Online.
-
Integrate AgileCRM Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live AgileCRM from Informatica Cloud.
-
Integrate Pushbullet with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Pushbullet with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Pushbullet.
-
How to Query Live Oracle Eloqua Data in Perplexity MacOS Desktop
Connect to and query live Oracle Eloqua Data in Perplexity Desktop using CData MCP Server.
-
Provide OData Services of PagerDuty Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for PagerDuty by developing a WCF Service Application.
-
How to Import Data from Salesforce into Google Sheets
Import Salesforce & Force.com into a Google spreadsheet that is automatically refreshed.
-
ETL Simplesat in Oracle Data Integrator
This article shows how to transfer Simplesat into a data warehouse using Oracle Data Integrator.
-
Build Voice Agents in ElevenLabs with access to Live Cosmos DB Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Azure Cosmos DB.
-
Connecting Agentforce with Adobe Analytics 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 Adobe Analytics for you.
-
Feed SAP HANA XS Advanced Data into FineReport
How to set SAP HANA XS Advanced as a JDBC data source in FineReport.
-
Import Real-Time LionDesk Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use LionDesk in ColdFusion.
-
Rapidly Develop Moosend-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 Moosend.
-
Connect to Elasticsearch Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Elasticsearch and the SQL Gateway to access Elasticsearch from Google Apps Script.
-
How to Connect to Live WooCommerce Data in Mistral AI Workflows
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live WooCommerce without replication.
-
How to Create Power BI Visual Reports with Real-Time SAS Data Sets Data
Use CData Power BI Connectors to visualize SAS Data Sets in Power BI.
-
Connect to Stack Exchange Data Using the Script Function in Claris FileMaker Pro
Use the CData API Driver for ODBC and the Script function in FileMaker Pro to connect to Stack Exchange and work with Stack Exchange in your FileMaker application.
-
Connect to Google Forms in SpagoBI
Create reports featuring live Google Forms in SpagoBI Studio. Host Google Forms reports on SpagoBI Server.
-
Build an OLAP Cube in SSAS from Adobe Commerce Data
Establish a connection to Adobe Commerce data from SQL Server Analysis Services, and use the Adobe Commerce Data Provider to build OLAP cubes for use in analytics and reporting.
-
Connect to Discourse Data in JRuby
Create a simple JRuby app with access to live Discourse.
-
How to work with Google Search Results in Apache Spark using SQL
Access and process Google Search Results in Apache Spark using the CData Software JDBC Driver.
-
How to Connect to & Open ConvertAPI Data in Microsoft Excel
This article uses the CData ODBC driver for ConvertAPI to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
How to Access PhantomBuster Data Using Entity Framework
This article shows how to access PhantomBuster using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Connect to Recurly Data from a Connection Pool in JBoss
Integrate Recurly into Java servlets: Use the Management Console in JBoss to install the Recurly JDBC Driver.
-
How to work with Zoho Projects Data in Apache Spark using SQL
Access and process Zoho Projects Data in Apache Spark using the CData Software JDBC Driver.
-
Replicate Email Data in Heroku for Use in Salesforce Connect
Replicate Email to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Connect to Instagram Data in DBArtisan
Use wizards in DBArtisan to configure Instagram as a data source.
-
Deploy the ADO.NET Provider for Dynamics 365 on an SSRS Report Server
Connect to Microsoft Dynamics 365 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.