CData Software - Knowledge Base
Recent Articles
-
Integrating Kiro with Wrike 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 an SAP BusinessObjects Universe on the CData ODBC Driver for Samanage
Provide connectivity to Samanage data through an SAP BusinessObjects universe.
-
Manage VWO Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for VWO.
-
Automated Continuous MariaDB Replication to MongoDB
Use CData Sync for automated, continuous, customizable MariaDB replication to MongoDB.
-
Build Visualizations of Ontraport Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Ontraport data in Birst.
-
Build AI/ML Models with Live Smartsheet Data using Dataiku
Connect Smartsheet Data with Dataiku using the CData JDBC Driver for Smartsheet.
-
Build Toggl-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Toggl data and build web apps with connectivity to live Toggl data.
-
Query Live Paylocity Data in Perplexity Desktop via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Perplexity Desktop to securely access and query live Paylocity data through a conversational interface.
-
Build Visualizations of Jodoo Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Jodoo data in Birst.
-
Use the CData Software ODBC Driver for Perigon in MicroStrategy Desktop
Connect to Perigon data in MicroStrategy Desktop using the CData Software ODBC Driver for Perigon.
-
Write a Simple Go Application to work with Dropbox Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Dropbox data.
-
How to integrate Metabase with Mode Data
Use CData Connect AI to connect to live Mode data and create an interactive dashboard in Metabase from Mode data.
-
How to Connect to Live SageHR 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 SageHR data for you.
-
Integrate Mixpanel Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Mixpanel data from Informatica Cloud.
-
Connect to Workday Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Workday and the SQL Gateway to access Workday data from Google Apps Script.
-
Connecting GenSpark with Snapchat Ads Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Snapchat Ads data without any replication or custom integration required.
-
Build Exact Online-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Exact Online data and build web apps with connectivity to live Exact Online data.
-
Build Voice Agents in ElevenLabs with access to Live Adobe Experience Manager Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Adobe Experience Manager data.
-
Back Up Pipedrive data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Pipedrive. In this article, we will employ an SSIS workflow to populate a database with Pipedrive data data.
-
Automate SAP Fieldglass Data Replication to Couchbase
Use CData Sync to Customize and automate SAP Fieldglass data replication to Couchbase.
-
Automated Continuous ZohoMarketingHub Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable ZohoMarketingHub replication to Apache Kafka.
-
How to Connect the Power BI Service to Google Sheets: Complete Guide
Connect to the CData Software Power BI Connector for Google Sheets from PowerBI.com to provide real-time Google Sheets data across the organization.
-
Connect to Codat Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Codat data using standard SQL.
-
How to connect Amazon QuickSight to ZohoExpense Data
Create a connection to ZohoExpense data in CData Connect AI and insert ZohoExpense data into Amazon QuickSight SPICE to build interactive dashboards.
-
Connect SAP SuccessFactors LMS to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect SAP SuccessFactors LMS with IBM WebSphere for seamless data integration and connectivity.
-
Access NetSuite RESTlets as Views
Use CData Data Providers for NetSuite to access RESTlets from third-party tools.
-
Use ChatGPT to Talk to Your SAP Concur Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable ChatGPT to securely answer questions and take actions on your SAP Concur data for you.
-
Integrate with Live AgileCRM Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to AgileCRM from the MuleSoft Anypoint Platform to integrate live AgileCRM data into custom reports and dashboards.
-
Integrate Google's Antigravity Agent with Live PayPal Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live PayPal data using the Model Context Protocol.
-
Build Jira Assets-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Jira Assets data.
-
Replicate iContact Data from PowerShell
Write a quick PowerShell script to query iContact data. Use connectivity to the live data to replicate iContact data to SQL Server.
-
How to Connect the Power BI Service to QuickBooks: Complete Guide
Connect to the CData Software Power BI Connector for QuickBooks from PowerBI.com to provide real-time QuickBooks data across the organization.
-
Integrating Antigravity CLI with Oracle Financials Cloud data via CData CLI
Connect Oracle Financials Cloud data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Provide OData Services of Avalara AvaTax Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Avalara AvaTax data by developing a WCF Service Application.
-
Integrate MySQL Data into Power Automate Desktop using CData Connect
CData Connect for MySQL Data enables you to integrate MySQL data into workflows built using Microsoft Power Automate Desktop.
-
Connect to Aha! Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Aha! data using standard SQL.
-
Create Informatica Mappings From/To a JDBC Data Source for Salesforce CRM Analytics
Create Salesforce CRM Analytics data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Access Cohere Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Cohere data from your Oracle system.
-
Access Live Power BI XMLA Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Power BI XMLA data into the statistical analysis tools available in SAS JMP. This article shows how to use Power BI XMLA data in the Graph Builder and Query Builder.
-
Visualize Live Microsoft Entra ID Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Microsoft Entra ID data.
-
Prepare, Blend, and Analyze Clockify Data in Alteryx Designer (ODBC)
Build workflows to access live Clockify data for self-service data analytics.
-
Query SFTP Data as a MySQL Database in Node.js
Execute MySQL queries against SFTP data from Node.js.
-
How to Connect to & Open Bitbucket Data in Microsoft Excel
This article uses the CData ODBC driver for Bitbucket to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Build Excel Online-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Excel Online Data from Zoho Analytics and import live Excel Online data.
-
Use Azure AI Foundry to Talk to Your Oracle SCM Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Azure AI Foundry agents to securely answer questions and take actions on your Oracle SCM data for you.
-
Excel Spreadsheet Automation on Jira Data with the QUERY Formula
Pull data from Jira, automate spreadsheets, and more with the QUERY formula.
-
Import Real-Time Helpscout Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Helpscout data in ColdFusion.
-
How to connect to Spark Data in DBVisualizer
Integrate Spark data with visual data analysis tools and data connection wizards in DBVisualizer
-
Automated Continuous ZendeskSell Replication to Databricks
Use CData Sync for automated, continuous, customizable ZendeskSell replication to Databricks.
-
Bridge Attio Connectivity with Apache NiFi
Access and process Attio data in Apache NiFi using the CData JDBC Driver.
-
Access Instagram Data in Mule Applications Using the CData JDBC Driver
Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for Instagram data.
-
Publish Crystal Reports on Adobe Target Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Adobe Target data.
-
Integrate Gorgias with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Gorgias with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Gorgias data.
-
Pipeline CRM Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Pipeline CRM facts in real time.
-
Getting Started with the CData JDBC Driver for Gmail
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Gmail.
-
Design BIRT Reports on Greenplum Data
Provide current Greenplum data to your embedded analytics.
-
Automated Continuous Zendesk Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Zendesk replication to Amazon S3.
-
Operational Reporting on QuickBooks Time Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote QuickBooks Time data.
-
Build a PostgreSQL Interface for Facebook Data using the CData JDBC Driver
Use the Remoting features of the Facebook JDBC Driver to create a PostgreSQL entry-point for data access.
-
Query Teamgate Data as a MySQL Database in Node.js
Execute MySQL queries against Teamgate data from Node.js.
-
Integrate Live MailChimp Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to MailChimp data and integrate live MailChimp data into apps built in Microsoft Power Apps.
-
How to connect Amazon QuickSight to Confluence Data
Create a connection to Confluence data in CData Connect AI and insert Confluence data into Amazon QuickSight SPICE to build interactive dashboards.
-
How to Connect DBeaver to ServiceDesk Plus via a JDBC Driver
Manage ServiceDesk Plus data with visual tools in DBeaver like the query browser.
-
Integrate Impala Data in Pentaho Data Integration
Build ETL pipelines based on Impala data in the Pentaho Data Integration tool.
-
Automate Oracle SCM Data Replication to Azure Synapse
Use CData Sync to customize and automate Oracle SCM data replication to Azure Synapse.
-
Analyze Live Paylocity Data in SAS Viya
Use CData Connect AI to connect to Paylocity data from SAS Viya and deploy self-service analytics using live Paylocity data.
-
Automated Continuous Shopify Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Shopify replication to IBM DB2.
-
DataBind Amazon Athena Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for Amazon Athena with the DevExpress Windows Forms and Web controls to provide Amazon Athena data to a chart.
-
Visualize Paylocity Data in Tableau
The CData ODBC driver for Paylocity enables you integrate Paylocity data into Tableau dashboards.
-
Analyze Egnyte Data in Cognos Analytics
Use CData Connect AI to connect to Egnyte Data from Cognos Analytics and analyze live Egnyte data.
-
Visualize SAP Fieldglass Data in TIBCO Spotfire through OData
Integrate SAP Fieldglass data into dashboards in TIBCO Spotfire.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Freshdesk
Provide connectivity to Freshdesk data through an SAP BusinessObjects universe.
-
Integrate with QuickBooks Data in SnapLogic
Use CData Connect AI to connect to and integrate with live QuickBooks data in SnapLogic.
-
How to create Google Drive federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Google Drive data in MySQL .
-
Integrating LlamaIndex with Twilio Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Twilio data in real time.
-
Prepare, Blend, and Analyze IBM Cloud Object Storage Data in Alteryx Designer (Connect AI)
Build workflows to access live IBM Cloud Object Storage data for self-service data analytics.
-
How to Work with Snapchat Ads Data in ETL Validator JDBC
Connect to Snapchat Ads from ETL Validator jobs using the CData Software JDBC Driver.
-
Visualize Act CRM Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Act CRM data.
-
Operational Reporting on Highrise Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Highrise data.
-
Use CData Connect AI to Access Grafana Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Grafana data in the Power Pivot business intelligence tool.
-
Visualize Odoo Data in Tableau
The CData ODBC driver for Odoo enables you integrate Odoo data into Tableau dashboards.
-
Integrate Dify with Live Microsoft Entra ID Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Dify agents and workflows to securely access and query live Microsoft Entra ID data.
-
Build Data Flows from GitLab to SQL Server using SSIS
Easily back up GitLab data to SQL Server using the SSIS components for GitLab.
-
Access Live Basecamp Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Basecamp data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Import and Visualize Gorgias Data in Power View
Create data visualizations based on Gorgias data in Excel.
-
Replicate Hugging Face Data from PowerShell
Write a quick PowerShell script to query Hugging Face data. Use connectivity to the live data to replicate Hugging Face data to SQL Server.
-
How to integrate Close with Apache Airflow
Access and process Close data in Apache Airflow using the CData JDBC Driver.
-
How to Connect HubSpot 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 HubSpot data in real time using natural language.
-
Model, Search, and Visualize Live MYOB AccountRight Data in ThoughtSpot
Use CData Connect AI to connect to live MYOB AccountRight data for modeling, searching, and visualizing.
-
Avro Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Avro facts in real time.
-
Build an OLAP Cube in SSAS from Moosend Data
Establish a connection to Moosend data data from SQL Server Analysis Services, and use the Moosend Data Provider to build OLAP cubes for use in analytics and reporting.
-
Getting Started with the CData ODBC Driver for PostgreSQL
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for PostgreSQL.
-
How to Connect to QuickBooks Online Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to QuickBooks Online data. Leverage the pyodbc module for ODBC in Python.
-
Connect to and Visualize Live JSON Services in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live JSON services.
-
Automated Continuous Sage Cloud Accounting Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Sage Cloud Accounting replication to Apache Kafka.
-
Integrate Google's Antigravity Agent with Live Freshservice Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Freshservice data using the Model Context Protocol.
-
Operational Reporting on Salesforce CRM Analytics Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Salesforce CRM Analytics data.
-
Explore Geographical Relationships in Klaviyo Data with Power Map
Create data visualizations with Klaviyo data in Power Map.
-
Enable the JSON JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with JSON services.
-
Integrate Live LinkedIn Ads Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live LinkedIn Ads data to Blue Prism using the CData ODBC Driver for LinkedIn Ads to create automated workflows for repetitive business tasks.