CData Software - Knowledge Base
Recent Articles
-
Bridge Teradata Connectivity with Apache NiFi
Access and process Teradata in Apache NiFi using the CData JDBC Driver.
-
Use Azure AI Foundry to Talk to Your MongoDB Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Azure AI Foundry agents to securely answer questions and take actions on your MongoDB for you.
-
Excel Spreadsheet Automation on HubSpot Data with the QUERY Formula
Pull data from HubSpot, automate spreadsheets, and more with the QUERY formula.
-
Visualize Live JotForm Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live JotForm.
-
Build LDAP-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to LDAP and build web apps with connectivity to live LDAP.
-
Rapidly Develop Zoom-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 Zoom.
-
Connect to MessageBird Data in Aqua Data Studio
Access MessageBird from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Validate Adobe Analytics Data with QuerySurge
Access and validate Adobe Analytics in QuerySurge using the CData JDBC Driver.
-
Access Shortcut Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Shortcut from your Oracle system.
-
Connect to Avaza Data in CloverDX (formerly CloverETL)
Transfer Avaza using the visual workflow in the CloverDX data integration tool.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for ChargeOver
Provide connectivity to ChargeOver through an SAP BusinessObjects universe.
-
Choosing the Best Method to Connect Salesforce to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Salesforce & Force.com from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Use Dash to Build Web Apps on Zoho Creator Data via CData Connect AI
Build interactive Dash web apps on live Zoho Creator using pandas and the CData Connect AI Python SDK.
-
Build Google Drive-Powered Applications in Gemini Code Assist with CData MCP Server
Use the CData MCP Server for Google Drive to explore live Google Drive Data in Gemini Code Assist to assist with building Google Drive-powered applications.
-
Getting Started with the CData Power BI Connector for MailerSend
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Access Live DB2 Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to IBM DB2 from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Use the CData API Server to Access DocuSign Data in Microsoft PowerPivot
Use the CData API Server to connect to live DocuSign in the Power Pivot business intelligence tool.
-
Access Live Google Search Results in TIBCO Data Virtualization
Use the Google Search Tibco DV Adapter to create a Google Search data source in TIBCO Data Virtualization Studio and gain access to live Google Search from your TDV Server.
-
Connect to Active Directory Data in Google Apps Script via Connect AI
Use CData Connect AI to access Active Directory in Google Apps Script.
-
How to publish and share SAP SuccessFactors LMS Data dashboards with Tableau Server
The CData ODBC driver for SAP SuccessFactors LMS enables you integrate SAP SuccessFactors LMS into Tableau dashboards.
-
Build SAP Fieldglass-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for SAP Fieldglass Data and create custom apps in Mendix.
-
Access Moosend Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Moosend from your Oracle system.
-
Use the CData Software ODBC Driver for Printful in MicroStrategy Web
Connect to Printful in MicroStrategy Web using the CData Software ODBC Driver for Printful.
-
Use Dash to Build Web Apps on Marketo Data via CData Connect AI
Build interactive Dash web apps on live Marketo using pandas and the CData Connect AI Python SDK.
-
Connect to Google Forms Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Google Forms to connect to Google Forms and execute queries in PowerBuilder.
-
Create Informatica Mappings From/To a JDBC Data Source for GraphQL
Create GraphQL data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Create Datasets from SAP HANA XS Advanced in Domo Workbench and Build Visualizations of SAP HANA XS Advanced Data in Domo
Use the CData Software ODBC Driver for SAP HANA XS Advanced to create datasets from SAP HANA XS Advanced in Domo Workbench and then build visualizations in the Domo service.
-
How to import MessageBird Data into Apache Solr
Use the CData Software JDBC Driver for MessageBird in Data Import Handler and create an automated import of MessageBird to Apache Solr Enterprise Search platform.
-
Create PayPal-Connected Business Apps in AppSheet
Connect to PayPal Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to PayPal.
-
Back Up Facebook to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Facebook. In this article, we will employ an SSIS workflow to populate a database with Facebook data.
-
Edit and Search External Amazon S3 Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Amazon S3 to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Amazon S3 Data objects that you can access from apps and the dashboard.
-
View Reports on Real-Time AgileCRM Data in Power BI Report Server
Use the CData ODBC Driver for AgileCRM to visualize AgileCRM in Power BI Desktop and then publish them to Power BI Report Server.
-
Access Live Sage 300 Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Sage 300 in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Analyze PingOne Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for PingOne from Power Pivot. You will use the Table Import Wizard to load PingOne. You can visually build the import query or use any SQL supported by the driver.
-
Connect to Parquet Data in HULFT Integrate
Connect to Parquet as a JDBC data source in HULFT Integrate
-
Build a PostgreSQL Interface for Greenplum Data using the CData JDBC Driver
Use the Remoting features of the Greenplum JDBC Driver to create a PostgreSQL entry-point for data access.
-
Build Automated Quickbase-Connected Workflows in Zapier
Use CData Connect AI to connect to live Quickbase and build automated workflows in Zapier.
-
How to Connect to Live FreshBooks 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 FreshBooks for you.
-
Build GitLab-Connected Apps in Choreo
Use CData Connect AI to connect to GitLab Data from Choreo and build custom apps using live GitLab.
-
Use Dash to Build to Web Apps on PingOne Data
Create Python applications that use pandas and Dash to build PingOne-connected web apps.
-
Connect to Omnisend Data in Jaspersoft Studio
Execute SQL to remote Omnisend in Jaspersoft Studio.
-
Use Biml to Build SSIS Tasks to Replicate ServiceDesk Plus Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate ServiceDesk Plus to SQL Server.
-
Integrate Cline with Live Salesforce CRM Analytics Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Salesforce CRM Analytics from within your IDE.
-
Visualize Amazon DynamoDB Data in TIBCO Spotfire through OData
Integrate Amazon DynamoDB into dashboards in TIBCO Spotfire.
-
Create Google Ads-Connected Applications in Appsmith
Connect to Google Ads Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Google Ads.
-
How to create Visio diagrams from Quickbase Data
Automatically update Quickbase with the changes you make to Visio master shapes.
-
How to connect and process Microsoft OneNote from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Microsoft OneNote.
-
Getting Started with the CData Power BI Connector for Salesforce Marketing
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Salesforce Marketing.
-
Query Neo4J Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Neo4J entities in PHP by modeling them as objects.
-
Bidirectional Access to Front Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Front in Filemaker Pro for Mac or Windows.
-
Build Dashboards with Customer.io Data in Dundas BI
Create dynamic dashboards and perform analytics based on Customer.io in Dundas BI.
-
Analyze PostgreSQL Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for PostgreSQL from Power Pivot. You will use the Table Import Wizard to load PostgreSQL. You can visually build the import query or use any SQL supported by the driver.
-
Integrating Codex CLI with Rootly 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.
-
Query FormSite Data as a MySQL Database in Node.js
Execute MySQL queries against FormSite from Node.js.
-
Create Dashboards and Visualize Live Oracle Eloqua Data in Geckoboard
Use CData Connect AI to connect to live Oracle Eloqua and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Integrate with Live Cvent Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Cvent from the MuleSoft Anypoint Platform to integrate live Cvent into custom reports and dashboards.
-
Connect to Monday.com Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Monday.com using standard SQL.
-
Choosing the Best Method to Connect Aweber to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Aweber from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Enable the LinkedIn Ads JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with LinkedIn Ads.
-
Create Zoho Creator-Connected Business Apps in AppSheet
Connect to Zoho Creator Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Zoho Creator.
-
Access Live Google Sheets Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Google Sheets in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Write a Simple Go Application to work with ElevenLabs Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to ElevenLabs.
-
Integrating Kiro CLI with ZohoInvoice 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 Automated WordPress-Connected Workflows in Zapier
Use CData Connect AI to connect to live WordPress and build automated workflows in Zapier.
-
Automated Continuous ServiceNow Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable ServiceNow replication to Apache Cassandra.
-
Import and Visualize Google Search Results in Power View
Create data visualizations based on Google Search in Excel.
-
Provide OData Services of RSS Feeds from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for RSS Feeds by developing a WCF Service Application.
-
Connect to Live Google Ad Manager Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Google Ad Manager in CData Connect AI and connect to your Google Ad Manager from PostgreSQL.
-
Use the CData Software JDBC Driver for PingOne in MicroStrategy Web
Connect to PingOne in MicroStrategy Web using the CData Software JDBC Driver for PingOne.
-
Publish SAS xpt-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live SAS XPORT.
-
Automated Continuous Planio Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Planio replication to delimited files (CSV/TSV).
-
Connect to Basecamp Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Basecamp.
-
Use the CData Software JDBC Driver for SendPulse in MicroStrategy Web
Connect to SendPulse in MicroStrategy Web using the CData Software JDBC Driver for SendPulse.
-
Access Live Parquet Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Apache Parquet into the statistical analysis tools available in SAS JMP. This article shows how to use Apache Parquet in the Graph Builder and Query Builder.
-
How to work with Nuclia Data in Apache Spark using SQL
Access and process Nuclia Data in Apache Spark using the CData Software JDBC Driver.
-
Connect to CockroachDB Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for CockroachDB.
-
How to Access CapsuleCRM Data Using Entity Framework
This article shows how to access CapsuleCRM using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Visualize Live Nuclia Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Nuclia using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Analyze Tanda Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Tanda with the CData JDBC Driver for Tanda.
-
Build Charts with Zoho Books Data in Clear Analytics
Create dynamic charts and perform analytics based on Zoho Books in Clear Analytics.
-
Integrate Live SQL Analysis Services Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Contentful
Provide connectivity to Contentful through an SAP BusinessObjects universe.
-
Build Amazon Marketplace Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Amazon Marketplace and build visualizations in Tableau Cloud.
-
Import Real-Time ClickUp Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use ClickUp in ColdFusion.
-
Connect to Live Google Campaign Manager 360 Data in MicroStrategy through CData Connect AI
Create a live connection to Google Campaign Manager 360 Data in CData Connect AI and connect to your Google Campaign Manager 360 from MicroStrategy.
-
Migrating data from Jumpseller to Snowflake using CData SSIS Components.
Easily push Jumpseller to Snowflake using the CData SSIS Tasks for Jumpseller and Snowflake.
-
Build Charts with SendInBlue Data in Clear Analytics
Create dynamic charts and perform analytics based on SendInBlue in Clear Analytics.
-
Automate MailerLite Data Replication to Couchbase
Use CData Sync to Customize and automate MailerLite replication to Couchbase.
-
Visualize Dynamics 365 Business Central Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Dynamics 365 Business Central.
-
Connect to Amazon DynamoDB Data in CloverDX (formerly CloverETL)
Transfer Amazon DynamoDB using the visual workflow in the CloverDX data integration tool.
-
Use Dash to Build to Web Apps on Jodoo Data
Create Python applications that use pandas and Dash to build Jodoo-connected web apps.
-
Connect to ZohoDesk Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time ZohoDesk using standard SQL.
-
Create Informatica Mappings From/To a JDBC Data Source for NASA
Create NASA data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Create SAP Fieldglass-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to SAP Fieldglass Data from Klipfolio and build custom visualizations using live SAP Fieldglass.
-
How to connect to Oracle SCM Data from IntelliJ
Integrate connectivity to Oracle SCM with wizards in IntelliJ.
-
Back Up RabbitMQ 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 RabbitMQ data.
-
Getting Started with the CData SSIS Components for Mixpanel
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Mixpanel.
-
How to use SQLAlchemy ORM to access Mailjet Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Mailjet.
-
Getting Started with the CData SSIS Components for Salesforce
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Salesforce.
-
Connect to Microsoft Entra ID from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Microsoft Entra ID, and over 250 other data sources, right inside your Excel and Google spreadsheets!