CData Software - Knowledge Base
Recent Articles
-
Analyze QuickBooks Online Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze QuickBooks Online with the CData JDBC Driver for QuickBooks Online.
-
Integrate Attio Data in the Pentaho Report Designer
Publish reports based on Attio in the Pentaho BI tool.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live SAP HANA within intelligent workflows.
-
Create Informatica Mappings From/To an ODBC Data Source for MarkLogic
Create an ODBC connection to MarkLogic in Informatica and browse and transfer MarkLogic.
-
Integrate LibreChat with Live Zoho Creator Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Zoho Creator from within the chat interface.
-
Access Live Zendesk Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Zendesk into the statistical analysis tools available in SAS JMP. This article shows how to use Zendesk in the Graph Builder and Query Builder.
-
Access Live Sage Intacct Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Sage Intacct in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Integrating Dataiku with Sybase IQ Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Sybase IQ.
-
Access Customer.io Data from MySQL in Amazon QuickSight
Connect to Customer.io and build visualizations of Customer.io using a MySQL Connection in Amazon QuickSight.
-
Deploy the ADO.NET Provider for Retently on an SSRS Report Server
Connect to Retently from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.
-
Model, Search, and Visualize Live HBase Data in ThoughtSpot
Use CData Connect AI to connect to live Apache HBase for modeling, searching, and visualizing.
-
Create Reports with Blackbaud FE NXT Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Blackbaud FE NXT.
-
Connecting Pipedream with Elasticsearch 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 Elasticsearch data in real time.
-
Integrate Cline with Live Twilio Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Twilio from within your IDE.
-
Connect to ActiveCampaign Data in DBArtisan
Use wizards in DBArtisan to configure ActiveCampaign as a data source.
-
Bridge Shippo Connectivity with Apache NiFi
Access and process Shippo in Apache NiFi using the CData JDBC Driver.
-
Configure the CData JDBC Driver for Toggl in a Connection Pool in Tomcat
Connect to Toggl from a connection pool in Tomcat.
-
Write a Simple Go Application to work with Cvent Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Cvent.
-
Automated GitHub Data Replication to Teradata
Use CData Sync to Customize and automate GitHub replication to Teradata.
-
Automated Continuous Humanity Replication to MySQL
Use CData Sync for automated, continuous, customizable Humanity replication to MySQL.
-
Connect to Jira Assets Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Jira Assets and the Script function in FileMaker Pro to connect to Jira Assets and work with Jira Assets in your FileMaker application.
-
Build GitLab-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live GitLab and build GitLab-connected web apps with Axios.
-
Build an OLAP Cube in SSAS from Airtable Data
Establish a connection to Airtable data from SQL Server Analysis Services, and use the Airtable Data Provider to build OLAP cubes for use in analytics and reporting.
-
Automated Continuous ZarMoney Replication to Vertica
Use CData Sync for automated, continuous, customizable ZarMoney replication to Vertica.
-
Visualize ScrapingBee Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to ScrapingBee.
-
Integrate Live Qualaroo Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Qualaroo to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Automated Continuous Bannerbear Replication to SQL Server
Use CData Sync for automated, continuous, customizable Bannerbear replication to SQL Server.
-
Connect to SAP Business Warehouse Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for SAP Business Warehouse in the Denodo Virtual DataPort Administrator.
-
Publish Crystal Reports on Webex Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Webex.
-
Getting Started with the CData ADO.NET Provider for OnePageCrm
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Access Sentry Data from MySQL in Amazon QuickSight
Connect to Sentry and build visualizations of Sentry using a MySQL Connection in Amazon QuickSight.
-
Integrate LibreChat with Live ADP Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live ADP from within the chat interface.
-
Build AI/ML Models with Live Everhour Data using Dataiku
Connect Everhour Data with Dataiku using the CData API Driver for JDBC.
-
Integrating OpenCode Terminal with Paddle 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.
-
Replicate Exa Data in Heroku for Use in Salesforce Connect
Replicate Exa to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Add ZarMoney Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for ZarMoney with the Informatica Enterprise Data Catalog to classify and organize data.
-
Automated Continuous Bullhorn CRM Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Bullhorn CRM replication to Amazon S3.
-
ServiceDesk Plus Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on ServiceDesk Plus facts in real time.
-
Visualize PDFMonkey Data in TIBCO Spotfire through ADO.NET
Integrate PDFMonkey into dashboards in TIBCO Spotfire.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Google Search within intelligent workflows.
-
Build LionDesk-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live LionDesk.
-
Connect Salesforce CRM Analytics to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Salesforce CRM Analytics using the CData Python MCP Server.
-
How to Connect to Live Dynamics 365 Business Central Data from Google ADK Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Google ADK agents to securely read and take actions on your Dynamics 365 Business Central for you.
-
Connect Printful to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Printful using the CData Python MCP Server.
-
Build Lakebase-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData MCP Server for Lakebase to explore live Lakebase Data in GitHub Copilot to assist with building Lakebase-powered applications.
-
Connect to NetSuite SuiteAnalytics Data in ACL Analytics
Connect to NetSuite SuiteAnalytics via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to NetSuite SuiteAnalytics.
-
Create NetSuite Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time NetSuite data access from reports, embedded analytics, and more.
-
Access Live Oracle Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Oracle Database from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
How to connect to HelloSign Data from IntelliJ
Integrate connectivity to HelloSign with wizards in IntelliJ.
-
How to connect to Xero Data from IntelliJ
Integrate connectivity to Xero Accounting with wizards in IntelliJ.
-
Build a Simple VCL Application for Presto Data
How to build a simple VCL Application to view Presto in RAD Studio using the CData ODBC Driver for Presto.
-
Connect to CloudConvert Data in HULFT Integrate
Connect to CloudConvert as a JDBC data source in HULFT Integrate
-
How to connect to Grafana Data from Spring Boot
Connect to Grafana in a Spring Boot Application using the CData API Driver for JDBC
-
Create Informatica Mappings From/To a JDBC Data Source for Vault CRM
Create Vault CRM data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Connect to Google Cloud Storage from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Google Cloud Storage, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Prepare, Blend, and Analyze Kintone Data in Alteryx Designer (ODBC)
Build workflows to access live Kintone for self-service data analytics.
-
Connect ADP to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live ADP using the CData Python MCP Server.
-
Consume ADP OData Feeds in PowerBuilder
This article demonstrates how to consume ADP as OData feeds from PowerBuilder using the API Server.
-
Integrating GitHub Copilot CLI with Egnyte 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.
-
Automated Continuous Bullhorn CRM Replication to Oracle
Use CData Sync for automated, continuous, customizable Bullhorn CRM replication to Oracle.
-
Integrate with Teradata Data in JReport Designer
Create charts and reports based on Teradata in JReport Designer.
-
Query Figshare Data as a MySQL Database in Node.js
Execute MySQL queries against Figshare from Node.js.
-
Connect to GraphQL Data from a Connection Pool in JBoss
Integrate GraphQL into Java servlets: Use the Management Console in JBoss to install the GraphQL JDBC Driver.
-
Edit and Search Greenplum External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of Pivotal GreenPlum to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create Greenplum objects that you can access from apps and the dashboard.
-
Connect to GitLab Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with GitLab Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
How to Easily Query Google Calendar Data in OpenOffice Base
Connect to Google Calendar data in OpenOffice Base using the CData ODBC Driver for Google Calendar and generate reports with live data insights.
-
Query Azure DevOps Data in DataGrip
Create a Data Source for Azure DevOps in DataGrip and use SQL to query live Azure DevOps.
-
Getting Started with the CData JDBC Driver for Google Calendar
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Google Calendar.
-
Replicate RSS Feeds from PowerShell
Write a quick PowerShell script to query RSS Feeds. Use connectivity to the live data to replicate RSS Feeds to SQL Server.
-
A PostgreSQL Interface for Gmail Data (MySQL Remoting via JDBC)
Use the Remoting features of the Gmail JDBC Driver to create a PostgreSQL entry-point for data access.
-
Getting Started with the CData ADO.NET Provider for Drip
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
How to Connect to Live Google Directory Data from Google ADK Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Google ADK agents to securely read and take actions on your Google Directory for you.
-
How to Connect to Live SAP ByDesign Data from Google ADK Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Google ADK agents to securely read and take actions on your SAP Business ByDesign for you.
-
Replicate Zuora Data from PowerShell
Write a quick PowerShell script to query Zuora. Use connectivity to the live data to replicate Zuora to SQL Server.
-
Use the CData Software ODBC Driver for SAP Business Warehouse in MicroStrategy Desktop
Connect to SAP Business Warehouse in MicroStrategy Desktop using the CData Software ODBC Driver for SAP Business Warehouse.
-
Create Informatica Mappings From/To an ODBC Data Source for Notion
Create an ODBC connection to Notion in Informatica and browse and transfer Notion.
-
Use the CData Software JDBC Driver for Mode in MicroStrategy
Connect to Mode in MicroStrategy Developer using the CData Software JDBC Driver for Mode.
-
Create a Data Access Object for PagerDuty Data using JDBI
A brief overview of creating a SQL Object API for PagerDuty in JDBI.
-
Integrate Live MarkLogic Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to MarkLogic from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live MarkLogic.
-
DataBind Controls to SuiteCRM Data in C++Builder
DataBind to SuiteCRM in C++Builder with standard components and controls.
-
Provide OData Services of Zoho Inventory Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Zoho Inventory by developing a WCF Service Application.
-
Query Datadog Data in DataGrip
Create a Data Source for Datadog in DataGrip and use SQL to query live Datadog.
-
Printify Reporting in OBIEE with the Printify JDBC Driver
Deploy the Printify JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
How to Query Live Twitter Ads Data in Perplexity MacOS Desktop
Connect to and query live Twitter Ads Data in Perplexity Desktop using CData MCP Server.
-
Build Visualizations of EmailOctopus Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of EmailOctopus in Birst.
-
Connect to Adobe Analytics Data from PowerBuilder via ADO.NET
This article demonstrates how to access Adobe Analytics from Appeon PowerBuilder using the CData ADO.NET Provider for Adobe Analytics.
-
Integrating Templated Data in Talend Cloud Data Management Platform
Connect Templated Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
How to Import Data from Avalara AvaTax into Google Sheets
Import Avalara AvaTax into a Google spreadsheet that is automatically refreshed.
-
Access PagerDuty Data from MySQL in Amazon QuickSight
Connect to PagerDuty and build visualizations of PagerDuty using a MySQL Connection in Amazon QuickSight.
-
Create Square-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Square Data from Klipfolio and build custom visualizations using live Square.
-
Automate SAP HANA Data Replication to Azure Synapse
Use CData Sync to customize and automate SAP HANA replication to Azure Synapse.
-
A PostgreSQL Interface for Foursquare Data using the CData ODBC Driver
Use the SQL Gateway and Foursquare ODBC Driver to create a PostgreSQL entry-point for data access.
-
A PostgreSQL Interface for Foursquare Data (MySQL Remoting via JDBC)
Use the Remoting features of the Foursquare JDBC Driver to create a PostgreSQL entry-point for data access.
-
Integrating LangChain with Dropbox Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Dropbox within automated workflows.
-
Connect to Perplexity Data Using the Script Function in Claris FileMaker Pro
Use the CData API Driver for ODBC and the Script function in FileMaker Pro to connect to Perplexity and work with Perplexity in your FileMaker application.
-
How to connect to Azure Synapse Data with Squirrel SQL client
Connect to Azure Synapse and execute queries in the Squirrel SQL Client.
-
ETL Supabase in Oracle Data Integrator
This article shows how to transfer Supabase into a data warehouse using Oracle Data Integrator.
-
Extract, Transform, and Load Timely Data in Informatica PowerCenter
Create a simple Workflow for Timely in Informatica PowerCenter.
-
Integrate Google Contacts Data in Pentaho Data Integration
Build ETL pipelines based on Google Contacts in the Pentaho Data Integration tool.
-
Connect to Live IBM Informix Data in PostGresSQL Interface through CData Connect AI
Create a live connection to IBM Informix in CData Connect AI and connect to your IBM Informix from PostgreSQL.