CData Software - Knowledge Base
Recent Articles
-
Automated Continuous JSON Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable JSON replication to PostgreSQL.
-
Automated Continuous Auth0 Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Auth0 replication to Google BigQuery.
-
Integrating OpenCode with GitLab 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.
-
Object-Relational Mapping (ORM) with CouchDB 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 CouchDB data into a Java-based ORM framework, Hibernate.
-
How to create an RPA flow for Authorize.Net Data in UiPath Studio
Use the Authorize.Net ODBC Driver to create workflows that access real-time Authorize.Net data without any coding.
-
Import and Visualize ClickUp Data in Power View
Create data visualizations based on ClickUp data in Excel.
-
Publish Oracle-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Oracle data.
-
Automated Continuous Couchbase Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Couchbase replication to IBM DB2.
-
Build a PostgreSQL Interface for Miro Data using the CData JDBC Driver
Use the Remoting features of the Miro JDBC Driver to create a PostgreSQL entry-point for data access.
-
Access Live AfterShip Data in Roo Code via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Roo Code agents to securely access and build applications with live AfterShip data through MCP integration.
-
Access Live SAP Ariba Source Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to SAP Ariba Source data from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Use the CData Software JDBC Driver for Templated in MicroStrategy
Connect to Templated data in MicroStrategy Developer using the CData Software JDBC Driver for Templated.
-
Connect SAS xpt to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect SAS xpt with IBM WebSphere for seamless data integration and connectivity.
-
Rapidly Develop SAP BusinessObjects BI-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 SAP BusinessObjects BI.
-
Integrate ZohoPeople with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate ZohoPeople with External Services.
-
Create Dashboards and Visualize Live Twitter Ads Data in Geckoboard
Use CData Connect AI to connect to live Twitter Ads data and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Connect to Printify 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 Printify and work with Printify data in your FileMaker application.
-
Publish Campaigner-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Campaigner data.
-
Migrating data from Discord to Google BigQuery using CData SSIS Components.
Easily push Discord data to Google BigQuery using the CData SSIS Tasks for Discord and Google BigQuery.
-
Integrate with Workday Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Workday data in SnapLogic.
-
Query Elasticsearch Data as a SQL Server Database in Node.js
Execute SQL Server queries against Elasticsearch data from Node.js.
-
Integrate Freshdesk with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Freshdesk with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Freshdesk data.
-
How to Access Live Klipfolio Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Klipfolio enables you to integrate Klipfolio data into workflows built using Microsoft Power Automate Desktop.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for LightSpeedRetail
Provide connectivity to LightSpeedRetail data through an SAP BusinessObjects universe.
-
Connect to Exa Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Exa and the SQL Gateway to access Exa data from Google Apps Script.
-
Automate Square Data Replication to Couchbase
Use CData Sync to Customize and automate Square data replication to Couchbase.
-
Consume Pipedrive OData Feeds in PowerBuilder
This article demonstrates how to consume Pipedrive data as OData feeds from PowerBuilder using the API Server.
-
Integrate Live ConvertAPI Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live ConvertAPI data to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Access Live Vault CRM Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Vault CRM data from your Excel spreadsheets.
-
How to Visualize SAP SuccessFactors LMS Data in Python with pandas
Use pandas and other modules to analyze and visualize live SAP SuccessFactors LMS data in Python.
-
Prepare, Blend, and Analyze ChartMogul Data in Alteryx Designer (ODBC)
Build workflows to access live ChartMogul data for self-service data analytics.
-
Publish Presto-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Presto data.
-
Load SAP Fieldglass Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load SAP Fieldglass data to a database.
-
Enable the Acumatica JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Acumatica data.
-
Analyze Email Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Email data in Microsoft R Open.
-
Automate Oracle Data Replication to Azure Synapse
Use CData Sync to customize and automate Oracle data replication to Azure Synapse.
-
Visualize Discourse Data in Tableau
The CData ODBC driver for Discourse enables you integrate Discourse data into Tableau dashboards.
-
Integrate LibreChat with Live FTP Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live FTP data from within the chat interface.
-
Build AI Agents with Google Spanner 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 Google Spanner data through CData Connect AI.
-
Build Sybase IQ-Connected Apps in Choreo
Use CData Connect AI to connect to Sybase IQ Data from Choreo and build custom apps using live Sybase IQ data.
-
How to Connect to Live Smartsheet 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 Smartsheet data for you.
-
Work with Reckon Data in FoxPro
Load Reckon data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Build Authorize.Net-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Authorize.Net Data and create custom apps in Mendix.
-
Query Live Zoho CRM Data in Zed Editor via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Zed Editor to securely access and query live Zoho CRM data directly from the development environment.
-
Process & Analyze Zoho Projects Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Zoho Projects Data.
-
Build Dashboards with Google Campaign Manager 360 Data in Dundas BI
Create dynamic dashboards and perform analytics based on Google Campaign Manager 360 data in Dundas BI.
-
Create Data Visualizations Based On Active Directory Data in Mode
Use CData Connect AI to connect to Active Directory Data from Mode and build visualizations using live Active Directory data.
-
Analyze SAP Ariba Procurement Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze SAP Ariba Procurement data with the CData JDBC Driver for SAP Ariba Procurement.
-
Getting Started with the CData Connect AI Python SDK for Wistia
Install the CData Connect AI Python SDK to read live Wistia data with standard DB-API 2.0 Python code.
-
Build Dynamics CRM Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Dynamics CRM data and build visualizations in Tableau Cloud.
-
Getting Started with the CData Excel Add-In for LinkedIn
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for LinkedIn.
-
How to Query Live SpaceX Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live SpaceX data data in natural language using Python.
-
Create Reports with Azure DevOps Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Azure DevOps data.
-
How to Access Live ClickUp Data in Power Automate Desktop via ODBC
The CData ODBC Driver for ClickUp enables you to integrate ClickUp data into workflows built using Microsoft Power Automate Desktop.
-
Connecting Pipedream with Email 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 Email data in real time.
-
Automated Continuous Teamgate Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Teamgate replication to delimited files (CSV/TSV).
-
Automated Continuous Amazon Athena Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Amazon Athena replication to Amazon Redshift.
-
Connect to ServiceDesk Plus Data in DBeaver
Use the CData ODBC Driver to connect to ServiceDesk Plus data in DBeaver.
-
Prepare, Blend, and Analyze PayPal Data in Alteryx Designer (Connect AI)
Build workflows to access live PayPal data for self-service data analytics.
-
Design BIRT Reports on Facebook Ads Data
Provide current Facebook Ads data to your embedded analytics.
-
Create Informatica Mappings From/To an ODBC Data Source for Cloudflare
Create an ODBC connection to Cloudflare in Informatica and browse and transfer Cloudflare data.
-
Visualize Live Sugar CRM Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Sugar CRM data into custom reports in Power BI.
-
Automated SAP Concur Data Replication to Teradata
Use CData Sync to Customize and automate SAP Concur data replication to Teradata.
-
Replicate PagerDuty Data in Heroku for Use in Salesforce Connect
Replicate PagerDuty data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
How to Connect to Live SQL Server 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 SQL Server data for you.
-
Use the CData SSIS Components to Insert New or Update Existing MYOB AccountRight Records from SQL Server
Easily push SQL Server data to MYOB AccountRight using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into MYOB AccountRight or update existing records with data from a SQL Server database.
-
How to Connect to Missive Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Missive data. Leverage the pyodbc module for ODBC in Python.
-
Automated Continuous Elasticsearch Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Elasticsearch replication to Amazon Redshift.
-
Integrate Cursor with Live LinkedIn Ads Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live LinkedIn Ads data from within the editor.
-
How to Seamlessly Import Databricks Data into IBM SPSS Modeler
Integrate Databricks data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Connect to Printful 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 Printful and work with Printful data in your FileMaker application.
-
How to Access Live Google Ads Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Google Ads enables you to integrate Google Ads data into workflows built using Microsoft Power Automate Desktop.
-
Automated Continuous RabbitMQ Replication to MongoDB
Use CData Sync for automated, continuous, customizable RabbitMQ replication to MongoDB.
-
Easily Integrate Pipeliner CRM Data in Lazarus Pascal IDE
Learn how to easily integrate live Pipeliner CRM data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
How to Seamlessly Import ZohoSubscriptions Data into IBM SPSS Modeler
Integrate ZohoSubscriptions data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Connect to Microsoft Ads Data in Aqua Data Studio
Access Microsoft Ads data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Automate Strava Data Replication to SAP HANA
Use CData Sync to customize and automate Strava data replication to SAP HANA.
-
How to Use a Microsoft Access Database to Update Microsoft Planner Data in Real Time
Update Microsoft Planner data by creating a linked table in Microsoft Access with the CData Microsoft Planner ODBC Driver.
-
Work with Facebook Ads Data in FoxPro
Load Facebook Ads data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Google Contacts
Provide connectivity to Google Contacts data through an SAP BusinessObjects universe.
-
Integrate Outreach.io with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Outreach.io with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Outreach.io data.
-
Connect to FHIR Data in Google Apps Script via Connect AI
Use CData Connect AI to access FHIR data in Google Apps Script.
-
Integrate Devin with Live BigQuery 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 BigQuery data.
-
Build Zoho Inventory-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Zoho Inventory Data and create custom apps in Bubble.
-
Connect to Parallel Data in Aqua Data Studio
Access Parallel data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Connect and Query Live Toggl Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Toggl data into Databricks and enable direct, live querying and analysis without replication.
-
Integrating LangChain with SAP Ariba Procurement Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on SAP Ariba Procurement data within automated workflows.
-
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.
-
Visualize Live CouchDB Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live CouchDB data.
-
Build Google Sheets-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 Google Sheets data without replication.
-
Enable the Wistia JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Wistia data.
-
Write a Simple Go Application to work with JobNimbus Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to JobNimbus data.
-
Migrating data from GitHub to Snowflake using CData SSIS Components.
Easily push GitHub data to Snowflake using the CData SSIS Tasks for GitHub and Snowflake.
-
Connect Procore to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Procore with IBM WebSphere for seamless data integration and connectivity.
-
Getting Started with the CData Connect AI Python SDK for ZohoSubscriptions
Install the CData Connect AI Python SDK to read live ZohoSubscriptions data with standard DB-API 2.0 Python code.
-
Connect to Gmail Data in NetBeans
Connect to Gmail data in NetBeans with the data source configuration wizard.
-
Automate Procore Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Procore data from PowerShell? This article demonstrates how to utilize the Procore Cmdlets for tasks like connecting to Procore data, automating operations, downloading data, and more.
-
Integrate SurveyMonkey Data in Pentaho Data Integration
Build ETL pipelines based on SurveyMonkey data in the Pentaho Data Integration tool.
-
Build AI/ML Models with Live Freshteam Data using Dataiku
Connect Freshteam Data with Dataiku using the CData API Driver for JDBC.
-
How to connect to Short.io Data in DBVisualizer
Integrate Short.io data with visual data analysis tools and data connection wizards in DBVisualizer