CData Software - Knowledge Base
Recent Articles
-
Integrating Gumloop with WordPress Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on WordPress within automated workflows.
-
Use Dash to Build to Web Apps on CircleCI Data
Create Python applications that use pandas and Dash to build CircleCI-connected web apps.
-
Migrating data from Oracle Financials Cloud to Databricks using CData SSIS Components.
Easily push Oracle Financials Cloud to Databricks using the CData SSIS Tasks for Oracle Financials Cloud and Databricks.
-
Connect to Oracle Eloqua Data in HULFT Integrate
Connect to Oracle Eloqua as a JDBC data source in HULFT Integrate
-
Visualize QuickBooks Online Data in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load QuickBooks Online into TIBCO Spotfire.
-
Use Microsoft Copilot Studio to talk to your Sybase IQ Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Microsoft Copilot Studio to securely answer questions and take actions on your Sybase IQ for you.
-
How to integrate Tickspot with Apache Airflow
Access and process Tickspot in Apache Airflow using the CData JDBC Driver.
-
Consume Eventbrite OData Feeds in PowerBuilder
This article demonstrates how to consume Eventbrite as OData feeds from PowerBuilder using the API Server.
-
Getting Started with the CData SSIS Components for Oracle Eloqua Reporting
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Oracle Eloqua Reporting.
-
Access Live DB2 Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live DB2 data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Connect to Real-Time Google Campaign Manager 360 Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Google Campaign Manager 360 and Dataflow to import and use Google Campaign Manager 360 in Power Apps.
-
Integrating Gumroad Data in Talend Cloud Data Management Platform
Connect Gumroad Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Use ChatGPT to Talk to Your Box 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 Box for you.
-
Build HDFS-Powered Applications in Cursor with CData MCP Server
Use the CData MCP Server for HDFS to explore live HDFS Data in Cursor to assist with building HDFS-powered applications.
-
Create LinkedIn Ads Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time LinkedIn Ads data access from reports, embedded analytics, and more.
-
Publish Crystal Reports on WordPress Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date WordPress.
-
Analyze Outreach.io Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Outreach.io in Microsoft R Open.
-
Establish a Live Connection with Sendwithus Data using Tableau Bridge
The CData ODBC Driver for Sendwithus enables you to integrate live Sendwithus into Tableau Cloud dashboards using the Tableau Bridge.
-
Establish a Live Connection with Dropbox Data using Tableau Bridge
The CData ODBC Driver for Dropbox enables you to integrate live Dropbox into Tableau Cloud dashboards using the Tableau Bridge.
-
Connect Google Analytics to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Google Analytics using the CData Python MCP Server.
-
Analyze GraphQL Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze GraphQL in Microsoft R Open.
-
Create SSAS Tabular Models from Access Data
How to build a SQL Server Analysis Service Tabular Model from Microsoft Access using CData drivers.
-
Integrating LangGraph with SAP Ariba Source Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on SAP Ariba Source within automated workflows.
-
How to integrate Metabase with eBay Data
Use CData Connect AI to connect to live eBay and create an interactive dashboard in Metabase from eBay.
-
Integrating Codex CLI with Coda 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 Cursor with Live Google Calendar Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Google Calendar from within the editor.
-
Vercel Reporting in OBIEE with the Vercel JDBC Driver
Deploy the Vercel JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Easily Integrate Eventbrite Data in Lazarus Pascal IDE
Learn how to easily integrate live Eventbrite in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Build Figshare-Powered Applications in Claude Code with CData MCP Server
Use the CData API Driver for MCP Server to explore live Figshare Data in Claude Code to assist with building Figshare-powered applications.
-
Build Automated Workflows with Live Oracle SCM Data in Workato
Use CData Connect AI to connect to live Oracle SCM and build automated workflows in Workato.
-
Access Live Insightly Data in TIBCO Data Virtualization
Use the CData API Driver for Tibco DV to create a Insightly data source in TIBCO Data Virtualization Studio and gain access to live Insightly from your TDV Server.
-
Automate Cloudant Integration Tasks from PowerShell
Are you in search of a quick and easy way to access IBM Cloudant from PowerShell? This article demonstrates how to utilize the Cloudant Cmdlets for tasks like connecting to IBM Cloudant, automating operations, downloading data, and more.
-
Process & Analyze Avaza Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Avaza Data.
-
Import Real-Time HCL Domino Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use HCL Domino in ColdFusion.
-
Create ZarMoney Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time ZarMoney data access from reports, embedded analytics, and more.
-
Connect to Procore in SpagoBI
Create reports featuring live Procore in SpagoBI Studio. Host Procore reports on SpagoBI Server.
-
Query PhantomBuster Data in ColdFusion
Write standard ColdFusion data access code to connect to PhantomBuster.
-
Connect to Delighted Data from PowerBuilder via ADO.NET
This article demonstrates how to access Delighted from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Automated Continuous Cloudflare Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Cloudflare replication to AlloyDB.
-
Operational Reporting on OpenWeatherMap Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote OpenWeatherMap.
-
Integrate Avalara AvaTax Data in Pentaho Data Integration
Build ETL pipelines based on Avalara AvaTax in the Pentaho Data Integration tool.
-
How to Work with Microsoft Entra ID Data in ETL Validator JDBC
Connect to Microsoft Entra ID from ETL Validator jobs using the CData Software JDBC Driver.
-
Bind Live Google Search Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Google Search data
-
How to Connect to Live Monday.com Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Monday.com securely in real time.
-
Getting Started with the CData ODBC Driver for Mailjet
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Mailjet.
-
LINQ to Bitbucket 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 Bitbucket Data Provider.
-
Integrate Open WebUI with Live Greenhouse Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Greenhouse from within the chat interface.
-
Create Active Directory-Connected Dashboards in Grafana
Connect to Active Directory Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Active Directory.
-
Build MySQL Visualizations in Tableau Cloud
Use CData Connect AI to connect to live MySQL and build visualizations in Tableau Cloud.
-
Process & Analyze Pipedrive Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Pipedrive Data.
-
Query JobNimbus Data as a MySQL Database in Node.js
Execute MySQL queries against JobNimbus from Node.js.
-
Use the CData ODBC Driver for Slack in Microsoft Power Query
You can use the CData Slack ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Slack into Microsoft Power Query.
-
How to create an RPA flow for JSON Services in UiPath Studio
Use the JSON ODBC Driver to create workflows that access real-time JSON without any coding.
-
How to Create Power BI Visual Reports with Real-Time Beeminder Data
Use CData Power BI Connectors to visualize Beeminder in Power BI.
-
Connect to Tally Data from PowerBuilder via JDBC
This article demonstrates how to access Tally ERP from PowerBuilder using the Tally JDBC Driver.
-
Import and Visualize Reckon Accounts Hosted Data in Power View
Create data visualizations based on Reckon Accounts Hosted in Excel.
-
Connect to Stack Exchange Data in Jaspersoft Studio
Execute SQL to remote Stack Exchange in Jaspersoft Studio.
-
Add Zoho Inventory Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Zoho Inventory with the Informatica Enterprise Data Catalog to classify and organize data.
-
Prepare, Blend, and Analyze LDAP Objects in Alteryx Designer (ODBC)
Build workflows to access live LDAP for self-service data analytics.
-
Getting Started with the CData ADO.NET Provider for Autopilot
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Create Attio Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Attio data access from reports, embedded analytics, and more.
-
Build Data Flows from Adobe Experience Manager to SQL Server using SSIS
Easily back up Adobe Experience Manager to SQL Server using the SSIS components for Adobe Experience Manager.
-
How to Query Live PolarTeamPro Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live PolarTeamPro data in natural language using Python.
-
Add Pipeliner CRM Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Pipeliner CRM with the Informatica Enterprise Data Catalog to classify and organize data.
-
Getting Started with the CData Excel Add-In for Facebook
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Facebook.
-
Analyze Cassandra Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Apache Cassandra with the CData JDBC Driver for Cassandra.
-
Integrating GitHub Copilot CLI with Paylocity 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.
-
Automated Continuous Reckon Replication to SQLite
Use CData Sync for automated, continuous, customizable Reckon replication to SQLite.
-
Easily Integrate Dynamics 365 Business Central Data in Lazarus Pascal IDE
Learn how to easily integrate live Dynamics 365 Business Central in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Integrate Datadog with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Datadog with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Datadog.
-
Integrate AdRoll with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate AdRoll with External Services.
-
Edit and Search Sage Cloud Accounting External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of Sage Business Cloud Accounting to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create Sage Cloud Accounting objects that you can access from apps and the dashboard.
-
Natively Connect to Greenplum Data in PHP
The CData ODBC driver for Greenplum enables you to create PHP applications with connectivity to Pivotal GreenPlum. Leverage the native support for ODBC in PHP.
-
Analyze Twilio Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Twilio from Power Pivot. You will use the Table Import Wizard to load Twilio. You can visually build the import query or use any SQL supported by the driver.
-
Automated Continuous Asana Replication to Databricks
Use CData Sync for automated, continuous, customizable Asana replication to Databricks.
-
Model Google Ads Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Google Ads, enabling the direct import of real-time Google Ads.
-
Build MVC Applications with Connectivity to Short.io Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Short.io from an ASP.NET MVC application.
-
Query Active Directory Data in DataGrip
Create a Data Source for Active Directory in DataGrip and use SQL to query live Active Directory.
-
How to import SAP HANA XS Advanced Data into Apache Solr
Use the CData Software JDBC Driver for SAP HANA XS Advanced in Data Import Handler and create an automated import of SAP HANA XS Advanced to Apache Solr Enterprise Search platform.
-
Access Live Typeform Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Typeform into the statistical analysis tools available in SAS JMP. This article shows how to use Typeform in the Graph Builder and Query Builder.
-
Create Informatica Mappings From/To a JDBC Data Source for Opsgenie
Create Opsgenie data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
How to work with Accelo Data in Apache Spark using SQL
Access and process Accelo Data in Apache Spark using the CData Software JDBC Driver.
-
How to Connect DBeaver to SendGrid via a JDBC Driver
Manage SendGrid with visual tools in DBeaver like the query browser.
-
Write a Simple Go Application to work with BigQuery Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Google BigQuery.
-
Build Zoom-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Zoom.
-
Automated Continuous Shortcut Replication to SingleStore
Use CData Sync for automated, continuous, customizable Shortcut replication to SingleStore.
-
Create Reports from Act CRM Data in Looker Studio
Use CData Connect AI to gain access to live Act CRM and create custom reports in Looker Studio.
-
Creating Bullhorn CRM-Connected Applications in Unqork
You can use CData Connect AI to feed Bullhorn CRM to Unqork and build custom business apps.
-
Automated Oracle Data Replication to Teradata
Use CData Sync to Customize and automate Oracle Database replication to Teradata.
-
Validate Oracle Eloqua Data with QuerySurge
Access and validate Oracle Eloqua in QuerySurge using the CData JDBC Driver.
-
Automated Continuous Notion Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Notion replication to delimited files (CSV/TSV).
-
Coda Reporting in OBIEE with the Coda JDBC Driver
Deploy the Coda JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Onfleet Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Onfleet facts in real time.
-
Connect to SAP Netweaver Gateway Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live SAP Netweaver Gateway from Filemaker Pro on Mac.
-
How to create eBay federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for eBay in MySQL .
-
How to connect and process HCL Domino from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live HCL Domino.
-
How to Build an ETL App for Trello Data in Python with CData
Create ETL applications and real-time data pipelines for Trello in Python with petl.
-
Visualize Zoho Projects Data in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load Zoho Projects into TIBCO Spotfire.
-
Replicate PostgreSQL Data from PowerShell
Write a quick PowerShell script to query PostgreSQL. Use connectivity to the live data to replicate PostgreSQL to SQL Server.
-
Natively Connect to PingOne Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to PingOne. Leverage the native support for ODBC in PHP.