CData Software - Knowledge Base
Recent Articles
-
Rapidly Develop Sentry-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 Sentry.
-
Back Up Attio 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 Attio data.
-
Access Live REST Data in TIBCO Data Virtualization
Use the REST Tibco DV Adapter to create a REST data source in TIBCO Data Virtualization Studio and gain access to live REST from your TDV Server.
-
Use the CData ODBC Driver for Invoiced in Microsoft Power Query
You can use the CData Invoiced ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Invoiced into Microsoft Power Query.
-
How to connect PolyBase to MailChimp
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live MailChimp.
-
Deploy the ADO.NET Provider for ZohoExpense on an SSRS Report Server
Connect to ZohoExpense from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.
-
Use Agno to Talk to Your Google Directory Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Agno agents to securely answer questions and take actions on your Google Directory for you.
-
How to Access SAP Netweaver Gateway Data Using Entity Framework
This article shows how to access SAP Netweaver Gateway using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Connect to Productboard Data in NetBeans
Connect to Productboard in NetBeans with the data source configuration wizard.
-
Publish Crystal Reports on Optimizely Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Optimizely.
-
Import Real-Time MailerLite Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use MailerLite in ColdFusion.
-
Visualize Moosend Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Moosend.
-
Back Up SharePoint Excel Services to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for SharePoint Excel Services. In this article, we will employ an SSIS workflow to populate a database with SharePoint Excel Services data.
-
Query Eventbrite Data as a MySQL Database in Node.js
Execute MySQL queries against Eventbrite from Node.js.
-
Build an OLAP Cube in SSAS from AlloyDB Data
Establish a connection to Google AlloyDB data from SQL Server Analysis Services, and use the AlloyDB Data Provider to build OLAP cubes for use in analytics and reporting.
-
Configure the CData JDBC Driver for eBay Analytics in a Connection Pool in Tomcat
Connect to eBay Analytics from a connection pool in Tomcat.
-
How to Connect to & Open HBase Data in Microsoft Excel
This article uses the CData ODBC driver for HBase to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Connect to ZohoMarketingHub Data from a Connection Pool in Jetty
The ZohoMarketingHub JDBC Driver supports connection pooling: This article shows how to connect faster to ZohoMarketingHub from Web apps in Jetty.
-
Build HubSpot Visualizations in Tableau Cloud
Use CData Connect AI to connect to live HubSpot and build visualizations in Tableau Cloud.
-
Access Vercel Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Vercel from HeidiSQL.
-
Use the CData SSIS Components to Insert New or Update Existing CockroachDB Records from SQL Server
Easily push SQL Server data to CockroachDB using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into CockroachDB or update existing records with data from a SQL Server database.
-
DataBind Controls to Recurly Data in C++Builder
DataBind to Recurly in C++Builder with standard components and controls.
-
Working with Mouseflow Data in LINQPad
Execute LINQ queries to Mouseflow in LINQPad.
-
Publish Crystal Reports on SparkPost Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date SparkPost.
-
Visualize Amazon Marketplace Data in Sisense
Create an ElastiCube in Sisense app with access to Amazon Marketplace.
-
Enable the ZohoExpense JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with ZohoExpense.
-
Analyze Live Oracle Service Cloud Data in SAS Viya
Use CData Connect AI to connect to Oracle Service Cloud from SAS Viya and deploy self-service analytics using live Oracle Service Cloud.
-
Build Voice Agents in ElevenLabs with access to Live Trello Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Trello.
-
Natively Connect to Marketo Data in PHP
The CData ODBC driver for Marketo enables you to create PHP applications with connectivity to Marketo. Leverage the native support for ODBC in PHP.
-
Connect CampaignMonitor Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your CampaignMonitor using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Use the CData Software JDBC Driver for Rebilly in MicroStrategy Desktop
Connect to Rebilly in MicroStrategy Desktop using the CData Software JDBC Driver for Rebilly.
-
Import Real-Time Auth0 Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Auth0 in ColdFusion.
-
Analyze Pinterest Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Pinterest and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Access Spotify Data from MySQL in PHP
Connect to Spotify through the standard MySQL libraries in PHP.
-
Visualize Marketo Data in Sisense
Create an ElastiCube in Sisense app with access to Marketo.
-
Connecting GenSpark with Vertica Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Vertica without any replication or custom integration required.
-
Excel Spreadsheet Automation on Billsby Data with the QUERY Formula
Pull data from Billsby, automate spreadsheets, and more with the QUERY formula.
-
Build Dashboards with Webflow Data in DBxtra
Create dynamic dashboards and perform analytics based on Webflow in DBxtra.
-
Getting Started with the CData Tableau Connector for Demio
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
SparkPost Reporting in OBIEE with the SparkPost JDBC Driver
Deploy the SparkPost JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Publish Marketo-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Marketo.
-
Integrate with Grafana Data in JReport Designer
Create charts and reports based on Grafana in JReport Designer.
-
Automated Continuous Microsoft Exchange Replication to SQLite
Use CData Sync for automated, continuous, customizable Microsoft Exchange replication to SQLite.
-
Use the CData Software ODBC Driver for Spotify in MicroStrategy Desktop
Connect to Spotify in MicroStrategy Desktop using the CData Software ODBC Driver for Spotify.
-
Connect to BigQuery Data in Jaspersoft Studio
Execute SQL to remote Google BigQuery in Jaspersoft Studio.
-
Getting Started with the CData Excel Add-In for Authorize.Net
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Authorize.Net.
-
Connecting GenSpark with SQL Analysis Services Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to SQL Analysis Services without any replication or custom integration required.
-
How to load Amazon Marketplace data into Elasticsearch via Logstash
Introducing a simple method to load Amazon Marketplace data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
How to Build an ETL App for Snapchat Ads Data in Python with CData
Create ETL applications and real-time data pipelines for Snapchat Ads in Python with petl.
-
How to Query Excel Online Data in MySQL Workbench
Execute MySQL queries against live Microsoft Excel Online from MySQL Workbench.
-
Build AI Agents with BigCommerce Data in IBM watsonx Orchestrate using CData Connect AI
Learn how to build intelligent agents in IBM watsonx Orchestrate that can securely access and act on live BigCommerce through CData Connect AI.
-
Create Reports from DocuSign Data in Looker Studio
Use CData Connect AI to gain access to live DocuSign and create custom reports in Looker Studio.
-
Automated Continuous eBay Replication to MySQL
Use CData Sync for automated, continuous, customizable eBay replication to MySQL.
-
Add Adobe Experience Manager Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Adobe Experience Manager with the Informatica Enterprise Data Catalog to classify and organize data.
-
Seamlessly Bring YouTube Analytics Data into Retool Using CData Connect AI
Integrate YouTube Analytics data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Connect to Stack Exchange Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Stack Exchange.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Zuora using the Model Context Protocol.
-
Query Smartsheet Data in ColdFusion
Write standard ColdFusion data access code to connect to Smartsheet.
-
Integrating Boomi Agentstudio with Azure DevOps Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Azure DevOps, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Import Real-Time Zoho Projects Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Zoho Projects in ColdFusion.
-
Connect to Blackbaud FE NXT Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Blackbaud FE NXT in the Denodo Virtual DataPort Administrator.
-
Connect to and Visualize Live Act CRM Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Act CRM.
-
How to Create Power BI Visual Reports with Real-Time Pipedrive Data
Use CData Power BI Connectors to visualize Pipedrive in Power BI.
-
Moving Data from AlloyDB to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live AlloyDB data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Connecting Mastra with Raisers Edge NXT Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to enable Mastra agents to securely query, read, and act on real-time Raisers Edge NXT, no replication required.
-
Moving Data from Zoho Creator to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Zoho Creator data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Integrate FreshBooks Data in the Pentaho Report Designer
Publish reports based on FreshBooks in the Pentaho BI tool.
-
How to Query Live WordPress Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live WordPress data in natural language using Python.
-
Connect to Pipeliner CRM Data from a Connection Pool in Jetty
The Pipeliner CRM JDBC Driver supports connection pooling: This article shows how to connect faster to Pipeliner CRM from Web apps in Jetty.
-
Getting Started with the CData Tableau Connector for Google Contacts
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Google Contacts.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Sybase IQ
Provide connectivity to Sybase IQ through an SAP BusinessObjects universe.
-
Build Drift-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Drift and build web apps with connectivity to live Drift.
-
Automated Continuous Figshare Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Figshare replication to Google Cloud SQL.
-
Integrating GitHub Copilot CLI with Superchat 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 Dashboards and Visualize Live Jira Assets Data in Geckoboard
Use CData Connect AI to connect to live Jira Assets and create dashboards for real-time monitoring and visualization in Geckoboard.
-
How to load Procore data into Elasticsearch via Logstash
Introducing a simple method to load Procore data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Consume ADP OData Feeds in SAP Lumira
Use the API Server to create data visualizations on ADP feeds that reflect any changes in SAP Lumira.
-
Migrating data from Apify to Snowflake using CData SSIS Components.
Easily push Apify to Snowflake using the CData SSIS Tasks for Apify and Snowflake.
-
Integrate Dynamics 365 Business Central Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Dynamics 365 Business Central from Informatica Cloud.
-
Integrate Goose with Live Pipedrive Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Pipedrive from within the local AI agent.
-
How to publish and share ServiceDesk Plus Data dashboards with Tableau Server
The CData ODBC driver for ServiceDesk Plus enables you integrate ServiceDesk Plus into Tableau dashboards.
-
Connect to Webflow Data in DBArtisan
Use wizards in DBArtisan to configure Webflow as a data source.
-
Integrate Cline with Live Procore Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Procore from within your IDE.
-
Automated Continuous MongoDB Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable MongoDB replication to Amazon Redshift.
-
Replicate Multiple Salesforce CRM Analytics Accounts
Replicate multiple Salesforce CRM Analytics accounts to one or many databases.
-
Connect to MailerSend Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Integrating Cursor CLI with PayPal 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 MailChimp from a Connection Pool in WebLogic
Use the CData JDBC Driver for MailChimp to connect to MailChimp from Web applications running on WebLogic.
-
Analyze Shippo Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Shippo with the CData JDBC Driver for Shippo.
-
Use Dash to Build to Web Apps on Amazon Marketplace Data
Create Python applications that use pandas and Dash to build Amazon Marketplace-connected web apps.
-
Connect to and Query Zoho Recruit Data in QlikView over ODBC
Create data visualizations with Zoho Recruit in QlikView.
-
Use the CData Software ODBC Driver for BigQuery in MicroStrategy
Connect to Google BigQuery in MicroStrategy Developer using the CData Software ODBC Driver for BigQuery.
-
How to publish and share Twilio Data dashboards with Tableau Server
The CData ODBC driver for Twilio enables you integrate Twilio into Tableau dashboards.
-
How to Visualize SAP Fieldglass Data in Python with pandas
Use pandas and other modules to analyze and visualize live SAP Fieldglass in Python.
-
View Reports on Real-Time MariaDB Data in Power BI Report Server
Use the CData ODBC Driver for MariaDB to visualize MariaDB in Power BI Desktop and then publish them to Power BI Report Server.
-
Automate SpaceX Data Replication to SAP HANA
Use CData Sync to customize and automate SpaceX replication to SAP HANA.
-
Use Manus AI to Talk to Your CockroachDB Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Manus AI agents to securely answer questions and take actions on CockroachDB.
-
Automated Continuous Perplexity Replication to MongoDB
Use CData Sync for automated, continuous, customizable Perplexity replication to MongoDB.
-
Connect to SAP Fieldglass Data in Google Apps Script via Connect AI
Use CData Connect AI to access SAP Fieldglass in Google Apps Script.
-
Excel Spreadsheet Automation on Odoo Data with the QUERY Formula
Pull data from Odoo, automate spreadsheets, and more with the QUERY formula.