CData Software - Knowledge Base
Recent Articles
-
Rapidly Develop Simplesat-Driven Apps with Active Query Builder
Leverage the Active Query Builder SQL interface and .NET data access to create data-driven WinForms and ASP.NET apps backed by Simplesat.
-
Integrate with LinkedIn Ads Data in SnapLogic
Use CData Connect AI to connect to and integrate with live LinkedIn Ads data in SnapLogic.
-
Create Informatica Mappings From/To a JDBC Data Source for SurveyMonkey
Create SurveyMonkey data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Migrating data from Sugar CRM to Google BigQuery using CData SSIS Components.
Easily push Sugar CRM data to Google BigQuery using the CData SSIS Tasks for Sugar CRM and Google BigQuery.
-
Model Active Directory Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Active Directory, enabling the direct import of real-time Active Directory data.
-
Enable the Pingdom JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Pingdom data.
-
Connect to Live SAP Netweaver Gateway Data in PostGresSQL Interface through CData Connect AI
Create a live connection to SAP Netweaver Gateway in CData Connect AI and connect to your SAP Netweaver Gateway data from PostgreSQL.
-
Create Power BI Reports on Real-Time ScrapingBee Data
Use the CData ODBC Driver for ScrapingBee to visualize ScrapingBee data in Power BI Desktop.
-
Automated Continuous Cosmos DB Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Cosmos DB replication to Azure SQL Database.
-
How to create Deel federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Deel data in MySQL .
-
Migrating data from Oracle HCM Cloud to Databricks using CData SSIS Components.
Easily push Oracle HCM Cloud data to Databricks using the CData SSIS Tasks for Oracle HCM Cloud and Databricks.
-
Visualize Live CapsuleCRM Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live CapsuleCRM data into custom reports in Power BI.
-
Integrating Kiro with eBay 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.
-
Use Dash to Build to Web Apps on Excel Online Data
Create Python applications that use pandas and Dash to build Excel Online-connected web apps.
-
Access Live Productboard Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Productboard data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Use the CData ODBC Driver for Square from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Square to connect to Square data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Square data in Excel.
-
Design BIRT Reports on Kafka Data
Provide current Kafka data to your embedded analytics.
-
Integrating Claude Code CLI with Factorial 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.
-
Migrating data from SAS xpt to Snowflake using CData SSIS Components.
Easily push SAS xpt data to Snowflake using the CData SSIS Tasks for SAS xpt and Snowflake.
-
Visualize Zuora Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Zuora data.
-
Integrate SAP BusinessObjects BI Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to SAP BusinessObjects BI data and integrate live SAP BusinessObjects BI data into your Power Automate tasks.
-
Automated Continuous ElevenLabs Replication to SQL Server
Use CData Sync for automated, continuous, customizable ElevenLabs replication to SQL Server.
-
Connect to SAP HANA Data from a Connection Pool in Jetty
The SAP HANA JDBC Driver supports connection pooling: This article shows how to connect faster to SAP HANA data from Web apps in Jetty.
-
Visualize ScrapingBee Data in TIBCO Spotfire through ADO.NET
Integrate ScrapingBee data into dashboards in TIBCO Spotfire.
-
Integrating LlamaIndex with Airtable Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Airtable data in real time.
-
Integrating Boomi Agentstudio with Salesforce Marketing Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Salesforce Marketing data, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Integrate Snowflake Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Snowflake data and integrate live Snowflake data into your Power Automate tasks.
-
Connect to AfterShip Data in Aqua Data Studio
Access AfterShip data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Build BigCommerce-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live BigCommerce data.
-
Connect to and Query Bullhorn CRM Data in QlikView over ODBC
Create data visualizations with Bullhorn CRM data in QlikView.
-
Model Greenhouse Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Greenhouse, enabling the direct import of real-time Greenhouse data.
-
Build Odoo-Connected Applications in Kiro with CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Kiro to securely access, query, and take action on live Odoo data without replication.
-
Analyze SAP HANA XS Advanced Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of SAP HANA XS Advanced data and visualize live SAP HANA XS Advanced data in Infragistics Reveal.
-
Replicate Ontraport Data in Heroku for Use in Salesforce Connect
Replicate Ontraport data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Build Automated Workflows with Live Monday.com Data in Workato
Use CData Connect AI to connect to live Monday.com data and build automated workflows in Workato.
-
Connect to Databricks from a Connection Pool in WebLogic
Use the CData JDBC Driver for Databricks to connect to Databricks data from Web applications running on WebLogic.
-
Connect to Bannerbear Data in DBArtisan
Use wizards in DBArtisan to configure Bannerbear data as a data source.
-
Use Grok to Talk to Your MYOB AccountRight Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Grok AI to securely answer questions and take actions on your MYOB AccountRight data for you.
-
Access Live HCL Domino Data in AWS Lambda (with IntelliJ IDEA)
Connect to live HCL Domino data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Visualize Live HCL Domino Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live HCL Domino data into custom reports in Power BI.
-
Consume Salesforce Data 360 OData Feeds in PowerBuilder
This article demonstrates how to consume Salesforce Data 360 data as OData feeds from PowerBuilder using the API Server.
-
How to connect PolyBase to MongoDB
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live MongoDB data.
-
Prepare, Blend, and Analyze Exa Data in Alteryx Designer (ODBC)
Build workflows to access live Exa data for self-service data analytics.
-
Integrating Boomi Agentstudio with Tally Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Tally data, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
How to Connect DBeaver to NASA via a JDBC Driver
Manage NASA data with visual tools in DBeaver like the query browser.
-
Use the CData Software ODBC Driver for SAP ByDesign in SAS for Real-Time Reporting and Analytics
Connect to real-time SAP ByDesign data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for SAP ByDesign.
-
Automate Beeminder Data Replication to SAP HANA
Use CData Sync to customize and automate Beeminder data replication to SAP HANA.
-
Automated Continuous Zoom Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Zoom replication to Apache Cassandra.
-
Connect to Oracle Service Cloud Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Oracle Service Cloud and the SQL Gateway to access Oracle Service Cloud data from Google Apps Script.
-
Getting Started with the CData ADO.NET Provider for MarkLogic
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for MarkLogic.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Ontraport
Provide connectivity to Ontraport data through an SAP BusinessObjects universe.
-
Analyze GetResponse Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze GetResponse data with the CData JDBC Driver for GetResponse.
-
Automate TaxJar Data Replication to SAP HANA
Use CData Sync to customize and automate TaxJar data replication to SAP HANA.
-
Integrate with DB2 Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy DB2 data to a JSON file on disk.
-
Integrate LibreChat with Live BigCommerce Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live BigCommerce data from within the chat interface.
-
Import and Visualize HBase Data in Power View
Create data visualizations based on HBase data in Excel.
-
How to connect to PabblySubscriptions Data in DBVisualizer
Integrate PabblySubscriptions data with visual data analysis tools and data connection wizards in DBVisualizer
-
How to Build an ETL App for Reckon Data in Python with CData Connect AI
Build ETL pipelines that read and write live Reckon data in Python with petl and the CData Connect AI Python SDK.
-
Integrate MongoDB Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to MongoDB data and integrate live MongoDB data into your Power Automate tasks.
-
Integrate Missive Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Missive data from Informatica Cloud.
-
How to Connect to & Open Active Directory Data in Microsoft Excel
This article uses the CData ODBC driver for Active Directory to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Getting Started with the CData Power BI Connector for Egnyte
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Build Zuora-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Zuora data and build Zuora-connected web apps with Axios.
-
Create Data Visualizations in Cognos BI with ZohoSubscriptions Data
Access ZohoSubscriptions data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Link PDFMonkey with FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate PDFMonkey data in Filemaker Pro for Mac or Windows.
-
Build an OLAP Cube in SSAS from Sage 200 Data
Establish a connection to Sage 200 data data from SQL Server Analysis Services, and use the Sage 200 Data Provider to build OLAP cubes for use in analytics and reporting.
-
Building Dynamic Web Pages with SAP Concur Data Using AngularJS
Create single-page applications with live connectivity to SAP Concur using the CData API Server.
-
How to Seamlessly Import Keap Data into IBM SPSS Modeler
Integrate Keap data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Visualize SparkPost Data in TIBCO Spotfire through ADO.NET
Integrate SparkPost data into dashboards in TIBCO Spotfire.
-
How to Connect DBeaver to Aircall via a JDBC Driver
Manage Aircall data with visual tools in DBeaver like the query browser.
-
Build Apps with Live Authorize.Net data in Adalo using CData Connect AI
Use CData Connect AI to integrate live Authorize.Net data into the Adalo platform and build custom mobile and web applications with real-time Authorize.Net data.
-
How to Build an ETL App for Microsoft Teams Data in Python with CData
Create ETL applications and real-time data pipelines for Microsoft Teams data in Python with petl.
-
Replicate Multiple Autopilot Accounts
Replicate multiple Autopilot accounts to one or many databases.
-
How to Query Paddle Data in MySQL Workbench
Execute MySQL queries against live Paddle data from MySQL Workbench.
-
Connect to Productboard Data in Ruby
Connect to Productboard data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
How to connect to SendInBlue Data with Squirrel SQL client
Connect to SendInBlue data and execute queries in the Squirrel SQL Client.
-
Integrating Codex with CouchDB 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 DB2 Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access DB2 from an ASP.NET MVC application.
-
Validate AfterShip Data with QuerySurge
Access and validate AfterShip data in QuerySurge using the CData JDBC Driver.
-
Pushbullet Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Pushbullet facts in real time.
-
Use Grok to Talk to Your Anaplan Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Grok AI to securely answer questions and take actions on your Anaplan data for you.
-
Build ClickUp-Connected Apps in Choreo
Use CData Connect AI to connect to ClickUp Data from Choreo and build custom apps using live ClickUp data.
-
Connect to CockroachDB Data in RapidMiner
Integrate CockroachDB data with standard components and data source configuration wizards in RapidMiner Studio.
-
Connect to Twilio Data in Ruby
Connect to Twilio data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
How to Query Live BigCommerce Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live BigCommerce data data in natural language using Python.
-
Connecting Moonlit Workflow with Act-On Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Moonlit workflows to securely read and act on your Act-On data in real time.
-
Create Apps from WooCommerce Data in Qlik Sense Cloud
Use CData Connect AI to connect to WooCommerce Data and build apps from live WooCommerce data in Qlik Sense Cloud.
-
Access Float Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Float data from HeidiSQL.
-
Getting Started with the CData Power BI Connector for Adobe Analytics
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Adobe Analytics.
-
Build Shopify-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Shopify Data and create custom apps in Mendix.
-
Build Impala-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Impala Data and create custom apps in Bubble.
-
Feed Outlook Data into FineReport
How to set Outlook data as a JDBC data source in FineReport.
-
Connect to Microsoft Exchange Data from Crystal Reports
Use CData Connect AI to connect to and report on live Microsoft Exchange data from Crystal Reports.
-
Query Deel Data in DataGrip
Create a Data Source for Deel in DataGrip and use SQL to query live Deel data.
-
Connect to Grafana Data from PowerBuilder via ADO.NET
This article demonstrates how to access Grafana data from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
How to connect to Jumpseller Data in DBVisualizer
Integrate Jumpseller data with visual data analysis tools and data connection wizards in DBVisualizer
-
Access Live Wave Financial Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Wave Financial data from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Getting Started with the CData Connect AI Python SDK for Guru
Install the CData Connect AI Python SDK to read live Guru data with standard DB-API 2.0 Python code.
-
Analyze Cosmos DB Data in Cognos Analytics
Use CData Connect AI to connect to Cosmos DB Data from Cognos Analytics and analyze live Cosmos DB data.
-
Connect to Zoom Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Zoom and the SQL Gateway to access Zoom data from Google Apps Script.