CData Software - Knowledge Base
Recent Articles
-
Create Dynamics NAV-Connected Dashboards in Grafana
Connect to Dynamics NAV Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Dynamics NAV data.
-
Connect to Paymo from a Connection Pool in WebLogic
Use the CData JDBC Driver for Paymo to connect to Paymo data from Web applications running on WebLogic.
-
Prepare, Blend, and Analyze CSV Data in Alteryx Designer (ODBC)
Build workflows to access live CSV data for self-service data analytics.
-
How to Build an ETL App for DB2 Data in Python with CData
Create ETL applications and real-time data pipelines for DB2 data in Python with petl.
-
Access Twitter Ads 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 Twitter Ads data.
-
Connect to Oracle HCM Cloud Data from a Connection Pool in Jetty
The Oracle HCM Cloud JDBC Driver supports connection pooling: This article shows how to connect faster to Oracle HCM Cloud data from Web apps in Jetty.
-
Build Semantic Layer Views for Google Forms Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Google Forms data.
-
Build Dashboards with SAP Ariba Source Data in Dundas BI
Create dynamic dashboards and perform analytics based on SAP Ariba Source data in Dundas BI.
-
Connect to Google Campaign Manager 360 Data in RapidMiner
Integrate Google Campaign Manager 360 data with standard components and data source configuration wizards in RapidMiner Studio.
-
Model Gmail Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Gmail, enabling the direct import of real-time Gmail data.
-
Migrating data from Google Ads to Google BigQuery using CData SSIS Components.
Easily push Google Ads data to Google BigQuery using the CData SSIS Tasks for Google Ads and Google BigQuery.
-
Analyze QuickBooks Online Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of QuickBooks Online data and visualize live QuickBooks Online data in Infragistics Reveal.
-
Use the CData Software JDBC Driver for Notion in MicroStrategy
Connect to Notion data in MicroStrategy Developer using the CData Software JDBC Driver for Notion.
-
How to connect and process Keap data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Keap data.
-
Integrate with Shortcut Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Shortcut data in SnapLogic.
-
Integrate Live Google Forms Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Google Forms from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Google Forms data.
-
How to connect to Discord Data from Spring Boot
Connect to Discord in a Spring Boot Application using the CData API Driver for JDBC
-
Enable the Suadeo JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Suadeo data.
-
Build an OLAP Cube in SSAS from Nuclia Data
Establish a connection to Nuclia data data from SQL Server Analysis Services, and use the Nuclia Data Provider to build OLAP cubes for use in analytics and reporting.
-
DataBind Kintone Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for Kintone with the DevExpress Windows Forms and Web controls to provide Kintone data to a chart.
-
Model BigQuery Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and BigQuery, enabling the direct import of real-time BigQuery data.
-
Feed Act CRM Data into FineReport
How to set Act CRM data as a JDBC data source in FineReport.
-
Use the CData Software ODBC Driver for Datadog in MicroStrategy Web
Connect to Datadog data in MicroStrategy Web using the CData Software ODBC Driver for Datadog.
-
Connect to Pingdom Data in DBeaver
Use the CData ODBC Driver to connect to Pingdom data in DBeaver.
-
Visualize MailerSend Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to MailerSend data.
-
Getting Started with the CData Power BI Connector for CampaignMonitor
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Connect to Factorial from Asprova with CData Software ODBC Driver for Factorial
This article shows how to connect faster to Factorial data from Asprova.
-
Connect to IBM Informix Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for IBM Informix data in the Denodo Virtual DataPort Administrator.
-
Integrate Facebook Data in the Pentaho Report Designer
Publish reports based on Facebook data in the Pentaho BI tool.
-
How to Connect to Live SAP Business Warehouse 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 SAP Business Warehouse data for you.
-
Process & Analyze Oracle SCM Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Oracle SCM Data.
-
Connect to SAP Ariba Procurement Data from PowerBuilder via ADO.NET
This article demonstrates how to access SAP Ariba Procurement data from Appeon PowerBuilder using the CData ADO.NET Provider for SAP Ariba Procurement.
-
Connect to Apify Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Apify data in the Denodo Virtual DataPort Administrator.
-
Manage ServiceNow Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for ServiceNow.
-
Getting Started with the CData Excel Add-In for LightSpeedRetail
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for LightSpeedRetail.
-
Connect to SAP Hybris C4C Data from PowerBuilder via ADO.NET
This article demonstrates how to access SAP Hybris C4C data from Appeon PowerBuilder using the CData ADO.NET Provider for SAP Hybris C4C.
-
Back Up Flowlu data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData API Driver for ADO.NET. In this article, we will employ an SSIS workflow to populate a database with Flowlu data data.
-
Integrating OpenCode with Vimeo 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.
-
Connecting GenSpark with Certinia Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Certinia data without any replication or custom integration required.
-
Extract, Transform, and Load CircleCI Data in Informatica PowerCenter
Create a simple Workflow for CircleCI data in Informatica PowerCenter.
-
Automated Continuous xBase Replication to Amazon S3
Use CData Sync for automated, continuous, customizable xBase replication to Amazon S3.
-
Publish Crystal Reports on DB2 Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date DB2 data.
-
Build AI/ML Models with Live Coinbase Data using Dataiku
Connect Coinbase Data with Dataiku using the CData API Driver for JDBC.
-
Connect to SAP Business One Data from PowerBuilder via ADO.NET
This article demonstrates how to access SAP Business One data from Appeon PowerBuilder using the CData ADO.NET Provider for SAP Business One.
-
LINQ to CouchDB 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 CouchDB Data Provider.
-
Getting Started with the CData ODBC Driver for Paymo
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Paymo.
-
Create Reckon-Connected Business Apps in AppSheet
Connect to Reckon Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Reckon data.
-
Connect to Google Campaign Manager 360 Data in RazorSQL
Connect to Google Campaign Manager 360 from wizards and query Google Campaign Manager 360 data from the GUI in the RazorSQL database management tool.
-
Migrating data from GraphQL to Databricks using CData SSIS Components.
Easily push GraphQL data to Databricks using the CData SSIS Tasks for GraphQL and Databricks.
-
Create Informatica Mappings From/To an ODBC Data Source for Grafana
Create an ODBC connection to Grafana in Informatica and browse and transfer Grafana data.
-
Integrating Cursor with Jira Assets 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.
-
Getting Started with the CData Tableau Connector for Smartsheet
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Smartsheet.
-
Analyze Mouseflow Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Mouseflow data in Microsoft R Open.
-
Analyze Snapchat Ads Data in Looker
Use CData Connect AI to connect to Snapchat Ads Data from Looker and build custom apps using live Snapchat Ads data.
-
How to connect to SAS Data Sets Data in DBVisualizer
Integrate SAS Data Sets data with visual data analysis tools and data connection wizards in DBVisualizer
-
Access Live Azure Data Catalog Data in Excel 365 Online (Excel for the web)
Connect to Azure Data Catalog data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Connect to Yelp Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Yelp and the SQL Gateway to access Yelp data from Google Apps Script.
-
Create Dashboards and Visualize Live HBase Data in Geckoboard
Use CData Connect AI to connect to live HBase data and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Build Agents in Relevance AI with Access to Live SAP Ariba Procurement Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on SAP Ariba Procurement data within intelligent agent workflows.
-
How to Connect the Power BI Service to Dynamics NAV: Complete Guide
Connect to the CData Software Power BI Connector for Dynamics NAV from PowerBI.com to provide real-time Dynamics NAV data across the organization.
-
Bridge Float Connectivity with Apache NiFi
Access and process Float data in Apache NiFi using the CData JDBC Driver.
-
Automated Continuous Mocean Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Mocean replication to IBM DB2.
-
Automated Continuous Reply.io Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Reply.io replication to Amazon S3.
-
Connect to SAP Data in Ruby
Connect to SAP data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Build Stripe-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Stripe data and build web apps with connectivity to live Stripe data.
-
DataBind Controls to Avalara AvaTax Data in C++Builder
DataBind to Avalara AvaTax data in C++Builder with standard components and controls.
-
Connect to Bitly Data in CloverDX (formerly CloverETL)
Transfer Bitly data using the visual workflow in the CloverDX data integration tool.
-
Automated Continuous Impala Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Impala replication to delimited files (CSV/TSV).
-
Build Charts with PDFMonkey Data in Clear Analytics
Create dynamic charts and perform analytics based on PDFMonkey data in Clear Analytics.
-
Connect to and Query Deel Data in QlikView over ODBC
Create data visualizations with Deel data in QlikView.
-
Bridge SAP HANA XS Advanced Connectivity with Apache NiFi
Access and process SAP HANA XS Advanced data in Apache NiFi using the CData JDBC Driver.
-
Configure the CData JDBC Driver for Databricks in a Connection Pool in Tomcat
Connect to Databricks data from a connection pool in Tomcat.
-
Automate Google Search Results Replication to Azure Synapse
Use CData Sync to customize and automate Google Search results replication to Azure Synapse.
-
Integrate Live GitLab Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live GitLab data to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Seamlessly Bring SingleStore Data into Retool Using CData Connect AI
Integrate SingleStore data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Visualize Microsoft Planner Data in TIBCO Spotfire through OData
Integrate Microsoft Planner data into dashboards in TIBCO Spotfire.
-
Create Informatica Mappings From/To an ODBC Data Source for Moosend
Create an ODBC connection to Moosend in Informatica and browse and transfer Moosend data.
-
Automated Continuous RSS Replication to MongoDB
Use CData Sync for automated, continuous, customizable RSS replication to MongoDB.
-
Integrating Cursor with Outreach.io 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 Dynamic Oracle SCM Grids Using the Infragistics XamDataGrid
Learn how you can connect Oracle SCM to Infragistics XamDataGrid to build dynamic grids.
-
Connect to Perigon Data in DBeaver
Use the CData ODBC Driver to connect to Perigon data in DBeaver.
-
SAP Netweaver Gateway Reporting in OBIEE with the SAP Netweaver Gateway JDBC Driver
Deploy the SAP Netweaver Gateway JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Create a Data Access Object for Mailgun Data using JDBI
A brief overview of creating a SQL Object API for Mailgun data in JDBI.
-
Integrating Cursor with Parallel 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.
-
Connect to HBase Data in HULFT Integrate
Connect to HBase as a JDBC data source in HULFT Integrate
-
Build Dashboards with Amplitude Data in DBxtra
Create dynamic dashboards and perform analytics based on Amplitude data in DBxtra.
-
Integrate Dify with Live MailChimp 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 MailChimp data.
-
Integrating Sage Cloud Accounting Data in Talend Cloud Data Management Platform
Connect Sage Cloud Accounting Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Sage Cloud Accounting.
-
Access Live SharePoint Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live SharePoint data from your Excel spreadsheets.
-
How to Work with AdRoll Data in AWS Glue Jobs Using JDBC
Connect to AdRoll from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Automated Continuous ZohoSubscriptions Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable ZohoSubscriptions replication to Azure SQL Database.
-
Query Google Calendar Data as a SQL Server Database in Node.js
Execute SQL Server queries against Google Calendar data from Node.js.
-
Replicate Multiple LeadDesk Accounts via the CData Sync CLI
Replicate multiple LeadDesk accounts to one or many databases.
-
Integrate with Dynamics NAV Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Dynamics NAV data in SnapLogic.
-
How to Connect DBeaver to JDBC-ODBC Bridge via a JDBC Driver
Manage JDBC-ODBC Bridge data with visual tools in DBeaver like the query browser.
-
Connect to Facebook Ads Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Facebook Ads as an External Source in Dremio.
-
Import Real-Time Microsoft Dataverse Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Microsoft Dataverse data in ColdFusion.
-
Work with Live LinkedIn Data in Power Query
Use CData Connect AI to connect to LinkedIn data and work with live LinkedIn data in Microsoft Power Query.
-
Use the CData Software ODBC Driver for ChartMogul in MicroStrategy Desktop
Connect to ChartMogul data in MicroStrategy Desktop using the CData Software ODBC Driver for ChartMogul.
-
Build JSON-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for JSON Services and create custom apps in Mendix.