CData Software - Knowledge Base
Recent Articles
-
Analyze Certinia Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Certinia data and visualize live Certinia data in Infragistics Reveal.
-
Automated Vimeo Data Replication to Teradata
Use CData Sync to Customize and automate Vimeo data replication to Teradata.
-
Perform Batch Operations with SAP SuccessFactors Data in Apache NiFi
Connect to SAP SuccessFactors data and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Connect to PolarTeamPro Data from AWS Glue
Use CData Connect AI to gain access to live PolarTeamPro data from your AWS Glue jobs.
-
Integrate Live Mode Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf's Cascade agent to securely access and query live Mode data from within the IDE.
-
Integrating GitHub Copilot with Google Spanner 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.
-
Integrate Real-Time Access to Microsoft Entra ID in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Microsoft Entra ID data in real time.
-
Automated Continuous RSS Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable RSS replication to PostgreSQL.
-
Rapidly Develop ZohoExpense-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 ZohoExpense.
-
Getting Started with the CData Python Connector for Azure Table
Learn to install and license the CData Python Connector and configure a connection to live Azure Table data.
-
Integrate Wistia Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Wistia data from Informatica Cloud.
-
How to Connect to Live Couchbase 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 Couchbase data for you.
-
Build Dashboards with Chargebee Data in Dundas BI
Create dynamic dashboards and perform analytics based on Chargebee data in Dundas BI.
-
Analyze Sybase Data in Cognos Analytics
Use CData Connect AI to connect to Sybase Data from Cognos Analytics and analyze live Sybase data.
-
How to Query Live Datadog Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Datadog data data in natural language using Python.
-
How to connect and process Salesforce Marketing data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Salesforce Marketing data.
-
Import Cloudflare Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Cloudflare Data and provide access to live Cloudflare data for custom reports in the Power BI Service.
-
Automated Continuous Placid Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Placid replication to Amazon S3.
-
Automate Paylocity Data Replication to Azure Data Lake
Use CData Sync to customize and automate Paylocity data replication to Azure Data Lake.
-
Connect HubDB to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live HubDB data using the CData Python MCP Server.
-
Load HDFS Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load HDFS data to a database.
-
Build GitHub-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live GitHub data and build GitHub-connected web apps with Axios.
-
Build Data Flows from Highrise to SQL Server using SSIS
Easily back up Highrise data to SQL Server using the SSIS components for Highrise.
-
Connect Gong Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Gong data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Integrating LangGraph with MongoDB Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on MongoDB data within automated workflows.
-
Create a Data Access Object for Pushbullet Data using JDBI
A brief overview of creating a SQL Object API for Pushbullet data in JDBI.
-
Validate Printful Data with QuerySurge
Access and validate Printful data in QuerySurge using the CData JDBC Driver.
-
Integrate with Google Cloud Storage Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Google Cloud Storage data in SnapLogic.
-
Manage SAP HANA XS Advanced Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for SAP HANA XS Advanced.
-
How to connect SharePoint with ADP Data through external lists
Provide ADP data to SharePoint users as an external list.
-
DataBind Onfleet Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Onfleet data to a chart.
-
How to create Visio diagrams from Google Drive Data
Automatically update Google Drive data with the changes you make to Visio master shapes.
-
Use the CData Software ODBC Driver for xBase in MicroStrategy
Connect to xBase data in MicroStrategy Developer using the CData Software ODBC Driver for xBase.
-
How to Visualize Basecamp 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 Basecamp data in Python.
-
How to Work with Mailgun Data in ETL Validator JDBC
Connect to Mailgun from ETL Validator jobs using the CData Software JDBC Driver.
-
Integrate Goose with Live Freshteam Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Freshteam data from within the local AI agent.
-
Build SAP Fieldglass-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to SAP Fieldglass data and build web apps with connectivity to live SAP Fieldglass data.
-
How to import Smartsheet Data into Apache Solr
Use the CData Software JDBC Driver for Smartsheet in Data Import Handler and create an automated import of Smartsheet data to Apache Solr Enterprise Search platform.
-
Query Invoiced Data as a MySQL Database in Node.js
Execute MySQL queries against Invoiced data from Node.js.
-
How to Connect WordPress 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 WordPress data in real time using natural language.
-
How to connect to Greenplum Data with Squirrel SQL client
Connect to Greenplum data and execute queries in the Squirrel SQL Client.
-
Automated Continuous Postmark Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Postmark replication to delimited files (CSV/TSV).
-
Automated Continuous Billsby Replication to SQL Server
Use CData Sync for automated, continuous, customizable Billsby replication to SQL Server.
-
Replicate ZarMoney Data to Multiple Databases via the CData Sync CLI
Replicate ZarMoney data to disparate databases with a single configuration.
-
Connect to Exact Online Data from a Connection Pool in JBoss
Integrate Exact Online data into Java servlets: Use the Management Console in JBoss to install the Exact Online JDBC Driver.
-
How to Access Live Mixpanel Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Mixpanel enables you to integrate Mixpanel data into workflows built using Microsoft Power Automate Desktop.
-
Create AgileCRM-Connected Applications in Appsmith
Connect to AgileCRM Data via CData Connect AI in Appsmith and create custom business applications with real-time access to AgileCRM data.
-
Work with Impala Data in FoxPro
Load Impala data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Import iContact Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to iContact Data and provide access to live iContact data for custom reports in the Power BI Service.
-
How to Create Power BI Visual Reports with Real-Time Calendly Data
Use CData Power BI Connectors to visualize Calendly data in Power BI.
-
Replicate Marketo Data to Multiple Databases via the CData Sync CLI
Replicate Marketo data to disparate databases with a single configuration.
-
Getting Started with the CData ADO.NET Provider for Notion
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Consume Elasticsearch OData Feeds in PowerBuilder
This article demonstrates how to consume Elasticsearch data as OData feeds from PowerBuilder using the API Server.
-
Replicate Microsoft Planner Data to Multiple Databases
Replicate Microsoft Planner data to disparate databases with a point-and-click configuration.
-
How to connect to Cloudflare Data with Squirrel SQL client
Connect to Cloudflare data and execute queries in the Squirrel SQL Client.
-
LINQ to Moosend 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 Moosend Data Provider.
-
Automated Continuous Neo4J Replication to MongoDB
Use CData Sync for automated, continuous, customizable Neo4J replication to MongoDB.
-
Connect to Kafka Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Kafka data in Airbyte.
-
Connecting Moonlit Workflow with WooCommerce Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Moonlit workflows to securely read and act on your WooCommerce data in real time.
-
Back Up Typeform 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 Typeform data data.
-
Connect to Databricks Data in DBArtisan
Use wizards in DBArtisan to configure Databricks data as a data source.
-
Deploy the ADO.NET Provider for Salesforce CRM Analytics on an SSRS Report Server
Connect to Salesforce CRM Analytics 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.
-
Build Pipelines with Live SAP HANA Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to SAP HANA from Google Cloud Data Fusion, enabling the integration of live SAP HANA data into the building and management of effective data pipelines.
-
Use the CData SSIS Components to Insert New or Update Existing Google Drive Records from SQL Server
Easily push SQL Server data to Google Drive using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Google Drive or update existing records with data from a SQL Server database.
-
Work with Live Databricks Data in Power Query
Use CData Connect AI to connect to Databricks data and work with live Databricks data in Microsoft Power Query.
-
Connect to Coinbase Data in Aqua Data Studio
Access Coinbase data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Automated Continuous Apollo Replication to Vertica
Use CData Sync for automated, continuous, customizable Apollo replication to Vertica.
-
Creating API Driver API Profiles
Create a new API Profiles to enable SQL access to a new API.
-
Automated Continuous SAP HANA Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable SAP HANA replication to Azure SQL Database.
-
Create Power BI Reports on Real-Time Box Data
Use the CData ODBC Driver for Box to visualize Box data in Power BI Desktop.
-
How to work with IBM Informix Data in Apache Spark using SQL
Access and process IBM Informix Data in Apache Spark using the CData Software JDBC Driver.
-
Migrating data from Teradata to Snowflake using CData SSIS Components.
Easily push Teradata data to Snowflake using the CData SSIS Tasks for Teradata and Snowflake.
-
How to Visualize Quickbase 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 Quickbase data in Python.
-
Use the CData ODBC Driver for Impala from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Impala to connect to Impala data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Impala data in Excel.
-
Work with Live Salesforce Data 360 Data in Power Query
Use CData Connect AI to connect to Salesforce Data 360 data and work with live Salesforce Data 360 data in Microsoft Power Query.
-
Connect to Helpscout Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Helpscout to connect to Helpscout data and execute queries in PowerBuilder.
-
Query Workable Data in DataGrip
Create a Data Source for Workable in DataGrip and use SQL to query live Workable data.
-
Connecting Moonlit Workflow with Snowflake Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Moonlit workflows to securely read and act on your Snowflake data in real time.
-
Build JSON Visualizations in Tableau Desktop
Use CData Connect AI to connect to live JSON services and build visualizations in Tableau.
-
Build Semantic Layer Views for SFTP Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for SFTP data.
-
Using the CData Software ODBC Driver for Tickspot in PyCharm
Connect to Tickspot as an ODBC data source in PyCharm using the CData Software ODBC Driver for Tickspot.
-
Create Datasets from Reckon Accounts Hosted in Domo Workbench and Build Visualizations of Reckon Accounts Hosted Data in Domo
Use the CData Software ODBC Driver for Reckon Accounts Hosted to create datasets from Reckon Accounts Hosted data in Domo Workbench and then build visualizations in the Domo service.
-
Build Automated Campaigner-Connected Workflows in Zapier
Use CData Connect AI to connect to live Campaigner data and build automated workflows in Zapier.
-
Build AI/ML Models with Live Google Search Data using Dataiku
Connect Google Search Data with Dataiku using the CData JDBC Driver for Google Search.
-
How to Connect to Live Airtable 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 Airtable data for you.
-
Getting Started with the CData Excel Add-In for SAP SuccessFactors
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for SAP SuccessFactors.
-
Design BIRT Reports on Redis Data
Provide current Redis data to your embedded analytics.
-
How to Connect to Live Yelp Data from Claude Agent SDK (via CData Connect AI)
Leverage CData Connect AI to enable Claude Agent SDK applications to securely read and take actions on your Yelp data for you.
-
Integrate with SuiteCRM Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy SuiteCRM data to a JSON file on disk.
-
Integrating Dataiku with Couchbase Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Couchbase data.
-
Object-Relational Mapping (ORM) with Optimizely 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 Optimizely data into a Java-based ORM framework, Hibernate.
-
How to Connect to Live Exact Online 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 Exact Online data through natural language.
-
Import and Visualize SAP Data in Power View
Create data visualizations based on SAP data in Excel.
-
Create Datasets from Nethunt in Domo Workbench and Build Visualizations of Nethunt Data in Domo
Use the CData Software ODBC Driver for Nethunt to create datasets from Nethunt data in Domo Workbench and then build visualizations in the Domo service.
-
Analyze Wave Financial Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Wave Financial data with the CData JDBC Driver for Wave Financial.
-
Connect to MailerSend Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for MailerSend and the SQL Gateway to access MailerSend data from Google Apps Script.
-
Connect to Typeform Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to Typeform.
-
Connect to Toggl Data in Google Apps Script via Connect AI
Use CData Connect AI to access Toggl data in Google Apps Script.
-
Create Amplitude Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Amplitude data access from reports, embedded analytics, and more.
-
Connect to Postmark Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Postmark as an External Source in Dremio.