CData Software - Knowledge Base
Recent Articles
-
Use Dash to Build to Web Apps on Chargebee Data
Create Python applications that use pandas and Dash to build Chargebee-connected web apps.
-
Integrating Codex CLI with Bullhorn CRM 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 with Excel Online Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Microsoft Excel Online in SnapLogic.
-
Create Informatica Mappings From/To an ODBC Data Source for LionDesk
Create an ODBC connection to LionDesk in Informatica and browse and transfer LionDesk.
-
Integrating Claude Code CLI with Timely 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.
-
Process & Analyze MySQL Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live MySQL Data.
-
Connect to Kintone Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Kintone.
-
Integrate Webex Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Webex from Informatica Cloud.
-
A PostgreSQL Interface for Timely Data using the CData ODBC Driver
Use the SQL Gateway and Timely ODBC Driver to create a PostgreSQL entry-point for data access.
-
View Reports on Real-Time Mixpanel Data in Power BI Report Server
Use the CData ODBC Driver for Mixpanel to visualize Mixpanel in Power BI Desktop and then publish them to Power BI Report Server.
-
Integrating Cursor CLI with Printful 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.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Postmark
Provide connectivity to Postmark through an SAP BusinessObjects universe.
-
Create Power BI Reports on Real-Time Azure Analysis Services Data
Use the CData ODBC Driver for Azure Analysis Services to visualize Azure Analysis Services in Power BI Desktop.
-
Configure the CData JDBC Driver for Active Directory in a Connection Pool in Tomcat
Connect to Active Directory from a connection pool in Tomcat.
-
Build Semantic Layer Views for Snapchat Ads Data in APOS Live Data Gateway
Use the CData Connector for Snapchat Ads in APOS Live Data Gateway to build Semantic Layer Views for Snapchat Ads.
-
How to Work with Shortcut Data in AWS Glue Jobs Using JDBC
Connect to Shortcut from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Automated Continuous QuickBooks Replication to IBM DB2
Use CData Sync for automated, continuous, customizable QuickBooks replication to IBM DB2.
-
How to Access ShipStation Data Using Entity Framework
This article shows how to access ShipStation using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Access Facebook Ads 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 Facebook Ads.
-
Access Live Stack Exchange Data in Coginiti Pro
Connect to and query live Stack Exchange from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Model Amazon Marketplace Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Amazon Marketplace, enabling the direct import of real-time Amazon Marketplace.
-
Connect to BigQuery Data in ACL Analytics
Connect to Google BigQuery via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Google BigQuery.
-
Visualize Live Google Campaign Manager 360 Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Google Campaign Manager 360 into custom reports in Power BI.
-
Automate Planio Data Replication to Azure Data Lake
Use CData Sync to customize and automate Planio replication to Azure Data Lake.
-
Connect to FormSite in SpagoBI
Create reports featuring live FormSite in SpagoBI Studio. Host FormSite reports on SpagoBI Server.
-
Integrate LibreChat with Live Elasticsearch Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Elasticsearch from within the chat interface.
-
Automate Samanage Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Samanage from PowerShell? This article demonstrates how to utilize the Samanage Cmdlets for tasks like connecting to Samanage, automating operations, downloading data, and more.
-
Use the CData Software ODBC Driver for Microsoft Ads in MicroStrategy
Connect to Microsoft Ads in MicroStrategy Developer using the CData Software ODBC Driver for Microsoft Ads.
-
Create Dynamic Copper Grids Using the Infragistics XamDataGrid
Learn how you can connect Copper to Infragistics XamDataGrid to build dynamic grids.
-
Build MVC Applications with Connectivity to Reckon Accounts Hosted Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Reckon Accounts Hosted from an ASP.NET MVC application.
-
Twitter Ads Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Twitter Ads facts in real time.
-
Visualize CockroachDB Data in TIBCO Spotfire through ADO.NET
Integrate CockroachDB into dashboards in TIBCO Spotfire.
-
Bidirectional Access to SpaceX Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate SpaceX in Filemaker Pro for Mac or Windows.
-
Bidirectional Access to Teradata Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Teradata in Filemaker Pro for Mac or Windows.
-
Create SSAS Tabular Models from ADP Data
How to build a SQL Server Analysis Service Tabular Model from ADP using CData drivers.
-
Establish a Live Connection with Redis Data using Tableau Bridge
The CData ODBC Driver for Redis enables you to integrate live Redis into Tableau Cloud dashboards using the Tableau Bridge.
-
Connect to Amazon S3 Data from Crystal Reports
Use CData Connect AI to connect to and report on live Amazon S3 from Crystal Reports.
-
How to Connect SingleStore Data to Gemini Enterprise via CData Connect AI
Connect CData Connect AI Remote MCP to Gemini Enterprise to securely read and take actions on live SingleStore data in real time using natural language.
-
Build Visualizations of SAP Business Warehouse Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of SAP Business Warehouse in Birst.
-
How to Query Live Elorus Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Elorus data in natural language using Python.
-
How to connect to Microsoft OneDrive Data from Spring Boot
Connect to Microsoft OneDrive in a Spring Boot Application using the CData JDBC Driver for Microsoft OneDrive
-
Connect to Oracle Eloqua Reporting Data from PowerBuilder via ADO.NET
This article demonstrates how to access Oracle Eloqua Reporting from Appeon PowerBuilder using the CData ADO.NET Provider for Oracle Eloqua Reporting.
-
Connect to Google Cloud Storage Data in RazorSQL
Connect to Google Cloud Storage from wizards and query Google Cloud Storage from the GUI in the RazorSQL database management tool.
-
Automated Continuous GitLab Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable GitLab replication to Google Cloud SQL.
-
Integrating OpenCode Terminal 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.
-
Easily Integrate Webflow Data in Lazarus Pascal IDE
Learn how to easily integrate live Webflow in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Build Apps with Live Slack in Adalo using CData Connect AI
Use CData Connect AI to integrate live Slack into the Adalo platform and build custom mobile and web applications with real-time Slack.
-
Create SSAS Tabular Models from LDAP Objects
How to build a SQL Server Analysis Service Tabular Model from LDAP using CData drivers.
-
Use the CData Software ODBC Driver for SAP Netweaver Gateway in MicroStrategy Web
Connect to SAP Netweaver Gateway in MicroStrategy Web using the CData Software ODBC Driver for SAP Netweaver Gateway.
-
Access Live Microsoft Exchange Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Microsoft Exchange from your Excel spreadsheets.
-
Import Facebook Ads Data Using Azure Data Factory
Use CData Connect AI to connect to Facebook Ads Data from Azure Data Factory and import live Facebook Ads.
-
Automate Splunk Data Replication to SAP HANA
Use CData Sync to customize and automate Splunk replication to SAP HANA.
-
How to connect to Monday.com Data from Spring Boot
Connect to Monday.com in a Spring Boot Application using the CData JDBC Driver for Monday.com
-
Visualize Live Sugar CRM Data in the Power BI Service
Use CData Connect AI to connect to live Sugar CRM and create custom reports in the Power BI Service through the On-Premises Gateway.
-
How to Connect to & Open Xero Data in Microsoft Excel
This article uses the CData ODBC driver for Xero to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Build a Singer.io Tap for Humanity With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Humanity data using
-
Use the CData Software ODBC Driver for Vimeo in SAS for Real-Time Reporting and Analytics
Connect to real-time Vimeo in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Vimeo.
-
Create Auth0 Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Auth0 data access from reports, embedded analytics, and more.
-
Create Oracle Financials Cloud-Connected Nintex Workflows
Use CData Connect AI to connect to Oracle Financials Cloud Data from Nintex Workflow Cloud and build custom workflows using live Oracle Financials Cloud.
-
Prepare, Blend, and Analyze Square Data in Alteryx Designer (Connect AI)
Build workflows to access live Square for self-service data analytics.
-
Extract, Transform, and Load Zoho Books Data in Informatica PowerCenter
Create a simple Workflow for Zoho Books in Informatica PowerCenter.
-
Connect to LeadDesk 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 LeadDesk and work with LeadDesk in your FileMaker application.
-
Prepare, Blend, and Analyze Office 365 Data in Alteryx Designer (Connect AI)
Build workflows to access live Microsoft Office 365 for self-service data analytics.
-
How to Import Data from TaxJar into Google Sheets
Import TaxJar into a Google spreadsheet that is automatically refreshed.
-
Getting Started with the CData Excel Add-In for Oracle Eloqua
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Oracle Eloqua.
-
Integrate Goose with Live Procore Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Procore from within the local AI agent.
-
Automated Continuous HubDB Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable HubDB replication to OneLake in Microsoft Fabric.
-
Use CData Connect AI to Access NetSuite SuiteAnalytics Data in Microsoft Power Pivot
Use CData Connect AI to connect to live NetSuite SuiteAnalytics in the Power Pivot business intelligence tool.
-
Create Datasets from HubSpot in Domo Workbench and Build Visualizations of HubSpot Data in Domo
Use the CData Software ODBC Driver for HubSpot to create datasets from HubSpot in Domo Workbench and then build visualizations in the Domo service.
-
Integrating Boomi Agentstudio with Elasticsearch Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Elasticsearch, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Automated Continuous Sage Cloud Accounting Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Sage Cloud Accounting replication to Google Cloud SQL.
-
Prepare, Blend, and Analyze SAP HANA Data in Alteryx Designer (ODBC)
Build workflows to access live SAP HANA for self-service data analytics.
-
How to Query Live Azure Synapse Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Azure Synapse data in natural language using Python.
-
How to Connect to Live Zoho Projects 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 Zoho Projects through natural language.
-
Connect to Smartsheet Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Smartsheet in Airbyte.
-
Build Apps with Live Clockify Data Using the Low-Code Development Platform of Mendix
Connect Clockify with Mendix to build apps using the CData API Driver for JDBC.
-
Connect to Spark Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Spark Data and connect to Apache Spark SQL in Akorbi Digital RunMyProcess.
-
How to Connect DBeaver to Dynamics 365 via a JDBC Driver
Manage Microsoft Dynamics 365 with visual tools in DBeaver like the query browser.
-
Query Sendwithus Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Sendwithus from Node.js.
-
How to Build an ETL App for ElevenLabs Data in Python with CData
Create ETL applications and real-time data pipelines for ElevenLabs in Python with petl.
-
Import Real-Time Foursquare Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Foursquare in ColdFusion.
-
How to connect to Stack Exchange Data from IntelliJ
Integrate connectivity to Stack Exchange with wizards in IntelliJ.
-
Build ServiceNow-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to ServiceNow Data from Zoho Analytics and import live ServiceNow.
-
Back Up Sage 300 to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Sage 300. In this article, we will employ an SSIS workflow to populate a database with Sage 300 data.
-
Connect to Raisers Edge NXT Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Raisers Edge NXT using standard SQL.
-
Access Live Sage 200 Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live Sage 200 data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Connect to EnterpriseDB Data in Claris FileMaker Pro
Use the CData ODBC Driver for EnterpriseDB in FileMaker Pro to connect to EnterpriseDB and work with EnterpriseDB in your FileMaker applications.
-
Use the CData Software JDBC Driver for CSV in MicroStrategy
Connect to CSV/TSV Files in MicroStrategy Developer using the CData Software JDBC Driver for CSV.
-
Build AI/ML Models with Live Avro Data using Dataiku
Connect Avro Data with Dataiku using the CData JDBC Driver for Avro.
-
Integrating Gumloop with Twitter Ads Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Twitter Ads within automated workflows.
-
Connect to EnterpriseDB Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time EnterpriseDB using standard SQL.
-
Create Informatica Mappings From/To an ODBC Data Source for Sugar CRM
Create an ODBC connection to Sugar CRM in Informatica and browse and transfer Sugar CRM.
-
Moving Data from Figshare to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Figshare data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Automated Continuous Sage 200 Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Sage 200 replication to delimited files (CSV/TSV).
-
How to create an RPA flow for Blackbaud FE NXT Data in UiPath Studio
Use the Blackbaud FE NXT ODBC Driver to create workflows that access real-time Blackbaud FE NXT without any coding.
-
Connect to and Query ElevenLabs Data in QlikView over ODBC
Create data visualizations with ElevenLabs in QlikView.
-
Perform Batch Operations with Snowflake Data in Apache NiFi
Connect to Snowflake and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Creating SAP Netweaver Gateway-Connected Applications in Unqork
You can use CData Connect AI to feed SAP Netweaver Gateway to Unqork and build custom business apps.
-
How to connect to BigCommerce Data with Squirrel SQL client
Connect to BigCommerce and execute queries in the Squirrel SQL Client.
-
Connect to Zoho Creator Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Zoho Creator as an External Source in Dremio.