CData Software - Knowledge Base
Recent Articles
-
Build AI/ML Models with Live Close Data using Dataiku
Connect Close Data with Dataiku using the CData API Driver for JDBC.
-
Create Tavily-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Tavily Data from Klipfolio and build custom visualizations using live Tavily data.
-
Publish Ontraport-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Ontraport data.
-
How to work with Oracle Sales Data in Apache Spark using SQL
Access and process Oracle Sales Data in Apache Spark using the CData Software JDBC Driver.
-
Deploy the ADO.NET Provider for JSON on an SSRS Report Server
Connect to JSON services 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.
-
Build Data Flows from SQL Server to Excel Online through SSIS
Easily push SQL Server data to Excel Online using the CData SSIS Tasks for Excel Online.
-
Build Apps with Live Microsoft OneDrive Data Using the Low-Code Development Platform of Mendix
Connect Microsoft OneDrive data with Mendix to build apps using the CData JDBC Driver for Microsoft OneDrive.
-
Automated Continuous Office 365 Replication to SQLite
Use CData Sync for automated, continuous, customizable Office 365 replication to SQLite.
-
Automated Continuous Zoho Creator Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Zoho Creator replication to Azure SQL Database.
-
Connect Amplitude to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Amplitude data using the CData Python MCP Server.
-
How to Connect Flowise AI Agents to Live Databricks Data via CData Connect AI
Integrate Flowise AI with the CData Connect AI MCP Server to enable agents to securely query and act on live Databricks data without replication.
-
How to load Sugar CRM data into Elasticsearch via Logstash
Introducing a simple method to load Sugar CRM data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Connect to ScrapingBee from Asprova with CData Software ODBC Driver for ScrapingBee
This article shows how to connect faster to ScrapingBee data from Asprova.
-
Create Data Visualizations in Cognos BI with LDAP Objects
Access LDAP objects as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Build Apps with Live Bitbucket Data Using the Low-Code Development Platform of Mendix
Connect Bitbucket data with Mendix to build apps using the CData JDBC Driver for Bitbucket.
-
Create Reports with Apify Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Apify data.
-
A PostgreSQL Interface for Amazon S3 Data (MySQL Remoting via JDBC)
Use the Remoting features of the Amazon S3 JDBC Driver to create a PostgreSQL entry-point for data access.
-
How to load ChargeOver data into Elasticsearch via Logstash
Introducing a simple method to load ChargeOver data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Use the CData Software JDBC Driver for Power BI XMLA in MicroStrategy
Connect to Power BI XMLA data in MicroStrategy Developer using the CData Software JDBC Driver for Power BI XMLA.
-
Basecamp Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Basecamp facts in real time.
-
Rapidly Develop Highrise-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 Highrise.
-
Connect to Attio Data in HULFT Integrate
Connect to Attio as a JDBC data source in HULFT Integrate
-
Migrating data from Greenplum to Google BigQuery using CData SSIS Components.
Easily push Greenplum data to Google BigQuery using the CData SSIS Tasks for Greenplum and Google BigQuery.
-
DataBind Controls to Paylocity Data in C++Builder
DataBind to Paylocity data in C++Builder with standard components and controls.
-
Connect to TigerGraph Data in DBeaver
Use the CData ODBC Driver to connect to TigerGraph data in DBeaver.
-
Create Zoho Inventory-Connected Dashboards in Grafana
Connect to Zoho Inventory Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Zoho Inventory data.
-
Import Real-Time Autopilot Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Autopilot data in ColdFusion.
-
Explore Geographical Relationships in CapsuleCRM Data with Power Map
Create data visualizations with CapsuleCRM data in Power Map.
-
Integrating Boomi Agentstudio with Oracle HCM Cloud Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Oracle HCM Cloud data, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Integrate LibreChat with Live QuickBooks Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live QuickBooks data from within the chat interface.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Dropbox
Provide connectivity to Dropbox data through an SAP BusinessObjects universe.
-
Build QuickBooks-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to QuickBooks data and build web apps with connectivity to live QuickBooks data.
-
Connect to SAS Data Sets Data in Ruby
Connect to SAS Data Sets data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Build Pipelines with Live Salesforce Data 360 Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Salesforce Data 360 from Google Cloud Data Fusion, enabling the integration of live Salesforce Data 360 data into the building and management of effective data pipelines.
-
Create a Data Access Object for Spotify Data using JDBI
A brief overview of creating a SQL Object API for Spotify data in JDBI.
-
Integrate Live OData 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 OData services from within the IDE.
-
Build Apps with Live Stack Exchange Data Using the Low-Code Development Platform of Mendix
Connect Stack Exchange data with Mendix to build apps using the CData API Driver for JDBC.
-
Integrating Claude Code with IBM Cloud Object Storage Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on IBM Cloud Object Storage data within assisted coding and automated development workflows.
-
How to Connect DBeaver to SAP Ariba Source via a JDBC Driver
Manage SAP Ariba Source data with visual tools in DBeaver like the query browser.
-
Connect to Dropbox Data in Ruby
Connect to Dropbox data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Automate Phoenix Data Replication to Couchbase
Use CData Sync to Customize and automate Phoenix data replication to Couchbase.
-
Establish a Live Connection with CampaignMonitor Data using Tableau Bridge
The CData ODBC Driver for CampaignMonitor enables you to integrate live CampaignMonitor data into Tableau Cloud dashboards using the Tableau Bridge.
-
Automated Continuous Impala Replication to SQL Server
Use CData Sync for automated, continuous, customizable Impala replication to SQL Server.
-
Create Data Visualizations Based On Amazon S3 Data in Mode
Use CData Connect AI to connect to Amazon S3 Data from Mode and build visualizations using live Amazon S3 data.
-
Query QuickBooks Online Data in ColdFusion
Write standard ColdFusion data access code to connect to QuickBooks Online data.
-
DataBind Google Drive Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for Google Drive with the DevExpress Windows Forms and Web controls to provide Google Drive data to a chart.
-
Excel Spreadsheet Automation on Shopify Data with the QUERY Formula
Pull data from Shopify, automate spreadsheets, and more with the QUERY formula.
-
Analyze Snapchat Ads Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Snapchat Ads data and visualize live Snapchat Ads data in Infragistics Reveal.
-
How to create SendGrid federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for SendGrid data in MySQL .
-
Visualize Live GraphQL Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live GraphQL data into custom reports in Power BI.
-
Automate Microsoft Ads Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Microsoft Ads data from PowerShell? This article demonstrates how to utilize the Microsoft Ads Cmdlets for tasks like connecting to Microsoft Ads data, automating operations, downloading data, and more.
-
Query Gumroad Data as a MySQL Database in Node.js
Execute MySQL queries against Gumroad data from Node.js.
-
Build Dashboards with Paddle Data in DBxtra
Create dynamic dashboards and perform analytics based on Paddle data in DBxtra.
-
Build Data Flows from Google Search to SQL Server using SSIS
Easily back up Google Search results to SQL Server using the SSIS components for Google Search.
-
Connecting Agentforce with Teradata Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Agentforce to securely read and take actions on your Teradata data for you.
-
How to Access Live Salesloft Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Salesloft enables you to integrate Salesloft data into workflows built using Microsoft Power Automate Desktop.
-
How to load Productboard data into Elasticsearch via Logstash
Introducing a simple method to load Productboard data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Paddle Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Paddle facts in real time.
-
Getting Started with the CData Python Connector for Demio
Learn to install and license the CData Python Connector and configure a connection to live Demio data.
-
Integrate Reply.io Data in the Pentaho Report Designer
Publish reports based on Reply.io data in the Pentaho BI tool.
-
Explore Geographical Relationships in Azure Table Data with Power Map
Create data visualizations with Azure Table data in Power Map.
-
Connect to Oracle Data in Claris FileMaker Pro
Use the CData ODBC Driver for Oracle in FileMaker Pro to connect to Oracle and work with Oracle data in your FileMaker applications.
-
Getting Started with the CData Excel Add-In for Mistral AI
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Mistral AI.
-
Connect to and Visualize Live Airtable Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Airtable data.
-
How to integrate Metabase with Discord Data
Use CData Connect AI to connect to live Discord data and create an interactive dashboard in Metabase from Discord data.
-
Access Tavily Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Tavily data from your Oracle system.
-
How to connect PolyBase to Bannerbear
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Bannerbear data.
-
Connect to Moosend Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Moosend Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Integrate Cursor with Live Klipfolio Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Klipfolio data from within the editor.
-
Connect to Recurly Data from a Connection Pool in JBoss
Integrate Recurly data into Java servlets: Use the Management Console in JBoss to install the Recurly JDBC Driver.
-
Add HubDB Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for HubDB with the Informatica Enterprise Data Catalog to classify and organize data.
-
Connect Tickspot to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Tickspot with IBM WebSphere for seamless data integration and connectivity.
-
Analyze Apify Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Apify from Power Pivot. You will use the Table Import Wizard to load Apify data. You can visually build the import query or use any SQL supported by the driver.
-
Create Informatica Mappings From/To an ODBC Data Source for Mailgun
Create an ODBC connection to Mailgun in Informatica and browse and transfer Mailgun data.
-
Build Microsoft Planner-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Microsoft Planner data and build web apps with connectivity to live Microsoft Planner data.
-
Build a Singer.io Tap for Keap With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Keap data using the CData Python Connector.
-
How to connect and process Tally data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Tally data.
-
Integrate with Aweber Data in JReport Designer
Create charts and reports based on Aweber data in JReport Designer.
-
Stream Freshdesk Data into Apache Kafka Topics
Access and stream Freshdesk data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Integrating Kiro with Azure Data Catalog 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.
-
Rapidly Develop Printify-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 Printify.
-
Connect to Live OneNote Data in PostGresSQL Interface through CData Connect AI
Create a live connection to OneNote in CData Connect AI and connect to your OneNote data from PostgreSQL.
-
Migrating data from Google Analytics to Google BigQuery using CData SSIS Components.
Easily push Google Analytics data to Google BigQuery using the CData SSIS Tasks for Google Analytics and Google BigQuery.
-
Build PayPal-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to PayPal data and build web apps with connectivity to live PayPal data.
-
Operational Reporting on Perigon Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Perigon data.
-
Integrate Outlook Data in Pentaho Data Integration
Build ETL pipelines based on Outlook data in the Pentaho Data Integration tool.
-
How to publish and share ChartMogul Data dashboards with Tableau Server
The CData ODBC driver for ChartMogul enables you integrate ChartMogul data into Tableau dashboards.
-
Connect to Reckon from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Reckon data, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Building Dynamic Web Pages with Outreach.io Data Using AngularJS
Create single-page applications with live connectivity to Outreach.io using the CData API Server.
-
Connect to ElevenLabs Data in RazorSQL
Connect to ElevenLabs from wizards and query ElevenLabs data from the GUI in the RazorSQL database management tool.
-
Model, Search, and Visualize Live ZohoMarketingHub Data in ThoughtSpot
Use CData Connect AI to connect to live ZohoMarketingHub data for modeling, searching, and visualizing.
-
Publish SingleStore-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live SingleStore data.
-
Replicate Cohere Data from PowerShell
Write a quick PowerShell script to query Cohere data. Use connectivity to the live data to replicate Cohere data to SQL Server.
-
Create Data Visualizations Based On SurveyMonkey Data in Mode
Use CData Connect AI to connect to SurveyMonkey Data from Mode and build visualizations using live SurveyMonkey data.
-
Getting Started with the CData Power BI Connector for Kintone
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Kintone.
-
Connect to FormSite Data as an External Source in Dremio
Use the CData JDBC Driver to connect to FormSite as an External Source in Dremio.
-
How to integrate EmailOctopus with Apache Airflow
Access and process EmailOctopus data in Apache Airflow using the CData JDBC Driver.
-
Build Pipeliner CRM-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Pipeliner CRM data.
-
Visualize Live Workable Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Workable data.
-
DataBind Controls to Printify Data in C++Builder
DataBind to Printify data in C++Builder with standard components and controls.