CData Software - Knowledge Base
Recent Articles
-
Analyze Azure DevOps Data in Cognos Analytics
Use CData Connect AI to connect to Azure DevOps Data from Cognos Analytics and analyze live Azure DevOps.
-
LINQ to Twitter Ads Data
LINQ offers versatile querying capabilities within the .NET Framework (v3.0+), offering a straightforward method for programmatic data access through CData ADO.NET Data Providers. In this article, we demonstrate the use of LINQ to retrieve information from the Twitter Ads Data Provider.
-
Replicate Blackbaud FE NXT Data in Heroku for Use in Salesforce Connect
Replicate Blackbaud FE NXT to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Integrate Real-Time Access to Box in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Box in real time.
-
Build Dashboards with Wave Financial Data in DBxtra
Create dynamic dashboards and perform analytics based on Wave Financial in DBxtra.
-
A PostgreSQL Interface for Bitbucket Data (MySQL Remoting via JDBC)
Use the Remoting features of the Bitbucket JDBC Driver to create a PostgreSQL entry-point for data access.
-
Getting Started with the CData Tableau Connector for Amazon DynamoDB
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Amazon DynamoDB.
-
Connect to and Visualize Live SurveyMonkey Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live SurveyMonkey.
-
Analyze Factorial Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Factorial from Power Pivot. You will use the Table Import Wizard to load Factorial. You can visually build the import query or use any SQL supported by the driver.
-
Build Voice Agents in ElevenLabs with access to Live Splunk Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Splunk.
-
Import Sybase IQ Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Sybase IQ. In this article, you will use the OData format to import Sybase IQ into Microsoft Power Query.
-
Natively Connect to OpenWeatherMap Data in PHP
The CData ODBC driver for OpenWeatherMap enables you to create PHP applications with connectivity to OpenWeatherMap. Leverage the native support for ODBC in PHP.
-
Viewing Freshteam Data in RAD Studio Data Explorer
How to view Freshteam in RAD Studio Data Explorer using the CData ODBC Driver for Freshteam.
-
Visualize Instagram Data in Sisense
Create an ElastiCube in Sisense app with access to Instagram.
-
Connect to Grafana Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Grafana to connect to Grafana and execute queries in PowerBuilder.
-
Build Impala-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Apache Impala and build Impala-connected web apps with Axios.
-
Query Google Ads Data in ColdFusion
Write standard ColdFusion data access code to connect to Google Ads.
-
Connect to Databricks from Asprova with CData Software ODBC Driver for Databricks
This article shows how to connect faster to Databricks data from Asprova.
-
How to connect to CampaignMonitor Data from Spring Boot
Connect to CampaignMonitor in a Spring Boot Application using the CData API Driver for JDBC
-
How to Easily Query Freshdesk Data in OpenOffice Base
Connect to Freshdesk data in OpenOffice Base using the CData ODBC Driver for Freshdesk and generate reports with live data insights.
-
Explore Geographical Relationships in Aweber Data with Power Map
Create data visualizations with Aweber in Power Map.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Mailgun
Provide connectivity to Mailgun through an SAP BusinessObjects universe.
-
Integrate Billsby Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Billsby from Informatica Cloud.
-
A PostgreSQL Interface for Zoom Data (MySQL Remoting via JDBC)
Use the Remoting features of the Zoom JDBC Driver to create a PostgreSQL entry-point for data access.
-
DataBind Power BI XMLA Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for Power BI XMLA with the DevExpress Windows Forms and Web controls to provide Power BI XMLA to a chart.
-
How to load EmailOctopus data into Elasticsearch via Logstash
Introducing a simple method to load EmailOctopus data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Integrating Cursor CLI with ActiveCampaign 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.
-
Getting Started with the CData Power BI Connector for Quaderno
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Build Microsoft Dataverse-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Microsoft Dataverse Data and create custom apps in Mendix.
-
How to Connect DBeaver to Neo4J via a JDBC Driver
Manage Neo4J with visual tools in DBeaver like the query browser.
-
Establish a Live Connection with HelloSign Data using Tableau Bridge
The CData ODBC Driver for HelloSign enables you to integrate live HelloSign into Tableau Cloud dashboards using the Tableau Bridge.
-
Explore Geographical Relationships in Epicor Kinetic Data with Power Map
Create data visualizations with Epicor Kinetic in Power Map.
-
Build Stripe-Powered Applications in Claude Code with CData MCP Server
Use the CData MCP Server for Stripe to explore live Stripe Data in Claude Code to assist with building Stripe-powered applications.
-
Build Dashboards with Cvent Data in Dundas BI
Create dynamic dashboards and perform analytics based on Cvent in Dundas BI.
-
Connect to SAP Ariba Procurement Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live SAP Ariba Procurement from Filemaker Pro on Mac.
-
How to Connect DBeaver to BigQuery via a JDBC Driver
Manage Google BigQuery with visual tools in DBeaver like the query browser.
-
How to load PivotalTracker data into Elasticsearch via Logstash
Introducing a simple method to load PivotalTracker data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Build a PostgreSQL Interface for Azure Analysis Services Data using the CData JDBC Driver
Use the Remoting features of the Azure Analysis Services JDBC Driver to create a PostgreSQL entry-point for data access.
-
Automated Continuous ShipStation Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable ShipStation replication to OneLake in Microsoft Fabric.
-
Connect to Azure DevOps from Asprova with CData Software ODBC Driver for Azure DevOps
This article shows how to connect faster to Azure DevOps data from Asprova.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Box within intelligent workflows.
-
Integrate with live Jira Assets Data in Jitterbit
Use CData Connect AI to connect to and integrate live Jira Assets in Jitterbit.
-
Use the CData Software JDBC Driver for HDFS in MicroStrategy
Connect to Apache HDFS in MicroStrategy Developer using the CData Software JDBC Driver for HDFS.
-
Access Live BigQuery 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 Google BigQuery through MCP integration.
-
Analyze Yelp Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Yelp with the CData JDBC Driver for Yelp.
-
How to create SAP Concur federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for SAP Concur in MySQL .
-
Access Live Pipeliner CRM Data in Coginiti Pro
Connect to and query live Pipeliner CRM from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Connect to HBase Data as an External Source in Dremio
Use the CData JDBC Driver to connect to HBase as an External Source in Dremio.
-
Build Vault CRM-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Veeva Vault & Vault CRM.
-
Configure the CData JDBC Driver for Avalara AvaTax in a Connection Pool in Tomcat
Connect to Avalara AvaTax from a connection pool in Tomcat.
-
How to Work with Aha! Data in AWS Glue Jobs Using JDBC
Connect to Aha! from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
View Reports on Real-Time Helpscout Data in Power BI Report Server
Use the CData ODBC Driver for Helpscout to visualize Helpscout in Power BI Desktop and then publish them to Power BI Report Server.
-
Extend Google Sheets with SAP Business One Data
Make calls to SAP Business One from Google Apps Script via the API Server.
-
Replicate Greenhouse Data to Multiple Databases
Replicate Greenhouse to disparate databases with a point-and-click configuration.
-
Manage Google Tasks Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Google Tasks.
-
Connect to PolarTeamPro Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for PolarTeamPro in the Denodo Virtual DataPort Administrator.
-
Automated Continuous Figshare Replication to Databricks
Use CData Sync for automated, continuous, customizable Figshare replication to Databricks.
-
Build a PostgreSQL Interface for HCL Domino Data using the CData JDBC Driver
Use the Remoting features of the HCL Domino JDBC Driver to create a PostgreSQL entry-point for data access.
-
Use the CData Software JDBC Driver for JotForm in MicroStrategy Desktop
Connect to JotForm in MicroStrategy Desktop using the CData Software JDBC Driver for JotForm.
-
Connect to Samanage Data from PowerBuilder via ADO.NET
This article demonstrates how to access Samanage from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Creating SAP SuccessFactors-Connected Applications in Unqork
You can use CData Connect AI to feed SAP SuccessFactors to Unqork and build custom business apps.
-
Automated Continuous Toggl Replication to MySQL
Use CData Sync for automated, continuous, customizable Toggl replication to MySQL.
-
Connecting Mastra with Freshservice Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to enable Mastra agents to securely query, read, and act on real-time Freshservice, no replication required.
-
Stream Amazon Marketplace Data into Apache Kafka Topics
Access and stream Amazon Marketplace in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Add Email Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Email with the Informatica Enterprise Data Catalog to classify and organize data.
-
How to Access Live Dynamics NAV Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Dynamics NAV enables you to integrate Microsoft Dynamics NAV into workflows built using Microsoft Power Automate Desktop.
-
Build Apps with Live Raisers Edge NXT Data Using the Low-Code Development Platform of Mendix
Connect Raisers Edge NXT with Mendix to build apps using the CData JDBC Driver for Raisers Edge NXT.
-
Model, Search, and Visualize Live Pipedrive Data in ThoughtSpot
Use CData Connect AI to connect to live Pipedrive for modeling, searching, and visualizing.
-
Using the CData Software ODBC Driver for Supabase in PyCharm
Connect to Supabase as an ODBC data source in PyCharm using the CData Software ODBC Driver for Supabase.
-
Getting Started with the CData JDBC Driver for Sybase IQ
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Sybase IQ.
-
Deploy the ADO.NET Provider for Demio on an SSRS Report Server
Connect to Demio 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.
-
Query SAP Ariba Source Data from Node.js
Use the OData endpoint of the CData API Server to connect to your SAP Ariba Source and perform CRUD operations on SAP Ariba Source from Node.js.
-
Automated Continuous LDAP Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable LDAP replication to Azure SQL Database.
-
Create Datasets from Anaplan in Domo Workbench and Build Visualizations of Anaplan Data in Domo
Use the CData Software ODBC Driver for Anaplan to create datasets from Anaplan in Domo Workbench and then build visualizations in the Domo service.
-
Integrating LlamaIndex with AlloyDB Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Google AlloyDB in real time.
-
Migrating data from Jira to Snowflake using CData SSIS Components.
Easily push Atlassian Jira to Snowflake using the CData SSIS Tasks for Jira and Snowflake.
-
Connect to Procore Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Procore using standard SQL.
-
How to Create Power BI Visual Reports with Real-Time ConstantContact Data
Use CData Power BI Connectors to visualize ConstantContact in Power BI.
-
How to Visualize Suadeo Data in Python with pandas
Use pandas and other modules to analyze and visualize live Suadeo in Python.
-
Use Azure AI Foundry to Talk to Your Procore Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Azure AI Foundry agents to securely answer questions and take actions on your Procore for you.
-
Connect to Mocean Data in RapidMiner
Integrate Mocean with standard components and data source configuration wizards in RapidMiner Studio.
-
How to connect Amazon QuickSight to Zoho Creator Data
Create a connection to Zoho Creator in CData Connect AI and insert Zoho Creator into Amazon QuickSight SPICE to build interactive dashboards.
-
Build Dashboards with Mailjet Data in Dundas BI
Create dynamic dashboards and perform analytics based on Mailjet in Dundas BI.
-
How to Connect to Strava Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Strava. Leverage the pyodbc module for ODBC in Python.
-
Automated Continuous Clockify Replication to Snowflake
Use CData Sync for automated, continuous, customizable Clockify replication to Snowflake.
-
Publish CapsuleCRM-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live CapsuleCRM.
-
Migrating data from Contentful to Databricks using CData SSIS Components.
Easily push Contentful to Databricks using the CData SSIS Tasks for Contentful and Databricks.
-
Use the CData SSIS Components to Insert New or Update Existing Teradata Records from SQL Server
Easily push SQL Server data to Teradata using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Teradata or update existing records with data from a SQL Server database.
-
How to Connect to Live Avalara AvaTax Data from Claude Agent SDK (via CData Connect AI)
Leverage CData Connect AI to enable Claude Agent SDK applications to securely read and take actions on your Avalara AvaTax for you.
-
Connect to Clio Data in DBArtisan
Use wizards in DBArtisan to configure Clio as a data source.
-
Build Semantic Layer Views for Oracle SCM Data in APOS Live Data Gateway
Use the CData Connector for Oracle SCM in APOS Live Data Gateway to build Semantic Layer Views for Oracle SCM.
-
Access Live Microsoft Entra ID Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Microsoft Entra ID from your Excel spreadsheets.
-
Use Grok to Talk to Your Smartsheet Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Grok AI to securely answer questions and take actions on your Smartsheet for you.
-
Connect Google Ads to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Google Ads with IBM WebSphere for seamless data integration and connectivity.
-
Build Pipelines with Live Stripe Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Stripe from Google Cloud Data Fusion, enabling the integration of live Stripe into the building and management of effective data pipelines.
-
ETL RabbitMQ in Oracle Data Integrator
This article shows how to transfer RabbitMQ into a data warehouse using Oracle Data Integrator.
-
Automated Continuous Outreach.io Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Outreach.io replication to delimited files (CSV/TSV).
-
Connect to Procore Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Procore and the SQL Gateway to access Procore from Google Apps Script.
-
Build Snapchat Ads-Connected Apps in Choreo
Use CData Connect AI to connect to Snapchat Ads Data from Choreo and build custom apps using live Snapchat Ads.
-
Automate LinkedIn Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live LinkedIn and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.