CData Software - Knowledge Base
Recent Articles
-
Query Live Samanage Data in Perplexity Desktop via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Perplexity Desktop to securely access and query live Samanage data through a conversational interface.
-
Access Optimizely Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Optimizely data from HeidiSQL.
-
Build AI/ML Models with Live Azure Data Catalog Data using Dataiku
Connect Azure Data Catalog Data with Dataiku using the CData JDBC Driver for Azure Data Catalog.
-
Use the CData ODBC Driver for Gong from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Gong to connect to Gong data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Gong data in Excel.
-
Back Up Amazon S3 data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Amazon S3. In this article, we will employ an SSIS workflow to populate a database with Amazon S3 data data.
-
Connect to RabbitMQ in SpagoBI
Create reports featuring live RabbitMQ data in SpagoBI Studio. Host RabbitMQ reports on SpagoBI Server.
-
Integrate Hive with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Hive with External Services.
-
Connect to Phoenix Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Phoenix data.
-
Integrate Trae with Live Aweber Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Trae to securely access and query live Aweber data from within the AI-powered IDE.
-
Build Charts with HelloSign Data in Clear Analytics
Create dynamic charts and perform analytics based on HelloSign data in Clear Analytics.
-
Automate HDFS Integration Tasks from PowerShell
Are you in search of a quick and easy way to access HDFS data from PowerShell? This article demonstrates how to utilize the HDFS Cmdlets for tasks like connecting to HDFS data, automating operations, downloading data, and more.
-
Build QuickBooks Online-Connected Apps in Choreo
Use CData Connect AI to connect to QuickBooks Online Data from Choreo and build custom apps using live QuickBooks Online data.
-
Use Biml to Build SSIS Tasks to Replicate xBase Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate xBase data to SQL Server.
-
How to integrate Metabase with Sugar CRM Data
Use CData Connect AI to connect to live Sugar CRM data and create an interactive dashboard in Metabase from Sugar CRM data.
-
Integrate with MessageBird Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy MessageBird data to a JSON file on disk.
-
How to Seamlessly Import Azure Data Lake Storage Data into IBM SPSS Modeler
Integrate Azure Data Lake Storage data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Automate Facebook Ads Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Facebook Ads data from PowerShell? This article demonstrates how to utilize the Facebook Ads Cmdlets for tasks like connecting to Facebook Ads data, automating operations, downloading data, and more.
-
Getting Started with the CData JDBC Driver for Impala
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Impala.
-
Natively Connect to Typeform Data in PHP
The CData ODBC driver for Typeform enables you to create PHP applications with connectivity to Typeform data. Leverage the native support for ODBC in PHP.
-
Create Reports with WordPress Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date WordPress data.
-
How to Work with Pushbullet Data in AWS Glue Jobs Using JDBC
Connect to Pushbullet from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Easily Integrate SAP BusinessObjects BI Data in Lazarus Pascal IDE
Learn how to easily integrate live SAP BusinessObjects BI data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Getting Started with the CData Connect AI Python SDK for eBay Analytics
Install the CData Connect AI Python SDK to read live eBay Analytics data with standard DB-API 2.0 Python code.
-
Create SSAS Tabular Models from Zoho Projects Data
How to build a SQL Server Analysis Service Tabular Model from Zoho Projects data using CData drivers.
-
Build Apps with Live Sugar CRM Data Using the Low-Code Development Platform of Mendix
Connect Sugar CRM data with Mendix to build apps using the CData JDBC Driver for Sugar CRM.
-
How to connect to Chargebee Data in DBVisualizer
Integrate Chargebee data with visual data analysis tools and data connection wizards in DBVisualizer
-
Integrating GitHub Copilot with Vercel 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.
-
Query Wave Financial Data as a SQL Server Database in Node.js
Execute SQL Server queries against Wave Financial data from Node.js.
-
Getting Started with the CData JDBC Driver for Google Search
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Google Search.
-
Operational Reporting on SAS xpt Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote SAS xpt data.
-
Load Microsoft Ads Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Microsoft Ads data to a database.
-
How to integrate Metabase with HBase Data
Use CData Connect AI to connect to live HBase data and create an interactive dashboard in Metabase from HBase data.
-
Build a Simple VCL Application for Cloudant Data
How to build a simple VCL Application to view Cloudant data in RAD Studio using the CData ODBC Driver for Cloudant.
-
Create SAP BusinessObjects BI-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to SAP BusinessObjects BI Data from Klipfolio and build custom visualizations using live SAP BusinessObjects BI data.
-
How to Connect to Live Zoho Books Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Zoho Books data securely in real time.
-
Build Dashboards with Bitbucket Data in DBxtra
Create dynamic dashboards and perform analytics based on Bitbucket data in DBxtra.
-
Build Google Forms-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Google Forms data.
-
Rapidly Develop TaxJar-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 TaxJar.
-
Automated Continuous EmailOctopus Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable EmailOctopus replication to Apache Cassandra.
-
Create Reports with BenchmarkEmail Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date BenchmarkEmail data.
-
Automated Continuous NetSuite Replication to MySQL
Use CData Sync for automated, continuous, customizable NetSuite replication to MySQL.
-
Connect Unbounce to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Unbounce with IBM WebSphere for seamless data integration and connectivity.
-
Write a Simple Go Application to work with Egnyte Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Egnyte data.
-
Connect to Paymo Data in RapidMiner
Integrate Paymo data with standard components and data source configuration wizards in RapidMiner Studio.
-
Natively Connect to Gumroad Data in PHP
The CData ODBC driver for Gumroad enables you to create PHP applications with connectivity to Gumroad data. Leverage the native support for ODBC in PHP.
-
Search External Confluence Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Confluence data to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Confluence Data objects that you can access from apps and the dashboard.
-
Connect to and Query Pingdom Data in QlikView over ODBC
Create data visualizations with Pingdom data in QlikView.
-
Natively Connect to Adobe Experience Manager Data in PHP
The CData ODBC driver for Adobe Experience Manager enables you to create PHP applications with connectivity to Adobe Experience Manager data. Leverage the native support for ODBC in PHP.
-
How to Access REST Data Using Entity Framework
This article shows how to access REST data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Automated Continuous ZendeskSell Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable ZendeskSell replication to Google BigQuery.
-
Validate Teamgate Data with QuerySurge
Access and validate Teamgate data in QuerySurge using the CData JDBC Driver.
-
Access Confluence Data from MySQL in Amazon QuickSight
Connect to Confluence and build visualizations of Confluence data using a MySQL Connection in Amazon QuickSight.
-
Automated Continuous Sybase IQ Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Sybase IQ replication to PostgreSQL.
-
Connect to Sage 200 Data from PowerBuilder via JDBC
This article demonstrates how to access Sage 200 data from PowerBuilder using the Sage 200 JDBC Driver.
-
Access Live Testmonitor Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Testmonitor data from your Excel spreadsheets.
-
Integrating Boomi Agentstudio with SAS Data Sets Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to SAS Data Sets data, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Automated Continuous ChartMogul Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable ChartMogul replication to Apache Kafka.
-
Build Automated Redshift-Connected Workflows in Zapier
Use CData Connect AI to connect to live Redshift data and build automated workflows in Zapier.
-
Integrating OpenCode with BigCommerce 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.
-
Bridge Missive Connectivity with Apache NiFi
Access and process Missive data in Apache NiFi using the CData JDBC Driver.
-
Query, Visualize, and Share live LinkedIn Data in Redash
Use CData Connect AI to connect to live LinkedIn data in Redash for querying, visualizing, and sharing.
-
Automated Continuous ZohoPeople Replication to Oracle
Use CData Sync for automated, continuous, customizable ZohoPeople replication to Oracle.
-
Integrate Oracle Eloqua Reporting Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Oracle Eloqua Reporting data from Informatica Cloud.
-
Access Live SAP HANA XS Advanced Data in AWS Lambda
Connect to live SAP HANA XS Advanced data in AWS Lambda using the CData JDBC Driver.
-
How to connect PolyBase to Moosend
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Moosend data.
-
Access Mailjet 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 Mailjet data.
-
Automated Continuous Google Translate Replication to Oracle
Use CData Sync for automated, continuous, customizable Google Translate replication to Oracle.
-
Use Biml to Build SSIS Tasks to Replicate Hugging Face Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Hugging Face data to SQL Server.
-
Build an OLAP Cube in SSAS from Oracle SCM Data
Establish a connection to Oracle SCM data data from SQL Server Analysis Services, and use the Oracle SCM Data Provider to build OLAP cubes for use in analytics and reporting.
-
Use Biml to Build SSIS Tasks to Replicate PostgreSQL Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate PostgreSQL data to SQL Server.
-
How to connect to JSON Services from Spring Boot
Connect to JSON in a Spring Boot Application using the CData JDBC Driver for JSON
-
Visualize Landbot 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 Landbot data into TIBCO Spotfire.
-
How to Connect to Live Redshift 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 Redshift data for you.
-
Getting Started with the CData JDBC Driver for Gumroad
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Gumroad.
-
Prepare, Blend, and Analyze Blackbaud FE NXT Data in Alteryx Designer (ODBC)
Build workflows to access live Blackbaud FE NXT data for self-service data analytics.
-
Connect and Query Live Box Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Box data into Databricks and enable direct, live querying and analysis without replication.
-
Trigger HBase IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for HBase with standard wizards in Logic Apps.
-
Automate Optimizely Data Replication to SAP HANA
Use CData Sync to customize and automate Optimizely data replication to SAP HANA.
-
Use the CData Software JDBC Driver for Deel in MicroStrategy Web
Connect to Deel data in MicroStrategy Web using the CData Software JDBC Driver for Deel.
-
Configure the CData JDBC Driver for FormSite in a Connection Pool in Tomcat
Connect to FormSite data from a connection pool in Tomcat.
-
Use the CData Software JDBC Driver for Mailgun in MicroStrategy
Connect to Mailgun data in MicroStrategy Developer using the CData Software JDBC Driver for Mailgun.
-
How to Easily Query Salesforce Pardot Data in OpenOffice Base
Connect to Salesforce Pardot data in OpenOffice Base using the CData ODBC Driver for Salesforce Pardot and generate reports with live data insights.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Campaigner
Provide connectivity to Campaigner data through an SAP BusinessObjects universe.
-
Build Snapchat Ads-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 Snapchat Ads data without replication.
-
Use Dash to Build to Web Apps on NetSuite Data
Create Python applications that use pandas and Dash to build NetSuite-connected web apps.
-
Build Adobe Experience Manager-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Adobe Experience Manager data.
-
Getting Started with the CData JDBC Driver for ClickTime
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for ClickTime.
-
Automated Continuous Pingdom Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Pingdom replication to Amazon Redshift.
-
Connect to SAP HANA XS Advanced Data in Ruby
Connect to SAP HANA XS Advanced data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Query Amazon Marketplace Data as a SQL Server Database in Node.js
Execute SQL Server queries against Amazon Marketplace data from Node.js.
-
Visualize Instagram 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 Instagram data into TIBCO Spotfire.
-
Automated Continuous Dynamics 365 Business Central Replication to Databricks
Use CData Sync for automated, continuous, customizable Dynamics 365 Business Central replication to Databricks.
-
Integrate PostgreSQL with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate PostgreSQL with External Services.
-
Create Pipeline CRM Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Pipeline CRM data access from reports, embedded analytics, and more.
-
Natively Connect to Cloudant Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Cloudant data. Leverage the native support for ODBC in PHP.
-
Visualize Live SendPulse Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live SendPulse data.
-
Connect to Strava Data in Aqua Data Studio
Access Strava data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Work with Dropbox Data in FoxPro
Load Dropbox data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Build Impala Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Impala data and build visualizations in Tableau.
-
Automated Continuous Gong Replication to Oracle
Use CData Sync for automated, continuous, customizable Gong replication to Oracle.