CData Software - Knowledge Base
Recent Articles
-
Access Live SAP Ariba Procurement Data in AWS Lambda (with IntelliJ IDEA)
Connect to live SAP Ariba Procurement in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
How to Access Live Kintone Data in Visual Studio Code via Cline
Run CData MCP Server for Kintone on Windows Subsytem for Linux (WSL) and connect to live Kintone from the Cline extension in Visual Studio Code.
-
Build Apps with Live FTP Servers in Adalo using CData Connect AI
Use CData Connect AI to integrate live FTP Servers into the Adalo platform and build custom mobile and web applications with real-time FTP Servers.
-
Build Webex-Powered Applications in Claude Code with CData MCP Server
Use the CData API Driver for MCP Server to explore live Webex Data in Claude Code to assist with building Webex-powered applications.
-
Use Claude to Talk to Your SurveyMonkey 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 SurveyMonkey for you.
-
How to Connect to Live Microsoft Exchange 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 Microsoft Exchange without replication.
-
Use the CData Software JDBC Driver for Freshteam in MicroStrategy Web
Connect to Freshteam in MicroStrategy Web using the CData Software JDBC Driver for Freshteam.
-
Automated Continuous Wistia Replication to MongoDB
Use CData Sync for automated, continuous, customizable Wistia replication to MongoDB.
-
Use the CData ODBC Driver for Raisers Edge NXT from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Raisers Edge NXT to connect to Raisers Edge NXT from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Raisers Edge NXT in Excel.
-
Build Azure Data Lake Storage-Powered Applications in Cursor with CData MCP Server
Use the CData MCP Server for Azure Data Lake Storage to explore live Azure Data Lake Storage Data in Cursor to assist with building Azure Data Lake Storage-powered applications.
-
Automated Continuous ZohoExpense Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable ZohoExpense replication to OneLake in Microsoft Fabric.
-
How to Connect to & Open Exa Data in Microsoft Excel
This article uses the CData ODBC driver for Exa to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Load QuickBooks Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load QuickBooks Desktop to a database.
-
How to Import Data from Mixpanel into Google Sheets
Import Mixpanel into a Google spreadsheet that is automatically refreshed.
-
Visualize Facebook Ads Data in Sisense
Create an ElastiCube in Sisense app with access to Facebook Ads.
-
Build Data Flows from CircleCI to SQL Server using SSIS
Easily back up CircleCI to SQL Server using the SSIS components for CircleCI.
-
Connect to SAP HANA Data in DBArtisan
Use wizards in DBArtisan to configure SAP HANA as a data source.
-
Connect to TigerGraph Data from a Connection Pool in Jetty
The TigerGraph JDBC Driver supports connection pooling: This article shows how to connect faster to TigerGraph from Web apps in Jetty.
-
Build an OLAP Cube in SSAS from Typeform Data
Establish a connection to Typeform data from SQL Server Analysis Services, and use the Typeform Data Provider to build OLAP cubes for use in analytics and reporting.
-
Getting Started with the CData Power BI Connector for Coda
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Back Up Authorize.Net to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Authorize.Net. In this article, we will employ an SSIS workflow to populate a database with Authorize.Net data.
-
Connect to ZohoInvoice Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time ZohoInvoice using standard SQL.
-
Getting Started with the CData JDBC Driver for CloudConvert
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for CloudConvert.
-
Bind Live Sage Intacct Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Sage Intacct data
-
Automate Campaigner Data Replication to Azure Synapse
Use CData Sync to customize and automate Campaigner replication to Azure Synapse.
-
Consume Procore OData Feeds in PowerBuilder
This article demonstrates how to consume Procore as OData feeds from PowerBuilder using the API Server.
-
Connect to EnterpriseDB Data in Aqua Data Studio
Access EnterpriseDB from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
ETL Excel Online in Oracle Data Integrator
This article shows how to transfer Microsoft Excel Online into a data warehouse using Oracle Data Integrator.
-
Getting Started with the CData Power BI Connector for LaunchDarkly
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Build AI/ML Models with Live Salesforce Marketing Data using Dataiku
Connect Salesforce Marketing Data with Dataiku using the CData JDBC Driver for Salesforce Marketing Cloud.
-
Build AI/ML Models with Live Pipeline CRM Data using Dataiku
Connect Pipeline CRM Data with Dataiku using the CData API Driver for JDBC.
-
Connect to Paymo Data in RazorSQL
Connect to Paymo from wizards and query Paymo from the GUI in the RazorSQL database management tool.
-
Access Live Samanage Data in AWS Lambda
Connect to live Samanage in AWS Lambda using the CData JDBC Driver.
-
Visualize Live Spark Data in the Power BI Service
Use CData Connect AI to connect to live Apache Spark SQL and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Use the CData ODBC Driver for Zoho Creator in Microsoft Power Query
You can use the CData Zoho Creator ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Zoho Creator into Microsoft Power Query.
-
Build MVC Applications with Connectivity to Sage Intacct Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Sage Intacct from an ASP.NET MVC application.
-
Connect to Live MariaDB Data in MicroStrategy through CData Connect AI
Create a live connection to MariaDB Data in CData Connect AI and connect to your MariaDB from MicroStrategy.
-
Build Contentful-Powered Applications in Cursor with CData MCP Server
Use the CData API Driver for MCP Server to explore live Contentful Data in Cursor to assist with building Contentful-powered applications.
-
Connect to and Query SAP Business Warehouse Data in QlikView over ODBC
Create data visualizations with SAP Business Warehouse in QlikView.
-
Query Presto Data in ColdFusion
Write standard ColdFusion data access code to connect to Presto.
-
Automate Zoho Creator Data Replication to Azure Data Lake
Use CData Sync to customize and automate Zoho Creator replication to Azure Data Lake.
-
Visualize Tally Data in Tableau
The CData ODBC driver for Tally enables you integrate Tally ERP into Tableau dashboards.
-
Publish Crystal Reports on Slack Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Slack.
-
Integrating GitHub Copilot CLI with Salesforce Marketing Cloud 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.
-
Explore Geographical Relationships in ScrapingBee Data with Power Map
Create data visualizations with ScrapingBee in Power Map.
-
Automated Continuous Tanda Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Tanda replication to OneLake in Microsoft Fabric.
-
Integrate Odoo with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Odoo with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Odoo ERP.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live SAP BusinessObjects BI within intelligent workflows.
-
LINQ to Microsoft Planner 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 Microsoft Planner Data Provider.
-
Replicate CapsuleCRM Data to Multiple Databases via the CData Sync CLI
Replicate CapsuleCRM to disparate databases with a single configuration.
-
Build Dashboards with CampaignMonitor Data in DBxtra
Create dynamic dashboards and perform analytics based on CampaignMonitor in DBxtra.
-
Connect to Microsoft Dataverse Data in NetBeans
Connect to Microsoft Dataverse (CDS) in NetBeans with the data source configuration wizard.
-
Analyze Microsoft Entra ID Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Microsoft Entra ID from Power Pivot. You will use the Table Import Wizard to load Microsoft Entra ID. You can visually build the import query or use any SQL supported by the driver.
-
Integrating OpenCode Terminal with DocuSign 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 LionDesk Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time LionDesk data access from reports, embedded analytics, and more.
-
Integrate Live DB2 Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to IBM DB2 and integrate live IBM DB2 into apps built in Microsoft Power Apps.
-
How to Work with Microsoft OneDrive Data in AWS Glue Jobs Using JDBC
Connect to Microsoft OneDrive from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Deploy the ADO.NET Provider for HBase on an SSRS Report Server
Connect to Apache HBase 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 Datadog in MicroStrategy
Connect to Datadog in MicroStrategy Developer using the CData Software JDBC Driver for Datadog.
-
Analyze SAP ByDesign Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze SAP Business ByDesign in Microsoft R Open.
-
Integrate Zuora Data into Power Automate Desktop using CData Connect
CData Connect for Zuora Data enables you to integrate Zuora into workflows built using Microsoft Power Automate Desktop.
-
Connect to PabblySubscriptions Data in Jaspersoft Studio
Execute SQL to remote PabblySubscriptions in Jaspersoft Studio.
-
How to Connect to Live Freshservice Data from Google ADK Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Google ADK agents to securely read and take actions on your Freshservice for you.
-
Connect Act CRM Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Act CRM using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Build Paylocity-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Paylocity Data and create custom apps in Mendix.
-
Replicate HDFS Data to Multiple Databases via the CData Sync CLI
Replicate Apache HDFS to disparate databases with a single configuration.
-
Connecting GenSpark with Salesforce Pardot Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Salesforce Pardot without any replication or custom integration required.
-
Build Redshift-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Redshift Data and create custom apps in Mendix.
-
Create Airtable-Connected Applications in Appsmith
Connect to Airtable Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Airtable.
-
Getting Started with the CData Python Connector for Twilio
Learn to install and license the CData Python Connector
-
How to create an RPA flow for Google Ad Manager Data in UiPath Studio
Use the Google Ad Manager ODBC Driver to create workflows that access real-time Google Ad Manager without any coding.
-
Access SAP Hybris C4C Data from MySQL in Amazon QuickSight
Connect to SAP Hybris C4C and build visualizations of SAP Hybris C4C using a MySQL Connection in Amazon QuickSight.
-
Integrate with Live SurveyMonkey Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to SurveyMonkey from the MuleSoft Anypoint Platform to integrate live SurveyMonkey into custom reports and dashboards.
-
How to Query Live Missive Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Missive data in natural language using Python.
-
Create Data Visualizations in Cognos BI with Campaigner Data
Access Campaigner as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Build Dashboards with Postmark Data in DBxtra
Create dynamic dashboards and perform analytics based on Postmark in DBxtra.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Freshdesk
Provide connectivity to Freshdesk through an SAP BusinessObjects universe.
-
Integrate Real-Time Access to Google Translate in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Google Translate in real time.
-
Automated Continuous Dynamics CRM Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Dynamics CRM replication to IBM DB2.
-
Connecting Mastra with Google Ad Manager Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to enable Mastra agents to securely query, read, and act on real-time Google Ad Manager, no replication required.
-
Access Live Microsoft Dataverse Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live Microsoft Dataverse data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Create Informatica Mappings From/To a JDBC Data Source for Zoho Inventory
Create Zoho Inventory data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Connect to FTP Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for FTP Data and connect to FTP Servers in Akorbi Digital RunMyProcess.
-
Query Cloudant Data as a SQL Server Database in Node.js
Execute SQL Server queries against IBM Cloudant from Node.js.
-
Access Live Dynamics 365 Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Microsoft Dynamics 365 from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Import SAP Concur Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access SAP Concur. In this article, you will use the OData format to import SAP Concur into Microsoft Power Query.
-
Connect and Visualize Live Azure Analysis Services Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Azure Analysis Services into the Databricks platform and create visualization dashboards with real-time Azure Analysis Services.
-
How to connect to Amazon Athena Data with Squirrel SQL client
Connect to Amazon Athena and execute queries in the Squirrel SQL Client.
-
Build VWO-Powered Applications in Claude Code with CData MCP Server
Use the CData API Driver for MCP Server to explore live VWO Data in Claude Code to assist with building VWO-powered applications.
-
Analyze Codat Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Codat with the CData JDBC Driver for Codat.
-
Object-Relational Mapping (ORM) with Elasticsearch 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 Elasticsearch into a Java-based ORM framework, Hibernate.
-
Automated Continuous Cassandra Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Cassandra replication to PostgreSQL.
-
Extract, Transform, and Load Keap Data in Informatica PowerCenter
Create a simple Workflow for Keap in Informatica PowerCenter.
-
Connect to Clockify Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Clockify.
-
Build Azure Synapse-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Azure Synapse.
-
Getting Started with the CData Power BI Connector for Opsgenie
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
How to Easily Query Microsoft Teams Data in OpenOffice Base
Connect to Microsoft Teams data in OpenOffice Base using the CData ODBC Driver for Microsoft Teams and generate reports with live data insights.
-
Import Real-Time Retently Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Retently in ColdFusion.
-
Edit and Search GitLab External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of GitLab to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create GitLab objects that you can access from apps and the dashboard.
-
Trigger Salesforce Pardot IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for Salesforce Pardot with standard wizards in Logic Apps.