CData Software - Knowledge Base
Recent Articles
-
Build Apps with Live Tally data in Adalo using CData Connect AI
Use CData Connect AI to integrate live Tally data into the Adalo platform and build custom mobile and web applications with real-time Tally data.
-
Automated Continuous Authorize.Net Replication to Vertica
Use CData Sync for automated, continuous, customizable Authorize.Net replication to Vertica.
-
How to Connect to Live Epicor Kinetic Data from Claude Agent SDK (via CData Connect AI)
Leverage CData Connect AI to enable Claude Agent SDK applications to securely read and take actions on your Epicor Kinetic data for you.
-
Access Live SAP ByDesign Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live SAP ByDesign data from your Excel spreadsheets.
-
DataBind Charts to Acumatica Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Acumatica data 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.
-
How to Work with MongoDB Data in AWS Glue Jobs Using JDBC
Connect to MongoDB from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Feed Foursquare Data into FineReport
How to set Foursquare data as a JDBC data source in FineReport.
-
Connecting Agentforce with Sage Intacct Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Agentforce to securely read and take actions on your Sage Intacct data for you.
-
Integrating Boomi Agentstudio with Azure Table Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Azure Table data, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
LINQ to Freshdesk 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 Freshdesk Data Provider.
-
Consume Oracle OData Feeds in PowerBuilder
This article demonstrates how to consume Oracle data as OData feeds from PowerBuilder using the API Server.
-
How to integrate Metabase with Quickbase Data
Use CData Connect AI to connect to live Quickbase data and create an interactive dashboard in Metabase from Quickbase data.
-
Connect to Paylocity Data in Aqua Data Studio
Access Paylocity data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Use the CData Software JDBC Driver for NASA in MicroStrategy
Connect to NASA data in MicroStrategy Developer using the CData Software JDBC Driver for NASA.
-
Visualize Mailgun 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 Mailgun data into TIBCO Spotfire.
-
Use the CData ODBC Driver for CloudConvert from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for CloudConvert to connect to CloudConvert data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring CloudConvert data in Excel.
-
Back Up Gorgias 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 Gorgias data data.
-
Connect to QuickBooks Online from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from QuickBooks Online data, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Integrate Live Exact Online Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Exact Online data and integrate live Exact Online data into apps built in Microsoft Power Apps.
-
How to Connect to Live Avro 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 Avro data without replication.
-
Automated Continuous Oracle Eloqua Reporting Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Oracle Eloqua Reporting replication to IBM DB2.
-
How to Easily Query OData Services in OpenOffice Base
Connect to OData data in OpenOffice Base using the CData ODBC Driver for OData and generate reports with live data insights.
-
Connect to Tavily Data Using the Script Function in Claris FileMaker Pro
Use the CData API Driver for ODBC and the Script function in FileMaker Pro to connect to Tavily and work with Tavily data in your FileMaker application.
-
Integrate Dynamics 365 Business Central Data in the Pentaho Report Designer
Publish reports based on Dynamics 365 Business Central data in the Pentaho BI tool.
-
Create Datasets from Templated in Domo Workbench and Build Visualizations of Templated Data in Domo
Use the CData Software ODBC Driver for Templated to create datasets from Templated data in Domo Workbench and then build visualizations in the Domo service.
-
Automated Couchbase Data Replication to Teradata
Use CData Sync to Customize and automate Couchbase data replication to Teradata.
-
Extract, Transform, and Load ZohoPeople Data in Informatica PowerCenter
Create a simple Workflow for ZohoPeople data in Informatica PowerCenter.
-
Create Google Drive-Connected Applications in Appsmith
Connect to Google Drive Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Google Drive data.
-
Back Up MarkLogic data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for MarkLogic. In this article, we will employ an SSIS workflow to populate a database with MarkLogic data data.
-
Connect to SendInBlue Data in Aqua Data Studio
Access SendInBlue data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
How to Visualize Jumpseller Data in Python with pandas
Use pandas and other modules to analyze and visualize live Jumpseller data in Python.
-
How to Work with Gmail Data in ETL Validator JDBC
Connect to Gmail from ETL Validator jobs using the CData Software JDBC Driver.
-
How to integrate SpaceX with Apache Airflow
Access and process SpaceX data in Apache Airflow using the CData JDBC Driver.
-
Use the CData Software JDBC Driver for SAP ByDesign in MicroStrategy
Connect to SAP ByDesign data in MicroStrategy Developer using the CData Software JDBC Driver for SAP ByDesign.
-
DataBind ZohoExpense Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide ZohoExpense data to a chart.
-
Getting Started with the CData JDBC Driver for Authorize.Net
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Authorize.Net.
-
Integrating OpenCode with Google Spanner 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.
-
Query Impala Data in DataGrip
Create a Data Source for Impala in DataGrip and use SQL to query live Impala data.
-
Automated Continuous Email Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Email replication to IBM DB2.
-
Import Real-Time Factorial Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Factorial data in ColdFusion.
-
Use Grok to Talk to Your Cosmos DB Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Grok AI to securely answer questions and take actions on your Cosmos DB data for you.
-
Bind Live MailChimp Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live MailChimp data and seamlessly connect and bind them to Wijmo's FlexGrid for real-time, interactive data access without manual data movement.
-
Use CData Connect AI to Access AlloyDB Data in Microsoft Power Pivot
Use CData Connect AI to connect to live AlloyDB data in the Power Pivot business intelligence tool.
-
Connect and Query Live MySQL Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live MySQL data into Databricks and enable direct, live querying and analysis without replication.
-
Connect to Google Drive Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Google Drive to connect to Google Drive data and execute queries in PowerBuilder.
-
Connect to SuiteCRM Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for SuiteCRM and the SQL Gateway to access SuiteCRM data from Google Apps Script.
-
Automated Continuous Google Calendar Replication to SQL Server
Use CData Sync for automated, continuous, customizable Google Calendar replication to SQL Server.
-
Build MVC Applications with Connectivity to Insightly Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Insightly from an ASP.NET MVC application.
-
How to Connect to & Open Close Data in Microsoft Excel
This article uses the CData ODBC driver for Close to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Consume Klaviyo OData Feeds in PowerBuilder
This article demonstrates how to consume Klaviyo data as OData feeds from PowerBuilder using the API Server.
-
Extract, Transform, and Load Google Translate Data in Informatica PowerCenter
Create a simple Workflow for Google Translate data in Informatica PowerCenter.
-
Back Up Pipeline CRM 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 Pipeline CRM data data.
-
Integrate Real-Time Access to Salesloft in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Salesloft data in real time.
-
Migrating data from Onfleet to Google BigQuery using CData SSIS Components.
Easily push Onfleet data to Google BigQuery using the CData SSIS Tasks for Onfleet and Google BigQuery.
-
LINQ to Google Tasks 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 Google Tasks Data Provider.
-
A PostgreSQL Interface for MailerSend Data (MySQL Remoting via JDBC)
Use the Remoting features of the MailerSend JDBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to Acumatica Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to Acumatica.
-
Create Data Visualizations Based On Adobe Commerce Data in Mode
Use CData Connect AI to connect to Adobe Commerce Data from Mode and build visualizations using live Adobe Commerce data.
-
How to connect and process BambooHR data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live BambooHR data.
-
Connect to Salesforce Data 360 Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Salesforce Data 360 data.
-
Connect to Samanage Data in ACL Analytics
Connect to Samanage data via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Samanage data.
-
Automated Continuous HBase Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable HBase replication to Azure SQL Database.
-
Replicate Multiple Retently Accounts via the CData Sync CLI
Replicate multiple Retently accounts to one or many databases.
-
Automated Continuous Azure Synapse Replication to Snowflake
Use CData Sync for automated, continuous, customizable Azure Synapse replication to Snowflake.
-
Import Real-Time Marketo Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Marketo data in ColdFusion.
-
Build AI Agents with Hive Data in IBM watsonx Orchestrate using CData Connect AI
Learn how to build intelligent agents in IBM watsonx Orchestrate that can securely access and act on live Hive data through CData Connect AI.
-
Use Manus AI to Talk to Your Microsoft Entra ID 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 Microsoft Entra ID data.
-
Automated Continuous ActiveCampaign Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable ActiveCampaign replication to Apache Kafka.
-
Automated Continuous Opsgenie Replication to SQLite
Use CData Sync for automated, continuous, customizable Opsgenie replication to SQLite.
-
Automated Mailgun Data Replication to Teradata
Use CData Sync to Customize and automate Mailgun data replication to Teradata.
-
Write a Simple Go Application to work with ChartMogul Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to ChartMogul data.
-
How to connect PolyBase to ServiceDesk Plus
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live ServiceDesk Plus data.
-
Create ConstantContact-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to ConstantContact Data from OutSystems and build custom enterprise apps using live ConstantContact data.
-
Use ChatGPT to Talk to Your Paylocity 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 Paylocity data for you.
-
Automated Continuous QuickBooks Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable QuickBooks replication to PostgreSQL.
-
Connect to Slack Data from AWS Glue
Use CData Connect AI to gain access to live Slack data from your AWS Glue jobs.
-
Build an OLAP Cube in SSAS from Reckon Data
Establish a connection to Reckon data data from SQL Server Analysis Services, and use the Reckon Data Provider to build OLAP cubes for use in analytics and reporting.
-
Model, Search, and Visualize Live Sybase IQ Data in ThoughtSpot
Use CData Connect AI to connect to live Sybase IQ data for modeling, searching, and visualizing.
-
How to Easily Query Keap Data in OpenOffice Base
Connect to Keap data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Build Dashboards with Outreach.io Data in Dundas BI
Create dynamic dashboards and perform analytics based on Outreach.io data in Dundas BI.
-
Integrate SAP Hybris C4C Data in the Pentaho Report Designer
Publish reports based on SAP Hybris C4C data in the Pentaho BI tool.
-
Automated Continuous Paddle Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Paddle data replication to OneLake in Microsoft Fabric.
-
Access Live Neo4J Data in TIBCO Data Virtualization
Use the Neo4J Tibco DV Adapter to create a Neo4J data data source in TIBCO Data Virtualization Studio and gain access to live Neo4J data from your TDV Server.
-
Validate Okta Data with QuerySurge
Access and validate Okta data in QuerySurge using the CData JDBC Driver.
-
Build Google Calendar-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Google Calendar data and build web apps with connectivity to live Google Calendar data.
-
Manage Codat Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Codat.
-
How to Connect Sage Intacct Data to Gemini Enterprise via CData Connect AI
Connect CData Connect AI Remote MCP to Gemini Enterprise to securely read and take actions on live Sage Intacct data in real time using natural language.
-
Build a Simple VCL Application for BambooHR Data
How to build a simple VCL Application to view BambooHR data in RAD Studio using the CData ODBC Driver for BambooHR.
-
Build Dashboards with ConstantContact Data in DBxtra
Create dynamic dashboards and perform analytics based on ConstantContact data in DBxtra.
-
Access Live Notion Data in Coginiti Pro
Connect to and query live Notion data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
How to Access Live GitHub Data in Power Automate Desktop via ODBC
The CData ODBC Driver for GitHub enables you to integrate GitHub data into workflows built using Microsoft Power Automate Desktop.
-
Use the CData Software JDBC Driver for Azure Table in MicroStrategy
Connect to Azure Table data in MicroStrategy Developer using the CData Software JDBC Driver for Azure Table.
-
Create Reports with SAP Hybris C4C Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date SAP Hybris C4C data.
-
Use Databricks Agent Bricks to Talk to Your Amazon S3 Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Amazon S3 data for you.
-
Integrate Open WebUI with Live SAP ByDesign Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live SAP ByDesign data from within the chat interface.
-
Connect to PagerDuty Data in JRuby
Create a simple JRuby app with access to live PagerDuty data.
-
Connecting Mastra with Snowflake 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 Snowflake data, no replication required.
-
Connect to Couchbase Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Couchbase data using standard SQL.
-
Replicate FreeAgent Data from PowerShell
Write a quick PowerShell script to query FreeAgent data. Use connectivity to the live data to replicate FreeAgent data to SQL Server.
-
Build AI/ML Models with Live Microsoft Ads Data using Dataiku
Connect Microsoft Ads Data with Dataiku using the CData JDBC Driver for Microsoft Ads.