CData Software - Knowledge Base
Recent Articles
-
How to load Sage 200 data into Elasticsearch via Logstash
Introducing a simple method to load Sage 200 data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Automated Continuous Browserless Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Browserless replication to Amazon Redshift.
-
Automate HelloSign Integration Tasks from PowerShell
Are you in search of a quick and easy way to access HelloSign data from PowerShell? This article demonstrates how to utilize the HelloSign Cmdlets for tasks like connecting to HelloSign data, automating operations, downloading data, and more.
-
Visualize Kintone Data in TIBCO Spotfire through ADO.NET
Integrate Kintone data into dashboards in TIBCO Spotfire.
-
Visualize Rebilly 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 Rebilly data into TIBCO Spotfire.
-
Automate Salesforce CRM Analytics Data Replication to Azure Synapse
Use CData Sync to customize and automate Salesforce CRM Analytics data replication to Azure Synapse.
-
Publish Crystal Reports on IBM Cloud Object Storage Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date IBM Cloud Object Storage data.
-
How to connect and process Zoho Books data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Zoho Books data.
-
Automated Continuous ZohoPeople Replication to IBM DB2
Use CData Sync for automated, continuous, customizable ZohoPeople replication to IBM DB2.
-
Natively Connect to CloudConvert Data in PHP
The CData ODBC driver for CloudConvert enables you to create PHP applications with connectivity to CloudConvert data. Leverage the native support for ODBC in PHP.
-
Access Live Freshteam Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Freshteam data from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Integrate Shopify Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Shopify data from Informatica Cloud.
-
Build AI Agents with ZohoDesk 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 ZohoDesk data through CData Connect AI.
-
Visualize Amplitude Data in TIBCO Spotfire through ADO.NET
Integrate Amplitude data into dashboards in TIBCO Spotfire.
-
Automate Procore Data Replication to SAP HANA
Use CData Sync to customize and automate Procore data replication to SAP HANA.
-
Connect to Snapchat Ads Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Snapchat Ads data.
-
How to Access Microsoft OneDrive Data Using Entity Framework
This article shows how to access Microsoft OneDrive data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Analyze Stack Exchange Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Stack Exchange data in Microsoft R Open.
-
Publish Reports with Sybase Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Sybase data.
-
Integrating Kiro with Greenplum 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.
-
Integrating Codex with Humanity 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.
-
Use the CData Software JDBC Driver for Gorgias in MicroStrategy Web
Connect to Gorgias data in MicroStrategy Web using the CData Software JDBC Driver for Gorgias.
-
Build SparkPost-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live SparkPost data.
-
Integrate LibreChat with Live Discord Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Discord data from within the chat interface.
-
Easily Integrate Clio Data in Lazarus Pascal IDE
Learn how to easily integrate live Clio data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Create Todoist Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Todoist from PowerBI.com to create Power BI Dataflows with real-time data.
-
Build Dashboards with MongoDB Data in DBxtra
Create dynamic dashboards and perform analytics based on MongoDB data in DBxtra.
-
Connect to SingleStore Data from PowerBuilder via ADO.NET
This article demonstrates how to access SingleStore data from Appeon PowerBuilder using the CData ADO.NET Provider for SingleStore.
-
How to Connect Flowise AI Agents to Live Sage 200 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 Sage 200 data without replication.
-
Visualize Live Bitly Data in the Power BI Service
Use CData Connect AI to connect to live Bitly data and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Integrating JSON Services in Talend Cloud Data Management Platform
Connect JSON Services with Talend Cloud Data Management Platform using the CData JDBC Driver for JSON.
-
Connecting Agentforce with Kafka Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Agentforce to securely read and take actions on your Kafka data for you.
-
How to Connect to Google Spanner Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Google Spanner data. Leverage the pyodbc module for ODBC in Python.
-
Connect to ScrapingBee Data in NetBeans
Connect to ScrapingBee data in NetBeans with the data source configuration wizard.
-
Access Live Redshift Data in TIBCO Data Virtualization
Use the Redshift Tibco DV Adapter to create a Redshift data data source in TIBCO Data Virtualization Studio and gain access to live Redshift data from your TDV Server.
-
Enable the SageHR JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with SageHR data.
-
Use Claude to Talk to Your Reckon Accounts Hosted Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your Reckon Accounts Hosted data for you.
-
How to Work with Strava Data in AWS Glue Jobs Using JDBC
Connect to Strava from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Publish Reports with Foursquare Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Foursquare data.
-
Connect to EnterpriseDB Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live EnterpriseDB data from Filemaker Pro on Mac.
-
Connect to Amazon S3 Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Amazon S3 Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Integrate Smartsheet Data in the Pentaho Report Designer
Publish reports based on Smartsheet data in the Pentaho BI tool.
-
Connect to SageHR Data from HeidiSQL
Use CData Connect AI to connect to and query live SageHR data from HeidiSQL.
-
Consume Adobe Target OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Adobe Target feeds that reflect any changes in SAP Lumira.
-
Access Live GitHub 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 GitHub data through MCP integration.
-
Easily Integrate Helpscout Data in Lazarus Pascal IDE
Learn how to easily integrate live Helpscout data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Create Informatica Mappings From/To an ODBC Data Source for Procore
Create an ODBC connection to Procore in Informatica and browse and transfer Procore data.
-
Use Manus AI to Talk to Your Zendesk Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Manus AI agents to securely answer questions and take actions on Zendesk data.
-
Connect to Yelp 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 Yelp and work with Yelp data in your FileMaker application.
-
Integrate Theia IDE with Live Adobe Experience Manager Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE's built-in AI agents to securely access and query live Adobe Experience Manager data from within the development environment.
-
Integrate Live Redis 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 Redis data from within the IDE.
-
Connect to Live Kintone Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Kintone in CData Connect AI and connect to your Kintone data from PostgreSQL.
-
Use JayDeBeApi to access Google Ads Data in Python
Use standard Python scripting and the development environment of your choice to access live Google Ads data.
-
Connect to Monday.com Data in Aqua Data Studio
Access Monday.com data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Work with Lakebase Data in FoxPro
Load Lakebase data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Connect to SAS xpt Data in DBeaver
Use the CData ODBC Driver to connect to SAS xpt data in DBeaver.
-
Build Bullhorn CRM-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Bullhorn CRM data.
-
How to Seamlessly Import Twitter Ads Data into IBM SPSS Modeler
Integrate Twitter Ads data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Create Informatica Mappings From/To a JDBC Data Source for Cosmos DB
Create Cosmos DB data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Access Sybase Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Sybase data from your Oracle system.
-
Access Live Salesforce Data 360 Data in Emergent via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Emergent agents to securely access and build applications with live Salesforce Data 360 data through MCP integration.
-
Use the CData Software ODBC Driver for RabbitMQ in SAS for Real-Time Reporting and Analytics
Connect to real-time RabbitMQ data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for RabbitMQ.
-
Build Act CRM-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 Act CRM data without replication.
-
Deploy the ADO.NET Provider for Sage 200 on an SSRS Report Server
Connect to Sage 200 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.
-
Integrate Live XML Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live XML data to Blue Prism using the CData ODBC Driver for XML to create automated workflows for repetitive business tasks.
-
Automated Continuous AdRoll Replication to SingleStore
Use CData Sync for automated, continuous, customizable AdRoll replication to SingleStore.
-
Visualize Live Sentry Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Sentry data.
-
Build Dashboards with Google Ads Data in Dundas BI
Create dynamic dashboards and perform analytics based on Google Ads data in Dundas BI.
-
How to Visualize Confluence Data in Python with pandas
Use pandas and other modules to analyze and visualize live Confluence data in Python.
-
How to connect Amazon QuickSight to BenchmarkEmail Data
Create a connection to BenchmarkEmail data in CData Connect AI and insert BenchmarkEmail data into Amazon QuickSight SPICE to build interactive dashboards.
-
Automated Continuous Salesforce Pardot Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Salesforce Pardot replication to AlloyDB.
-
Access Live Greenhouse Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Greenhouse data from your Google Sheets.
-
Replicate Clari Data from PowerShell
Write a quick PowerShell script to query Clari data. Use connectivity to the live data to replicate Clari data to SQL Server.
-
Moving Data from Exact Online to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Exact Online data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Automated Continuous Oracle SCM Replication to Oracle
Use CData Sync for automated, continuous, customizable Oracle SCM replication to Oracle.
-
Bidirectional Access to Spark Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Spark data in Filemaker Pro for Mac or Windows.
-
Integrating Boomi Agentstudio with Cloudant Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Cloudant data, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Visualize Square Data in TIBCO Spotfire through OData
Integrate Square data into dashboards in TIBCO Spotfire.
-
Automate MessageBird Data Replication to Azure Data Lake
Use CData Sync to customize and automate MessageBird data replication to Azure Data Lake.
-
How to Connect DBeaver to SAP ByDesign via a JDBC Driver
Manage SAP ByDesign data with visual tools in DBeaver like the query browser.
-
Provide OData Services of Webex Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Webex data by developing a WCF Service Application.
-
Process & Analyze Exa Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Exa Data.
-
Automated Continuous Klipfolio Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Klipfolio data replication to OneLake in Microsoft Fabric.
-
Connect to Testmonitor Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Testmonitor Data and connect to Testmonitor data in Akorbi Digital RunMyProcess.
-
Connect to Zoho Creator Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Zoho Creator and the SQL Gateway to access Zoho Creator data from Google Apps Script.
-
Replicate QuickBooks Data to Multiple Databases
Replicate QuickBooks data to disparate databases with a point-and-click configuration.
-
Build Oracle Sales-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Oracle Sales Data and create custom apps in Mendix.
-
Query Microsoft Planner Data in ColdFusion
Write standard ColdFusion data access code to connect to Microsoft Planner data.
-
Integrating Cursor with Amazon DynamoDB 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.
-
Replicate Couchbase Data to Multiple Databases
Replicate Couchbase data to disparate databases with a point-and-click configuration.
-
Connect to Opsgenie from Asprova with CData Software ODBC Driver for Opsgenie
This article shows how to connect faster to Opsgenie data from Asprova.
-
Integrate LibreChat with Live Adobe Experience Manager Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Adobe Experience Manager data from within the chat interface.
-
Use Dash to Build to Web Apps on Discord Data
Create Python applications that use pandas and Dash to build Discord-connected web apps.
-
Stream Drip Data into Apache Kafka Topics
Access and stream Drip data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Access ConvertAPI Data from MySQL in PHP
Connect to ConvertAPI through the standard MySQL libraries in PHP.
-
Act CRM Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Act CRM facts in real time.
-
Connect to ServiceNow Data as an External Source in Dremio
Use the CData JDBC Driver to connect to ServiceNow as an External Source in Dremio.
-
A PostgreSQL Interface for Impala Data using the CData ODBC Driver
Use the SQL Gateway and Impala ODBC Driver to create a PostgreSQL entry-point for data access.
-
Create Asana-Connected Dashboards in Grafana
Connect to Asana Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Asana data.
-
Publish Zoho Creator-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Zoho Creator data.