CData Software - Knowledge Base
Recent Articles
-
Automate SAP Hybris C4C Data Replication to Azure Synapse
Use CData Sync to customize and automate SAP Hybris C4C replication to Azure Synapse.
-
Automated Continuous Reckon Accounts Hosted Replication to SingleStore
Use CData Sync for automated, continuous, customizable Reckon Accounts Hosted replication to SingleStore.
-
Integrate Cline with Live Google Drive Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Google Drive from within your IDE.
-
Connect AdRoll to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect AdRoll with IBM WebSphere for seamless data integration and connectivity.
-
Create DB2-Connected Nintex Workflows
Use CData Connect AI to connect to DB2 Data from Nintex Workflow Cloud and build custom workflows using live IBM DB2.
-
Migrating data from Zoho CRM to Snowflake using CData SSIS Components.
Easily push Zoho CRM to Snowflake using the CData SSIS Tasks for Zoho CRM and Snowflake.
-
How to Seamlessly Import Apify Data into IBM SPSS Modeler
Integrate Apify data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Edit and Search PagerDuty External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of PagerDuty to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create PagerDuty objects that you can access from apps and the dashboard.
-
Build Apps with Live Demio Data Using the Low-Code Development Platform of Mendix
Connect Demio with Mendix to build apps using the CData API Driver for JDBC.
-
Prepare, Blend, and Analyze Workday Data in Alteryx Designer (ODBC)
Build workflows to access live Workday for self-service data analytics.
-
Connect to ServiceDesk Plus Data in RapidMiner
Integrate ServiceDesk Plus with standard components and data source configuration wizards in RapidMiner Studio.
-
Integrating PivotalTracker Data in Talend Cloud Data Management Platform
Connect PivotalTracker Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Build an OLAP Cube in SSAS from Missive Data
Establish a connection to Missive data from SQL Server Analysis Services, and use the Missive Data Provider to build OLAP cubes for use in analytics and reporting.
-
Integrate Facebook with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Facebook with External Services.
-
Automated Continuous Amazon Marketplace Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Amazon Marketplace replication to Google BigQuery.
-
Seamlessly Bring Sybase IQ Data into Retool Using CData Connect AI
Integrate Sybase IQ data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Migrating data from Datadog to Google BigQuery using CData SSIS Components.
Easily push Datadog to Google BigQuery using the CData SSIS Tasks for Datadog and Google BigQuery.
-
Choosing the Best Method to Connect Presto to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Presto from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Build GitHub-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live GitHub.
-
Automated Continuous Front Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Front replication to IBM DB2.
-
Use the CData ODBC Driver for VWO in Microsoft Power Query
You can use the CData VWO ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import VWO into Microsoft Power Query.
-
Perform Batch Operations with SFTP Data in Apache NiFi
Connect to SFTP and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Visualize Cvent Data in TIBCO Spotfire through ADO.NET
Integrate Cvent into dashboards in TIBCO Spotfire.
-
Query SAP ByDesign Data in DataGrip
Create a Data Source for SAP ByDesign in DataGrip and use SQL to query live SAP Business ByDesign.
-
Migrating data from Workable to Databricks using CData SSIS Components.
Easily push Workable to Databricks using the CData SSIS Tasks for Workable and Databricks.
-
DataBind Charts to PostgreSQL Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to PostgreSQL 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.
-
Provide OData Services of Drip Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Drip by developing a WCF Service Application.
-
How to Access Live Intercom Data in Visual Studio Code via Cline
Run CData API Driver for MCP Server on Windows Subsytem for Linux (WSL) and connect to live Intercom from the Cline extension in Visual Studio Code.
-
Automated Continuous Mouseflow Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Mouseflow replication to Apache Kafka.
-
Build Apollo-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Apollo Data and create custom apps in Mendix.
-
Integrating Cursor CLI with Stripe 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.
-
Connect to Avaza Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Avaza to connect to Avaza and execute queries in PowerBuilder.
-
Connect to Hacker News from Asprova with CData Software ODBC Driver for Hacker News
This article shows how to connect faster to Hacker News data from Asprova.
-
Rapidly Develop Supabase-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 Supabase.
-
Import ElevenLabs Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access ElevenLabs. In this article, you will use the OData format to import ElevenLabs into Microsoft Power Query.
-
Excel Spreadsheet Automation on Oracle HCM Cloud Data with the QUERY Formula
Pull data from Oracle HCM Cloud, automate spreadsheets, and more with the QUERY formula.
-
Moving Data from Timely to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Timely data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
How to create Opsgenie federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Opsgenie in MySQL .
-
Create Datasets from Couchbase in Domo Workbench and Build Visualizations of Couchbase Data in Domo
Use the CData Software ODBC Driver for Couchbase to create datasets from Couchbase in Domo Workbench and then build visualizations in the Domo service.
-
Getting Started with the CData JDBC Driver for ElevenLabs
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for ElevenLabs.
-
Access Live Printful Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Printful in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Feed Sage Cloud Accounting Data into FineReport
How to set Sage Business Cloud Accounting as a JDBC data source in FineReport.
-
How to import Wave Financial Data into Apache Solr
Use the CData Software JDBC Driver for Wave Financial in Data Import Handler and create an automated import of Wave Financial to Apache Solr Enterprise Search platform.
-
How to work with MongoDB Data in Apache Spark using SQL
Access and process MongoDB Data in Apache Spark using the CData Software JDBC Driver.
-
How to connect to LionDesk Data in DBVisualizer
Integrate LionDesk with visual data analysis tools and data connection wizards in DBVisualizer
-
Create Reports with Oracle Sales Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Oracle Sales.
-
A PostgreSQL Interface for Zoho Books Data using the CData ODBC Driver
Use the SQL Gateway and Zoho Books ODBC Driver to create a PostgreSQL entry-point for data access.
-
Easily Integrate Workday Data in Lazarus Pascal IDE
Learn how to easily integrate live Workday in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Automated Continuous CampaignMonitor Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable CampaignMonitor replication to Apache Kafka.
-
Access Live Cosmos DB Data in TIBCO Data Virtualization
Use the Cosmos DB Tibco DV Adapter to create a Azure Cosmos DB data source in TIBCO Data Virtualization Studio and gain access to live Azure Cosmos DB from your TDV Server.
-
Analyze Google Ad Manager Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Google Ad Manager and visualize Google Ad Manager in SAP Analytics Cloud.
-
How to Connect to Live Slack 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 Slack for you.
-
Build AI/ML Models with Live Workable Data using Dataiku
Connect Workable Data with Dataiku using the CData API Driver for JDBC.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Auth0
Provide connectivity to Auth0 through an SAP BusinessObjects universe.
-
Automated Continuous Oracle Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Oracle Database replication to OneLake in Microsoft Fabric.
-
Analyze PayPal Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of PayPal and visualize PayPal in SAP Analytics Cloud.
-
Create Power BI Reports on Real-Time ChargeOver Data
Use the CData ODBC Driver for ChargeOver to visualize ChargeOver in Power BI Desktop.
-
How to use SQLAlchemy ORM to access Google Contacts Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Google Contacts.
-
Connect and Visualize Live Cloudant Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live IBM Cloudant into the Databricks platform and create visualization dashboards with real-time IBM Cloudant.
-
Build a Singer.io Tap for LionDesk With the CData Python Connector
Learn how to easily build a Singer.io Tap for live LionDesk data using
-
Integrate with Teamwork Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Teamwork to a JSON file on disk.
-
Build Semantic Layer Views for Microsoft Exchange Data in APOS Live Data Gateway
Use the CData Connector for Microsoft Exchange in APOS Live Data Gateway to build Semantic Layer Views for Microsoft Exchange.
-
Use the CData API Server to Access Zuora Data in Microsoft PowerPivot
Use the CData API Server to connect to live Zuora in the Power Pivot business intelligence tool.
-
Integrating Gumloop with CouchDB Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Apache CouchDB within automated workflows.
-
Access Live Dynamics 365 Data in Roo Code via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Roo Code agents to securely access and build applications with live Microsoft Dynamics 365 through MCP integration.
-
How to Access Lakebase Data Using Entity Framework
This article shows how to access Lakebase using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Automated Continuous Monday.com Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Monday.com replication to Apache Kafka.
-
Use the CData API Server to Access Telegram Data in Microsoft PowerPivot
Use the CData API Server to connect to live Telegram in the Power Pivot business intelligence tool.
-
Automated Continuous Paylocity Replication to MySQL
Use CData Sync for automated, continuous, customizable Paylocity replication to MySQL.
-
Build Contentful-Powered Applications in Gemini Code Assist with CData MCP Server
Use the CData API Driver for MCP Server to explore live Contentful Data in Gemini Code Assist to assist with building Contentful-powered applications.
-
Access Live Xero Data in Coginiti Pro
Connect to and query live Xero Accounting from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
How to create an RPA flow for FreeAgent Data in UiPath Studio
Use the FreeAgent ODBC Driver to create workflows that access real-time FreeAgent without any coding.
-
How to Connect to Live Snowflake Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Snowflake securely in real time.
-
LINQ to Clio 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 Clio Data Provider.
-
How to Connect Flowise AI Agents to Live Microsoft Ads 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 Microsoft Ads without replication.
-
Load MarkLogic Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load MarkLogic to a database.
-
A PostgreSQL Interface for Certinia Data using the CData ODBC Driver
Use the SQL Gateway and Certinia ODBC Driver to create a PostgreSQL entry-point for data access.
-
Add ConvertKit Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for ConvertKit with the Informatica Enterprise Data Catalog to classify and organize data.
-
A PostgreSQL Interface for Cloudflare Data (MySQL Remoting via JDBC)
Use the Remoting features of the Cloudflare JDBC Driver to create a PostgreSQL entry-point for data access.
-
Build Semantic Layer Views for ZohoExpense Data in APOS Live Data Gateway
Use the CData Connector for ZohoExpense in APOS Live Data Gateway to build Semantic Layer Views for ZohoExpense.
-
Create Zoho Books-Connected Nintex Workflows
Use CData Connect AI to connect to Zoho Books Data from Nintex Workflow Cloud and build custom workflows using live Zoho Books.
-
Migrating data from RabbitMQ to Google BigQuery using CData SSIS Components.
Easily push RabbitMQ to Google BigQuery using the CData SSIS Tasks for RabbitMQ and Google BigQuery.
-
Migrating data from Jodoo to Google BigQuery using CData SSIS Components.
Easily push Jodoo to Google BigQuery using the CData SSIS Tasks for Jodoo and Google BigQuery.
-
Create SSAS Tabular Models from Microsoft Dataverse Data
How to build a SQL Server Analysis Service Tabular Model from Microsoft Dataverse (CDS) using CData drivers.
-
Viewing Opsgenie Data in RAD Studio Data Explorer
How to view Opsgenie in RAD Studio Data Explorer using the CData ODBC Driver for Opsgenie.
-
Moving Data from ConstantContact to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live ConstantContact data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
How to Connect to Live Hive 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 Apache Hive for you.
-
Object-Relational Mapping (ORM) with Foursquare 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 Foursquare into a Java-based ORM framework, Hibernate.
-
How to connect SharePoint with Oracle Eloqua Reporting Data through external lists
Provide Oracle Eloqua Reporting to SharePoint users as an external list.
-
Automated Continuous Box Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Box replication to Apache Kafka.
-
Use the CData Software JDBC Driver for Adobe Analytics in MicroStrategy Desktop
Connect to Adobe Analytics in MicroStrategy Desktop using the CData Software JDBC Driver for Adobe Analytics.
-
Connect to Outlook Data in RapidMiner
Integrate Outlook with standard components and data source configuration wizards in RapidMiner Studio.
-
Use CData Connect AI to Access Couchbase Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Couchbase in the Power Pivot business intelligence tool.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live NetSuite CRM & ERP using the Model Context Protocol.
-
Automated Continuous Grafana Replication to MySQL
Use CData Sync for automated, continuous, customizable Grafana replication to MySQL.
-
Query WooCommerce Data through ODBC in Node.js
Use node-odbc to execute SQL queries against WooCommerce from Node.js.
-
Access Live Accelo Data in Coginiti Pro
Connect to and query live Accelo from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Connect to Invoiced Data from a Connection Pool in JBoss
Integrate Invoiced into Java servlets: Use the Management Console in JBoss to install the Invoiced JDBC Driver.
-
Use the CData ODBC Driver for Strava in Microsoft Power Query
You can use the CData Strava ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Strava into Microsoft Power Query.
-
How to Query Live Blackbaud FE NXT Data in Perplexity MacOS Desktop
Connect to and query live Blackbaud FE NXT Data in Perplexity Desktop using CData MCP Server.