CData Software - Knowledge Base
Recent Articles
-
Using the CData Software ODBC Driver for Stack Exchange in PyCharm
Connect to Stack Exchange as an ODBC data source in PyCharm using the CData Software ODBC Driver for Stack Exchange.
-
Integrate Live NASA Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live NASA to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Integrating GitHub Copilot CLI with Sentry 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 GraphQL Visualizations in Tableau Cloud
Use CData Connect AI to connect to live GraphQL and build visualizations in Tableau Cloud.
-
Automate Insightly Data Replication to Azure Synapse
Use CData Sync to customize and automate Insightly replication to Azure Synapse.
-
How to Connect to Microsoft Dataverse Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Microsoft Dataverse (CDS). Leverage the pyodbc module for ODBC in Python.
-
Provide OData Services of AdRoll Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for AdRoll by developing a WCF Service Application.
-
Excel Spreadsheet Automation on Superchat Data with the QUERY Formula
Pull data from Superchat, automate spreadsheets, and more with the QUERY formula.
-
How to connect to Discourse Data in DBVisualizer
Integrate Discourse with visual data analysis tools and data connection wizards in DBVisualizer
-
Migrating data from Quaderno to Snowflake using CData SSIS Components.
Easily push Quaderno to Snowflake using the CData SSIS Tasks for Quaderno and Snowflake.
-
Analyze Spark Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Apache Spark SQL with the CData JDBC Driver for Spark.
-
Access FormSite Data from MySQL in Amazon QuickSight
Connect to FormSite and build visualizations of FormSite using a MySQL Connection in Amazon QuickSight.
-
How to Easily Query LDAP Objects in OpenOffice Base
Connect to LDAP data in OpenOffice Base using the CData ODBC Driver for LDAP and generate reports with live data insights.
-
Access Live REST Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live REST data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Integrating Adobe Analytics Data in Talend Cloud Data Management Platform
Connect Adobe Analytics Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Adobe Analytics.
-
Build Dashboards with Zoho Inventory Data in DBxtra
Create dynamic dashboards and perform analytics based on Zoho Inventory in DBxtra.
-
Import Real-Time EnterpriseDB Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use EnterpriseDB in ColdFusion.
-
Connect to SurveyMonkey Data in DBArtisan
Use wizards in DBArtisan to configure SurveyMonkey as a data source.
-
How to connect Amazon QuickSight to NetSuite SuiteAnalytics Data
Create a connection to NetSuite SuiteAnalytics in CData Connect AI and insert NetSuite SuiteAnalytics into Amazon QuickSight SPICE to build interactive dashboards.
-
How to Connect to REST Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to REST. Leverage the pyodbc module for ODBC in Python.
-
Trigger Pipedrive IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for Pipedrive with standard wizards in Logic Apps.
-
Use the CData Software ODBC Driver for Presto in SAS for Real-Time Reporting and Analytics
Connect to real-time Presto in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Presto.
-
Migrating data from MariaDB to Databricks using CData SSIS Components.
Easily push MariaDB to Databricks using the CData SSIS Tasks for MariaDB and Databricks.
-
Configure the CData JDBC Driver for Sybase in a Connection Pool in Tomcat
Connect to Sybase from a connection pool in Tomcat.
-
Create Reports from Oracle SCM Data in Looker Studio
Use CData Connect AI to gain access to live Oracle SCM and create custom reports in Looker Studio.
-
Build Certinia-Powered Applications in Claude Code with CData MCP Server
Use the CData MCP Server for Certinia to explore live Certinia Data in Claude Code to assist with building Certinia-powered applications.
-
Automated Continuous Optimizely Replication to SingleStore
Use CData Sync for automated, continuous, customizable Optimizely replication to SingleStore.
-
Create HubSpot Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time HubSpot data access from reports, embedded analytics, and more.
-
How to Work with FreshBooks Data in ETL Validator JDBC
Connect to FreshBooks from ETL Validator jobs using the CData Software JDBC Driver.
-
Build Yelp-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Yelp.
-
How to Seamlessly Import Qualaroo Data into IBM SPSS Modeler
Integrate Qualaroo data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
How to Access Live MarkLogic Data in Visual Studio Code via Cline
Run CData MCP Server for MarkLogic on Windows Subsytem for Linux (WSL) and connect to live MarkLogic from the Cline extension in Visual Studio Code.
-
Feed Postmark Data into FineReport
How to set Postmark as a JDBC data source in FineReport.
-
Operational Reporting on Retently Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Retently.
-
How to Connect Dynamics 365 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 Dynamics 365 data in real time using natural language.
-
Analyze GitLab Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of GitLab and visualize GitLab in SAP Analytics Cloud.
-
Rapidly Develop Beeminder-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 Beeminder.
-
Integrate Live Avalara AvaTax Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Avalara AvaTax to Blue Prism using the CData ODBC Driver for Avalara AvaTax to create automated workflows for repetitive business tasks.
-
Build Apps with Live Jira Assets Data Using the Low-Code Development Platform of Mendix
Connect Jira Assets with Mendix to build apps using the CData JDBC Driver for Jira Assets.
-
Connect to Impala in SpagoBI
Create reports featuring live Apache Impala in SpagoBI Studio. Host Impala reports on SpagoBI Server.
-
Add SendGrid Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for SendGrid with the Informatica Enterprise Data Catalog to classify and organize data.
-
Connect Amazon DynamoDB to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Amazon DynamoDB using the CData Python MCP Server.
-
Build MVC Applications with Connectivity to PayPal Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access PayPal from an ASP.NET MVC application.
-
Use the CData API Server to Access Redis Data in Microsoft PowerPivot
Use the CData API Server to connect to live Redis in the Power Pivot business intelligence tool.
-
How to Visualize ClickTime Data in Python with pandas
Use pandas and other modules to analyze and visualize live ClickTime in Python.
-
Access Live ZohoSubscriptions Data in Coginiti Pro
Connect to and query live ZohoSubscriptions from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Integrate Testmonitor with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Testmonitor with External Services.
-
How to connect SharePoint with Access Data through external lists
Provide Microsoft Access to SharePoint users as an external list.
-
Integrate Cursor with Live Instagram Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Instagram from within the editor.
-
Connect to and Query LaunchDarkly Data in QlikView over ODBC
Create data visualizations with LaunchDarkly in QlikView.
-
Choosing the Best Method to Connect HDFS to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Apache HDFS from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Automate Cloudant Data Replication to Azure Data Lake
Use CData Sync to customize and automate IBM Cloudant replication to Azure Data Lake.
-
Migrating data from Google Ad Manager to Snowflake using CData SSIS Components.
Easily push Google Ad Manager to Snowflake using the CData SSIS Tasks for Google Ad Manager and Snowflake.
-
How to Build an ETL App for ZohoMarketingHub Data in Python with CData
Create ETL applications and real-time data pipelines for ZohoMarketingHub in Python with petl.
-
Connect to GitHub Data from a Connection Pool in Jetty
The GitHub JDBC Driver supports connection pooling: This article shows how to connect faster to GitHub from Web apps in Jetty.
-
How to integrate Metabase with Google Drive Data
Use CData Connect AI to connect to live Google Drive and create an interactive dashboard in Metabase from Google Drive.
-
Integrate LibreChat with Live CouchDB Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Apache CouchDB from within the chat interface.
-
Access Live Email Data in Excel 365 Online (Excel for the web)
Connect to Email from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Connect to and Query Teamgate Data in QlikView over ODBC
Create data visualizations with Teamgate in QlikView.
-
Build a Singer.io Tap for Notion With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Notion data using
-
Publish Reports with Invoiced Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Invoiced.
-
Connect to FTP Data from PowerBuilder via JDBC
This article demonstrates how to access FTP Servers from PowerBuilder using the FTP JDBC Driver.
-
Automated Continuous Flowlu Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Flowlu replication to OneLake in Microsoft Fabric.
-
How to Connect to & Open RSS Feeds in Microsoft Excel
This article uses the CData ODBC driver for RSS to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Build Azure Data Catalog-Powered Applications in Cursor with CData MCP Server
Use the CData MCP Server for Azure Data Catalog to explore live Azure Data Catalog Data in Cursor to assist with building Azure Data Catalog-powered applications.
-
Access Live Workable Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Workable in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Access Klaviyo Data from MySQL in Amazon QuickSight
Connect to Klaviyo and build visualizations of Klaviyo using a MySQL Connection in Amazon QuickSight.
-
Work with Zoho Creator Data in FoxPro
Load Zoho Creator into a FoxPro database. This article includes full code and a walk-through of the process.
-
Connect to Authorize.Net Data in NetBeans
Connect to Authorize.Net in NetBeans with the data source configuration wizard.
-
Create Dynamics CRM-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Dynamics CRM Data from OutSystems and build custom enterprise apps using live Microsoft Dynamics CRM.
-
Use Dash to Build to Web Apps on FHIR Data
Create Python applications that use pandas and Dash to build FHIR-connected web apps.
-
Access ZeroBounce Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access ZeroBounce from your Oracle system.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Apache CouchDB within intelligent workflows.
-
Analyze Kintone Data in Cognos Analytics
Use CData Connect AI to connect to Kintone Data from Cognos Analytics and analyze live Kintone.
-
Visualize SendInBlue Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to SendInBlue.
-
Load Snapchat Ads Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Snapchat Ads to a database.
-
Automate Campaigner Data Replication to SAP HANA
Use CData Sync to customize and automate Campaigner replication to SAP HANA.
-
Build Apps with Live Adobe Experience Manager Data Using the Low-Code Development Platform of Mendix
Connect Adobe Experience Manager with Mendix to build apps using the CData JDBC Driver for Adobe Experience Manager.
-
Create Power BI Reports on Real-Time RSS Feeds
Use the CData ODBC Driver for RSS to visualize RSS Feeds in Power BI Desktop.
-
Automated Continuous Xero Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Xero replication to Google Cloud SQL.
-
DataBind Controls to Clari Data in Delphi
DataBind to Clari in Delphi with standard data access components and controls.
-
Connect to Autopilot Data from PowerBuilder via JDBC
This article demonstrates how to access Autopilot from PowerBuilder using the Autopilot JDBC Driver.
-
Install a Microsoft Excel Add-In Manually
Some Microsoft Excel users may need to follow these steps to manually add the CData Excel Add-In formulas, enabling you to execute your own database queries.
-
Publish Slack-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Slack.
-
Stream Paddle Data into Apache Kafka Topics
Access and stream Paddle in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Connect Moosend to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Moosend using the CData Python MCP Server.
-
How to create Stripe federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Stripe in MySQL .
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for HubSpot
Provide connectivity to HubSpot through an SAP BusinessObjects universe.
-
Object-Relational Mapping (ORM) with Nethunt 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 Nethunt into a Java-based ORM framework, Hibernate.
-
Use the CData Software JDBC Driver for BenchmarkEmail in MicroStrategy
Connect to BenchmarkEmail in MicroStrategy Developer using the CData Software JDBC Driver for BenchmarkEmail.
-
Integrating Boomi Agentstudio with Amazon Marketplace Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Amazon Marketplace, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Integrating Gumloop with Instagram Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Instagram within automated workflows.
-
How to publish and share Google Spanner Data dashboards with Tableau Server
The CData ODBC driver for Google Spanner enables you integrate Google Spanner into Tableau dashboards.
-
Greenhouse Reporting in OBIEE with the Greenhouse JDBC Driver
Deploy the Greenhouse JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Visualize Tavily Data in TIBCO Spotfire through ADO.NET
Integrate Tavily into dashboards in TIBCO Spotfire.
-
Write a Simple Go Application to work with Act CRM Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Act CRM.
-
Use the CData ODBC Driver for Pipeline CRM from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Pipeline CRM to connect to Pipeline CRM from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Pipeline CRM in Excel.
-
How to integrate HubDB with Apache Airflow
Access and process HubDB in Apache Airflow using the CData JDBC Driver.
-
Build Dashboards with Simplesat Data in DBxtra
Create dynamic dashboards and perform analytics based on Simplesat in DBxtra.
-
Visualize Klaviyo Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Klaviyo.