CData Software - Knowledge Base
Recent Articles
-
Access Live Facebook Data in Excel 365 Online (Excel for the web)
Connect to Facebook from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Connect to Real-Time Front Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Front in Power Apps.
-
Integrating Antigravity CLI with ZohoSubscriptions via CData CLI
Connect ZohoSubscriptions to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Write a Simple Go Application to work with Google Contacts Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Google Contacts.
-
Migrating data from Instantly to Google BigQuery using CData SSIS Components.
Easily push Instantly to Google BigQuery using the CData SSIS Tasks for Instantly and Google BigQuery.
-
How to connect to Azure Analysis Services Data from IntelliJ
Integrate connectivity to Azure Analysis Services with wizards in IntelliJ.
-
Connect to Anaplan Data in Claris FileMaker Pro
Use the CData ODBC Driver for Anaplan in FileMaker Pro to connect to Anaplan and work with Anaplan in your FileMaker applications.
-
How to Design Smartsheet Power Apps with Database-Like Connectivity
Gain real-time, database-like connectivity to Smartsheet from mobile and tablet Power Apps.
-
How to Connect to Live SAP Business One 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 SAP Business One for you.
-
A PostgreSQL Interface for Redshift Data using the CData ODBC Driver
Use the SQL Gateway and Redshift ODBC Driver to create a PostgreSQL entry-point for data access.
-
Enable the Google Tasks JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Google Tasks.
-
Connect to Live Zoho Inventory Data in MicroStrategy through CData Connect AI
Create a live connection to Zoho Inventory Data in CData Connect AI and connect to your Zoho Inventory from MicroStrategy.
-
Integrate Real-Time Access to BigQuery in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Google BigQuery in real time.
-
Bidirectional Access to AdRoll Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate AdRoll in Filemaker Pro for Mac or Windows.
-
Connect to Coinbase Data in RapidMiner
Integrate Coinbase with standard components and data source configuration wizards in RapidMiner Studio.
-
Use Databricks Agent Bricks to Talk to Your Zoho Projects Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Zoho Projects for you.
-
Automated Continuous Wistia Replication to Databricks
Use CData Sync for automated, continuous, customizable Wistia replication to Databricks.
-
Extract, Transform, and Load Stripe Data in Informatica PowerCenter
Create a simple Workflow for Stripe in Informatica PowerCenter.
-
How to Query Live SAP Netweaver Gateway Data in Claude Desktop
Connect to and query live SAP Netweaver Gateway Data in Claude Desktop using CData MCP Server.
-
Create Power BI Reports on Real-Time Hugging Face Data
Use the CData ODBC Driver for Hugging Face to visualize Hugging Face in Power BI Desktop.
-
LINQ to Avaza 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 Avaza Data Provider.
-
Building Dynamic Web Pages with Cloudant Data Using AngularJS
Create single-page applications with live connectivity to Cloudant using the CData API Server.
-
Process & Analyze AfterShip Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live AfterShip Data.
-
Access Live Adobe Analytics Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Adobe Analytics into the statistical analysis tools available in SAS JMP. This article shows how to use Adobe Analytics in the Graph Builder and Query Builder.
-
Access HubDB 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 HubDB.
-
How to Easily Query Zendesk Data in OpenOffice Base
Connect to Zendesk data in OpenOffice Base using the CData ODBC Driver for Zendesk and generate reports with live data insights.
-
Automated Continuous Keap Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Keap replication to Apache Cassandra.
-
Getting Started with the CData ODBC Driver for SAP Ariba Procurement
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for SAP Ariba Procurement.
-
Access Live ADP Data in AWS Lambda (with IntelliJ IDEA)
Connect to live ADP in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Connect to Reckon Accounts Hosted Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Reckon Accounts Hosted and the SQL Gateway to access Reckon Accounts Hosted from Google Apps Script.
-
Query Reckon Data in ColdFusion
Write standard ColdFusion data access code to connect to Reckon.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Microsoft Dynamics 365 using the Model Context Protocol.
-
Back Up Email to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Email. In this article, we will employ an SSIS workflow to populate a database with Email data.
-
Build Visualizations of Contentful Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Contentful in Birst.
-
Create Informatica Mappings From/To a JDBC Data Source for Reckon
Create Reckon data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Getting Started with the CData ODBC Driver for Amazon Marketplace
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Amazon Marketplace.
-
How to integrate Metabase with Google Directory Data
Use CData Connect AI to connect to live Google Directory and create an interactive dashboard in Metabase from Google Directory.
-
Access Twitter Ads Data from MySQL in Amazon QuickSight
Connect to Twitter Ads and build visualizations of Twitter Ads using a MySQL Connection in Amazon QuickSight.
-
Connect to ConvertAPI 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 ConvertAPI and work with ConvertAPI in your FileMaker application.
-
Import and Visualize FormSite Data in Power View
Create data visualizations based on FormSite in Excel.
-
How to connect to Guru Data from IntelliJ
Integrate connectivity to Guru with wizards in IntelliJ.
-
Create MongoDB Dataflows on PowerBI.com
Connect to the CData Power BI Connector for MongoDB from PowerBI.com to create Power BI Dataflows with real-time data.
-
Connect to TigerGraph Data in RapidMiner
Integrate TigerGraph with standard components and data source configuration wizards in RapidMiner Studio.
-
Build Voice Agents in ElevenLabs with access to Live Dropbox Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Dropbox.
-
Using the CData Software ODBC Driver for Jumpseller in PyCharm
Connect to Jumpseller as an ODBC data source in PyCharm using the CData Software ODBC Driver for Jumpseller.
-
Bridge Email Connectivity with Apache NiFi
Access and process Email in Apache NiFi using the CData JDBC Driver.
-
Connect and Visualize Live Okta Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Okta into the Databricks platform and create visualization dashboards with real-time Okta.
-
Connect to Pingdom Data from PowerBuilder via JDBC
This article demonstrates how to access Pingdom from PowerBuilder using the Pingdom JDBC Driver.
-
Replicate AgileCRM Data to Multiple Databases via the CData Sync CLI
Replicate AgileCRM to disparate databases with a single configuration.
-
Build Blackbaud FE NXT-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Blackbaud FE NXT Data and create custom apps in Bubble.
-
Automated Continuous Samanage Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Samanage replication to Amazon Redshift.
-
Query Sage Cloud Accounting Data from Node.js
Use the OData endpoint of the CData API Server to connect to your Sage Business Cloud Accounting and perform CRUD operations on Sage Cloud Accounting from Node.js.
-
Use Biml to Build SSIS Tasks to Replicate FHIR Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate FHIR to SQL Server.
-
Build ActiveCampaign-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to ActiveCampaign and build web apps with connectivity to live ActiveCampaign.
-
Connect to Quaderno Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Quaderno.
-
Replicate Aha! Data to Multiple Databases
Replicate Aha! to disparate databases with a point-and-click configuration.
-
Automated Continuous Tanda Replication to Oracle
Use CData Sync for automated, continuous, customizable Tanda replication to Oracle.
-
Integrate LinkedIn Data in Pentaho Data Integration
Build ETL pipelines based on LinkedIn in the Pentaho Data Integration tool.
-
How to Connect to Live Databricks 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 Databricks for you.
-
How to Connect to Live WordPress 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 WordPress for you.
-
Automated Continuous Zoho Projects Replication to Oracle
Use CData Sync for automated, continuous, customizable Zoho Projects replication to Oracle.
-
Deploy the ADO.NET Provider for Raisers Edge NXT on an SSRS Report Server
Connect to Raisers Edge NXT 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.
-
Bind Live Adobe Analytics Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Adobe Analytics data
-
Create Data Visualizations in Cognos BI with Mode Data
Access Mode as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Access Google Ad Manager 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 Google Ad Manager.
-
Excel Spreadsheet Automation on SQLite Data with the QUERY Formula
Pull data from SQLite, automate spreadsheets, and more with the QUERY formula.
-
How to Access XML Data Using Entity Framework
This article shows how to access XML Files using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Certinia Reporting in OBIEE with the Certinia JDBC Driver
Deploy the Certinia JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Publish Azure DevOps-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Azure DevOps.
-
Using the CData Software ODBC Driver for Mocean in PyCharm
Connect to Mocean as an ODBC data source in PyCharm using the CData Software ODBC Driver for Mocean.
-
Connect to Demio Data in JRuby
Create a simple JRuby app with access to live Demio.
-
Connect to Discourse Data from a Connection Pool in Jetty
The Discourse JDBC Driver supports connection pooling: This article shows how to connect faster to Discourse from Web apps in Jetty.
-
How to Connect to & Open Couchbase Data in Microsoft Excel
This article uses the CData ODBC driver for Couchbase to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Automated Continuous Coinbase Replication to SQL Server
Use CData Sync for automated, continuous, customizable Coinbase replication to SQL Server.
-
Automated Continuous Avro Replication to SingleStore
Use CData Sync for automated, continuous, customizable Avro replication to SingleStore.
-
Create Sage Intacct-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Sage Intacct Data from OutSystems and build custom enterprise apps using live Sage Intacct.
-
Use Databricks Agent Bricks to Talk to Your Workday Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Workday for you.
-
Create a Data Access Object for MYOB AccountRight Data using JDBI
A brief overview of creating a SQL Object API for MYOB AccountRight in JDBI.
-
Integrating OpenCode Terminal with Humanity 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 Avaza Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Avaza replication to Apache Cassandra.
-
Create Datasets from Dynamics 365 in Domo Workbench and Build Visualizations of Dynamics 365 Data in Domo
Use the CData Software ODBC Driver for Dynamics 365 to create datasets from Microsoft Dynamics 365 in Domo Workbench and then build visualizations in the Domo service.
-
Getting Started with the CData Connect AI Python SDK for PostgreSQL
Install the CData Connect AI Python SDK to read and write live PostgreSQL with standard DB-API 2.0 Python code.
-
Integrating LangChain with Sybase IQ Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Sybase IQ within automated workflows.
-
Use the CData Software JDBC Driver for Pinterest in MicroStrategy
Connect to Pinterest in MicroStrategy Developer using the CData Software JDBC Driver for Pinterest.
-
Use the CData ODBC Driver for Webflow from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Webflow to connect to Webflow from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Webflow in Excel.
-
Analyze Dynamics 365 Data in Cognos Analytics
Use CData Connect AI to connect to Dynamics 365 Data from Cognos Analytics and analyze live Microsoft Dynamics 365.
-
Build AI/ML Models with Live Landbot Data using Dataiku
Connect Landbot Data with Dataiku using the CData API Driver for JDBC.
-
Getting Started with the CData JDBC Driver for SharePoint
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for SharePoint.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Authorize.Net using the Model Context Protocol.
-
Integrate with Gorgias Data in JReport Designer
Create charts and reports based on Gorgias in JReport Designer.
-
Extract, Transform, and Load Yelp Data in Informatica PowerCenter
Create a simple Workflow for Yelp in Informatica PowerCenter.
-
Integrating Boomi Agentstudio with Quickbase Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Quickbase, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
How to Work with Qualaroo Data in AWS Glue Jobs Using JDBC
Connect to Qualaroo from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Getting Started with the CData JDBC Driver for Salesforce
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Salesforce.
-
Natively Connect to Excel Online Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Microsoft Excel Online. Leverage the native support for ODBC in PHP.
-
Connect to Mouseflow Data in CloverDX (formerly CloverETL)
Transfer Mouseflow using the visual workflow in the CloverDX data integration tool.
-
Build Data Flows from Miro to SQL Server using SSIS
Easily back up Miro to SQL Server using the SSIS components for Miro.
-
Connect to and Query Copper Data in QlikView over ODBC
Create data visualizations with Copper in QlikView.
-
Access Live MYOB AccountRight 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 MYOB AccountRight through MCP integration.
-
How to Query Live Accelo Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Accelo data in natural language using Python.