CData Software - Knowledge Base
Recent Articles
-
Use Dash to Build to Web Apps on Clari Data
Create Python applications that use pandas and Dash to build Clari-connected web apps.
-
Access Live JSON Services in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live JSON from your Excel spreadsheets.
-
Bridge Certinia Connectivity with Apache NiFi
Access and process Certinia in Apache NiFi using the CData JDBC Driver.
-
Connect to Spark Data in Ruby
Connect to Apache Spark SQL in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Publish LionDesk-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live LionDesk.
-
Integrating Kiro CLI with JDBC-ODBC Bridge 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.
-
Import and Visualize Hacker News Data in Power View
Create data visualizations based on Hacker News in Excel.
-
Integrating ShipEngine Data in Talend Cloud Data Management Platform
Connect ShipEngine Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Use the CData Software ODBC Driver for QuickBooks Online in MicroStrategy
Connect to QuickBooks Online in MicroStrategy Developer using the CData Software ODBC Driver for QuickBooks Online.
-
Build Procore-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Procore and build Procore-connected web apps with Axios.
-
Create Reports with Highrise Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Highrise CRM.
-
Integrate Microsoft Exchange Data into Power Automate Desktop using CData Connect
CData Connect for Microsoft Exchange Data enables you to integrate Microsoft Exchange into workflows built using Microsoft Power Automate Desktop.
-
Automate Dynamics CRM Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Microsoft Dynamics CRM from PowerShell? This article demonstrates how to utilize the Dynamics CRM Cmdlets for tasks like connecting to Microsoft Dynamics CRM, automating operations, downloading data, and more.
-
Connect to SendInBlue in SpagoBI
Create reports featuring live SendInBlue in SpagoBI Studio. Host SendInBlue reports on SpagoBI Server.
-
How to Query OnePageCrm Data in MySQL Workbench
Execute MySQL queries against live OnePageCrm from MySQL Workbench.
-
Build AI/ML Models with Live Oracle HCM Cloud Data using Dataiku
Connect Oracle HCM Cloud Data with Dataiku using the CData JDBC Driver for Oracle HCM Cloud.
-
Automated Continuous Cloudflare Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Cloudflare replication to Apache Kafka.
-
Integrate Live Gorgias Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Gorgias to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Automated Continuous SageHR Replication to IBM DB2
Use CData Sync for automated, continuous, customizable SageHR replication to IBM DB2.
-
Model MongoDB Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and MongoDB, enabling the direct import of real-time MongoDB.
-
Operational Reporting on CampaignMonitor Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote CampaignMonitor.
-
Connect to ScrapingBee Data in DBArtisan
Use wizards in DBArtisan to configure ScrapingBee as a data source.
-
Feed Azure Data Catalog Data into FineReport
How to set Azure Data Catalog as a JDBC data source in FineReport.
-
How to Connect to Live Neo4J Data from Gemini CLI (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Gemini CLI to securely read and take actions on your Neo4J for you.
-
How to Query Live Active Directory Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Active Directory data in natural language using Python.
-
Getting Started with the CData Python Connector for WordPress
Learn to install and license the CData Python Connector
-
DataBind Controls to Act CRM Data in Delphi
DataBind to Act CRM in Delphi with standard data access components and controls.
-
Publish Reports with Adobe Target Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Adobe Target.
-
Replicate Samanage Data in Heroku for Use in Salesforce Connect
Replicate Samanage to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Automated Continuous Drip Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Drip replication to Apache Kafka.
-
Build Automated Act CRM-Connected Workflows in Zapier
Use CData Connect AI to connect to live Act CRM and build automated workflows in Zapier.
-
Build MVC Applications with Connectivity to Pipeline CRM Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Pipeline CRM from an ASP.NET MVC application.
-
Getting Started with the CData ADO.NET Provider for Figshare
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Visualize Live Workday Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Workday into custom reports in Power BI.
-
Automated Continuous CampaignMonitor Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable CampaignMonitor replication to Azure SQL Database.
-
Build a Simple VCL Application for Xero Data
How to build a simple VCL Application to view Xero Accounting in RAD Studio using the CData ODBC Driver for Xero.
-
Automated Continuous Twitter Ads Replication to SQLite
Use CData Sync for automated, continuous, customizable Twitter Ads replication to SQLite.
-
Create Data Visualizations Based On Greenhouse Data in Mode
Use CData Connect AI to connect to Greenhouse Data from Mode and build visualizations using live
-
How to Visualize SQL Analysis Services Data in Python with pandas via CData Connect AI
Use the CData Connect AI Python SDK with pandas and Matplotlib to analyze and visualize live SQL Analysis Services in Python.
-
Create Data Visualizations Based On Excel Online Data in Mode
Use CData Connect AI to connect to Excel Online Data from Mode and build visualizations using live
-
DataBind Controls to Copper Data in Delphi
DataBind to Copper in Delphi with standard data access components and controls.
-
Access Live Presto Data in AWS Lambda
Connect to live Presto in AWS Lambda using the CData JDBC Driver.
-
How to connect to Freshdesk Data from IntelliJ
Integrate connectivity to Freshdesk with wizards in IntelliJ.
-
Getting Started with the CData Excel Add-In for Zoho CRM
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Zoho CRM.
-
How to Connect to & Open Missive Data in Microsoft Excel
This article uses the CData ODBC driver for Missive to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Creating Asana-Connected Applications in Unqork
You can use CData Connect AI to feed Asana to Unqork and build custom business apps.
-
Integrate Oracle Eloqua Reporting with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Oracle Eloqua Reporting with External Services.
-
Connect to and Visualize Live LionDesk Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live LionDesk.
-
Integrating GitHub Copilot CLI with SAP Netweaver Gateway 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 Browserless Data from PowerBuilder via ADO.NET
This article demonstrates how to access Browserless from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Integrate Live Salesforce CRM Analytics Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Salesforce CRM Analytics from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Salesforce CRM Analytics.
-
Connect to Spotify Data in Aqua Data Studio
Access Spotify from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Getting Started with the CData Python Connector for AfterShip
Learn to install and license the CData Python Connector
-
Integrate Trello Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Trello and integrate live Trello into your Power Automate tasks.
-
Use the CData Software ODBC Driver for Pipedrive in MicroStrategy
Connect to Pipedrive in MicroStrategy Developer using the CData Software ODBC Driver for Pipedrive.
-
Create Data Visualizations Based On Zoho CRM Data in Mode
Use CData Connect AI to connect to Zoho CRM Data from Mode and build visualizations using live
-
Migrating data from Helpscout to Google BigQuery using CData SSIS Components.
Easily push Helpscout to Google BigQuery using the CData SSIS Tasks for Helpscout and Google BigQuery.
-
Integrating Codex CLI with Authorize.Net 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 Seamlessly Import Workable Data into IBM SPSS Modeler
Integrate Workable data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Connect to Twilio Data from a Connection Pool in Jetty
The Twilio JDBC Driver supports connection pooling: This article shows how to connect faster to Twilio from Web apps in Jetty.
-
Create YouTube Analytics-Connected Business Apps in AppSheet
Connect to YouTube Analytics Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to YouTube Analytics.
-
Build AI/ML Models with Live ZarMoney Data using Dataiku
Connect ZarMoney Data with Dataiku using the CData API Driver for JDBC.
-
Prepare, Blend, and Analyze LinkedIn Ads Data in Alteryx Designer (Connect AI)
Build workflows to access live LinkedIn Ads for self-service data analytics.
-
How to Import Data from RSS into Google Sheets
Import RSS Feeds into a Google spreadsheet that is automatically refreshed.
-
Replicate Quickbase Data in Heroku for Use in Salesforce Connect
Replicate Quickbase to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Automate Dynamics CRM Data Replication to SAP HANA
Use CData Sync to customize and automate Microsoft Dynamics CRM replication to SAP HANA.
-
Analyze EnterpriseDB Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of EnterpriseDB and visualize EnterpriseDB in SAP Analytics Cloud.
-
Bidirectional Access to Act-On Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Act-On in Filemaker Pro for Mac or Windows.
-
Getting Started with the CData Excel Add-In for Salesloft
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Salesloft.
-
Create Apps from GraphQL Data in Qlik Sense Cloud
Use CData Connect AI to connect to GraphQL Data and build apps from live GraphQL in Qlik Sense Cloud.
-
Building Dynamic Web Pages with Databricks Data Using AngularJS
Create single-page applications with live connectivity to Databricks using the CData API Server.
-
Replicate Monday.com Data from PowerShell
Write a quick PowerShell script to query Monday.com. Use connectivity to the live data to replicate Monday.com to SQL Server.
-
Use Claude to Talk to Your Snowflake Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your Snowflake for you.
-
Connect to LinkedIn Ads Data in DBArtisan
Use wizards in DBArtisan to configure LinkedIn Ads as a data source.
-
Visualize Teamwork Data in TIBCO Spotfire through ADO.NET
Integrate Teamwork into dashboards in TIBCO Spotfire.
-
How to Query GraphQL Data in MySQL Workbench
Execute MySQL queries against live GraphQL from MySQL Workbench.
-
Enable the Gumroad JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Gumroad.
-
Query Hive Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Hive entities in PHP by modeling them as objects.
-
Connect to ClickUp Data in Ruby
Connect to ClickUp in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Explore Geographical Relationships in Sage Intacct Data with Power Map
Create data visualizations with Sage Intacct in Power Map.
-
Analyze Salesforce Data 360 Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Salesforce Data 360 in Microsoft R Open.
-
How to Connect to Live HubSpot Data from OpenAI Python Applications (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable OpenAI-powered Python applications to securely read and take actions on your HubSpot through natural language.
-
Integrate Open WebUI with Live HCL Domino Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live HCL Domino from within the chat interface.
-
How to connect and process Shortcut from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Shortcut.
-
Integrating Kiro CLI with EnterpriseDB 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.
-
Access Live Slack Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Slack into the statistical analysis tools available in SAS JMP. This article shows how to use Slack in the Graph Builder and Query Builder.
-
Integrate Open WebUI with Live QuickBooks Online Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live QuickBooks Online from within the chat interface.
-
Working with Dynamics NAV Data in LINQPad
Execute LINQ queries to Microsoft Dynamics NAV in LINQPad.
-
Manage Opsgenie Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Opsgenie.
-
A PostgreSQL Interface for YouTube Analytics Data using the CData ODBC Driver
Use the SQL Gateway and YouTube Analytics ODBC Driver to create a PostgreSQL entry-point for data access.
-
Bidirectional Access to Moosend Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Moosend in Filemaker Pro for Mac or Windows.
-
Use the CData Software ODBC Driver for Vercel in MicroStrategy Desktop
Connect to Vercel in MicroStrategy Desktop using the CData Software ODBC Driver for Vercel.
-
Extract, Transform, and Load Jumpseller Data in Informatica PowerCenter
Create a simple Workflow for Jumpseller in Informatica PowerCenter.
-
Use the CData Software JDBC Driver for Airtable in MicroStrategy Web
Connect to Airtable in MicroStrategy Web using the CData Software JDBC Driver for Airtable.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Snowflake
Provide connectivity to Snowflake through an SAP BusinessObjects universe.
-
Use ChatGPT to Talk to Your Neo4J 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 Neo4J for you.
-
Use the CData Software JDBC Driver for Drip in MicroStrategy
Connect to Drip in MicroStrategy Developer using the CData Software JDBC Driver for Drip.
-
Access Live MariaDB 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 MariaDB through MCP integration.
-
Visualize Live Zuora Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Zuora into custom reports in Power BI.
-
Build Confluence Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Atlassian Confluence and build visualizations in Tableau Cloud.