CData Software - Knowledge Base
Recent Articles
-
Visualize Pushbullet Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Pushbullet.
-
Integrating Claude Code CLI with Beeminder 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.
-
Connect to Salesforce Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Salesforce and the SQL Gateway to access Salesforce & Force.com from Google Apps Script.
-
Build Pipelines with Live Workday Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Workday from Google Cloud Data Fusion, enabling the integration of live Workday into the building and management of effective data pipelines.
-
Connect to WooCommerce Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Stream Strava Data into Apache Kafka Topics
Access and stream Strava in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Connect to Live JSON Services in MicroStrategy through CData Connect AI
Create a live connection to JSON Services in CData Connect AI and connect to your JSON from MicroStrategy.
-
Use the CData ODBC Driver for HCL Domino from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for HCL Domino to connect to HCL Domino from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring HCL Domino in Excel.
-
Automate Sentry Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Sentry from PowerShell? This article demonstrates how to utilize the Sentry Cmdlets for tasks like connecting to Sentry, automating operations, downloading data, and more.
-
Extract, Transform, and Load MailChimp Data in Informatica PowerCenter
Create a simple Workflow for MailChimp in Informatica PowerCenter.
-
Publish OpenWeatherMap-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live OpenWeatherMap.
-
How to Easily Query Google Contacts Data in OpenOffice Base
Connect to Google Contacts data in OpenOffice Base using the CData ODBC Driver for Google Contacts and generate reports with live data insights.
-
Automated Continuous GetResponse Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable GetResponse replication to delimited files (CSV/TSV).
-
Getting Started with the CData Excel Add-In for Paylocity
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Paylocity.
-
How to Build an ETL App for Aha! Data in Python with CData
Create ETL applications and real-time data pipelines for Aha! in Python with petl.
-
Publish CampaignMonitor-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live CampaignMonitor.
-
Prepare, Blend, and Analyze BigQuery Data in Alteryx Designer (ODBC)
Build workflows to access live Google BigQuery for self-service data analytics.
-
Managing Snowflake TIMESTAMP discrepancies with CData Drivers
TIMESTAMP columns can be difficult thing to manage when insert data into Snowflake. This article explains what you need to know about Snowflake TIMESTAMP types and how to manage them with CData Drivers.
-
How to Access Live Couchbase Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Couchbase enables you to integrate Couchbase into workflows built using Microsoft Power Automate Desktop.
-
Automated Continuous PayPal Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable PayPal replication to Azure SQL Database.
-
Build Pipelines with Live GraphQL Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to GraphQL from Google Cloud Data Fusion, enabling the integration of live GraphQL into the building and management of effective data pipelines.
-
Validate Google Ads Data with QuerySurge
Access and validate Google Ads in QuerySurge using the CData JDBC Driver.
-
Build Visualizations of Google Campaign Manager 360 Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Google Campaign Manager 360 in Birst.
-
Use Dash to Build to Web Apps on Azure Data Catalog Data
Create Python applications that use pandas and Dash to build Azure Data Catalog-connected web apps.
-
How to Connect to SageHR Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to SageHR. Leverage the pyodbc module for ODBC in Python.
-
Design BIRT Reports on PDFMonkey Data
Provide current PDFMonkey to your embedded analytics.
-
Connect to Live Kintone Data in MicroStrategy through CData Connect AI
Create a live connection to Kintone Data in CData Connect AI and connect to your Kintone from MicroStrategy.
-
Create Reports with ChartMogul Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date ChartMogul.
-
Integrate with Miro Data in JReport Designer
Create charts and reports based on Miro in JReport Designer.
-
Create Datasets from AgileCRM in Domo Workbench and Build Visualizations of AgileCRM Data in Domo
Use the CData Software ODBC Driver for AgileCRM to create datasets from AgileCRM in Domo Workbench and then build visualizations in the Domo service.
-
Build SAP Concur-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData MCP Server for SAP Concur to explore live SAP Concur Data in GitHub Copilot to assist with building SAP Concur-powered applications.
-
A PostgreSQL Interface for Drip Data (MySQL Remoting via JDBC)
Use the Remoting features of the Drip JDBC Driver to create a PostgreSQL entry-point for data access.
-
Build Dashboards with Presto Data in Dundas BI
Create dynamic dashboards and perform analytics based on Presto in Dundas BI.
-
Automated Continuous MailChimp Replication to Databricks
Use CData Sync for automated, continuous, customizable MailChimp replication to Databricks.
-
How to connect to Customer.io Data in DBVisualizer
Integrate Customer.io with visual data analysis tools and data connection wizards in DBVisualizer
-
Replicate Multiple GraphQL Accounts via the CData Sync CLI
Replicate multiple GraphQL accounts to one or many databases.
-
Integrating GitHub Copilot CLI with Productboard 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 Work with SAP Hybris C4C Data in AWS Glue Jobs Using JDBC
Connect to SAP Hybris C4C from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Use the CData ODBC Driver for iContact in Microsoft Power Query
You can use the CData iContact ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import iContact into Microsoft Power Query.
-
How to Design Quickbase Power Apps with Database-Like Connectivity
Gain real-time, database-like connectivity to Quickbase from mobile and tablet Power Apps.
-
Integrating Kiro CLI with Zoho Recruit 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 Zoho CRM in Domo Workbench and Build Visualizations of Zoho CRM Data in Domo
Use the CData Software ODBC Driver for Zoho CRM to create datasets from Zoho CRM in Domo Workbench and then build visualizations in the Domo service.
-
Connect to and Query Egnyte Data in QlikView over ODBC
Create data visualizations with Egnyte in QlikView.
-
Connect to Opsgenie from a Connection Pool in WebLogic
Use the CData JDBC Driver for Opsgenie to connect to Opsgenie from Web applications running on WebLogic.
-
Build Voice Agents in ElevenLabs with access to Live Oracle Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Oracle Database.
-
Connect to Notion Data in Aqua Data Studio
Access Notion from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
How to create an RPA flow for Campaigner Data in UiPath Studio
Use the Campaigner ODBC Driver to create workflows that access real-time Campaigner without any coding.
-
Create a Data Access Object for Snapchat Ads Data using JDBI
A brief overview of creating a SQL Object API for Snapchat Ads in JDBI.
-
Access Live Amazon Marketplace Data in Roo Code via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Roo Code agents to securely access and build applications with live Amazon Marketplace through MCP integration.
-
Getting Started with the CData SSIS Components for Google Calendar
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Google Calendar.
-
Analyze Adobe Target Data in Infragistics Reveal
Use the CData API Server to create an OData API on top of Adobe Target and visualize live Adobe Target in Infragistics Reveal.
-
Connect to Rebilly from Asprova with CData Software ODBC Driver for Rebilly
This article shows how to connect faster to Rebilly data from Asprova.
-
Visualize SAP SuccessFactors LMS 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 SAP SuccessFactors LMS into TIBCO Spotfire.
-
Getting Started with the CData ODBC Driver for SAP Hybris C4C
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for SAP Hybris C4C.
-
Automated Continuous SAP Concur Replication to Vertica
Use CData Sync for automated, continuous, customizable SAP Concur replication to Vertica.
-
Integrate Monday.com Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Monday.com and integrate live Monday.com into your Power Automate tasks.
-
Import Real-Time Salesforce Data 360 Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Salesforce Data 360 in ColdFusion.
-
Connect to Facebook Ads 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 Facebook Ads.
-
Getting Started with the CData ADO.NET Provider for Avalara AvaTax
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Avalara AvaTax.
-
Automated Continuous MYOB AccountRight Replication to Snowflake
Use CData Sync for automated, continuous, customizable MYOB AccountRight replication to Snowflake.
-
How to connect SharePoint with SFTP Data through external lists
Provide SFTP to SharePoint users as an external list.
-
How to use SQLAlchemy ORM to access Coda Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Coda.
-
Moving Data from Bugsnag to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Bugsnag data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Automate MySQL Data Replication to Couchbase
Use CData Sync to Customize and automate MySQL replication to Couchbase.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed GraphQL to Power BI dashboards. Simply drag and drop GraphQL into data visuals on the Power BI canvas.
-
Integrating Cursor CLI with BigQuery 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.
-
Integrate Snowflake Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Snowflake from Informatica Cloud.
-
Build GitHub-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData MCP Server for GitHub to explore live GitHub Data in GitHub Copilot to assist with building GitHub-powered applications.
-
Design BIRT Reports on Bitly Data
Provide current Bitly to your embedded analytics.
-
Integrating Antigravity CLI with Google Analytics via CData CLI
Connect Google Analytics to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Visualize Live Procore Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Procore.
-
Access Live Salesforce Marketing Data in Emergent via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Emergent agents to securely access and build applications with live Salesforce Marketing Cloud through MCP integration.
-
How to Query Live PDFMonkey Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live PDFMonkey data in natural language using Python.
-
How to Connect DBeaver to Hive via a JDBC Driver
Manage Apache Hive with visual tools in DBeaver like the query browser.
-
Use Biml to Build SSIS Tasks to Replicate Pipeliner CRM Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Pipeliner CRM to SQL Server.
-
Connect to SAP ByDesign Data from HeidiSQL
Use CData Connect AI to connect to and query live SAP Business ByDesign from HeidiSQL.
-
How to connect to Amazon S3 Data from Spring Boot
Connect to Amazon S3 in a Spring Boot Application using the CData JDBC Driver for Amazon S3
-
Connect to Telegram Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Telegram and the SQL Gateway to access Telegram from Google Apps Script.
-
Connect to NetSuite from a Connection Pool in WebLogic
Use the CData JDBC Driver for NetSuite to connect to NetSuite CRM & ERP from Web applications running on WebLogic.
-
Connect to Dynamics 365 Business Central Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Dynamics 365 Business Central Data and connect to Dynamics 365 Business Central in Akorbi Digital RunMyProcess.
-
Create Oracle Eloqua Reporting Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Oracle Eloqua Reporting from PowerBI.com to create Power BI Dataflows with real-time data.
-
Create SSAS Tabular Models from Onfleet Data
How to build a SQL Server Analysis Service Tabular Model from Onfleet using CData drivers.
-
Query HBase Data as a SQL Server Database in Node.js
Execute SQL Server queries against Apache HBase from Node.js.
-
Access Live LinkedIn Ads Data in Coginiti Pro
Connect to and query live LinkedIn Ads from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Viewing Factorial Data in RAD Studio Data Explorer
How to view Factorial in RAD Studio Data Explorer using the CData ODBC Driver for Factorial.
-
How to Work with Oracle Eloqua Reporting Data in AWS Glue Jobs Using JDBC
Connect to Oracle Eloqua Reporting from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Analyze Amazon S3 Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Amazon S3 and visualize live Amazon S3 in Infragistics Reveal.
-
Build Sugar CRM-Powered Applications in Cursor with CData MCP Server
Use the CData MCP Server for Sugar CRM to explore live Sugar CRM Data in Cursor to assist with building Sugar CRM-powered applications.
-
Connect to LaunchDarkly Data from PowerBuilder via ADO.NET
This article demonstrates how to access LaunchDarkly from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
How to Connect to Live Microsoft Entra ID Data from Gemini CLI (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Gemini CLI to securely read and take actions on your Microsoft Entra ID for you.
-
How to Access Live Rebilly Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Rebilly enables you to integrate Rebilly into workflows built using Microsoft Power Automate Desktop.
-
Automated Continuous Freshdesk Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Freshdesk replication to Google Cloud SQL.
-
Create Datasets from Amplitude in Domo Workbench and Build Visualizations of Amplitude Data in Domo
Use the CData Software ODBC Driver for Amplitude to create datasets from Amplitude in Domo Workbench and then build visualizations in the Domo service.
-
Automate Tasks in Power Automate Using the CData API Server
Automate AlloyDB actions in Microsoft Flow — sending emails, posting to social media, or syncing CRM and ERP.
-
Rapidly Develop Basecamp-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 Basecamp.
-
Access Live YouTube Analytics Data in Roo Code via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Roo Code agents to securely access and build applications with live YouTube Analytics through MCP integration.
-
Access Live Cohere Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Cohere into the statistical analysis tools available in SAS JMP. This article shows how to use Cohere in the Graph Builder and Query Builder.
-
Build FreshBooks-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for FreshBooks Data and create custom apps in Bubble.
-
Replicate AdRoll Data in Heroku for Use in Salesforce Connect
Replicate AdRoll to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Using the CData Software ODBC Driver for ZeroBounce in PyCharm
Connect to ZeroBounce as an ODBC data source in PyCharm using the CData Software ODBC Driver for ZeroBounce.