CData Software - Knowledge Base
Recent Articles
-
Automated Continuous Copper Replication to Snowflake
Use CData Sync for automated, continuous, customizable Copper replication to Snowflake.
-
Import Real-Time Printful Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Printful in ColdFusion.
-
Build Apps with Live Freshservice Data Using the Low-Code Development Platform of Mendix
Connect Freshservice with Mendix to build apps using the CData API Driver for JDBC.
-
Integrating LangChain with Microsoft Dataverse Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Microsoft Dataverse (CDS) within automated workflows.
-
DataBind LinkedIn Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for LinkedIn with the DevExpress Windows Forms and Web controls to provide LinkedIn to a chart.
-
How to connect and process AgileCRM from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live AgileCRM.
-
How to Connect to Live Google Search Results from OpenAI Python Applications (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable OpenAI-powered Python applications to securely read and take actions on your Google Search through natural language.
-
Create Informatica Mappings From/To an ODBC Data Source for Exact Online
Create an ODBC connection to Exact Online in Informatica and browse and transfer Exact Online.
-
Publish Brex-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Brex.
-
Perform Batch Operations with Facebook Ads Data in Apache NiFi
Connect to Facebook Ads and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Access Pinecone Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Pinecone from HeidiSQL.
-
Automated Continuous GetResponse Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable GetResponse replication to Apache Cassandra.
-
Integrating Kiro CLI with eBay Analytics 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 Authorize.Net to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Authorize.Net with IBM WebSphere for seamless data integration and connectivity.
-
Publish Crystal Reports on GitLab Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date GitLab.
-
Easily Integrate HDFS Data in Lazarus Pascal IDE
Learn how to easily integrate live Apache HDFS in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Integrating LangChain with Twilio Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Twilio within automated workflows.
-
How to create an RPA flow for Spotify Data in UiPath Studio
Use the Spotify ODBC Driver to create workflows that access real-time Spotify without any coding.
-
Use the CData Software JDBC Driver for Oracle Eloqua Reporting in MicroStrategy Desktop
Connect to Oracle Eloqua Reporting in MicroStrategy Desktop using the CData Software JDBC Driver for Oracle Eloqua Reporting.
-
Connect to Apollo Data in Ruby
Connect to Apollo in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Access Live Front Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Front in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Automated Continuous Greenhouse Replication to Databricks
Use CData Sync for automated, continuous, customizable Greenhouse replication to Databricks.
-
Create Datasets from Wistia in Domo Workbench and Build Visualizations of Wistia Data in Domo
Use the CData Software ODBC Driver for Wistia to create datasets from Wistia in Domo Workbench and then build visualizations in the Domo service.
-
Access Google Calendar 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 Google Calendar.
-
Connect to and Visualize Live Zoho Projects Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Zoho Projects.
-
Connect to SAP Ariba Procurement Data in Aqua Data Studio
Access SAP Ariba Procurement from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
How to create an RPA flow for Avaza Data in UiPath Studio
Use the Avaza ODBC Driver to create workflows that access real-time Avaza without any coding.
-
Connect to Power BI XMLA Data from Crystal Reports
Use CData Connect AI to connect to and report on live Power BI XMLA from Crystal Reports.
-
Publish Reports with Pipeliner CRM Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Pipeliner CRM.
-
Model, Search, and Visualize Live ADP Data in ThoughtSpot
Use CData Connect AI to connect to live ADP for modeling, searching, and visualizing.
-
How to Connect to & Open ZohoMarketingHub Data in Microsoft Excel
This article uses the CData ODBC driver for ZohoMarketingHub to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
LINQ to Monday.com 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 Monday.com Data Provider.
-
Access Live Blackbaud FE NXT Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Blackbaud FE NXT from your Google Sheets.
-
ZarMoney Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on ZarMoney facts in real time.
-
Connect to Zoom Data from a Connection Pool in JBoss
Integrate Zoom into Java servlets: Use the Management Console in JBoss to install the Zoom JDBC Driver.
-
Use the CData ODBC Driver for Gorgias from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Gorgias to connect to Gorgias from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Gorgias in Excel.
-
Seamlessly Bring Google Cloud Storage Data into Retool Using CData Connect AI
Integrate Google Cloud Storage data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Integrate with ZohoPeople Data in JReport Designer
Create charts and reports based on ZohoPeople in JReport Designer.
-
Integrate with Live Odoo Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Odoo from the MuleSoft Anypoint Platform to integrate live Odoo ERP into custom reports and dashboards.
-
Use the CData Software ODBC Driver for SingleStore in SAS for Real-Time Reporting and Analytics
Connect to real-time SingleStore in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for SingleStore.
-
Build Data Flows from SQL Server to Odoo through SSIS
Easily push SQL Server data to Odoo using the CData SSIS Tasks for Odoo.
-
How to Access Tavily Data Using Entity Framework
This article shows how to access Tavily using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Build Pipelines with Live Databricks Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Databricks from Google Cloud Data Fusion, enabling the integration of live Databricks into the building and management of effective data pipelines.
-
Build QuickBooks Time-Connected Apps in Choreo
Use CData Connect AI to connect to QuickBooks Time Data from Choreo and build custom apps using live QuickBooks Time.
-
Publish Paymo-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Paymo.
-
Access Live Dynamics NAV Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Microsoft Dynamics NAV into the statistical analysis tools available in SAS JMP. This article shows how to use Microsoft Dynamics NAV in the Graph Builder and Query Builder.
-
Access Live PostgreSQL Data in Emergent via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Emergent agents to securely access and build applications with live PostgreSQL through MCP integration.
-
Integrating Antigravity CLI with Instantly via CData CLI
Connect Instantly to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
How to use SQLAlchemy ORM to access PabblySubscriptions Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of PabblySubscriptions.
-
How to work with Flowlu Data in Apache Spark using SQL
Access and process Flowlu Data in Apache Spark using the CData Software JDBC Driver.
-
Build Charts with Strava Data in Clear Analytics
Create dynamic charts and perform analytics based on Strava in Clear Analytics.
-
How to Connect to Live SAP Ariba Procurement Data from OpenAI Python Applications (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable OpenAI-powered Python applications to securely read and take actions on your SAP Ariba Procurement through natural language.
-
Build AI Agents with Azure Analysis Services 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 Azure Analysis Services through CData Connect AI.
-
Integrating Claude Code CLI with Adobe Commerce 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.
-
Migrating data from MessageBird to Databricks using CData SSIS Components.
Easily push MessageBird to Databricks using the CData SSIS Tasks for MessageBird and Databricks.
-
How to create an RPA flow for Zoom Data in UiPath Studio
Use the Zoom ODBC Driver to create workflows that access real-time Zoom without any coding.
-
Moving Data from Aha! to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Aha! data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
How to use SQLAlchemy ORM to access CockroachDB Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of CockroachDB.
-
Analyze Google Search Results in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Google Search and visualize the live Results in Slingshot (formerly Reveal BI) for seamless insights.
-
Connect to and Visualize Live Templated Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Templated.
-
Query REST Data from Node.js
Use the OData endpoint of the CData API Server to connect to your REST and perform CRUD operations on REST from Node.js.
-
Build Semantic Layer Views for SAS Data Sets Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for SAS Data Sets.
-
Query PagerDuty Data in ColdFusion
Write standard ColdFusion data access code to connect to PagerDuty.
-
Automate SingleStore Data Replication to Azure Data Lake
Use CData Sync to customize and automate SingleStore replication to Azure Data Lake.
-
Extend Google Sheets with Oracle Eloqua Data
Make calls to Oracle Eloqua from Google Apps Script via the API Server.
-
Enable the TaxJar JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with TaxJar.
-
How to Execute Stored Procedures with the CData BizTalk Adapter for Salesforce
You can use stored procedures provided by the CData BizTalk Adapter for Salesforce to automate working with Salesforce data in BizTalk. Stored procedures implement actions available in the underlying API.
-
Consume MongoDB OData Feeds in SAP Lumira
Use the API Server to create data visualizations on MongoDB feeds that reflect any changes in SAP Lumira.
-
Import Twilio Data Using Azure Data Factory
Use CData Connect AI to connect to Twilio Data from Azure Data Factory and import live Twilio.
-
How to Query Live Oracle Data in Claude Desktop
Connect to and query live Oracle Data in Claude Desktop using CData MCP Server.
-
Analyze Confluence Data in Infragistics Reveal
Use the CData API Server to create an OData API on top of Atlassian Confluence and visualize live Atlassian Confluence in Infragistics Reveal.
-
Extend Google Sheets with SAP Business Warehouse Data
Make calls to SAP Business Warehouse from Google Apps Script via the API Server.
-
Add CloudConvert Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for CloudConvert with the Informatica Enterprise Data Catalog to classify and organize data.
-
Visualize Amplitude Data in Sisense
Create an ElastiCube in Sisense app with access to Amplitude.
-
Connect and Query Live SAS Data Sets Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live SAS Data Sets into Databricks
-
Build an OLAP Cube in SSAS from SuiteCRM Data
Establish a connection to SuiteCRM data from SQL Server Analysis Services, and use the SuiteCRM Data Provider to build OLAP cubes for use in analytics and reporting.
-
Automated Continuous ConvertKit Replication to Snowflake
Use CData Sync for automated, continuous, customizable ConvertKit replication to Snowflake.
-
Query MySQL Data through ODBC in Node.js
Use node-odbc to execute SQL queries against MySQL from Node.js.
-
Back Up Timely 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 Timely data.
-
Integrate Live Tally Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Tally from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Tally ERP.
-
Import Real-Time ConstantContact Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use ConstantContact in ColdFusion.
-
Integrating Codex CLI with SpaceX 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.
-
Automated Continuous Toggl Replication to Vertica
Use CData Sync for automated, continuous, customizable Toggl replication to Vertica.
-
Access Live Freshdesk Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live Freshdesk data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Automated Continuous BenchmarkEmail Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable BenchmarkEmail replication to Google BigQuery.
-
Visualize Zoho Books Data in Tableau
The CData ODBC driver for Zoho Books enables you integrate Zoho Books into Tableau dashboards.
-
Integrate Cline with Live BambooHR Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live BambooHR from within your IDE.
-
Automated Continuous Elasticsearch Replication to SingleStore
Use CData Sync for automated, continuous, customizable Elasticsearch replication to SingleStore.
-
Analyze Wave Financial Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Wave Financial and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Integrate with Guru Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Guru to a JSON file on disk.
-
Use Dash to Build to Web Apps on Aircall Data
Create Python applications that use pandas and Dash to build Aircall-connected web apps.
-
Visualize SharePoint Excel Services 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 SharePoint Excel Services into TIBCO Spotfire.
-
Connect to Figshare Data in NetBeans
Connect to Figshare in NetBeans with the data source configuration wizard.
-
How to Access SAS Data Sets Data Using Entity Framework
This article shows how to access SAS Data Sets using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Build a Simple VCL Application for Google Ad Manager Data
How to build a simple VCL Application to view Google Ad Manager in RAD Studio using the CData ODBC Driver for Google Ad Manager.
-
Connect to Teamwork 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 Teamwork and work with Teamwork in your FileMaker application.
-
Feed Dropbox Data into FineReport
How to set Dropbox as a JDBC data source in FineReport.
-
Validate EmailOctopus Data with QuerySurge
Access and validate EmailOctopus in QuerySurge using the CData JDBC Driver.
-
Visualize Live Bitly Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Bitly using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Build SAP SuccessFactors LMS-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live SAP SuccessFactors LMS.