CData Software - Knowledge Base
Recent Articles
-
Automate JSON Services Replication to Couchbase
Use CData Sync to Customize and automate JSON services replication to Couchbase.
-
Connect to LeadDesk Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for LeadDesk data.
-
Access Live ZohoPeople 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 ZohoPeople data through MCP integration.
-
Integrate Dify with Live Dropbox 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 Dropbox data.
-
Connect to Todoist Data in DBeaver
Use the CData ODBC Driver to connect to Todoist data in DBeaver.
-
Create AgileCRM-Connected Nintex Workflows
Use CData Connect AI to connect to AgileCRM Data from Nintex Workflow Cloud and build custom workflows using live AgileCRM data.
-
Use the CData Software ODBC Driver for Jumpseller in SAS for Real-Time Reporting and Analytics
Connect to real-time Jumpseller data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Jumpseller.
-
Connect to AlloyDB Data in ACL Analytics
Connect to AlloyDB data via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to AlloyDB data.
-
Use Dash to Build Web Apps on Google Spanner Data via CData Connect AI
Build interactive Dash web apps on live Google Spanner data using pandas and the CData Connect AI Python SDK.
-
Create Printify-Connected Applications in Appsmith
Connect to Printify Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Printify data.
-
Import Real-Time JSON Services via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use JSON services in ColdFusion.
-
Create Adobe Analytics-Connected Applications in Appsmith
Connect to Adobe Analytics Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Adobe Analytics data.
-
Connect to SAS xpt Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for SAS xpt and the SQL Gateway to access SAS xpt data from Google Apps Script.
-
Connect to and Query Freshteam Data in QlikView over ODBC
Create data visualizations with Freshteam data in QlikView.
-
Analyze MailChimp Data in Cognos Analytics
Use CData Connect AI to connect to MailChimp Data from Cognos Analytics and analyze live MailChimp data.
-
Visualize ZohoDesk Data in Sisense
Create an ElastiCube in Sisense app with access to ZohoDesk data.
-
Create Dashboards and Visualize Live Vertica Data in Geckoboard
Use CData Connect AI to connect to live Vertica data and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Create Data Visualizations in Cognos BI with Sage Intacct Data
Access Sage Intacct data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Connecting GenSpark with Mailjet Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Mailjet data without any replication or custom integration required.
-
Analyze Spark Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Spark data and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Excel Spreadsheet Automation on Dynamics 365 Business Central Data with the QUERY Formula
Pull data from Dynamics 365 Business Central, automate spreadsheets, and more with the QUERY formula.
-
Create Klipfolio Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Klipfolio from PowerBI.com to create Power BI Dataflows with real-time data.
-
Creating Microsoft Dataverse-Connected Applications in Unqork
You can use CData Connect AI to feed Microsoft Dataverse data to Unqork and build custom business apps.
-
Create Zoho Creator-Connected Applications in Appsmith
Connect to Zoho Creator Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Zoho Creator data.
-
Access Live Google Ad Manager 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 Google Ad Manager data through MCP integration.
-
Analyze Supabase Data in Looker
Use CData Connect AI to connect to Supabase Data from Looker and build custom apps using live Supabase data.
-
How to connect to SAP Ariba Procurement Data with Squirrel SQL client
Connect to SAP Ariba Procurement data and execute queries in the Squirrel SQL Client.
-
Connect to Google Calendar Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Google Calendar data.
-
How to Create Power BI Visual Reports with Real-Time AdRoll Data
Use CData Power BI Connectors to visualize AdRoll data in Power BI.
-
Integrate OpenCode with Live Exa Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable OpenCode to securely access and query live Exa data from within your AI coding agent.
-
Visualize Avalara AvaTax 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 Avalara AvaTax data into TIBCO Spotfire.
-
Analyze Apollo Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Apollo data and visualize live Apollo data in Infragistics Reveal.
-
Visualize Live Jira Data in the Power BI Service
Use CData Connect AI to connect to live Jira data and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Analyze Front Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Front data in Microsoft R Open.
-
Build Data Flows from Quickbase to SQL Server using SSIS
Easily back up Quickbase data to SQL Server using the SSIS components for Quickbase.
-
Use the CData Software ODBC Driver for SQL Server in SAS for Real-Time Reporting and Analytics
Connect to real-time SQL Server data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for SQL Server.
-
Connect to Oracle Service Cloud Data in Google Apps Script via Connect AI
Use CData Connect AI to access Oracle Service Cloud data in Google Apps Script.
-
Query Live Google Contacts 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 Google Contacts data directly from the development environment.
-
Build Dashboards with Samanage Data in DBxtra
Create dynamic dashboards and perform analytics based on Samanage data in DBxtra.
-
Build AI/ML Models with Live Dotmailer Data using Dataiku
Connect Dotmailer Data with Dataiku using the CData API Driver for JDBC.
-
How to connect Amazon QuickSight to Adobe Experience Manager Data
Create a connection to Adobe Experience Manager data in CData Connect AI and insert Adobe Experience Manager data into Amazon QuickSight SPICE to build interactive dashboards.
-
Automated Continuous Basecamp Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Basecamp replication to Amazon Redshift.
-
Build an OLAP Cube in SSAS from Timely Data
Establish a connection to Timely data data from SQL Server Analysis Services, and use the Timely Data Provider to build OLAP cubes for use in analytics and reporting.
-
Getting Started with the CData JDBC Driver for Paylocity
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Paylocity.
-
Getting Started with the CData ODBC Driver for SAP Netweaver Gateway
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for SAP Netweaver Gateway.
-
Extract, Transform, and Load NASA Data in Informatica PowerCenter
Create a simple Workflow for NASA data in Informatica PowerCenter.
-
Build Sugar CRM-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Sugar CRM data and build Sugar CRM-connected web apps with Axios.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Gumroad
Provide connectivity to Gumroad data through an SAP BusinessObjects universe.
-
Build a PostgreSQL Interface for Mocean Data using the CData JDBC Driver
Use the Remoting features of the Mocean JDBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to Beeminder Data from a Connection Pool in JBoss
Integrate Beeminder data into Java servlets: Use the Management Console in JBoss to install the Beeminder JDBC Driver.
-
Automate HubSpot Data Replication to SAP HANA
Use CData Sync to customize and automate HubSpot data replication to SAP HANA.
-
Build Agents in Relevance AI with Access to Live Attio Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Attio data within intelligent agent workflows.
-
Integrating Boomi Agentstudio with Adobe Commerce Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Adobe Commerce data, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Publish Salesforce-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Salesforce data.
-
Connect to Box Data in Ruby
Connect to Box data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Use the CData Software JDBC Driver for Webex in MicroStrategy Desktop
Connect to Webex data in MicroStrategy Desktop using the CData Software JDBC Driver for Webex.
-
Connect and Visualize Live Pipedrive Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Pipedrive data into the Databricks platform and create visualization dashboards with real-time Pipedrive data.
-
Build Apps with Live Keap Data Using the Low-Code Development Platform of Mendix
Connect Keap data with Mendix to build apps using the CData API Driver for JDBC.
-
Build NetSuite Visualizations in Tableau Desktop
Use CData Connect AI to connect to live NetSuite data and build visualizations in Tableau.
-
Connect to SAP Netweaver Gateway Data in RapidMiner
Integrate SAP Netweaver Gateway data with standard components and data source configuration wizards in RapidMiner Studio.
-
Integrating Antigravity CLI with Todoist data via CData CLI
Connect Todoist data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Automated Continuous MariaDB Replication to IBM DB2
Use CData Sync for automated, continuous, customizable MariaDB replication to IBM DB2.
-
Use the CData Software JDBC Driver for Elorus in MicroStrategy Desktop
Connect to Elorus data in MicroStrategy Desktop using the CData Software JDBC Driver for Elorus.
-
View Reports on Real-Time REST Data in Power BI Report Server
Use the CData ODBC Driver for REST to visualize REST data in Power BI Desktop and then publish them to Power BI Report Server.
-
Access Live Cassandra Data in Excel 365 Online (Excel for the web)
Connect to Cassandra data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Publish VWO-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live VWO data.
-
Import Oracle Financials Cloud Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Oracle Financials Cloud Data and provide access to live Oracle Financials Cloud data for custom reports in the Power BI Service.
-
Connect to Salesforce Data in RapidMiner
Integrate Salesforce data with standard components and data source configuration wizards in RapidMiner Studio.
-
Use the CData Software JDBC Driver for Wistia in MicroStrategy Web
Connect to Wistia data in MicroStrategy Web using the CData Software JDBC Driver for Wistia.
-
Connect to Avro Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Avro data using standard SQL.
-
Build Dashboards with Greenhouse Data in Dundas BI
Create dynamic dashboards and perform analytics based on Greenhouse data in Dundas BI.
-
Connect to and Visualize Live Auth0 Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Auth0 data.
-
Connect to ConvertAPI from Asprova with CData Software ODBC Driver for ConvertAPI
This article shows how to connect faster to ConvertAPI data from Asprova.
-
Automated Continuous SuiteCRM Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable SuiteCRM replication to Apache Cassandra.
-
Design BIRT Reports on EmailOctopus Data
Provide current EmailOctopus data to your embedded analytics.
-
Validate Clio Data with QuerySurge
Access and validate Clio data in QuerySurge using the CData JDBC Driver.
-
Rapidly Develop Insightly-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 Insightly.
-
Build Spark-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Spark data.
-
Connect to Parquet Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Parquet data in the Denodo Virtual DataPort Administrator.
-
Import and Visualize Wistia Data in Power View
Create data visualizations based on Wistia data in Excel.
-
Configure the CData JDBC Driver for Oracle HCM Cloud in a Connection Pool in Tomcat
Connect to Oracle HCM Cloud data from a connection pool in Tomcat.
-
Process & Analyze Pinecone Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Pinecone Data.
-
Integrate Perplexity with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Perplexity with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Perplexity data.
-
Publish 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.
-
Connect to SendGrid Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for SendGrid and the SQL Gateway to access SendGrid data from Google Apps Script.
-
Integrate Devin with Live QuickBooks 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 QuickBooks data.
-
Connect to ClickTime from a Connection Pool in WebLogic
Use the CData JDBC Driver for ClickTime to connect to ClickTime data from Web applications running on WebLogic.
-
Visualize GitHub Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to GitHub data.
-
Create Informatica Mappings From/To an ODBC Data Source for Salesloft
Create an ODBC connection to Salesloft in Informatica and browse and transfer Salesloft data.
-
Use the CData Software ODBC Driver for XML in MicroStrategy Web
Connect to XML data in MicroStrategy Web using the CData Software ODBC Driver for XML.
-
How to connect and process Wrike data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Wrike data.
-
Access Live Google Drive Data in Coginiti Pro
Connect to and query live Google Drive data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
How to Visualize Sage Cloud Accounting 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 Sage Cloud Accounting data in Python.
-
How to Connect to Live Mailgun Data from crewAI Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable crewAI agents to securely read and take actions on your Mailgun data for you.
-
Build Charts with Odoo Data in Clear Analytics
Create dynamic charts and perform analytics based on Odoo data in Clear Analytics.
-
Automated Continuous iContact Replication to Oracle
Use CData Sync for automated, continuous, customizable iContact replication to Oracle.
-
Build MVC Applications with Connectivity to Dynamics NAV Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Dynamics NAV from an ASP.NET MVC application.
-
How to Access Live Avaza Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Avaza enables you to integrate Avaza data into workflows built using Microsoft Power Automate Desktop.
-
Creating Timely-Connected Applications in Unqork
You can use CData Connect AI to feed Timely data to Unqork and build custom business apps.
-
Design BIRT Reports on CloudConvert Data
Provide current CloudConvert data to your embedded analytics.