CData Software - Knowledge Base
Recent Articles
-
Visualize Live Facebook Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Facebook using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Stream Planio Data into Apache Kafka Topics
Access and stream Planio in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
How to Visualize Dropbox Data in Python with pandas
Use pandas and other modules to analyze and visualize live Dropbox in Python.
-
How to Connect to Live EnterpriseDB Data in Mistral AI Workflows
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live EnterpriseDB without replication.
-
How to use SQLAlchemy ORM to access Klipfolio Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Klipfolio.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Zoom using the Model Context Protocol.
-
Integrate with ZohoInvoice Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy ZohoInvoice to a JSON file on disk.
-
How to publish and share QuickBooks Online Data dashboards with Tableau Server
The CData ODBC driver for QuickBooks Online enables you integrate QuickBooks Online into Tableau dashboards.
-
Replicate Multiple Clari Accounts
Replicate multiple Clari accounts to one or many databases.
-
How to connect to Freshsales Data in DBVisualizer
Integrate Freshsales with visual data analysis tools and data connection wizards in DBVisualizer
-
Working with Redshift Data in LINQPad
Execute LINQ queries to Amazon Redshift in LINQPad.
-
Visualize Live Procore Data in the Power BI Service
Use CData Connect AI to connect to live Procore and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Automated Continuous SAS xpt Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable SAS xpt replication to delimited files (CSV/TSV).
-
Connecting Mastra with Okta Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to enable Mastra agents to securely query, read, and act on real-time Okta, no replication required.
-
Access Live Parallel Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Parallel into the statistical analysis tools available in SAS JMP. This article shows how to use Parallel in the Graph Builder and Query Builder.
-
How to Visualize Active Directory 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 Active Directory in Python.
-
Integrate Open WebUI with Live Microsoft Planner Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Microsoft Planner from within the chat interface.
-
Extract, Transform, and Load WordPress Data in Informatica PowerCenter
Create a simple Workflow for WordPress in Informatica PowerCenter.
-
Connect to Reckon Data in JRuby
Create a simple JRuby app with access to live Reckon.
-
Viewing VWO Data in RAD Studio Data Explorer
How to view VWO in RAD Studio Data Explorer using the CData ODBC Driver for VWO.
-
Integrating LangChain with Freshdesk Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Freshdesk within automated workflows.
-
Migrating data from Okta to Google BigQuery using CData SSIS Components.
Easily push Okta to Google BigQuery using the CData SSIS Tasks for Okta and Google BigQuery.
-
Build Act CRM-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Act CRM and build Act CRM-connected web apps with Axios.
-
Connect to and Visualize Live Sybase Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Sybase.
-
DataBind Controls to Azure Data Lake Storage Data in Delphi
DataBind to Azure Data Lake Storage in Delphi with standard data access components and controls.
-
Load Salesforce Marketing Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Salesforce Marketing Cloud to a database.
-
Automated Continuous Freshteam Replication to SQLite
Use CData Sync for automated, continuous, customizable Freshteam replication to SQLite.
-
Browserless Reporting in OBIEE with the Browserless JDBC Driver
Deploy the Browserless JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Analyze Oracle Eloqua Reporting Data in Infragistics Reveal
Use the CData API Server to create an OData API on top of Oracle Eloqua Reporting and visualize live Oracle Eloqua Reporting in Infragistics Reveal.
-
Analyze ShipStation Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of ShipStation and visualize live ShipStation in Infragistics Reveal.
-
Create Power BI Reports on Real-Time Amazon Athena Data
Use the CData ODBC Driver for Amazon Athena to visualize Amazon Athena in Power BI Desktop.
-
Access Live Insightly Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Insightly into the statistical analysis tools available in SAS JMP. This article shows how to use Insightly in the Graph Builder and Query Builder.
-
Build Avalara AvaTax-Powered Applications in Claude Code with CData MCP Server
Use the CData MCP Server for Avalara AvaTax to explore live Avalara AvaTax Data in Claude Code to assist with building Avalara AvaTax-powered applications.
-
Connect to Opsgenie Data from a Connection Pool in JBoss
Integrate Opsgenie into Java servlets: Use the Management Console in JBoss to install the Opsgenie JDBC Driver.
-
ETL Stripe in Oracle Data Integrator
This article shows how to transfer Stripe into a data warehouse using Oracle Data Integrator.
-
Connect to PostgreSQL Data in RapidMiner
Integrate PostgreSQL with standard components and data source configuration wizards in RapidMiner Studio.
-
A PostgreSQL Interface for Google Sheets Data using the CData ODBC Driver
Use the SQL Gateway and Google Sheets ODBC Driver to create a PostgreSQL entry-point for data access.
-
Replicate ZendeskSell Data to Multiple Databases via the CData Sync CLI
Replicate ZendeskSell to disparate databases with a single configuration.
-
Use the CData Software JDBC Driver for Sage Cloud Accounting in MicroStrategy Desktop
Connect to Sage Business Cloud Accounting in MicroStrategy Desktop using the CData Software JDBC Driver for Sage Cloud Accounting.
-
Connect to and Query TaxJar Data in QlikView over ODBC
Create data visualizations with TaxJar in QlikView.
-
Implementing the CData JDBC Driver ITokenStore Interface
This guide explains how to implement the ITokenStore interface in CData JDBC Drivers to manage OAuth token persistence across distributed and cloud-based applications.
-
Feed Zoho Creator Data into FineReport
How to set Zoho Creator as a JDBC data source in FineReport.
-
Using the CData Software ODBC Driver for Dynamics NAV in PyCharm
Connect to Dynamics NAV as an ODBC data source in PyCharm using the CData Software ODBC Driver for Dynamics NAV.
-
How to import Amazon S3 Data into Apache Solr
Use the CData Software JDBC Driver for Amazon S3 in Data Import Handler and create an automated import of Amazon S3 to Apache Solr Enterprise Search platform.
-
Use the CData Software ODBC Driver for Freshdesk in MicroStrategy Desktop
Connect to Freshdesk in MicroStrategy Desktop using the CData Software ODBC Driver for Freshdesk.
-
Build Apps with Live Oracle Service Cloud in Adalo using CData Connect AI
Use CData Connect AI to integrate live Oracle Service Cloud into the Adalo platform and build custom mobile and web applications with real-time Oracle Service Cloud.
-
Integrate Cline with Live Reckon Accounts Hosted Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Reckon Accounts Hosted from within your IDE.
-
Integrate Theia IDE with Live FHIR Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE
-
Automated Continuous Bannerbear Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Bannerbear replication to Google BigQuery.
-
Connect to Live Epicor Kinetic Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Epicor Kinetic in CData Connect AI and connect to your Epicor Kinetic from PostgreSQL.
-
Build Jira Assets-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Jira Assets Data from Zoho Analytics and import live Jira Assets.
-
Integrate Live Wave Financial Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Wave Financial to Blue Prism using the CData ODBC Driver for Wave Financial to create automated workflows for repetitive business tasks.
-
Build Data Flows from Sage 200 to SQL Server using SSIS
Easily back up Sage 200 to SQL Server using the SSIS components for Sage 200.
-
Automated Continuous Azure Data Lake Storage Replication to Vertica
Use CData Sync for automated, continuous, customizable Azure Data Lake Storage replication to Vertica.
-
Analyze Live Zoho Books Data in SAS Viya
Use CData Connect AI to connect to Zoho Books from SAS Viya and deploy self-service analytics using live Zoho Books.
-
Integrate Theia IDE with Live Splunk Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE
-
Import Real-Time LionDesk Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use LionDesk in ColdFusion.
-
Automate xBase Data Replication to Azure Synapse
Use CData Sync to customize and automate xBase replication to Azure Synapse.
-
Validate VWO Data with QuerySurge
Access and validate VWO in QuerySurge using the CData JDBC Driver.
-
How to Query Live Strava Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Strava data in natural language using Python.
-
Automated Continuous Pipeliner CRM Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Pipeliner CRM replication to delimited files (CSV/TSV).
-
Replicate ZeroBounce Data from PowerShell
Write a quick PowerShell script to query ZeroBounce. Use connectivity to the live data to replicate ZeroBounce to SQL Server.
-
How to publish and share Tickspot Data dashboards with Tableau Server
The CData ODBC driver for Tickspot enables you integrate Tickspot into Tableau dashboards.
-
Design BIRT Reports on Parquet Data
Provide current Apache Parquet to your embedded analytics.
-
Getting Started with the CData SSIS Components for SAP SuccessFactors LMS
Complete guide to installing, licensing, and connecting with the CData SSIS Components for SAP SuccessFactors LMS.
-
Feed Browserless Data into FineReport
How to set Browserless as a JDBC data source in FineReport.
-
Building Dynamic Web Pages with LinkedIn Data Using AngularJS
Create single-page applications with live connectivity to LinkedIn using the CData API Server.
-
Connect to Redshift Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Amazon Redshift from Filemaker Pro on Mac.
-
Connect to Spark Data from PowerBuilder via ADO.NET
This article demonstrates how to access Apache Spark SQL from Appeon PowerBuilder using the CData ADO.NET Provider for Spark.
-
Use Dash to Build Web Apps on Xero Data via CData Connect AI
Build interactive Dash web apps on live Xero Accounting using pandas and the CData Connect AI Python SDK.
-
Import Real-Time Vault CRM Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Veeva Vault & Vault CRM in ColdFusion.
-
How to Import Data from LinkedIn Ads into Google Sheets
Import LinkedIn Ads into a Google spreadsheet that is automatically refreshed.
-
Provide OData Services of SageHR Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for SageHR by developing a WCF Service Application.
-
Operational Reporting on Beeminder Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Beeminder.
-
Excel Spreadsheet Automation on Microsoft Teams Data with the QUERY Formula
Pull data from Microsoft Teams, automate spreadsheets, and more with the QUERY formula.
-
Visualize Live PostgreSQL Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live PostgreSQL into custom reports in Power BI.
-
How to integrate Metabase with Snapchat Ads Data
Use CData Connect AI to connect to live Snapchat Ads and create an interactive dashboard in Metabase from Snapchat Ads.
-
How to Query Live Codat Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Codat data in natural language using Python.
-
Connect to and Visualize Live MariaDB Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live MariaDB.
-
Replicate Accelo Data to Multiple Databases via the CData Sync CLI
Replicate Accelo to disparate databases with a single configuration.
-
Use the CData API Server to Access FTP Data in Microsoft PowerPivot
Use the CData API Server to connect to live FTP Servers in the Power Pivot business intelligence tool.
-
Design BIRT Reports on Billsby Data
Provide current Billsby to your embedded analytics.
-
Replicate PayPal Data to Multiple Databases
Replicate PayPal to disparate databases with a point-and-click configuration.
-
Creating Jira Assets-Connected Applications in Unqork
You can use CData Connect AI to feed Jira Assets to Unqork and build custom business apps.
-
How to import NetSuite Data into Apache Solr
Use the CData Software JDBC Driver for NetSuite in Data Import Handler and create an automated import of NetSuite CRM & ERP to Apache Solr Enterprise Search platform.
-
Automate Azure Data Catalog Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Azure Data Catalog from PowerShell? This article demonstrates how to utilize the Azure Data Catalog Cmdlets for tasks like connecting to Azure Data Catalog, automating operations, downloading data, and more.
-
Automated Continuous Salesloft Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Salesloft replication to OneLake in Microsoft Fabric.
-
Automated Continuous Redis Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Redis replication to Amazon S3.
-
Analyze Raisers Edge NXT Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Raisers Edge NXT and visualize Raisers Edge NXT in SAP Analytics Cloud.
-
Integrate with Salesforce Marketing Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Salesforce Marketing Cloud in SnapLogic.
-
Integrate with live Trello Data in Jitterbit
Use CData Connect AI to connect to and integrate live Trello in Jitterbit.
-
Use the CData Software JDBC Driver for JDBC-ODBC Bridge in MicroStrategy
Connect to JDBC-ODBC Bridge in MicroStrategy Developer using the CData Software JDBC Driver for JDBC-ODBC Bridge.
-
Build Zendesk-Connected Apps in Choreo
Use CData Connect AI to connect to Zendesk Data from Choreo and build custom apps using live Zendesk.
-
Automated Continuous ServiceNow Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable ServiceNow replication to Amazon Redshift.
-
Connect BenchmarkEmail to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect BenchmarkEmail with IBM WebSphere for seamless data integration and connectivity.
-
A PostgreSQL Interface for Reckon Data (MySQL Remoting via JDBC)
Use the Remoting features of the Reckon JDBC Driver to create a PostgreSQL entry-point for data access.
-
How to Connect DBeaver to Toggl via a JDBC Driver
Manage Toggl with visual tools in DBeaver like the query browser.
-
Operational Reporting on Outlook Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Outlook.
-
Connect to SAP Hybris C4C Data in DBeaver
Use the CData ODBC Driver to connect to SAP Hybris C4C in DBeaver.
-
Integrating BigQuery Data in Talend Cloud Data Management Platform
Connect BigQuery Data with Talend Cloud Data Management Platform using the CData JDBC Driver for BigQuery.