CData Software - Knowledge Base
Recent Articles
-
Build an OLAP Cube in SSAS from Apify Data
Establish a connection to Apify data from SQL Server Analysis Services, and use the Apify Data Provider to build OLAP cubes for use in analytics and reporting.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed Aha! to Power BI dashboards. Simply drag and drop Aha! into data visuals on the Power BI canvas.
-
Migrating data from Salesforce to Google BigQuery using CData SSIS Components.
Easily push Salesforce & Force.com to Google BigQuery using the CData SSIS Tasks for Salesforce and Google BigQuery.
-
Use the CData ODBC Driver for Clockify from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Clockify to connect to Clockify from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Clockify in Excel.
-
Automate AfterShip Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live AfterShip and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
Add FHIR Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for FHIR with the Informatica Enterprise Data Catalog to classify and organize data.
-
Rapidly Develop Pushbullet-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 Pushbullet.
-
How to Connect to Live Salesforce CRM Analytics 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 Salesforce CRM Analytics for you.
-
Connect to Zoom from a Connection Pool in WebLogic
Use the CData JDBC Driver for Zoom to connect to Zoom from Web applications running on WebLogic.
-
Import ActiveCampaign Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access ActiveCampaign. In this article, you will use the OData format to import ActiveCampaign into Microsoft Power Query.
-
Connect to Stack Exchange Data in RapidMiner
Integrate Stack Exchange with standard components and data source configuration wizards in RapidMiner Studio.
-
DataBind Controls to SAP Hybris C4C Data in C++Builder
DataBind to SAP Hybris C4C in C++Builder with standard components and controls.
-
Create Datasets from Moosend in Domo Workbench and Build Visualizations of Moosend Data in Domo
Use the CData Software ODBC Driver for Moosend to create datasets from Moosend in Domo Workbench and then build visualizations in the Domo service.
-
Automated Continuous CampaignMonitor Replication to Vertica
Use CData Sync for automated, continuous, customizable CampaignMonitor replication to Vertica.
-
Integrate QuickBooks Online with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate QuickBooks Online with External Services.
-
Connect to Sage 300 Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Access HCL Domino Data from MySQL in Amazon QuickSight
Connect to HCL Domino and build visualizations of HCL Domino using a MySQL Connection in Amazon QuickSight.
-
Enable the Freshteam JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Freshteam.
-
Integrate with Discourse Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Discourse to a JSON file on disk.
-
Connect to Instagram Data in Claris FileMaker Pro
Use the CData ODBC Driver for Instagram in FileMaker Pro to connect to Instagram and work with Instagram in your FileMaker applications.
-
Build Reckon Accounts Hosted-Powered Applications in Cursor with CData MCP Server
Use the CData MCP Server for Reckon Accounts Hosted to explore live Reckon Accounts Hosted Data in Cursor to assist with building Reckon Accounts Hosted-powered applications.
-
How to Query Live Contentful Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Contentful data in natural language using Python.
-
Slack Reporting in OBIEE with the Slack JDBC Driver
Deploy the Slack JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Edit and Search ConstantContact External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of ConstantContact to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create ConstantContact objects that you can access from apps and the dashboard.
-
Connect to Kafka Data from a Connection Pool in JBoss
Integrate Apache Kafka into Java servlets: Use the Management Console in JBoss to install the Kafka JDBC Driver.
-
How to Create Power BI Visual Reports with Real-Time Landbot Data
Use CData Power BI Connectors to visualize Landbot in Power BI.
-
Viewing Float Data in RAD Studio Data Explorer
How to view Float in RAD Studio Data Explorer using the CData ODBC Driver for Float.
-
Consume LeadDesk OData Feeds in PowerBuilder
This article demonstrates how to consume LeadDesk as OData feeds from PowerBuilder using the API Server.
-
Publish Crystal Reports on Access Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Microsoft Access.
-
Prepare, Blend, and Analyze Tally Data in Alteryx Designer (ODBC)
Build workflows to access live Tally ERP for self-service data analytics.
-
Connect to Workable Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Workable and the SQL Gateway to access Workable from Google Apps Script.
-
Use Agno to Talk to Your SAP ByDesign Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Agno agents to securely answer questions and take actions on your SAP Business ByDesign for you.
-
Access Live Cloudant Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to IBM Cloudant from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Integrating Claude Code CLI with Zoho Projects 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.
-
Connect to LDAP Objects in Ruby
Connect to LDAP in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Build Automated CSV-Connected Workflows in Zapier
Use CData Connect AI to connect to live CSV/TSV Files and build automated workflows in Zapier.
-
Integrating Cursor CLI with Gmail 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.
-
Bind Live Scrapfly Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Scrapfly data
-
How to connect Amazon QuickSight to MongoDB Data
Create a connection to MongoDB in CData Connect AI and insert MongoDB into Amazon QuickSight SPICE to build interactive dashboards.
-
Visualize Live IBM Cloud Object Storage Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live IBM Cloud Object Storage.
-
How to Import Data from Intercom into Google Sheets
Import Intercom into a Google spreadsheet that is automatically refreshed.
-
Extract, Transform, and Load Sentry Data in Informatica PowerCenter
Create a simple Workflow for Sentry in Informatica PowerCenter.
-
Connect to MailerSend Data from a Connection Pool in Jetty
The MailerSend JDBC Driver supports connection pooling: This article shows how to connect faster to MailerSend from Web apps in Jetty.
-
Connect to Discourse Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Discourse.
-
Build Data Flows from SQL Server to Sage Cloud Accounting through SSIS
Easily push SQL Server data to Sage Cloud Accounting using the CData SSIS Tasks for Sage Cloud Accounting.
-
Connecting Pipedream with ShipStation Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Pipedream workflows to securely read and take actions on ShipStation data in real time.
-
Natively Connect to Salesloft Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Salesloft. Leverage the native support for ODBC in PHP.
-
Getting Started with the CData Power BI Connector for Missive
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Automated Continuous WooCommerce Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable WooCommerce replication to PostgreSQL.
-
How to load MySQL data into Elasticsearch via Logstash
Introducing a simple method to load MySQL data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Visualize Microsoft Dataverse Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Microsoft Dataverse (CDS).
-
Publish Webflow-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Webflow.
-
Automate eBay Data Replication to Azure Synapse
Use CData Sync to customize and automate eBay replication to Azure Synapse.
-
Use JayDeBeApi to access Workable Data in Python
Use standard Python scripting and the development environment of your choice to access live Workable.
-
Use ChatGPT to Talk to Your API 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 API for you.
-
Use the CData Software JDBC Driver for Oracle HCM Cloud in MicroStrategy Desktop
Connect to Oracle HCM Cloud in MicroStrategy Desktop using the CData Software JDBC Driver for Oracle HCM Cloud.
-
Use Dash to Build to Web Apps on Reckon Data
Create Python applications that use pandas and Dash to build Reckon-connected web apps.
-
Connect to Splunk from a Connection Pool in WebLogic
Use the CData JDBC Driver for Splunk to connect to Splunk from Web applications running on WebLogic.
-
Automated Continuous LinkedIn Replication to MongoDB
Use CData Sync for automated, continuous, customizable LinkedIn replication to MongoDB.
-
Natively Connect to ZohoExpense Data in PHP
The CData ODBC driver for ZohoExpense enables you to create PHP applications with connectivity to ZohoExpense. Leverage the native support for ODBC in PHP.
-
Explore Geographical Relationships in LaunchDarkly Data with Power Map
Create data visualizations with LaunchDarkly in Power Map.
-
Automated Continuous Billsby Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Billsby replication to Apache Cassandra.
-
Query GitHub Data as a SQL Server Database in Node.js
Execute SQL Server queries against GitHub from Node.js.
-
Automated Continuous FreshBooks Replication to Snowflake
Use CData Sync for automated, continuous, customizable FreshBooks replication to Snowflake.
-
Moving Data from ZohoDesk to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live ZohoDesk data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Getting Started with the CData Python Connector for PolarTeamPro
Learn to install and license the CData Python Connector
-
Use Dash to Build to Web Apps on Placid Data
Create Python applications that use pandas and Dash to build Placid-connected web apps.
-
Publish Reports with Factorial Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Factorial.
-
Create Reports with PDFMonkey Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date PDFMonkey.
-
Automated Continuous FreeAgent Replication to MongoDB
Use CData Sync for automated, continuous, customizable FreeAgent replication to MongoDB.
-
Getting Started with the CData Tableau Connector for Vault CRM
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Vault CRM Vault.
-
Integrate Pipedrive Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Pipedrive and integrate live Pipedrive into your Power Automate tasks.
-
How to connect to Microsoft Dataverse Data from IntelliJ
Integrate connectivity to Microsoft Dataverse (CDS) with wizards in IntelliJ.
-
Edit and Search External Sage Cloud Accounting Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Sage Business Cloud Accounting to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Sage Cloud Accounting Data objects that you can access from apps and the dashboard.
-
Natively Connect to Office 365 Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Microsoft Office 365. Leverage the native support for ODBC in PHP.
-
Connect to Recurly Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Recurly using standard SQL.
-
Automated Continuous Microsoft Ads Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Microsoft Ads replication to delimited files (CSV/TSV).
-
Query Azure Synapse Data from Node.js
Use the OData endpoint of the CData API Server to connect to your Azure Synapse and perform CRUD operations on Azure Synapse from Node.js.
-
Connecting Moonlit Workflow with CSV Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Moonlit workflows to securely read and act on your CSV/TSV Files in real time.
-
Build a Simple VCL Application for Deel Data
How to build a simple VCL Application to view Deel in RAD Studio using the CData ODBC Driver for Deel.
-
Connect to Odoo Data from PowerBuilder via JDBC
This article demonstrates how to access Odoo ERP from PowerBuilder using the Odoo JDBC Driver.
-
Excel Spreadsheet Automation on Eventbrite Data with the QUERY Formula
Pull data from Eventbrite, automate spreadsheets, and more with the QUERY formula.
-
Analyze PolarTeamPro Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze PolarTeamPro with the CData JDBC Driver for PolarTeamPro.
-
Build AI/ML Models with Live Bitly Data using Dataiku
Connect Bitly Data with Dataiku using the CData API Driver for JDBC.
-
Connect to CampaignMonitor Data from a Connection Pool in Jetty
The CampaignMonitor JDBC Driver supports connection pooling: This article shows how to connect faster to CampaignMonitor from Web apps in Jetty.
-
Connect SAP Fieldglass to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect SAP Fieldglass with IBM WebSphere for seamless data integration and connectivity.
-
Connect to RabbitMQ Data in RazorSQL
Connect to RabbitMQ from wizards and query RabbitMQ from the GUI in the RazorSQL database management tool.
-
How to Connect the Power BI Service to Nuclia: Complete Guide
Connect to the CData Software Power BI Connector for Nuclia from PowerBI.com to provide real-time Nuclia across the organization.
-
Build AI/ML Models with Live ZohoPeople Data using Dataiku
Connect ZohoPeople Data with Dataiku using the CData API Driver for JDBC.
-
Process & Analyze Insightly Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Insightly Data.
-
How to Access Live Zoho Books Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Zoho Books enables you to integrate Zoho Books into workflows built using Microsoft Power Automate Desktop.
-
Choosing the Best Method to Connect Pipeliner CRM to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Pipeliner CRM from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Analyze Azure Analysis Services Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Azure Analysis Services and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Stream Greenhouse Data into Apache Kafka Topics
Access and stream Greenhouse in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Consume CapsuleCRM OData Feeds in SAP Lumira
Use the API Server to create data visualizations on CapsuleCRM feeds that reflect any changes in SAP Lumira.
-
A PostgreSQL Interface for AgileCRM Data (MySQL Remoting via JDBC)
Use the Remoting features of the AgileCRM JDBC Driver to create a PostgreSQL entry-point for data access.
-
Create Power BI Reports on Real-Time Pushbullet Data
Use the CData ODBC Driver for Pushbullet to visualize Pushbullet in Power BI Desktop.
-
Connect to Adobe Analytics Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Adobe Analytics to connect to Adobe Analytics and execute queries in PowerBuilder.
-
Automate Campaigner Data Replication to Azure Data Lake
Use CData Sync to customize and automate Campaigner replication to Azure Data Lake.
-
Publish Crystal Reports on Neo4J Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Neo4J.