CData Software - Knowledge Base
Recent Articles
-
Create SAP Hybris C4C-Connected Nintex Workflows
Use CData Connect AI to connect to SAP Hybris C4C Data from Nintex Workflow Cloud and build custom workflows using live SAP Hybris C4C.
-
Connecting GenSpark with SAP HANA Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to SAP HANA without any replication or custom integration required.
-
Integrate Zuora Data in the Pentaho Report Designer
Publish reports based on Zuora in the Pentaho BI tool.
-
Configure the CData JDBC Driver for Mode in a Connection Pool in Tomcat
Connect to Mode from a connection pool in Tomcat.
-
Integrate Pipedrive Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Pipedrive and integrate live Pipedrive into your Power Automate tasks.
-
How to connect to Microsoft Dataverse Data from IntelliJ
Integrate connectivity to Microsoft Dataverse (CDS) with wizards in IntelliJ.
-
DataBind Beeminder Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Beeminder to a chart.
-
Replicate Multiple Avro Accounts via the CData Sync CLI
Replicate multiple Avro accounts to one or many databases.
-
Edit and Search External Sage Cloud Accounting Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Sage Business Cloud Accounting to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Sage Cloud Accounting Data objects that you can access from apps and the dashboard.
-
How to use SQLAlchemy ORM to access Attio Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Attio.
-
Natively Connect to Office 365 Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Microsoft Office 365. Leverage the native support for ODBC in PHP.
-
Automated Continuous Microsoft Ads Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Microsoft Ads replication to delimited files (CSV/TSV).
-
Connecting Moonlit Workflow with CSV 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 CSV/TSV Files in real time.
-
Create Amazon Marketplace Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Amazon Marketplace data access from reports, embedded analytics, and more.
-
Rapidly Develop Vault CRM-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 Vault CRM.
-
Build a Simple VCL Application for Deel Data
How to build a simple VCL Application to view Deel in RAD Studio using the CData ODBC Driver for Deel.
-
How to Connect to Live SAP HANA 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 SAP HANA for you.
-
Analyze PolarTeamPro Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze PolarTeamPro with the CData JDBC Driver for PolarTeamPro.
-
Connect to CampaignMonitor Data from a Connection Pool in Jetty
The CampaignMonitor JDBC Driver supports connection pooling: This article shows how to connect faster to CampaignMonitor from Web apps in Jetty.
-
Connect SAP Fieldglass to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect SAP Fieldglass with IBM WebSphere for seamless data integration and connectivity.
-
Use ChatGPT to Talk to Your LinkedIn 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 LinkedIn for you.
-
Access Live Couchbase Data in Excel 365 Online (Excel for the web)
Connect to Couchbase from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Automated Continuous HBase Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable HBase replication to PostgreSQL.
-
Connect to RabbitMQ Data in RazorSQL
Connect to RabbitMQ from wizards and query RabbitMQ from the GUI in the RazorSQL database management tool.
-
How to Access Live Eventbrite Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Eventbrite enables you to integrate Eventbrite into workflows built using Microsoft Power Automate Desktop.
-
Build AI/ML Models with Live ZohoPeople Data using Dataiku
Connect ZohoPeople Data with Dataiku using the CData API Driver for JDBC.
-
Connect to Invoiced Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Connect to Apify Data in CloverDX (formerly CloverETL)
Transfer Apify using the visual workflow in the CloverDX data integration tool.
-
Provide OData Services of BigCommerce Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for BigCommerce by developing a WCF Service Application.
-
Create Power BI Reports on Real-Time Pushbullet Data
Use the CData ODBC Driver for Pushbullet to visualize Pushbullet in Power BI Desktop.
-
Connect to Adobe Analytics Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Adobe Analytics to connect to Adobe Analytics and execute queries in PowerBuilder.
-
Automated ZarMoney Data Replication to Teradata
Use CData Sync to Customize and automate ZarMoney replication to Teradata.
-
Publish Crystal Reports on Neo4J Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Neo4J.
-
Visualize Live CircleCI Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live CircleCI using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Query, Visualize, and Share live Power BI XMLA Data in Redash
Use CData Connect AI to connect to live Power BI XMLA in Redash for querying, visualizing, and sharing.
-
How to Visualize Freshservice Data in Python with pandas via CData Connect AI
Use the CData Connect AI Python SDK with pandas and Matplotlib to analyze and visualize live Freshservice in Python.
-
Stream SFTP Data into Apache Kafka Topics
Access and stream SFTP in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Migrating data from Square to Databricks using CData SSIS Components.
Easily push Square to Databricks using the CData SSIS Tasks for Square and Databricks.
-
Visualize ScrapingBee Data in Tableau
The CData ODBC driver for ScrapingBee enables you integrate ScrapingBee into Tableau dashboards.
-
Prepare, Blend, and Analyze Attio Data in Alteryx Designer (ODBC)
Build workflows to access live Attio for self-service data analytics.
-
ClickUp Reporting in OBIEE with the ClickUp JDBC Driver
Deploy the ClickUp JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Integrating Cursor CLI with Monday.com 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.
-
How to use SQLAlchemy ORM to access Strava Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Strava.
-
Connect ConvertKit Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your ConvertKit using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Consume Reckon Accounts Hosted OData Feeds in PowerBuilder
This article demonstrates how to consume Reckon Accounts Hosted as OData feeds from PowerBuilder using the API Server.
-
Connect to Microsoft Exchange Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Microsoft Exchange from Filemaker Pro on Mac.
-
How to create an RPA flow for Marketo Data in UiPath Studio
Use the Marketo ODBC Driver to create workflows that access real-time Marketo without any coding.
-
Deploy the ADO.NET Provider for Customer.io on an SSRS Report Server
Connect to Customer.io from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.
-
Build Autopilot-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Autopilot.
-
Getting Started with the CData Python Connector for Gumroad
Learn to install and license the CData Python Connector
-
Extract, Transform, and Load Missive Data in Informatica PowerCenter
Create a simple Workflow for Missive in Informatica PowerCenter.
-
Access Bannerbear Data from MySQL in Amazon QuickSight
Connect to Bannerbear and build visualizations of Bannerbear using a MySQL Connection in Amazon QuickSight.
-
Extract, Transform, and Load eBay Data in Informatica PowerCenter
Create a simple Workflow for eBay in Informatica PowerCenter.
-
Access Live Reckon Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live Reckon data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Getting Started with the CData SSIS Components for Placid
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Placid.
-
Build a Singer.io Tap for Twilio With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Twilio data using
-
Build Pipelines with Live CockroachDB Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to CockroachDB from Google Cloud Data Fusion, enabling the integration of live CockroachDB into the building and management of effective data pipelines.
-
Build Semantic Layer Views for GitHub Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for GitHub.
-
Use Biml to Build SSIS Tasks to Replicate Postmark Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Postmark to SQL Server.
-
Integrate Goose with Live MongoDB Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live MongoDB from within the local AI agent.
-
Enable the Paylocity JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Paylocity.
-
LINQ to SAP HANA XS Advanced 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 SAP HANA XS Advanced Data Provider.
-
Connect to CampaignMonitor in SpagoBI
Create reports featuring live CampaignMonitor in SpagoBI Studio. Host CampaignMonitor reports on SpagoBI Server.
-
Square Reporting in OBIEE with the Square JDBC Driver
Deploy the Square JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
How to create an RPA flow for Egnyte Data in UiPath Studio
Use the Egnyte ODBC Driver to create workflows that access real-time Egnyte without any coding.
-
Visualize Kintone Data in Tableau
The CData ODBC driver for Kintone enables you integrate Kintone into Tableau dashboards.
-
Build Apps with Live Procore in Adalo using CData Connect AI
Use CData Connect AI to integrate live Procore into the Adalo platform and build custom mobile and web applications with real-time Procore.
-
Create Data Visualizations Based On SAP Hybris C4C Data in Mode
Use CData Connect AI to connect to SAP Hybris C4C Data from Mode and build visualizations using live
-
Integrate Hive Data into Power Automate Desktop using CData Connect
CData Connect for Hive Data enables you to integrate Apache Hive into workflows built using Microsoft Power Automate Desktop.
-
Create Dynamic FreeAgent Grids Using the Infragistics XamDataGrid
Learn how you can connect FreeAgent to Infragistics XamDataGrid to build dynamic grids.
-
Connect to Spark from a Connection Pool in WebLogic
Use the CData JDBC Driver for Spark to connect to Apache Spark SQL from Web applications running on WebLogic.
-
How to Connect to & Open Cloudflare Data in Microsoft Excel
This article uses the CData ODBC driver for Cloudflare to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Build Dashboards with Dynamics NAV Data in Dundas BI
Create dynamic dashboards and perform analytics based on Microsoft Dynamics NAV in Dundas BI.
-
How to Connect DBeaver to Onfleet via a JDBC Driver
Manage Onfleet with visual tools in DBeaver like the query browser.
-
Working with Sage 300 Data in LINQPad
Execute LINQ queries to Sage 300 in LINQPad.
-
Integrating GitHub Copilot CLI with Salesforce & Force.com 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.
-
Connecting GenSpark with Google Analytics Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Google Analytics without any replication or custom integration required.
-
Automate BambooHR Data Replication to Azure Data Lake
Use CData Sync to customize and automate BambooHR replication to Azure Data Lake.
-
Replicate BambooHR Data to Multiple Databases
Replicate BambooHR to disparate databases with a point-and-click configuration.
-
Query, Visualize, and Share live SAP Concur Data in Redash
Use CData Connect AI to connect to live SAP Concur in Redash for querying, visualizing, and sharing.
-
Integrate Aircall Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Aircall from Informatica Cloud.
-
Build Salesforce Pardot Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Salesforce Pardot and build visualizations in Tableau Cloud.
-
Connect to Marketo Data in ACL Analytics
Connect to Marketo via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Marketo.
-
How to connect and process Pivotal GreenPlum from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Pivotal GreenPlum.
-
Excel Spreadsheet Automation on Aircall Data with the QUERY Formula
Pull data from Aircall, automate spreadsheets, and more with the QUERY formula.
-
Integrating GitHub Copilot CLI with Authorize.Net 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 LDAP to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live LDAP using the CData Python MCP Server.
-
How to connect to Oracle HCM Cloud Data in DBVisualizer
Integrate Oracle HCM Cloud with visual data analysis tools and data connection wizards in DBVisualizer
-
Build Google Campaign Manager 360-Connected Apps in Choreo
Use CData Connect AI to connect to Google Campaign Manager 360 Data from Choreo and build custom apps using live Google Campaign Manager 360.
-
Integrating LangChain with SAP BusinessObjects BI Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on SAP BusinessObjects BI within automated workflows.
-
Connect to SAP Business One Data from Crystal Reports
Use CData Connect AI to connect to and report on live SAP Business One from Crystal Reports.
-
Configure the CData JDBC Driver for Browserless in a Connection Pool in Tomcat
Connect to Browserless from a connection pool in Tomcat.
-
Connect to Chargebee Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Chargebee.
-
Use the CData Software ODBC Driver for Stripe in SAS for Real-Time Reporting and Analytics
Connect to real-time Stripe in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Stripe.
-
Connect to MailChimp Data in RazorSQL
Connect to MailChimp from wizards and query MailChimp from the GUI in the RazorSQL database management tool.
-
Object-Relational Mapping (ORM) with xBase Data Entities in Java
Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to xBase into a Java-based ORM framework, Hibernate.
-
How to create an RPA flow for Phoenix Data in UiPath Studio
Use the Phoenix ODBC Driver to create workflows that access real-time Apache Phoenix without any coding.
-
Connect to Salesloft Data in RapidMiner
Integrate Salesloft with standard components and data source configuration wizards in RapidMiner Studio.
-
Write a Simple Go Application to work with TaxJar Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to TaxJar.
-
Use Azure AI Foundry to Talk to Your Microsoft Exchange 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 Microsoft Exchange for you.