CData Software - Knowledge Base
Recent Articles
-
Prepare, Blend, and Analyze AdRoll Data in Alteryx Designer (ODBC)
Build workflows to access live AdRoll data for self-service data analytics.
-
Write a Simple Go Application to work with Google Analytics Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Google Analytics data.
-
Build Apps with Live SurveyMonkey data in Adalo using CData Connect AI
Use CData Connect AI to integrate live SurveyMonkey data into the Adalo platform and build custom mobile and web applications with real-time SurveyMonkey data.
-
Connect to Act CRM Data from Crystal Reports
Use CData Connect AI to connect to and report on live Act CRM data from Crystal Reports.
-
Integrate Live Cvent Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Cvent from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Cvent data.
-
Migrating data from Facebook to Snowflake using CData SSIS Components.
Easily push Facebook data to Snowflake using the CData SSIS Tasks for Facebook and Snowflake.
-
Integrating Gumloop with Timely Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Timely data within automated workflows.
-
How to Visualize Mixpanel Data in Python with pandas
Use pandas and other modules to analyze and visualize live Mixpanel data in Python.
-
A PostgreSQL Interface for Reckon Accounts Hosted Data (MySQL Remoting via JDBC)
Use the Remoting features of the Reckon Accounts Hosted JDBC Driver to create a PostgreSQL entry-point for data access.
-
Connect and Query Live Highrise Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Highrise data into Databricks and enable direct, live querying and analysis without replication.
-
Build AI Agents with SAP Business Warehouse 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 SAP Business Warehouse data through CData Connect AI.
-
Integrate with live Vault CRM Data in Jitterbit
Use CData Connect AI to connect to and integrate live Vault CRM data in Jitterbit.
-
Access Live Campaigner 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 Campaigner data through MCP integration.
-
Visualize SAP Business One Data in Sisense
Create an ElastiCube in Sisense app with access to SAP Business One data.
-
Build an OLAP Cube in SSAS from Parquet Data
Establish a connection to Parquet data data from SQL Server Analysis Services, and use the Parquet Data Provider to build OLAP cubes for use in analytics and reporting.
-
Import Real-Time SAP Fieldglass Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use SAP Fieldglass data in ColdFusion.
-
Integrate Live SAP SuccessFactors LMS Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf's Cascade agent to securely access and query live SAP SuccessFactors LMS data from within the IDE.
-
Work with Live Bitly Data in Power Query
Use CData Connect AI to connect to Bitly data and work with live Bitly data in Microsoft Power Query.
-
Create Dashboards and Visualize Live Splunk Data in Geckoboard
Use CData Connect AI to connect to live Splunk data and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Replicate Multiple Hugging Face Accounts
Replicate multiple Hugging Face accounts to one or many databases.
-
Integrate Theia IDE with Live Dynamics NAV Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE's built-in AI agents to securely access and query live Dynamics NAV data from within the development environment.
-
Connect to Clio Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Clio to connect to Clio data and execute queries in PowerBuilder.
-
Replicate Epicor Kinetic Data to Multiple Databases
Replicate Epicor Kinetic data to disparate databases with a point-and-click configuration.
-
Build an OLAP Cube in SSAS from ChargeOver Data
Establish a connection to ChargeOver data data from SQL Server Analysis Services, and use the ChargeOver Data Provider to build OLAP cubes for use in analytics and reporting.
-
Publish Box-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Box data.
-
Automated Continuous Sage Intacct Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Sage Intacct replication to Azure SQL Database.
-
Connect to Codat Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Codat as an External Source in Dremio.
-
Build PagerDuty-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live PagerDuty data.
-
Access Live Google Ads Data in Excel 365 Online (Excel for the web)
Connect to Google Ads data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Create Dashboards and Visualize Live Authorize.Net Data in Geckoboard
Use CData Connect AI to connect to live Authorize.Net data and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Build Semantic Layer Views for Jodoo Data in APOS Live Data Gateway
Use the CData Connector for Jodoo in APOS Live Data Gateway to build Semantic Layer Views for Jodoo data.
-
How to Connect Bullhorn CRM 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 Bullhorn CRM data in real time using natural language.
-
How to Create Power BI Visual Reports with Real-Time Zuora Data
Use CData Power BI Connectors to visualize Zuora data in Power BI.
-
Using the CData Software ODBC Driver for Quaderno in PyCharm
Connect to Quaderno as an ODBC data source in PyCharm using the CData Software ODBC Driver for Quaderno.
-
Visualize Confluence 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 Confluence data into TIBCO Spotfire.
-
Access GitLab Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live GitLab data from HeidiSQL.
-
Stream Tickspot Data into Apache Kafka Topics
Access and stream Tickspot data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
How to connect PolyBase to Superchat
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Superchat data.
-
Build a Singer.io Tap for MySQL With the CData Python Connector
Learn how to easily build a Singer.io Tap for live MySQL data using the CData Python Connector.
-
Moving Data from Mocean to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Mocean data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Automated Continuous Zoho CRM Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Zoho CRM replication to IBM DB2.
-
How to Access Live GitLab Data in Power Automate Desktop via ODBC
The CData ODBC Driver for GitLab enables you to integrate GitLab data into workflows built using Microsoft Power Automate Desktop.
-
Replicate Hugging Face Data to Multiple Databases via the CData Sync CLI
Replicate Hugging Face data to disparate databases with a single configuration.
-
Connect to and Query SuiteCRM Data in QlikView over ODBC
Create data visualizations with SuiteCRM data in QlikView.
-
Visualize Impala Data in Tableau
The CData ODBC driver for Impala enables you integrate Impala data into Tableau dashboards.
-
Integrate with Square Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Square data in SnapLogic.
-
DataBind Controls to Wistia Data in C++Builder
DataBind to Wistia data in C++Builder with standard components and controls.
-
Analyze Live PolarTeamPro Data in SAS Viya
Use CData Connect AI to connect to PolarTeamPro data from SAS Viya and deploy self-service analytics using live PolarTeamPro data.
-
Publish Reports with ZendeskSell Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date ZendeskSell data.
-
Access Live Xero Data in AWS Lambda
Connect to live Xero data in AWS Lambda using the CData JDBC Driver.
-
Mailjet Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Mailjet facts in real time.
-
Access AgileCRM Data from MySQL in Amazon QuickSight
Connect to AgileCRM and build visualizations of AgileCRM data using a MySQL Connection in Amazon QuickSight.
-
Query, Visualize, and Share live GitLab Data in Redash
Use CData Connect AI to connect to live GitLab data in Redash for querying, visualizing, and sharing.
-
Establish a Live Connection with Azure DevOps Data using Tableau Bridge
The CData ODBC Driver for Azure DevOps enables you to integrate live Azure DevOps data into Tableau Cloud dashboards using the Tableau Bridge.
-
Integrating LangChain with Google Directory Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Google Directory data within automated workflows.
-
Create Apps from SharePoint Data in Qlik Sense Cloud
Use CData Connect AI to connect to SharePoint Data and build apps from live SharePoint data in Qlik Sense Cloud.
-
Query Live Azure Data Lake Storage 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 Azure Data Lake Storage data through a conversational interface.
-
Connect to ZohoPeople Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live ZohoPeople data from Filemaker Pro on Mac.
-
Connect to Missive in SpagoBI
Create reports featuring live Missive data in SpagoBI Studio. Host Missive reports on SpagoBI Server.
-
Connect Sybase IQ to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Sybase IQ data using the CData Python MCP Server.
-
Connect to and Query Short.io Data in QlikView over ODBC
Create data visualizations with Short.io data in QlikView.
-
Automated Continuous CapsuleCRM Replication to SingleStore
Use CData Sync for automated, continuous, customizable CapsuleCRM replication to SingleStore.
-
LINQ to xBase 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 xBase Data Provider.
-
Automated Continuous SAP HANA XS Advanced Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable SAP HANA XS Advanced replication to Apache Kafka.
-
Integrating Dataiku with Salesforce Marketing Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Salesforce Marketing data.
-
Getting Started with the CData Tableau Connector for Kintone
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Kintone.
-
How to Connect the Power BI Service to LinkedIn: Complete Guide
Connect to the CData Software Power BI Connector for LinkedIn from PowerBI.com to provide real-time LinkedIn data across the organization.
-
Automated Continuous Twitter Ads Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Twitter Ads replication to Amazon S3.
-
Automated Continuous Foursquare Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Foursquare replication to PostgreSQL.
-
Connect to Act-On Data in RapidMiner
Integrate Act-On data with standard components and data source configuration wizards in RapidMiner Studio.
-
DataBind Deel Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Deel data to a chart.
-
Analyze ChargeOver Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze ChargeOver data in Microsoft R Open.
-
How to work with HelloSign Data in Apache Spark using SQL
Access and process HelloSign Data in Apache Spark using the CData Software JDBC Driver.
-
Prepare, Blend, and Analyze SingleStore Data in Alteryx Designer (ODBC)
Build workflows to access live SingleStore data for self-service data analytics.
-
Automated Continuous Reckon Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Reckon replication to IBM DB2.
-
Build Data Flows from Flowlu to SQL Server using SSIS
Easily back up Flowlu data to SQL Server using the SSIS components for Flowlu.
-
Publish Crystal Reports on Quaderno Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Quaderno data.
-
Import GitLab Data Using Azure Data Factory
Use CData Connect AI to connect to GitLab Data from Azure Data Factory and import live GitLab data.
-
Use Manus AI to Talk to Your Power BI XMLA 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 Power BI XMLA data.
-
Connect to Zoho CRM Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Zoho CRM and the SQL Gateway to access Zoho CRM data from Google Apps Script.
-
Access Live Marketo Data in AWS Lambda
Connect to live Marketo data in AWS Lambda using the CData JDBC Driver.
-
Replicate Act-On Data to Multiple Databases
Replicate Act-On data to disparate databases with a point-and-click configuration.
-
Automated Continuous ZohoSubscriptions Replication to SingleStore
Use CData Sync for automated, continuous, customizable ZohoSubscriptions replication to SingleStore.
-
Integrate LibreChat with Live Google Ads Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Google Ads data from within the chat interface.
-
Build HBase-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live HBase data.
-
Create Google Ad Manager-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Google Ad Manager Data from OutSystems and build custom enterprise apps using live Google Ad Manager data.
-
Create Adobe Target Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Adobe Target data access from reports, embedded analytics, and more.
-
How to Work with XML Data in AWS Glue Jobs Using JDBC
Connect to XML from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Use Manus AI to Talk to Your MariaDB 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 MariaDB data.
-
Build Workday-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Workday Data from Zoho Analytics and import live Workday data.
-
Getting Started with the CData JDBC Driver for QuickBooks Online
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for QuickBooks Online.
-
Analyze REST Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze REST data in Microsoft R Open.
-
DataBind Charts to PDFMonkey Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to PDFMonkey data from controls in the Visual Studio toolbox. This article demonstrates a graphical approach using wizards in Visual Studio, as well as how to databind with only a few lines of code.
-
Deploy the ADO.NET Provider for Confluence on an SSRS Report Server
Connect to Confluence data 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.
-
How to Work with Salesforce Pardot Data in ETL Validator JDBC
Connect to Salesforce Pardot from ETL Validator jobs using the CData Software JDBC Driver.
-
Analyze JobNimbus Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze JobNimbus data with the CData JDBC Driver for JobNimbus.
-
A PostgreSQL Interface for Zendesk Data (MySQL Remoting via JDBC)
Use the Remoting features of the Zendesk JDBC Driver to create a PostgreSQL entry-point for data access.
-
Use Agno to Talk to Your Dynamics NAV 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 Dynamics NAV data for you.
-
Connect to Couchbase Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Couchbase data from Filemaker Pro on Mac.
-
How to Connect DBeaver to Zoho CRM via a JDBC Driver
Manage Zoho CRM data with visual tools in DBeaver like the query browser.