CData Software - Knowledge Base
Recent Articles
-
Replicate PagerDuty Data to Multiple Databases via the CData Sync CLI
Replicate PagerDuty data to disparate databases with a single configuration.
-
Getting Started with the CData Tableau Connector for ADP
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for ADP.
-
Consume Couchbase OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Couchbase feeds that reflect any changes in SAP Lumira.
-
Build an OLAP Cube in SSAS from CapsuleCRM Data
Establish a connection to CapsuleCRM data data from SQL Server Analysis Services, and use the CapsuleCRM Data Provider to build OLAP cubes for use in analytics and reporting.
-
How to connect and process Hacker News data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Hacker News data.
-
Create Quaderno Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Quaderno data access from reports, embedded analytics, and more.
-
Create a Data Access Object for Strava Data using JDBI
A brief overview of creating a SQL Object API for Strava data in JDBI.
-
Access Live SageHR Data in Roo Code via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Roo Code agents to securely access and build applications with live SageHR data through MCP integration.
-
Analyze Pingdom Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Pingdom data in Microsoft R Open.
-
Automated Continuous Salesforce CRM Analytics Replication to Vertica
Use CData Sync for automated, continuous, customizable Salesforce CRM Analytics replication to Vertica.
-
Analyze OData Services in Looker
Use CData Connect AI to connect to OData Services from Looker and build custom apps using live OData services.
-
Build a Singer.io Tap for CSV With the CData Python Connector
Learn how to easily build a Singer.io Tap for live CSV data using the CData Python Connector.
-
How to publish and share Clio Data dashboards with Tableau Server
The CData ODBC driver for Clio enables you integrate Clio data into Tableau dashboards.
-
Query Moosend Data in DataGrip
Create a Data Source for Moosend in DataGrip and use SQL to query live Moosend data.
-
Establish a Live Connection with Quickbase Data using Tableau Bridge
The CData ODBC Driver for Quickbase enables you to integrate live Quickbase data into Tableau Cloud dashboards using the Tableau Bridge.
-
Viewing Zoho Recruit Data in RAD Studio Data Explorer
How to view Zoho Recruit data in RAD Studio Data Explorer using the CData ODBC Driver for Zoho Recruit.
-
Integrate Live ChargeOver Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live ChargeOver data to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Use the CData Software ODBC Driver for SageHR in MicroStrategy Desktop
Connect to SageHR data in MicroStrategy Desktop using the CData Software ODBC Driver for SageHR.
-
Automated Continuous SageHR Replication to Databricks
Use CData Sync for automated, continuous, customizable SageHR replication to Databricks.
-
Integrate Oracle Sales with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Oracle Sales with External Services.
-
Analyze Miro Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Miro data in Microsoft R Open.
-
Integrate Aha! Data in Pentaho Data Integration
Build ETL pipelines based on Aha! data in the Pentaho Data Integration tool.
-
Use Dash to Build Web Apps on Sage 200 Data via CData Connect AI
Build interactive Dash web apps on live Sage 200 data using pandas and the CData Connect AI Python SDK.
-
Build Dashboards with Shopify Data in Dundas BI
Create dynamic dashboards and perform analytics based on Shopify data in Dundas BI.
-
Build DB2-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 DB2 data without replication.
-
Using the CData Software ODBC Driver for Intercom in PyCharm
Connect to Intercom as an ODBC data source in PyCharm using the CData Software ODBC Driver for Intercom.
-
Analyze ZohoMarketingHub Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze ZohoMarketingHub data in Microsoft R Open.
-
Connect to and Visualize Live Todoist Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Todoist data.
-
Automated Continuous FreshBooks Replication to Vertica
Use CData Sync for automated, continuous, customizable FreshBooks replication to Vertica.
-
Replicate Smartsheet Data to Multiple Databases via the CData Sync CLI
Replicate Smartsheet data to disparate databases with a single configuration.
-
Analyze ZohoInvoice Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for ZohoInvoice from Power Pivot. You will use the Table Import Wizard to load ZohoInvoice data. You can visually build the import query or use any SQL supported by the driver.
-
Use Databricks Agent Bricks to Talk to Your Bullhorn CRM Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Bullhorn CRM data for you.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Perigon
Provide connectivity to Perigon data through an SAP BusinessObjects universe.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for LDAP
Provide connectivity to LDAP objects through an SAP BusinessObjects universe.
-
Build Automated Workflows with Live Zuora Data in Workato
Use CData Connect AI to connect to live Zuora data and build automated workflows in Workato.
-
Visualize Basecamp Data in Tableau
The CData ODBC driver for Basecamp enables you integrate Basecamp data into Tableau dashboards.
-
Analyze Azure Synapse Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Azure Synapse data in Microsoft R Open.
-
Access Live Zoho Inventory Data in Excel 365 Online (Excel for the web)
Connect to Zoho Inventory data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
How to Connect to & Open PhantomBuster Data in Microsoft Excel
This article uses the CData ODBC driver for PhantomBuster to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Build Data Flows from RabbitMQ to SQL Server using SSIS
Easily back up RabbitMQ data to SQL Server using the SSIS components for RabbitMQ.
-
LINQ to Cloudant Data
LINQ offers versatile querying capabilities within the .NET Framework (v3.0+), offering a straightforward method for programmatic data access through CData ADO.NET Data Providers. In this article, we demonstrate the use of LINQ to retrieve information from the Cloudant Data Provider.
-
Connect to Salesloft Data in RazorSQL
Connect to Salesloft from wizards and query Salesloft data from the GUI in the RazorSQL database management tool.
-
Use the CData ODBC Driver for SAS xpt from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for SAS xpt to connect to SAS xpt data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring SAS xpt data in Excel.
-
How to Visualize Email Data in Python with pandas
Use pandas and other modules to analyze and visualize live Email data in Python.
-
Connect to Printify Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to Printify.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Telegram
Provide connectivity to Telegram data through an SAP BusinessObjects universe.
-
Bridge Reply.io Connectivity with Apache NiFi
Access and process Reply.io data in Apache NiFi using the CData JDBC Driver.
-
Query FTP Data as a SQL Server Database in Node.js
Execute SQL Server queries against FTP data from Node.js.
-
Rapidly Develop Webflow-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 Webflow.
-
Create IBM Informix-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to IBM Informix Data from OutSystems and build custom enterprise apps using live IBM Informix data.
-
Build Automated Kafka-Connected Workflows in Zapier
Use CData Connect AI to connect to live Kafka data and build automated workflows in Zapier.
-
Use the CData Software JDBC Driver for Oracle HCM Cloud in MicroStrategy Web
Connect to Oracle HCM Cloud data in MicroStrategy Web using the CData Software JDBC Driver for Oracle HCM Cloud.
-
Integrate Box Data into Power Automate Desktop using CData Connect
CData Connect for Box Data enables you to integrate Box data into workflows built using Microsoft Power Automate Desktop.
-
Excel Spreadsheet Automation on SAP Business Warehouse Data with the QUERY Formula
Pull data from SAP Business Warehouse, automate spreadsheets, and more with the QUERY formula.
-
Migrating data from Typeform to Google BigQuery using CData SSIS Components.
Easily push Typeform data to Google BigQuery using the CData SSIS Tasks for Typeform and Google BigQuery.
-
Connect to Real-Time SAP Netweaver Gateway Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for SAP Netweaver Gateway and Dataflow to import and use SAP Netweaver Gateway data in Power Apps.
-
Visualize Live LaunchDarkly Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live LaunchDarkly data.
-
Use Biml to Build SSIS Tasks to Replicate Splunk Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Splunk data to SQL Server.
-
Integrate with SendInBlue Data in JReport Designer
Create charts and reports based on SendInBlue data in JReport Designer.
-
View Reports on Real-Time Clari Data in Power BI Report Server
Use the CData ODBC Driver for Clari to visualize Clari data in Power BI Desktop and then publish them to Power BI Report Server.
-
Load Accelo Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Accelo data to a database.
-
Provide OData Services of Google Tasks Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Google Tasks data by developing a WCF Service Application.
-
Getting Started with the CData Tableau Connector for Amazon Athena
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Amazon Athena.
-
Consume Cvent OData Feeds in PowerBuilder
This article demonstrates how to consume Cvent data as OData feeds from PowerBuilder using the API Server.
-
Create SSAS Tabular Models from SharePoint Data
How to build a SQL Server Analysis Service Tabular Model from SharePoint data using CData drivers.
-
Integrating Codex with Microsoft Ads 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 HubDB Data in DBeaver
Use the CData ODBC Driver to connect to HubDB data in DBeaver.
-
Connect to Aha! Data from PowerBuilder via ADO.NET
This article demonstrates how to access Aha! data from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Manage Billsby Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Billsby.
-
Build MVC Applications with Connectivity to Google Translate Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Google Translate from an ASP.NET MVC application.
-
Stream Asana Data into Apache Kafka Topics
Access and stream Asana data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Visualize Spark Data in TIBCO Spotfire through ADO.NET
Integrate Spark data into dashboards in TIBCO Spotfire.
-
Automated Continuous SurveyMonkey Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable SurveyMonkey replication to Apache Cassandra.
-
Build Semantic Layer Views for Azure Data Catalog Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Azure Data Catalog data.
-
Load ZarMoney Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load ZarMoney data to a database.
-
Work with Klipfolio Data in FoxPro
Load Klipfolio data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Create a Data Access Object for Vercel Data using JDBI
A brief overview of creating a SQL Object API for Vercel data in JDBI.
-
Build Workday-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Workday data and build Workday-connected web apps with Axios.
-
Integrate Campaigner Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Campaigner data from Informatica Cloud.
-
Automated Continuous JobNimbus Replication to Vertica
Use CData Sync for automated, continuous, customizable JobNimbus replication to Vertica.
-
Connect to Adobe Commerce Data from AWS Glue
Use CData Connect AI to gain access to live Adobe Commerce data from your AWS Glue jobs.
-
Create Dashboards and Visualize Live Power BI XMLA Data in Geckoboard
Use CData Connect AI to connect to live Power BI XMLA data and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Integrating Codex with Short.io 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.
-
Connecting Pipedream with SQL Analysis Services Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Pipedream workflows to securely read and take actions on SQL Analysis Services data in real time.
-
Build eBay Analytics-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 eBay Analytics data without replication.
-
Analyze MailChimp Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for MailChimp from Power Pivot. You will use the Table Import Wizard to load MailChimp data. You can visually build the import query or use any SQL supported by the driver.
-
Bridge Chargebee Connectivity with Apache NiFi
Access and process Chargebee data in Apache NiFi using the CData JDBC Driver.
-
Analyze Freshdesk Data in Looker
Use CData Connect AI to connect to Freshdesk Data from Looker and build custom apps using live Freshdesk data.
-
Create Data Visualizations in Cognos BI with Microsoft Entra ID Data
Access Microsoft Entra ID data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Replicate Perplexity Data to Multiple Databases via the CData Sync CLI
Replicate Perplexity data to disparate databases with a single configuration.
-
Connect to Cosmos DB Data in NetBeans
Connect to Cosmos DB data in NetBeans with the data source configuration wizard.
-
Getting Started with the CData Python Connector for Optimizely
Learn to install and license the CData Python Connector and configure a connection to live Optimizely data.
-
Build Google Contacts-Connected Apps in Choreo
Use CData Connect AI to connect to Google Contacts Data from Choreo and build custom apps using live Google Contacts data.
-
Use Dash to Build to Web Apps on MarkLogic Data
Create Python applications that use pandas and Dash to build MarkLogic-connected web apps.
-
Create Certinia Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Certinia from PowerBI.com to create Power BI Dataflows with real-time data.
-
Create Zendesk-Connected Dashboards in Grafana
Connect to Zendesk Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Zendesk data.
-
How to Connect to Live SAP Netweaver Gateway 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 SAP Netweaver Gateway data for you.
-
Use the CData Software JDBC Driver for eBay in MicroStrategy Desktop
Connect to eBay data in MicroStrategy Desktop using the CData Software JDBC Driver for eBay.
-
Access Pinterest Data from MySQL in PHP
Connect to Pinterest through the standard MySQL libraries in PHP.
-
How to Connect Microsoft Ads 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 Microsoft Ads data in real time using natural language.