CData Software - Knowledge Base
Recent Articles
-
Connect to Omnisend Data in RapidMiner
Integrate Omnisend with standard components and data source configuration wizards in RapidMiner Studio.
-
Getting Started with the CData ODBC Driver for Customer.io
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Customer.io.
-
Create Dashboards and Visualize Live Kintone Data in Geckoboard
Use CData Connect AI to connect to live Kintone and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Automated Continuous Sybase IQ Replication to MongoDB
Use CData Sync for automated, continuous, customizable Sybase IQ replication to MongoDB.
-
Visualize Cohere Data in Sisense
Create an ElastiCube in Sisense app with access to Cohere.
-
Connect to Google Analytics Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Google Analytics as an External Source in Dremio.
-
Build a Singer.io Tap for Autopilot With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Autopilot data using
-
Automated Continuous CSV Replication to Databricks
Use CData Sync for automated, continuous, customizable CSV replication to Databricks.
-
Rapidly Develop Guru-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 Guru.
-
Act CRM Reporting in OBIEE with the Act CRM JDBC Driver
Deploy the Act CRM JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
How to Work with SpaceX Data in AWS Glue Jobs Using JDBC
Connect to SpaceX from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Use Dash to Build to Web Apps on Greenplum Data
Create Python applications that use pandas and Dash to build Greenplum-connected web apps.
-
Configure the CData JDBC Driver for IBM Informix in a Connection Pool in Tomcat
Connect to IBM Informix from a connection pool in Tomcat.
-
Replicate Pingdom Data from PowerShell
Write a quick PowerShell script to query Pingdom. Use connectivity to the live data to replicate Pingdom to SQL Server.
-
Integrating LlamaIndex with WooCommerce Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on WooCommerce in real time.
-
Access Live Presto Data in Emergent via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Emergent agents to securely access and build applications with live Presto through MCP integration.
-
How to Query Live Avalara AvaTax Data in Perplexity MacOS Desktop
Connect to and query live Avalara AvaTax Data in Perplexity Desktop using CData MCP Server.
-
Build WordPress Visualizations in Tableau Cloud
Use CData Connect AI to connect to live WordPress and build visualizations in Tableau Cloud.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Nuclia
Provide connectivity to Nuclia through an SAP BusinessObjects universe.
-
ETL Quaderno in Oracle Data Integrator
This article shows how to transfer Quaderno into a data warehouse using Oracle Data Integrator.
-
Build Charts with ConvertKit Data in Clear Analytics
Create dynamic charts and perform analytics based on ConvertKit in Clear Analytics.
-
Automated Continuous Microsoft Ads Replication to MySQL
Use CData Sync for automated, continuous, customizable Microsoft Ads replication to MySQL.
-
Connect to Microsoft Teams Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Microsoft Teams as an External Source in Dremio.
-
How to Access VWO Data Using Entity Framework
This article shows how to access VWO using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Perform Batch Operations with DB2 Data in Apache NiFi
Connect to IBM DB2 and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Automated Continuous Grafana Replication to MongoDB
Use CData Sync for automated, continuous, customizable Grafana replication to MongoDB.
-
Automated Continuous CData Connect AI Replication to Databricks
Use CData Sync for automated, continuous, customizable CData Connect AI replication to Databricks.
-
Design BIRT Reports on Snapchat Ads Data
Provide current Snapchat Ads to your embedded analytics.
-
Use the CData Software ODBC Driver for Teamgate in MicroStrategy
Connect to Teamgate in MicroStrategy Developer using the CData Software ODBC Driver for Teamgate.
-
Replicate Wrike Data in Heroku for Use in Salesforce Connect
Replicate Wrike to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Connect to Instantly Data in DBeaver
Use the CData ODBC Driver to connect to Instantly in DBeaver.
-
How to connect Amazon QuickSight to Pipedrive Data
Create a connection to Pipedrive in CData Connect AI and insert Pipedrive into Amazon QuickSight SPICE to build interactive dashboards.
-
Getting Started with the CData ADO.NET Provider for MailerSend
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Use Claude to Talk to Your Trello Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your Trello for you.
-
Use the CData ODBC Driver for Smartsheet from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Smartsheet to connect to Smartsheet from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Smartsheet in Excel.
-
Operational Reporting on Microsoft OneDrive Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Microsoft OneDrive.
-
Create Apps from Shopify Data in Qlik Sense Cloud
Use CData Connect AI to connect to Shopify Data and build apps from live Shopify in Qlik Sense Cloud.
-
How to Easily Query SurveyMonkey Data in OpenOffice Base
Connect to SurveyMonkey data in OpenOffice Base using the CData ODBC Driver for SurveyMonkey and generate reports with live data insights.
-
How to Connect the Power BI Service to Tally: Complete Guide
Connect to the CData Software Power BI Connector for Tally from PowerBI.com to provide real-time Tally ERP across the organization.
-
Build Dashboards with ShipStation Data in Dundas BI
Create dynamic dashboards and perform analytics based on ShipStation in Dundas BI.
-
Add WordPress Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for WordPress with the Informatica Enterprise Data Catalog to classify and organize data.
-
Brex Reporting in OBIEE with the Brex JDBC Driver
Deploy the Brex JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Automated Continuous eBay Analytics Replication to SQLite
Use CData Sync for automated, continuous, customizable eBay Analytics replication to SQLite.
-
Connect to Epicor Kinetic Data from PowerBuilder via ADO.NET
This article demonstrates how to access Epicor Kinetic from Appeon PowerBuilder using the CData ADO.NET Provider for Epicor Kinetic.
-
Connect to Google Spanner Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Getting Started with the CData Power BI Connector for Zoom
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Visualize Live Blackbaud FE NXT Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Blackbaud FE NXT using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Connect to Gmail from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Gmail, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Connect to ServiceNow Data in RazorSQL
Connect to ServiceNow from wizards and query ServiceNow from the GUI in the RazorSQL database management tool.
-
How to connect to MarkLogic Data from Spring Boot
Connect to MarkLogic in a Spring Boot Application using the CData JDBC Driver for MarkLogic
-
Integrate with Retently Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Retently to a JSON file on disk.
-
Connect to Guru Data in NetBeans
Connect to Guru in NetBeans with the data source configuration wizard.
-
Connect to Google Cloud Storage Data in JRuby
Create a simple JRuby app with access to live Google Cloud Storage.
-
Getting Started with the CData ODBC Driver for Keap
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Keap.
-
Query SendPulse Data in ColdFusion
Write standard ColdFusion data access code to connect to SendPulse.
-
Integrate with MYOB AccountRight Data in SnapLogic
Use CData Connect AI to connect to and integrate with live MYOB AccountRight in SnapLogic.
-
Connect to HBase Data in JRuby
Create a simple JRuby app with access to live Apache HBase.
-
Use the CData Software JDBC Driver for Presto in MicroStrategy Web
Connect to Presto in MicroStrategy Web using the CData Software JDBC Driver for Presto.
-
Connect to Invoiced from Asprova with CData Software ODBC Driver for Invoiced
This article shows how to connect faster to Invoiced data from Asprova.
-
Create Datasets from Hacker News in Domo Workbench and Build Visualizations of Hacker News Data in Domo
Use the CData Software ODBC Driver for Hacker News to create datasets from Hacker News in Domo Workbench and then build visualizations in the Domo service.
-
Work with SharePoint Data in FoxPro
Load Microsoft SharePoint into a FoxPro database. This article includes full code and a walk-through of the process.
-
How to Connect the Power BI Service to Facebook Ads: Complete Guide
Connect to the CData Software Power BI Connector for Facebook Ads from PowerBI.com to provide real-time Facebook Ads across the organization.
-
How to Connect to & Open Oracle Financials Cloud Data in Microsoft Excel
This article uses the CData ODBC driver for Oracle Financials Cloud to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Creating Instagram-Connected Applications in Unqork
You can use CData Connect AI to feed Instagram to Unqork and build custom business apps.
-
Build an OLAP Cube in SSAS from Pinterest Data
Establish a connection to Pinterest data from SQL Server Analysis Services, and use the Pinterest Data Provider to build OLAP cubes for use in analytics and reporting.
-
Build Automated Workflows with Live Salesforce Marketing Data in Workato
Use CData Connect AI to connect to live Salesforce Marketing Cloud and build automated workflows in Workato.
-
How to Query Cvent Data in MySQL Workbench
Execute MySQL queries against live Cvent from MySQL Workbench.
-
Migrating data from SAP Fieldglass to Google BigQuery using CData SSIS Components.
Easily push SAP Fieldglass to Google BigQuery using the CData SSIS Tasks for SAP Fieldglass and Google BigQuery.
-
Analyze Greenhouse Data in Infragistics Reveal
Use the CData API Server to create an OData API on top of Greenhouse and visualize live Greenhouse in Infragistics Reveal.
-
Moving Data from Azure Data Lake Storage to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Azure Data Lake Storage data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Analyze LDAP Objects in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze LDAP in Microsoft R Open.
-
Build Pipelines with Live Gong Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Gong from Google Cloud Data Fusion, enabling the integration of live Gong into the building and management of effective data pipelines.
-
Use JayDeBeApi to access Deel Data in Python
Use standard Python scripting and the development environment of your choice to access live Deel.
-
Connect to Freshteam in SpagoBI
Create reports featuring live Freshteam in SpagoBI Studio. Host Freshteam reports on SpagoBI Server.
-
Publish Reports with Gmail Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Gmail.
-
Connect to and Query DB2 Data in QlikView over ODBC
Create data visualizations with IBM DB2 in QlikView.
-
How to Connect to Live Xero Data in n8n Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable n8n to securely read and take actions on your Xero Accounting for you.
-
Analyze Spark Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Apache Spark SQL in Microsoft R Open.
-
Getting Started with the CData Connect AI Python SDK for Odoo
Install the CData Connect AI Python SDK to read and write live Odoo ERP with standard DB-API 2.0 Python code.
-
Connect to Snowflake in SpagoBI
Create reports featuring live Snowflake in SpagoBI Studio. Host Snowflake reports on SpagoBI Server.
-
Stream Figshare Data into Apache Kafka Topics
Access and stream Figshare in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Creating HCL Domino-Connected Applications in Unqork
You can use CData Connect AI to feed HCL Domino to Unqork and build custom business apps.
-
Natively Connect to Close Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Close. Leverage the native support for ODBC in PHP.
-
Create Google Ad Manager-Connected Business Apps in AppSheet
Connect to Google Ad Manager Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Google Ad Manager.
-
How to Connect to Live Microsoft Entra ID Data from Google ADK Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Google ADK agents to securely read and take actions on your Microsoft Entra ID for you.
-
Access Zoho CRM Data from MySQL in Amazon QuickSight
Connect to Zoho CRM and build visualizations of Zoho CRM using a MySQL Connection in Amazon QuickSight.
-
How to create Eventbrite federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Eventbrite in MySQL .
-
Connect to Bugsnag Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Bugsnag using standard SQL.
-
Integrate Real-Time Access to YouTube Analytics in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to YouTube Analytics in real time.
-
Use Agno to Talk to Your SAP Concur 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 SAP Concur for you.
-
Build a Singer.io Tap for SageHR With the CData Python Connector
Learn how to easily build a Singer.io Tap for live SageHR data using
-
Build Apps with Live Salesforce Pardot Data Using the Low-Code Development Platform of Mendix
Connect Salesforce Pardot with Mendix to build apps using the CData JDBC Driver for Salesforce Pardot.
-
Bridge ZohoInvoice Connectivity with Apache NiFi
Access and process ZohoInvoice in Apache NiFi using the CData JDBC Driver.
-
DataBind Webex Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Webex to a chart.
-
Prepare, Blend, and Analyze Elasticsearch Data in Alteryx Designer (Connect AI)
Build workflows to access live Elasticsearch for self-service data analytics.
-
Getting Started with the CData JDBC Driver for Reckon Accounts Hosted
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Reckon Accounts Hosted.
-
How to connect to Email Data in DBVisualizer
Integrate Email with visual data analysis tools and data connection wizards in DBVisualizer
-
Use the CData Software ODBC Driver for HelloSign in SAS for Real-Time Reporting and Analytics
Connect to real-time HelloSign in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for HelloSign.
-
Create SAP ByDesign Dataflows on PowerBI.com
Connect to the CData Power BI Connector for SAP ByDesign from PowerBI.com to create Power BI Dataflows with real-time data.
-
How to connect to Parallel Data from Spring Boot
Connect to Parallel in a Spring Boot Application using the CData API Driver for JDBC