CData Software - Knowledge Base
Recent Articles
-
Consume Attio OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Attio feeds that reflect any changes in SAP Lumira.
-
Design BIRT Reports on PayPal Data
Provide current PayPal to your embedded analytics.
-
Consume Zoho Inventory OData Feeds in PowerBuilder
This article demonstrates how to consume Zoho Inventory as OData feeds from PowerBuilder using the API Server.
-
Visualize Live Cloudant Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live IBM Cloudant.
-
Build Automated Workflows with Live API Data in Workato
Use CData Connect AI to connect to live API and build automated workflows in Workato.
-
Import and Visualize Webflow Data in Power View
Create data visualizations based on Webflow in Excel.
-
Deploy the ADO.NET Provider for Google Drive on an SSRS Report Server
Connect to Google Drive 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.
-
Connect to Freshservice Data from PowerBuilder via ADO.NET
This article demonstrates how to access Freshservice from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Getting Started with the CData SSIS Components for DB2
Complete guide to installing, licensing, and connecting with the CData SSIS Components for DB2.
-
Connect to Gong Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Bridge Google Translate Connectivity with Apache NiFi
Access and process Google Translate in Apache NiFi using the CData JDBC Driver.
-
Consume GitHub OData Feeds in PowerBuilder
This article demonstrates how to consume GitHub as OData feeds from PowerBuilder using the API Server.
-
How to Visualize Intercom Data in Python with pandas
Use pandas and other modules to analyze and visualize live Intercom in Python.
-
Create Exact Online-Connected Dashboards in Grafana
Connect to Exact Online Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Exact Online.
-
Publish Reports with Facebook Ads Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Facebook Ads.
-
Create Dashboards and Visualize Live SAP Concur Data in Geckoboard
Use CData Connect AI to connect to live SAP Concur and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Use the CData API Server to Access Act CRM Data in Microsoft PowerPivot
Use the CData API Server to connect to live Act CRM in the Power Pivot business intelligence tool.
-
Moving Data from Marketo to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Marketo data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Integrate with SAP SuccessFactors LMS Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy SAP SuccessFactors LMS to a JSON file on disk.
-
Connect to Browserless from Asprova with CData Software ODBC Driver for Browserless
This article shows how to connect faster to Browserless data from Asprova.
-
Connect to Basecamp Data in NetBeans
Connect to Basecamp in NetBeans with the data source configuration wizard.
-
Build SQL Server-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData MCP Server for SQL Server to explore live SQL Server Data in GitHub Copilot to assist with building SQL Server-powered applications.
-
Moving Data from Twitter Ads to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Twitter Ads data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
ETL Hacker News in Oracle Data Integrator
This article shows how to transfer Hacker News into a data warehouse using Oracle Data Integrator.
-
Integrating Claude Code CLI with Zuora 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.
-
Bind Live ServiceNow Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live ServiceNow data
-
Work with Rebilly Data in FoxPro
Load Rebilly into a FoxPro database. This article includes full code and a walk-through of the process.
-
Build Avaza-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Avaza.
-
Integrate with Azure Analysis Services Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Azure Analysis Services in SnapLogic.
-
Connect to Paylocity Data in CloverDX (formerly CloverETL)
Transfer Paylocity using the visual workflow in the CloverDX data integration tool.
-
Connect to ActiveCampaign Data in NetBeans
Connect to ActiveCampaign in NetBeans with the data source configuration wizard.
-
Build Dashboards with Outlook Data in Dundas BI
Create dynamic dashboards and perform analytics based on Outlook in Dundas BI.
-
Integrating Antigravity CLI with Reckon Accounts Hosted via CData CLI
Connect Reckon Accounts Hosted to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Create a Data Access Object for Jumpseller Data using JDBI
A brief overview of creating a SQL Object API for Jumpseller in JDBI.
-
Integrating OpenCode Terminal with Guru 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.
-
How to create Humanity federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Humanity in MySQL .
-
Use the CData ODBC Driver for Twitter Ads from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Twitter Ads to connect to Twitter Ads from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Twitter Ads in Excel.
-
Publish Trello-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Trello.
-
Connect to SendPulse Data from a Connection Pool in JBoss
Integrate SendPulse into Java servlets: Use the Management Console in JBoss to install the SendPulse JDBC Driver.
-
Connect to Real-Time Anaplan Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Anaplan and Dataflow to import and use Anaplan in Power Apps.
-
Bidirectional Access to Optimizely Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Optimizely in Filemaker Pro for Mac or Windows.
-
Analyze Certinia Data in Infragistics Reveal
Use the CData API Server to create an OData API on top of Certinia and visualize live Certinia in Infragistics Reveal.
-
Query, Visualize, and Share live Azure Data Lake Storage Data in Redash
Use CData Connect AI to connect to live Azure Data Lake Storage in Redash for querying, visualizing, and sharing.
-
Use Dash to Build to Web Apps on Microsoft Dataverse Data
Create Python applications that use pandas and Dash to build Microsoft Dataverse-connected web apps.
-
Connect to Moosend Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Moosend using standard SQL.
-
Connect to GitHub Data in NetBeans
Connect to GitHub in NetBeans with the data source configuration wizard.
-
Use the CData ODBC Driver for Pinecone in Microsoft Power Query
You can use the CData Pinecone ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Pinecone into Microsoft Power Query.
-
Explore Geographical Relationships in VWO Data with Power Map
Create data visualizations with VWO in Power Map.
-
Connect to Onfleet Data from a Connection Pool in Jetty
The Onfleet JDBC Driver supports connection pooling: This article shows how to connect faster to Onfleet from Web apps in Jetty.
-
Use the CData Software ODBC Driver for Authorize.Net in MicroStrategy Desktop
Connect to Authorize.Net in MicroStrategy Desktop using the CData Software ODBC Driver for Authorize.Net.
-
How to Connect the Power BI Service to LeadDesk: Complete Guide
Connect to the CData Software Power BI Connector for LeadDesk from PowerBI.com to provide real-time LeadDesk across the organization.
-
Validate Dynamics NAV Data with QuerySurge
Access and validate Microsoft Dynamics NAV in QuerySurge using the CData JDBC Driver.
-
Build Apps with Live Zoho Creator Data Using the Low-Code Development Platform of Mendix
Connect Zoho Creator with Mendix to build apps using the CData JDBC Driver for Zoho Creator.
-
Automated Continuous HDFS Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable HDFS replication to Azure SQL Database.
-
Getting Started with the CData Python Connector for ServiceNow
Learn to install and license the CData Python Connector
-
Build Voice Agents in ElevenLabs with access to Live Presto Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Presto.
-
Publish Azure DevOps-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Azure DevOps.
-
Integrating Codex CLI with HubDB 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.
-
Add SAP Fieldglass Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for SAP Fieldglass with the Informatica Enterprise Data Catalog to classify and organize data.
-
Access AlloyDB Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Google AlloyDB from HeidiSQL.
-
Integrate Theia IDE with Live Microsoft Teams Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE
-
Object-Relational Mapping (ORM) with Cloudflare Data Entities in Java
Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to Cloudflare into a Java-based ORM framework, Hibernate.
-
Choosing the Best Method to Connect Pushbullet to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Pushbullet from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Migrating data from Paylocity to Snowflake using CData SSIS Components.
Easily push Paylocity to Snowflake using the CData SSIS Tasks for Paylocity and Snowflake.
-
Connect to GitLab Data in ACL Analytics
Connect to GitLab via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to GitLab.
-
Build Gmail-Powered Applications in Claude Code with CData MCP Server
Use the CData MCP Server for Gmail to explore live Gmail Data in Claude Code to assist with building Gmail-powered applications.
-
Use the CData Software JDBC Driver for Drift in MicroStrategy Web
Connect to Drift in MicroStrategy Web using the CData Software JDBC Driver for Drift.
-
Connect to GitLab Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for GitLab.
-
Write a Simple Go Application to work with SuiteCRM Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to SuiteCRM.
-
Getting Started with the CData Power BI Connector for Reckon Accounts Hosted
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Reckon Accounts Hosted.
-
Prepare, Blend, and Analyze Avaza Data in Alteryx Designer (ODBC)
Build workflows to access live Avaza for self-service data analytics.
-
Edit and Search External NetSuite Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of NetSuite CRM & ERP to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create NetSuite Data objects that you can access from apps and the dashboard.
-
Automate Browserless Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Browserless from PowerShell? This article demonstrates how to utilize the Browserless Cmdlets for tasks like connecting to Browserless, automating operations, downloading data, and more.
-
Use the CData Software JDBC Driver for RSS in MicroStrategy
Connect to RSS Feeds in MicroStrategy Developer using the CData Software JDBC Driver for RSS.
-
Build Acumatica-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Acumatica Data from Zoho Analytics and import live Acumatica ERP.
-
Integrate QuickBooks Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live QuickBooks Desktop from Informatica Cloud.
-
How to connect SharePoint with MailerSend Data through external lists
Provide MailerSend to SharePoint users as an external list.
-
Create Datasets from Avaza in Domo Workbench and Build Visualizations of Avaza Data in Domo
Use the CData Software ODBC Driver for Avaza to create datasets from Avaza in Domo Workbench and then build visualizations in the Domo service.
-
Getting Started with the CData ODBC Driver for Splunk
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Splunk.
-
Integrating Cursor CLI with Aweber 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.
-
Build Charts with Access Data in Clear Analytics
Create dynamic charts and perform analytics based on Microsoft Access in Clear Analytics.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Google Search
Provide connectivity to Google Search through an SAP BusinessObjects universe.
-
Establish a Live Connection with Google Directory Data using Tableau Bridge
The CData ODBC Driver for Google Directory enables you to integrate live Google Directory into Tableau Cloud dashboards using the Tableau Bridge.
-
Use the CData Software ODBC Driver for MailerSend in MicroStrategy Web
Connect to MailerSend in MicroStrategy Web using the CData Software ODBC Driver for MailerSend.
-
Integrating OpenCode Terminal with Pipeline CRM 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.
-
Query Live Snowflake Data in Zed Editor via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Zed Editor to securely access and query live Snowflake directly from the development environment.
-
Automated Continuous Oracle SCM Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Oracle SCM replication to IBM DB2.
-
Query Google Calendar Data as a MySQL Database in Node.js
Execute MySQL queries against Google Calendar from Node.js.
-
Connect to Snowflake Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Snowflake to connect to Snowflake and execute queries in PowerBuilder.
-
How to Connect Flowise AI Agents to Live BigQuery 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 Google BigQuery without replication.
-
Access Live Oracle Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Oracle Database from your Excel spreadsheets.
-
Visualize Google Translate Data in Tableau
The CData ODBC driver for Google Translate enables you integrate Google Translate into Tableau dashboards.
-
Connect to Cloudant Data from AWS Glue
Use CData Connect AI to gain access to live IBM Cloudant from your AWS Glue jobs.
-
Explore Geographical Relationships in Onfleet Data with Power Map
Create data visualizations with Onfleet in Power Map.
-
Connect to MailerSend from Asprova with CData Software ODBC Driver for MailerSend
This article shows how to connect faster to MailerSend data from Asprova.
-
Automate Amazon S3 Data Replication to Azure Data Lake
Use CData Sync to customize and automate Amazon S3 replication to Azure Data Lake.
-
How to publish and share Oracle Service Cloud Data dashboards with Tableau Server
The CData ODBC driver for Oracle Service Cloud enables you integrate Oracle Service Cloud into Tableau dashboards.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed CockroachDB to Power BI dashboards. Simply drag and drop CockroachDB into data visuals on the Power BI canvas.
-
Consume Hubstaff OData Feeds in PowerBuilder
This article demonstrates how to consume Hubstaff as OData feeds from PowerBuilder using the API Server.
-
Visualize Live Marketo Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Marketo into custom reports in Power BI.