CData Software - Knowledge Base
Recent Articles
-
Edit and Search External Zoho Projects Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Zoho Projects data to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Zoho Projects Data objects that you can access from apps and the dashboard.
-
Automated Continuous ChargeOver Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable ChargeOver replication to PostgreSQL.
-
Integrate SAS xpt with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate SAS xpt with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to SAS xpt data.
-
How to Use a Microsoft Access Database to Update Zoho Projects Data in Real Time
Update Zoho Projects data by creating a linked table in Microsoft Access with the CData Zoho Projects ODBC Driver.
-
Integrating Kiro with Hubstaff 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 to Zoho Books Data from PowerBuilder via ADO.NET
This article demonstrates how to access Zoho Books data from Appeon PowerBuilder using the CData ADO.NET Provider for Zoho Books.
-
Integrate Testmonitor Data in Pentaho Data Integration
Build ETL pipelines based on Testmonitor data in the Pentaho Data Integration tool.
-
How to Connect Flowise AI Agents to Live Zendesk 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 Zendesk data without replication.
-
Build Semantic Layer Views for Autopilot Data in APOS Live Data Gateway
Use the CData Connector for Autopilot in APOS Live Data Gateway to build Semantic Layer Views for Autopilot data.
-
Integrate PhantomBuster with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate PhantomBuster with External Services.
-
Work with Templated Data in FoxPro
Load Templated data into a FoxPro database. This article includes full code and a walk-through of the process.
-
How to publish and share Access Data dashboards with Tableau Server
The CData ODBC driver for Access enables you integrate Access data into Tableau dashboards.
-
Seamlessly Bring ADP Data into Retool Using CData Connect AI
Integrate ADP data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
A PostgreSQL Interface for Bright Data Data using the CData ODBC Driver
Use the SQL Gateway and Bright Data ODBC Driver to create a PostgreSQL entry-point for data access.
-
How to Work with Rebilly Data in AWS Glue Jobs Using JDBC
Connect to Rebilly from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
How to create an RPA flow for Sybase IQ Data in UiPath Studio
Use the Sybase IQ ODBC Driver to create workflows that access real-time Sybase IQ data without any coding.
-
How to Connect to Google Search Results in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Google Search results. Leverage the pyodbc module for ODBC in Python.
-
Integrate Live FTP Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf's Cascade agent to securely access and query live FTP data from within the IDE.
-
Getting Started with the CData Python Connector for Pushbullet
Learn to install and license the CData Python Connector and configure a connection to live Pushbullet data.
-
How to Connect to Live Bitbucket Data in n8n Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable n8n to securely read and take actions on your Bitbucket data for you.
-
Automated Continuous Guru Replication to MongoDB
Use CData Sync for automated, continuous, customizable Guru replication to MongoDB.
-
Create Datasets from Oracle in Domo Workbench and Build Visualizations of Oracle Data in Domo
Use the CData Software ODBC Driver for Oracle to create datasets from Oracle data in Domo Workbench and then build visualizations in the Domo service.
-
Connect to Avaza Data from a Connection Pool in Jetty
The Avaza JDBC Driver supports connection pooling: This article shows how to connect faster to Avaza data from Web apps in Jetty.
-
Replicate Webex Data to Multiple Databases
Replicate Webex data to disparate databases with a point-and-click configuration.
-
Seamlessly Bring Shippo Data into Retool Using CData Connect AI
Integrate Shippo data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Connect to and Visualize Live Copper Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Copper data.
-
Connect to Avaza Data in Ruby
Connect to Avaza data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Automate Couchbase Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Couchbase data from PowerShell? This article demonstrates how to utilize the Couchbase Cmdlets for tasks like connecting to Couchbase data, automating operations, downloading data, and more.
-
Integrate Devin with Live MarkLogic 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 MarkLogic data.
-
How to load ConvertAPI data into Elasticsearch via Logstash
Introducing a simple method to load ConvertAPI data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Create Apps from Office 365 Data in Qlik Sense Cloud
Use CData Connect AI to connect to Office 365 Data and build apps from live Office 365 data in Qlik Sense Cloud.
-
Build Agents in Relevance AI with Access to Live Adobe Commerce Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Adobe Commerce data within intelligent agent workflows.
-
Integrate Helpscout with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Helpscout with External Services.
-
Getting Started with the CData Python Connector for SAP HANA
Learn to install and license the CData Python Connector and configure a connection to live SAP HANA data.
-
Connect to SAP Business Warehouse Data in JRuby
Create a simple JRuby app with access to live SAP Business Warehouse data.
-
Integrate Placid Data in the Pentaho Report Designer
Publish reports based on Placid data in the Pentaho BI tool.
-
Create Zoho Creator-Connected Nintex Workflows
Use CData Connect AI to connect to Zoho Creator Data from Nintex Workflow Cloud and build custom workflows using live Zoho Creator data.
-
Use Microsoft Copilot Studio to talk to your Exa Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Microsoft Copilot Studio to securely answer questions and take actions on your Exa data for you.
-
Connect to MailChimp Data from PowerBuilder via JDBC
This article demonstrates how to access MailChimp data from PowerBuilder using the MailChimp JDBC Driver.
-
Access Twitter Ads Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Twitter Ads data from your Oracle system.
-
DataBind Charts to Zoho Inventory Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Zoho Inventory data 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.
-
Create Slack-Connected Nintex Workflows
Use CData Connect AI to connect to Slack Data from Nintex Workflow Cloud and build custom workflows using live Slack data.
-
Integrating OpenCode with Sugar CRM 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.
-
Publish Reports with Xero Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Xero data.
-
Provide OData Services of Google Analytics Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Google Analytics data by developing a WCF Service Application.
-
Create Reports from RSS Feeds in Looker Studio
Use CData Connect AI to gain access to live RSS feeds and create custom reports in Looker Studio.
-
Automated Continuous ZohoPeople Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable ZohoPeople replication to Amazon Redshift.
-
Integrate Microsoft Ads Data into Power Automate Desktop using CData Connect
CData Connect for Microsoft Ads Data enables you to integrate Microsoft Ads data into workflows built using Microsoft Power Automate Desktop.
-
Use Microsoft Copilot Studio to talk to your LinkedIn Ads Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Microsoft Copilot Studio to securely answer questions and take actions on your LinkedIn Ads data for you.
-
Build Neo4J-Connected Applications in Kiro with CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Kiro to securely access, query, and take action on live Neo4J data without replication.
-
Connect to Figshare Data from HeidiSQL
Use CData Connect AI to connect to and query live Figshare data from HeidiSQL.
-
Link Supabase with FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Supabase data in Filemaker Pro for Mac or Windows.
-
Access Live Apify Data in Coginiti Pro
Connect to and query live Apify data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
How to Visualize Redis Data in Python with pandas
Use pandas and other modules to analyze and visualize live Redis data in Python.
-
How to Visualize HCL Domino Data in Python with pandas
Use pandas and other modules to analyze and visualize live HCL Domino data in Python.
-
How to Connect to & Open SAP Netweaver Gateway Data in Microsoft Excel
This article uses the CData ODBC driver for SAP Netweaver Gateway to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Connect to Sage 200 Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Sage 200 data.
-
Create Reports from GitHub Data in Looker Studio
Use CData Connect AI to gain access to live GitHub data and create custom reports in Looker Studio.
-
Build Visualizations of Qualaroo Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Qualaroo data in Birst.
-
Feed Google Translate Data into FineReport
How to set Google Translate data as a JDBC data source in FineReport.
-
How to Connect Certinia 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 Certinia data in real time using natural language.
-
Access Live Facebook Data in Excel 365 Online (Excel for the web)
Connect to Facebook data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Viewing Sybase IQ Data in RAD Studio Data Explorer
How to view Sybase IQ data in RAD Studio Data Explorer using the CData ODBC Driver for Sybase IQ.
-
Back Up SAP Business One data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for SAP Business One. In this article, we will employ an SSIS workflow to populate a database with SAP Business One data data.
-
Feed Zoho Recruit Data into FineReport
How to set Zoho Recruit data as a JDBC data source in FineReport.
-
Integrating GitHub Copilot with ZarMoney 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.
-
A PostgreSQL Interface for SurveyMonkey Data (MySQL Remoting via JDBC)
Use the Remoting features of the SurveyMonkey JDBC Driver to create a PostgreSQL entry-point for data access.
-
Analyze Azure Synapse Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Azure Synapse data and visualize Azure Synapse data in SAP Analytics Cloud.
-
Connect to SAP Business Warehouse Data in Google Apps Script via Connect AI
Use CData Connect AI to access SAP Business Warehouse data in Google Apps Script.
-
Build MVC Applications with Connectivity to Grafana Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Grafana from an ASP.NET MVC application.
-
Automated Continuous Parquet Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Parquet replication to IBM DB2.
-
Access Live Mouseflow Data in AWS Lambda
Connect to live Mouseflow data in AWS Lambda using the CData JDBC Driver.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for ChartMogul
Provide connectivity to ChartMogul data through an SAP BusinessObjects universe.
-
Excel Spreadsheet Automation on ZohoSubscriptions Data with the QUERY Formula
Pull data from ZohoSubscriptions, automate spreadsheets, and more with the QUERY formula.
-
DataBind Controls to QuickBooks Data in Delphi
DataBind to QuickBooks data in Delphi with standard data access components and controls.
-
Connect to VWO Data in Ruby
Connect to VWO data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Connect to Cvent Data in HULFT Integrate
Connect to Cvent as a JDBC data source in HULFT Integrate
-
Publish BambooHR-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live BambooHR data.
-
Replicate Multiple Mixpanel Accounts via the CData Sync CLI
Replicate multiple Mixpanel accounts to one or many databases.
-
Integrate Cvent Data in the Pentaho Report Designer
Publish reports based on Cvent data in the Pentaho BI tool.
-
Integrating OpenCode 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.
-
A PostgreSQL Interface for Redshift Data using the CData ODBC Driver
Use the SQL Gateway and Redshift ODBC Driver to create a PostgreSQL entry-point for data access.
-
Google Drive Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Google Drive facts in real time.
-
Connect to Sage Intacct Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Sage Intacct data in Airbyte.
-
How to connect to Asana Data from IntelliJ
Integrate connectivity to Asana data with wizards in IntelliJ.
-
Connecting Pipedream with ShipEngine 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 ShipEngine data in real time.
-
Access Live Codat Data in Coginiti Pro
Connect to and query live Codat data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Pingdom
Provide connectivity to Pingdom data through an SAP BusinessObjects universe.
-
How to work with Dynamics 365 Business Central Data in Apache Spark using SQL
Access and process Dynamics 365 Business Central Data in Apache Spark using the CData Software JDBC Driver.
-
How to create an RPA flow for Cosmos DB Data in UiPath Studio
Use the Cosmos DB ODBC Driver to create workflows that access real-time Cosmos DB data without any coding.
-
Automated Continuous Freshsales Replication to SQL Server
Use CData Sync for automated, continuous, customizable Freshsales replication to SQL Server.
-
Create Reports with Bannerbear Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Bannerbear data.
-
Build LinkedIn Visualizations in Tableau Desktop
Use CData Connect AI to connect to live LinkedIn data and build visualizations in Tableau.
-
How to update SQLite from Excel
This article explains how to transfer data from Excel to SQLite using the Excel Add-In for SQLite.
-
Automated Continuous LightSpeedRetail Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable LightSpeedRetail replication to Google BigQuery.
-
Use the CData Software JDBC Driver for Paymo in MicroStrategy Desktop
Connect to Paymo data in MicroStrategy Desktop using the CData Software JDBC Driver for Paymo.
-
Use Agno to Talk to Your Authorize.Net 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 Authorize.Net data for you.
-
How to Visualize Helpscout Data in Python with pandas
Use pandas and other modules to analyze and visualize live Helpscout data in Python.
-
Connecting Moonlit Workflow with Sugar CRM 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 Sugar CRM data in real time.
-
Access Live ADP Data in AWS Lambda (with IntelliJ IDEA)
Connect to live ADP data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.