CData Software - Knowledge Base
Recent Articles
-
How to use SQLAlchemy ORM to access Yelp Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Yelp data.
-
Connect to Google Search Results in Google Apps Script via Connect AI
Use CData Connect AI to access Google Search results in Google Apps Script.
-
Query Redshift Data as a MySQL Database in Node.js
Execute MySQL queries against Redshift data from Node.js.
-
Getting Started with the CData Power BI Connector for Wrike
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
How to Query ZohoDesk Data in MySQL Workbench
Execute MySQL queries against live ZohoDesk data from MySQL Workbench.
-
Visualize Live ZohoExpense Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live ZohoExpense data.
-
ETL SendInBlue in Oracle Data Integrator
This article shows how to transfer SendInBlue data into a data warehouse using Oracle Data Integrator.
-
Getting Started with the CData Excel Add-In for Anaplan
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Anaplan.
-
Use Grok to Talk to Your MySQL 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 MySQL data for you.
-
Analyze Sage Intacct Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Sage Intacct data in Microsoft R Open.
-
Use Manus AI to Talk to Your Adobe Experience Manager 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 Adobe Experience Manager data.
-
Access Live Microsoft Exchange Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Microsoft Exchange data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
How to integrate NetSuite with Apache Airflow
Access and process NetSuite data in Apache Airflow using the CData JDBC Driver.
-
How to Seamlessly Import ServiceDesk Plus Data into IBM SPSS Modeler
Integrate ServiceDesk Plus data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Automated Continuous Zoho Creator Replication to Databricks
Use CData Sync for automated, continuous, customizable Zoho Creator replication to Databricks.
-
Connect to Nuclia Data from a Connection Pool in JBoss
Integrate Nuclia data into Java servlets: Use the Management Console in JBoss to install the Nuclia JDBC Driver.
-
ETL Grafana in Oracle Data Integrator
This article shows how to transfer Grafana data into a data warehouse using Oracle Data Integrator.
-
How to connect SharePoint with Act-On Data through external lists
Provide Act-On data to SharePoint users as an external list.
-
Work with Avaza Data in FoxPro
Load Avaza data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Analyze ZohoInvoice Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of ZohoInvoice data and visualize live ZohoInvoice data in Infragistics Reveal.
-
Build Data Flows from Google Calendar to SQL Server using SSIS
Easily back up Google Calendar data to SQL Server using the SSIS components for Google Calendar.
-
Visualize Live Microsoft Ads Data in the Power BI Service
Use CData Connect AI to connect to live Microsoft Ads data and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Build AI Agents with AfterShip 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 AfterShip data through CData Connect AI.
-
Natively Connect to SAP Netweaver Gateway Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to SAP Netweaver Gateway data. Leverage the native support for ODBC in PHP.
-
Use the CData Software JDBC Driver for Exact Online in MicroStrategy
Connect to Exact Online data in MicroStrategy Developer using the CData Software JDBC Driver for Exact Online.
-
Build Automated Workflows with Live HDFS Data in Workato
Use CData Connect AI to connect to live HDFS data and build automated workflows in Workato.
-
Replicate Google Analytics Data from PowerShell
Write a quick PowerShell script to query Google Analytics data. Use connectivity to the live data to replicate Google Analytics data to SQL Server.
-
Integrating OpenCode with Zoho Projects 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.
-
Getting Started with the CData Python Connector for Asana
Learn to install and license the CData Python Connector and configure a connection to live Asana data.
-
Build a Singer.io Tap for eBay Analytics With the CData Python Connector
Learn how to easily build a Singer.io Tap for live eBay Analytics data using the CData Python Connector.
-
How to Connect to Live CouchDB Data from Gemini CLI (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Gemini CLI to securely read and take actions on your CouchDB data for you.
-
Use JayDeBeApi to access Shopify Data in Python
Use standard Python scripting and the development environment of your choice to access live Shopify data.
-
Connect to Reckon Data in Claris FileMaker Pro
Use the CData ODBC Driver for Reckon in FileMaker Pro to connect to Reckon and work with Reckon data in your FileMaker applications.
-
Rapidly Develop Unbounce-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 Unbounce.
-
Access Live Databricks Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Databricks data from your Excel spreadsheets.
-
Automated Continuous Paylocity Replication to Snowflake
Use CData Sync for automated, continuous, customizable Paylocity replication to Snowflake.
-
Visualize Live Contentful Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Contentful data.
-
Visualize Dotmailer Data in Tableau
The CData ODBC driver for Dotmailer enables you integrate Dotmailer data into Tableau dashboards.
-
Search External Amazon Marketplace Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Amazon Marketplace data to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Amazon Marketplace Data objects that you can access from apps and the dashboard.
-
Automated Continuous QuickBooks Online Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable QuickBooks Online replication to Google Cloud SQL.
-
Use the CData Software ODBC Driver for Google Sheets in SAS for Real-Time Reporting and Analytics
Connect to real-time Google Sheets data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Google Sheets.
-
Visualize Bitbucket Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Bitbucket data.
-
Operational Reporting on Excel Online Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Excel Online data.
-
Connect to Acumatica Data in CloverDX (formerly CloverETL)
Transfer Acumatica data using the visual workflow in the CloverDX data integration tool.
-
How to Use a Microsoft Access Database to Update JSON Services in Real Time
Update JSON data by creating a linked table in Microsoft Access with the CData JSON ODBC Driver.
-
Automated Continuous Snapchat Ads Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Snapchat Ads replication to IBM DB2.
-
Explore Geographical Relationships in Zuora Data with Power Map
Create data visualizations with Zuora data in Power Map.
-
Getting Started with the CData Connect AI Python SDK for Cvent
Install the CData Connect AI Python SDK to read and write live Cvent data with standard DB-API 2.0 Python code.
-
Build Charts with Email Data in Clear Analytics
Create dynamic charts and perform analytics based on Email data in Clear Analytics.
-
Integrate with ShipEngine Data in SnapLogic
Use CData Connect AI to connect to and integrate with live ShipEngine data in SnapLogic.
-
Query ServiceNow Data as a SQL Server Database in Node.js
Execute SQL Server queries against ServiceNow data from Node.js.
-
Automated Continuous Postmark Replication to SQL Server
Use CData Sync for automated, continuous, customizable Postmark replication to SQL Server.
-
Access Adobe Target Data from MySQL in PHP
Connect to Adobe Target through the standard MySQL libraries in PHP.
-
Connect to Everhour Data in DBArtisan
Use wizards in DBArtisan to configure Everhour data as a data source.
-
Create Dynamic Aweber Grids Using the Infragistics XamDataGrid
Learn how you can connect Aweber to Infragistics XamDataGrid to build dynamic grids.
-
How to integrate Metabase with Jira Assets Data
Use CData Connect AI to connect to live Jira Assets data and create an interactive dashboard in Metabase from Jira Assets data.
-
Automated Continuous Google Ad Manager Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Google Ad Manager replication to delimited files (CSV/TSV).
-
Getting Started with the CData Power BI Connector for Calendly
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Access Live Trello Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Trello data from your Excel spreadsheets.
-
Use the CData ODBC Driver for Intercom from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Intercom to connect to Intercom data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Intercom data in Excel.
-
Build MarkLogic-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for MarkLogic Data and create custom apps in Mendix.
-
Replicate Multiple Customer.io Accounts via the CData Sync CLI
Replicate multiple Customer.io accounts to one or many databases.
-
Connecting Mastra with Toggl 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 Toggl data, no replication required.
-
Create Informatica Mappings From/To a JDBC Data Source for Humanity
Create Humanity data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Integrating LangChain with Azure DevOps Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Azure DevOps data within automated workflows.
-
Analyze Supabase Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Supabase data and visualize Supabase data in SAP Analytics Cloud.
-
Replicate Teamwork Data from PowerShell
Write a quick PowerShell script to query Teamwork data. Use connectivity to the live data to replicate Teamwork data to SQL Server.
-
Build Salesforce CRM Analytics-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Salesforce CRM Analytics data and build Salesforce CRM Analytics-connected web apps with Axios.
-
Access Live ShipEngine Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live ShipEngine data from your Excel spreadsheets.
-
Connect to ChartMogul Data in JRuby
Create a simple JRuby app with access to live ChartMogul data.
-
Integrate with Lakebase Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Lakebase data to a JSON file on disk.
-
Prepare, Blend, and Analyze Printify Data in Alteryx Designer (ODBC)
Build workflows to access live Printify data for self-service data analytics.
-
Validate Campaigner Data with QuerySurge
Access and validate Campaigner data in QuerySurge using the CData JDBC Driver.
-
Create Data Visualizations in Cognos BI with Square Data
Access Square data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Connect Foursquare to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Foursquare data using the CData Python MCP Server.
-
Connect to Drip Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Drip data.
-
Connect to Campaigner Data in Jaspersoft Studio
Execute SQL to remote Campaigner data in Jaspersoft Studio.
-
Automated Continuous Coda Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Coda data replication to OneLake in Microsoft Fabric.
-
Visualize Live Act CRM Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Act CRM data.
-
How to Access SurveyMonkey Data Using Entity Framework
This article shows how to access SurveyMonkey data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Visualize Live Amazon Athena Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Amazon Athena data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Create Data Visualizations Based On LinkedIn Data in Mode
Use CData Connect AI to connect to LinkedIn Data from Mode and build visualizations using live LinkedIn data.
-
Integrate Open WebUI with Live SAS xpt Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live SAS xpt data from within the chat interface.
-
Publish Greenhouse-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Greenhouse data.
-
Integrate Google's Vertex AI Agent with Live Zoho Projects 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 Zoho Projects data within intelligent workflows.
-
How to connect to Pingdom Data from IntelliJ
Integrate connectivity to Pingdom data with wizards in IntelliJ.
-
Use Azure AI Foundry to Talk to Your SAP Concur 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 SAP Concur data for you.
-
Connect and Query Live Tavily Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Tavily data into Databricks and enable direct, live querying and analysis without replication.
-
Automate Browserless Data Replication to Azure Synapse
Use CData Sync to customize and automate Browserless data replication to Azure Synapse.
-
Integrate Cline with Live PolarTeamPro Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live PolarTeamPro data from within your IDE.
-
How to Visualize HubSpot Data in Python with pandas
Use pandas and other modules to analyze and visualize live HubSpot data in Python.
-
How to work with Monday.com Data in Apache Spark using SQL
Access and process Monday.com Data in Apache Spark using the CData Software JDBC Driver.
-
Integrating LangGraph with Square Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Square data within automated workflows.
-
Connect to Amplitude Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Amplitude and work with Amplitude data in your FileMaker applications.
-
Write a Simple Go Application to work with Google Search Results on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Google Search results.
-
Use Biml to Build SSIS Tasks to Replicate WordPress Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate WordPress data to SQL Server.
-
Integrate with live Zoho CRM Data in Jitterbit
Use CData Connect AI to connect to and integrate live Zoho CRM data in Jitterbit.
-
Build CapsuleCRM-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to CapsuleCRM data and build web apps with connectivity to live CapsuleCRM data.
-
Integrate Figshare with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Figshare with External Services.
-
Create Workday-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Workday Data from OutSystems and build custom enterprise apps using live Workday data.