CData Software - Knowledge Base
Recent Articles
-
Getting Started with the CData Power BI Connector for Dynamics 365 Business Central
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Dynamics 365 Business Central.
-
Process & Analyze Discourse Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Discourse Data.
-
Getting Started with the CData Python Connector for Microsoft Exchange
Learn to install and license the CData Python Connector and configure a connection to live Microsoft Exchange data.
-
Visualize Live SageHR Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live SageHR data.
-
Use Azure AI Foundry to Talk to Your NetSuite Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Azure AI Foundry agents to securely answer questions and take actions on your NetSuite data for you.
-
Create Informatica Mappings From/To an ODBC Data Source for Teamwork
Create an ODBC connection to Teamwork in Informatica and browse and transfer Teamwork data.
-
Connect to Real-Time Google Calendar Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Google Calendar and Dataflow to import and use Google Calendar data in Power Apps.
-
Stream LightSpeedRetail Data into Apache Kafka Topics
Access and stream LightSpeedRetail data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
How to Seamlessly Import CSV Data into IBM SPSS Modeler
Integrate CSV data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Integrate Live Sage Intacct Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Sage Intacct data and integrate live Sage Intacct data into apps built in Microsoft Power Apps.
-
Analyze Live xBase Data in SAS Viya
Use CData Connect AI to connect to xBase data from SAS Viya and deploy self-service analytics using live xBase data.
-
How to create Cassandra federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Cassandra data in MySQL .
-
Build a Simple VCL Application for Bright Data Data
How to build a simple VCL Application to view Bright Data data in RAD Studio using the CData ODBC Driver for Bright Data.
-
Automated Continuous Spark Replication to Oracle
Use CData Sync for automated, continuous, customizable Spark replication to Oracle.
-
Connect to Real-Time Google Cloud Storage Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Google Cloud Storage and Dataflow to import and use Google Cloud Storage data in Power Apps.
-
Connect to Presto Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Presto data using standard SQL.
-
Analyze SAP SuccessFactors LMS Data in Looker
Use CData Connect AI to connect to SAP SuccessFactors LMS Data from Looker and build custom apps using live SAP SuccessFactors LMS data.
-
Excel Spreadsheet Automation on Bugsnag Data with the QUERY Formula
Pull data from Bugsnag, automate spreadsheets, and more with the QUERY formula.
-
Use JayDeBeApi to access EnterpriseDB Data in Python
Use standard Python scripting and the development environment of your choice to access live EnterpriseDB data.
-
Automated Continuous IBM Informix Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable IBM Informix replication to Azure SQL Database.
-
Prepare, Blend, and Analyze ShipEngine Data in Alteryx Designer (Connect AI)
Build workflows to access live ShipEngine data for self-service data analytics.
-
Integrate Reckon Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Reckon data and integrate live Reckon data into your Power Automate tasks.
-
How to Connect to Live Act-On 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 Act-On data for you.
-
Load TaxJar Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load TaxJar data to a database.
-
Getting Started with the CData Python Connector for Shopify
Learn to install and license the CData Python Connector and configure a connection to live Shopify data.
-
Connect to Salesforce Marketing from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Salesforce Marketing data, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Automated Continuous Dynamics NAV Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Dynamics NAV replication to IBM DB2.
-
Query Factorial Data in ColdFusion
Write standard ColdFusion data access code to connect to Factorial data.
-
Connect to Contentful Data in RazorSQL
Connect to Contentful from wizards and query Contentful data from the GUI in the RazorSQL database management tool.
-
Stream Databricks Data into Apache Kafka Topics
Access and stream Databricks data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Integrating Antigravity CLI with Pipeliner CRM data via CData CLI
Connect Pipeliner CRM data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
DataBind Controls to Dynamics 365 Business Central Data in Delphi
DataBind to Dynamics 365 Business Central data in Delphi with standard data access components and controls.
-
Deploy the ADO.NET Provider for Oracle Sales on an SSRS Report Server
Connect to Oracle Sales 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.
-
Automated Continuous Oracle Service Cloud Replication to SingleStore
Use CData Sync for automated, continuous, customizable Oracle Service Cloud replication to SingleStore.
-
Create Dynamic Google Ad Manager Grids Using the Infragistics XamDataGrid
Learn how you can connect Google Ad Manager to Infragistics XamDataGrid to build dynamic grids.
-
Build Charts with Perplexity Data in Clear Analytics
Create dynamic charts and perform analytics based on Perplexity data in Clear Analytics.
-
Analyze Anaplan Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Anaplan data in Microsoft R Open.
-
Automated Continuous Monday.com Replication to SingleStore
Use CData Sync for automated, continuous, customizable Monday.com replication to SingleStore.
-
Automated Continuous ZohoExpense Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable ZohoExpense replication to Azure SQL Database.
-
Integrating LangGraph with BambooHR Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on BambooHR data within automated workflows.
-
Create Reports from Zoho Creator Data in Looker Studio
Use CData Connect AI to gain access to live Zoho Creator data and create custom reports in Looker Studio.
-
Deploy the ADO.NET Provider for Mode on an SSRS Report Server
Connect to Mode 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.
-
Use the CData Software JDBC Driver for Reply.io in MicroStrategy Web
Connect to Reply.io data in MicroStrategy Web using the CData Software JDBC Driver for Reply.io.
-
Use the CData Software JDBC Driver for Auth0 in MicroStrategy Web
Connect to Auth0 data in MicroStrategy Web using the CData Software JDBC Driver for Auth0.
-
Excel Spreadsheet Automation on eBay Analytics Data with the QUERY Formula
Pull data from eBay Analytics, automate spreadsheets, and more with the QUERY formula.
-
Integrate ClickUp with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate ClickUp with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to ClickUp data.
-
Edit and Search External MailChimp Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of MailChimp data to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create MailChimp Data objects that you can access from apps and the dashboard.
-
Create Datasets from Egnyte in Domo Workbench and Build Visualizations of Egnyte Data in Domo
Use the CData Software ODBC Driver for Egnyte to create datasets from Egnyte data in Domo Workbench and then build visualizations in the Domo service.
-
Migrating data from SAP SuccessFactors LMS to Databricks using CData SSIS Components.
Easily push SAP SuccessFactors LMS data to Databricks using the CData SSIS Tasks for SAP SuccessFactors LMS and Databricks.
-
Work with Live Samanage Data in Power Query
Use CData Connect AI to connect to Samanage data and work with live Samanage data in Microsoft Power Query.
-
Connect and Query Live Dynamics NAV Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Dynamics NAV data into Databricks and enable direct, live querying and analysis without replication.
-
How to Connect to Live SAP HANA XS Advanced Data in Mistral AI Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live SAP HANA XS Advanced data without replication.
-
Integrating LangGraph with SingleStore Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on SingleStore data within automated workflows.
-
A PostgreSQL Interface for Google Forms Data using the CData ODBC Driver
Use the SQL Gateway and Google Forms ODBC Driver to create a PostgreSQL entry-point for data access.
-
Provide OData Services of Harvest Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Harvest data by developing a WCF Service Application.
-
Getting Started with the CData SSIS Components for Redis
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Redis.
-
Choosing the Best Method to Connect Typeform to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Typeform data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Publish Customer.io-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Customer.io data.
-
Automate Google Calendar Data Replication to Azure Data Lake
Use CData Sync to customize and automate Google Calendar data replication to Azure Data Lake.
-
Integrating LangGraph with Google Analytics Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Google Analytics data within automated workflows.
-
Integrate Live Azure Analysis Services 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 Azure Analysis Services data from within the IDE.
-
Connect to Slack Data in DBeaver
Use the CData ODBC Driver to connect to Slack data in DBeaver.
-
Manage Beeminder Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Beeminder.
-
Consume Certinia OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Certinia feeds that reflect any changes in SAP Lumira.
-
How to create Productboard federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Productboard data in MySQL .
-
How to Create Power BI Visual Reports with Real-Time Oracle Data
Use CData Power BI Connectors to visualize Oracle data in Power BI.
-
Model Avro Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Avro, enabling the direct import of real-time Avro data.
-
Integrate Google's Antigravity Agent with Live Salesforce Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Salesforce data using the Model Context Protocol.
-
Access Amazon Marketplace Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Amazon Marketplace data from your Oracle system.
-
Model, Search, and Visualize Live LinkedIn Data in ThoughtSpot
Use CData Connect AI to connect to live LinkedIn data for modeling, searching, and visualizing.
-
Create a Data Access Object for SageHR Data using JDBI
A brief overview of creating a SQL Object API for SageHR data in JDBI.
-
How to Connect DBeaver to Google Drive via a JDBC Driver
Manage Google Drive data with visual tools in DBeaver like the query browser.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for LinkedIn Ads
Provide connectivity to LinkedIn Ads data through an SAP BusinessObjects universe.
-
Datadog Reporting in OBIEE with the Datadog JDBC Driver
Deploy the Datadog JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Integrate Google's Vertex AI Agent with Live Exact Online Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Exact Online data within intelligent workflows.
-
Automated Continuous Sendwithus Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Sendwithus replication to Google BigQuery.
-
Automated Continuous MailerLite Replication to Snowflake
Use CData Sync for automated, continuous, customizable MailerLite replication to Snowflake.
-
Getting Started with the CData SSIS Components for Brex
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Brex.
-
Rapidly Develop Oracle Eloqua-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 Oracle Eloqua.
-
Write a Simple Go Application to work with Spotify Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Spotify data.
-
DataBind Controls to Paddle Data in C++Builder
DataBind to Paddle data in C++Builder with standard components and controls.
-
DataBind Controls to Webflow Data in Delphi
DataBind to Webflow data in Delphi with standard data access components and controls.
-
Use the CData Software ODBC Driver for Workable in MicroStrategy
Connect to Workable data in MicroStrategy Developer using the CData Software ODBC Driver for Workable.
-
DataBind Charts to Typeform Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Typeform data 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.
-
Analyze SAP Concur Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of SAP Concur data and visualize live SAP Concur data in Infragistics Reveal.
-
Natively Connect to ServiceNow Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to ServiceNow data. Leverage the native support for ODBC in PHP.
-
Analyze XML Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of XML data and visualize live XML data in Infragistics Reveal.
-
Getting Started with the CData Connect AI Python SDK for Microsoft Planner
Install the CData Connect AI Python SDK to read and write live Microsoft Planner data with standard DB-API 2.0 Python code.
-
How to connect to Superchat Data from Spring Boot
Connect to Superchat in a Spring Boot Application using the CData API Driver for JDBC
-
Integrate with Live Google Cloud Storage Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Google Cloud Storage from the MuleSoft Anypoint Platform to integrate live Google Cloud Storage data into custom reports and dashboards.
-
How to Connect to Live Google Campaign Manager 360 Data in Mistral AI Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live Google Campaign Manager 360 data without replication.
-
Integrate with live Egnyte Data in Jitterbit
Use CData Connect AI to connect to and integrate live Egnyte data in Jitterbit.
-
DataBind Controls to Landbot Data in Delphi
DataBind to Landbot data in Delphi with standard data access components and controls.
-
How to Visualize ZohoMarketingHub 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 ZohoMarketingHub data in Python.
-
Connect to Real-Time Ontraport Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Ontraport data in Power Apps.
-
How to create Chargebee federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Chargebee data in MySQL .
-
Process & Analyze Acumatica Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Acumatica Data.
-
Integrate with SAP Fieldglass Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy SAP Fieldglass data to a JSON file on disk.
-
Connect to Microsoft Exchange in SpagoBI
Create reports featuring live Microsoft Exchange data in SpagoBI Studio. Host Microsoft Exchange reports on SpagoBI Server.
-
ETL GetResponse in Oracle Data Integrator
This article shows how to transfer GetResponse data into a data warehouse using Oracle Data Integrator.