CData Software - Knowledge Base
Recent Articles
-
Establish a Live Connection with Telegram Data using Tableau Bridge
The CData ODBC Driver for Telegram enables you to integrate live Telegram into Tableau Cloud dashboards using the Tableau Bridge.
-
Create a Data Access Object for Accelo Data using JDBI
A brief overview of creating a SQL Object API for Accelo in JDBI.
-
Connect to eBay Analytics Data in RapidMiner
Integrate eBay Analytics with standard components and data source configuration wizards in RapidMiner Studio.
-
Build Monday.com-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Monday.com.
-
Build Anaplan-Powered Applications in Claude Code with CData MCP Server
Use the CData MCP Server for Anaplan to explore live Anaplan Data in Claude Code to assist with building Anaplan-powered applications.
-
Replicate Greenplum Data to Multiple Databases via the CData Sync CLI
Replicate Pivotal GreenPlum to disparate databases with a single configuration.
-
How to Connect the Power BI Service to OneNote: Complete Guide
Connect to the CData Software Power BI Connector for OneNote from PowerBI.com to provide real-time Microsoft OneNote across the organization.
-
How to Connect to SendInBlue Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to SendInBlue. Leverage the pyodbc module for ODBC in Python.
-
Access Live IBM Informix Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live IBM Informix data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Working with MYOB AccountRight Data in LINQPad
Execute LINQ queries to MYOB AccountRight in LINQPad.
-
Operational Reporting on Templated Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Templated.
-
Build a PostgreSQL Interface for Zoho Recruit Data using the CData JDBC Driver
Use the Remoting features of the Zoho Recruit JDBC Driver to create a PostgreSQL entry-point for data access.
-
Migrating data from HBase to Google BigQuery using CData SSIS Components.
Easily push Apache HBase to Google BigQuery using the CData SSIS Tasks for HBase and Google BigQuery.
-
How to work with Quaderno Data in Apache Spark using SQL
Access and process Quaderno Data in Apache Spark using the CData Software JDBC Driver.
-
Visualize Live ServiceNow Data in the Power BI Service
Use CData Connect AI to connect to live ServiceNow and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Publish Crystal Reports on Opsgenie Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Opsgenie.
-
How to Build an ETL App for Oracle Data in Python with CData
Create ETL applications and real-time data pipelines for Oracle Database in Python with petl.
-
Build Semantic Layer Views for NetSuite SuiteAnalytics Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for NetSuite SuiteAnalytics.
-
Import Real-Time Shopify Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Shopify in ColdFusion.
-
Object-Relational Mapping (ORM) with Adobe Commerce 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 Adobe Commerce into a Java-based ORM framework, Hibernate.
-
Automated Continuous Grafana Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Grafana replication to Amazon Redshift.
-
Getting Started with the CData Excel Add-In for EmailOctopus
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for EmailOctopus.
-
Query Salesforce Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Salesforce entities in PHP by modeling them as objects.
-
How to integrate PingOne with Apache Airflow
Access and process PingOne in Apache Airflow using the CData JDBC Driver.
-
Create Reports with Figshare Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Figshare.
-
Automate ActiveCampaign Integration Tasks from PowerShell
Are you in search of a quick and easy way to access ActiveCampaign from PowerShell? This article demonstrates how to utilize the ActiveCampaign Cmdlets for tasks like connecting to ActiveCampaign, automating operations, downloading data, and more.
-
Connect Helpscout to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Helpscout using the CData Python MCP Server.
-
Validate Factorial Data with QuerySurge
Access and validate Factorial in QuerySurge using the CData JDBC Driver.
-
How to Connect to Dynamics 365 Business Central Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Dynamics 365 Business Central. Leverage the pyodbc module for ODBC in Python.
-
Using the CData Software ODBC Driver for Phoenix in PyCharm
Connect to Phoenix as an ODBC data source in PyCharm using the CData Software ODBC Driver for Phoenix.
-
Extract, Transform, and Load Salesforce Data 360 Data in Informatica PowerCenter
Create a simple Workflow for Salesforce Data 360 in Informatica PowerCenter.
-
How to connect to SAP Business Warehouse Data from IntelliJ
Integrate connectivity to SAP Business Warehouse with wizards in IntelliJ.
-
How to connect PolyBase to Brex
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Brex.
-
Create Reports from Amazon Marketplace Data in Looker Studio
Use CData Connect AI to gain access to live Amazon Marketplace and create custom reports in Looker Studio.
-
Automated Continuous SAP Ariba Procurement Replication to MySQL
Use CData Sync for automated, continuous, customizable SAP Ariba Procurement replication to MySQL.
-
Use the CData Software ODBC Driver for Sentry in MicroStrategy
Connect to Sentry in MicroStrategy Developer using the CData Software ODBC Driver for Sentry.
-
Use Manus AI to Talk to Your Freshdesk 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 Freshdesk.
-
How to Connect to Live Avro Data from crewAI Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable crewAI agents to securely read and take actions on your Apache Avro for you.
-
Build Semantic Layer Views for LeadDesk Data in APOS Live Data Gateway
Use the CData Connector for LeadDesk in APOS Live Data Gateway to build Semantic Layer Views for LeadDesk.
-
View Reports on Real-Time Workable Data in Power BI Report Server
Use the CData ODBC Driver for Workable to visualize Workable in Power BI Desktop and then publish them to Power BI Report Server.
-
How to Access Live Basecamp Data in Visual Studio Code via Cline
Run CData MCP Server for Basecamp on Windows Subsytem for Linux (WSL) and connect to live Basecamp from the Cline extension in Visual Studio Code.
-
Analyze Reply.io Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Reply.io from Power Pivot. You will use the Table Import Wizard to load Reply.io. You can visually build the import query or use any SQL supported by the driver.
-
Create Apps from Gong Data in Qlik Sense Cloud
Use CData Connect AI to connect to Gong Data and build apps from live Gong in Qlik Sense Cloud.
-
Access Live Email 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 Email through MCP integration.
-
Build AI Agents with Workday Data in IBM watsonx Orchestrate using CData Connect AI
Learn how to build intelligent agents in IBM watsonx Orchestrate that can securely access and act on live Workday through CData Connect AI.
-
Build AlloyDB-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Google AlloyDB.
-
How to Visualize Odoo Data in Python with pandas
Use pandas and other modules to analyze and visualize live Odoo ERP in Python.
-
Automated Continuous SendGrid Replication to MongoDB
Use CData Sync for automated, continuous, customizable SendGrid replication to MongoDB.
-
Integrate Live Microsoft Exchange Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf
-
Query Cloudant Data in ColdFusion
Write standard ColdFusion data access code to connect to IBM Cloudant.
-
LINQ to Jira Assets 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 Jira Assets Data Provider.
-
Automated Continuous CapsuleCRM Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable CapsuleCRM replication to Google BigQuery.
-
Integrating GitHub Copilot CLI with OData 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.
-
Establish a Live Connection with Notion Data using Tableau Bridge
The CData ODBC Driver for Notion enables you to integrate live Notion into Tableau Cloud dashboards using the Tableau Bridge.
-
Access Live SAP Netweaver Gateway Data in Coginiti Pro
Connect to and query live SAP Netweaver Gateway from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Connect to Optimizely in SpagoBI
Create reports featuring live Optimizely in SpagoBI Studio. Host Optimizely reports on SpagoBI Server.
-
Provide OData Services of Cloudflare Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Cloudflare by developing a WCF Service Application.
-
Connect to Sage Cloud Accounting Data from a Connection Pool in Jetty
The Sage Cloud Accounting JDBC Driver supports connection pooling: This article shows how to connect faster to Sage Business Cloud Accounting from Web apps in Jetty.
-
Automate Instagram Data Replication to Couchbase
Use CData Sync to Customize and automate Instagram replication to Couchbase.
-
How to create VWO federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for VWO in MySQL .
-
How to Connect the Power BI Service to SAP Fieldglass: Complete Guide
Connect to the CData Software Power BI Connector for SAP Fieldglass from PowerBI.com to provide real-time SAP Fieldglass across the organization.
-
Create Power BI Reports on Real-Time Contentful Data
Use the CData ODBC Driver for Contentful to visualize Contentful in Power BI Desktop.
-
Automated Continuous SAP Business One Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable SAP Business One replication to Google BigQuery.
-
DataBind Controls to Eventbrite Data in Delphi
DataBind to Eventbrite in Delphi with standard data access components and controls.
-
DataBind Controls to Webflow Data in C++Builder
DataBind to Webflow in C++Builder with standard components and controls.
-
How to Query Live Jira Data in Perplexity MacOS Desktop
Connect to and query live Jira Data in Perplexity Desktop using CData MCP Server.
-
Configure the CData JDBC Driver for Perigon in a Connection Pool in Tomcat
Connect to Perigon from a connection pool in Tomcat.
-
Automate Google Search Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Google Search from PowerShell? This article demonstrates how to utilize the Google Search Cmdlets for tasks like connecting to Google Search, automating operations, downloading data, and more.
-
Automate Slack Data Replication to Azure Data Lake
Use CData Sync to customize and automate Slack replication to Azure Data Lake.
-
Migrating data from Neo4J to Databricks using CData SSIS Components.
Easily push Neo4J to Databricks using the CData SSIS Tasks for Neo4J and Databricks.
-
Analyze Office 365 Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Microsoft Office 365 in Microsoft R Open.
-
Create Dynamic Avalara AvaTax Grids Using the Infragistics XamDataGrid
Learn how you can connect Avalara AvaTax to Infragistics XamDataGrid to build dynamic grids.
-
Manage Gmail Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Gmail.
-
Connect to PivotalTracker Data Using the Script Function in Claris FileMaker Pro
Use the CData API Driver for ODBC and the Script function in FileMaker Pro to connect to PivotalTracker and work with PivotalTracker in your FileMaker application.
-
Publish Nuclia-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Nuclia.
-
How to Easily Query Wave Financial Data in OpenOffice Base
Connect to Wave Financial data in OpenOffice Base using the CData ODBC Driver for Wave Financial and generate reports with live data insights.
-
Build an OLAP Cube in SSAS from Flowlu Data
Establish a connection to Flowlu data from SQL Server Analysis Services, and use the Flowlu Data Provider to build OLAP cubes for use in analytics and reporting.
-
How to connect and process Apache Phoenix from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Apache Phoenix.
-
Integrating Claude Code CLI with Freshsales 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 import Highrise Data into Apache Solr
Use the CData Software JDBC Driver for Highrise in Data Import Handler and create an automated import of Highrise CRM to Apache Solr Enterprise Search platform.
-
Automated Continuous CouchDB Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable CouchDB replication to Apache Cassandra.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for EmailOctopus
Provide connectivity to EmailOctopus through an SAP BusinessObjects universe.
-
Integrating OpenCode Terminal with VWO 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.
-
Explore Geographical Relationships in Microsoft Ads Data with Power Map
Create data visualizations with Microsoft Ads in Power Map.
-
Back Up SAP ERP/NetWeaver to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for SAP. In this article, we will employ an SSIS workflow to populate a database with SAP ERP/NetWeaver data.
-
Access Live Smartsheet Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Smartsheet from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
How to connect and process MailChimp from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live MailChimp.
-
Build Data Flows from DB2 to SQL Server using SSIS
Easily back up IBM DB2 to SQL Server using the SSIS components for DB2.
-
Automated Continuous Pinterest Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Pinterest replication to IBM DB2.
-
Connect to Microsoft OneDrive Data in Ruby
Connect to Microsoft OneDrive in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Explore Geographical Relationships in XML Data with Power Map
Create data visualizations with XML Files in Power Map.
-
Excel Spreadsheet Automation on Google Contacts Data with the QUERY Formula
Pull data from Google Contacts, automate spreadsheets, and more with the QUERY formula.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for ZohoMarketingHub
Provide connectivity to ZohoMarketingHub through an SAP BusinessObjects universe.
-
Automated Continuous Oracle Eloqua Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Oracle Eloqua replication to IBM DB2.
-
Connect to Shopify Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Shopify as an External Source in Dremio.
-
Connect to Facebook Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Facebook in Airbyte.
-
Rapidly Develop ChartMogul-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 ChartMogul.
-
Integrating Codex CLI with MongoDB 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 GraphQL Data from a Connection Pool in Jetty
The GraphQL JDBC Driver supports connection pooling: This article shows how to connect faster to GraphQL from Web apps in Jetty.
-
Migrating data from Nuclia to Snowflake using CData SSIS Components.
Easily push Nuclia to Snowflake using the CData SSIS Tasks for Nuclia and Snowflake.