CData Software - Knowledge Base
Recent Articles
-
Replicate IBM Cloud Object Storage Data from PowerShell
Write a quick PowerShell script to query IBM Cloud Object Storage data. Use connectivity to the live data to replicate IBM Cloud Object Storage data to SQL Server.
-
Automated Continuous Google Campaign Manager 360 Replication to Databricks
Use CData Sync for automated, continuous, customizable Google Campaign Manager 360 replication to Databricks.
-
Query Landbot Data as a MySQL Database in Node.js
Execute MySQL queries against Landbot data from Node.js.
-
Connect CapsuleCRM to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live CapsuleCRM data using the CData Python MCP Server.
-
Replicate IBM Cloud Object Storage Data to Multiple Databases via the CData Sync CLI
Replicate IBM Cloud Object Storage data to disparate databases with a single configuration.
-
Automated Continuous Placid Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Placid data replication to OneLake in Microsoft Fabric.
-
How to connect SharePoint with Salesforce Data through external lists
Provide Salesforce data to SharePoint users as an external list.
-
Automated Continuous Google Sheets Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Google Sheets replication to IBM DB2.
-
Connect to Azure DevOps Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Azure DevOps to connect to Azure DevOps data and execute queries in PowerBuilder.
-
How to connect PolyBase to Asana
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Asana data.
-
Connect to Marketo in SpagoBI
Create reports featuring live Marketo data in SpagoBI Studio. Host Marketo reports on SpagoBI Server.
-
Working with Freshteam Data in LINQPad
Execute LINQ queries to Freshteam data in LINQPad.
-
Visualize CSV Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to CSV data.
-
Query, Visualize, and Share live Okta Data in Redash
Use CData Connect AI to connect to live Okta data in Redash for querying, visualizing, and sharing.
-
Access Tickspot Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Tickspot data from your Oracle system.
-
Connect to SAP in SpagoBI
Create reports featuring live SAP data in SpagoBI Studio. Host SAP reports on SpagoBI Server.
-
Using the CData Software ODBC Driver for Clari in PyCharm
Connect to Clari as an ODBC data source in PyCharm using the CData Software ODBC Driver for Clari.
-
Build Dashboards with Opsgenie Data in DBxtra
Create dynamic dashboards and perform analytics based on Opsgenie data in DBxtra.
-
How to create an RPA flow for Facebook Ads Data in UiPath Studio
Use the Facebook Ads ODBC Driver to create workflows that access real-time Facebook Ads data without any coding.
-
Integrate Dify with Live Microsoft Teams Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Dify agents and workflows to securely access and query live Microsoft Teams data.
-
Connect to Xero in SpagoBI
Create reports featuring live Xero data in SpagoBI Studio. Host Xero reports on SpagoBI Server.
-
How to use SQLAlchemy ORM to access SendGrid Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of SendGrid data.
-
Create Informatica Mappings From/To an ODBC Data Source for Twilio
Create an ODBC connection to Twilio in Informatica and browse and transfer Twilio data.
-
Extract, Transform, and Load Shopify Data in Informatica PowerCenter
Create a simple Workflow for Shopify data in Informatica PowerCenter.
-
Getting Started with the CData Tableau Connector for Google Forms
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Back Up ClickTime data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData API Driver for ADO.NET. In this article, we will employ an SSIS workflow to populate a database with ClickTime data data.
-
Access Live Telegram Data in Coginiti Pro
Connect to and query live Telegram data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Automated MailChimp Data Replication to Teradata
Use CData Sync to Customize and automate MailChimp data replication to Teradata.
-
Automated Freshsales Data Replication to Teradata
Use CData Sync to Customize and automate Freshsales data replication to Teradata.
-
Replicate Multiple SAP SuccessFactors Accounts via the CData Sync CLI
Replicate multiple SAP SuccessFactors accounts to one or many databases.
-
Getting Started with the CData ADO.NET Provider for Contentful
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Create Informatica Mappings From/To a JDBC Data Source for Sentry
Create Sentry data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Integrate LibreChat with Live Salesforce Marketing Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Salesforce Marketing data from within the chat interface.
-
Connect to ScrapingBee Data in Jaspersoft Studio
Execute SQL to remote ScrapingBee data in Jaspersoft Studio.
-
Visualize Google Search Results in Sisense
Create an ElastiCube in Sisense app with access to Google Search results.
-
Access QuickBooks Data from MySQL in PHP
Connect to QuickBooks through the standard MySQL libraries in PHP.
-
Access Live FreeAgent Data in AWS Lambda (with IntelliJ IDEA)
Connect to live FreeAgent data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
How to Connect to Live Cloudant Data in n8n Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable n8n to securely read and take actions on your Cloudant data for you.
-
Connect to Splunk Data in CloverDX (formerly CloverETL)
Transfer Splunk data using the visual workflow in the CloverDX data integration tool.
-
Use the CData Software ODBC Driver for Workable in MicroStrategy Desktop
Connect to Workable data in MicroStrategy Desktop using the CData Software ODBC Driver for Workable.
-
Automate WordPress Data Replication to Azure Synapse
Use CData Sync to customize and automate WordPress data replication to Azure Synapse.
-
How to Connect Flowise AI Agents to Live SingleStore Data via CData Connect AI
Integrate Flowise AI with the CData Connect AI MCP Server to enable agents to securely query and act on live SingleStore data without replication.
-
Configure the CData JDBC Driver for ConvertKit in a Connection Pool in Tomcat
Connect to ConvertKit data from a connection pool in Tomcat.
-
Access Live Vercel Data in AWS Lambda
Connect to live Vercel data in AWS Lambda using the CData JDBC Driver.
-
Integrating Kiro with Klaviyo 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 SAP SuccessFactors Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable SAP SuccessFactors replication to Apache Cassandra.
-
Create Reports from Dropbox Data in Looker Studio
Use CData Connect AI to gain access to live Dropbox data and create custom reports in Looker Studio.
-
Create Power BI Reports on Real-Time SpaceX Data
Use the CData ODBC Driver for SpaceX to visualize SpaceX data in Power BI Desktop.
-
Use Grok to Talk to Your SendGrid 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 SendGrid data for you.
-
Microsoft Ads Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Microsoft Ads data through CData Connect AI using different applications and tools.
-
Connect to RSS Feeds in the Denodo Platform
Use CData driver technologies to create a virtual data source for RSS feeds in the Denodo Virtual DataPort Administrator.
-
Integrate PayPal Data into Power Automate Desktop using CData Connect
CData Connect for PayPal Data enables you to integrate PayPal data into workflows built using Microsoft Power Automate Desktop.
-
Analyze Google Cloud Storage Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Google Cloud Storage from Power Pivot. You will use the Table Import Wizard to load Google Cloud Storage data. You can visually build the import query or use any SQL supported by the driver.
-
Build Semantic Layer Views for ADP Data in APOS Live Data Gateway
Use the CData Connector for ADP in APOS Live Data Gateway to build Semantic Layer Views for ADP data.
-
Use the CData Software ODBC Driver for SAP SuccessFactors in MicroStrategy Desktop
Connect to SAP SuccessFactors data in MicroStrategy Desktop using the CData Software ODBC Driver for SAP SuccessFactors.
-
Replicate Multiple Cloudflare Accounts via the CData Sync CLI
Replicate multiple Cloudflare accounts to one or many databases.
-
Getting Started with the CData JDBC Driver for ZohoDesk
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for ZohoDesk.
-
DataBind Controls to Lakebase Data in Delphi
DataBind to Lakebase data in Delphi with standard data access components and controls.
-
How to connect PolyBase to BambooHR
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live BambooHR data.
-
Design BIRT Reports on Odoo Data
Provide current Odoo data to your embedded analytics.
-
Connect to Eventbrite from a Connection Pool in WebLogic
Use the CData JDBC Driver for Eventbrite to connect to Eventbrite data from Web applications running on WebLogic.
-
How to use SQLAlchemy ORM to access Google Calendar Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Google Calendar data.
-
Connect to Placid Data in Jaspersoft Studio
Execute SQL to remote Placid data in Jaspersoft Studio.
-
Integrate with Microsoft Exchange Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Microsoft Exchange data in SnapLogic.
-
Build an OLAP Cube in SSAS from Shopify Data
Establish a connection to Shopify data data from SQL Server Analysis Services, and use the Shopify Data Provider to build OLAP cubes for use in analytics and reporting.
-
Create Apollo Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Apollo from PowerBI.com to create Power BI Dataflows with real-time data.
-
Integrating Claude Code CLI with WordPress 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 Connect DBeaver to Yelp via a JDBC Driver
Manage Yelp data with visual tools in DBeaver like the query browser.
-
Visualize Live Coinbase Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Coinbase data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Publish Amazon Marketplace-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Amazon Marketplace data.
-
How to Connect to Live OneNote Data in n8n Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable n8n to securely read and take actions on your OneNote data for you.
-
Integrate Cursor with Live SAP Business One Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live SAP Business One data from within the editor.
-
Connect to MariaDB Data in DBeaver
Use the CData ODBC Driver to connect to MariaDB data in DBeaver.
-
Create a Data Access Object for EnterpriseDB Data using JDBI
A brief overview of creating a SQL Object API for EnterpriseDB data in JDBI.
-
Prepare, Blend, and Analyze Azure Data Catalog Data in Alteryx Designer (Connect AI)
Build workflows to access live Azure Data Catalog data for self-service data analytics.
-
Prepare, Blend, and Analyze Odoo Data in Alteryx Designer (Connect AI)
Build workflows to access live Odoo data for self-service data analytics.
-
Getting Started with the CData ODBC Driver for ConstantContact
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for ConstantContact.
-
Use Databricks Agent Bricks to Talk to Your HubSpot Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your HubSpot data for you.
-
Consume EnterpriseDB OData Feeds in PowerBuilder
This article demonstrates how to consume EnterpriseDB data as OData feeds from PowerBuilder using the API Server.
-
DataBind Charts to SAP Hybris C4C Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to SAP Hybris C4C data from controls in the Visual Studio toolbox. This article demonstrates a graphical approach using wizards in Visual Studio, as well as how to databind with only a few lines of code.
-
How to Connect to Live Bitly 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 Bitly data for you.
-
Build Dashboards with eBay Analytics Data in Dundas BI
Create dynamic dashboards and perform analytics based on eBay Analytics data in Dundas BI.
-
Getting Started with the CData Power BI Connector for Microsoft Planner
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Microsoft Planner.
-
Write a Simple Go Application to work with JotForm Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to JotForm data.
-
How to publish and share ZohoPeople Data dashboards with Tableau Server
The CData ODBC driver for ZohoPeople enables you integrate ZohoPeople data into Tableau dashboards.
-
Access FormSite Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live FormSite data from HeidiSQL.
-
A PostgreSQL Interface for Salesforce Data 360 Data using the CData ODBC Driver
Use the SQL Gateway and Salesforce Data 360 ODBC Driver to create a PostgreSQL entry-point for data access.
-
Migrating data from SuiteCRM to Databricks using CData SSIS Components.
Easily push SuiteCRM data to Databricks using the CData SSIS Tasks for SuiteCRM and Databricks.
-
How to Easily Query Sage Cloud Accounting Data in OpenOffice Base
Connect to Sage Cloud Accounting data in OpenOffice Base using the CData ODBC Driver for Sage Cloud Accounting and generate reports with live data insights.
-
Connect to LDAP Objects Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for LDAP and the Script function in FileMaker Pro to connect to LDAP and work with LDAP objects in your FileMaker application.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Aha!
Provide connectivity to Aha! data through an SAP BusinessObjects universe.
-
Extract, Transform, and Load Freshsales Data in Informatica PowerCenter
Create a simple Workflow for Freshsales data in Informatica PowerCenter.
-
How to Visualize Gumroad Data in Python with pandas
Use pandas and other modules to analyze and visualize live Gumroad data in Python.
-
Automated Continuous Strava Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Strava replication to Amazon S3.
-
Visualize Salesforce Data in TIBCO Spotfire through ADO.NET
Integrate Salesforce data into dashboards in TIBCO Spotfire.
-
Access Live SAP Business Warehouse 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 SAP Business Warehouse data through MCP integration.
-
Connect to Microsoft Teams Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Microsoft Teams Data and connect to Microsoft Teams data in Akorbi Digital RunMyProcess.
-
Connect to Real-Time Monday.com Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Monday.com and Dataflow to import and use Monday.com data in Power Apps.
-
How to Visualize LinkedIn Data in Python with pandas
Use pandas and other modules to analyze and visualize live LinkedIn data in Python.
-
How to Connect the Power BI Service to Splunk: Complete Guide
Connect to the CData Software Power BI Connector for Splunk from PowerBI.com to provide real-time Splunk data across the organization.