CData Software - Knowledge Base
Recent Articles
-
Automate Float Data Replication to Azure Data Lake
Use CData Sync to customize and automate Float replication to Azure Data Lake.
-
How to connect PolyBase to Microsoft Dataverse
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Microsoft Dataverse (CDS).
-
Connect to Live Microsoft Entra ID Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Microsoft Entra ID in CData Connect AI and connect to your Microsoft Entra ID from PostgreSQL.
-
Automate IBM Informix Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live IBM Informix and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
Integrating Kiro CLI with Planio 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.
-
Import Amazon DynamoDB Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Amazon DynamoDB. In this article, you will use the OData format to import Amazon DynamoDB into Microsoft Power Query.
-
Integrate Gmail Data in the Pentaho Report Designer
Publish reports based on Gmail in the Pentaho BI tool.
-
Query Placid Data as a MySQL Database in Node.js
Execute MySQL queries against Placid from Node.js.
-
Visualize Intercom Data in Sisense
Create an ElastiCube in Sisense app with access to Intercom.
-
Easily Integrate Figshare Data in Lazarus Pascal IDE
Learn how to easily integrate live Figshare in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Connect to Sybase IQ Data from PowerBuilder via ADO.NET
This article demonstrates how to access Sybase IQ from Appeon PowerBuilder using the CData ADO.NET Provider for Sybase IQ.
-
Integrate Freshsales Data in the Pentaho Report Designer
Publish reports based on Freshsales in the Pentaho BI tool.
-
How to Connect to Live Bullhorn CRM Data from Gemini CLI (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Gemini CLI to securely read and take actions on your Bullhorn CRM for you.
-
Build Automated Workflows with Live SAP ByDesign Data in Workato
Use CData Connect AI to connect to live SAP Business ByDesign and build automated workflows in Workato.
-
Connect GetResponse to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live GetResponse using the CData Python MCP Server.
-
Provide OData Services of Bugsnag Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Bugsnag by developing a WCF Service Application.
-
Create Dynamic LDAP Grids Using the Infragistics XamDataGrid
Learn how you can connect LDAP to Infragistics XamDataGrid to build dynamic grids.
-
Connect to Cloudant Data in Claris FileMaker Pro
Use the CData ODBC Driver for Cloudant in FileMaker Pro to connect to Cloudant and work with IBM Cloudant in your FileMaker applications.
-
Connect to Facebook Ads Data from AWS Glue
Use CData Connect AI to gain access to live Facebook Ads from your AWS Glue jobs.
-
Access Freshsales Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Freshsales from your Oracle system.
-
Publish Reports with AgileCRM Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date AgileCRM.
-
How to Access Live BenchmarkEmail Data in Power Automate Desktop via ODBC
The CData ODBC Driver for BenchmarkEmail enables you to integrate BenchmarkEmail into workflows built using Microsoft Power Automate Desktop.
-
Use the CData Software ODBC Driver for Suadeo in SAS for Real-Time Reporting and Analytics
Connect to real-time Suadeo in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Suadeo.
-
How to Access Live Perplexity Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Perplexity enables you to integrate Perplexity into workflows built using Microsoft Power Automate Desktop.
-
Access Live FTP Data in Excel 365 Online (Excel for the web)
Connect to FTP Servers from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Automated Continuous Tanda Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Tanda replication to AlloyDB.
-
Connect to Office 365 Data from PowerBuilder via JDBC
This article demonstrates how to access Microsoft Office 365 from PowerBuilder using the Office 365 JDBC Driver.
-
Import Real-Time RabbitMQ Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use RabbitMQ in ColdFusion.
-
Create Odoo Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Odoo from PowerBI.com to create Power BI Dataflows with real-time data.
-
Connect to Splunk Data in HULFT Integrate
Connect to Splunk as a JDBC data source in HULFT Integrate
-
Connect to Greenhouse Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Greenhouse Data and connect to Greenhouse in Akorbi Digital RunMyProcess.
-
Explore Geographical Relationships in Authorize.Net Data with Power Map
Create data visualizations with Authorize.Net in Power Map.
-
Build Automated Workflows with Live ServiceNow Data in Workato
Use CData Connect AI to connect to live ServiceNow and build automated workflows in Workato.
-
Integrating Claude Code CLI with Active Directory 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 Theia IDE with Live Couchbase Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE
-
Automate SAP ByDesign Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live SAP Business ByDesign and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
Analyze Accelo Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Accelo in Microsoft R Open.
-
Integrate Live Cosmos DB Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Cosmos DB from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Azure Cosmos DB.
-
Import Real-Time Cosmos DB Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Azure Cosmos DB in ColdFusion.
-
Access Live Office 365 Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Microsoft Office 365 from your Excel spreadsheets.
-
Publish Tally-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Tally ERP.
-
How to connect to Kintone Data from Spring Boot
Connect to Kintone in a Spring Boot Application using the CData JDBC Driver for Kintone
-
Publish Crystal Reports on SAP Business Warehouse Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date SAP Business Warehouse.
-
Use the CData Software JDBC Driver for SharePoint in MicroStrategy
Connect to Microsoft SharePoint in MicroStrategy Developer using the CData Software JDBC Driver for SharePoint.
-
Access Greenhouse Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Greenhouse from HeidiSQL.
-
Import Real-Time Todoist Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Todoist in ColdFusion.
-
Use the CData Software JDBC Driver for Planio in MicroStrategy Web
Connect to Planio in MicroStrategy Web using the CData Software JDBC Driver for Planio.
-
Access Live Sage 300 Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live Sage 300 data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Connect to Act CRM Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Act CRM and the SQL Gateway to access Act CRM from Google Apps Script.
-
Use the CData Software ODBC Driver for Bannerbear in MicroStrategy
Connect to Bannerbear in MicroStrategy Developer using the CData Software ODBC Driver for Bannerbear.
-
Feed Apify Data into FineReport
How to set Apify as a JDBC data source in FineReport.
-
Connect to Live BambooHR Data in PostGresSQL Interface through CData Connect AI
Create a live connection to BambooHR in CData Connect AI and connect to your BambooHR from PostgreSQL.
-
Amplitude Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Amplitude facts in real time.
-
Replicate Multiple Facebook Accounts
Replicate multiple Facebook accounts to one or many databases.
-
Connect to SAP Ariba Source Data in Aqua Data Studio
Access SAP Ariba Source from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Build Dashboards with LionDesk Data in DBxtra
Create dynamic dashboards and perform analytics based on LionDesk in DBxtra.
-
Connect to and Visualize Live SAP Business Warehouse Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live SAP Business Warehouse.
-
Automate Wrike Data Replication to Couchbase
Use CData Sync to Customize and automate Wrike replication to Couchbase.
-
Integrating Boomi Agentstudio with Epicor Kinetic Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Epicor Kinetic, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Create Datasets from Quaderno in Domo Workbench and Build Visualizations of Quaderno Data in Domo
Use the CData Software ODBC Driver for Quaderno to create datasets from Quaderno in Domo Workbench and then build visualizations in the Domo service.
-
Automated Continuous Apify Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Apify replication to Apache Cassandra.
-
How to Connect to Live MYOB AccountRight 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 MYOB AccountRight for you.
-
How to import Zoho Projects Data into Apache Solr
Use the CData Software JDBC Driver for Zoho Projects in Data Import Handler and create an automated import of Zoho Projects to Apache Solr Enterprise Search platform.
-
Easily Integrate SAP SuccessFactors LMS Data in Lazarus Pascal IDE
Learn how to easily integrate live SAP SuccessFactors LMS in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
How to integrate LaunchDarkly with Apache Airflow
Access and process LaunchDarkly in Apache Airflow using the CData JDBC Driver.
-
Integrate Goose with Live Greenhouse Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Greenhouse from within the local AI agent.
-
Write a Simple Go Application to work with Bitbucket Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Bitbucket.
-
Build Semantic Layer Views for Opsgenie Data in APOS Live Data Gateway
Use the CData Connector for Opsgenie in APOS Live Data Gateway to build Semantic Layer Views for Opsgenie.
-
Access JSON Services as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access JSON from your Oracle system.
-
Design BIRT Reports on Instantly Data
Provide current Instantly to your embedded analytics.
-
How to work with LinkedIn Data in Apache Spark using SQL
Access and process LinkedIn Data in Apache Spark using the CData Software JDBC Driver.
-
How to Use a Microsoft Access Database to Update Sage Cloud Accounting Data in Real Time
Update Sage Cloud Accounting data by creating a linked table in Microsoft Access with the CData Sage Cloud Accounting ODBC Driver.
-
Moving Data from Apollo to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Apollo data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Build Pipelines with Live FreshBooks Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to FreshBooks from Google Cloud Data Fusion, enabling the integration of live FreshBooks into the building and management of effective data pipelines.
-
Create Data Visualizations Based On eBay Data in Mode
Use CData Connect AI to connect to eBay Data from Mode and build visualizations using live
-
Connect to Webex Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Webex and work with Webex in your FileMaker applications.
-
Consume SAP SuccessFactors LMS OData Feeds in SAP Lumira
Use the API Server to create data visualizations on SAP SuccessFactors LMS feeds that reflect any changes in SAP Lumira.
-
DataBind Charts to Rootly Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Rootly 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 LinkedIn-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for LinkedIn Data and create custom apps in Mendix.
-
Manage PingOne Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for PingOne.
-
Automated Continuous Freshservice Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Freshservice replication to Amazon Redshift.
-
Use the CData Software JDBC Driver for SAS xpt in MicroStrategy Desktop
Connect to SAS XPORT in MicroStrategy Desktop using the CData Software JDBC Driver for SAS xpt.
-
Getting Started with the CData Tableau Connector for SendGrid
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for SendGrid.
-
Integrate with Parallel Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Parallel to a JSON file on disk.
-
Access Live Oracle Service Cloud Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Oracle Service Cloud from your Google Sheets.
-
Getting Started with the CData Tableau Connector for Microsoft Dataverse
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Microsoft Dataverse.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live SurveyMonkey within intelligent workflows.
-
Build SQL Analysis Services-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live SQL Analysis Services.
-
Integrate Superchat Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Superchat from Informatica Cloud.
-
How to Design Snapchat Ads Power Apps with Database-Like Connectivity
Gain real-time, database-like connectivity to Snapchat Ads from mobile and tablet Power Apps.
-
Automated Continuous Authorize.Net Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Authorize.Net replication to delimited files (CSV/TSV).
-
Build SAP Netweaver Gateway-Connected Apps in Choreo
Use CData Connect AI to connect to SAP Netweaver Gateway Data from Choreo and build custom apps using live SAP Netweaver Gateway.
-
Connect to Dynamics CRM Data in DBArtisan
Use wizards in DBArtisan to configure Microsoft Dynamics CRM as a data source.
-
How to create Visio diagrams from MarkLogic Data
Automatically update MarkLogic with the changes you make to Visio master shapes.
-
Connect to Google Ad Manager Data in NetBeans
Connect to Google Ad Manager in NetBeans with the data source configuration wizard.
-
Visualize Live Zoho Creator Data in the Power BI Service
Use CData Connect AI to connect to live Zoho Creator and create custom reports in the Power BI Service through the On-Premises Gateway.
-
How to connect to PivotalTracker Data in DBVisualizer
Integrate PivotalTracker with visual data analysis tools and data connection wizards in DBVisualizer
-
Analyze Microsoft Teams Data in Infragistics Reveal
Use the CData API Server to create an OData API on top of Microsoft Teams and visualize live Microsoft Teams in Infragistics Reveal.
-
Build MVC Applications with Connectivity to MailerLite Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access MailerLite from an ASP.NET MVC application.
-
Import GitHub Data Using Azure Data Factory
Use CData Connect AI to connect to GitHub Data from Azure Data Factory and import live GitHub.