CData Software - Knowledge Base
Recent Articles
-
Use the CData Software JDBC Driver for Wave Financial in MicroStrategy Desktop
Connect to Wave Financial in MicroStrategy Desktop using the CData Software JDBC Driver for Wave Financial.
-
How to Query Live Recurly Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Recurly data in natural language using Python.
-
How to Build an ETL App for Pushbullet Data in Python with CData
Create ETL applications and real-time data pipelines for Pushbullet in Python with petl.
-
Analyze Zoom Data in Cognos Analytics
Use CData Connect AI to connect to Zoom Data from Cognos Analytics and analyze live Zoom.
-
Migrating data from Browserless to Databricks using CData SSIS Components.
Easily push Browserless to Databricks using the CData SSIS Tasks for Browserless and Databricks.
-
Replicate Redis Data from PowerShell
Write a quick PowerShell script to query Redis. Use connectivity to the live data to replicate Redis to SQL Server.
-
How to Easily Query Float Data in OpenOffice Base
Connect to Float data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Connect to Databricks in SpagoBI
Create reports featuring live Databricks in SpagoBI Studio. Host Databricks reports on SpagoBI Server.
-
Stream ScrapingBee Data into Apache Kafka Topics
Access and stream ScrapingBee in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Build a Simple VCL Application for GetResponse Data
How to build a simple VCL Application to view GetResponse in RAD Studio using the CData ODBC Driver for GetResponse.
-
Extend Google Sheets with Microsoft OneDrive Data
Make calls to Microsoft OneDrive from Google Apps Script via the API Server.
-
How to connect to RSS Feeds from IntelliJ
Integrate connectivity to RSS Feeds with wizards in IntelliJ.
-
Use JayDeBeApi to access Notion Data in Python
Use standard Python scripting and the development environment of your choice to access live Notion.
-
Visualize MailChimp Data in Sisense
Create an ElastiCube in Sisense app with access to MailChimp.
-
Automated Continuous Authorize.Net Replication to MongoDB
Use CData Sync for automated, continuous, customizable Authorize.Net replication to MongoDB.
-
Seamlessly Bring ShipStation Data into Retool Using CData Connect AI
Integrate ShipStation data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Connect to Real-Time Wrike Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Wrike in Power Apps.
-
Create Tanda Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Tanda from PowerBI.com to create Power BI Dataflows with real-time data.
-
Access Live Insightly Data in Coginiti Pro
Connect to and query live Insightly from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Import Real-Time Tally Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Tally ERP in ColdFusion.
-
Access Azure Data Catalog Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Azure Data Catalog from HeidiSQL.
-
Integrate Open WebUI with Live SAP Business One Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live SAP Business One from within the chat interface.
-
Automated Continuous GitHub Replication to Snowflake
Use CData Sync for automated, continuous, customizable GitHub replication to Snowflake.
-
Integrating Codex CLI with Stack Exchange 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 SharePoint with Databricks Data through external lists
Provide Databricks to SharePoint users as an external list.
-
Integrate with Tanda Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Tanda to a JSON file on disk.
-
How to connect PolyBase to Smartsheet
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Smartsheet.
-
Publish Reports with Deel Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Deel.
-
Natively Connect to Square Data in PHP
The CData ODBC driver for Square enables you to create PHP applications with connectivity to Square. Leverage the native support for ODBC in PHP.
-
Getting Started with the CData Connect AI Python SDK for MariaDB
Install the CData Connect AI Python SDK to read and write live MariaDB with standard DB-API 2.0 Python code.
-
Getting Started with the CData ODBC Driver for Google Translate
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Google Translate.
-
Visualize Live Freshsales Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Freshsales using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Connect to Calendly Data in RazorSQL
Connect to Calendly from wizards and query Calendly from the GUI in the RazorSQL database management tool.
-
Visualize FreshBooks Data in TIBCO Spotfire through ADO.NET
Integrate FreshBooks into dashboards in TIBCO Spotfire.
-
Automate Twilio Data Replication to SAP HANA
Use CData Sync to customize and automate Twilio replication to SAP HANA.
-
Rapidly Develop Parquet-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 Parquet.
-
Connect to BenchmarkEmail Data as an External Source in Dremio
Use the CData JDBC Driver to connect to BenchmarkEmail as an External Source in Dremio.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for ClickUp
Provide connectivity to ClickUp through an SAP BusinessObjects universe.
-
Create Informatica Mappings From/To an ODBC Data Source for Act-On
Create an ODBC connection to Act-On in Informatica and browse and transfer Act-On.
-
Replicate Dynamics CRM Data to Multiple Databases via the CData Sync CLI
Replicate Microsoft Dynamics CRM to disparate databases with a single configuration.
-
Connect to ConvertKit Data in RazorSQL
Connect to ConvertKit from wizards and query ConvertKit from the GUI in the RazorSQL database management tool.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Excel Online
Provide connectivity to Microsoft Excel Online through an SAP BusinessObjects universe.
-
How to Connect to Google Campaign Manager 360 Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Google Campaign Manager 360. Leverage the pyodbc module for ODBC in Python.
-
Automate Trello Data Replication to Azure Synapse
Use CData Sync to customize and automate Trello replication to Azure Synapse.
-
Use the CData ODBC Driver for Qualaroo from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Qualaroo to connect to Qualaroo from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Qualaroo in Excel.
-
How to Seamlessly Import Spotify Data into IBM SPSS Modeler
Integrate Spotify data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Edit and Search External IBM Informix Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of IBM Informix to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create IBM Informix Data objects that you can access from apps and the dashboard.
-
Automated SAP BusinessObjects BI Data Replication to Teradata
Use CData Sync to Customize and automate SAP BusinessObjects BI replication to Teradata.
-
How to Query Live SAS xpt Data in Claude Desktop
Connect to and query live SAS xpt Data in Claude Desktop using CData MCP Server.
-
Integrate ZeroBounce Data in Pentaho Data Integration
Build ETL pipelines based on ZeroBounce in the Pentaho Data Integration tool.
-
Model Adobe Commerce Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Adobe Commerce, enabling the direct import of real-time Adobe Commerce.
-
How to connect to Eventbrite Data from Spring Boot
Connect to Eventbrite in a Spring Boot Application using the CData API Driver for JDBC
-
How to connect PolyBase to Shortcut
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Shortcut.
-
Create Salesforce Pardot Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Salesforce Pardot data access from reports, embedded analytics, and more.
-
Create Data Visualizations in Cognos BI with Instagram Data
Access Instagram as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Import Act CRM Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Act CRM Data and provide access to live Act CRM for custom reports in the Power BI Service.
-
Integrate with MYOB AccountRight Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy MYOB AccountRight to a JSON file on disk.
-
Create Data Visualizations Based On Google Search Results in Mode
Use CData Connect AI to connect to Google Search Results from Mode and build visualizations using live
-
Connect to Live Vertica Data in MicroStrategy through CData Connect AI
Create a live connection to Vertica Data in CData Connect AI and connect to your Vertica from MicroStrategy.
-
Connect to Rebilly Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Rebilly as an External Source in Dremio.
-
Migrating data from AlloyDB to Google BigQuery using CData SSIS Components.
Easily push Google AlloyDB to Google BigQuery using the CData SSIS Tasks for AlloyDB and Google BigQuery.
-
Import Real-Time Facebook Ads Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Facebook Ads in ColdFusion.
-
Visualize Invoiced Data in Tableau
The CData ODBC driver for Invoiced enables you integrate Invoiced into Tableau dashboards.
-
How to connect PolyBase to Sage Cloud Accounting
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Sage Business Cloud Accounting.
-
Analyze Epicor Kinetic Data in Cognos Analytics
Use CData Connect AI to connect to Epicor Kinetic Data from Cognos Analytics and analyze live Epicor Kinetic.
-
Create Datasets from Dynamics CRM in Domo Workbench and Build Visualizations of Dynamics CRM Data in Domo
Use the CData Software ODBC Driver for Dynamics CRM to create datasets from Microsoft Dynamics CRM in Domo Workbench and then build visualizations in the Domo service.
-
Connect to Real-Time Microsoft Ads Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Microsoft Ads and Dataflow to import and use Microsoft Ads in Power Apps.
-
How to Connect to Live MongoDB 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 MongoDB without replication.
-
Visualize Google Analytics Data in TIBCO Spotfire through ADO.NET
Integrate Google Analytics into dashboards in TIBCO Spotfire.
-
Access Live Salesforce Marketing Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Salesforce Marketing Cloud in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Create Data Visualizations in Cognos BI with eBay Analytics Data
Access eBay Analytics as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Automated Continuous RSS Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable RSS replication to delimited files (CSV/TSV).
-
Create Azure Data Catalog Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Azure Data Catalog data access from reports, embedded analytics, and more.
-
How to connect to Nethunt Data from Spring Boot
Connect to Nethunt in a Spring Boot Application using the CData API Driver for JDBC
-
LINQ to SAP 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 SAP Data Provider.
-
Create Datasets from Customer.io in Domo Workbench and Build Visualizations of Customer.io Data in Domo
Use the CData Software ODBC Driver for Customer.io to create datasets from Customer.io in Domo Workbench and then build visualizations in the Domo service.
-
Connect to SurveyMonkey Data in ACL Analytics
Connect to SurveyMonkey via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to SurveyMonkey.
-
Getting Started with the CData ADO.NET Provider for Pinterest
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Pinterest.
-
Prepare, Blend, and Analyze Spotify Data in Alteryx Designer (ODBC)
Build workflows to access live Spotify for self-service data analytics.
-
Build Avro-Powered Applications in Cursor with CData MCP Server
Use the CData MCP Server for Avro to explore live Avro Data in Cursor to assist with building Avro-powered applications.
-
Create SSAS Tabular Models from HubSpot Data
How to build a SQL Server Analysis Service Tabular Model from HubSpot using CData drivers.
-
How to publish and share Zoho Inventory Data dashboards with Tableau Server
The CData ODBC driver for Zoho Inventory enables you integrate Zoho Inventory into Tableau dashboards.
-
Analyze GitHub Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of GitHub and visualize live GitHub in Infragistics Reveal.
-
Automated Continuous Mouseflow Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Mouseflow replication to delimited files (CSV/TSV).
-
Access Neo4J Data in Mule Applications Using the CData JDBC Driver
Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for Neo4J.
-
Connecting GenSpark with Power BI XMLA Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Power BI XMLA without any replication or custom integration required.
-
Use Biml to Build SSIS Tasks to Replicate GitHub Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate GitHub to SQL Server.
-
Getting Started with the CData Excel Add-In for TaxJar
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for TaxJar.
-
How to Connect DBeaver to Google Spanner via a JDBC Driver
Manage Google Spanner with visual tools in DBeaver like the query browser.
-
Create Dashboards and Visualize Live Impala Data in Geckoboard
Use CData Connect AI to connect to live Apache Impala and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Amazon DynamoDB
Provide connectivity to Amazon DynamoDB through an SAP BusinessObjects universe.
-
Use Manus AI to Talk to Your JSON Services via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Manus AI agents to securely answer questions and take actions on JSON.
-
Connect to Google Campaign Manager 360 Data from a Connection Pool in Jetty
The Google Campaign Manager 360 JDBC Driver supports connection pooling: This article shows how to connect faster to Google Campaign Manager 360 from Web apps in Jetty.
-
Create Microsoft Entra ID-Connected Nintex Workflows
Use CData Connect AI to connect to Microsoft Entra ID Data from Nintex Workflow Cloud and build custom workflows using live Microsoft Entra ID.
-
Viewing Zuora Data in RAD Studio Data Explorer
How to view Zuora in RAD Studio Data Explorer using the CData ODBC Driver for Zuora.
-
Create LaunchDarkly Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time LaunchDarkly data access from reports, embedded analytics, and more.
-
Connect to ElevenLabs 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 ElevenLabs and work with ElevenLabs in your FileMaker application.
-
Connect to Yelp Data from PowerBuilder via ADO.NET
This article demonstrates how to access Yelp from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
LINQ to Opsgenie 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 Opsgenie Data Provider.
-
Getting Started with the CData Power BI Connector for Wave Financial
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Wave Financial.