CData Software - Knowledge Base
Recent Articles
-
Connect to Active Directory Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Active Directory to connect to Active Directory and execute queries in PowerBuilder.
-
Import and Visualize OnePageCrm Data in Power View
Create data visualizations based on OnePageCrm in Excel.
-
Query Wave Financial Data in DataGrip
Create a Data Source for Wave Financial in DataGrip and use SQL to query live Wave Financial.
-
Access Campaigner 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 Campaigner.
-
Publish Procore-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Procore.
-
Integrate CapsuleCRM Data in the Pentaho Report Designer
Publish reports based on CapsuleCRM in the Pentaho BI tool.
-
Connect to BambooHR in SpagoBI
Create reports featuring live BambooHR in SpagoBI Studio. Host BambooHR reports on SpagoBI Server.
-
Add Everhour Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Everhour with the Informatica Enterprise Data Catalog to classify and organize data.
-
Getting Started with the CData Python Connector for IBM Cloud Object Storage
Learn to install and license the CData Python Connector
-
Connecting GenSpark with Act CRM Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Act CRM without any replication or custom integration required.
-
Build Facebook Ads Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Facebook Ads and build visualizations in Tableau Cloud.
-
Import Real-Time AfterShip Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use AfterShip in ColdFusion.
-
Integrating GitHub Copilot CLI with LionDesk 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.
-
A PostgreSQL Interface for Oracle Financials Cloud Data using the CData ODBC Driver
Use the SQL Gateway and Oracle Financials Cloud ODBC Driver to create a PostgreSQL entry-point for data access.
-
Automate OnePageCrm Integration Tasks from PowerShell
Are you in search of a quick and easy way to access OnePageCrm from PowerShell? This article demonstrates how to utilize the OnePageCrm Cmdlets for tasks like connecting to OnePageCrm, automating operations, downloading data, and more.
-
Create Dynamic ZendeskSell Grids Using the Infragistics XamDataGrid
Learn how you can connect ZendeskSell to Infragistics XamDataGrid to build dynamic grids.
-
Query, Visualize, and Share live Authorize.Net Data in Redash
Use CData Connect AI to connect to live Authorize.Net in Redash for querying, visualizing, and sharing.
-
Integrate SAP Fieldglass with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate SAP Fieldglass with External Services.
-
Use the CData Software JDBC Driver for SAP ByDesign in MicroStrategy Desktop
Connect to SAP Business ByDesign in MicroStrategy Desktop using the CData Software JDBC Driver for SAP ByDesign.
-
Stream Scrapfly Data into Apache Kafka Topics
Access and stream Scrapfly in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Integrating Antigravity CLI with ZohoExpense via CData CLI
Connect ZohoExpense to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Visualize CampaignMonitor Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to CampaignMonitor.
-
Import Real-Time Drip Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Drip in ColdFusion.
-
Create Elasticsearch Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Elasticsearch data access from reports, embedded analytics, and more.
-
Automated Continuous SAP Ariba Source Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable SAP Ariba Source replication to Apache Cassandra.
-
Integrate Open WebUI with Live Google Calendar Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Google Calendar from within the chat interface.
-
Integrate with live Amazon Athena Data in Jitterbit
Use CData Connect AI to connect to and integrate live Amazon Athena in Jitterbit.
-
Connect to Cosmos DB Data in RapidMiner
Integrate Azure Cosmos DB with standard components and data source configuration wizards in RapidMiner Studio.
-
Automate Salesforce Data 360 Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Salesforce Data 360 from PowerShell? This article demonstrates how to utilize the Salesforce Data 360 Cmdlets for tasks like connecting to Salesforce Data 360, automating operations, downloading data, and more.
-
Getting Started with the CData Connect AI Python SDK for Zoho Inventory
Install the CData Connect AI Python SDK to read and write live Zoho Inventory with standard DB-API 2.0 Python code.
-
Create Power BI Reports on Real-Time Codat Data
Use the CData ODBC Driver for Codat to visualize Codat in Power BI Desktop.
-
How to Seamlessly Import Zoho Books Data into IBM SPSS Modeler
Integrate Zoho Books data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Build AI/ML Models with Live HBase Data using Dataiku
Connect HBase Data with Dataiku using the CData JDBC Driver for HBase.
-
Connect to Parallel Data in NetBeans
Connect to Parallel in NetBeans with the data source configuration wizard.
-
Create SpaceX Dataflows on PowerBI.com
Connect to the CData Power BI Connector for SpaceX from PowerBI.com to create Power BI Dataflows with real-time data.
-
Automated Continuous SparkPost Replication to MySQL
Use CData Sync for automated, continuous, customizable SparkPost replication to MySQL.
-
How to Connect to Live Act-On 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 Act-On without replication.
-
How to Connect to Live Confluence Data from crewAI Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable crewAI agents to securely read and take actions on your Atlassian Confluence for you.
-
How to Build an ETL App for Miro Data in Python with CData
Create ETL applications and real-time data pipelines for Miro in Python with petl.
-
Natively Connect to PabblySubscriptions Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to PabblySubscriptions. Leverage the native support for ODBC in PHP.
-
How to Visualize Everhour Data in Python with pandas
Use pandas and other modules to analyze and visualize live Everhour in Python.
-
Integrate Dynamics 365 Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Microsoft Dynamics 365 and integrate live Microsoft Dynamics 365 into your Power Automate tasks.
-
Connect to Klaviyo Data in ACL Analytics
Connect to Klaviyo via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Klaviyo.
-
Connect to TigerGraph Data from a Connection Pool in JBoss
Integrate TigerGraph into Java servlets: Use the Management Console in JBoss to install the TigerGraph JDBC Driver.
-
How to Query Live Planio Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Planio data in natural language using Python.
-
How to Create Power BI Visual Reports with Real-Time Pushbullet Data
Use CData Power BI Connectors to visualize Pushbullet in Power BI.
-
Connect to Elasticsearch Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Elasticsearch and the Script function in FileMaker Pro to connect to Elasticsearch and work with Elasticsearch in your FileMaker application.
-
Automate Wave Financial Data Replication to Azure Data Lake
Use CData Sync to customize and automate Wave Financial replication to Azure Data Lake.
-
Connect to Aweber Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Aweber in the Denodo Virtual DataPort Administrator.
-
Access Cosmos DB Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Azure Cosmos DB from your Oracle system.
-
Analyze Azure Analysis Services Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Azure Analysis Services in Microsoft R Open.
-
Analyze Sugar CRM Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Sugar CRM and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Viewing XML Data in RAD Studio Data Explorer
How to view XML Files in RAD Studio Data Explorer using the CData ODBC Driver for XML.
-
Connect to Live MySQL Data in MicroStrategy through CData Connect AI
Create a live connection to MySQL Data in CData Connect AI and connect to your MySQL from MicroStrategy.
-
Connect to Google Calendar from Asprova with CData Software ODBC Driver for Google Calendar
This article shows how to connect faster to Google Calendar data from Asprova.
-
Feed CampaignMonitor Data into FineReport
How to set CampaignMonitor as a JDBC data source in FineReport.
-
DataBind Controls to Cosmos DB Data in Delphi
DataBind to Azure Cosmos DB in Delphi with standard data access components and controls.
-
Connect to Monday.com Data in NetBeans
Connect to Monday.com in NetBeans with the data source configuration wizard.
-
DataBind Controls to Microsoft Exchange Data in C++Builder
DataBind to Microsoft Exchange in C++Builder with standard components and controls.
-
Integrating LlamaIndex with Avalara AvaTax Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Avalara AvaTax in real time.
-
Create SSAS Tabular Models from Pinterest Data
How to build a SQL Server Analysis Service Tabular Model from Pinterest using CData drivers.
-
Access Reply.io Data from MySQL in Amazon QuickSight
Connect to Reply.io and build visualizations of Reply.io using a MySQL Connection in Amazon QuickSight.
-
Automated Continuous Azure DevOps Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Azure DevOps replication to Apache Kafka.
-
Access Wistia Data from MySQL in PHP
Connect to Wistia through the standard MySQL libraries in PHP.
-
Using the CData Software ODBC Driver for ChartMogul in PyCharm
Connect to ChartMogul as an ODBC data source in PyCharm using the CData Software ODBC Driver for ChartMogul.
-
Getting Started with the CData ADO.NET Provider for Avro
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Avro.
-
Create Reports from SurveyMonkey Data in Looker Studio
Use CData Connect AI to gain access to live SurveyMonkey and create custom reports in Looker Studio.
-
Integrate Live HCL Domino Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to HCL Domino from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live HCL Domino.
-
Getting Started with the CData Power BI Connector for Access
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Access.
-
How to Use a Microsoft Access Database to Update Databricks Data in Real Time
Update Databricks data by creating a linked table in Microsoft Access with the CData Databricks ODBC Driver.
-
Query Lakebase Data in DataGrip
Create a Data Source for Lakebase in DataGrip and use SQL to query live Lakebase.
-
How to Access Live MYOB AccountRight Data in Power Automate Desktop via ODBC
The CData ODBC Driver for MYOB AccountRight enables you to integrate MYOB AccountRight into workflows built using Microsoft Power Automate Desktop.
-
Import Real-Time Databricks Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Databricks in ColdFusion.
-
Create Dynamic Optimizely Grids Using the Infragistics XamDataGrid
Learn how you can connect Optimizely to Infragistics XamDataGrid to build dynamic grids.
-
Build Phoenix-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData MCP Server for Phoenix to explore live Phoenix Data in GitHub Copilot to assist with building Phoenix-powered applications.
-
Automated Continuous MailChimp Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable MailChimp replication to delimited files (CSV/TSV).
-
Visualize SAS Data Sets 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 SAS Data Sets into TIBCO Spotfire.
-
Create Snapchat Ads Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Snapchat Ads data access from reports, embedded analytics, and more.
-
Query LionDesk Data as a MySQL Database in Node.js
Execute MySQL queries against LionDesk from Node.js.
-
Validate PivotalTracker Data with QuerySurge
Access and validate PivotalTracker in QuerySurge using the CData JDBC Driver.
-
Replicate Adobe Commerce Data to Multiple Databases
Replicate Adobe Commerce to disparate databases with a point-and-click configuration.
-
Build Semantic Layer Views for Close Data in APOS Live Data Gateway
Use the CData Connector for Close in APOS Live Data Gateway to build Semantic Layer Views for Close.
-
Use the CData Software ODBC Driver for LinkedIn Ads in SAS for Real-Time Reporting and Analytics
Connect to real-time LinkedIn Ads in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for LinkedIn Ads.
-
Access Google Directory 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 Google Directory.
-
Build Greenhouse-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Greenhouse and build web apps with connectivity to live Greenhouse.
-
How to connect to Google Contacts Data in DBVisualizer
Integrate Google Contacts with visual data analysis tools and data connection wizards in DBVisualizer
-
Back Up Oracle Database to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Oracle. In this article, we will employ an SSIS workflow to populate a database with Oracle Database data.
-
Provide OData Services of DocuSign Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for DocuSign by developing a WCF Service Application.
-
Integrating LangChain with Dynamics 365 Business Central Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Dynamics 365 Business Central within automated workflows.
-
Visualize Live Avalara AvaTax Data in the Power BI Service
Use CData Connect AI to connect to live Avalara AvaTax and create custom reports in the Power BI Service through the On-Premises Gateway.
-
How to connect PolyBase to PingOne
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live PingOne.
-
Automate Shopify Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live Shopify and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
Connect to LionDesk Data from PowerBuilder via JDBC
This article demonstrates how to access LionDesk from PowerBuilder using the LionDesk JDBC Driver.
-
Automated Continuous LaunchDarkly Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable LaunchDarkly replication to OneLake in Microsoft Fabric.
-
Object-Relational Mapping (ORM) with PDFMonkey 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 PDFMonkey into a Java-based ORM framework, Hibernate.
-
Connect to VWO Data from PowerBuilder via ADO.NET
This article demonstrates how to access VWO from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Integrating Boomi Agentstudio with WooCommerce Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to WooCommerce, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Connect to ShipStation in SpagoBI
Create reports featuring live ShipStation in SpagoBI Studio. Host ShipStation reports on SpagoBI Server.
-
A PostgreSQL Interface for Oracle Sales Data (MySQL Remoting via JDBC)
Use the Remoting features of the Oracle Sales JDBC Driver to create a PostgreSQL entry-point for data access.
-
Access Live MongoDB Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live MongoDB from your Google Sheets.