CData Software - Knowledge Base
Recent Articles
-
How to connect SharePoint with Power BI XMLA Data through external lists
Provide Power BI XMLA data to SharePoint users as an external list.
-
Connect to Monday.com Data from a Connection Pool in Jetty
The Monday.com JDBC Driver supports connection pooling: This article shows how to connect faster to Monday.com data from Web apps in Jetty.
-
Connecting GenSpark with Cosmos DB Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Cosmos DB data without any replication or custom integration required.
-
How to create HDFS federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for HDFS data in MySQL .
-
Import Real-Time Simplesat Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Simplesat data in ColdFusion.
-
Rapidly Develop MarkLogic-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 MarkLogic.
-
Use the CData Software JDBC Driver for Teamwork in MicroStrategy Desktop
Connect to Teamwork data in MicroStrategy Desktop using the CData Software JDBC Driver for Teamwork.
-
Publish Teradata-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Teradata data.
-
LINQ to Azure DevOps 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 Azure DevOps Data Provider.
-
Seamlessly Bring Jira Data into Retool Using CData Connect AI
Integrate Jira data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Automated Continuous FormSite Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable FormSite replication to Apache Cassandra.
-
Visualize HubDB Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to HubDB data.
-
How to Connect to Live Sage Cloud Accounting Data in Mistral AI Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live Sage Cloud Accounting data without replication.
-
How to connect to Cloudflare Data from IntelliJ
Integrate connectivity to Cloudflare data with wizards in IntelliJ.
-
How to integrate Raisers Edge NXT with Apache Airflow
Access and process Raisers Edge NXT data in Apache Airflow using the CData JDBC Driver.
-
Automated Continuous Authorize.Net Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Authorize.Net replication to AlloyDB.
-
Use Dash to Build to Web Apps on SAP Hybris C4C Data
Create Python applications that use pandas and Dash to build SAP Hybris C4C-connected web apps.
-
Query ZohoPeople Data as a MySQL Database in Node.js
Execute MySQL queries against ZohoPeople data from Node.js.
-
Consume Azure Table OData Feeds in PowerBuilder
This article demonstrates how to consume Azure Table data as OData feeds from PowerBuilder using the API Server.
-
Analyze ZohoExpense Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of ZohoExpense data and visualize ZohoExpense data in SAP Analytics Cloud.
-
Object-Relational Mapping (ORM) with SAP Concur 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 SAP Concur data into a Java-based ORM framework, Hibernate.
-
Use CData Connect AI to Access Email Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Email data in the Power Pivot business intelligence tool.
-
How to Query Live Amazon DynamoDB Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Amazon DynamoDB data data in natural language using Python.
-
Import Real-Time HBase Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use HBase data in ColdFusion.
-
LINQ to Clari 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 Clari Data Provider.
-
Analyze Jira Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Jira data in Microsoft R Open.
-
A PostgreSQL Interface for SAP Data using the CData ODBC Driver
Use the SQL Gateway and SAP ODBC Driver to create a PostgreSQL entry-point for data access.
-
Replicate Multiple Exact Online Accounts
Replicate multiple Exact Online accounts to one or many databases.
-
Moving Data from Jira to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Jira data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Replicate AdRoll Data to Multiple Databases
Replicate AdRoll data to disparate databases with a point-and-click configuration.
-
Analyze Azure Synapse Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Azure Synapse data with the CData JDBC Driver for Azure Synapse.
-
Integrating Codex with Recurly 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.
-
Build ShipEngine-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for ShipEngine Data and create custom apps in Bubble.
-
DataBind Controls to Planio Data in Delphi
DataBind to Planio data in Delphi with standard data access components and controls.
-
Use Agno to Talk to Your Google Forms 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 Google Forms data for you.
-
How to Connect to ConvertKit Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to ConvertKit data. Leverage the pyodbc module for ODBC in Python.
-
Analyze Mailjet Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Mailjet data in Microsoft R Open.
-
Build Amazon S3-Connected Apps in Choreo
Use CData Connect AI to connect to Amazon S3 Data from Choreo and build custom apps using live Amazon S3 data.
-
Back Up AfterShip data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData API Driver for ADO.NET. In this article, we will employ an SSIS workflow to populate a database with AfterShip data data.
-
Natively Connect to Freshservice Data in PHP
The CData ODBC driver for Freshservice enables you to create PHP applications with connectivity to Freshservice data. Leverage the native support for ODBC in PHP.
-
Connect to Cassandra Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Cassandra Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Getting Started with the CData JDBC Driver for ServiceDesk Plus
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for ServiceDesk Plus.
-
Connecting Pipedream with FTP 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 FTP data in real time.
-
Connect to Excel Online Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Excel Online data from Filemaker Pro on Mac.
-
Create xBase-Connected Nintex Workflows
Use CData Connect AI to connect to xBase Data from Nintex Workflow Cloud and build custom workflows using live xBase data.
-
Create SSAS Tabular Models from Cassandra Data
How to build a SQL Server Analysis Service Tabular Model from Cassandra data using CData drivers.
-
Moving Data from Humanity to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Humanity data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Connect to Sentry Data in Ruby
Connect to Sentry data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Connect to Clari Data in Ruby
Connect to Clari data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
How to connect to WordPress Data from Spring Boot
Connect to WordPress in a Spring Boot Application using the CData JDBC Driver for WordPress
-
Analyze Zuora Data in Cognos Analytics
Use CData Connect AI to connect to Zuora Data from Cognos Analytics and analyze live Zuora data.
-
Build Vertica-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Vertica data.
-
Automated Continuous Bitly Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Bitly replication to Apache Cassandra.
-
Build a PostgreSQL Interface for xBase Data using the CData JDBC Driver
Use the Remoting features of the xBase JDBC Driver to create a PostgreSQL entry-point for data access.
-
Publish Reports with Autopilot Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Autopilot data.
-
Getting Started with the CData Tableau Connector for SAP SuccessFactors LMS
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for SAP SuccessFactors LMS.
-
Build a Singer.io Tap for SAP Hybris C4C With the CData Python Connector
Learn how to easily build a Singer.io Tap for live SAP Hybris C4C data using the CData Python Connector.
-
Analyze Live Active Directory Data in SAS Viya
Use CData Connect AI to connect to Active Directory data from SAS Viya and deploy self-service analytics using live Active Directory data.
-
Create Amazon S3-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Amazon S3 Data from Klipfolio and build custom visualizations using live Amazon S3 data.
-
Build Facebook Ads-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Facebook Ads data and build web apps with connectivity to live Facebook Ads data.
-
Integrate Tanda with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Tanda with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Tanda data.
-
Configure the CData JDBC Driver for Marketo in a Connection Pool in Tomcat
Connect to Marketo data from a connection pool in Tomcat.
-
Access Live SAP SuccessFactors LMS Data in Roo Code via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Roo Code agents to securely access and build applications with live SAP SuccessFactors LMS data through MCP integration.
-
Configure the CData JDBC Driver for Campaigner in a Connection Pool in Tomcat
Connect to Campaigner data from a connection pool in Tomcat.
-
Integrating Kiro with Box 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.
-
Integrate Live Azure DevOps Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Azure DevOps from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Azure DevOps data.
-
Create Informatica Mappings From/To a JDBC Data Source for JobNimbus
Create JobNimbus data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Automated Continuous DocuSign Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable DocuSign replication to Google BigQuery.
-
Integrating Cursor with SparkPost 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 DocuSign Data from PowerBuilder via JDBC
This article demonstrates how to access DocuSign data from PowerBuilder using the DocuSign JDBC Driver.
-
Automated Continuous Google Directory Replication to SingleStore
Use CData Sync for automated, continuous, customizable Google Directory replication to SingleStore.
-
Stream Factorial Data into Apache Kafka Topics
Access and stream Factorial data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Working with Twilio Data in LINQPad
Execute LINQ queries to Twilio data in LINQPad.
-
Connect OpenWeatherMap to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live OpenWeatherMap data using the CData Python MCP Server.
-
Import Real-Time Bullhorn CRM Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Bullhorn CRM data in ColdFusion.
-
How to work with SAP BusinessObjects BI Data in Apache Spark using SQL
Access and process SAP BusinessObjects BI Data in Apache Spark using the CData Software JDBC Driver.
-
How to Visualize Keap Data in Python with pandas
Use pandas and other modules to analyze and visualize live Keap data in Python.
-
Automated Continuous Elasticsearch Replication to SQLite
Use CData Sync for automated, continuous, customizable Elasticsearch replication to SQLite.
-
Create Power BI Reports on Real-Time Insightly Data
Use the CData ODBC Driver for Insightly to visualize Insightly data in Power BI Desktop.
-
Visualize Superchat 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 Superchat data into TIBCO Spotfire.
-
Automated Continuous Close Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Close replication to Amazon Redshift.
-
Create Dashboards and Visualize Live Salesforce CRM Analytics Data in Geckoboard
Use CData Connect AI to connect to live Salesforce CRM Analytics data and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Connect to SAP from a Connection Pool in WebLogic
Use the CData JDBC Driver for SAP to connect to SAP data from Web applications running on WebLogic.
-
Integrate Square Data into Power Automate Desktop using CData Connect
CData Connect for Square Data enables you to integrate Square data into workflows built using Microsoft Power Automate Desktop.
-
Build Semantic Layer Views for API Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for API data.
-
Use Manus AI to Talk to Your Hive Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Manus AI agents to securely answer questions and take actions on Hive data.
-
Automated Continuous CSV Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable CSV replication to Azure SQL Database.
-
Create PagerDuty Dataflows on PowerBI.com
Connect to the CData Power BI Connector for PagerDuty from PowerBI.com to create Power BI Dataflows with real-time data.
-
Connect to SharePoint Excel Services in SpagoBI
Create reports featuring live SharePoint Excel Services data in SpagoBI Studio. Host SharePoint Excel Services reports on SpagoBI Server.
-
Access Live Microsoft Exchange Data in AWS Lambda
Connect to live Microsoft Exchange data in AWS Lambda using the CData JDBC Driver.
-
Getting Started with the CData Python Connector for BigCommerce
Learn to install and license the CData Python Connector and configure a connection to live BigCommerce data.
-
Analyze Apollo Data in Cognos Analytics
Use CData Connect AI to connect to Apollo Data from Cognos Analytics and analyze live Apollo data.
-
Getting Started with the CData Tableau Connector for EnterpriseDB
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for EnterpriseDB.
-
Write a Simple Go Application to work with Dotmailer Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Dotmailer data.
-
Access Live OpenWeatherMap Data in AWS Lambda
Connect to live OpenWeatherMap data in AWS Lambda using the CData JDBC Driver.
-
How to Work with Adobe Experience Manager Data in ETL Validator JDBC
Connect to Adobe Experience Manager from ETL Validator jobs using the CData Software JDBC Driver.
-
Build Charts with MongoDB Data in Clear Analytics
Create dynamic charts and perform analytics based on MongoDB data in Clear Analytics.
-
How to update SharePoint from Excel
This article explains how to transfer data from Excel to SharePoint using the Excel Add-In for SharePoint.
-
Build Apps with Live GitHub Data Using the Low-Code Development Platform of Mendix
Connect GitHub data with Mendix to build apps using the CData JDBC Driver for GitHub.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Notion
Provide connectivity to Notion data through an SAP BusinessObjects universe.