CData Software - Knowledge Base
Recent Articles
-
LINQ to Act-On 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 Act-On Data Provider.
-
Build Sage Cloud Accounting-Powered Applications in Cursor with CData MCP Server
Use the CData MCP Server for Sage Cloud Accounting to explore live Sage Cloud Accounting Data in Cursor to assist with building Sage Cloud Accounting-powered applications.
-
Integrate MongoDB Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to MongoDB and integrate live MongoDB into your Power Automate tasks.
-
Analyze ZohoMarketingHub Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for ZohoMarketingHub from Power Pivot. You will use the Table Import Wizard to load ZohoMarketingHub. You can visually build the import query or use any SQL supported by the driver.
-
Automate Clari Data Replication to Azure Data Lake
Use CData Sync to customize and automate Clari replication to Azure Data Lake.
-
Automate LinkedIn Data Replication to Couchbase
Use CData Sync to Customize and automate LinkedIn replication to Couchbase.
-
How to Import Data from Azure Data Lake Storage into Google Sheets
Import Azure Data Lake Storage into a Google spreadsheet that is automatically refreshed.
-
Query Google Directory Data as a SQL Server Database in Node.js
Execute SQL Server queries against Google Directory from Node.js.
-
Create Data Visualizations in Cognos BI with ZohoSubscriptions Data
Access ZohoSubscriptions as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Publish Bitbucket-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Bitbucket.
-
Build Oracle SCM-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Oracle SCM Data and create custom apps in Mendix.
-
Use the CData Software ODBC Driver for Copper in MicroStrategy Desktop
Connect to Copper in MicroStrategy Desktop using the CData Software ODBC Driver for Copper.
-
Feed Timely Data into FineReport
How to set Timely as a JDBC data source in FineReport.
-
Access Live Avalara AvaTax Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Avalara AvaTax from your Google Sheets.
-
Connect to Wrike Data from PowerBuilder via JDBC
This article demonstrates how to access Wrike from PowerBuilder using the Wrike JDBC Driver.
-
Visualize SparkPost Data in TIBCO Spotfire through ADO.NET
Integrate SparkPost into dashboards in TIBCO Spotfire.
-
Choosing the Best Method to Connect Jira to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Atlassian Jira from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Visualize Wistia 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 Wistia into TIBCO Spotfire.
-
Write a Simple Go Application to work with Freshteam Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Freshteam.
-
Object-Relational Mapping (ORM) with Sage 200 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 Sage 200 into a Java-based ORM framework, Hibernate.
-
How to Visualize Cloudant Data in Python with pandas via CData Connect AI
Use the CData Connect AI Python SDK with pandas and Matplotlib to analyze and visualize live IBM Cloudant in Python.
-
Connect Snapchat Ads to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Snapchat Ads using the CData Python MCP Server.
-
Create SSAS Tabular Models from Slack Data
How to build a SQL Server Analysis Service Tabular Model from Slack using CData drivers.
-
Replicate Flowlu Data in Heroku for Use in Salesforce Connect
Replicate Flowlu to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
How to Connect to Live Airtable 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 Airtable for you.
-
Connect to SharePoint Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with SharePoint Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Integrating Kiro CLI with Square 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.
-
How to connect PolyBase to Scrapfly
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Scrapfly.
-
Validate AfterShip Data with QuerySurge
Access and validate AfterShip in QuerySurge using the CData JDBC Driver.
-
Establish a Live Connection with ZohoMarketingHub Data using Tableau Bridge
The CData ODBC Driver for ZohoMarketingHub enables you to integrate live ZohoMarketingHub into Tableau Cloud dashboards using the Tableau Bridge.
-
Build Apps with Live Zendesk Data Using the Low-Code Development Platform of Mendix
Connect Zendesk with Mendix to build apps using the CData JDBC Driver for Zendesk.
-
Access Float Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Float from HeidiSQL.
-
Provide OData Services of Exact Online Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Exact Online by developing a WCF Service Application.
-
Build Impala-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Impala Data and create custom apps in Bubble.
-
Replicate Multiple REST Accounts via the CData Sync CLI
Replicate multiple REST accounts to one or many databases.
-
Integrate Live Act CRM Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Act CRM and integrate live Act CRM into apps built in Microsoft Power Apps.
-
ETL Figshare in Oracle Data Integrator
This article shows how to transfer Figshare into a data warehouse using Oracle Data Integrator.
-
Migrating data from Cassandra to Databricks using CData SSIS Components.
Easily push Apache Cassandra to Databricks using the CData SSIS Tasks for Cassandra and Databricks.
-
Build Dashboards with Neo4J Data in Dundas BI
Create dynamic dashboards and perform analytics based on Neo4J in Dundas BI.
-
Automated Continuous Facebook Ads Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Facebook Ads replication to OneLake in Microsoft Fabric.
-
Work with IBM Cloud Object Storage Data in FoxPro
Load IBM Cloud Object Storage into a FoxPro database. This article includes full code and a walk-through of the process.
-
Replicate Excel Data to Multiple Databases
Replicate Microsoft Excel to disparate databases with a point-and-click configuration.
-
How to Query Dynamics 365 Business Central Data in MySQL Workbench
Execute MySQL queries against live Dynamics 365 Business Central from MySQL Workbench.
-
Consume YouTube Analytics OData Feeds in PowerBuilder
This article demonstrates how to consume YouTube Analytics as OData feeds from PowerBuilder using the API Server.
-
DataBind Controls to ActiveCampaign Data in C++Builder
DataBind to ActiveCampaign in C++Builder with standard components and controls.
-
Connect to Autopilot Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Autopilot and work with Autopilot in your FileMaker applications.
-
How to connect to HCL Domino Data with Squirrel SQL client
Connect to HCL Domino and execute queries in the Squirrel SQL Client.
-
Access Amazon S3 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 Amazon S3.
-
Replicate Google Ads Data from PowerShell
Write a quick PowerShell script to query Google Ads. Use connectivity to the live data to replicate Google Ads to SQL Server.
-
Integrating Antigravity CLI with Monday.com via CData CLI
Connect Monday.com to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Access Live DocuSign Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live DocuSign from your Google Sheets.
-
How to Connect DBeaver to PagerDuty via a JDBC Driver
Manage PagerDuty with visual tools in DBeaver like the query browser.
-
How to connect to Deel Data from Spring Boot
Connect to Deel in a Spring Boot Application using the CData API Driver for JDBC
-
Create YouTube Analytics-Connected Dashboards in Grafana
Connect to YouTube Analytics Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to YouTube Analytics.
-
Deploy the ADO.NET Provider for Missive on an SSRS Report Server
Connect to Missive 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 ODBC Driver for Google Translate from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Google Translate to connect to Google Translate from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Google Translate in Excel.
-
Replicate GetResponse Data to Multiple Databases
Replicate GetResponse to disparate databases with a point-and-click configuration.
-
Build Pipelines with Live HCL Domino Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to HCL Domino from Google Cloud Data Fusion, enabling the integration of live HCL Domino into the building and management of effective data pipelines.
-
Integrating Kiro CLI with Tanda 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 Bitly Data in Aqua Data Studio
Access Bitly from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Integrate Live ClickTime Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live ClickTime to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Build Automated IBM Cloud Object Storage-Connected Workflows in Zapier
Use CData Connect AI to connect to live IBM Cloud Object Storage and build automated workflows in Zapier.
-
DataBind Charts to ZeroBounce Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to ZeroBounce from controls in the Visual Studio toolbox. This article demonstrates a graphical approach using wizards in Visual Studio, as well as how to databind with only a few lines of code.
-
Analyze Drip Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Drip with the CData JDBC Driver for Drip.
-
Creating SAP Ariba Source-Connected Applications in Unqork
You can use CData Connect AI to feed SAP Ariba Source to Unqork and build custom business apps.
-
Automated Continuous Amplitude Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Amplitude replication to AlloyDB.
-
Getting Started with the CData SSIS Components for Azure Synapse
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Azure Synapse.
-
Easily Integrate Avaza Data in Lazarus Pascal IDE
Learn how to easily integrate live Avaza in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Process & Analyze Adobe Commerce Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Adobe Commerce Data.
-
Bind Live SAP HANA XS Advanced Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live SAP HANA XS Advanced data
-
Viewing PayPal Data in RAD Studio Data Explorer
How to view PayPal in RAD Studio Data Explorer using the CData ODBC Driver for PayPal.
-
Visualize MailerLite Data in Tableau
The CData ODBC driver for MailerLite enables you integrate MailerLite into Tableau dashboards.
-
DataBind Charts to Lakebase Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Lakebase from controls in the Visual Studio toolbox. This article demonstrates a graphical approach using wizards in Visual Studio, as well as how to databind with only a few lines of code.
-
Build Visualizations of Typeform Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Typeform in Birst.
-
Build a Singer.io Tap for ChartMogul With the CData Python Connector
Learn how to easily build a Singer.io Tap for live ChartMogul data using
-
Access Exa Data from MySQL in PHP
Connect to Exa through the standard MySQL libraries in PHP.
-
How to Connect to Live Zoom Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Zoom securely in real time.
-
Process & Analyze Vercel Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Vercel Data.
-
Access Live Slack Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Slack from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
How to Access SAP Ariba Procurement Data Using Entity Framework
This article shows how to access SAP Ariba Procurement using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Create Datasets from Adobe Experience Manager in Domo Workbench and Build Visualizations of Adobe Experience Manager Data in Domo
Use the CData Software ODBC Driver for Adobe Experience Manager to create datasets from Adobe Experience Manager in Domo Workbench and then build visualizations in the Domo service.
-
Integrate Azure Data Lake Storage Data into Power Automate Desktop using CData Connect
CData Connect for Azure Data Lake Storage Data enables you to integrate Azure Data Lake Storage into workflows built using Microsoft Power Automate Desktop.
-
How to Build an ETL App for Moosend Data in Python with CData
Create ETL applications and real-time data pipelines for Moosend in Python with petl.
-
Publish Mailgun-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Mailgun.
-
Visualize Paymo Data in Sisense
Create an ElastiCube in Sisense app with access to Paymo.
-
Access PolarTeamPro 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 PolarTeamPro.
-
Automated Continuous Cvent Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Cvent replication to PostgreSQL.
-
Getting Started with the CData ADO.NET Provider for Telegram
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Connect to NetSuite Data in DBArtisan
Use wizards in DBArtisan to configure NetSuite CRM & ERP as a data source.
-
Integrate Cline with Live MailChimp Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live MailChimp from within your IDE.
-
Consume JSON OData Feeds in PowerBuilder
This article demonstrates how to consume JSON as OData feeds from PowerBuilder using the API Server.
-
Connect to Microsoft Dataverse Data from a Connection Pool in JBoss
Integrate Microsoft Dataverse (CDS) into Java servlets: Use the Management Console in JBoss to install the Microsoft Dataverse JDBC Driver.
-
Connect to Real-Time Workable Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Workable in Power Apps.
-
Connect Trello to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Trello with IBM WebSphere for seamless data integration and connectivity.
-
Publish Crystal Reports on Oracle Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Oracle Database.
-
Automated Mouseflow Data Replication to Teradata
Use CData Sync to Customize and automate Mouseflow replication to Teradata.
-
Build MySQL-Powered Applications in Cursor with CData MCP Server
Use the CData MCP Server for MySQL to explore live MySQL Data in Cursor to assist with building MySQL-powered applications.
-
Connect to Aha! Data in CloverDX (formerly CloverETL)
Transfer Aha! using the visual workflow in the CloverDX data integration tool.
-
How to connect SharePoint with Couchbase Data through external lists
Provide Couchbase to SharePoint users as an external list.
-
Use Manus AI to Talk to Your Facebook Ads 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 Facebook Ads.