CData Software - Knowledge Base
Recent Articles
-
Connect to CSV Data from PowerBuilder via ADO.NET
This article demonstrates how to access CSV data from Appeon PowerBuilder using the CData ADO.NET Provider for CSV.
-
How to Access Live Microsoft Exchange Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Microsoft Exchange enables you to integrate Microsoft Exchange data into workflows built using Microsoft Power Automate Desktop.
-
Connect to Flowlu Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Flowlu and the SQL Gateway to access Flowlu data from Google Apps Script.
-
Automated Continuous Gumroad Replication to MySQL
Use CData Sync for automated, continuous, customizable Gumroad replication to MySQL.
-
Integrating Claude Code with Smartsheet Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Smartsheet data within assisted coding and automated development workflows.
-
Integrate Open WebUI with Live Dynamics 365 Business Central Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Dynamics 365 Business Central data from within the chat interface.
-
Connect to ScrapingBee Data from a Connection Pool in Jetty
The ScrapingBee JDBC Driver supports connection pooling: This article shows how to connect faster to ScrapingBee data from Web apps in Jetty.
-
Connect to QuickBooks Time from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from QuickBooks Time data, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Build Airtable-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Airtable data and build Airtable-connected web apps with Axios.
-
Integrating Claude Code CLI with SingleStore 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.
-
Create a Data Access Object for Sugar CRM Data using JDBI
A brief overview of creating a SQL Object API for Sugar CRM data in JDBI.
-
Automated Continuous Everhour Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Everhour replication to AlloyDB.
-
Replicate Reckon Data from PowerShell
Write a quick PowerShell script to query Reckon data. Use connectivity to the live data to replicate Reckon data to SQL Server.
-
Create Datasets from Vimeo in Domo Workbench and Build Visualizations of Vimeo Data in Domo
Use the CData Software ODBC Driver for Vimeo to create datasets from Vimeo data in Domo Workbench and then build visualizations in the Domo service.
-
Connect to Excel Online Data in Jaspersoft Studio
Execute SQL to remote Excel Online data in Jaspersoft Studio.
-
A PostgreSQL Interface for Todoist Data (MySQL Remoting via JDBC)
Use the Remoting features of the Todoist JDBC Driver to create a PostgreSQL entry-point for data access.
-
Visualize Greenplum Data in TIBCO Spotfire through ADO.NET
Integrate Greenplum data into dashboards in TIBCO Spotfire.
-
Connect to SAS Data Sets Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for SAS Data Sets and the SQL Gateway to access SAS Data Sets data from Google Apps Script.
-
Automated Continuous Oracle Eloqua Reporting Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Oracle Eloqua Reporting replication to Apache Cassandra.
-
Import Spark Data Using Azure Data Factory
Use CData Connect AI to connect to Spark Data from Azure Data Factory and import live Spark data.
-
Create Informatica Mappings From/To a JDBC Data Source for Clari
Create Clari data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Visualize Elasticsearch Data in TIBCO Spotfire through OData
Integrate Elasticsearch data into dashboards in TIBCO Spotfire.
-
Automated Continuous ZohoPeople Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable ZohoPeople replication to delimited files (CSV/TSV).
-
Analyze Avro Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Avro data and visualize live Avro data in Infragistics Reveal.
-
Automate Wave Financial Data Replication to SAP HANA
Use CData Sync to customize and automate Wave Financial data replication to SAP HANA.
-
How to Connect to Live PolarTeamPro 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 PolarTeamPro data for you.
-
How to Connect DBeaver to Microsoft Planner via a JDBC Driver
Manage Microsoft Planner data with visual tools in DBeaver like the query browser.
-
Automated Continuous Acumatica Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Acumatica data replication to OneLake in Microsoft Fabric.
-
Build SAP ByDesign-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to SAP ByDesign Data from Zoho Analytics and import live SAP ByDesign data.
-
Publish Reports with BambooHR Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date BambooHR data.
-
Connect to Tally Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Tally data.
-
Access Live Mailjet Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Mailjet data into the statistical analysis tools available in SAS JMP. This article shows how to use Mailjet data in the Graph Builder and Query Builder.
-
Automated Continuous Amazon Marketplace Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Amazon Marketplace replication to Azure SQL Database.
-
A PostgreSQL Interface for Typeform Data using the CData ODBC Driver
Use the SQL Gateway and Typeform ODBC Driver to create a PostgreSQL entry-point for data access.
-
Build Dashboards with Nuclia Data in DBxtra
Create dynamic dashboards and perform analytics based on Nuclia data in DBxtra.
-
How to connect to Teamwork Data in DBVisualizer
Integrate Teamwork data with visual data analysis tools and data connection wizards in DBVisualizer
-
Replicate Multiple ElevenLabs Accounts via the CData Sync CLI
Replicate multiple ElevenLabs accounts to one or many databases.
-
How to connect and process Google Search results from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Google Search results.
-
Automate Reckon Data Replication to Azure Synapse
Use CData Sync to customize and automate Reckon data replication to Azure Synapse.
-
Integrate Certinia with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Certinia with External Services.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Oracle Financials Cloud
Provide connectivity to Oracle Financials Cloud data through an SAP BusinessObjects universe.
-
Trigger Cloudant IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for Cloudant with standard wizards in Logic Apps.
-
Search External Google Cloud Storage Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Google Cloud Storage data to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Google Cloud Storage Data objects that you can access from apps and the dashboard.
-
Link Apollo with FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Apollo data in Filemaker Pro for Mac or Windows.
-
Search External Apollo Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Apollo data to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Apollo Data objects that you can access from apps and the dashboard.
-
How to Access Azure Data Lake Storage Data Using Entity Framework
This article shows how to access Azure Data Lake Storage data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Building Dynamic Web Pages with Marketo Data Using AngularJS
Create single-page applications with live connectivity to Marketo using the CData API Server.
-
Stream Discourse Data into Apache Kafka Topics
Access and stream Discourse data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Build an OLAP Cube in SSAS from GitHub Data
Establish a connection to GitHub data data from SQL Server Analysis Services, and use the GitHub Data Provider to build OLAP cubes for use in analytics and reporting.
-
How to connect PolyBase to Everhour
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Everhour data.
-
Perform Batch Operations with Act CRM Data in Apache NiFi
Connect to Act CRM data and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Getting Started with the CData JDBC Driver for Workable
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Workable.
-
Access LightSpeedRetail Data from MySQL in Amazon QuickSight
Connect to LightSpeedRetail and build visualizations of LightSpeedRetail data using a MySQL Connection in Amazon QuickSight.
-
How to Seamlessly Import EnterpriseDB Data into IBM SPSS Modeler
Integrate EnterpriseDB data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Build Dashboards with Shortcut Data in Dundas BI
Create dynamic dashboards and perform analytics based on Shortcut data in Dundas BI.
-
Integrating Boomi Agentstudio with FTP Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to FTP data, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Use Manus AI to Talk to Your Shopify 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 Shopify data.
-
Access Live Exact Online Data in Coginiti Pro
Connect to and query live Exact Online data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
How to Visualize Excel Online 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 Excel Online data in Python.
-
LINQ to ZohoInvoice 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 ZohoInvoice Data Provider.
-
Neo4J Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Neo4J facts in real time.
-
Integrate Goose with Live Shortcut Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Shortcut data from within the local AI agent.
-
Connect to Power BI XMLA Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Power BI XMLA data.
-
Automated Continuous Postmark Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Postmark data replication to OneLake in Microsoft Fabric.
-
Connect to Oracle Data from a Connection Pool in JBoss
Integrate Oracle data into Java servlets: Use the Management Console in JBoss to install the Oracle JDBC Driver.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Salesforce Data 360
Provide connectivity to Salesforce Data 360 data through an SAP BusinessObjects universe.
-
Analyze Live Discord Data in SAS Viya
Use CData Connect AI to connect to Discord data from SAS Viya and deploy self-service analytics using live Discord data.
-
Automate Asana Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Asana data from PowerShell? This article demonstrates how to utilize the Asana Cmdlets for tasks like connecting to Asana data, automating operations, downloading data, and more.
-
Connect to ServiceNow Data in Claris FileMaker Pro
Use the CData ODBC Driver for ServiceNow in FileMaker Pro to connect to ServiceNow and work with ServiceNow data in your FileMaker applications.
-
Integrate Office 365 Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Office 365 data from Informatica Cloud.
-
Visualize PayPal Data in Sisense
Create an ElastiCube in Sisense app with access to PayPal data.
-
Access Live Sybase 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 Sybase data through MCP integration.
-
Create Pipedrive-Connected Nintex Workflows
Use CData Connect AI to connect to Pipedrive Data from Nintex Workflow Cloud and build custom workflows using live Pipedrive data.
-
Connect to SAS Data Sets Data as an External Source in Dremio
Use the CData JDBC Driver to connect to SAS Data Sets as an External Source in Dremio.
-
Create Reports with Microsoft Ads Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Microsoft Ads data.
-
Publish QuickBooks Time-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live QuickBooks Time data.
-
Connect to Cohere Data in DBeaver
Use the CData ODBC Driver to connect to Cohere data in DBeaver.
-
Connect to Adobe Commerce Data in Jaspersoft Studio
Execute SQL to remote Adobe Commerce data in Jaspersoft Studio.
-
Automated Continuous Superchat Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Superchat replication to Amazon Redshift.
-
Replicate Multiple Aha! Accounts
Replicate multiple Aha! accounts to one or many databases.
-
Integrate Live NetSuite Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to NetSuite data and integrate live NetSuite data into apps built in Microsoft Power Apps.
-
How to connect and process Aha! data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Aha! data.
-
How to publish and share LinkedIn Ads Data dashboards with Tableau Server
The CData ODBC driver for LinkedIn Ads enables you integrate LinkedIn Ads data into Tableau dashboards.
-
Automated Continuous ServiceDesk Plus Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable ServiceDesk Plus replication to Apache Cassandra.
-
Visualize Smartsheet 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 Smartsheet data into TIBCO Spotfire.
-
Integrate with PolarTeamPro Data in JReport Designer
Create charts and reports based on PolarTeamPro data in JReport Designer.
-
Visualize Live SparkPost Data in the Power BI Service
Use CData Connect AI to connect to live SparkPost data and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Create TaxJar-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to TaxJar Data from Klipfolio and build custom visualizations using live TaxJar data.
-
Automated Continuous GetResponse Replication to AlloyDB
Use CData Sync for automated, continuous, customizable GetResponse replication to AlloyDB.
-
How to integrate Metabase with Vertica Data
Use CData Connect AI to connect to live Vertica data and create an interactive dashboard in Metabase from Vertica data.
-
Connect to Dynamics CRM Data in RapidMiner
Integrate Dynamics CRM data with standard components and data source configuration wizards in RapidMiner Studio.
-
Integrating GitHub Copilot with Perplexity 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.
-
Getting Started with the CData ADO.NET Provider for Close
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Provide OData Services of HubSpot Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for HubSpot data by developing a WCF Service Application.
-
Use Databricks Agent Bricks to Talk to Your Excel Online Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Excel Online data for you.
-
How to Seamlessly Import Reckon Data into IBM SPSS Modeler
Integrate Reckon data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Connect to Live Stripe Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Stripe in CData Connect AI and connect to your Stripe data from PostgreSQL.
-
Create Splunk-Connected Business Apps in AppSheet
Connect to Splunk Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Splunk data.
-
How to Build an ETL App for SAP Ariba Procurement Data in Python with CData Connect AI
Extract and transform live SAP Ariba Procurement data in Python with petl and the CData Connect AI Python SDK.
-
Create Reports with Microsoft Planner Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Microsoft Planner data.