CData Software - Knowledge Base
Recent Articles
-
Use Azure AI Foundry to Talk to Your Splunk 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 Splunk for you.
-
Access Live Instagram 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 Instagram through MCP integration.
-
Integrating Dataiku with ShipStation Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live ShipStation.
-
Create Azure DevOps-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Azure DevOps Data from OutSystems and build custom enterprise apps using live Azure DevOps.
-
Connect Autopilot to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Autopilot with IBM WebSphere for seamless data integration and connectivity.
-
Use Grok to Talk to Your MarkLogic 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 MarkLogic for you.
-
How to Connect to Live Reckon Accounts Hosted Data from OpenAI Python Applications (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable OpenAI-powered Python applications to securely read and take actions on your Reckon Accounts Hosted through natural language.
-
How to connect to SharePoint Data from Spring Boot
Connect to SharePoint in a Spring Boot Application using the CData JDBC Driver for SharePoint
-
Object-Relational Mapping (ORM) with Keap 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 Keap into a Java-based ORM framework, Hibernate.
-
Moving Data from Drift to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Drift data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Use the CData Software ODBC Driver for Airtable in SAS for Real-Time Reporting and Analytics
Connect to real-time Airtable in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Airtable.
-
Connecting Agentforce with Authorize.Net 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 Authorize.Net for you.
-
Integrate MarkLogic Data into Power Automate Desktop using CData Connect
CData Connect for MarkLogic Data enables you to integrate MarkLogic into workflows built using Microsoft Power Automate Desktop.
-
Getting Started with the CData ADO.NET Provider for Azure DevOps
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Azure DevOps.
-
Connect to Adobe Commerce Data in RapidMiner
Integrate Adobe Commerce with standard components and data source configuration wizards in RapidMiner Studio.
-
Analyze Trello Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Trello with the CData JDBC Driver for Trello.
-
Integrate Theia IDE with Live SAS Data Sets Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE
-
ETL Delighted in Oracle Data Integrator
This article shows how to transfer Delighted into a data warehouse using Oracle Data Integrator.
-
Access CampaignMonitor Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live CampaignMonitor from HeidiSQL.
-
How to Query Live Sage 200 Data in Claude Desktop
Connect to and query live Sage 200 Data in Claude Desktop using CData MCP Server.
-
Automated Continuous Oracle Replication to SQL Server
Use CData Sync for automated, continuous, customizable Oracle replication to SQL Server.
-
Access Zoho Creator Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Zoho Creator from HeidiSQL.
-
Trigger Reckon IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for Reckon with standard wizards in Logic Apps.
-
Connect to Nuclia Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Nuclia using standard SQL.
-
Connect to MailerSend Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for MailerSend.
-
Provide OData Services of Bitly Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Bitly by developing a WCF Service Application.
-
Visualize Office 365 Data in TIBCO Spotfire through ADO.NET
Integrate Microsoft Office 365 into dashboards in TIBCO Spotfire.
-
Analyze BambooHR Data in Looker
Use CData Connect AI to connect to BambooHR Data from Looker and build custom apps using live BambooHR.
-
How to Import Data from Google Campaign Manager 360 into Google Sheets
Import Google Campaign Manager 360 into a Google spreadsheet that is automatically refreshed.
-
Object-Relational Mapping (ORM) with FreeAgent 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 FreeAgent into a Java-based ORM framework, Hibernate.
-
Create Data Visualizations in Cognos BI with Blackbaud FE NXT Data
Access Blackbaud FE NXT as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Use ChatGPT to Talk to Your Epicor Kinetic Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable ChatGPT to securely answer questions and take actions on your Epicor Kinetic for you.
-
Integrating Foursquare Data in Talend Cloud Data Management Platform
Connect Foursquare Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Establish a Live Connection with ElevenLabs Data using Tableau Bridge
The CData ODBC Driver for ElevenLabs enables you to integrate live ElevenLabs into Tableau Cloud dashboards using the Tableau Bridge.
-
Natively Connect to JSON Services in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to JSON. Leverage the native support for ODBC in PHP.
-
Use the CData Software JDBC Driver for Zoho Books in MicroStrategy Web
Connect to Zoho Books in MicroStrategy Web using the CData Software JDBC Driver for Zoho Books.
-
Prepare, Blend, and Analyze Dynamics NAV Data in Alteryx Designer (ODBC)
Build workflows to access live Microsoft Dynamics NAV for self-service data analytics.
-
Connect to Productboard Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Connect to CouchDB Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Apache CouchDB.
-
Analyze Perigon Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Perigon with the CData JDBC Driver for Perigon.
-
How to use SQLAlchemy ORM to access Tickspot Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Tickspot.
-
Connect to Vercel Data in HULFT Integrate
Connect to Vercel as a JDBC data source in HULFT Integrate
-
Create SendGrid-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to SendGrid Data from OutSystems and build custom enterprise apps using live SendGrid.
-
How to Create Power BI Visual Reports with Real-Time SAP Business Warehouse Data
Use CData Power BI Connectors to visualize SAP Business Warehouse in Power BI.
-
Deploy the ADO.NET Provider for Certinia on an SSRS Report Server
Connect to Certinia 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 BigCommerce Visualizations in Tableau Desktop
Use CData Connect AI to connect to live BigCommerce and build visualizations in Tableau.
-
Visualize MariaDB Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to MariaDB.
-
Automated Continuous Everhour Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Everhour replication to PostgreSQL.
-
Automated Continuous Zoho CRM Replication to MySQL
Use CData Sync for automated, continuous, customizable Zoho CRM replication to MySQL.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Marketo within intelligent workflows.
-
How to publish and share SAP Netweaver Gateway Data dashboards with Tableau Server
The CData ODBC driver for SAP Netweaver Gateway enables you integrate SAP Netweaver Gateway into Tableau dashboards.
-
Build Excel Online-Connected Apps in Choreo
Use CData Connect AI to connect to Excel Online Data from Choreo and build custom apps using live Microsoft Excel Online.
-
Access Live Retently Data in AWS Lambda
Connect to live Retently in AWS Lambda using the CData JDBC Driver.
-
Operational Reporting on Supabase Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Supabase.
-
Use Agno to Talk to Your SAP Hybris C4C Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Agno agents to securely answer questions and take actions on your SAP Hybris C4C for you.
-
How to Create Power BI Visual Reports with Real-Time Oracle Sales Data
Use CData Power BI Connectors to visualize Oracle Sales in Power BI.
-
Use the CData Software ODBC Driver for Zendesk in MicroStrategy Desktop
Connect to Zendesk in MicroStrategy Desktop using the CData Software ODBC Driver for Zendesk.
-
How to Access Live RabbitMQ Data in Power Automate Desktop via ODBC
The CData ODBC Driver for RabbitMQ enables you to integrate RabbitMQ into workflows built using Microsoft Power Automate Desktop.
-
Connect to MySQL Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for MySQL in Airbyte.
-
Connect to Bugsnag Data in Jaspersoft Studio
Execute SQL to remote Bugsnag in Jaspersoft Studio.
-
Optimizely Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Optimizely facts in real time.
-
Build Pipelines with Live Tally Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Tally from Google Cloud Data Fusion, enabling the integration of live Tally ERP into the building and management of effective data pipelines.
-
Connect to OnePageCrm Data in NetBeans
Connect to OnePageCrm in NetBeans with the data source configuration wizard.
-
Explore Geographical Relationships in Act CRM Data with Power Map
Create data visualizations with Act CRM in Power Map.
-
Automate ZendeskSell Data Replication to Azure Data Lake
Use CData Sync to customize and automate ZendeskSell replication to Azure Data Lake.
-
Integrating Boomi Agentstudio with SAS xpt Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to SAS XPORT, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
How to Create Power BI Visual Reports with Real-Time MessageBird Data
Use CData Power BI Connectors to visualize MessageBird in Power BI.
-
Automated Continuous Mouseflow Replication to MySQL
Use CData Sync for automated, continuous, customizable Mouseflow replication to MySQL.
-
Connect to Guru Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Guru.
-
Viewing Jumpseller Data in RAD Studio Data Explorer
How to view Jumpseller in RAD Studio Data Explorer using the CData ODBC Driver for Jumpseller.
-
Getting Started with the CData Tableau Connector for Zoom
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Establish a Live Connection with Anaplan Data using Tableau Bridge
The CData ODBC Driver for Anaplan enables you to integrate live Anaplan into Tableau Cloud dashboards using the Tableau Bridge.
-
Create Teradata Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Teradata from PowerBI.com to create Power BI Dataflows with real-time data.
-
Replicate Oracle Eloqua Data from PowerShell
Write a quick PowerShell script to query Oracle Eloqua. Use connectivity to the live data to replicate Oracle Eloqua to SQL Server.
-
How to Connect the Power BI Service to Invoiced: Complete Guide
Connect to the CData Software Power BI Connector for Invoiced from PowerBI.com to provide real-time Invoiced across the organization.
-
How to connect PolyBase to Amazon DynamoDB
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Amazon DynamoDB.
-
Integrate with Live Salesforce Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Salesforce from the MuleSoft Anypoint Platform to integrate live Salesforce & Force.com into custom reports and dashboards.
-
Use the CData ODBC Driver for OpenWeatherMap in Microsoft Power Query
You can use the CData OpenWeatherMap ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import OpenWeatherMap into Microsoft Power Query.
-
How to Connect to MailChimp Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to MailChimp. Leverage the pyodbc module for ODBC in Python.
-
Automate Jumpseller Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Jumpseller from PowerShell? This article demonstrates how to utilize the Jumpseller Cmdlets for tasks like connecting to Jumpseller, automating operations, downloading data, and more.
-
Getting Started with the CData ADO.NET Provider for Pipedrive
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Pipedrive.
-
Create Reports with Freshsales Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Freshsales.
-
Migrating data from Samanage to Databricks using CData SSIS Components.
Easily push Samanage to Databricks using the CData SSIS Tasks for Samanage and Databricks.
-
Automated Continuous Testmonitor Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Testmonitor replication to delimited files (CSV/TSV).
-
Create Dynamic SurveyMonkey Grids Using the Infragistics XamDataGrid
Learn how you can connect SurveyMonkey to Infragistics XamDataGrid to build dynamic grids.
-
Extract, Transform, and Load Perigon Data in Informatica PowerCenter
Create a simple Workflow for Perigon in Informatica PowerCenter.
-
Connect to HBase Data in CloverDX (formerly CloverETL)
Transfer Apache HBase using the visual workflow in the CloverDX data integration tool.
-
Visualize Unbounce 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 Unbounce into TIBCO Spotfire.
-
Connect Dynamics NAV Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Microsoft Dynamics NAV using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Connecting Mastra with BigQuery 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 Google BigQuery, no replication required.
-
Create a Data Access Object for Amplitude Data using JDBI
A brief overview of creating a SQL Object API for Amplitude in JDBI.
-
Integrate with Telegram Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Telegram to a JSON file on disk.
-
Design BIRT Reports on Datadog Data
Provide current Datadog to your embedded analytics.
-
Connect to GitHub Data from a Connection Pool in JBoss
Integrate GitHub into Java servlets: Use the Management Console in JBoss to install the GitHub JDBC Driver.
-
Automated Continuous Amazon DynamoDB Replication to Databricks
Use CData Sync for automated, continuous, customizable Amazon DynamoDB replication to Databricks.
-
Create Apps from Sybase Data in Qlik Sense Cloud
Use CData Connect AI to connect to Sybase Data and build apps from live Sybase in Qlik Sense Cloud.
-
Access JSON Services from MySQL in PHP
Connect to JSON through the standard MySQL libraries in PHP.
-
Integrate Goose with Live Cosmos DB Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Azure Cosmos DB from within the local AI agent.
-
Analyze Rootly Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Rootly from Power Pivot. You will use the Table Import Wizard to load Rootly. You can visually build the import query or use any SQL supported by the driver.
-
Replicate Multiple Quaderno Accounts via the CData Sync CLI
Replicate multiple Quaderno accounts to one or many databases.