CData Software - Knowledge Base
Recent Articles
-
Connect to IBM Informix Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
LINQ to Helpscout 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 Helpscout Data Provider.
-
Build a PostgreSQL Interface for Salesforce Data using the CData JDBC Driver
Use the Remoting features of the Salesforce JDBC Driver to create a PostgreSQL entry-point for data access.
-
Build Dashboards with Elorus Data in DBxtra
Create dynamic dashboards and perform analytics based on Elorus in DBxtra.
-
How to work with ClickTime Data in Apache Spark using SQL
Access and process ClickTime Data in Apache Spark using the CData Software JDBC Driver.
-
Build Charts with Vimeo Data in Clear Analytics
Create dynamic charts and perform analytics based on Vimeo in Clear Analytics.
-
Query ActiveCampaign Data from Node.js
Use the OData endpoint of the CData API Server to connect to your ActiveCampaign and perform CRUD operations on ActiveCampaign from Node.js.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for RSS
Provide connectivity to RSS Feeds through an SAP BusinessObjects universe.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed Snapchat Ads to Power BI dashboards. Simply drag and drop Snapchat Ads into data visuals on the Power BI canvas.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Zoho Inventory
Provide connectivity to Zoho Inventory through an SAP BusinessObjects universe.
-
Build Azure Analysis Services-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Azure Analysis Services and build Azure Analysis Services-connected web apps with Axios.
-
Automated Continuous Zoho Inventory Replication to SQL Server
Use CData Sync for automated, continuous, customizable Zoho Inventory replication to SQL Server.
-
Publish Reports with SAP HANA XS Advanced Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date SAP HANA XS Advanced.
-
Analyze Live Google Calendar Data in SAS Viya
Use CData Connect AI to connect to Google Calendar from SAS Viya and deploy self-service analytics using live Google Calendar.
-
Use Biml to Build SSIS Tasks to Replicate OneNote Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Microsoft OneNote to SQL Server.
-
Publish Reports with Bitly Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Bitly.
-
How to update MongoDB from Excel
This article explains how to transfer data from Excel to MongoDB using the Excel Add-In for MongoDB.
-
Replicate HCL Domino Data to Multiple Databases via the CData Sync CLI
Replicate HCL Domino to disparate databases with a single configuration.
-
Integrating OpenCode Terminal with Oracle Eloqua 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 SSAS Tabular Models from WordPress Data
How to build a SQL Server Analysis Service Tabular Model from WordPress using CData drivers.
-
Publish Microsoft Planner-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Microsoft Planner.
-
Automated Continuous Optimizely Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Optimizely replication to Apache Kafka.
-
Build Apps with Live SAP HANA Data Using the Low-Code Development Platform of Mendix
Connect SAP HANA with Mendix to build apps using the CData JDBC Driver for SAP HANA.
-
Getting Started with the CData ADO.NET Provider for NASA
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
How to Easily Query SAP HANA XS Advanced Data in OpenOffice Base
Connect to SAP HANA XS Advanced data in OpenOffice Base using the CData ODBC Driver for SAP HANA XS Advanced and generate reports with live data insights.
-
Connect to Wistia Data in CloverDX (formerly CloverETL)
Transfer Wistia using the visual workflow in the CloverDX data integration tool.
-
Integrate Greenplum Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Pivotal GreenPlum from Informatica Cloud.
-
Build AI/ML Models with Live SAP HANA XS Advanced Data using Dataiku
Connect SAP HANA XS Advanced Data with Dataiku using the CData JDBC Driver for SAP HANA XS Advanced.
-
Replicate Calendly Data in Heroku for Use in Salesforce Connect
Replicate Calendly to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Visualize Live Hugging Face Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Hugging Face.
-
Integrate Live Zuora Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Zuora and integrate live Zuora into apps built in Microsoft Power Apps.
-
Automated Continuous IBM Informix Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable IBM Informix replication to delimited files (CSV/TSV).
-
Connect to Rootly Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Rootly using standard SQL.
-
Creating HBase-Connected Applications in Unqork
You can use CData Connect AI to feed Apache HBase to Unqork and build custom business apps.
-
Connect to Oracle SCM Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Oracle SCM from Filemaker Pro on Mac.
-
Create Data Visualizations in Cognos BI with Workable Data
Access Workable as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Automate Tasks in Power Automate Using the CData API Server
Automate CouchDB actions in Microsoft Flow — sending emails, posting to social media, or syncing CRM and ERP.
-
Visualize Live Yelp Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Yelp using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Connecting GenSpark with Xero Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Xero Accounting without any replication or custom integration required.
-
Analyze SAP Business One Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze SAP Business One in Microsoft R Open.
-
Connect to and Visualize Live Jira Assets Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Jira Assets.
-
Build a PostgreSQL Interface for Cohere Data using the CData JDBC Driver
Use the Remoting features of the Cohere JDBC Driver to create a PostgreSQL entry-point for data access.
-
Analyze Workable Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Workable from Power Pivot. You will use the Table Import Wizard to load Workable. You can visually build the import query or use any SQL supported by the driver.
-
Create Dynamic Microsoft Teams Grids Using the Infragistics XamDataGrid
Learn how you can connect Microsoft Teams to Infragistics XamDataGrid to build dynamic grids.
-
Visualize SingleStore Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to SingleStore.
-
Design BIRT Reports on Reckon Data
Provide current Reckon to your embedded analytics.
-
How to Connect to Live Microsoft Entra ID Data 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 Microsoft Entra ID for you.
-
Model, Search, and Visualize Live Exact Online Data in ThoughtSpot
Use CData Connect AI to connect to live Exact Online for modeling, searching, and visualizing.
-
How to connect to TigerGraph Data in DBVisualizer
Integrate TigerGraph with visual data analysis tools and data connection wizards in DBVisualizer
-
Integrate SharePoint Data in Pentaho Data Integration
Build ETL pipelines based on Microsoft SharePoint in the Pentaho Data Integration tool.
-
Integrate Oracle SCM Data in the Pentaho Report Designer
Publish reports based on Oracle SCM in the Pentaho BI tool.
-
Replicate LeadDesk Data in Heroku for Use in Salesforce Connect
Replicate LeadDesk to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Create Microsoft OneDrive-Connected Business Apps in AppSheet
Connect to Microsoft OneDrive Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Microsoft OneDrive.
-
Trigger Oracle Sales IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for Oracle Sales with standard wizards in Logic Apps.
-
Create SSAS Tabular Models from Tanda Data
How to build a SQL Server Analysis Service Tabular Model from Tanda using CData drivers.
-
Connect to Salesforce Pardot Data in HULFT Integrate
Connect to Salesforce Pardot as a JDBC data source in HULFT Integrate
-
Connect to Real-Time Dynamics 365 Business Central Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Dynamics 365 Business Central and Dataflow to import and use Dynamics 365 Business Central in Power Apps.
-
How to create an RPA flow for Rebilly Data in UiPath Studio
Use the Rebilly ODBC Driver to create workflows that access real-time Rebilly without any coding.
-
Use the CData Software JDBC Driver for Customer.io in MicroStrategy
Connect to Customer.io in MicroStrategy Developer using the CData Software JDBC Driver for Customer.io.
-
How to publish and share Act-On Data dashboards with Tableau Server
The CData ODBC driver for Act-On enables you integrate Act-On into Tableau dashboards.
-
Analyze Zoho CRM Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Zoho CRM and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Easily Integrate Airtable Data in Lazarus Pascal IDE
Learn how to easily integrate live Airtable in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Use the CData Software JDBC Driver for Authorize.Net in MicroStrategy Web
Connect to Authorize.Net in MicroStrategy Web using the CData Software JDBC Driver for Authorize.Net.
-
Access Live Productboard Data in AWS Lambda
Connect to live Productboard in AWS Lambda using the CData JDBC Driver.
-
Visualize Nuclia 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 Nuclia into TIBCO Spotfire.
-
Automate Kafka Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live Apache Kafka and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
Query Microsoft Exchange Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Microsoft Exchange from Node.js.
-
Feed JSON Services into FineReport
How to set JSON as a JDBC data source in FineReport.
-
Choosing the Best Method to Connect Superchat to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Superchat from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Automated Continuous Freshsales Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Freshsales replication to AlloyDB.
-
How to Query Live Google Spanner Data in Perplexity MacOS Desktop
Connect to and query live Google Spanner Data in Perplexity Desktop using CData MCP Server.
-
Automated Continuous Splunk Replication to Oracle
Use CData Sync for automated, continuous, customizable Splunk replication to Oracle.
-
Query Highrise Data from Node.js
Use the OData endpoint of the CData API Server to connect to your Highrise CRM and perform CRUD operations on Highrise from Node.js.
-
How to connect to Gong Data in DBVisualizer
Integrate Gong with visual data analysis tools and data connection wizards in DBVisualizer
-
Automated Continuous Copper Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Copper replication to Apache Cassandra.
-
Integrate Salesforce Pardot Data in the Pentaho Report Designer
Publish reports based on Salesforce Pardot in the Pentaho BI tool.
-
How to Build an ETL App for BigCommerce Data in Python with CData Connect AI
Build ETL pipelines that read and write live BigCommerce in Python with petl and the CData Connect AI Python SDK.
-
Connect to CouchDB Data in DBeaver
Use the CData ODBC Driver to connect to Apache CouchDB in DBeaver.
-
Automate Printify Data Replication to Azure Synapse
Use CData Sync to customize and automate Printify replication to Azure Synapse.
-
Access Live Twitter Ads Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Twitter Ads in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Use the CData Software ODBC Driver for CloudConvert in MicroStrategy Desktop
Connect to CloudConvert in MicroStrategy Desktop using the CData Software ODBC Driver for CloudConvert.
-
How to connect to Impala Data from Spring Boot
Connect to Impala in a Spring Boot Application using the CData JDBC Driver for Impala
-
Getting Started with the CData JDBC Driver for WooCommerce
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for WooCommerce.
-
Natively Connect to ClickUp Data in PHP
The CData ODBC driver for ClickUp enables you to create PHP applications with connectivity to ClickUp. Leverage the native support for ODBC in PHP.
-
Automate BambooHR Data Replication to Azure Synapse
Use CData Sync to customize and automate BambooHR replication to Azure Synapse.
-
Getting Started with the CData Python Connector for RSS
Learn to install and license the CData Python Connector
-
Use the CData Software ODBC Driver for Teamwork in MicroStrategy Desktop
Connect to Teamwork in MicroStrategy Desktop using the CData Software ODBC Driver for Teamwork.
-
Visualize Aweber Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Aweber.
-
Automated Continuous Google Cloud Storage Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Google Cloud Storage replication to PostgreSQL.
-
How to connect and process Recurly from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Recurly.
-
How to work with CloudConvert Data in Apache Spark using SQL
Access and process CloudConvert Data in Apache Spark using the CData Software JDBC Driver.
-
Publish Crystal Reports on Jira Assets Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Jira Assets.
-
Connect to Gong Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Gong Data and connect to Gong in Akorbi Digital RunMyProcess.
-
Visualize Live Quaderno Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Quaderno.
-
Stream Airtable Data into Apache Kafka Topics
Access and stream Airtable in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Create Power BI Reports on Real-Time Oracle HCM Cloud Data
Use the CData ODBC Driver for Oracle HCM Cloud to visualize Oracle HCM Cloud in Power BI Desktop.
-
Getting Started with the CData ADO.NET Provider for Sage 200
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Sage 200.
-
Add QuickBooks Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for QuickBooks with the Informatica Enterprise Data Catalog to classify and organize data.
-
Connect to Splunk Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Splunk Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Query Presto Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Presto from Node.js.