CData Software - Knowledge Base
Recent Articles
-
Back Up Apache Kafka to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Kafka. In this article, we will employ an SSIS workflow to populate a database with Apache Kafka data.
-
Use the CData Software ODBC Driver for MongoDB in SAS for Real-Time Reporting and Analytics
Connect to real-time MongoDB in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for MongoDB.
-
Integrating Gumloop with SQL Server via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Microsoft SQL Server within automated workflows.
-
Design BIRT Reports on SAP Ariba Source
Provide current SAP Ariba Source to your embedded analytics.
-
Load Dynamics NAV to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Microsoft Dynamics NAV to a database.
-
Publish Crystal Reports on Printful
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Printful.
-
A PostgreSQL Interface for Drift (MySQL Remoting via JDBC)
Use the Remoting features of the Drift JDBC Driver to create a PostgreSQL entry-point for data access.
-
Using the CData Software ODBC Driver for MongoDB in PyCharm
Connect to MongoDB as an ODBC data source in PyCharm using the CData Software ODBC Driver for MongoDB.
-
Process & Analyze Zoom in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Zoom .
-
Choosing the Best Method to Connect Bullhorn CRM to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Bullhorn CRM from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
How to Connect to Live YouTube Analytics in n8n Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable n8n to securely read and take actions on your YouTube Analytics for you.
-
Stream Couchbase into Apache Kafka Topics
Access and stream Couchbase in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Integrating LangChain with Trello via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Trello within automated workflows.
-
How to Access Live Dynamics NAV in Power Automate Desktop via ODBC
The CData ODBC Driver for Dynamics NAV enables you to integrate Microsoft Dynamics NAV into workflows built using Microsoft Power Automate Desktop.
-
Access CouchDB 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 Apache CouchDB.
-
Create Dashboards and Visualize Live Jira Service Management in Geckoboard
Use CData Connect AI to connect to live Atlassian Jira Service Management and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Provide OData Services of Sage 300 from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Sage 300 by developing a WCF Service Application.
-
Edit and Search SurveyMonkey External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of SurveyMonkey to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create SurveyMonkey objects that you can access from apps and the dashboard.
-
DataBind Controls to BigQuery in C++Builder
DataBind to Google BigQuery in C++Builder with standard components and controls.
-
Access Adobe Target from MySQL in Amazon QuickSight
Connect to Adobe Target and build visualizations of Adobe Target using a MySQL Connection in Amazon QuickSight.
-
Build Automated Impala-Connected Workflows in Zapier
Use CData Connect AI to connect to live Apache Impala and build automated workflows in Zapier.
-
Access Live Google Analytics in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Google Analytics from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Integrate HCL Domino in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live HCL Domino from Informatica Cloud.
-
Access Live Jira Service Management in AWS Lambda
Connect to live Atlassian Jira Service Management in AWS Lambda using the CData JDBC Driver.
-
Connect to JDBC-ODBC Bridge in RapidMiner
Integrate JDBC-ODBC Bridge with standard components and data source configuration wizards in RapidMiner Studio.
-
Import Real-Time Zoho Projects via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Zoho Projects in ColdFusion.
-
Getting Started with the CData SSIS Components for HCL Domino
Complete guide to installing, licensing, and connecting with the CData SSIS Components for HCL Domino.
-
Connect to Harvest as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Harvest.
-
LINQ to Twitter Ads
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 Twitter Ads Data Provider.
-
Analyze Dynamics 365 Business Central in Looker
Use CData Connect AI to connect to Dynamics 365 Business Central from Looker and build custom apps using live Dynamics 365 Business Central.
-
Integrate with Excel using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Microsoft Excel to a JSON file on disk.
-
Automated Continuous SAP Fieldglass Replication to SQLite
Use CData Sync for automated, continuous, customizable SAP Fieldglass replication to SQLite.
-
DataBind Charts to Sage 300
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Sage 300 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.
-
Rapidly Develop CockroachDB-Driven Apps with Active Query Builder
Leverage the Active Query Builder SQL interface builder and the ease of .NET data access to create data-driven WinForms and ASP.NET apps.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed Sage 50 UK to Power BI dashboards. Simply drag and drop Sage 50 UK into data visuals on the Power BI canvas.
-
Create Twitter-Connected Applications in Appsmith
Connect to Twitter via CData Connect AI in Appsmith and create custom business applications with real-time access to Twitter.
-
Visualize Live Monday.com in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Monday.com into custom reports in Power BI.
-
How to Import Data from Pinterest into Google Sheets
Import Pinterest into a Google spreadsheet that is automatically refreshed.
-
Build Charts with Microsoft Planner in Clear Analytics
Create dynamic charts and perform analytics based on Microsoft Planner in Clear Analytics.
-
Connect to Confluence from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Atlassian Confluence using standard SQL.
-
How to Connect to Live IBM Informix 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 IBM Informix for you.
-
How to Design Twitter Power Apps with Database-Like Connectivity
This article shows how to gain real-time, database-like connectivity from mobile and tablet Power Apps.
-
Viewing Oracle Service Cloud in RAD Studio Data Explorer
How to view Oracle Service Cloud in RAD Studio Data Explorer using the CData ODBC Driver for Oracle Service Cloud.
-
Model, Search, and Visualize Live SAP SuccessFactors in ThoughtSpot
Use CData Connect AI to connect to live SAP SuccessFactors for modeling, searching, and visualizing.
-
Integrating Boomi Agentstudio with Tableau CRM Analytics via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Tableau CRM Analytics, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Use the CData Software ODBC Driver for SAP HANA in MicroStrategy Desktop
Connect to SAP HANA in MicroStrategy Desktop using the CData Software ODBC Driver for SAP HANA.
-
Automate Dynamics CRM Replication to Couchbase
Use CData Sync to Customize and automate Microsoft Dynamics CRM replication to Couchbase.
-
Use the CData Software ODBC Driver for CouchDB in MicroStrategy Web
Connect to Apache CouchDB in MicroStrategy Web using the CData Software ODBC Driver for CouchDB.
-
Connect to BigCommerce from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for BigCommerce to connect to BigCommerce and execute queries in PowerBuilder.
-
Analyze Couchbase in Infragistics Reveal
Use the CData API Server to create an OData API on top of Couchbase and visualize live Couchbase in Infragistics Reveal.
-
Getting Started with the CData Excel Add-In for PingOne
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for PingOne.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Oracle Sales
Provide connectivity to Oracle Sales through an SAP BusinessObjects universe.
-
Natively Connect to Twitter in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Twitter. Leverage the native support for ODBC in PHP.
-
How to Query Live Email Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Email data in natural language using Python.
-
Query OData Services in DataGrip
Create a Data Source for OData in DataGrip and use SQL to query live OData.
-
Create ShipStation Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time ShipStation data access from reports, embedded analytics, and more.
-
DataBind Controls to eBay in C++Builder
DataBind to eBay in C++Builder with standard components and controls.
-
Connect to Blackbaud FE NXT in ACL Analytics
Connect to Blackbaud FE NXT via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Blackbaud FE NXT.
-
How to Connect DBeaver to Reckon Accounts Hosted via a JDBC Driver
Manage Reckon Accounts Hosted with visual tools in DBeaver like the query browser.
-
How to Connect to Live OData Services 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 OData for you.
-
Connect to Dynamics 365 Business Central in DBeaver
Use the CData ODBC Driver to connect to Dynamics 365 Business Central in DBeaver.
-
Tableau CRM Analytics Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Tableau CRM Analytics facts in real time.
-
Connect to Hive through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Hive using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Create Dynamic Databricks Grids Using the Infragistics XamDataGrid
Learn how you can connect Databricks to Infragistics XamDataGrid to build dynamic grids.
-
Analyze Google Drive in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Google Drive in Microsoft R Open.
-
DataBind Controls to Shopify in Delphi
DataBind to Shopify in Delphi with standard data access components and controls.
-
Viewing SFTP in RAD Studio Data Explorer
How to view SFTP in RAD Studio Data Explorer using the CData ODBC Driver for SFTP.
-
Integrate with Pinterest in JReport Designer
Create charts and reports based on Pinterest in JReport Designer.
-
Connecting Mastra with Amazon Marketplace 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 data across 300+ enterprise sources no replication required.
-
Prepare, Blend, and Analyze SAP HANA in Alteryx Designer (Connect AI)
Build workflows to access live SAP HANA for self-service data analytics.
-
How to Connect to Live Microsoft Exchange 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 Microsoft Exchange for you.
-
Process & Analyze TigerGraph in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live TigerGraph .
-
Choosing the Best Method to Connect Harvest to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Harvest from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
How to connect and process FHIR from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live FHIR.
-
Automated Continuous Zuora Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Zuora replication to delimited files (CSV/TSV).
-
Create SSAS Tabular Models from Okta
How to build a SQL Server Analysis Service Tabular Model from Okta using CData drivers.
-
Create YouTube Analytics-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to YouTube Analytics from OutSystems and build custom enterprise apps using live YouTube Analytics.
-
Edit and Search External SurveyMonkey Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of SurveyMonkey to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create SurveyMonkey objects that you can access from apps and the dashboard.
-
Build Automated SAP Hybris C4C-Connected Workflows in Zapier
Use CData Connect AI to connect to live SAP Hybris C4C and build automated workflows in Zapier.
-
How to Query Live Zoho Books Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Zoho Books data in natural language using Python.
-
Automated Continuous Zuora Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Zuora replication to Apache Cassandra.
-
Object-Relational Mapping (ORM) with Sage 200 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 Sage 200 into a Java-based ORM framework, Hibernate.
-
Automated Continuous Pipedrive Replication to SQL Server
Use CData Sync for automated, continuous, customizable Pipedrive replication to SQL Server.
-
Integrate with Cassandra in JReport Designer
Create charts and reports based on Apache Cassandra in JReport Designer.
-
How to connect to Shopify in DBVisualizer
Integrate Shopify with visual data analysis tools and data connection wizards in DBVisualizer
-
How to connect PolyBase to Typeform
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Typeform.
-
Build LinkedIn-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to LinkedIn from Zoho Analytics and import live LinkedIn.
-
Object-Relational Mapping (ORM) with Monday.com 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 Monday.com into a Java-based ORM framework, Hibernate.
-
How to work with Smartsheet in Apache Spark using SQL
Access and process Smartsheet in Apache Spark using the CData Software JDBC Driver.
-
Access SAS Data Sets from MySQL in PHP
Connect to SAS Data Sets through the standard MySQL libraries in PHP.
-
How to Query Live BambooHR Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live BambooHR data in natural language using Python.
-
How to connect to Dynamics CRM from IntelliJ
Integrate connectivity to Microsoft Dynamics CRM with wizards in IntelliJ.
-
Connecting GenSpark with Salesforce via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to enterprise data across 300+ systems without any replication or custom integration required.
-
Connect to PayPal in JRuby
Create a simple JRuby app with access to live PayPal.
-
Automate Tasks in Power Automate Using the CData API Server
Automate actions like sending emails to a contact list, posting to social media, or syncing CRM and ERP.
-
Automated Continuous Salesloft Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Salesloft replication to Apache Cassandra.
-
Connect to Raisers Edge NXT in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Raisers Edge NXT and connect to Raisers Edge NXT in Akorbi Digital RunMyProcess.
-
Automate Google Ad Manager Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Google Ad Manager from PowerShell? This article demonstrates how to utilize the Google Ad Manager Cmdlets for tasks like connecting to Google Ad Manager, automating operations, downloading data, and more.
-
Use the CData ODBC Driver for Azure Table in Microsoft Power Query
You can use the CData Azure Table ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Azure Table Storage into Microsoft Power Query.
-
Integrate Twitter Ads with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Twitter Ads with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Twitter Ads.