CData Software - Knowledge Base
Recent Articles
-
Visualize Live PingOne Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live PingOne using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
How to use SQLAlchemy ORM to access Flowlu Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Flowlu.
-
Back Up SAP SuccessFactors to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for SAP SuccessFactors. In this article, we will employ an SSIS workflow to populate a database with SAP SuccessFactors data.
-
Build MVC Applications with Connectivity to Azure DevOps Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Azure DevOps from an ASP.NET MVC application.
-
Use the CData ODBC Driver for Everhour in Microsoft Power Query
You can use the CData Everhour ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Everhour into Microsoft Power Query.
-
Use the CData Software JDBC Driver for Zendesk in MicroStrategy
Connect to Zendesk in MicroStrategy Developer using the CData Software JDBC Driver for Zendesk.
-
Replicate XML Data to Multiple Databases
Replicate XML Files to disparate databases with a point-and-click configuration.
-
Integrate with Nethunt Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Nethunt to a JSON file on disk.
-
Replicate Multiple Unbounce Accounts via the CData Sync CLI
Replicate multiple Unbounce accounts to one or many databases.
-
Connect to Placid Data from a Connection Pool in JBoss
Integrate Placid into Java servlets: Use the Management Console in JBoss to install the Placid JDBC Driver.
-
Integrating OpenCode Terminal with Foursquare 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 with Zuora Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Zuora to a JSON file on disk.
-
Connect to Sage Intacct Data in HULFT Integrate
Connect to Sage Intacct as a JDBC data source in HULFT Integrate
-
Create Datasets from Microsoft Planner in Domo Workbench and Build Visualizations of Microsoft Planner Data in Domo
Use the CData Software ODBC Driver for Microsoft Planner to create datasets from Microsoft Planner in Domo Workbench and then build visualizations in the Domo service.
-
How to connect to ScrapingBee Data with Squirrel SQL client
Connect to ScrapingBee and execute queries in the Squirrel SQL Client.
-
Integrate with Outreach.io Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Outreach.io in SnapLogic.
-
Connect to Salesforce Pardot Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Salesforce Pardot using standard SQL.
-
Prepare, Blend, and Analyze Cassandra Data in Alteryx Designer (Connect AI)
Build workflows to access live Apache Cassandra for self-service data analytics.
-
Access Live MySQL Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live MySQL from your Google Sheets.
-
Integrating Codex CLI with GetResponse 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 HBase to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect HBase with IBM WebSphere for seamless data integration and connectivity.
-
How to create Gorgias federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Gorgias in MySQL .
-
Connecting GenSpark with SAP Netweaver Gateway Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to SAP Netweaver Gateway without any replication or custom integration required.
-
Automated Continuous Amazon Marketplace Replication to SQLite
Use CData Sync for automated, continuous, customizable Amazon Marketplace replication to SQLite.
-
Use the CData Software ODBC Driver for Datadog in MicroStrategy Desktop
Connect to Datadog in MicroStrategy Desktop using the CData Software ODBC Driver for Datadog.
-
Create Apps from MongoDB Data in Qlik Sense Cloud
Use CData Connect AI to connect to MongoDB Data and build apps from live MongoDB in Qlik Sense Cloud.
-
Choosing the Best Method to Connect Teradata to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Teradata from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Provide OData Services of eBay Analytics Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for eBay Analytics by developing a WCF Service Application.
-
Build Semantic Layer Views for Simplesat Data in APOS Live Data Gateway
Use the CData Connector for Simplesat in APOS Live Data Gateway to build Semantic Layer Views for Simplesat.
-
Build Agents in Relevance AI with Access to Live Redshift Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Amazon Redshift within intelligent agent workflows.
-
Choosing the Best Method to Connect ZeroBounce to SQL Server: 5 Options Explained
Discover multiple ways to connect and use ZeroBounce from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Publish Reports with Sage 200 Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Sage 200.
-
How to load Asana data into Elasticsearch via Logstash
Introducing a simple method to load Asana data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Access Dotmailer Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Dotmailer from HeidiSQL.
-
Query ZohoPeople Data in ColdFusion
Write standard ColdFusion data access code to connect to ZohoPeople.
-
Create a Data Access Object for Mode Data using JDBI
A brief overview of creating a SQL Object API for Mode in JDBI.
-
Bridge OneNote Connectivity with Apache NiFi
Access and process Microsoft OneNote in Apache NiFi using the CData JDBC Driver.
-
Import Adobe Target Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Adobe Target. In this article, you will use the OData format to import Adobe Target into Microsoft Power Query.
-
Access Live Discourse Data in Coginiti Pro
Connect to and query live Discourse from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Edit and Search REST External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of REST to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create REST objects that you can access from apps and the dashboard.
-
How to integrate Highrise with Apache Airflow
Access and process Highrise CRM in Apache Airflow using the CData JDBC Driver.
-
Use Manus AI to Talk to Your LinkedIn Ads Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Manus AI agents to securely answer questions and take actions on LinkedIn Ads.
-
Access Live Splunk Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Splunk in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Automated Continuous eBay Replication to SQL Server
Use CData Sync for automated, continuous, customizable eBay replication to SQL Server.
-
Getting Started with the CData JDBC Driver for Dynamics 365 Business Central
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Dynamics 365 Business Central.
-
Build Jira Assets-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Jira Assets.
-
Query Trello Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Trello entities in PHP by modeling them as objects.
-
LINQ to HDFS 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 HDFS Data Provider.
-
Integrate Phoenix Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Apache Phoenix from Informatica Cloud.
-
Automated Continuous SharePoint Excel Services Replication to SQLite
Use CData Sync for automated, continuous, customizable SharePoint Excel Services replication to SQLite.
-
Access Humanity 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 Humanity.
-
How to Build an ETL App for Active Directory Data in Python with CData
Create ETL applications and real-time data pipelines for Active Directory in Python with petl.
-
Visualize FTP 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 FTP Servers into TIBCO Spotfire.
-
Analyze Superchat Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Superchat from Power Pivot. You will use the Table Import Wizard to load Superchat. You can visually build the import query or use any SQL supported by the driver.
-
How to create Aweber federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Aweber in MySQL .
-
Integrate with Dynamics CRM Data in JReport Designer
Create charts and reports based on Microsoft Dynamics CRM in JReport Designer.
-
Visualize Email Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Email.
-
Query SAP BusinessObjects BI Data as a SQL Server Database in Node.js
Execute SQL Server queries against SAP BusinessObjects BI from Node.js.
-
How to Query Exact Online Data in MySQL Workbench
Execute MySQL queries against live Exact Online from MySQL Workbench.
-
Access Sugar CRM Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Sugar CRM from HeidiSQL.
-
A PostgreSQL Interface for PivotalTracker Data (MySQL Remoting via JDBC)
Use the Remoting features of the PivotalTracker JDBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to Cloudant Data from a Connection Pool in JBoss
Integrate IBM Cloudant into Java servlets: Use the Management Console in JBoss to install the Cloudant JDBC Driver.
-
Integrate Redis Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Redis from Informatica Cloud.
-
Trigger Google Directory IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for Google Directory with standard wizards in Logic Apps.
-
DataBind Controls to Timely Data in C++Builder
DataBind to Timely in C++Builder with standard components and controls.
-
Automate Phoenix Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Apache Phoenix from PowerShell? This article demonstrates how to utilize the Phoenix Cmdlets for tasks like connecting to Apache Phoenix, automating operations, downloading data, and more.
-
How to Connect to & Open LDAP Objects in Microsoft Excel
This article uses the CData ODBC driver for LDAP to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Import and Visualize MailerSend Data in Power View
Create data visualizations based on MailerSend in Excel.
-
Build Charts with BigCommerce Data in Clear Analytics
Create dynamic charts and perform analytics based on BigCommerce in Clear Analytics.
-
Automate Acumatica Data Replication to Azure Data Lake
Use CData Sync to customize and automate Acumatica ERP replication to Azure Data Lake.
-
Connect to Sage 200 Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Sage 200 using standard SQL.
-
Add Invoiced Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Invoiced with the Informatica Enterprise Data Catalog to classify and organize data.
-
Import and Visualize Calendly Data in Power View
Create data visualizations based on Calendly in Excel.
-
Integrating Gumloop with MongoDB Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on MongoDB within automated workflows.
-
Access Adobe Target Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Adobe Target from your Oracle system.
-
Build Automated Workflows with Live Microsoft OneDrive Data in Workato
Use CData Connect AI to connect to live Microsoft OneDrive and build automated workflows in Workato.
-
Integrate Live Cosmos DB Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Azure Cosmos DB to Blue Prism using the CData ODBC Driver for Cosmos DB to create automated workflows for repetitive business tasks.
-
Connect to Quickbase Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
How to Connect PostgreSQL Data to Gemini Enterprise via CData Connect AI
Connect CData Connect AI Remote MCP to Gemini Enterprise to securely read and take actions on live PostgreSQL data in real time using natural language.
-
Using the CData Software ODBC Driver for Aweber in PyCharm
Connect to Aweber as an ODBC data source in PyCharm using the CData Software ODBC Driver for Aweber.
-
Connect to Jira Assets 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 Jira Assets.
-
Operational Reporting on LeadDesk Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote LeadDesk.
-
Access Live Telegram Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Telegram in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Viewing Autopilot Data in RAD Studio Data Explorer
How to view Autopilot in RAD Studio Data Explorer using the CData ODBC Driver for Autopilot.
-
How to Connect to Live Azure Synapse 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 Azure Synapse through natural language.
-
Replicate Notion Data to Multiple Databases
Replicate Notion to disparate databases with a point-and-click configuration.
-
How to use SQLAlchemy ORM to access Excel Online Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Microsoft Excel Online.
-
Build a Singer.io Tap for HDFS With the CData Python Connector
Learn how to easily build a Singer.io Tap for live HDFS data using
-
Analyze Stripe Data in Cognos Analytics
Use CData Connect AI to connect to Stripe Data from Cognos Analytics and analyze live Stripe.
-
Build AI/ML Models with Live Elasticsearch Data using Dataiku
Connect Elasticsearch Data with Dataiku using the CData JDBC Driver for Elasticsearch.
-
Integrating Claude Code with Google Spanner Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Google Spanner within assisted coding and automated development workflows.
-
Connect to Omnisend Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Omnisend to connect to Omnisend and execute queries in PowerBuilder.
-
Connect to Stripe Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Stripe using standard SQL.
-
Workday Reporting in OBIEE with the Workday JDBC Driver
Deploy the Workday JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Design BIRT Reports on SAP ByDesign Data
Provide current SAP Business ByDesign to your embedded analytics.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Short.io
Provide connectivity to Short.io through an SAP BusinessObjects universe.
-
How to Import Data from SAP Business Warehouse into Google Sheets
Import SAP Business Warehouse into a Google spreadsheet that is automatically refreshed.
-
Integrate REST Data in the Pentaho Report Designer
Publish reports based on REST in the Pentaho BI tool.
-
Use Grok to Talk to Your Vertica 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 Vertica for you.
-
Building Dynamic Web Pages with Oracle Eloqua Data Using AngularJS
Create single-page applications with live connectivity to Oracle Eloqua using the CData API Server.