CData Software - Knowledge Base
Recent Articles
-
Automated Continuous DB2 for i Replication to SQL Server
Use CData Sync for automated, continuous, customizable DB2 for i replication to SQL Server.
-
Automate Monday.com Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live Monday.com and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
Excel Spreadsheet Automation on Autopilot Data with the QUERY Formula
Pull data from Autopilot, automate spreadsheets, and more with the QUERY formula.
-
Automate ServiceNow Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live ServiceNow and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
How to Connect Flowise AI Agents to Live DocuSign Data via CData Connect AI
Integrate Flowise AI with the CData Connect AI MCP Server to enable agents to securely query and act on live DocuSign without replication.
-
Integrate with Live Google Ad Manager Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Google Ad Manager from the MuleSoft Anypoint Platform to integrate live Google Ad Manager into custom reports and dashboards.
-
Connect ZohoDesk Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your ZohoDesk using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Integrate Open WebUI with Live Amazon DynamoDB Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Amazon DynamoDB from within the chat interface.
-
Automated Continuous LionDesk Replication to Oracle
Use CData Sync for automated, continuous, customizable LionDesk replication to Oracle.
-
Connect to Perigon Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Perigon and the SQL Gateway to access Perigon from Google Apps Script.
-
Using Your Own Sender ID and Password with the Sage Intacct API
How to configure your own Web Services Sender ID and Password for use with the Sage Intacct API in CData products.
-
Create Dashboards and Visualize Live Cloudant Data in Geckoboard
Use CData Connect AI to connect to live IBM Cloudant and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Import Real-Time Klipfolio Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Klipfolio in ColdFusion.
-
Use Grok to Talk to Your Redis 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 Redis for you.
-
Analyze Timely Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Timely in Microsoft R Open.
-
Publish Google Analytics-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Google Analytics.
-
Connect to Sybase IQ Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Sybase IQ to connect to Sybase IQ and execute queries in PowerBuilder.
-
Analyze Odoo Data in Infragistics Reveal
Use the CData API Server to create an OData API on top of Odoo ERP and visualize live Odoo ERP in Infragistics Reveal.
-
Automated Continuous Clockify Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Clockify replication to AlloyDB.
-
Create Dashboards and Visualize Live ServiceNow Data in Geckoboard
Use CData Connect AI to connect to live ServiceNow and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Connect to Perigon Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Perigon using standard SQL.
-
Amplitude Reporting in OBIEE with the Amplitude JDBC Driver
Deploy the Amplitude JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Access Live Acumatica Data in AWS Lambda
Connect to live Acumatica ERP in AWS Lambda using the CData JDBC Driver.
-
How to Seamlessly Import Zoho Inventory Data into IBM SPSS Modeler
Integrate Zoho Inventory data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Build HBase-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for HBase Data and create custom apps in Mendix.
-
Moving Data from HelloSign to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live HelloSign data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Automated Continuous Datadog Replication to MySQL
Use CData Sync for automated, continuous, customizable Datadog replication to MySQL.
-
Connect and Query Live Monday.com Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Monday.com into Databricks
-
Use the CData Software JDBC Driver for EnterpriseDB in MicroStrategy
Connect to EnterpriseDB in MicroStrategy Developer using the CData Software JDBC Driver for EnterpriseDB.
-
Publish Workable-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Workable.
-
Replicate Multiple ZohoInvoice Accounts via the CData Sync CLI
Replicate multiple ZohoInvoice accounts to one or many databases.
-
Viewing Google Search Results in RAD Studio Data Explorer
How to view Google Search in RAD Studio Data Explorer using the CData ODBC Driver for Google Search.
-
Automated Continuous Recurly Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Recurly replication to OneLake in Microsoft Fabric.
-
How to connect PolyBase to Acumatica
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Acumatica ERP.
-
Analyze AdRoll Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze AdRoll with the CData JDBC Driver for AdRoll.
-
Prepare, Blend, and Analyze Google Contacts Data in Alteryx Designer (ODBC)
Build workflows to access live Google Contacts for self-service data analytics.
-
Integrating Kiro CLI with Omnisend 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.
-
Visualize SAS Data Sets Data in Tableau
The CData ODBC driver for SAS Data Sets enables you integrate SAS Data Sets into Tableau dashboards.
-
Process & Analyze Nethunt Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Nethunt Data.
-
MarkLogic Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to MarkLogic through CData Connect AI using different applications and tools.
-
Automated Continuous BambooHR Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable BambooHR replication to PostgreSQL.
-
Validate EnterpriseDB Data with QuerySurge
Access and validate EnterpriseDB in QuerySurge using the CData JDBC Driver.
-
Automate Clio Data Replication to Azure Synapse
Use CData Sync to customize and automate Clio replication to Azure Synapse.
-
Create Datasets from Browserless in Domo Workbench and Build Visualizations of Browserless Data in Domo
Use the CData Software ODBC Driver for Browserless to create datasets from Browserless in Domo Workbench and then build visualizations in the Domo service.
-
How to Access Sage Cloud Accounting Data Using Entity Framework
This article shows how to access Sage Business Cloud Accounting using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Create EnterpriseDB Dataflows on PowerBI.com
Connect to the CData Power BI Connector for EnterpriseDB from PowerBI.com to create Power BI Dataflows with real-time data.
-
How to Visualize Presto Data in Python with pandas
Use pandas and other modules to analyze and visualize live Presto in Python.
-
Integrating Antigravity CLI with Paymo via CData CLI
Connect Paymo to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
How to update Google Sheets from Excel
This article explains how to transfer data from Excel to Google Sheets using the Excel Add-In for Google Sheets.
-
Create Informatica Mappings From/To a JDBC Data Source for DocuSign
Create DocuSign data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
LINQ to Amazon Marketplace 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 Amazon Marketplace Data Provider.
-
Connect to FTP Data as an External Data Source using PolyBase
Use CData Connect AI and PolyBase to create an external data source in SQL Swerver with access to live FTP Servers.
-
Automated Continuous Dotmailer Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Dotmailer replication to Apache Cassandra.
-
Use the CData ODBC Driver for SQL Server from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for SQL Server to connect to Microsoft SQL Server from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Microsoft SQL Server in Excel.
-
Connect to GetResponse Data as an External Source in Dremio
Use the CData JDBC Driver to connect to GetResponse as an External Source in Dremio.
-
Integrating LlamaIndex with JSON Services via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on JSON in real time.
-
Build Semantic Layer Views for Zuora Data in APOS Live Data Gateway
Use the CData Connector for Zuora in APOS Live Data Gateway to build Semantic Layer Views for Zuora.
-
Visualize Live Smartsheet Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Smartsheet.
-
Connect to Box Data from Crystal Reports
Use CData Connect AI to connect to and report on live Box from Crystal Reports.
-
How to Create Power BI Visual Reports with Real-Time Zoho Inventory Data
Use CData Power BI Connectors to visualize Zoho Inventory in Power BI.
-
Create Dynamic Clari Grids Using the Infragistics XamDataGrid
Learn how you can connect Clari to Infragistics XamDataGrid to build dynamic grids.
-
Connect to Egnyte in SpagoBI
Create reports featuring live Egnyte in SpagoBI Studio. Host Egnyte reports on SpagoBI Server.
-
How to Query Live Foursquare Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Foursquare data in natural language using Python.
-
Process & Analyze PolarTeamPro Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live PolarTeamPro Data.
-
Access Dropbox Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Dropbox from HeidiSQL.
-
Design BIRT Reports on FreshBooks Data
Provide current FreshBooks to your embedded analytics.
-
How to work with Oracle Eloqua Reporting Data in Apache Spark using SQL
Access and process Oracle Eloqua Reporting Data in Apache Spark using the CData Software JDBC Driver.
-
How to Easily Query Spotify Data in OpenOffice Base
Connect to Spotify data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
How to connect PolyBase to Spark
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Apache Spark SQL.
-
Visualize MailerSend Data in TIBCO Spotfire through ADO.NET
Integrate MailerSend into dashboards in TIBCO Spotfire.
-
Visualize Live Google Cloud Storage Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Google Cloud Storage using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Consume Google Contacts OData Feeds in PowerBuilder
This article demonstrates how to consume Google Contacts as OData feeds from PowerBuilder using the API Server.
-
Automated Continuous Calendly Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Calendly replication to IBM DB2.
-
Migrating data from Couchbase to Snowflake using CData SSIS Components.
Easily push Couchbase to Snowflake using the CData SSIS Tasks for Couchbase and Snowflake.
-
Build Semantic Layer Views for Authorize.Net Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Authorize.Net.
-
Connect to Real-Time Microsoft Dataverse Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Microsoft Dataverse and Dataflow to import and use Microsoft Dataverse (CDS) in Power Apps.
-
Create Microsoft Planner-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Microsoft Planner Data from OutSystems and build custom enterprise apps using live Microsoft Planner.
-
Building Dynamic Web Pages with Oracle SCM Data Using AngularJS
Create single-page applications with live connectivity to Oracle SCM using the CData API Server.
-
Integrate Tavily Data in the Pentaho Report Designer
Publish reports based on Tavily in the Pentaho BI tool.
-
Automated Continuous Avalara AvaTax Replication to Vertica
Use CData Sync for automated, continuous, customizable Avalara AvaTax replication to Vertica.
-
Create Datasets from QuickBooks Time in Domo Workbench and Build Visualizations of QuickBooks Time Data in Domo
Use the CData Software ODBC Driver for QuickBooks Time to create datasets from QuickBooks Time in Domo Workbench and then build visualizations in the Domo service.
-
Getting Started with the CData Power BI Connector for Chargebee
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Bidirectional Access to JotForm Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate JotForm in Filemaker Pro for Mac or Windows.
-
Use Azure AI Foundry to Talk to Your Amazon Marketplace Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Azure AI Foundry agents to securely answer questions and take actions on your Amazon Marketplace for you.
-
Use the CData Software ODBC Driver for Pipeliner CRM in MicroStrategy
Connect to Pipeliner CRM in MicroStrategy Developer using the CData Software ODBC Driver for Pipeliner CRM.
-
DataBind Controls to Typeform Data in Delphi
DataBind to Typeform in Delphi with standard data access components and controls.
-
Connect to Outreach.io Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Outreach.io from Filemaker Pro on Mac.
-
Import Real-Time Google Search Results via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Google Search in ColdFusion.
-
Automated Continuous Workday Replication to SQL Server
Use CData Sync for automated, continuous, customizable Workday replication to SQL Server.
-
Access Live Pushbullet Data in AWS Lambda
Connect to live Pushbullet in AWS Lambda using the CData JDBC Driver.
-
Integrating Antigravity CLI with QuickBooks Desktop via CData CLI
Connect QuickBooks Desktop to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Visualize HubSpot Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to HubSpot.
-
Getting Started with the CData ODBC Driver for Phoenix
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Phoenix.
-
Building Dynamic Web Pages with Confluence Data Using AngularJS
Create single-page applications with live connectivity to Confluence using the CData API Server.
-
Create Dynamic PingOne Grids Using the Infragistics XamDataGrid
Learn how you can connect PingOne to Infragistics XamDataGrid to build dynamic grids.
-
Use CData Connect AI to Access SAP Fieldglass Data in Microsoft Power Pivot
Use CData Connect AI to connect to live SAP Fieldglass in the Power Pivot business intelligence tool.
-
Rapidly Develop WordPress-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 WordPress.
-
Replicate Dynamics CRM Data in Heroku for Use in Salesforce Connect
Replicate Microsoft Dynamics CRM to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Connecting Moonlit Workflow with Okta Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Moonlit workflows to securely read and act on your Okta in real time.
-
Connect to MarkLogic Data in Claris FileMaker Pro
Use the CData ODBC Driver for MarkLogic in FileMaker Pro to connect to MarkLogic and work with MarkLogic in your FileMaker applications.