CData Software - Knowledge Base
Recent Articles
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live NetSuite SuiteAnalytics within intelligent workflows.
-
Connect to Hugging Face Data from a Connection Pool in Jetty
The Hugging Face JDBC Driver supports connection pooling: This article shows how to connect faster to Hugging Face from Web apps in Jetty.
-
Query Sybase Data from Node.js
Use the OData endpoint of the CData API Server to connect to your Sybase and perform CRUD operations on Sybase from Node.js.
-
Using the CData Software ODBC Driver for Gong in PyCharm
Connect to Gong as an ODBC data source in PyCharm using the CData Software ODBC Driver for Gong.
-
Access xBase 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 xBase.
-
Publish Crystal Reports on Quaderno Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Quaderno.
-
Publish Crystal Reports on SQL Analysis Services Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date SQL Analysis Services.
-
How to connect and process Google Translate from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Google Translate.
-
Create Dynamic Paymo Grids Using the Infragistics XamDataGrid
Learn how you can connect Paymo to Infragistics XamDataGrid to build dynamic grids.
-
Build a PostgreSQL Interface for Cosmos DB Data using the CData JDBC Driver
Use the Remoting features of the Cosmos DB JDBC Driver to create a PostgreSQL entry-point for data access.
-
Build Dashboards with Quickbase Data in DBxtra
Create dynamic dashboards and perform analytics based on Quickbase in DBxtra.
-
Getting Started with the CData SSIS Components for Sage Cloud Accounting
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Sage Cloud Accounting.
-
Connect to Zoho CRM Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Zoho CRM and the SQL Gateway to access Zoho CRM from Google Apps Script.
-
Access Live Marketo Data in AWS Lambda
Connect to live Marketo in AWS Lambda using the CData JDBC Driver.
-
Write a Simple Go Application to work with NASA Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to NASA.
-
Create Data Visualizations in Cognos BI with ZohoPeople Data
Access ZohoPeople as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Replicate SharePoint Excel Services Data to Multiple Databases
Replicate SharePoint Excel Services to disparate databases with a point-and-click configuration.
-
Use Biml to Build SSIS Tasks to Replicate Jodoo Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Jodoo to SQL Server.
-
How to create Landbot federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Landbot in MySQL .
-
Getting Started with the CData JDBC Driver for QuickBooks Online
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for QuickBooks Online.
-
Build Visualizations of SAP BusinessObjects BI Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of SAP BusinessObjects BI in Birst.
-
Visualize Paddle Data in Sisense
Create an ElastiCube in Sisense app with access to Paddle.
-
Deploy the ADO.NET Provider for Confluence on an SSRS Report Server
Connect to Atlassian Confluence 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.
-
Natively Connect to Attio Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Attio. Leverage the native support for ODBC in PHP.
-
Use Microsoft Copilot Studio to talk to your Blackbaud FE NXT Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Microsoft Copilot Studio to securely answer questions and take actions on your Blackbaud FE NXT for you.
-
Analyze JobNimbus Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze JobNimbus with the CData JDBC Driver for JobNimbus.
-
A PostgreSQL Interface for Zendesk Data (MySQL Remoting via JDBC)
Use the Remoting features of the Zendesk JDBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to Couchbase Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Couchbase from Filemaker Pro on Mac.
-
How to connect Amazon QuickSight to SurveyMonkey Data
Create a connection to SurveyMonkey in CData Connect AI and insert SurveyMonkey into Amazon QuickSight SPICE to build interactive dashboards.
-
How to Create Power BI Visual Reports with Real-Time Yelp Data
Use CData Power BI Connectors to visualize Yelp in Power BI.
-
Connect to Miro Data from a Connection Pool in JBoss
Integrate Miro into Java servlets: Use the Management Console in JBoss to install the Miro JDBC Driver.
-
Operational Reporting on Cassandra Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Apache Cassandra.
-
DataBind Charts to HCL Domino Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to HCL Domino from controls in the Visual Studio toolbox. This article demonstrates a graphical approach using wizards in Visual Studio, as well as how to databind with only a few lines of code.
-
Model SAP ByDesign Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and SAP ByDesign, enabling the direct import of real-time SAP Business ByDesign.
-
How to Easily Query Salesforce Data in OpenOffice Base
Connect to Salesforce data in OpenOffice Base using the CData ODBC Driver for Salesforce and generate reports with live data insights.
-
Use Databricks Agent Bricks to Talk to Your Salesforce CRM Analytics Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Salesforce CRM Analytics for you.
-
How to connect and process Clockify from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Clockify.
-
Integrate Humanity with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Humanity with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Humanity.
-
Build an OLAP Cube in SSAS from SurveyMonkey Data
Establish a connection to SurveyMonkey data from SQL Server Analysis Services, and use the SurveyMonkey Data Provider to build OLAP cubes for use in analytics and reporting.
-
Connect to Freshdesk Data from a Connection Pool in JBoss
Integrate Freshdesk into Java servlets: Use the Management Console in JBoss to install the Freshdesk JDBC Driver.
-
Access Eventbrite Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Eventbrite from HeidiSQL.
-
Connect to Mouseflow Data in HULFT Integrate
Connect to Mouseflow as a JDBC data source in HULFT Integrate
-
Integrating LangChain with Couchbase Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Couchbase within automated workflows.
-
Extract, Transform, and Load Nethunt Data in Informatica PowerCenter
Create a simple Workflow for Nethunt in Informatica PowerCenter.
-
Integrate Bitly Data in the Pentaho Report Designer
Publish reports based on Bitly in the Pentaho BI tool.
-
How to Connect to Live MySQL Data from Gemini CLI (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Gemini CLI to securely read and take actions on your MySQL for you.
-
Query SAP Fieldglass Data through ODBC in Node.js
Use node-odbc to execute SQL queries against SAP Fieldglass from Node.js.
-
DataBind Controls to CouchDB Data in C++Builder
DataBind to Apache CouchDB in C++Builder with standard components and controls.
-
Object-Relational Mapping (ORM) with Anaplan 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 Anaplan into a Java-based ORM framework, Hibernate.
-
Import ClickUp Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access ClickUp. In this article, you will use the OData format to import ClickUp into Microsoft Power Query.
-
Automated Continuous AlloyDB Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable AlloyDB replication to PostgreSQL.
-
Building Dynamic Web Pages with Presto Data Using AngularJS
Create single-page applications with live connectivity to Presto using the CData API Server.
-
Publish Reports with HubDB Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date HubDB.
-
Build Pipelines with Live MYOB AccountRight Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to MYOB AccountRight from Google Cloud Data Fusion, enabling the integration of live MYOB AccountRight into the building and management of effective data pipelines.
-
Use the CData Software ODBC Driver for Office 365 in MicroStrategy
Connect to Microsoft Office 365 in MicroStrategy Developer using the CData Software ODBC Driver for Office 365.
-
Extend Google Sheets with ActiveCampaign Data
Make calls to ActiveCampaign from Google Apps Script via the API Server.
-
Build JotForm-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData API Driver for MCP Server to explore live JotForm Data in GitHub Copilot to assist with building JotForm-powered applications.
-
How to Work with Pinterest Data in ETL Validator JDBC
Connect to Pinterest from ETL Validator jobs using the CData Software JDBC Driver.
-
Access Zuora Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Zuora from your Oracle system.
-
Access Hive 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 Apache Hive.
-
Build LinkedIn Ads-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live LinkedIn Ads and build LinkedIn Ads-connected web apps with Axios.
-
Connect to VWO Data as an External Source in Dremio
Use the CData JDBC Driver to connect to VWO as an External Source in Dremio.
-
Excel Spreadsheet Automation on Flowlu Data with the QUERY Formula
Pull data from Flowlu, automate spreadsheets, and more with the QUERY formula.
-
Connect to Zoho CRM Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Zoho CRM.
-
DataBind Controls to Snapchat Ads Data in C++Builder
DataBind to Snapchat Ads in C++Builder with standard components and controls.
-
Prepare, Blend, and Analyze Certinia Data in Alteryx Designer (Connect AI)
Build workflows to access live Certinia for self-service data analytics.
-
Automate Attio Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live Attio and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
Connect to NetSuite SuiteAnalytics Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with NetSuite SuiteAnalytics Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Connect to Bitbucket Data from PowerBuilder via ADO.NET
This article demonstrates how to access Bitbucket from Appeon PowerBuilder using the CData ADO.NET Provider for Bitbucket.
-
How to connect to Supabase Data in DBVisualizer
Integrate Supabase with visual data analysis tools and data connection wizards in DBVisualizer
-
Access Live Databricks Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live Databricks data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Oracle SCM within intelligent workflows.
-
DataBind Controls to Trello Data in C++Builder
DataBind to Trello in C++Builder with standard components and controls.
-
Write a Simple Go Application to work with Discourse Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Discourse.
-
Integrate Theia IDE with Live Monday.com Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE
-
Bind Live Miro Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Miro data
-
Connect to Salesforce Data 360 Data in Ruby
Connect to Salesforce Data 360 in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
How to Connect to Live Dynamics 365 Business Central 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 Dynamics 365 Business Central for you.
-
Connect to Parquet Data in DBeaver
Use the CData ODBC Driver to connect to Apache Parquet in DBeaver.
-
Establish a Live Connection with FormSite Data using Tableau Bridge
The CData ODBC Driver for FormSite enables you to integrate live FormSite into Tableau Cloud dashboards using the Tableau Bridge.
-
Write a Simple Go Application to work with Microsoft Teams Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Microsoft Teams.
-
Build Automated Facebook Ads-Connected Workflows in Zapier
Use CData Connect AI to connect to live Facebook Ads and build automated workflows in Zapier.
-
Use Biml to Build SSIS Tasks to Replicate Google Ad Manager Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Google Ad Manager to SQL Server.
-
Access Live GraphQL Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live GraphQL from your Google Sheets.
-
Use ChatGPT to Talk to Your Bullhorn CRM 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 Bullhorn CRM for you.
-
Integrate Slack Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Slack from Informatica Cloud.
-
Connect to Monday.com from Asprova with CData Software ODBC Driver for Monday.com
This article shows how to connect faster to Monday.com data from Asprova.
-
Connect to QuickBooks from a Connection Pool in WebLogic
Use the CData JDBC Driver for QuickBooks to connect to QuickBooks Desktop from Web applications running on WebLogic.
-
Integrating Gumloop with Zoho Creator Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Zoho Creator within automated workflows.
-
Getting Started with the CData SSIS Components for ZohoPeople
Complete guide to installing, licensing, and connecting with the CData SSIS Components for ZohoPeople.
-
Publish Teamwork-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Teamwork.
-
Access Teamwork Data from MySQL in Amazon QuickSight
Connect to Teamwork and build visualizations of Teamwork using a MySQL Connection in Amazon QuickSight.
-
Import WordPress Data Using Azure Data Factory
Use CData Connect AI to connect to WordPress Data from Azure Data Factory and import live WordPress.
-
LINQ to JobNimbus Data
LINQ offers versatile querying capabilities within the .NET Framework (v3.0+), offering a straightforward method for programmatic data access through CData ADO.NET Data Providers. In this article, we demonstrate the use of LINQ to retrieve information from the JobNimbus Data Provider.
-
Publish SAP Fieldglass-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live SAP Fieldglass.
-
Automated Continuous Outreach.io Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Outreach.io replication to Azure SQL Database.
-
Load Microsoft Entra ID Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Microsoft Entra ID to a database.
-
Build Automated Workflows with Live ADP Data in Workato
Use CData Connect AI to connect to live ADP and build automated workflows in Workato.
-
How to Connect to & Open SuiteCRM Data in Microsoft Excel
This article uses the CData ODBC driver for SuiteCRM to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Access Live Aircall Data in TIBCO Data Virtualization
Use the CData API Driver for Tibco DV to create a Aircall data source in TIBCO Data Virtualization Studio and gain access to live Aircall from your TDV Server.