CData Software - Knowledge Base
Recent Articles
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Avalara AvaTax using the Model Context Protocol.
-
Integrating LangChain with Sage Intacct Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Sage Intacct within automated workflows.
-
Integrate Pipeliner CRM with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Pipeliner CRM with External Services.
-
Use the CData ODBC Driver for SendInBlue in Microsoft Power Query
You can use the CData SendInBlue ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import SendInBlue into Microsoft Power Query.
-
Automated Continuous Marketo Replication to SQLite
Use CData Sync for automated, continuous, customizable Marketo replication to SQLite.
-
Integrate ServiceNow Data into Power Automate Desktop using CData Connect
CData Connect for ServiceNow Data enables you to integrate ServiceNow into workflows built using Microsoft Power Automate Desktop.
-
Use the CData Software JDBC Driver for Perplexity in MicroStrategy Desktop
Connect to Perplexity in MicroStrategy Desktop using the CData Software JDBC Driver for Perplexity.
-
Connect to Brex Data in HULFT Integrate
Connect to Brex as a JDBC data source in HULFT Integrate
-
Use the CData Software JDBC Driver for PayPal in MicroStrategy Desktop
Connect to PayPal in MicroStrategy Desktop using the CData Software JDBC Driver for PayPal.
-
Connect to Invoiced Data in Aqua Data Studio
Access Invoiced from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Access Live Google Directory Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Google Directory from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Query ShipStation Data as a SQL Server Database in Node.js
Execute SQL Server queries against ShipStation from Node.js.
-
Build AI/ML Models with Live Bannerbear Data using Dataiku
Connect Bannerbear Data with Dataiku using the CData API Driver for JDBC.
-
Build Data Flows from Pipeliner CRM to SQL Server using SSIS
Easily back up Pipeliner CRM to SQL Server using the SSIS components for Pipeliner CRM.
-
Use the CData Software ODBC Driver for Salesloft in SAS for Real-Time Reporting and Analytics
Connect to real-time Salesloft in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Salesloft.
-
Working with Calendly Data in LINQPad
Execute LINQ queries to Calendly in LINQPad.
-
How to Access Live Greenhouse Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Greenhouse enables you to integrate Greenhouse into workflows built using Microsoft Power Automate Desktop.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed IBM DB2 to Power BI dashboards. Simply drag and drop IBM DB2 into data visuals on the Power BI canvas.
-
Working with Billsby Data in LINQPad
Execute LINQ queries to Billsby in LINQPad.
-
Connecting Pipedream with Avalara AvaTax Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Pipedream workflows to securely read and take actions on Avalara AvaTax data in real time.
-
Use the CData Software ODBC Driver for SAP HANA XS Advanced in SAS for Real-Time Reporting and Analytics
Connect to real-time SAP HANA XS Advanced in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for SAP HANA XS Advanced.
-
Create Datasets from HCL Domino in Domo Workbench and Build Visualizations of HCL Domino Data in Domo
Use the CData Software ODBC Driver for HCL Domino to create datasets from HCL Domino in Domo Workbench and then build visualizations in the Domo service.
-
Connect to and Query Live Salesforce Data in QlikView (vina ODBC)
Create data visualizations with Salesforce data in QlikView.
-
Connect to OData Services in NetBeans
Connect to OData in NetBeans with the data source configuration wizard.
-
Connect to Float Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Float using standard SQL.
-
Automated Continuous Amplitude Replication to Databricks
Use CData Sync for automated, continuous, customizable Amplitude replication to Databricks.
-
Build Workday-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Workday Data and create custom apps in Bubble.
-
Build Avalara AvaTax-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Avalara AvaTax Data and create custom apps in Mendix.
-
Automated Continuous Delighted Replication to Vertica
Use CData Sync for automated, continuous, customizable Delighted replication to Vertica.
-
Access Live MongoDB Data in AWS Lambda
Connect to live MongoDB in AWS Lambda using the CData JDBC Driver.
-
How to connect Amazon QuickSight to Quickbase Data
Create a connection to Quickbase in CData Connect AI and insert Quickbase into Amazon QuickSight SPICE to build interactive dashboards.
-
Query Front Data in DataGrip
Create a Data Source for Front in DataGrip and use SQL to query live Front.
-
Analyze Sage 200 Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Sage 200 and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Enable the Pipedrive JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Pipedrive.
-
Automated Continuous ShipStation Replication to SQL Server
Use CData Sync for automated, continuous, customizable ShipStation replication to SQL Server.
-
Automated Continuous ZohoExpense Replication to Amazon S3
Use CData Sync for automated, continuous, customizable ZohoExpense replication to Amazon S3.
-
Replicate Multiple Stack Exchange Accounts
Replicate multiple Stack Exchange accounts to one or many databases.
-
Analyze Cosmos DB Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Azure Cosmos DB with the CData JDBC Driver for Cosmos DB.
-
How to Connect to Live MariaDB Data from Claude Agent SDK (via CData Connect AI)
Leverage CData Connect AI to enable Claude Agent SDK applications to securely read and take actions on your MariaDB for you.
-
How to connect to Snapchat Ads Data in DBVisualizer
Integrate Snapchat Ads with visual data analysis tools and data connection wizards in DBVisualizer
-
Use CData Connect AI to Access Odoo Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Odoo ERP in the Power Pivot business intelligence tool.
-
Analyze Apollo Data in Looker
Use CData Connect AI to connect to Apollo Data from Looker and build custom apps using live Apollo.
-
Access Live Greenplum 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 Pivotal GreenPlum through MCP integration.
-
Import Confluence Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Confluence Data and provide access to live Atlassian Confluence for custom reports in the Power BI Service.
-
Create Informatica Mappings From/To a JDBC Data Source for Pipeliner CRM
Create Pipeliner CRM data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Build Semantic Layer Views for Notion Data in APOS Live Data Gateway
Use the CData Connector for Notion in APOS Live Data Gateway to build Semantic Layer Views for Notion.
-
Automated Continuous Zoho Inventory Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Zoho Inventory replication to Amazon Redshift.
-
Query Google Search Results in ColdFusion
Write standard ColdFusion data access code to connect to Google Search.
-
Analyze Sugar CRM Data in Infragistics Reveal
Use the CData API Server to create an OData API on top of Sugar CRM and visualize live Sugar CRM in Infragistics Reveal.
-
Integrating Paddle Data in Talend Cloud Data Management Platform
Connect Paddle Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Use the CData Software JDBC Driver for Dynamics 365 Business Central in MicroStrategy Desktop
Connect to Dynamics 365 Business Central in MicroStrategy Desktop using the CData Software JDBC Driver for Dynamics 365 Business Central.
-
Automated Continuous Act-On Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Act-On replication to PostgreSQL.
-
Use the CData Software JDBC Driver for JSON in MicroStrategy
Connect to JSON in MicroStrategy Developer using the CData Software JDBC Driver for JSON.
-
Visualize CouchDB Data in Tableau
The CData ODBC driver for CouchDB enables you integrate Apache CouchDB into Tableau dashboards.
-
Prepare, Blend, and Analyze Vertica Data in Alteryx Designer (Connect AI)
Build workflows to access live Vertica for self-service data analytics.
-
Import Quickbase Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Quickbase Data and provide access to live Quickbase for custom reports in the Power BI Service.
-
Analyze Asana Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Asana in Microsoft R Open.
-
Automated Continuous IBM Cloud Object Storage Replication to Databricks
Use CData Sync for automated, continuous, customizable IBM Cloud Object Storage replication to Databricks.
-
Operational Reporting on Presto Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Presto.
-
Extend Google Sheets with Trello Data
Make calls to Trello from Google Apps Script via the API Server.
-
Build Couchbase-Powered Applications in Claude Code with CData MCP Server
Use the CData MCP Server for Couchbase to explore live Couchbase Data in Claude Code to assist with building Couchbase-powered applications.
-
Access Live Office 365 Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Microsoft Office 365 into the statistical analysis tools available in SAS JMP. This article shows how to use Microsoft Office 365 in the Graph Builder and Query Builder.
-
Integrate with Live SAS xpt Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to SAS xpt from the MuleSoft Anypoint Platform to integrate live SAS XPORT into custom reports and dashboards.
-
Publish Reports with Outreach.io Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Outreach.io.
-
Create Power BI Reports on Real-Time Ontraport Data
Use the CData ODBC Driver for Ontraport to visualize Ontraport in Power BI Desktop.
-
Create a Data Access Object for Google Search Results using JDBI
A brief overview of creating a SQL Object API for Google Search in JDBI.
-
Replicate Multiple Typeform Accounts via the CData Sync CLI
Replicate multiple Typeform accounts to one or many databases.
-
How to update Splunk from Excel
This article explains how to transfer data from Excel to Splunk using the Excel Add-In for Splunk.
-
Connect to SAS xpt Data from a Connection Pool in JBoss
Integrate SAS XPORT into Java servlets: Use the Management Console in JBoss to install the SAS xpt JDBC Driver.
-
Visualize Drip Data in Sisense
Create an ElastiCube in Sisense app with access to Drip.
-
Analyze Freshdesk Data in Infragistics Reveal
Use the CData API Server to create an OData API on top of Freshdesk and visualize live Freshdesk in Infragistics Reveal.
-
Import Splunk Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Splunk Data and provide access to live Splunk for custom reports in the Power BI Service.
-
Connect to Live MYOB AccountRight Data in MicroStrategy through CData Connect AI
Create a live connection to MYOB AccountRight Data in CData Connect AI and connect to your MYOB AccountRight from MicroStrategy.
-
Access Live Highrise Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Highrise CRM into the statistical analysis tools available in SAS JMP. This article shows how to use Highrise CRM in the Graph Builder and Query Builder.
-
Use the CData Software ODBC Driver for Figshare in MicroStrategy
Connect to Figshare in MicroStrategy Developer using the CData Software ODBC Driver for Figshare.
-
How to Connect to Live Zoom Data from Claude Agent SDK (via CData Connect AI)
Leverage CData Connect AI to enable Claude Agent SDK applications to securely read and take actions on your Zoom for you.
-
Connect to LeadDesk Data from a Connection Pool in Jetty
The LeadDesk JDBC Driver supports connection pooling: This article shows how to connect faster to LeadDesk from Web apps in Jetty.
-
Automate Jira Assets Data Replication to Azure Data Lake
Use CData Sync to customize and automate Jira Assets replication to Azure Data Lake.
-
Feed Contentful Data into FineReport
How to set Contentful as a JDBC data source in FineReport.
-
Connect to Procore Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Procore in the Denodo Virtual DataPort Administrator.
-
Build MVC Applications with Connectivity to Clockify Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Clockify from an ASP.NET MVC application.
-
How to import ClickUp Data into Apache Solr
Use the CData Software JDBC Driver for ClickUp in Data Import Handler and create an automated import of ClickUp to Apache Solr Enterprise Search platform.
-
Visualize ElevenLabs Data in Tableau
The CData ODBC driver for ElevenLabs enables you integrate ElevenLabs into Tableau dashboards.
-
Access Live Email Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Email into the statistical analysis tools available in SAS JMP. This article shows how to use Email in the Graph Builder and Query Builder.
-
Import Zoho Projects Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Zoho Projects. In this article, you will use the OData format to import Zoho Projects into Microsoft Power Query.
-
Integrating OpenCode Terminal 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.
-
Build MVC Applications with Connectivity to Apify Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Apify from an ASP.NET MVC application.
-
Use the CData Software ODBC Driver for AdRoll in MicroStrategy Desktop
Connect to AdRoll in MicroStrategy Desktop using the CData Software ODBC Driver for AdRoll.
-
How to import Presto Data into Apache Solr
Use the CData Software JDBC Driver for Presto in Data Import Handler and create an automated import of Presto to Apache Solr Enterprise Search platform.
-
How to Connect to Live Vertica 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 Vertica for you.
-
Access Live Oracle Sales Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Oracle Sales into the statistical analysis tools available in SAS JMP. This article shows how to use Oracle Sales in the Graph Builder and Query Builder.
-
Automated Continuous Oracle SCM Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Oracle SCM replication to PostgreSQL.
-
How to Create Power BI Visual Reports with Real-Time Outlook Data
Use CData Power BI Connectors to visualize Outlook in Power BI.
-
Connect to TaxJar Data in NetBeans
Connect to TaxJar in NetBeans with the data source configuration wizard.
-
Create Reports with Gmail Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Gmail.
-
Build Epicor Kinetic-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Epicor Kinetic and build Epicor Kinetic-connected web apps with Axios.
-
Create Pipedrive-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Pipedrive Data from Klipfolio and build custom visualizations using live Pipedrive.
-
How to publish and share WooCommerce Data dashboards with Tableau Server
The CData ODBC driver for WooCommerce enables you integrate WooCommerce into Tableau dashboards.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Workable
Provide connectivity to Workable through an SAP BusinessObjects universe.
-
Integrate with JSON Services in SnapLogic
Use CData Connect AI to connect to and integrate with live JSON in SnapLogic.