CData Software - Knowledge Base
Recent Articles
-
How to create an RPA flow for Paylocity Data in UiPath Studio
Use the Paylocity ODBC Driver to create workflows that access real-time Paylocity data without any coding.
-
Use the CData Software JDBC Driver for xBase in MicroStrategy Web
Connect to xBase data in MicroStrategy Web using the CData Software JDBC Driver for xBase.
-
Visualize WooCommerce Data in TIBCO Spotfire through ADO.NET
Integrate WooCommerce data into dashboards in TIBCO Spotfire.
-
Access Live Slack Data in TIBCO Data Virtualization
Use the Slack Tibco DV Adapter to create a Slack data data source in TIBCO Data Virtualization Studio and gain access to live Slack data from your TDV Server.
-
Automated Continuous IBM Cloud Object Storage Replication to MySQL
Use CData Sync for automated, continuous, customizable IBM Cloud Object Storage replication to MySQL.
-
Build Apps with Live Act CRM data in Adalo using CData Connect AI
Use CData Connect AI to integrate live Act CRM data into the Adalo platform and build custom mobile and web applications with real-time Act CRM data.
-
Create Reports with MailerSend Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date MailerSend data.
-
Connect to QuickBooks Time Data from Crystal Reports
Use CData Connect AI to connect to and report on live QuickBooks Time data from Crystal Reports.
-
Connect to Gorgias Data in JRuby
Create a simple JRuby app with access to live Gorgias data.
-
Access Jodoo Data from MySQL in PHP
Connect to Jodoo through the standard MySQL libraries in PHP.
-
Integrate with Dynamics 365 Business Central Data in JReport Designer
Create charts and reports based on Dynamics 365 Business Central data in JReport Designer.
-
How to Easily Query RSS Feeds in OpenOffice Base
Connect to RSS data in OpenOffice Base using the CData ODBC Driver for RSS and generate reports with live data insights.
-
Rapidly Develop CloudConvert-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 CloudConvert.
-
How to Connect to Live Google Calendar 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 Google Calendar data for you.
-
Visualize Live PagerDuty Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live PagerDuty data.
-
Connect to SAP Ariba Procurement Data from a Connection Pool in Jetty
The SAP Ariba Procurement JDBC Driver supports connection pooling: This article shows how to connect faster to SAP Ariba Procurement data from Web apps in Jetty.
-
Replicate MySQL Data to Multiple Databases
Replicate MySQL data to disparate databases with a point-and-click configuration.
-
Automated Continuous Superchat Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Superchat replication to Amazon S3.
-
Build a Singer.io Tap for Avalara AvaTax With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Avalara AvaTax data using the CData Python Connector.
-
Object-Relational Mapping (ORM) with Dropbox 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 Dropbox data into a Java-based ORM framework, Hibernate.
-
Access Live Zoho Creator Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Zoho Creator data from your Excel spreadsheets.
-
Build Apps with Live Reckon Accounts Hosted Data Using the Low-Code Development Platform of Mendix
Connect Reckon Accounts Hosted data with Mendix to build apps using the CData JDBC Driver for Reckon Accounts Hosted.
-
How to Connect Flowise AI Agents to Live Sage 300 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 300 data without replication.
-
Bind Live Bullhorn CRM Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Bullhorn CRM data and seamlessly connect and bind them to Wijmo's FlexGrid for real-time, interactive data access without manual data movement.
-
How to Create Power BI Visual Reports with Real-Time MYOB AccountRight Data
Use CData Power BI Connectors to visualize MYOB AccountRight data in Power BI.
-
Analyze Tickspot Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Tickspot from Power Pivot. You will use the Table Import Wizard to load Tickspot data. You can visually build the import query or use any SQL supported by the driver.
-
Visualize Redis Data in TIBCO Spotfire through ADO.NET
Integrate Redis data into dashboards in TIBCO Spotfire.
-
Integrating GitHub Copilot with Eventbrite 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.
-
Samanage Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Samanage facts in real time.
-
Connect to Paymo in SpagoBI
Create reports featuring live Paymo data in SpagoBI Studio. Host Paymo reports on SpagoBI Server.
-
Access Live SQL Server Data in TIBCO Data Virtualization
Use the SQL Server Tibco DV Adapter to create a SQL Server data data source in TIBCO Data Virtualization Studio and gain access to live SQL Server data from your TDV Server.
-
Integrating OpenCode with SFTP 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.
-
LaunchDarkly Reporting in OBIEE with the LaunchDarkly JDBC Driver
Deploy the LaunchDarkly JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Connect to Twitter Ads Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Twitter Ads Data and connect to Twitter Ads data in Akorbi Digital RunMyProcess.
-
Import and Visualize Reply.io Data in Power View
Create data visualizations based on Reply.io data in Excel.
-
Build an OLAP Cube in SSAS from SAS xpt Data
Establish a connection to SAS xpt data data from SQL Server Analysis Services, and use the SAS xpt Data Provider to build OLAP cubes for use in analytics and reporting.
-
Create Informatica Mappings From/To a JDBC Data Source for CapsuleCRM
Create CapsuleCRM data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Connect to Shortcut Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Shortcut data using standard SQL.
-
Automated Continuous MailerLite Replication to Databricks
Use CData Sync for automated, continuous, customizable MailerLite replication to Databricks.
-
Search External Samanage Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Samanage data to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Samanage Data objects that you can access from apps and the dashboard.
-
Integrate OpenCode with Live FreshBooks Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable OpenCode to securely access and query live FreshBooks data from within your AI coding agent.
-
Operational Reporting on Oracle Service Cloud Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Oracle Service Cloud data.
-
Object-Relational Mapping (ORM) with MailChimp 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 MailChimp data into a Java-based ORM framework, Hibernate.
-
Build Suadeo Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Suadeo data and build visualizations in Tableau.
-
Build Agents in Relevance AI with Access to Live MarkLogic Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on MarkLogic data within intelligent agent workflows.
-
Replicate Teamgate Data to Multiple Databases
Replicate Teamgate data to disparate databases with a point-and-click configuration.
-
Build Semantic Layer Views for Kintone Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Kintone data.
-
How to connect to Freshdesk Data in DBVisualizer
Integrate Freshdesk data with visual data analysis tools and data connection wizards in DBVisualizer
-
ETL Retently in Oracle Data Integrator
This article shows how to transfer Retently data into a data warehouse using Oracle Data Integrator.
-
Create Apps from NetSuite Data in Qlik Sense Cloud
Use CData Connect AI to connect to NetSuite Data and build apps from live NetSuite data in Qlik Sense Cloud.
-
Access Live QuickBooks Data in Coginiti Pro
Connect to and query live QuickBooks data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Import and Visualize Jodoo Data in Power View
Create data visualizations based on Jodoo data in Excel.
-
Integrating LangChain with Spark Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Spark data within automated workflows.
-
Access Live Grafana 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 Grafana data through MCP integration.
-
Migrating data from REST to Snowflake using CData SSIS Components.
Easily push REST data to Snowflake using the CData SSIS Tasks for REST and Snowflake.
-
How to Build an ETL App for Microsoft Planner Data in Python with CData Connect AI
Build ETL pipelines that read and write live Microsoft Planner data in Python with petl and the CData Connect AI Python SDK.
-
Automate HCL Domino Integration Tasks from PowerShell
Are you in search of a quick and easy way to access HCL Domino data from PowerShell? This article demonstrates how to utilize the HCL Domino Cmdlets for tasks like connecting to HCL Domino data, automating operations, downloading data, and more.
-
Use the CData Software ODBC Driver for Freshsales in MicroStrategy Desktop
Connect to Freshsales data in MicroStrategy Desktop using the CData Software ODBC Driver for Freshsales.
-
Analyze Bullhorn CRM Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Bullhorn CRM data with the CData JDBC Driver for Bullhorn CRM.
-
Moving Data from OnePageCrm to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live OnePageCrm data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
A PostgreSQL Interface for Freshsales Data (MySQL Remoting via JDBC)
Use the Remoting features of the Freshsales JDBC Driver to create a PostgreSQL entry-point for data access.
-
Getting Started with the CData ADO.NET Provider for WooCommerce
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for WooCommerce.
-
Integrate with Keap Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Keap data to a JSON file on disk.
-
Visualize Outlook Data in Tableau
The CData ODBC driver for Outlook enables you integrate Outlook data into Tableau dashboards.
-
Build Automated Workflows with Live Zoho Creator Data in Workato
Use CData Connect AI to connect to live Zoho Creator data and build automated workflows in Workato.
-
Configure the CData JDBC Driver for Supabase in a Connection Pool in Tomcat
Connect to Supabase data from a connection pool in Tomcat.
-
Automated Continuous Everhour Replication to SQL Server
Use CData Sync for automated, continuous, customizable Everhour replication to SQL Server.
-
Integrate LibreChat with Live Google Contacts Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Google Contacts data from within the chat interface.
-
Create Power BI Reports on Real-Time Invoiced Data
Use the CData ODBC Driver for Invoiced to visualize Invoiced data in Power BI Desktop.
-
Visualize Live QuickBooks Time Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live QuickBooks Time data into custom reports in Power BI.
-
Automated Continuous ADP Replication to Snowflake
Use CData Sync for automated, continuous, customizable ADP replication to Snowflake.
-
Visualize Microsoft Planner Data in Sisense
Create an ElastiCube in Sisense app with access to Microsoft Planner data.
-
Integrate OpenCode with Live Raisers Edge NXT Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable OpenCode to securely access and query live Raisers Edge NXT data from within your AI coding agent.
-
Automated Continuous FreshBooks Replication to SQLite
Use CData Sync for automated, continuous, customizable FreshBooks replication to SQLite.
-
Connect to MySQL Data in NetBeans
Connect to MySQL data in NetBeans with the data source configuration wizard.
-
Integrate Live SAS xpt 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 SAS xpt data from within the IDE.
-
Publish Elorus-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Elorus data.
-
Analyze Sage Cloud Accounting Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Sage Cloud Accounting from Power Pivot. You will use the Table Import Wizard to load Sage Cloud Accounting data. You can visually build the import query or use any SQL supported by the driver.
-
Back Up PostgreSQL data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for PostgreSQL. In this article, we will employ an SSIS workflow to populate a database with PostgreSQL data data.
-
Connect to IBM Informix Data in CloverDX (formerly CloverETL)
Transfer IBM Informix data using the visual workflow in the CloverDX data integration tool.
-
How to Connect DBeaver to Google Cloud Storage via a JDBC Driver
Manage Google Cloud Storage data with visual tools in DBeaver like the query browser.
-
Natively Connect to Reckon Accounts Hosted Data in PHP
The CData ODBC driver for Reckon Accounts Hosted enables you to create PHP applications with connectivity to Reckon Accounts Hosted data. Leverage the native support for ODBC in PHP.
-
How to Connect to Live Adobe Experience Manager Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Adobe Experience Manager data securely in real time.
-
Build Data Flows from Strava to SQL Server using SSIS
Easily back up Strava data to SQL Server using the SSIS components for Strava.
-
Create Informatica Mappings From/To a JDBC Data Source for Azure Table
Create Azure Table data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Connect to ZohoSubscriptions Data in Aqua Data Studio
Access ZohoSubscriptions data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Connect to Google Translate Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to Google Translate.
-
How to create Visio diagrams from Freshdesk Data
Automatically update Freshdesk data with the changes you make to Visio master shapes.
-
Query Cvent Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Cvent entities in PHP by modeling them as objects.
-
Connect to Elasticsearch Data from HeidiSQL
Use CData Connect AI to connect to and query live Elasticsearch data from HeidiSQL.
-
Establish a Live Connection with Databricks Data using Tableau Bridge
The CData ODBC Driver for Databricks enables you to integrate live Databricks data into Tableau Cloud dashboards using the Tableau Bridge.
-
Automated Continuous Reckon Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Reckon replication to Amazon S3.
-
Create SSAS Tabular Models from Google Forms Data
How to build a SQL Server Analysis Service Tabular Model from Google Forms data using CData drivers.
-
DataBind Controls to BigCommerce Data in C++Builder
DataBind to BigCommerce data in C++Builder with standard components and controls.
-
Build Data Flows from YouTube Analytics to SQL Server using SSIS
Easily back up YouTube Analytics data to SQL Server using the SSIS components for YouTube Analytics.
-
How to connect Amazon QuickSight to ConstantContact Data
Create a connection to ConstantContact data in CData Connect AI and insert ConstantContact data into Amazon QuickSight SPICE to build interactive dashboards.
-
Connect to Salesforce CRM Analytics Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Salesforce CRM Analytics to connect to Salesforce CRM Analytics data and execute queries in PowerBuilder.
-
Connecting Moonlit Workflow with Google Sheets 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 Google Sheets data in real time.
-
How to Connect to & Open Spark Data in Microsoft Excel
This article uses the CData ODBC driver for Spark to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Automate Discord Data Replication to SAP HANA
Use CData Sync to customize and automate Discord data replication to SAP HANA.