CData Software - Knowledge Base
Recent Articles
-
Visualize SAP SuccessFactors LMS Data in TIBCO Spotfire through OData
Integrate SAP SuccessFactors LMS data into dashboards in TIBCO Spotfire.
-
How to work with ServiceNow Data in Apache Spark using SQL
Access and process ServiceNow Data in Apache Spark using the CData Software JDBC Driver.
-
How to integrate SendPulse with Apache Airflow
Access and process SendPulse data in Apache Airflow using the CData JDBC Driver.
-
Integrate OpenCode with Live Dynamics CRM Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable OpenCode to securely access and query live Dynamics CRM data from within your AI coding agent.
-
Create Power BI Reports on Real-Time LeadDesk Data
Use the CData ODBC Driver for LeadDesk to visualize LeadDesk data in Power BI Desktop.
-
How to Connect to Live Gmail 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 Gmail data for you.
-
Getting Started with the CData ODBC Driver for SAS Data Sets
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for SAS Data Sets.
-
Automated Continuous Humanity Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Humanity replication to PostgreSQL.
-
How to Import Gmail Data into Excel with CData
Learn how to connect and import Gmail data directly into Microsoft Excel using the CData Excel Add-In. Query, analyze, and visualize your email data using standard SQL.
-
How to Query Live Float Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Float data data in natural language using Python.
-
Analyze Okta Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Okta data in Microsoft R Open.
-
Integrating Dataiku with Bannerbear Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Bannerbear data.
-
How to connect and process Quickbase data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Quickbase data.
-
Integrating Gumloop with Cloudant Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Cloudant data within automated workflows.
-
Use Grok to Talk to Your ADP 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 ADP data for you.
-
How to connect SharePoint with Azure Data Lake Storage Data through external lists
Provide Azure Data Lake Storage data to SharePoint users as an external list.
-
Connect to Instagram Data in Jaspersoft Studio
Execute SQL to remote Instagram data in Jaspersoft Studio.
-
Integrate with Live Oracle Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Oracle from the MuleSoft Anypoint Platform to integrate live Oracle data into custom reports and dashboards.
-
Getting Started with the CData SSIS Components for ZeroBounce
Complete guide to installing, licensing, and connecting with the CData SSIS Components for ZeroBounce.
-
Use the CData Software JDBC Driver for Pinecone in MicroStrategy Desktop
Connect to Pinecone data in MicroStrategy Desktop using the CData Software JDBC Driver for Pinecone.
-
Choosing the Best Method to Connect Email to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Email data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Build Dashboards with Gmail Data in Dundas BI
Create dynamic dashboards and perform analytics based on Gmail data in Dundas BI.
-
Use the CData Software ODBC Driver for WordPress in SAS for Real-Time Reporting and Analytics
Connect to real-time WordPress data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for WordPress.
-
How to work with CapsuleCRM Data in Apache Spark using SQL
Access and process CapsuleCRM Data in Apache Spark using the CData Software JDBC Driver.
-
Establish a Live Connection with Salesforce Pardot Data using Tableau Bridge
The CData ODBC Driver for Salesforce Pardot enables you to integrate live Salesforce Pardot data into Tableau Cloud dashboards using the Tableau Bridge.
-
Connect to Sugar CRM Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Sugar CRM data.
-
How to publish and share Microsoft Dataverse Data dashboards with Tableau Server
The CData ODBC driver for Microsoft Dataverse enables you integrate Microsoft Dataverse data into Tableau dashboards.
-
Automate Stripe Data Replication to SAP HANA
Use CData Sync to customize and automate Stripe data replication to SAP HANA.
-
Import Avalara AvaTax Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Avalara AvaTax Data and provide access to live Avalara AvaTax data for custom reports in the Power BI Service.
-
How to Easily Query Oracle Sales Data in OpenOffice Base
Connect to Oracle Sales data in OpenOffice Base using the CData ODBC Driver for Oracle Sales and generate reports with live data insights.
-
Establish a Live Connection with Confluence Data using Tableau Bridge
The CData ODBC Driver for Confluence enables you to integrate live Confluence data into Tableau Cloud dashboards using the Tableau Bridge.
-
Configure the CData JDBC Driver for Reckon in a Connection Pool in Tomcat
Connect to Reckon data from a connection pool in Tomcat.
-
Prepare, Blend, and Analyze Airtable Data in Alteryx Designer (ODBC)
Build workflows to access live Airtable data for self-service data analytics.
-
How to Connect Optimizely 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 Optimizely data in real time using natural language.
-
Query Google Analytics Data as a SQL Server Database in Node.js
Execute SQL Server queries against Google Analytics data from Node.js.
-
Create Microsoft OneDrive-Connected Dashboards in Grafana
Connect to Microsoft OneDrive Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Microsoft OneDrive data.
-
How to Work with Outreach.io Data in AWS Glue Jobs Using JDBC
Connect to Outreach.io from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Connect to LinkedIn Ads Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for LinkedIn Ads data in the Denodo Virtual DataPort Administrator.
-
Use the CData Software ODBC Driver for Xero in SAS for Real-Time Reporting and Analytics
Connect to real-time Xero data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Xero.
-
Integrate Theia IDE with Live SuiteCRM Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE's built-in AI agents to securely access and query live SuiteCRM data from within the development environment.
-
Perform Batch Operations with Reckon Accounts Hosted Data in Apache NiFi
Connect to Reckon Accounts Hosted data and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Connecting Pipedream with Oracle Eloqua Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Pipedream workflows to securely read and take actions on Oracle Eloqua data in real time.
-
Build MVC Applications with Connectivity to Zoho CRM Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Zoho CRM from an ASP.NET MVC application.
-
Connect to Box Data from a Connection Pool in Jetty
The Box JDBC Driver supports connection pooling: This article shows how to connect faster to Box data from Web apps in Jetty.
-
Provide OData Services of FTP Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for FTP data by developing a WCF Service Application.
-
How to Use a Microsoft Access Database to Update MySQL Data in Real Time
Update MySQL data by creating a linked table in Microsoft Access with the CData MySQL ODBC Driver.
-
Integrating Claude Code with SQL Server Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on SQL Server data within assisted coding and automated development workflows.
-
Import Exact Online Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Exact Online Data and provide access to live Exact Online data for custom reports in the Power BI Service.
-
Analyze ConvertAPI Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for ConvertAPI from Power Pivot. You will use the Table Import Wizard to load ConvertAPI data. You can visually build the import query or use any SQL supported by the driver.
-
Publish Reports with Klaviyo Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Klaviyo data.
-
Integrating LangGraph with Perplexity Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Perplexity data within automated workflows.
-
Integrating LlamaIndex with SAP Fieldglass Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on SAP Fieldglass data in real time.
-
GraphQL Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on GraphQL facts in real time.
-
Connect to TigerGraph Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for TigerGraph to connect to TigerGraph data and execute queries in PowerBuilder.
-
DataBind Controls to HubSpot Data in Delphi
DataBind to HubSpot data in Delphi with standard data access components and controls.
-
Azure Synapse Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Azure Synapse facts in real time.
-
Extract, Transform, and Load Oracle Eloqua Reporting Data in Informatica PowerCenter
Create a simple Workflow for Oracle Eloqua Reporting data in Informatica PowerCenter.
-
How to connect to MailChimp Data from IntelliJ
Integrate connectivity to MailChimp data with wizards in IntelliJ.
-
How to Visualize Customer.io Data in Python with pandas
Use pandas and other modules to analyze and visualize live Customer.io data in Python.
-
Automated Continuous Elasticsearch Replication to Snowflake
Use CData Sync for automated, continuous, customizable Elasticsearch replication to Snowflake.
-
Building Dynamic Web Pages with Pipedrive Data Using AngularJS
Create single-page applications with live connectivity to Pipedrive using the CData API Server.
-
Import WordPress Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to WordPress Data and provide access to live WordPress data for custom reports in the Power BI Service.
-
Use Dash to Build to Web Apps on Square Data
Create Python applications that use pandas and Dash to build Square-connected web apps.
-
Access ActiveCampaign Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access ActiveCampaign data from your Oracle system.
-
DataBind Controls to CircleCI Data in C++Builder
DataBind to CircleCI data in C++Builder with standard components and controls.
-
Build Strava-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Strava data.
-
Create Data Visualizations in Cognos BI with Templated Data
Access Templated data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Use the CData Software JDBC Driver for Scrapfly in MicroStrategy Desktop
Connect to Scrapfly data in MicroStrategy Desktop using the CData Software JDBC Driver for Scrapfly.
-
Model SendPulse Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and SendPulse, enabling the direct import of real-time SendPulse data.
-
Search External IBM Cloud Object Storage Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of IBM Cloud Object Storage data to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create IBM Cloud Object Storage Data objects that you can access from apps and the dashboard.
-
How to Use a Microsoft Access Database to Update Facebook Data in Real Time
Update Facebook data by creating a linked table in Microsoft Access with the CData Facebook ODBC Driver.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Google Campaign Manager 360
Provide connectivity to Google Campaign Manager 360 data through an SAP BusinessObjects universe.
-
DataBind AdRoll Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide AdRoll data to a chart.
-
Connect to ElevenLabs Data in DBArtisan
Use wizards in DBArtisan to configure ElevenLabs data as a data source.
-
Automated Continuous Dynamics CRM Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Dynamics CRM replication to Google BigQuery.
-
Automate ConvertKit Data Replication to Azure Synapse
Use CData Sync to customize and automate ConvertKit data replication to Azure Synapse.
-
Use Biml to Build SSIS Tasks to Replicate SuiteCRM Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate SuiteCRM data to SQL Server.
-
ETL LaunchDarkly in Oracle Data Integrator
This article shows how to transfer LaunchDarkly data into a data warehouse using Oracle Data Integrator.
-
How to Access Live Nethunt Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Nethunt enables you to integrate Nethunt data into workflows built using Microsoft Power Automate Desktop.
-
Access Live Freshservice Data in Excel 365 Online (Excel for the web)
Connect to Freshservice data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Connect to MailChimp Data in RapidMiner
Integrate MailChimp data with standard components and data source configuration wizards in RapidMiner Studio.
-
Automate NetSuite Data Replication to Azure Data Lake
Use CData Sync to customize and automate NetSuite data replication to Azure Data Lake.
-
Analyze Eventbrite Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Eventbrite data in Microsoft R Open.
-
LINQ to ZohoSubscriptions 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 ZohoSubscriptions Data Provider.
-
Build Automated Workflows with Live Aweber Data in Workato
Use CData Connect AI to connect to live Aweber data and build automated workflows in Workato.
-
Analyze WordPress Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of WordPress data and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
DataBind Zuora Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for Zuora with the DevExpress Windows Forms and Web controls to provide Zuora data to a chart.
-
How to Connect Microsoft Exchange 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 Microsoft Exchange data in real time using natural language.
-
Access Live Facebook Ads 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 Facebook Ads data through MCP integration.
-
Access Live ConvertAPI Data in Coginiti Pro
Connect to and query live ConvertAPI data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Use the CData Software ODBC Driver for Monday.com in MicroStrategy
Connect to Monday.com data in MicroStrategy Developer using the CData Software ODBC Driver for Monday.com.
-
Build Automated Workflows with Live Timely Data in Workato
Use CData Connect AI to connect to live Timely data and build automated workflows in Workato.
-
Feed Dynamics CRM Data into FineReport
How to set Dynamics CRM data as a JDBC data source in FineReport.
-
Build Apps with Live ServiceNow data in Adalo using CData Connect AI
Use CData Connect AI to integrate live ServiceNow data into the Adalo platform and build custom mobile and web applications with real-time ServiceNow data.
-
Bind Live SAP HANA Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live SAP HANA data and seamlessly connect and bind them to Wijmo's FlexGrid for real-time, interactive data access without manual data movement.
-
How to create Copper federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Copper data in MySQL .
-
Automate Codat Data Replication to Azure Data Lake
Use CData Sync to customize and automate Codat data replication to Azure Data Lake.
-
Create Apps from Cloudant Data in Qlik Sense Cloud
Use CData Connect AI to connect to Cloudant Data and build apps from live Cloudant data in Qlik Sense Cloud.
-
Integrating Gumloop with Avalara AvaTax Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Avalara AvaTax data within automated workflows.
-
Integrate Splunk Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Splunk data from Informatica Cloud.