CData Software - Knowledge Base
Recent Articles
-
How to connect and process CampaignMonitor data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live CampaignMonitor data.
-
Integrate with Pingdom Data in JReport Designer
Create charts and reports based on Pingdom data in JReport Designer.
-
Automated Continuous Confluence Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Confluence data replication to OneLake in Microsoft Fabric.
-
Automate Perplexity Data Replication to Azure Synapse
Use CData Sync to customize and automate Perplexity data replication to Azure Synapse.
-
REST Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on REST facts in real time.
-
Analyze SAP Ariba Source Data in Cognos Analytics
Use CData Connect AI to connect to SAP Ariba Source Data from Cognos Analytics and analyze live SAP Ariba Source data.
-
Create Informatica Mappings From/To an ODBC Data Source for Mouseflow
Create an ODBC connection to Mouseflow in Informatica and browse and transfer Mouseflow data.
-
How to Easily Query Superchat Data in OpenOffice Base
Connect to Superchat data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Automate Snapchat Ads Data Replication to Azure Data Lake
Use CData Sync to customize and automate Snapchat Ads data replication to Azure Data Lake.
-
Build Apps with Live Discourse Data Using the Low-Code Development Platform of Mendix
Connect Discourse data with Mendix to build apps using the CData API Driver for JDBC.
-
How to create Visio diagrams from Microsoft Ads Data
Automatically update Microsoft Ads data with the changes you make to Visio master shapes.
-
Bridge Kintone Connectivity with Apache NiFi
Access and process Kintone data in Apache NiFi using the CData JDBC Driver.
-
LINQ to Invoiced 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 Invoiced Data Provider.
-
How to publish and share Bullhorn CRM Data dashboards with Tableau Server
The CData ODBC driver for Bullhorn CRM enables you integrate Bullhorn CRM data into Tableau dashboards.
-
Connect to Box Data in Google Apps Script via Connect AI
Use CData Connect AI to access Box data in Google Apps Script.
-
How to Connect to Live XML 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 XML data for you.
-
Use the CData ODBC Driver for SendPulse in Microsoft Power Query
You can use the CData SendPulse ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import SendPulse data into Microsoft Power Query.
-
MarkLogic Reporting in OBIEE with the MarkLogic JDBC Driver
Deploy the MarkLogic JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Design BIRT Reports on Sage Cloud Accounting Data
Provide current Sage Cloud Accounting data to your embedded analytics.
-
Bidirectional Access to Microsoft Exchange Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Microsoft Exchange data in Filemaker Pro for Mac or Windows.
-
Integrate Tally Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Tally data from Informatica Cloud.
-
Integrate OpenCode with Live Adobe Target Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable OpenCode to securely access and query live Adobe Target data from within your AI coding agent.
-
Connect to Cloudant Data from PowerBuilder via JDBC
This article demonstrates how to access Cloudant data from PowerBuilder using the Cloudant JDBC Driver.
-
How to Seamlessly Import Hubstaff Data into IBM SPSS Modeler
Integrate Hubstaff data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Connect and Visualize Live Jira Assets Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Jira Assets data into the Databricks platform and create visualization dashboards with real-time Jira Assets data.
-
Build Semantic Layer Views for Clio Data in APOS Live Data Gateway
Use the CData Connector for Clio in APOS Live Data Gateway to build Semantic Layer Views for Clio data.
-
Connect to Timely Data from AWS Glue
Use CData Connect AI to gain access to live Timely data from your AWS Glue jobs.
-
Use the CData ODBC Driver for Clari from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Clari to connect to Clari data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Clari data in Excel.
-
How to load ConvertKit data into Elasticsearch via Logstash
Introducing a simple method to load ConvertKit data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Deploy the ADO.NET Provider for Pinterest on an SSRS Report Server
Connect to Pinterest data from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.
-
Query Confluence Data in DataGrip
Create a Data Source for Confluence in DataGrip and use SQL to query live Confluence data.
-
How to Visualize AgileCRM Data in Python with pandas
Use pandas and other modules to analyze and visualize live AgileCRM data in Python.
-
Integrating Codex with Cassandra 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.
-
How to create Suadeo federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Suadeo data in MySQL .
-
Build MVC Applications with Connectivity to Bugsnag Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Bugsnag from an ASP.NET MVC application.
-
How to Connect DBeaver to ElevenLabs via a JDBC Driver
Manage ElevenLabs data with visual tools in DBeaver like the query browser.
-
Automated Continuous MailerLite Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable MailerLite replication to delimited files (CSV/TSV).
-
How to Query Live Monday.com Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Monday.com data data in natural language using Python.
-
Visualize Live Autopilot Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Autopilot data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Connect to Sentry from Asprova with CData Software ODBC Driver for Sentry
This article shows how to connect faster to Sentry data from Asprova.
-
Connect to SAP Business One Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live SAP Business One data from Filemaker Pro on Mac.
-
Perform Batch Operations with Microsoft Teams Data in Apache NiFi
Connect to Microsoft Teams data and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Access Live Oracle Sales Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Oracle Sales data from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
How to Build an ETL App for CloudConvert Data in Python with CData
Create ETL applications and real-time data pipelines for CloudConvert data in Python with petl.
-
Create Epicor Kinetic-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Epicor Kinetic Data from OutSystems and build custom enterprise apps using live Epicor Kinetic data.
-
Link QuickBooks Time with FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate QuickBooks Time data in Filemaker Pro for Mac or Windows.
-
Integrate Live HubDB Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf's Cascade agent to securely access and query live HubDB data from within the IDE.
-
How to Connect the Power BI Service to Zendesk: Complete Guide
Connect to the CData Software Power BI Connector for Zendesk from PowerBI.com to provide real-time Zendesk data across the organization.
-
Connect to and Query Flowlu Data in QlikView over ODBC
Create data visualizations with Flowlu data in QlikView.
-
Use the CData Software JDBC Driver for EnterpriseDB in MicroStrategy Desktop
Connect to EnterpriseDB data in MicroStrategy Desktop using the CData Software JDBC Driver for EnterpriseDB.
-
Build Agents in Relevance AI with Access to Live Zoom Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Zoom data within intelligent agent workflows.
-
Access Live Auth0 Data in AWS Lambda
Connect to live Auth0 data in AWS Lambda using the CData JDBC Driver.
-
Stream Pipedrive Data into Apache Kafka Topics
Access and stream Pipedrive data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Excel Spreadsheet Automation on Float Data with the QUERY Formula
Pull data from Float, automate spreadsheets, and more with the QUERY formula.
-
Query Stack Exchange Data as a MySQL Database in Node.js
Execute MySQL queries against Stack Exchange data from Node.js.
-
Connect to ShipEngine Data in DBeaver
Use the CData ODBC Driver to connect to ShipEngine data in DBeaver.
-
How to Query Paymo Data in MySQL Workbench
Execute MySQL queries against live Paymo data from MySQL Workbench.
-
Build Data Flows from SQL Server to Presto through SSIS
Easily push SQL Server data to Presto using the CData SSIS Tasks for Presto.
-
Automate FreeAgent Data Replication to Couchbase
Use CData Sync to Customize and automate FreeAgent data replication to Couchbase.
-
Create SSAS Tabular Models from Basecamp Data
How to build a SQL Server Analysis Service Tabular Model from Basecamp data using CData drivers.
-
Integrate with WordPress Data in JReport Designer
Create charts and reports based on WordPress data in JReport Designer.
-
Excel Spreadsheet Automation on Strava Data with the QUERY Formula
Pull data from Strava, automate spreadsheets, and more with the QUERY formula.
-
Connect to Live Mailgun Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Mailgun in CData Connect AI and connect to your Mailgun data from PostgreSQL.
-
Visualize Live SparkPost Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live SparkPost data into custom reports in Power BI.
-
Visualize CSV 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 CSV data into TIBCO Spotfire.
-
Integrate Printful Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Printful data from Informatica Cloud.
-
Visualize Front Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Front data.
-
Visualize Shopify Data in TIBCO Spotfire through OData
Integrate Shopify data into dashboards in TIBCO Spotfire.
-
Visualize Certinia Data in Sisense
Create an ElastiCube in Sisense app with access to Certinia data.
-
Integrating Claude Code CLI with Opsgenie 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 Informatica Mappings From/To a JDBC Data Source for Microsoft Teams
Create Microsoft Teams data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Work with Authorize.Net Data in FoxPro
Load Authorize.Net data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Connect to Bugsnag Data in NetBeans
Connect to Bugsnag data in NetBeans with the data source configuration wizard.
-
Analyze Supabase Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Supabase data and visualize live Supabase data in Infragistics Reveal.
-
Connect to Salesforce CRM Analytics Data from a Connection Pool in Jetty
The Salesforce CRM Analytics JDBC Driver supports connection pooling: This article shows how to connect faster to Salesforce CRM Analytics data from Web apps in Jetty.
-
Replicate ZohoDesk Data in Heroku for Use in Salesforce Connect
Replicate ZohoDesk data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Prepare, Blend, and Analyze Mailgun Data in Alteryx Designer (ODBC)
Build workflows to access live Mailgun data for self-service data analytics.
-
Use the CData Software JDBC Driver for iContact in MicroStrategy Web
Connect to iContact data in MicroStrategy Web using the CData Software JDBC Driver for iContact.
-
How to Connect Printify 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 Printify data in real time using natural language.
-
Use JayDeBeApi to access OnePageCrm Data in Python
Use standard Python scripting and the development environment of your choice to access live OnePageCrm data.
-
Connect to Accelo Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Accelo data using standard SQL.
-
How to Build an ETL App for Zoho Projects Data in Python with CData
Create ETL applications and real-time data pipelines for Zoho Projects data in Python with petl.
-
Migrating data from Vault CRM to Google BigQuery using CData SSIS Components.
Easily push Vault CRM data to Google BigQuery using the CData SSIS Tasks for Vault CRM and Google BigQuery.
-
Build Authorize.Net-Connected Apps in Choreo
Use CData Connect AI to connect to Authorize.Net Data from Choreo and build custom apps using live Authorize.Net data.
-
Moving Data from Accelo to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Accelo data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
DataBind Charts to Zoho Projects Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Zoho Projects data from controls in the Visual Studio toolbox. This article demonstrates a graphical approach using wizards in Visual Studio, as well as how to databind with only a few lines of code.
-
Getting Started with the CData Connect AI Python SDK for Azure Analysis Services
Install the CData Connect AI Python SDK to read live Azure Analysis Services data with standard DB-API 2.0 Python code.
-
Integrate Trae with Live QuickBooks Online Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Trae to securely access and query live QuickBooks Online data from within the AI-powered IDE.
-
Use Azure AI Foundry to Talk to Your Stripe Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Azure AI Foundry agents to securely answer questions and take actions on your Stripe data for you.
-
How to connect PolyBase to Microsoft Dataverse
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Microsoft Dataverse data.
-
How to Visualize MailerLite 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 MailerLite data in Python.
-
Build HubSpot-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live HubSpot data.
-
Query, Visualize, and Share live Guru Data in Redash
Use CData Connect AI to connect to live Guru data in Redash for querying, visualizing, and sharing.
-
Create Datasets from Microsoft Entra ID in Domo Workbench and Build Visualizations of Microsoft Entra ID Data in Domo
Use the CData Software ODBC Driver for Microsoft Entra ID to create datasets from Microsoft Entra ID data in Domo Workbench and then build visualizations in the Domo service.
-
Building Dynamic Web Pages with Oracle Service Cloud Data Using AngularJS
Create single-page applications with live connectivity to Oracle Service Cloud using the CData API Server.
-
How to Connect to Live LDAP Objects 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 LDAP objects for you.
-
Use Claude to Talk to Your Highrise 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 Highrise data for you.
-
Integrating Kiro with Planio 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.
-
Getting Started with the CData Tableau Connector for Hive
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Hive.
-
Integrating Codex with Oracle Service Cloud 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.