CData Software - Knowledge Base
Recent Articles
-
Automate Stack Exchange Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Stack Exchange from PowerShell? This article demonstrates how to utilize the Stack Exchange Cmdlets for tasks like connecting to Stack Exchange, automating operations, downloading data, and more.
-
Import and Visualize Oracle Eloqua Reporting Data in Power View
Create data visualizations based on Oracle Eloqua Reporting in Excel.
-
Access Live Paylocity Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live Paylocity data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Query Avaza Data in DataGrip
Create a Data Source for Avaza in DataGrip and use SQL to query live Avaza.
-
Import Facebook Ads Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Facebook Ads Data and provide access to live Facebook Ads for custom reports in the Power BI Service.
-
Access Live Rebilly Data in AWS Lambda
Connect to live Rebilly in AWS Lambda using the CData JDBC Driver.
-
Visualize Live Act-On Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Act-On.
-
Integrate Live Discourse Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Discourse to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Connect to CampaignMonitor Data in JRuby
Create a simple JRuby app with access to live CampaignMonitor.
-
Build a Singer.io Tap for Supabase With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Supabase data using
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live NetSuite SuiteAnalytics using the Model Context Protocol.
-
Automated Continuous Float Replication to SingleStore
Use CData Sync for automated, continuous, customizable Float replication to SingleStore.
-
Access Moosend 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 Moosend.
-
Build a PostgreSQL Interface for Ontraport Data using the CData JDBC Driver
Use the Remoting features of the Ontraport JDBC Driver to create a PostgreSQL entry-point for data access.
-
Integrating Antigravity CLI with Apache Avro via CData CLI
Connect Apache Avro to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Create Datasets from Miro in Domo Workbench and Build Visualizations of Miro Data in Domo
Use the CData Software ODBC Driver for Miro to create datasets from Miro in Domo Workbench and then build visualizations in the Domo service.
-
Analyze Lakebase Data in Cognos Analytics
Use CData Connect AI to connect to Lakebase Data from Cognos Analytics and analyze live Lakebase.
-
Access Zoom Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Zoom from HeidiSQL.
-
Stream JobNimbus Data into Apache Kafka Topics
Access and stream JobNimbus in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Integrate with Highrise Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Highrise CRM to a JSON file on disk.
-
Connect to Close from a Connection Pool in WebLogic
Use the CData JDBC Driver for Close to connect to Close from Web applications running on WebLogic.
-
Import Real-Time Paddle Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Paddle in ColdFusion.
-
Access Live PabblySubscriptions Data in Coginiti Pro
Connect to and query live PabblySubscriptions from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Build Highrise Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Highrise CRM and build visualizations in Tableau.
-
How to connect PolyBase to Adobe Target
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Adobe Target.
-
Connect to Oracle Data in Jaspersoft Studio
Execute SQL to remote Oracle Database in Jaspersoft Studio.
-
How to connect to Redis Data in DBVisualizer
Integrate Redis with visual data analysis tools and data connection wizards in DBVisualizer
-
Build Apps with Live Redis in Adalo using CData Connect AI
Use CData Connect AI to integrate live Redis into the Adalo platform and build custom mobile and web applications with real-time Redis.
-
Work with Amplitude Data in FoxPro
Load Amplitude into a FoxPro database. This article includes full code and a walk-through of the process.
-
Build Dashboards with ADP Data in DBxtra
Create dynamic dashboards and perform analytics based on ADP in DBxtra.
-
Automated Continuous Exa Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Exa replication to AlloyDB.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed Marketo to Power BI dashboards. Simply drag and drop Marketo into data visuals on the Power BI canvas.
-
Analyze Jira Data in Infragistics Reveal
Use the CData API Server to create an OData API on top of Atlassian Jira and visualize live Atlassian Jira in Infragistics Reveal.
-
Analyze Highrise Data in Cognos Analytics
Use CData Connect AI to connect to Highrise Data from Cognos Analytics and analyze live Highrise CRM.
-
How to Easily Query Amazon Marketplace Data in OpenOffice Base
Connect to Amazon Marketplace data in OpenOffice Base using the CData ODBC Driver for Amazon Marketplace and generate reports with live data insights.
-
Use the CData Software ODBC Driver for Invoiced in MicroStrategy Web
Connect to Invoiced in MicroStrategy Web using the CData Software ODBC Driver for Invoiced.
-
Connect to Workday Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Workday Data and connect to Workday in Akorbi Digital RunMyProcess.
-
Access Live Harvest Data in Coginiti Pro
Connect to and query live Harvest from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
A PostgreSQL Interface for SAP Business One Data using the CData ODBC Driver
Use the SQL Gateway and SAP Business One ODBC Driver to create a PostgreSQL entry-point for data access.
-
Build Data Flows from SQL Server to Zoho Inventory through SSIS
Easily push SQL Server data to Zoho Inventory using the CData SSIS Tasks for Zoho Inventory.
-
Use CData Connect AI to Access Google Search Results in Microsoft Power Pivot
Use CData Connect AI to connect to live Google Search in the Power Pivot business intelligence tool.
-
View Reports on Real-Time Confluence Data in Power BI Report Server
Use the CData ODBC Driver for Confluence to visualize Atlassian Confluence in Power BI Desktop and then publish them to Power BI Report Server.
-
Viewing Zendesk Data in RAD Studio Data Explorer
How to view Zendesk in RAD Studio Data Explorer using the CData ODBC Driver for Zendesk.
-
Consume OneNote OData Feeds in PowerBuilder
This article demonstrates how to consume Microsoft OneNote as OData feeds from PowerBuilder using the API Server.
-
Prepare, Blend, and Analyze Google Spanner Data in Alteryx Designer (ODBC)
Build workflows to access live Google Spanner for self-service data analytics.
-
Integrating OpenCode Terminal with SAP Fieldglass 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.
-
Use Microsoft Copilot Studio to talk to your Google Ads Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Microsoft Copilot Studio to securely answer questions and take actions on your Google Ads for you.
-
Connect to Real-Time Customer.io Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Customer.io in Power Apps.
-
Use the CData Software ODBC Driver for MailerLite in MicroStrategy
Connect to MailerLite in MicroStrategy Developer using the CData Software ODBC Driver for MailerLite.
-
How to publish and share Neo4J Data dashboards with Tableau Server
The CData ODBC driver for Neo4J enables you integrate Neo4J into Tableau dashboards.
-
How to create an RPA flow for Gumroad Data in UiPath Studio
Use the Gumroad ODBC Driver to create workflows that access real-time Gumroad without any coding.
-
Build AI Agents with Epicor Kinetic 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 Epicor Kinetic through CData Connect AI.
-
How to create an RPA flow for Omnisend Data in UiPath Studio
Use the Omnisend ODBC Driver to create workflows that access real-time Omnisend without any coding.
-
Process & Analyze Azure DevOps Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Azure DevOps Data.
-
Use the CData Software JDBC Driver for Coinbase in MicroStrategy Web
Connect to Coinbase in MicroStrategy Web using the CData Software JDBC Driver for Coinbase.
-
Visualize Google Campaign Manager 360 Data in TIBCO Spotfire through OData
Integrate Google Campaign Manager 360 into dashboards in TIBCO Spotfire.
-
Integrate Odoo Data into Power Automate Desktop using CData Connect
CData Connect for Odoo Data enables you to integrate Odoo ERP into workflows built using Microsoft Power Automate Desktop.
-
Automated Continuous SAP BusinessObjects BI Replication to Databricks
Use CData Sync for automated, continuous, customizable SAP BusinessObjects BI replication to Databricks.
-
Automated Continuous Teradata Replication to SQLite
Use CData Sync for automated, continuous, customizable Teradata replication to SQLite.
-
Access Neo4J Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Neo4J from HeidiSQL.
-
Connect to ADP Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live ADP from Filemaker Pro on Mac.
-
Build Dashboards with Avalara AvaTax Data in Dundas BI
Create dynamic dashboards and perform analytics based on Avalara AvaTax in Dundas BI.
-
Establish a Live Connection with Codat Data using Tableau Bridge
The CData ODBC Driver for Codat enables you to integrate live Codat into Tableau Cloud dashboards using the Tableau Bridge.
-
Analyze ServiceNow Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of ServiceNow and visualize ServiceNow in SAP Analytics Cloud.
-
Access Pingdom Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Pingdom from HeidiSQL.
-
Create Dashboards and Visualize Live Apollo Data in Geckoboard
Use CData Connect AI to connect to live Apollo and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Use the CData Software JDBC Driver for Shopify in MicroStrategy Desktop
Connect to Shopify in MicroStrategy Desktop using the CData Software JDBC Driver for Shopify.
-
Access Strava Data from MySQL in Amazon QuickSight
Connect to Strava and build visualizations of Strava using a MySQL Connection in Amazon QuickSight.
-
Analyze PayPal Data in Looker
Use CData Connect AI to connect to PayPal Data from Looker and build custom apps using live PayPal.
-
How to Easily Query Shippo Data in OpenOffice Base
Connect to Shippo data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Integrating Gumloop with Apollo Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Apollo within automated workflows.
-
How to Work with eBay Analytics Data in AWS Glue Jobs Using JDBC
Connect to eBay Analytics from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Getting Started with the CData SSIS Components for Microsoft Exchange
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Microsoft Exchange.
-
JSON Services Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to JSON through CData Connect AI using different applications and tools.
-
Connect to Workday Data from HeidiSQL
Use CData Connect AI to connect to and query live Workday from HeidiSQL.
-
Automated Continuous Paymo Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Paymo replication to Apache Kafka.
-
Integrate LibreChat with Live Microsoft Exchange Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Microsoft Exchange from within the chat interface.
-
Getting Started with the CData Tableau Connector for Presto
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Presto.
-
Connect to Paddle Data in RapidMiner
Integrate Paddle with standard components and data source configuration wizards in RapidMiner Studio.
-
Use the CData Software JDBC Driver for AdRoll in MicroStrategy Web
Connect to AdRoll in MicroStrategy Web using the CData Software JDBC Driver for AdRoll.
-
Build Lakebase Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Lakebase and build visualizations in Tableau Cloud.
-
Use Biml to Build SSIS Tasks to Replicate Gorgias Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Gorgias to SQL Server.
-
Connect to Basecamp Data in CloverDX (formerly CloverETL)
Transfer Basecamp using the visual workflow in the CloverDX data integration tool.
-
Integrate Theia IDE with Live MySQL Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE
-
How to Import Data from Salesforce Marketing into Google Sheets
Import Salesforce Marketing Cloud into a Google spreadsheet that is automatically refreshed.
-
Connect Microsoft Dataverse Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Microsoft Dataverse (CDS) using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Connect to and Visualize Live Close Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Close.
-
Connect to NetSuite SuiteAnalytics Data as an External Data Source using PolyBase
Use CData Connect AI and PolyBase to create an external data source in SQL Swerver with access to live NetSuite SuiteAnalytics.
-
Publish GetResponse-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live GetResponse.
-
Automated Continuous Everhour Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Everhour replication to Apache Kafka.
-
Access Live SharePoint Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Microsoft SharePoint from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Query PDFMonkey Data as a MySQL Database in Node.js
Execute MySQL queries against PDFMonkey from Node.js.
-
Access Live BambooHR Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live BambooHR from your Excel spreadsheets.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Microsoft Teams
Provide connectivity to Microsoft Teams through an SAP BusinessObjects universe.
-
Integrate Cursor with Live MarkLogic Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live MarkLogic from within the editor.
-
View Reports on Real-Time Microsoft Entra ID Data in Power BI Report Server
Use the CData ODBC Driver for Microsoft Entra ID to visualize Microsoft Entra ID in Power BI Desktop and then publish them to Power BI Report Server.
-
Build Dropbox-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Dropbox.
-
How to Connect to Live Asana Data in Mistral AI Workflows
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live Asana without replication.
-
Extract, Transform, and Load eBay Analytics Data in Informatica PowerCenter
Create a simple Workflow for eBay Analytics in Informatica PowerCenter.
-
Integrate Azure Synapse Data in Pentaho Data Integration
Build ETL pipelines based on Azure Synapse in the Pentaho Data Integration tool.