CData Software - Knowledge Base
Recent Articles
-
Build Dashboards with Delighted Data in DBxtra
Create dynamic dashboards and perform analytics based on Delighted in DBxtra.
-
Access Live Quickbase Data in TIBCO Data Virtualization
Use the Quickbase Tibco DV Adapter to create a Quickbase data source in TIBCO Data Virtualization Studio and gain access to live Quickbase from your TDV Server.
-
How to Connect to & Open Mouseflow Data in Microsoft Excel
This article uses the CData ODBC driver for Mouseflow to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Build MVC Applications with Connectivity to WooCommerce Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access WooCommerce from an ASP.NET MVC application.
-
How to Connect to & Open Twilio Data in Microsoft Excel
This article uses the CData ODBC driver for Twilio to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Build Dashboards with BenchmarkEmail Data in Dundas BI
Create dynamic dashboards and perform analytics based on BenchmarkEmail in Dundas BI.
-
Use the CData ODBC Driver for Adobe Target from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Adobe Target to connect to Adobe Target from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Adobe Target in Excel.
-
Natively Connect to LightSpeedRetail Data in PHP
The CData ODBC driver for LightSpeedRetail enables you to create PHP applications with connectivity to LightSpeedRetail. Leverage the native support for ODBC in PHP.
-
Connect to Apify from a Connection Pool in WebLogic
Use the CData JDBC Driver for Apify to connect to Apify from Web applications running on WebLogic.
-
How to connect Amazon QuickSight to SharePoint Data
Create a connection to Microsoft SharePoint in CData Connect AI and insert Microsoft SharePoint into Amazon QuickSight SPICE to build interactive dashboards.
-
Integrating LangChain with Google Ad Manager Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Google Ad Manager within automated workflows.
-
Connect to Attio Data in Jaspersoft Studio
Execute SQL to remote Attio in Jaspersoft Studio.
-
DataBind Dynamics CRM Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for Dynamics CRM with the DevExpress Windows Forms and Web controls to provide Microsoft Dynamics CRM to a chart.
-
Natively Connect to Oracle HCM Cloud Data in PHP
The CData ODBC driver for Oracle HCM Cloud enables you to create PHP applications with connectivity to Oracle HCM Cloud. Leverage the native support for ODBC in PHP.
-
Automate MongoDB Data Replication to Azure Data Lake
Use CData Sync to customize and automate MongoDB replication to Azure Data Lake.
-
Connect and Visualize Live SendGrid Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live SendGrid into the Databricks platform and create visualization dashboards with real-time SendGrid.
-
Easily Integrate PDFMonkey Data in Lazarus Pascal IDE
Learn how to easily integrate live PDFMonkey in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Use ChatGPT to Talk to Your Oracle Sales 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 Oracle Sales for you.
-
How to Connect to & Open PayPal Data in Microsoft Excel
This article uses the CData ODBC driver for PayPal to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Connect to Sybase IQ Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Sybase IQ Data and connect to Sybase IQ in Akorbi Digital RunMyProcess.
-
Build an OLAP Cube in SSAS from Apollo Data
Establish a connection to Apollo data from SQL Server Analysis Services, and use the Apollo Data Provider to build OLAP cubes for use in analytics and reporting.
-
Build Sage 200-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Sage 200.
-
Connect to Slack Data in Jaspersoft Studio
Execute SQL to remote Slack in Jaspersoft Studio.
-
Automated Continuous Elasticsearch Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Elasticsearch replication to IBM DB2.
-
Visualize Live Dynamics 365 Data in the Power BI Service
Use CData Connect AI to connect to live Microsoft Dynamics 365 and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Integrate Oracle Financials Cloud with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Oracle Financials Cloud with External Services.
-
Getting Started with the CData JDBC Driver for LightSpeedRetail
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for LightSpeedRetail.
-
Build Dashboards with Foursquare Data in Dundas BI
Create dynamic dashboards and perform analytics based on Foursquare in Dundas BI.
-
Getting Started with the CData Excel Add-In for ServiceNow
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for ServiceNow.
-
Automated Continuous Basecamp Replication to SingleStore
Use CData Sync for automated, continuous, customizable Basecamp replication to SingleStore.
-
Provide OData Services of IBM Cloud Object Storage Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for IBM Cloud Object Storage by developing a WCF Service Application.
-
Use Biml to Build SSIS Tasks to Replicate Box Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Box to SQL Server.
-
Query Salesforce Pardot Data from Node.js
Use the OData endpoint of the CData API Server to connect to your Salesforce Pardot and perform CRUD operations on Salesforce Pardot from Node.js.
-
Create Dynamic Mixpanel Grids Using the Infragistics XamDataGrid
Learn how you can connect Mixpanel to Infragistics XamDataGrid to build dynamic grids.
-
Getting Started with the CData Tableau Connector for Figshare
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Excel Spreadsheet Automation on Gorgias Data with the QUERY Formula
Pull data from Gorgias, automate spreadsheets, and more with the QUERY formula.
-
Connect Marketo to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Marketo with IBM WebSphere for seamless data integration and connectivity.
-
Automated Continuous Basecamp Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Basecamp replication to AlloyDB.
-
Build AI/ML Models with Live Certinia Data using Dataiku
Connect Certinia Data with Dataiku using the CData JDBC Driver for Certinia.
-
Connect to SAP Netweaver Gateway Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for SAP Netweaver Gateway in Airbyte.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for PivotalTracker
Provide connectivity to PivotalTracker through an SAP BusinessObjects universe.
-
Connect to SAP Ariba Source Data from a Connection Pool in Jetty
The SAP Ariba Source JDBC Driver supports connection pooling: This article shows how to connect faster to SAP Ariba Source from Web apps in Jetty.
-
Connect to CockroachDB Data in HULFT Integrate
Connect to CockroachDB as a JDBC data source in HULFT Integrate
-
Create Dynamic MailerSend Grids Using the Infragistics XamDataGrid
Learn how you can connect MailerSend to Infragistics XamDataGrid to build dynamic grids.
-
Visualize Live Egnyte Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Egnyte using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Build an OLAP Cube in SSAS from Pipedrive Data
Establish a connection to Pipedrive data from SQL Server Analysis Services, and use the Pipedrive Data Provider to build OLAP cubes for use in analytics and reporting.
-
How to Query Live Google Directory Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Google Directory data in natural language using Python.
-
How to update Redshift from Excel
This article explains how to transfer data from Excel to Redshift using the Excel Add-In for Redshift.
-
Automated Continuous TaxJar Replication to MongoDB
Use CData Sync for automated, continuous, customizable TaxJar replication to MongoDB.
-
Analyze Attio Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Attio with the CData JDBC Driver for Attio.
-
Automate SAP Ariba Procurement Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live SAP Ariba Procurement and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
Integrate Goose with Live Microsoft Dataverse Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Microsoft Dataverse (CDS) from within the local AI agent.
-
Integrating Claude Code CLI with HelloSign 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 EnterpriseDB Data as an External Source in Dremio
Use the CData JDBC Driver to connect to EnterpriseDB as an External Source in Dremio.
-
How to Seamlessly Import CloudConvert Data into IBM SPSS Modeler
Integrate CloudConvert data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Connect to Billsby Data from a Connection Pool in JBoss
Integrate Billsby into Java servlets: Use the Management Console in JBoss to install the Billsby JDBC Driver.
-
How to Use a Microsoft Access Database to Update MongoDB Data in Real Time
Update MongoDB data by creating a linked table in Microsoft Access with the CData MongoDB ODBC Driver.
-
Integrating Cursor CLI with NASA 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 Parallel from a Connection Pool in WebLogic
Use the CData JDBC Driver for Parallel to connect to Parallel from Web applications running on WebLogic.
-
Automated AfterShip Data Replication to Teradata
Use CData Sync to Customize and automate AfterShip replication to Teradata.
-
Create Dynamic ServiceDesk Plus Grids Using the Infragistics XamDataGrid
Learn how you can connect ServiceDesk Plus to Infragistics XamDataGrid to build dynamic grids.
-
Visualize PingOne Data in TIBCO Spotfire through ADO.NET
Integrate PingOne into dashboards in TIBCO Spotfire.
-
Integrate Live Marketo Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Marketo and integrate live Marketo into apps built in Microsoft Power Apps.
-
Integrate Zoho Recruit Data in Pentaho Data Integration
Build ETL pipelines based on Zoho Recruit in the Pentaho Data Integration tool.
-
Use the CData Software ODBC Driver for Microsoft Exchange in MicroStrategy Desktop
Connect to Microsoft Exchange in MicroStrategy Desktop using the CData Software ODBC Driver for Microsoft Exchange.
-
Integrating LangGraph with CSV Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on CSV/TSV Files within automated workflows.
-
Connect and Query Live SAP SuccessFactors Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live SAP SuccessFactors into Databricks
-
Connect to Greenplum Data in Aqua Data Studio
Access Pivotal GreenPlum from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Model, Search, and Visualize Live ShipStation Data in ThoughtSpot
Use CData Connect AI to connect to live ShipStation for modeling, searching, and visualizing.
-
How to Easily Query Zoom Data in OpenOffice Base
Connect to Zoom data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Integrate LibreChat with Live Twitter Ads Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Twitter Ads from within the chat interface.
-
Connect to Quickbase Data from HeidiSQL
Use CData Connect AI to connect to and query live Quickbase from HeidiSQL.
-
Migrating data from ZarMoney to Snowflake using CData SSIS Components.
Easily push ZarMoney to Snowflake using the CData SSIS Tasks for ZarMoney and Snowflake.
-
Integrating LangGraph with Marketo Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Marketo within automated workflows.
-
Connecting Moonlit Workflow with Sage 200 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 Sage 200 in real time.
-
Publish Crystal Reports on Paylocity Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Paylocity.
-
Create Reports with Pinecone Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Pinecone.
-
Deploy the ADO.NET Provider for Avro on an SSRS Report Server
Connect to Apache Avro 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 Google Search Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Google Search replication to Apache Cassandra.
-
How to Create Power BI Visual Reports with Real-Time Acumatica Data
Use CData Power BI Connectors to visualize Acumatica ERP in Power BI.
-
Integrating OpenCode Terminal with Oracle HCM Cloud 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.
-
Excel Spreadsheet Automation on Klaviyo Data with the QUERY Formula
Pull data from Klaviyo, automate spreadsheets, and more with the QUERY formula.
-
Integrate Supabase Data in Pentaho Data Integration
Build ETL pipelines based on Supabase in the Pentaho Data Integration tool.
-
Integrate Live AlloyDB Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf
-
Access Acumatica Data from MySQL in Amazon QuickSight
Connect to Acumatica and build visualizations of Acumatica ERP using a MySQL Connection in Amazon QuickSight.
-
Create Apps from Procore Data in Qlik Sense Cloud
Use CData Connect AI to connect to Procore Data and build apps from live Procore in Qlik Sense Cloud.
-
How to connect to Apollo Data from Spring Boot
Connect to Apollo in a Spring Boot Application using the CData API Driver for JDBC
-
How to load Epicor Kinetic data into Elasticsearch via Logstash
Introducing a simple method to load Epicor Kinetic data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Connect to and Visualize Live Aha! Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Aha!.
-
How to Connect the Power BI Service to SendPulse: Complete Guide
Connect to the CData Software Power BI Connector for SendPulse from PowerBI.com to provide real-time SendPulse across the organization.
-
Feed Dotmailer Data into FineReport
How to set Dotmailer as a JDBC data source in FineReport.
-
Connect to SurveyMonkey 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 SurveyMonkey.
-
How to Connect to Drift Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Drift. Leverage the pyodbc module for ODBC in Python.
-
Access Live Trello Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Trello from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Choosing the Best Method to Connect WooCommerce to SQL Server: 5 Options Explained
Discover multiple ways to connect and use WooCommerce from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Integrate CockroachDB Data in the Pentaho Report Designer
Publish reports based on CockroachDB in the Pentaho BI tool.
-
Analyze Shopify Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Shopify and visualize live Shopify in Infragistics Reveal.
-
Connect to Outlook Data in Jaspersoft Studio
Execute SQL to remote Outlook in Jaspersoft Studio.
-
Seamlessly Bring Salesforce Data into Retool Using CData Connect AI
Integrate Salesforce data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
How to Create Power BI Visual Reports with Real-Time Elasticsearch Data
Use CData Power BI Connectors to visualize Elasticsearch in Power BI.