CData Software - Knowledge Base
Recent Articles
-
How to connect and process Omnisend data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Omnisend data.
-
Connect to Nethunt Data from a Connection Pool in JBoss
Integrate Nethunt data into Java servlets: Use the Management Console in JBoss to install the Nethunt JDBC Driver.
-
Connect to Trello Data in NetBeans
Connect to Trello data in NetBeans with the data source configuration wizard.
-
Integrate Cline with Live SAP HANA Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live SAP HANA data from within your IDE.
-
Access Live Anaplan Data in AWS Lambda
Connect to live Anaplan data in AWS Lambda using the CData JDBC Driver.
-
Import and Visualize Discourse Data in Power View
Create data visualizations based on Discourse data in Excel.
-
Integrate Dify with Live Paymo 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 Paymo data.
-
Prepare, Blend, and Analyze SAS xpt Data in Alteryx Designer (ODBC)
Build workflows to access live SAS xpt data for self-service data analytics.
-
Integrate Live GitHub Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live GitHub data to Blue Prism using the CData ODBC Driver for GitHub to create automated workflows for repetitive business tasks.
-
Configure the CData JDBC Driver for Eventbrite in a Connection Pool in Tomcat
Connect to Eventbrite data from a connection pool in Tomcat.
-
How to Connect Omnisend 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 Omnisend data in real time using natural language.
-
Connect to and Query ConvertKit Data in QlikView over ODBC
Create data visualizations with ConvertKit data in QlikView.
-
Integrating Boomi Agentstudio with Google Forms Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Google Forms data, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Integrate Goose with Live SAP SuccessFactors Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live SAP SuccessFactors data from within the local AI agent.
-
Use JayDeBeApi to access Certinia Data in Python
Use standard Python scripting and the development environment of your choice to access live Certinia data.
-
Integrating OpenCode with Couchbase 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 Mode-Connected Nintex Workflows
Use CData Connect AI to connect to Mode Data from Nintex Workflow Cloud and build custom workflows using live Mode data.
-
Integrating LangChain with XML Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on XML data within automated workflows.
-
Connect to SuiteCRM Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for SuiteCRM and the Script function in FileMaker Pro to connect to SuiteCRM and work with SuiteCRM data in your FileMaker application.
-
DataBind Charts to Zoho Creator Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Zoho Creator data 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.
-
Build Data Flows from SAP Netweaver Gateway to SQL Server using SSIS
Easily back up SAP Netweaver Gateway data to SQL Server using the SSIS components for SAP Netweaver Gateway.
-
Connect to LinkedIn Ads Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for LinkedIn Ads to connect to LinkedIn Ads data and execute queries in PowerBuilder.
-
Connect to and Query Aha! Data in QlikView over ODBC
Create data visualizations with Aha! data in QlikView.
-
How to work with Factorial Data in Apache Spark using SQL
Access and process Factorial Data in Apache Spark using the CData Software JDBC Driver.
-
How to Connect to Live Kafka 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 Kafka data for you.
-
Connect Airtable Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Airtable data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
How to Connect the Power BI Service to AfterShip: Complete Guide
Connect to the CData Software Power BI Connector for AfterShip from PowerBI.com to provide real-time AfterShip data across the organization.
-
Build AI/ML Models with Live Avalara AvaTax Data using Dataiku
Connect Avalara AvaTax Data with Dataiku using the CData JDBC Driver for Avalara AvaTax.
-
Use the CData Software ODBC Driver for Mixpanel in MicroStrategy Desktop
Connect to Mixpanel data in MicroStrategy Desktop using the CData Software ODBC Driver for Mixpanel.
-
Model GetResponse Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and GetResponse, enabling the direct import of real-time GetResponse data.
-
ActiveCampaign Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on ActiveCampaign facts in real time.
-
Connect to ZohoSubscriptions Data from PowerBuilder via JDBC
This article demonstrates how to access ZohoSubscriptions data from PowerBuilder using the ZohoSubscriptions JDBC Driver.
-
Build Microsoft Exchange-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Microsoft Exchange data and build Microsoft Exchange-connected web apps with Axios.
-
Creating Typeform-Connected Applications in Unqork
You can use CData Connect AI to feed Typeform data to Unqork and build custom business apps.
-
Integrate Google's Antigravity Agent with Live AfterShip Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live AfterShip data using the Model Context Protocol.
-
Use the CData Software JDBC Driver for Clari in MicroStrategy Desktop
Connect to Clari data in MicroStrategy Desktop using the CData Software JDBC Driver for Clari.
-
Connect Snapchat Ads Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Snapchat Ads data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Replicate Lakebase Data from PowerShell
Write a quick PowerShell script to query Lakebase data. Use connectivity to the live data to replicate Lakebase data to SQL Server.
-
Build Semantic Layer Views for Zoho Books Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Zoho Books data.
-
Work with Live Power BI XMLA Data in Power Query
Use CData Connect AI to connect to Power BI XMLA data and work with live Power BI XMLA data in Microsoft Power Query.
-
Visualize HubSpot Data in TIBCO Spotfire through OData
Integrate HubSpot data into dashboards in TIBCO Spotfire.
-
Integrate Live Oracle HCM Cloud Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf's Cascade agent to securely access and query live Oracle HCM Cloud data from within the IDE.
-
How to import HubDB Data into Apache Solr
Use the CData Software JDBC Driver for HubDB in Data Import Handler and create an automated import of HubDB data to Apache Solr Enterprise Search platform.
-
Design BIRT Reports on Discourse Data
Provide current Discourse data to your embedded analytics.
-
Connect to PolarTeamPro Data from PowerBuilder via ADO.NET
This article demonstrates how to access PolarTeamPro data from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Connect to OData Services in HULFT Integrate
Connect to OData as a JDBC data source in HULFT Integrate
-
Integrate Google's Vertex AI Agent with Live Act-On Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Act-On data within intelligent workflows.
-
How to integrate Metabase with Salesforce Data 360 Data
Use CData Connect AI to connect to live Salesforce Data 360 data and create an interactive dashboard in Metabase from Salesforce Data 360 data.
-
How to Work with Workable Data in ETL Validator JDBC
Connect to Workable from ETL Validator jobs using the CData Software JDBC Driver.
-
Integrate with SAP Business Warehouse Data in JReport Designer
Create charts and reports based on SAP Business Warehouse data in JReport Designer.
-
Create Datasets from Greenplum in Domo Workbench and Build Visualizations of Greenplum Data in Domo
Use the CData Software ODBC Driver for Greenplum to create datasets from Greenplum data in Domo Workbench and then build visualizations in the Domo service.
-
Create Reports from Quickbase Data in Looker Studio
Use CData Connect AI to gain access to live Quickbase data and create custom reports in Looker Studio.
-
Build Apps with Live Toggl data in Adalo using CData Connect AI
Use CData Connect AI to integrate live Toggl data into the Adalo platform and build custom mobile and web applications with real-time Toggl data.
-
Getting Started with the CData JDBC Driver for SpaceX
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for SpaceX.
-
Replicate Gorgias Data to Multiple Databases
Replicate Gorgias data to disparate databases with a point-and-click configuration.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Keap
Provide connectivity to Keap data through an SAP BusinessObjects universe.
-
Connect to Marketo Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Marketo as an External Source in Dremio.
-
Integrate Live Hugging Face Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Hugging Face data to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Integrate Phoenix Data in the Pentaho Report Designer
Publish reports based on Phoenix data in the Pentaho BI tool.
-
Work with SAP Fieldglass Data in FoxPro
Load SAP Fieldglass data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Connect to Email Data from AWS Glue
Use CData Connect AI to gain access to live Email data from your AWS Glue jobs.
-
Visualize Live Coda Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Coda data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Enable the Exact Online JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Exact Online data.
-
Automated Continuous Helpscout Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Helpscout replication to IBM DB2.
-
Getting Started with the CData Tableau Connector for IBM Cloud Object Storage
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for IBM Cloud Object Storage.
-
Publish Crystal Reports on Teamwork Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Teamwork data.
-
Use the CData Software JDBC Driver for Microsoft OneDrive in MicroStrategy
Connect to Microsoft OneDrive data in MicroStrategy Developer using the CData Software JDBC Driver for Microsoft OneDrive.
-
Automated Continuous Parallel Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Parallel replication to Amazon Redshift.
-
Bridge Bright Data Connectivity with Apache NiFi
Access and process Bright Data data in Apache NiFi using the CData JDBC Driver.
-
Build Dashboards with AfterShip Data in Dundas BI
Create dynamic dashboards and perform analytics based on AfterShip data in Dundas BI.
-
Use Dash to Build Web Apps on Optimizely Data via CData Connect AI
Build interactive Dash web apps on live Optimizely data using pandas and the CData Connect AI Python SDK.
-
Integrate Google Contacts with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Google Contacts with External Services.
-
Create Dynamic Demio Grids Using the Infragistics XamDataGrid
Learn how you can connect Demio to Infragistics XamDataGrid to build dynamic grids.
-
Query Wrike Data in DataGrip
Create a Data Source for Wrike in DataGrip and use SQL to query live Wrike data.
-
Connect to and Visualize Live Facebook Ads Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Facebook Ads data.
-
Connect to SAS Data Sets Data from PowerBuilder via ADO.NET
This article demonstrates how to access SAS Data Sets data from Appeon PowerBuilder using the CData ADO.NET Provider for SAS Data Sets.
-
Build Agents in Relevance AI with Access to Live Adobe Experience Manager Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Adobe Experience Manager data within intelligent agent workflows.
-
How to Connect to Live HDFS 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 HDFS data for you.
-
Use Dash to Build to Web Apps on Acumatica Data
Create Python applications that use pandas and Dash to build Acumatica-connected web apps.
-
Build Box-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Box data and build web apps with connectivity to live Box data.
-
How to connect to Sugar CRM Data in DBVisualizer
Integrate Sugar CRM data with visual data analysis tools and data connection wizards in DBVisualizer
-
Connect to Flowlu from Asprova with CData Software ODBC Driver for Flowlu
This article shows how to connect faster to Flowlu data from Asprova.
-
Connect to Sendwithus Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Sendwithus data using standard SQL.
-
Integrate with live Reckon Data in Jitterbit
Use CData Connect AI to connect to and integrate live Reckon data in Jitterbit.
-
Integrating Cursor with Highrise 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.
-
Natively Connect to PayPal Data in PHP
The CData ODBC driver for PayPal enables you to create PHP applications with connectivity to PayPal data. Leverage the native support for ODBC in PHP.
-
Feed Amplitude Data into FineReport
How to set Amplitude data as a JDBC data source in FineReport.
-
Trigger QuickBooks Online IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for QuickBooks Online with standard wizards in Logic Apps.
-
Integrating Boomi Agentstudio with IBM Informix Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to IBM Informix data, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Access Live PostgreSQL Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live PostgreSQL data from your Excel spreadsheets.
-
Build Microsoft Ads-Connected Apps in Choreo
Use CData Connect AI to connect to Microsoft Ads Data from Choreo and build custom apps using live Microsoft Ads data.
-
Use the CData Software ODBC Driver for Amazon S3 in MicroStrategy
Connect to Amazon S3 data in MicroStrategy Developer using the CData Software ODBC Driver for Amazon S3.
-
Visualize ScrapingBee 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 ScrapingBee data into TIBCO Spotfire.
-
Integrate with Live Dynamics 365 Business Central Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Dynamics 365 Business Central from the MuleSoft Anypoint Platform to integrate live Dynamics 365 Business Central data into custom reports and dashboards.
-
Query Databricks Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Databricks data from Node.js.
-
Integrating Claude Code CLI with SharePoint Excel Services 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.
-
Publish ConvertAPI-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live ConvertAPI data.
-
Integrate Live Reckon Accounts Hosted Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Reckon Accounts Hosted data and integrate live Reckon Accounts Hosted data into apps built in Microsoft Power Apps.
-
Analyze Dotmailer Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Dotmailer from Power Pivot. You will use the Table Import Wizard to load Dotmailer data. You can visually build the import query or use any SQL supported by the driver.
-
Create Reports with Templated Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Templated data.