CData Software - Knowledge Base
Recent Articles
-
Integrating LangGraph with Slack Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Slack within automated workflows.
-
Automated Continuous Zuora Replication to MySQL
Use CData Sync for automated, continuous, customizable Zuora replication to MySQL.
-
Work with Cosmos DB Data in FoxPro
Load Azure Cosmos DB into a FoxPro database. This article includes full code and a walk-through of the process.
-
Add Nethunt Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Nethunt with the Informatica Enterprise Data Catalog to classify and organize data.
-
Use Biml to Build SSIS Tasks to Replicate Placid Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Placid to SQL Server.
-
Connect to Supabase in SpagoBI
Create reports featuring live Supabase in SpagoBI Studio. Host Supabase reports on SpagoBI Server.
-
Edit and Search External Microsoft OneDrive Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Microsoft OneDrive to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Microsoft OneDrive Data objects that you can access from apps and the dashboard.
-
Integrate Cursor with Live Paylocity Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Paylocity from within the editor.
-
Connect to Real-Time BigCommerce Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for BigCommerce and Dataflow to import and use BigCommerce in Power Apps.
-
Connect to Live WordPress Data in PostGresSQL Interface through CData Connect AI
Create a live connection to WordPress in CData Connect AI and connect to your WordPress from PostgreSQL.
-
How to connect and process IBM Informix from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live IBM Informix.
-
Automate Kintone Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live Kintone and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
Back Up Keap 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 Keap data.
-
Integrating Boomi Agentstudio with ServiceNow Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to ServiceNow, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Build Adobe Analytics Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Adobe Analytics and build visualizations in Tableau Cloud.
-
Use Microsoft Copilot Studio to talk to your FHIR Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Microsoft Copilot Studio to securely answer questions and take actions on your FHIR for you.
-
Work with Testmonitor Data in FoxPro
Load Testmonitor into a FoxPro database. This article includes full code and a walk-through of the process.
-
Access Contentful Data from MySQL in PHP
Connect to Contentful through the standard MySQL libraries in PHP.
-
Create Dynamic xBase Grids Using the Infragistics XamDataGrid
Learn how you can connect xBase to Infragistics XamDataGrid to build dynamic grids.
-
How to Connect to Live Oracle Eloqua 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 Oracle Eloqua through natural language.
-
Extend Google Sheets with Instagram Data
Make calls to Instagram from Google Apps Script via the API Server.
-
Create SSAS Tabular Models from Instagram Data
How to build a SQL Server Analysis Service Tabular Model from Instagram using CData drivers.
-
How to use SQLAlchemy ORM to access ConvertKit Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of ConvertKit.
-
Use Biml to Build SSIS Tasks to Replicate CouchDB Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Apache CouchDB to SQL Server.
-
How to Seamlessly Import Pinecone Data into IBM SPSS Modeler
Integrate Pinecone data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
How to connect to Wrike Data from Spring Boot
Connect to Wrike in a Spring Boot Application using the CData API Driver for JDBC
-
Build Zendesk-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Zendesk Data from Zoho Analytics and import live Zendesk.
-
Visualize Spotify Data in TIBCO Spotfire through ADO.NET
Integrate Spotify into dashboards in TIBCO Spotfire.
-
How to use SQLAlchemy ORM to access Nuclia Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Nuclia.
-
How to connect to Freshsales Data from Spring Boot
Connect to Freshsales in a Spring Boot Application using the CData API Driver for JDBC
-
Analyze SAP Ariba Procurement Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of SAP Ariba Procurement and visualize live SAP Ariba Procurement in Infragistics Reveal.
-
Query, Visualize, and Share live Workday Data in Redash
Use CData Connect AI to connect to live Workday in Redash for querying, visualizing, and sharing.
-
Analyze Coda Data in Infragistics Reveal
Use the CData API Server to create an OData API on top of Coda and visualize live Coda in Infragistics Reveal.
-
How to Build an ETL App for Stack Exchange Data in Python with CData
Create ETL applications and real-time data pipelines for Stack Exchange in Python with petl.
-
Use Grok to Talk to Your QuickBooks Time 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 QuickBooks Time for you.
-
Automated Continuous Airtable Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Airtable replication to Azure SQL Database.
-
Vault CRM Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Veeva Vault & Vault CRM through CData Connect AI using different applications and tools.
-
Working with HDFS Data in LINQPad
Execute LINQ queries to Apache HDFS in LINQPad.
-
Add Kintone Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Kintone with the Informatica Enterprise Data Catalog to classify and organize data.
-
Deploy the ADO.NET Provider for BigCommerce on an SSRS Report Server
Connect to BigCommerce 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.
-
Connect to Sentry Data in CloverDX (formerly CloverETL)
Transfer Sentry using the visual workflow in the CloverDX data integration tool.
-
How to Query Live CircleCI Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live CircleCI data in natural language using Python.
-
Write a Simple Go Application to work with Demio Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Demio.
-
Connect to PivotalTracker Data in NetBeans
Connect to PivotalTracker in NetBeans with the data source configuration wizard.
-
Connect to Real-Time Close Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Close in Power Apps.
-
How to Connect to Live Gmail 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 Gmail through natural language.
-
Natively Connect to SurveyMonkey Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to SurveyMonkey. Leverage the native support for ODBC in PHP.
-
Bidirectional Access to JDBC-ODBC Bridge Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate JDBC-ODBC Bridge in Filemaker Pro for Mac or Windows.
-
Connect to Gorgias Data in Jaspersoft Studio
Execute SQL to remote Gorgias in Jaspersoft Studio.
-
Connect to NASA Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time NASA using standard SQL.
-
Visualize TaxJar Data in Sisense
Create an ElastiCube in Sisense app with access to TaxJar.
-
Create Informatica Mappings From/To an ODBC Data Source for Testmonitor
Create an ODBC connection to Testmonitor in Informatica and browse and transfer Testmonitor.
-
Use Agno to Talk to Your QuickBooks Online 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 QuickBooks Online for you.
-
Connect to AgileCRM Data in Jaspersoft Studio
Execute SQL to remote AgileCRM in Jaspersoft Studio.
-
Integrate eBay with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate eBay with External Services.
-
Automated Continuous Facebook Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Facebook replication to Apache Kafka.
-
DataBind Controls to Tanda Data in C++Builder
DataBind to Tanda in C++Builder with standard components and controls.
-
Access Couchbase 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 Couchbase.
-
How to connect and process Microsoft SharePoint from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Microsoft SharePoint.
-
How to Connect to ConstantContact Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to ConstantContact. Leverage the pyodbc module for ODBC in Python.
-
Connect to Redis Data from PowerBuilder via ADO.NET
This article demonstrates how to access Redis from Appeon PowerBuilder using the CData ADO.NET Provider for Redis.
-
Automated Continuous Attio Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Attio replication to Apache Cassandra.
-
Connect to Google Calendar Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Google Calendar.
-
Add Kafka Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Kafka with the Informatica Enterprise Data Catalog to classify and organize data.
-
Publish Dynamics 365-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Microsoft Dynamics 365.
-
How to connect and process Twitter Ads from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Twitter Ads.
-
How to Query Live Mixpanel Data in Perplexity MacOS Desktop
Connect to and query live Mixpanel Data in Perplexity Desktop using CData MCP Server.
-
Bidirectional Access to YouTube Analytics Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate YouTube Analytics in Filemaker Pro for Mac or Windows.
-
How to integrate Metabase with QuickBooks Online Data
Use CData Connect AI to connect to live QuickBooks Online and create an interactive dashboard in Metabase from QuickBooks Online.
-
How to connect and process Guru from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Guru.
-
Connect to OpenWeatherMap Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for OpenWeatherMap.
-
How to Access Live MailerSend Data in Visual Studio Code via Cline
Run CData API Driver for MCP Server on Windows Subsytem for Linux (WSL) and connect to live MailerSend from the Cline extension in Visual Studio Code.
-
Natively Connect to SQL Analysis Services Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to SQL Analysis Services. Leverage the native support for ODBC in PHP.
-
Quaderno Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Quaderno facts in real time.
-
How to integrate Google Analytics with Apache Airflow
Access and process Google Analytics in Apache Airflow using the CData JDBC Driver.
-
Query Splunk Data in ColdFusion
Write standard ColdFusion data access code to connect to Splunk.
-
Integrate Live Mocean Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Mocean to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Connect Wrike to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Wrike with IBM WebSphere for seamless data integration and connectivity.
-
How to Connect the Power BI Service to Mocean: Complete Guide
Connect to the CData Software Power BI Connector for Mocean from PowerBI.com to provide real-time Mocean across the organization.
-
Connect to Bannerbear Data in NetBeans
Connect to Bannerbear in NetBeans with the data source configuration wizard.
-
Build Apps with Live Adobe Commerce in Adalo using CData Connect AI
Use CData Connect AI to integrate live Adobe Commerce into the Adalo platform and build custom mobile and web applications with real-time Adobe Commerce.
-
Connect to ZohoInvoice Data in JRuby
Create a simple JRuby app with access to live ZohoInvoice.
-
Build AI Agents with Cosmos DB 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 Azure Cosmos DB through CData Connect AI.
-
Replicate Multiple Delighted Accounts
Replicate multiple Delighted accounts to one or many databases.
-
Connect to and Visualize Live ADP Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live ADP.
-
How to Query Live RSS Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live RSS Feeds data in natural language using Python.
-
Connect to Accelo Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Accelo.
-
Automated Continuous Oracle Eloqua Replication to SQLite
Use CData Sync for automated, continuous, customizable Oracle Eloqua replication to SQLite.
-
Connect to Egnyte Data in HULFT Integrate
Connect to Egnyte as a JDBC data source in HULFT Integrate
-
Quickbase Reporting in OBIEE with the Quickbase JDBC Driver
Deploy the Quickbase JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Prepare, Blend, and Analyze ZohoPeople Data in Alteryx Designer (ODBC)
Build workflows to access live ZohoPeople for self-service data analytics.
-
Use Microsoft Copilot Studio to talk to your Shopify Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Microsoft Copilot Studio to securely answer questions and take actions on your Shopify for you.
-
How to Connect Okta 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 Okta data in real time using natural language.
-
Create Informatica Mappings From/To an ODBC Data Source for Reckon
Create an ODBC connection to Reckon in Informatica and browse and transfer Reckon.
-
Access Live Gong Data in TIBCO Data Virtualization
Use the CData API Driver for Tibco DV to create a Gong data source in TIBCO Data Virtualization Studio and gain access to live Gong from your TDV Server.
-
Connect to Confluence Data from AWS Glue
Use CData Connect AI to gain access to live Atlassian Confluence from your AWS Glue jobs.
-
Use the CData Software ODBC Driver for Exact Online in MicroStrategy Desktop
Connect to Exact Online in MicroStrategy Desktop using the CData Software ODBC Driver for Exact Online.
-
How to publish and share Amplitude Data dashboards with Tableau Server
The CData ODBC driver for Amplitude enables you integrate Amplitude into Tableau dashboards.
-
Build Mouseflow-Powered Applications in Claude Code with CData MCP Server
Use the CData API Driver for MCP Server to explore live Mouseflow Data in Claude Code to assist with building Mouseflow-powered applications.
-
Integrate with Reckon Accounts Hosted Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Reckon Accounts Hosted to a JSON file on disk.