CData Software - Knowledge Base
Recent Articles
-
Connect to Optimizely Data in NetBeans
Connect to Optimizely data in NetBeans with the data source configuration wizard.
-
How to connect PolyBase to Mailgun
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Mailgun data.
-
Connect FreshBooks to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live FreshBooks data using the CData Python MCP Server.
-
Build Semantic Layer Views for RSS Feeds in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for RSS feeds.
-
How to connect to RSS Feeds from Spring Boot
Connect to RSS in a Spring Boot Application using the CData JDBC Driver for RSS
-
Visualize Live ZohoExpense Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live ZohoExpense data into custom reports in Power BI.
-
Integrating Kiro with ZohoSubscriptions 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 and Visualize Live Jira Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Jira data into the Databricks platform and create visualization dashboards with real-time Jira data.
-
Viewing Sage Intacct Data in RAD Studio Data Explorer
How to view Sage Intacct data in RAD Studio Data Explorer using the CData ODBC Driver for Sage Intacct.
-
Back Up Snowflake data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Snowflake. In this article, we will employ an SSIS workflow to populate a database with Snowflake data data.
-
Connect to PayPal Data in HULFT Integrate
Connect to PayPal as a JDBC data source in HULFT Integrate
-
Build Visualizations of MailerSend Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of MailerSend data in Birst.
-
Connect to Contentful in SpagoBI
Create reports featuring live Contentful data in SpagoBI Studio. Host Contentful reports on SpagoBI Server.
-
Access Samanage Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Samanage data from your Oracle system.
-
Connect to Front Data in DBArtisan
Use wizards in DBArtisan to configure Front data as a data source.
-
Consume Instagram OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Instagram feeds that reflect any changes in SAP Lumira.
-
Automate Datadog Data Replication to Azure Data Lake
Use CData Sync to customize and automate Datadog data replication to Azure Data Lake.
-
Automate SingleStore Data Replication to SAP HANA
Use CData Sync to customize and automate SingleStore data replication to SAP HANA.
-
Create Power BI Reports on Real-Time Salesforce Data 360 Data
Use the CData ODBC Driver for Salesforce Data 360 to visualize Salesforce Data 360 data in Power BI Desktop.
-
Build Apps with Live Tanda Data Using the Low-Code Development Platform of Mendix
Connect Tanda data with Mendix to build apps using the CData API Driver for JDBC.
-
A PostgreSQL Interface for FreeAgent Data (MySQL Remoting via JDBC)
Use the Remoting features of the FreeAgent JDBC Driver to create a PostgreSQL entry-point for data access.
-
Automated Continuous JobNimbus Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable JobNimbus replication to delimited files (CSV/TSV).
-
Connect to FreeAgent Data from PowerBuilder via ADO.NET
This article demonstrates how to access FreeAgent data from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Use the CData Software ODBC Driver for Highrise in MicroStrategy
Connect to Highrise data in MicroStrategy Developer using the CData Software ODBC Driver for Highrise.
-
Automated Continuous Airtable Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Airtable replication to delimited files (CSV/TSV).
-
How to Connect Flowise AI Agents to Live xBase 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 xBase data without replication.
-
Visualize GraphQL 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 GraphQL data into TIBCO Spotfire.
-
Access Live Zoho Inventory Data in TIBCO Data Virtualization
Use the Zoho Inventory Tibco DV Adapter to create a Zoho Inventory data data source in TIBCO Data Virtualization Studio and gain access to live Zoho Inventory data from your TDV Server.
-
LINQ to Couchbase 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 Couchbase Data Provider.
-
Connect to Miro in SpagoBI
Create reports featuring live Miro data in SpagoBI Studio. Host Miro reports on SpagoBI Server.
-
Connecting GenSpark with Dynamics NAV Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Dynamics NAV data without any replication or custom integration required.
-
How to connect to Oracle Sales Data with Squirrel SQL client
Connect to Oracle Sales data and execute queries in the Squirrel SQL Client.
-
How to Connect to Opsgenie Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Opsgenie data. Leverage the pyodbc module for ODBC in Python.
-
Use the CData Software ODBC Driver for Microsoft Entra ID in SAS for Real-Time Reporting and Analytics
Connect to real-time Microsoft Entra ID data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Microsoft Entra ID.
-
Visualize Anaplan Data in TIBCO Spotfire through OData
Integrate Anaplan data into dashboards in TIBCO Spotfire.
-
Automated Teamgate Data Replication to Teradata
Use CData Sync to Customize and automate Teamgate data replication to Teradata.
-
Integrating LangGraph with Greenhouse Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Greenhouse data within automated workflows.
-
Import Real-Time Mocean Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Mocean data in ColdFusion.
-
Viewing Snapchat Ads Data in RAD Studio Data Explorer
How to view Snapchat Ads data in RAD Studio Data Explorer using the CData ODBC Driver for Snapchat Ads.
-
How to Access Live Mailjet Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Mailjet enables you to integrate Mailjet data into workflows built using Microsoft Power Automate Desktop.
-
Create Reports with Zoho CRM Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Zoho CRM data.
-
Build a PostgreSQL Interface for Wrike Data using the CData JDBC Driver
Use the Remoting features of the Wrike JDBC Driver to create a PostgreSQL entry-point for data access.
-
Integrate with Live Amazon Athena Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Amazon Athena from the MuleSoft Anypoint Platform to integrate live Amazon Athena data into custom reports and dashboards.
-
Validate GraphQL Data with QuerySurge
Access and validate GraphQL data in QuerySurge using the CData JDBC Driver.
-
Create Google Analytics-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Google Analytics Data from Klipfolio and build custom visualizations using live Google Analytics data.
-
Analyze Smartsheet Data in Cognos Analytics
Use CData Connect AI to connect to Smartsheet Data from Cognos Analytics and analyze live Smartsheet data.
-
Operational Reporting on Google Tasks Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Google Tasks data.
-
Connect and Query Live LinkedIn Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live LinkedIn data into Databricks and enable direct, live querying and analysis without replication.
-
Replicate Sybase IQ Data from PowerShell
Write a quick PowerShell script to query Sybase IQ data. Use connectivity to the live data to replicate Sybase IQ data to SQL Server.
-
Build Sendwithus-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Sendwithus data and build Sendwithus-connected web apps with Axios.
-
Getting Started with the CData SSIS Components for Amazon Marketplace
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Amazon Marketplace.
-
DataBind Zoho Inventory Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for Zoho Inventory with the DevExpress Windows Forms and Web controls to provide Zoho Inventory data to a chart.
-
Import Real-Time ConvertAPI Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use ConvertAPI data in ColdFusion.
-
Getting Started with the CData ODBC Driver for Google Forms
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Google Forms.
-
Connect to Attio Data in RapidMiner
Integrate Attio data with standard components and data source configuration wizards in RapidMiner Studio.
-
Build AI/ML Models with Live OpenWeatherMap Data using Dataiku
Connect OpenWeatherMap Data with Dataiku using the CData API Driver for JDBC.
-
Build Apps with Live CockroachDB data in Adalo using CData Connect AI
Use CData Connect AI to integrate live CockroachDB data into the Adalo platform and build custom mobile and web applications with real-time CockroachDB data.
-
Visualize Live Azure Analysis Services Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Azure Analysis Services data into custom reports in Power BI.
-
Connect to Keap Data from a Connection Pool in JBoss
Integrate Keap data into Java servlets: Use the Management Console in JBoss to install the Keap JDBC Driver.
-
Process & Analyze ClickTime Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live ClickTime Data.
-
Migrating data from Accelo to Snowflake using CData SSIS Components.
Easily push Accelo data to Snowflake using the CData SSIS Tasks for Accelo and Snowflake.
-
Consume HDFS OData Feeds in SAP Lumira
Use the API Server to create data visualizations on HDFS feeds that reflect any changes in SAP Lumira.
-
How to work with Eventbrite Data in Apache Spark using SQL
Access and process Eventbrite Data in Apache Spark using the CData Software JDBC Driver.
-
Query Greenhouse Data as a MySQL Database in Node.js
Execute MySQL queries against Greenhouse data from Node.js.
-
Use Agno to Talk to Your Office 365 Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Agno agents to securely answer questions and take actions on your Office 365 data for you.
-
Use the CData Software ODBC Driver for Shippo in MicroStrategy Web
Connect to Shippo data in MicroStrategy Web using the CData Software ODBC Driver for Shippo.
-
Query Access Data as a MySQL Database in Node.js
Execute MySQL queries against Access data from Node.js.
-
How to Work with Google Cloud Storage Data in ETL Validator JDBC
Connect to Google Cloud Storage from ETL Validator jobs using the CData Software JDBC Driver.
-
Integrate with FHIR Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy FHIR data to a JSON file on disk.
-
OnePageCrm Reporting in OBIEE with the OnePageCrm JDBC Driver
Deploy the OnePageCrm JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Create Reports with Salesforce Pardot Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Salesforce Pardot data.
-
Automated Continuous Copper Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Copper replication to IBM DB2.
-
Easily Integrate Codat Data in Lazarus Pascal IDE
Learn how to easily integrate live Codat data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Automated Continuous Oracle Eloqua Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Oracle Eloqua replication to Amazon S3.
-
Build an OLAP Cube in SSAS from WooCommerce Data
Establish a connection to WooCommerce data data from SQL Server Analysis Services, and use the WooCommerce Data Provider to build OLAP cubes for use in analytics and reporting.
-
How to Work with Gorgias Data in AWS Glue Jobs Using JDBC
Connect to Gorgias from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Build Paylocity-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Paylocity data and build web apps with connectivity to live Paylocity data.
-
Getting Started with the CData Power BI Connector for Basecamp
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Basecamp.
-
Migrating data from BambooHR to Google BigQuery using CData SSIS Components.
Easily push BambooHR data to Google BigQuery using the CData SSIS Tasks for BambooHR and Google BigQuery.
-
Feed Twitter Ads Data into FineReport
How to set Twitter Ads data as a JDBC data source in FineReport.
-
Automate Google Campaign Manager 360 Data Replication to SAP HANA
Use CData Sync to customize and automate Google Campaign Manager 360 data replication to SAP HANA.
-
Connect to Reckon Data in Aqua Data Studio
Access Reckon data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Create Power BI Reports on Real-Time Redshift Data
Use the CData ODBC Driver for Redshift to visualize Redshift data in Power BI Desktop.
-
How to Connect Hive 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 Hive data in real time using natural language.
-
How to connect PolyBase to SAP HANA
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live SAP HANA data.
-
Integrate Devin with Live Bitly Data Using CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Devin, the AI software engineer, to securely access and query live Bitly data.
-
Excel Spreadsheet Automation on Cloudant Data with the QUERY Formula
Pull data from Cloudant, automate spreadsheets, and more with the QUERY formula.
-
Build Data Flows from SQL Server to SAP Hybris C4C through SSIS
Easily push SQL Server data to SAP Hybris C4C using the CData SSIS Tasks for SAP Hybris C4C.
-
How to Access Onfleet Data Using Entity Framework
This article shows how to access Onfleet data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Rapidly Develop Discord-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 Discord.
-
Connect to Kafka Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Kafka as an External Source in Dremio.
-
Connect to Microsoft Ads Data from PowerBuilder via ADO.NET
This article demonstrates how to access Microsoft Ads data from Appeon PowerBuilder using the CData ADO.NET Provider for Microsoft Ads.
-
Creating ADP-Connected Applications in Unqork
You can use CData Connect AI to feed ADP data to Unqork and build custom business apps.
-
Connect to Azure Table Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Azure Table data in the Denodo Virtual DataPort Administrator.
-
Import Real-Time ZohoInvoice Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use ZohoInvoice data in ColdFusion.
-
Connecting Pipedream with Tavily Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Pipedream workflows to securely read and take actions on Tavily data in real time.
-
Connect to Bitly Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Bitly data.
-
Access Live SAP Business One Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate SAP Business One data into the statistical analysis tools available in SAS JMP. This article shows how to use SAP Business One data in the Graph Builder and Query Builder.
-
Connect to and Query Postmark Data in QlikView over ODBC
Create data visualizations with Postmark data in QlikView.
-
How to Connect Flowise AI Agents to Live BigCommerce 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 BigCommerce data without replication.