CData Software - Knowledge Base
Recent Articles
-
Automated Continuous Couchbase Replication to SQLite
Use CData Sync for automated, continuous, customizable Couchbase replication to SQLite.
-
Build Charts with Hacker News Data in Clear Analytics
Create dynamic charts and perform analytics based on Hacker News in Clear Analytics.
-
Automated Continuous WooCommerce Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable WooCommerce replication to Amazon Redshift.
-
Build Reckon Accounts Hosted-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Reckon Accounts Hosted Data from Zoho Analytics and import live Reckon Accounts Hosted.
-
Build Google Ad Manager-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData MCP Server for Google Ad Manager to explore live Google Ad Manager Data in GitHub Copilot to assist with building Google Ad Manager-powered applications.
-
Use the CData ODBC Driver for ChartMogul in Microsoft Power Query
You can use the CData ChartMogul ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import ChartMogul into Microsoft Power Query.
-
How to use SQLAlchemy ORM to access Harvest Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Harvest.
-
Analyze Live eBay Data in SAS Viya
Use CData Connect AI to connect to eBay from SAS Viya and deploy self-service analytics using live eBay.
-
Integrate Live Zendesk Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf
-
Extend Google Sheets with Sybase IQ Data
Make calls to Sybase IQ from Google Apps Script via the API Server.
-
Automate SAP HANA XS Advanced Data Replication to Azure Synapse
Use CData Sync to customize and automate SAP HANA XS Advanced replication to Azure Synapse.
-
Integrate Open WebUI with Live Exact Online Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Exact Online from within the chat interface.
-
Build Pipelines with Live Acumatica Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Acumatica from Google Cloud Data Fusion, enabling the integration of live Acumatica ERP into the building and management of effective data pipelines.
-
How to Connect to Active Directory Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Active Directory. Leverage the pyodbc module for ODBC in Python.
-
Use the CData Software JDBC Driver for LaunchDarkly in MicroStrategy
Connect to LaunchDarkly in MicroStrategy Developer using the CData Software JDBC Driver for LaunchDarkly.
-
Integrate Cline with Live PostgreSQL Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live PostgreSQL from within your IDE.
-
Connect to Airtable Data in RazorSQL
Connect to Airtable from wizards and query Airtable from the GUI in the RazorSQL database management tool.
-
Load Perigon Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Perigon to a database.
-
Using the CData Software ODBC Driver for Paylocity in PyCharm
Connect to Paylocity as an ODBC data source in PyCharm using the CData Software ODBC Driver for Paylocity.
-
Connect to Xero Data in ACL Analytics
Connect to Xero Accounting via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Xero Accounting.
-
Getting Started with the CData JDBC Driver for Oracle HCM Cloud
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Oracle HCM Cloud.
-
How to Connect to Live Vault CRM Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Veeva Vault & Vault CRM securely in real time.
-
Create CouchDB Dataflows on PowerBI.com
Connect to the CData Power BI Connector for CouchDB from PowerBI.com to create Power BI Dataflows with real-time data.
-
Access Paymo Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Paymo from HeidiSQL.
-
Connect to and Visualize Live Google Spanner Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Google Spanner.
-
Use the CData ODBC Driver for Jumpseller in Microsoft Power Query
You can use the CData Jumpseller ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Jumpseller into Microsoft Power Query.
-
Getting Started with the CData Tableau Connector for Azure Table
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Azure Table.
-
How to connect PolyBase to BigQuery
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Google BigQuery.
-
How to Query Live Anaplan Data in Claude Desktop
Connect to and query live Anaplan Data in Claude Desktop using CData MCP Server.
-
Automate Act CRM Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Act CRM from PowerShell? This article demonstrates how to utilize the Act CRM Cmdlets for tasks like connecting to Act CRM, automating operations, downloading data, and more.
-
Connect to Azure Table Data in JRuby
Create a simple JRuby app with access to live Azure Table Storage.
-
Connect to Zoom Data in NetBeans
Connect to Zoom in NetBeans with the data source configuration wizard.
-
Automated Continuous Coinbase Replication to Snowflake
Use CData Sync for automated, continuous, customizable Coinbase replication to Snowflake.
-
Automate Google Contacts Data Replication to Couchbase
Use CData Sync to Customize and automate Google Contacts replication to Couchbase.
-
Create SAP SuccessFactors Dataflows on PowerBI.com
Connect to the CData Power BI Connector for SAP SuccessFactors from PowerBI.com to create Power BI Dataflows with real-time data.
-
Connect to Azure Table Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Azure Table Storage.
-
Visualize Live Outlook Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Outlook using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Object-Relational Mapping (ORM) with Gorgias Data Entities in Java
Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to Gorgias into a Java-based ORM framework, Hibernate.
-
Create Data Visualizations in Cognos BI with Shippo Data
Access Shippo as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Connect to Samanage Data in Jaspersoft Studio
Execute SQL to remote Samanage in Jaspersoft Studio.
-
Rapidly Develop Marketo-Driven Apps with Active Query Builder
Leverage the Active Query Builder SQL interface and .NET data access to create data-driven WinForms and ASP.NET apps backed by Marketo.
-
Deploy the ADO.NET Provider for Microsoft Entra ID on an SSRS Report Server
Connect to Microsoft Entra ID 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.
-
Connect to SAP Business Warehouse Data in NetBeans
Connect to SAP Business Warehouse in NetBeans with the data source configuration wizard.
-
DataBind Controls to Front Data in Delphi
DataBind to Front in Delphi with standard data access components and controls.
-
How to Visualize ADP 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 ADP in Python.
-
Connect to PDFMonkey Data in RapidMiner
Integrate PDFMonkey with standard components and data source configuration wizards in RapidMiner Studio.
-
Integrating Cursor CLI with Wave Financial 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.
-
Visualize Live Adobe Commerce Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Adobe Commerce using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
How to connect PolyBase to ConvertKit
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live ConvertKit.
-
Bridge GitLab Connectivity with Apache NiFi
Access and process GitLab in Apache NiFi using the CData JDBC Driver.
-
Publish Pinecone-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Pinecone.
-
Create Azure Table-Connected Dashboards in Grafana
Connect to Azure Table Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Azure Table Storage.
-
Integrate SAP Business One Data in Pentaho Data Integration
Build ETL pipelines based on SAP Business One in the Pentaho Data Integration tool.
-
How to Connect DBeaver to Confluence via a JDBC Driver
Manage Atlassian Confluence with visual tools in DBeaver like the query browser.
-
Integrate Blackbaud FE NXT with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Blackbaud FE NXT with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Blackbaud FE NXT.
-
Connect to ClickUp Data in NetBeans
Connect to ClickUp in NetBeans with the data source configuration wizard.
-
Access Live Redis Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Redis in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Connect to and Query PolarTeamPro Data in QlikView over ODBC
Create data visualizations with PolarTeamPro in QlikView.
-
How to Access Oracle HCM Cloud Data Using Entity Framework
This article shows how to access Oracle HCM Cloud using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Automated Continuous Google Ads Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Google Ads replication to Google BigQuery.
-
Create Power BI Reports on Real-Time Missive Data
Use the CData ODBC Driver for Missive to visualize Missive in Power BI Desktop.
-
Visualize Live ZarMoney Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live ZarMoney using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Integrating Codex CLI with Google Contacts 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.
-
Validate ChartMogul Data with QuerySurge
Access and validate ChartMogul in QuerySurge using the CData JDBC Driver.
-
Connect to Bitly Data in RapidMiner
Integrate Bitly with standard components and data source configuration wizards in RapidMiner Studio.
-
How to Create Power BI Visual Reports with Real-Time SingleStore Data
Use CData Power BI Connectors to visualize SingleStore in Power BI.
-
Write a Simple Go Application to work with Elasticsearch Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Elasticsearch.
-
How to publish and share Freshdesk Data dashboards with Tableau Server
The CData ODBC driver for Freshdesk enables you integrate Freshdesk into Tableau dashboards.
-
Visualize Hugging Face 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 Hugging Face into TIBCO Spotfire.
-
Consume Salesforce Marketing OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Salesforce Marketing feeds that reflect any changes in SAP Lumira.
-
Creating Raisers Edge NXT-Connected Applications in Unqork
You can use CData Connect AI to feed Raisers Edge NXT to Unqork and build custom business apps.
-
VWO Reporting in OBIEE with the VWO JDBC Driver
Deploy the VWO JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Build a Simple VCL Application for BigCommerce Data
How to build a simple VCL Application to view BigCommerce in RAD Studio using the CData ODBC Driver for BigCommerce.
-
Integrating LlamaIndex with Google Campaign Manager 360 Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Google Campaign Manager 360 in real time.
-
How to Query Live PostgreSQL Data in Claude Desktop
Connect to and query live PostgreSQL Data in Claude Desktop using CData MCP Server.
-
How to connect to SAP SuccessFactors LMS Data from IntelliJ
Integrate connectivity to SAP SuccessFactors LMS with wizards in IntelliJ.
-
Analyze Acumatica Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Acumatica ERP and visualize live Acumatica ERP in Infragistics Reveal.
-
Analyze FreshBooks Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for FreshBooks from Power Pivot. You will use the Table Import Wizard to load FreshBooks. You can visually build the import query or use any SQL supported by the driver.
-
Deploy the ADO.NET Provider for Dotmailer on an SSRS Report Server
Connect to Dotmailer 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.
-
Use the CData Software JDBC Driver for SAP Ariba Source in MicroStrategy Desktop
Connect to SAP Ariba Source in MicroStrategy Desktop using the CData Software JDBC Driver for SAP Ariba Source.
-
Connect to Workable Data in RapidMiner
Integrate Workable with standard components and data source configuration wizards in RapidMiner Studio.
-
LINQ to Authorize.Net 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 Authorize.Net Data Provider.
-
Build Adobe Experience Manager-Powered Applications in Gemini Code Assist with CData MCP Server
Use the CData MCP Server for Adobe Experience Manager to explore live Adobe Experience Manager Data in Gemini Code Assist to assist with building Adobe Experience Manager-powered applications.
-
Connect to OneNote Data in Claris FileMaker Pro
Use the CData ODBC Driver for OneNote in FileMaker Pro to connect to OneNote and work with Microsoft OneNote in your FileMaker applications.
-
Automated Continuous Excel Online Replication to SingleStore
Use CData Sync for automated, continuous, customizable Excel Online replication to SingleStore.
-
How to use SQLAlchemy ORM to access HBase Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Apache HBase.
-
Connect to OpenWeatherMap Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for OpenWeatherMap in the Denodo Virtual DataPort Administrator.
-
Enable the Perplexity JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Perplexity.
-
Automated Continuous Highrise Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Highrise replication to Google BigQuery.
-
Analyze EnterpriseDB Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze EnterpriseDB in Microsoft R Open.
-
Automated Continuous SpaceX Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable SpaceX replication to delimited files (CSV/TSV).
-
Migrating data from Oracle Eloqua Reporting to Snowflake using CData SSIS Components.
Easily push Oracle Eloqua Reporting to Snowflake using the CData SSIS Tasks for Oracle Eloqua Reporting and Snowflake.
-
Perform Batch Operations with Paylocity Data in Apache NiFi
Connect to Paylocity and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Add Flowlu Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Flowlu with the Informatica Enterprise Data Catalog to classify and organize data.
-
Automated Continuous Attio Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Attio replication to Google BigQuery.
-
Visualize Typeform 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 Typeform into TIBCO Spotfire.
-
Integrate Bullhorn CRM Data into Power Automate Desktop using CData Connect
CData Connect for Bullhorn CRM Data enables you to integrate Bullhorn CRM into workflows built using Microsoft Power Automate Desktop.
-
Use Claude to Talk to Your Freshservice 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 Freshservice for you.
-
Replicate MYOB AccountRight Data from PowerShell
Write a quick PowerShell script to query MYOB AccountRight. Use connectivity to the live data to replicate MYOB AccountRight to SQL Server.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Bitbucket
Provide connectivity to Bitbucket through an SAP BusinessObjects universe.