CData Software - Knowledge Base
Recent Articles
-
Use Grok to Talk to Your Microsoft Dataverse 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 Microsoft Dataverse (CDS) for you.
-
Query OData Services as a MySQL Database in Node.js
Execute MySQL queries against OData from Node.js.
-
Use Dash to Build to Web Apps on PabblySubscriptions Data
Create Python applications that use pandas and Dash to build PabblySubscriptions-connected web apps.
-
How to load RabbitMQ data into Elasticsearch via Logstash
Introducing a simple method to load RabbitMQ data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
How to Build an ETL App for Parquet Data in Python with CData
Create ETL applications and real-time data pipelines for Apache Parquet in Python with petl.
-
Create Unbounce Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Unbounce data access from reports, embedded analytics, and more.
-
Use Manus AI to Talk to Your Act-On Data 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 Act-On.
-
Build an OLAP Cube in SSAS from DocuSign Data
Establish a connection to DocuSign data from SQL Server Analysis Services, and use the DocuSign Data Provider to build OLAP cubes for use in analytics and reporting.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Short.io
Provide connectivity to Short.io through an SAP BusinessObjects universe.
-
Query Paymo Data in DataGrip
Create a Data Source for Paymo in DataGrip and use SQL to query live Paymo.
-
Connect Jira Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Atlassian Jira using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Connect to Yelp Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Yelp as an External Source in Dremio.
-
Replicate DB2 for i Data to Multiple Databases
Replicate DB2 for i to disparate databases with a point-and-click configuration.
-
How to connect to QuickBooks Data with Squirrel SQL client
Connect to QuickBooks Desktop and execute queries in the Squirrel SQL Client.
-
Build Greenplum-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Greenplum Data from Zoho Analytics and import live Pivotal GreenPlum.
-
Write a Simple Go Application to work with Templated Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Templated.
-
Validate Dropbox Data with QuerySurge
Access and validate Dropbox in QuerySurge using the CData JDBC Driver.
-
Publish Reports with Kintone Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Kintone.
-
How to Query Live Spotify Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Spotify data in natural language using Python.
-
Integrate Goose with Live Microsoft Ads Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Microsoft Ads from within the local AI agent.
-
Publish Elasticsearch-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Elasticsearch.
-
Query, Visualize, and Share live Klaviyo Data in Redash
Use CData Connect AI to connect to live Klaviyo in Redash for querying, visualizing, and sharing.
-
Integrate Real-Time Access to DocuSign in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to DocuSign in real time.
-
View Reports on Real-Time Azure Data Lake Storage Data in Power BI Report Server
Use the CData ODBC Driver for Azure Data Lake Storage to visualize Azure Data Lake Storage in Power BI Desktop and then publish them to Power BI Report Server.
-
How to use SQLAlchemy ORM to access Brex Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Brex.
-
Build Visualizations of HubSpot Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of HubSpot in Birst.
-
Create Amazon Marketplace-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Amazon Marketplace Data from OutSystems and build custom enterprise apps using live Amazon Marketplace.
-
Getting Started with the CData Excel Add-In for Pipeliner CRM
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Pipeliner CRM.
-
Use the CData Software ODBC Driver for Omnisend in MicroStrategy
Connect to Omnisend in MicroStrategy Developer using the CData Software ODBC Driver for Omnisend.
-
Use the CData API Server to Access Highrise Data in Microsoft PowerPivot
Use the CData API Server to connect to live Highrise CRM in the Power Pivot business intelligence tool.
-
Establish a Live Connection with Jumpseller Data using Tableau Bridge
The CData ODBC Driver for Jumpseller enables you to integrate live Jumpseller into Tableau Cloud dashboards using the Tableau Bridge.
-
Connect to HBase Data in ACL Analytics
Connect to Apache HBase via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Apache HBase.
-
Use the CData Software ODBC Driver for Paddle in SAS for Real-Time Reporting and Analytics
Connect to real-time Paddle in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Paddle.
-
Create Informatica Mappings From/To a JDBC Data Source for BambooHR
Create BambooHR data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Moving Data from Access to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Access data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Automated Continuous HBase Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable HBase replication to Google BigQuery.
-
Automate Hugging Face Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Hugging Face from PowerShell? This article demonstrates how to utilize the Hugging Face Cmdlets for tasks like connecting to Hugging Face, automating operations, downloading data, and more.
-
Connect to TigerGraph Data in RazorSQL
Connect to TigerGraph from wizards and query TigerGraph from the GUI in the RazorSQL database management tool.
-
Integrate Live ShipStation Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf
-
Access ADP Data from MySQL in PHP
Connect to ADP through the standard MySQL libraries in PHP.
-
Integrate with OneNote Data in JReport Designer
Create charts and reports based on Microsoft OneNote in JReport Designer.
-
How to Connect DBeaver to eBay Analytics via a JDBC Driver
Manage eBay Analytics with visual tools in DBeaver like the query browser.
-
Use Agno to Talk to Your Cassandra 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 Apache Cassandra for you.
-
Build Visualizations of MailChimp Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of MailChimp in Birst.
-
Easily Integrate Guru Data in Lazarus Pascal IDE
Learn how to easily integrate live Guru in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Create Power BI Reports on Real-Time Drift Data
Use the CData ODBC Driver for Drift to visualize Drift in Power BI Desktop.
-
How to connect to Front Data with Squirrel SQL client
Connect to Front and execute queries in the Squirrel SQL Client.
-
Connect to Dynamics 365 Business Central Data in Claris FileMaker Pro
Use the CData ODBC Driver for Dynamics 365 Business Central in FileMaker Pro to connect to Dynamics 365 Business Central and work with Dynamics 365 Business Central in your FileMaker applications.
-
Automated Continuous Testmonitor Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Testmonitor replication to Google BigQuery.
-
Integrating Google Directory Data in Talend Cloud Data Management Platform
Connect Google Directory Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Google Directory.
-
Add PingOne Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for PingOne with the Informatica Enterprise Data Catalog to classify and organize data.
-
How to Access Live Zoho Projects Data in Visual Studio Code via Cline
Run CData MCP Server for Zoho Projects on Windows Subsytem for Linux (WSL) and connect to live Zoho Projects from the Cline extension in Visual Studio Code.
-
Access Live Smartsheet Data in TIBCO Data Virtualization
Use the Smartsheet Tibco DV Adapter to create a Smartsheet data source in TIBCO Data Virtualization Studio and gain access to live Smartsheet from your TDV Server.
-
Replicate LightSpeedRetail Data from PowerShell
Write a quick PowerShell script to query LightSpeedRetail. Use connectivity to the live data to replicate LightSpeedRetail to SQL Server.
-
How to Query Live Intercom Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Intercom data in natural language using Python.
-
Connect to Wave Financial Data in NetBeans
Connect to Wave Financial in NetBeans with the data source configuration wizard.
-
Getting Started with the CData Power BI Connector for Acumatica
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Acumatica.
-
Enable the Pinecone JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Pinecone.
-
Using the CData Software ODBC Driver for Close in PyCharm
Connect to Close as an ODBC data source in PyCharm using the CData Software ODBC Driver for Close.
-
How to Query Live Vault CRM Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Veeva Vault & Vault CRM data in natural language using Python.
-
Access Live Zoom Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Zoom from your Google Sheets.
-
How to Access Certinia Data Using Entity Framework
This article shows how to access Certinia using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Query Google Campaign Manager 360 Data in DataGrip
Create a Data Source for Google Campaign Manager 360 in DataGrip and use SQL to query live Google Campaign Manager 360.
-
Import and Visualize Freshdesk Data in Power View
Create data visualizations based on Freshdesk in Excel.
-
Design BIRT Reports on SQL Analysis Services Data
Provide current SQL Analysis Services to your embedded analytics.
-
Connect and Visualize Live Google Sheets Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Google Sheets into the Databricks platform and create visualization dashboards with real-time Google Sheets.
-
Automated Continuous ZarMoney Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable ZarMoney replication to delimited files (CSV/TSV).
-
How to load FreshBooks data into Elasticsearch via Logstash
Introducing a simple method to load FreshBooks data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Use Agno to Talk to Your Amazon Marketplace 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 Amazon Marketplace for you.
-
Access Live Google Spanner Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live Google Spanner data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Auth0
Provide connectivity to Auth0 through an SAP BusinessObjects universe.
-
Integrating LlamaIndex with Smartsheet Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Smartsheet in real time.
-
Automated Continuous SAS xpt Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable SAS xpt replication to Google BigQuery.
-
Build Dashboards with Rootly Data in Dundas BI
Create dynamic dashboards and perform analytics based on Rootly in Dundas BI.
-
Easily Integrate Paylocity Data in Lazarus Pascal IDE
Learn how to easily integrate live Paylocity in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Automated Continuous Shopify Replication to Databricks
Use CData Sync for automated, continuous, customizable Shopify replication to Databricks.
-
How to Query Live Salesforce Pardot Data in Perplexity MacOS Desktop
Connect to and query live Salesforce Pardot Data in Perplexity Desktop using CData MCP Server.
-
How to connect to Acumatica Data with Squirrel SQL client
Connect to Acumatica ERP and execute queries in the Squirrel SQL Client.
-
A PostgreSQL Interface for Salesforce Marketing Data (MySQL Remoting via JDBC)
Use the Remoting features of the Salesforce Marketing JDBC Driver to create a PostgreSQL entry-point for data access.
-
Establish a Live Connection with Chargebee Data using Tableau Bridge
The CData ODBC Driver for Chargebee enables you to integrate live Chargebee into Tableau Cloud dashboards using the Tableau Bridge.
-
Connect to Paylocity Data from AWS Glue
Use CData Connect AI to gain access to live Paylocity from your AWS Glue jobs.
-
Automated Continuous Salesforce Replication to Snowflake
Use CData Sync for automated, continuous, customizable Salesforce replication to Snowflake.
-
Work with Live NetSuite SuiteAnalytics Data in Power Query
Use CData Connect AI to connect to NetSuite SuiteAnalytics and work with live NetSuite SuiteAnalytics in Microsoft Power Query.
-
How to connect PolyBase to Power BI XMLA
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Power BI XMLA.
-
Back Up CloudConvert to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData API Driver for ADO.NET. In this article, we will employ an SSIS workflow to populate a database with CloudConvert data.
-
Work with SAP Concur Data in FoxPro
Load SAP Concur into a FoxPro database. This article includes full code and a walk-through of the process.
-
Access Live Salesforce CRM Analytics Data in Coginiti Pro
Connect to and query live Salesforce CRM Analytics from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
How to use SQLAlchemy ORM to access Act CRM Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Act CRM.
-
Create SSAS Tabular Models from AfterShip Data
How to build a SQL Server Analysis Service Tabular Model from AfterShip using CData drivers.
-
How to Connect to Live Azure DevOps 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 Azure DevOps for you.
-
How to connect Amazon QuickSight to DocuSign Data
Create a connection to DocuSign in CData Connect AI and insert DocuSign into Amazon QuickSight SPICE to build interactive dashboards.
-
Connect to Nethunt Data from PowerBuilder via JDBC
This article demonstrates how to access Nethunt from PowerBuilder using the Nethunt JDBC Driver.
-
Consume Zoho Creator OData Feeds in PowerBuilder
This article demonstrates how to consume Zoho Creator as OData feeds from PowerBuilder using the API Server.
-
Publish Crystal Reports on Auth0 Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Auth0.
-
Getting Started with the CData Excel Add-In for Pinterest
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Pinterest.
-
Connect to Redis from Asprova with CData Software ODBC Driver for Redis
This article shows how to connect faster to Redis data from Asprova.
-
Spark Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Apache Spark SQL through CData Connect AI using different applications and tools.
-
Create Reports with Adobe Commerce Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Adobe Commerce.
-
Access Live BambooHR Data in Roo Code via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Roo Code agents to securely access and build applications with live BambooHR through MCP integration.
-
Operational Reporting on Azure Analysis Services Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Azure Analysis Services.