CData Software - Knowledge Base
Recent Articles
-
Import Amazon S3 Data Using Azure Data Factory
Use CData Connect AI to connect to Amazon S3 Data from Azure Data Factory and import live Amazon S3 data.
-
Integrating Boomi Agentstudio with ADP Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to ADP data, 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 Freshteam Data
Use CData Power BI Connectors to visualize Freshteam data in Power BI.
-
Connect to Lakebase from a Connection Pool in WebLogic
Use the CData JDBC Driver for Lakebase to connect to Lakebase data from Web applications running on WebLogic.
-
Build Apps with Live HubSpot data in Adalo using CData Connect AI
Use CData Connect AI to integrate live HubSpot data into the Adalo platform and build custom mobile and web applications with real-time HubSpot data.
-
Add Keap Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Keap with the Informatica Enterprise Data Catalog to classify and organize data.
-
Automated Continuous BigCommerce Replication to IBM DB2
Use CData Sync for automated, continuous, customizable BigCommerce replication to IBM DB2.
-
Publish Reports with Postmark Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Postmark data.
-
How to work with FreeAgent Data in Apache Spark using SQL
Access and process FreeAgent Data in Apache Spark using the CData Software JDBC Driver.
-
Connect to ZarMoney Data in Ruby
Connect to ZarMoney data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Create Datasets from SAP Netweaver Gateway in Domo Workbench and Build Visualizations of SAP Netweaver Gateway Data in Domo
Use the CData Software ODBC Driver for SAP Netweaver Gateway to create datasets from SAP Netweaver Gateway data in Domo Workbench and then build visualizations in the Domo service.
-
Use the CData Software JDBC Driver for Typeform in MicroStrategy Desktop
Connect to Typeform data in MicroStrategy Desktop using the CData Software JDBC Driver for Typeform.
-
Build SAP Business One-Connected Applications in Kiro with CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Kiro to securely access, query, and take action on live SAP Business One data without replication.
-
Automated Continuous Reckon Accounts Hosted Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Reckon Accounts Hosted data replication to OneLake in Microsoft Fabric.
-
Connect to Act CRM Data in JRuby
Create a simple JRuby app with access to live Act CRM data.
-
Creating Klaviyo-Connected Applications in Unqork
You can use CData Connect AI to feed Klaviyo data to Unqork and build custom business apps.
-
Connect to Facebook Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Facebook data in the Denodo Virtual DataPort Administrator.
-
Use Dash to Build Web Apps on SAP BusinessObjects BI Data via CData Connect AI
Build interactive Dash web apps on live SAP BusinessObjects BI data using pandas and the CData Connect AI Python SDK.
-
Import Real-Time Authorize.Net Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Authorize.Net data in ColdFusion.
-
Connect to PhantomBuster Data in HULFT Integrate
Connect to PhantomBuster as a JDBC data source in HULFT Integrate
-
Load Shippo Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Shippo data to a database.
-
Access ServiceNow Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access ServiceNow data from your Oracle system.
-
Visualize Live HubSpot Data in the Power BI Service
Use CData Connect AI to connect to live HubSpot data and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Use Manus AI to Talk to Your ZohoDesk 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 ZohoDesk data.
-
How to Visualize Sybase IQ Data in Python with pandas via CData Connect AI
Use the CData Connect AI Python SDK with pandas and Matplotlib to analyze and visualize live Sybase IQ data in Python.
-
Integrating Codex with Postmark 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 an SAP BusinessObjects Universe on the CData JDBC Driver for OneNote
Provide connectivity to OneNote data through an SAP BusinessObjects universe.
-
Access Mode Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Mode data from HeidiSQL.
-
Prepare, Blend, and Analyze SQL Server Data in Alteryx Designer (ODBC)
Build workflows to access live SQL Server data for self-service data analytics.
-
How to publish and share Avaza Data dashboards with Tableau Server
The CData ODBC driver for Avaza enables you integrate Avaza data into Tableau dashboards.
-
Query Office 365 Data in ColdFusion
Write standard ColdFusion data access code to connect to Office 365 data.
-
Create Workday-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Workday Data from Klipfolio and build custom visualizations using live Workday data.
-
How to Connect to Live Greenhouse Data from Google ADK Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Google ADK agents to securely read and take actions on your Greenhouse data for you.
-
Establish a Live Connection with MailerLite Data using Tableau Bridge
The CData ODBC Driver for MailerLite enables you to integrate live MailerLite data into Tableau Cloud dashboards using the Tableau Bridge.
-
How to Connect the Power BI Service to Twitter Ads: Complete Guide
Connect to the CData Software Power BI Connector for Twitter Ads from PowerBI.com to provide real-time Twitter Ads data across the organization.
-
Build Toggl-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Toggl data.
-
Extract, Transform, and Load Jira Data in Informatica PowerCenter
Create a simple Workflow for Jira data in Informatica PowerCenter.
-
Access Productboard Data from MySQL in PHP
Connect to Productboard through the standard MySQL libraries in PHP.
-
Connect to Zoho Creator Data in JRuby
Create a simple JRuby app with access to live Zoho Creator data.
-
Working with Zendesk Data in LINQPad
Execute LINQ queries to Zendesk data in LINQPad.
-
Migrating data from Teamwork to Google BigQuery using CData SSIS Components.
Easily push Teamwork data to Google BigQuery using the CData SSIS Tasks for Teamwork and Google BigQuery.
-
Configure the CData JDBC Driver for Gorgias in a Connection Pool in Tomcat
Connect to Gorgias data from a connection pool in Tomcat.
-
How to Build an ETL App for Auth0 Data in Python with CData
Create ETL applications and real-time data pipelines for Auth0 data in Python with petl.
-
Getting Started with the CData Excel Add-In for Jira Assets
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Jira Assets.
-
Integrate Google Sheets Data into Power Automate Desktop using CData Connect
CData Connect for Google Sheets Data enables you to integrate Google Sheets data into workflows built using Microsoft Power Automate Desktop.
-
Access Live Teamgate Data in AWS Lambda
Connect to live Teamgate data in AWS Lambda using the CData JDBC Driver.
-
Object-Relational Mapping (ORM) with Oracle 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 Oracle data into a Java-based ORM framework, Hibernate.
-
Deploy the ADO.NET Provider for Amplitude on an SSRS Report Server
Connect to Amplitude data 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.
-
Import Apify Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Apify Data and provide access to live Apify data for custom reports in the Power BI Service.
-
Analyze Webex Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Webex data in Microsoft R Open.
-
DataBind Active Directory Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for Active Directory with the DevExpress Windows Forms and Web controls to provide Active Directory data to a chart.
-
How to use SQLAlchemy ORM to access Perigon Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Perigon data.
-
Access Live Google Drive Data in TIBCO Data Virtualization
Use the Google Drive Tibco DV Adapter to create a Google Drive data data source in TIBCO Data Virtualization Studio and gain access to live Google Drive data from your TDV Server.
-
How to use SQLAlchemy ORM to access Salesforce Marketing Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Salesforce Marketing data.
-
Build Pipelines with Live PolarTeamPro Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to PolarTeamPro from Google Cloud Data Fusion, enabling the integration of live PolarTeamPro data into the building and management of effective data pipelines.
-
How to Easily Query Webflow Data in OpenOffice Base
Connect to Webflow data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Use Agno to Talk to Your Microsoft OneDrive 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 Microsoft OneDrive data for you.
-
Publish Stripe-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Stripe data.
-
Build a Simple VCL Application for Excel Data
How to build a simple VCL Application to view Excel data in RAD Studio using the CData ODBC Driver for Excel.
-
Visualize Oracle Service Cloud Data in TIBCO Spotfire through ADO.NET
Integrate Oracle Service Cloud data into dashboards in TIBCO Spotfire.
-
Provide OData Services of CockroachDB Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for CockroachDB data by developing a WCF Service Application.
-
Automate Tally Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Tally data from PowerShell? This article demonstrates how to utilize the Tally Cmdlets for tasks like connecting to Tally data, automating operations, downloading data, and more.
-
LINQ to Salesforce 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 Salesforce Data Provider.
-
DataBind ShipEngine Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide ShipEngine data to a chart.
-
Automate QuickBooks Time Data Replication to Couchbase
Use CData Sync to Customize and automate QuickBooks Time data replication to Couchbase.
-
Access Live SingleStore Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate SingleStore data into the statistical analysis tools available in SAS JMP. This article shows how to use SingleStore data in the Graph Builder and Query Builder.
-
Integrate Cursor with Live Oracle Sales Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Oracle Sales data from within the editor.
-
Query LightSpeedRetail Data through ODBC in Node.js
Use node-odbc to execute SQL queries against LightSpeedRetail data from Node.js.
-
Create Dynamic Instantly Grids Using the Infragistics XamDataGrid
Learn how you can connect Instantly to Infragistics XamDataGrid to build dynamic grids.
-
Build a Singer.io Tap for Google Contacts With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Google Contacts data using the CData Python Connector.
-
Integrate Google's Vertex AI Agent with Live SAP ByDesign Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live SAP ByDesign data within intelligent workflows.
-
Work with Live Oracle Financials Cloud Data in Power Query
Use CData Connect AI to connect to Oracle Financials Cloud data and work with live Oracle Financials Cloud data in Microsoft Power Query.
-
Integrate Google Analytics with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Google Analytics with External Services.
-
Integrate Live Google Forms Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Google Forms data to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Integrating GitHub Copilot with Hubstaff 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.
-
Access Live Tally Data in TIBCO Data Virtualization
Use the Tally Tibco DV Adapter to create a Tally data data source in TIBCO Data Virtualization Studio and gain access to live Tally data from your TDV Server.
-
Connect to Cosmos DB Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Cosmos DB data.
-
Connect to Amazon Marketplace Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Amazon Marketplace data.
-
Create Power BI Reports on Real-Time NASA Data
Use the CData ODBC Driver for NASA to visualize NASA data in Power BI Desktop.
-
Integrating Claude Code CLI with Azure Table 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.
-
Automated Continuous Freshservice Replication to Databricks
Use CData Sync for automated, continuous, customizable Freshservice replication to Databricks.
-
Automated Continuous Salesforce Pardot Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Salesforce Pardot replication to Google BigQuery.
-
Build Data Flows from SendInBlue to SQL Server using SSIS
Easily back up SendInBlue data to SQL Server using the SSIS components for SendInBlue.
-
Automated Continuous ElevenLabs Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable ElevenLabs replication to Google BigQuery.
-
Build Zoho Books Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Zoho Books data and build visualizations in Tableau.
-
Use Dash to Build to Web Apps on ServiceDesk Plus Data
Create Python applications that use pandas and Dash to build ServiceDesk Plus-connected web apps.
-
Connect to Hugging Face Data in Jaspersoft Studio
Execute SQL to remote Hugging Face data in Jaspersoft Studio.
-
Process & Analyze SparkPost Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live SparkPost Data.
-
Automated Continuous SharePoint Replication to Snowflake
Use CData Sync for automated, continuous, customizable SharePoint replication to Snowflake.
-
Connect to SAP Ariba Procurement Data from PowerBuilder via JDBC
This article demonstrates how to access SAP Ariba Procurement data from PowerBuilder using the SAP Ariba Procurement JDBC Driver.
-
How to Connect to & Open WooCommerce Data in Microsoft Excel
This article uses the CData ODBC driver for WooCommerce to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Stream OnePageCrm Data into Apache Kafka Topics
Access and stream OnePageCrm data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Create Power BI Reports on Real-Time Copper Data
Use the CData ODBC Driver for Copper to visualize Copper data in Power BI Desktop.
-
Connect to Office 365 Data in DBArtisan
Use wizards in DBArtisan to configure Office 365 data as a data source.
-
Connecting GenSpark with Pinterest Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Pinterest data without any replication or custom integration required.
-
Use the CData Software JDBC Driver for Suadeo in MicroStrategy
Connect to Suadeo data in MicroStrategy Developer using the CData Software JDBC Driver for Suadeo.
-
Avalara AvaTax Reporting in OBIEE with the Avalara AvaTax JDBC Driver
Deploy the Avalara AvaTax JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Integrating Kiro with Epicor Kinetic 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.
-
Use ChatGPT to Talk to Your Certinia 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 Certinia data for you.
-
Integrate Cline with Live Act CRM Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Act CRM data from within your IDE.