CData Software - Knowledge Base
Recent Articles
-
Automated Continuous GitHub Replication to Vertica
Use CData Sync for automated, continuous, customizable GitHub replication to Vertica.
-
LINQ to Beeminder 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 Beeminder Data Provider.
-
Use the CData Software ODBC Driver for Couchbase in SAS for Real-Time Reporting and Analytics
Connect to real-time Couchbase data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Couchbase.
-
How to Visualize Bitbucket Data in Python with pandas
Use pandas and other modules to analyze and visualize live Bitbucket data in Python.
-
Create Salesforce CRM Analytics Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Salesforce CRM Analytics data access from reports, embedded analytics, and more.
-
Automated Continuous Freshdesk Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Freshdesk replication to PostgreSQL.
-
Import Real-Time Salesforce Marketing Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Salesforce Marketing data in ColdFusion.
-
Build an OLAP Cube in SSAS from ZohoPeople Data
Establish a connection to ZohoPeople data data from SQL Server Analysis Services, and use the ZohoPeople Data Provider to build OLAP cubes for use in analytics and reporting.
-
ETL Adobe Commerce in Oracle Data Integrator
This article shows how to transfer Adobe Commerce data into a data warehouse using Oracle Data Integrator.
-
Create Reports with MailerLite Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date MailerLite data.
-
Create Reports from Zuora Data in Looker Studio
Use CData Connect AI to gain access to live Zuora data and create custom reports in Looker Studio.
-
How to use SQLAlchemy ORM to access Webflow Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Webflow data.
-
Getting Started with the CData SSIS Components for Avaza
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Avaza.
-
Explore Geographical Relationships in Avro Data with Power Map
Create data visualizations with Avro data in Power Map.
-
Natively Connect to AdRoll Data in PHP
The CData ODBC driver for AdRoll enables you to create PHP applications with connectivity to AdRoll data. Leverage the native support for ODBC in PHP.
-
Integrating Cursor with Copper 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.
-
Create Datasets from NetSuite in Domo Workbench and Build Visualizations of NetSuite Data in Domo
Use the CData Software ODBC Driver for NetSuite to create datasets from NetSuite data in Domo Workbench and then build visualizations in the Domo service.
-
Use CData Connect AI to Access Shippo Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Shippo data in the Power Pivot business intelligence tool.
-
Publish Reports with SAP Ariba Source Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date SAP Ariba Source data.
-
Automated Continuous Kintone Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Kintone replication to delimited files (CSV/TSV).
-
How to load Azure Analysis Services data into Elasticsearch via Logstash
Introducing a simple method to load Azure Analysis Services data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Publish Reports with SuiteCRM Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date SuiteCRM data.
-
Create Intercom Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Intercom data access from reports, embedded analytics, and more.
-
Use Biml to Build SSIS Tasks to Replicate Deel Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Deel data to SQL Server.
-
Connect to and Visualize Live OData Services in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live OData services.
-
Integrate with Sage Cloud Accounting Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Sage Cloud Accounting data in SnapLogic.
-
Connect to Grafana Data in CloverDX (formerly CloverETL)
Transfer Grafana data using the visual workflow in the CloverDX data integration tool.
-
Visualize Azure Analysis Services 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 Azure Analysis Services data into TIBCO Spotfire.
-
Connecting Moonlit Workflow with Google Spanner Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Moonlit workflows to securely read and act on your Google Spanner data in real time.
-
Access Live Google Forms Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Google Forms data from your Google Sheets.
-
Building Dynamic Web Pages with Raisers Edge NXT Data Using AngularJS
Create single-page applications with live connectivity to Raisers Edge NXT using the CData API Server.
-
Connect to Asana Data in CloverDX (formerly CloverETL)
Transfer Asana data using the visual workflow in the CloverDX data integration tool.
-
Connect LightSpeedRetail Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your LightSpeedRetail data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Integrate OpenCode with Live Bitbucket Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable OpenCode to securely access and query live Bitbucket data from within your AI coding agent.
-
Query Mouseflow Data as a MySQL Database in Node.js
Execute MySQL queries against Mouseflow data from Node.js.
-
Integrate Square Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Square data from Informatica Cloud.
-
Automated Continuous Google Ads Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Google Ads replication to Azure SQL Database.
-
Analyze Zoho Recruit Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Zoho Recruit from Power Pivot. You will use the Table Import Wizard to load Zoho Recruit data. You can visually build the import query or use any SQL supported by the driver.
-
Build Semantic Layer Views for Wave Financial Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Wave Financial data.
-
Build Microsoft Entra ID-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Microsoft Entra ID data and build web apps with connectivity to live Microsoft Entra ID data.
-
Analyze Live Klipfolio Data in SAS Viya
Use CData Connect AI to connect to Klipfolio data from SAS Viya and deploy self-service analytics using live Klipfolio data.
-
Build Automated Workflows with Live Zoom Data in Workato
Use CData Connect AI to connect to live Zoom data and build automated workflows in Workato.
-
Integrating Antigravity CLI with Perigon data via CData CLI
Connect Perigon data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Connect to Hubstaff Data in Aqua Data Studio
Access Hubstaff data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Getting Started with the CData Python Connector for Quaderno
Learn to install and license the CData Python Connector and configure a connection to live Quaderno data.
-
Prepare, Blend, and Analyze Instagram Data in Alteryx Designer (Connect AI)
Build workflows to access live Instagram data for self-service data analytics.
-
Use Dash to Build Web Apps on Instagram Data via CData Connect AI
Build interactive Dash web apps on live Instagram data using pandas and the CData Connect AI Python SDK.
-
How to connect to SAP SuccessFactors LMS Data in DBVisualizer
Integrate SAP SuccessFactors LMS data with visual data analysis tools and data connection wizards in DBVisualizer
-
Connect AI Guide: Derived Views, Saved Queries, and Custom Reports
A basic guide to creating Derived Views, Saved Queries, and Custom Reports in Connect AI.
-
Build FreshBooks Visualizations in Tableau Desktop
Use CData Connect AI to connect to live FreshBooks data and build visualizations in Tableau.
-
Connect to and Query SAP HANA Data in QlikView over ODBC
Create data visualizations with SAP HANA data in QlikView.
-
Connect to LinkedIn Data in DBeaver
Use the CData ODBC Driver to connect to LinkedIn data in DBeaver.
-
Integrate PolarTeamPro Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live PolarTeamPro data from Informatica Cloud.
-
Build Monday.com Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Monday.com data and build visualizations in Tableau.
-
Integrating Clari Data in Talend Cloud Data Management Platform
Connect Clari Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Visualize Live Asana Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Asana data into custom reports in Power BI.
-
Use the CData Software JDBC Driver for SFTP in MicroStrategy Web
Connect to SFTP data in MicroStrategy Web using the CData Software JDBC Driver for SFTP.
-
Visualize Amazon DynamoDB Data in Sisense
Create an ElastiCube in Sisense app with access to Amazon DynamoDB data.
-
Integrating Gumloop with Dropbox Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Dropbox data within automated workflows.
-
Establish a Live Connection with SAP Business One Data using Tableau Bridge
The CData ODBC Driver for SAP Business One enables you to integrate live SAP Business One data into Tableau Cloud dashboards using the Tableau Bridge.
-
Connect to Live Oracle Sales Data in MicroStrategy through CData Connect AI
Create a live connection to Oracle Sales Data in CData Connect AI and connect to your Oracle Sales data from MicroStrategy.
-
How to Connect the Power BI Service to TigerGraph: Complete Guide
Connect to the CData Software Power BI Connector for TigerGraph from PowerBI.com to provide real-time TigerGraph data across the organization.
-
Getting Started with the CData Power BI Connector for AdRoll
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
How to connect to CouchDB Data in DBVisualizer
Integrate CouchDB data with visual data analysis tools and data connection wizards in DBVisualizer
-
Create FreshBooks-Connected Applications in Appsmith
Connect to FreshBooks Data via CData Connect AI in Appsmith and create custom business applications with real-time access to FreshBooks data.
-
Prepare, Blend, and Analyze SAP Fieldglass Data in Alteryx Designer (ODBC)
Build workflows to access live SAP Fieldglass data for self-service data analytics.
-
How to Connect to Live Amazon S3 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 Amazon S3 data for you.
-
Use Databricks Agent Bricks to Talk to Your Toggl Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Toggl data for you.
-
Query SAP Netweaver Gateway Data as a MySQL Database in Node.js
Execute MySQL queries against SAP Netweaver Gateway data from Node.js.
-
Work with Live Certinia Data in Power Query
Use CData Connect AI to connect to Certinia data and work with live Certinia data in Microsoft Power Query.
-
Query Live Jira 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 Jira data through a conversational interface.
-
Getting Started with the CData Excel Add-In for Impala
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Impala.
-
Validate Zoho Books Data with QuerySurge
Access and validate Zoho Books data in QuerySurge using the CData JDBC Driver.
-
Import Real-Time Datadog Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Datadog data in ColdFusion.
-
Integrate Cline with Live Amazon S3 Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Amazon S3 data from within your IDE.
-
Connect to Real-Time Asana Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Asana and Dataflow to import and use Asana data in Power Apps.
-
Access Live Act CRM Data in TIBCO Data Virtualization
Use the Act CRM Tibco DV Adapter to create a Act CRM data data source in TIBCO Data Virtualization Studio and gain access to live Act CRM data from your TDV Server.
-
Build Dashboards with QuickBooks Data in DBxtra
Create dynamic dashboards and perform analytics based on QuickBooks data in DBxtra.
-
Automated Continuous Beeminder Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Beeminder replication to Apache Cassandra.
-
Build Float-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Float data.
-
Automated Continuous Spotify Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Spotify replication to Google Cloud SQL.
-
Access SurveyMonkey Data from MySQL in PHP
Connect to SurveyMonkey through the standard MySQL libraries in PHP.
-
DataBind Charts to Optimizely Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Optimizely 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.
-
Connect to Testmonitor Data in NetBeans
Connect to Testmonitor data in NetBeans with the data source configuration wizard.
-
How to connect to Spotify Data from IntelliJ
Integrate connectivity to Spotify data with wizards in IntelliJ.
-
How to Connect to Live Vertica 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 Vertica data for you.
-
Create Informatica Mappings From/To an ODBC Data Source for Pipeline CRM
Create an ODBC connection to Pipeline CRM in Informatica and browse and transfer Pipeline CRM data.
-
Integrate LibreChat with Live Microsoft OneDrive Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Microsoft OneDrive data from within the chat interface.
-
Work with Twitter Ads Data in FoxPro
Load Twitter Ads data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Getting Started with the CData Excel Add-In for Avro
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Avro.
-
How to connect to Paylocity Data with Squirrel SQL client
Connect to Paylocity data and execute queries in the Squirrel SQL Client.
-
Build Mailgun-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Mailgun Data from Zoho Analytics and import live Mailgun data.
-
Integrate Google's Antigravity Agent with Live Google Ads Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Google Ads data using the Model Context Protocol.
-
Integrate with live QuickBooks Time Data in Jitterbit
Use CData Connect AI to connect to and integrate live QuickBooks Time data in Jitterbit.
-
Import Real-Time Autopilot Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Autopilot data in ColdFusion.
-
Automate YouTube Analytics Data Replication to Azure Synapse
Use CData Sync to customize and automate YouTube Analytics data replication to Azure Synapse.
-
Getting Started with the CData SSIS Components for Beeminder
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Beeminder.
-
Create Google Analytics-Connected Applications in Appsmith
Connect to Google Analytics Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Google Analytics data.
-
Build Zoho Inventory-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Zoho Inventory Data and create custom apps in Mendix.
-
Integrate MailChimp Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live MailChimp data from Informatica Cloud.