CData Software - Knowledge Base
Recent Articles
-
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 Cloud Accounting data 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 data.
-
Natively Connect to Office 365 Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Office 365 data. 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 data 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 data 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 data for you.
-
Analyze PolarTeamPro Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze PolarTeamPro data with the CData JDBC Driver for PolarTeamPro.
-
Automated Continuous ChartMogul Replication to Databricks
Use CData Sync for automated, continuous, customizable ChartMogul replication to Databricks.
-
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 data 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 data for you.
-
Access Live Couchbase Data in Excel 365 Online (Excel for the web)
Connect to Couchbase data 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 data 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 data 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's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to Invoiced.
-
Connect to Apify Data in CloverDX (formerly CloverETL)
Transfer Apify data 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 data 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 data 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 data and execute queries in PowerBuilder.
-
Automated ZarMoney Data Replication to Teradata
Use CData Sync to Customize and automate ZarMoney data 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 data.
-
Visualize Live CircleCI Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live CircleCI data 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 data 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 data in Python.
-
Stream SFTP Data into Apache Kafka Topics
Access and stream SFTP data 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 data 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 data into Tableau dashboards.
-
Prepare, Blend, and Analyze Attio Data in Alteryx Designer (ODBC)
Build workflows to access live Attio data 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 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 data.
-
Connect ConvertKit Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your ConvertKit data 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 data 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 data from Filemaker Pro on Mac.
-
Build Semantic Layer Views for SageHR Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for SageHR data.
-
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 data without any coding.
-
Deploy the ADO.NET Provider for Customer.io on an SSRS Report Server
Connect to Customer.io data 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 data.
-
Getting Started with the CData Python Connector for Gumroad
Learn to install and license the CData Python Connector and configure a connection to live Gumroad data.
-
Extract, Transform, and Load Missive Data in Informatica PowerCenter
Create a simple Workflow for Missive data in Informatica PowerCenter.
-
Access Bannerbear Data from MySQL in Amazon QuickSight
Connect to Bannerbear and build visualizations of Bannerbear data using a MySQL Connection in Amazon QuickSight.
-
Extract, Transform, and Load eBay Data in Informatica PowerCenter
Create a simple Workflow for eBay data in Informatica PowerCenter.
-
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 the CData Python Connector.
-
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 data 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 data.
-
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 data 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 data 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 data.
-
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 data 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 data without any coding.
-
Visualize Kintone Data in Tableau
The CData ODBC driver for Kintone enables you integrate Kintone data into Tableau dashboards.
-
Build Apps with Live Procore data in Adalo using CData Connect AI
Use CData Connect AI to integrate live Procore data into the Adalo platform and build custom mobile and web applications with real-time Procore data.
-
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 SAP Hybris C4C data.
-
Integrate Hive Data into Power Automate Desktop using CData Connect
CData Connect for Hive Data enables you to integrate Hive data 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 Spark data 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 Dynamics NAV data in Dundas BI.
-
How to Connect DBeaver to Onfleet via a JDBC Driver
Manage Onfleet data with visual tools in DBeaver like the query browser.
-
Working with Sage 300 Data in LINQPad
Execute LINQ queries to Sage 300 data in LINQPad.
-
Integrating GitHub Copilot with Salesforce 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.
-
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 data without any replication or custom integration required.
-
Automate BambooHR Data Replication to Azure Data Lake
Use CData Sync to customize and automate BambooHR data replication to Azure Data Lake.
-
Replicate BambooHR Data to Multiple Databases
Replicate BambooHR data 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 data 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 data from Informatica Cloud.
-
Build Salesforce Pardot Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Salesforce Pardot data and build visualizations in Tableau Cloud.
-
Connect to Marketo Data in ACL Analytics
Connect to Marketo data via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Marketo data.
-
How to connect and process Greenplum data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Greenplum data.
-
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 with Authorize.Net 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 LDAP to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live LDAP objects using the CData Python MCP Server.
-
How to connect to Oracle HCM Cloud Data in DBVisualizer
Integrate Oracle HCM Cloud data 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 data.
-
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 data 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 data from Crystal Reports.
-
Configure the CData JDBC Driver for Browserless in a Connection Pool in Tomcat
Connect to Browserless data 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 data.
-
Use the CData Software ODBC Driver for Stripe in SAS for Real-Time Reporting and Analytics
Connect to real-time Stripe data 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 data 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 data 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 Phoenix data without any coding.
-
Connect to Salesloft Data in RapidMiner
Integrate Salesloft data 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 data.
-
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 data for you.
-
Build a PostgreSQL Interface for JDBC-ODBC Bridge Data using the CData JDBC Driver
Use the Remoting features of the JDBC-ODBC Bridge JDBC Driver to create a PostgreSQL entry-point for data access.
-
Access Basecamp Data from MySQL in PHP
Connect to Basecamp through the standard MySQL libraries in PHP.
-
Integrate with live Amazon DynamoDB Data in Jitterbit
Use CData Connect AI to connect to and integrate live Amazon DynamoDB data in Jitterbit.
-
Publish Microsoft Teams-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Microsoft Teams data.
-
Access Live Google Ad Manager Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Google Ad Manager data from your Excel spreadsheets.
-
Create Reports with ScrapingBee Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date ScrapingBee data.