CData Software - Knowledge Base
Recent Articles
-
How to Visualize Guru Data in Python with pandas
Use pandas and other modules to analyze and visualize live Guru in Python.
-
Connect to Adobe Analytics Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Adobe Analytics and the SQL Gateway to access Adobe Analytics from Google Apps Script.
-
How to Connect the Power BI Service to Procore: Complete Guide
Connect to the CData Software Power BI Connector for Procore from PowerBI.com to provide real-time Procore across the organization.
-
Automated Continuous MongoDB Replication to Oracle
Use CData Sync for automated, continuous, customizable MongoDB replication to Oracle.
-
Create Google Search Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Google Search from PowerBI.com to create Power BI Dataflows with real-time data.
-
Connect to Hive Data from Crystal Reports
Use CData Connect AI to connect to and report on live Apache Hive from Crystal Reports.
-
Use the CData Software ODBC Driver for JobNimbus in MicroStrategy
Connect to JobNimbus in MicroStrategy Developer using the CData Software ODBC Driver for JobNimbus.
-
Integrating Antigravity CLI with Lakebase via CData CLI
Connect Lakebase to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Work with xBase Data in FoxPro
Load xBase into a FoxPro database. This article includes full code and a walk-through of the process.
-
Integrating Boomi Agentstudio with Trello Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Trello, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
A PostgreSQL Interface for SharePoint Data (MySQL Remoting via JDBC)
Use the Remoting features of the SharePoint JDBC Driver to create a PostgreSQL entry-point for data access.
-
Design BIRT Reports on Basecamp Data
Provide current Basecamp to your embedded analytics.
-
Publish Crystal Reports on ZendeskSell Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date ZendeskSell.
-
Access Live Recurly Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Recurly in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Visualize SpaceX Data in Sisense
Create an ElastiCube in Sisense app with access to SpaceX.
-
Analyze Strava Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Strava in Microsoft R Open.
-
Replicate Multiple Recurly Accounts
Replicate multiple Recurly accounts to one or many databases.
-
Integrating OpenCode Terminal with Typeform 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.
-
Automated Continuous Helpscout Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Helpscout replication to Amazon S3.
-
Process & Analyze Cvent Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Cvent Data.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed Certinia to Power BI dashboards. Simply drag and drop Certinia into data visuals on the Power BI canvas.
-
Provide OData Services of ChartMogul Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for ChartMogul by developing a WCF Service Application.
-
Getting Started with the CData ODBC Driver for Intercom
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Intercom.
-
Create AlloyDB-Connected Applications in Appsmith
Connect to AlloyDB Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Google AlloyDB.
-
Excel Spreadsheet Automation on Outlook Data with the QUERY Formula
Pull data from Outlook, automate spreadsheets, and more with the QUERY formula.
-
Connect to JSON Services in Ruby
Connect to JSON in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Integrate with SendPulse Data in JReport Designer
Create charts and reports based on SendPulse in JReport Designer.
-
Visualize Live Azure Synapse Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Azure Synapse.
-
Process & Analyze Epicor Kinetic Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Epicor Kinetic Data.
-
Connect to Google Ads Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Google Ads from Filemaker Pro on Mac.
-
Query RabbitMQ Data in ColdFusion
Write standard ColdFusion data access code to connect to RabbitMQ.
-
Connect to Apify Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Apify using standard SQL.
-
Import and Visualize Pushbullet Data in Power View
Create data visualizations based on Pushbullet in Excel.
-
Seamlessly Bring Microsoft OneDrive Data into Retool Using CData Connect AI
Integrate Microsoft OneDrive data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Connect to ScrapingBee Data in Ruby
Connect to ScrapingBee in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Connect Clockify to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Clockify using the CData Python MCP Server.
-
Connect to FreshBooks Data in RapidMiner
Integrate FreshBooks with standard components and data source configuration wizards in RapidMiner Studio.
-
How to create Float federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Float in MySQL .
-
Automated Continuous SAP Ariba Source Replication to SingleStore
Use CData Sync for automated, continuous, customizable SAP Ariba Source replication to SingleStore.
-
Automate Zoom Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Zoom from PowerShell? This article demonstrates how to utilize the Zoom Cmdlets for tasks like connecting to Zoom, automating operations, downloading data, and more.
-
Visualize Bitbucket Data in Sisense
Create an ElastiCube in Sisense app with access to Bitbucket.
-
Build MVC Applications with Connectivity to Office 365 Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Office 365 from an ASP.NET MVC application.
-
Automated Continuous Salesforce Marketing Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Salesforce Marketing replication to Apache Cassandra.
-
How to Build an ETL App for QuickBooks Time Data in Python with CData
Create ETL applications and real-time data pipelines for QuickBooks Time in Python with petl.
-
Getting Started with the CData Tableau Connector for QuickBooks Time
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for QuickBooks Time.
-
Publish Crystal Reports on Tavily Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Tavily.
-
Create Salesforce Marketing-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Salesforce Marketing Data from Klipfolio and build custom visualizations using live Salesforce Marketing Cloud.
-
Connect to Confluence Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Automate Amazon Athena Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Amazon Athena from PowerShell? This article demonstrates how to utilize the Amazon Athena Cmdlets for tasks like connecting to Amazon Athena, automating operations, downloading data, and more.
-
Feed NASA Data into FineReport
How to set NASA as a JDBC data source in FineReport.
-
Connect to and Query FreeAgent Data in QlikView over ODBC
Create data visualizations with FreeAgent in QlikView.
-
Connect Workable to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Workable using the CData Python MCP Server.
-
Query MailChimp Data in DataGrip
Create a Data Source for MailChimp in DataGrip and use SQL to query live MailChimp.
-
Integrate Live Zoom Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Zoom to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Integrate Live IBM Informix Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to IBM Informix and integrate live IBM Informix into apps built in Microsoft Power Apps.
-
Migrating data from TaxJar to Google BigQuery using CData SSIS Components.
Easily push TaxJar to Google BigQuery using the CData SSIS Tasks for TaxJar and Google BigQuery.
-
How to Query Live SharePoint Data in Claude Desktop
Connect to and query live SharePoint Data in Claude Desktop using CData MCP Server.
-
Automate Avaza Data Replication to Azure Synapse
Use CData Sync to customize and automate Avaza replication to Azure Synapse.
-
Connect to ZarMoney Data in JRuby
Create a simple JRuby app with access to live ZarMoney.
-
Build OneNote-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to OneNote Data from Zoho Analytics and import live Microsoft OneNote.
-
Working with Acumatica Data in LINQPad
Execute LINQ queries to Acumatica ERP in LINQPad.
-
Connect to Helpscout Data from PowerBuilder via JDBC
This article demonstrates how to access Helpscout from PowerBuilder using the Helpscout JDBC Driver.
-
Access Live Foursquare Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Foursquare in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Access Freshdesk Data in Mule Applications Using the CData JDBC Driver
Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for Freshdesk.
-
Automate MYOB AccountRight Data Replication to Azure Synapse
Use CData Sync to customize and automate MYOB AccountRight replication to Azure Synapse.
-
Integrating LlamaIndex with Zendesk Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Zendesk in real time.
-
Create SAP Hybris C4C-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to SAP Hybris C4C Data from OutSystems and build custom enterprise apps using live SAP Hybris C4C.
-
Use the CData ODBC Driver for Zoho Recruit in Microsoft Power Query
You can use the CData Zoho Recruit ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Zoho Recruit into Microsoft Power Query.
-
Use the CData Software JDBC Driver for Pipedrive in MicroStrategy Desktop
Connect to Pipedrive in MicroStrategy Desktop using the CData Software JDBC Driver for Pipedrive.
-
Use the CData Software JDBC Driver for Sage Intacct in MicroStrategy Web
Connect to Sage Intacct in MicroStrategy Web using the CData Software JDBC Driver for Sage Intacct.
-
Automated Continuous Google Ads Replication to Vertica
Use CData Sync for automated, continuous, customizable Google Ads replication to Vertica.
-
Build an OLAP Cube in SSAS from Gumroad Data
Establish a connection to Gumroad data from SQL Server Analysis Services, and use the Gumroad Data Provider to build OLAP cubes for use in analytics and reporting.
-
Automated Continuous Calendly Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Calendly replication to PostgreSQL.
-
Connect to XML Data in CloverDX (formerly CloverETL)
Transfer XML Files using the visual workflow in the CloverDX data integration tool.
-
Getting Started with the CData ODBC Driver for SAP Netweaver Gateway
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for SAP Netweaver Gateway.
-
Extract, Transform, and Load NASA Data in Informatica PowerCenter
Create a simple Workflow for NASA in Informatica PowerCenter.
-
Connect to Act-On Data from Crystal Reports
Use CData Connect AI to connect to and report on live Act-On from Crystal Reports.
-
Bind Live Greenplum Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Greenplum data
-
Build Automated Workflows with Live Odoo Data in Workato
Use CData Connect AI to connect to live Odoo ERP and build automated workflows in Workato.
-
Automated Continuous DB2 for i Replication to Vertica
Use CData Sync for automated, continuous, customizable DB2 for i replication to Vertica.
-
Use the CData Software JDBC Driver for Miro in MicroStrategy Web
Connect to Miro in MicroStrategy Web using the CData Software JDBC Driver for Miro.
-
Automate Copper Data Replication to Azure Data Lake
Use CData Sync to customize and automate Copper replication to Azure Data Lake.
-
How to Visualize Insightly Data in Python with pandas
Use pandas and other modules to analyze and visualize live Insightly in Python.
-
Connect to Deel in SpagoBI
Create reports featuring live Deel in SpagoBI Studio. Host Deel reports on SpagoBI Server.
-
Integrating Boomi Agentstudio with Adobe Commerce Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Adobe Commerce, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Automated Continuous Retently Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Retently replication to Google Cloud SQL.
-
Getting Started with the CData JDBC Driver for LinkedIn Ads
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for LinkedIn Ads.
-
Use CData Connect AI to Access SAP Ariba Procurement Data in Microsoft Power Pivot
Use CData Connect AI to connect to live SAP Ariba Procurement in the Power Pivot business intelligence tool.
-
Integrating Act CRM Data in Talend Cloud Data Management Platform
Connect Act CRM Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Act CRM.
-
Connect to Google Spanner Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Google Spanner using standard SQL.
-
DataBind Charts to Accelo Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Accelo 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.
-
Build Apps with Live Keap Data Using the Low-Code Development Platform of Mendix
Connect Keap with Mendix to build apps using the CData API Driver for JDBC.
-
Automated Continuous MariaDB Replication to IBM DB2
Use CData Sync for automated, continuous, customizable MariaDB replication to IBM DB2.
-
Integrate Open WebUI with Live MariaDB Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live MariaDB from within the chat interface.
-
Access Live Cassandra Data in Excel 365 Online (Excel for the web)
Connect to Apache Cassandra from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Connect and Query Live Redis Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Redis into Databricks
-
Visualize Google Campaign Manager 360 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 Google Campaign Manager 360 into TIBCO Spotfire.
-
Connect to Rootly from Asprova with CData Software ODBC Driver for Rootly
This article shows how to connect faster to Rootly data from Asprova.
-
Use the CData Software ODBC Driver for SpaceX in MicroStrategy Desktop
Connect to SpaceX in MicroStrategy Desktop using the CData Software ODBC Driver for SpaceX.
-
Integrating Dataiku with Paylocity Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Paylocity.