CData Software - Knowledge Base
Recent Articles
-
Analyze Sugar CRM Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Sugar CRM from Power Pivot. You will use the Table Import Wizard to load Sugar CRM data. You can visually build the import query or use any SQL supported by the driver.
-
Access Live Typeform Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Typeform data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Extract, Transform, and Load Close Data in Informatica PowerCenter
Create a simple Workflow for Close data in Informatica PowerCenter.
-
Easily Integrate Contentful Data in Lazarus Pascal IDE
Learn how to easily integrate live Contentful data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
How to Connect to & Open Instagram Data in Microsoft Excel
This article uses the CData ODBC driver for Instagram to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Connect CircleCI to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live CircleCI data using the CData Python MCP Server.
-
Replicate eBay Data to Multiple Databases
Replicate eBay data to disparate databases with a point-and-click configuration.
-
How to Query Live Salesforce CRM Analytics Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Salesforce CRM Analytics data data in natural language using Python.
-
Connect to Microsoft Planner Data in Ruby
Connect to Microsoft Planner data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Automated Continuous Kafka Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Kafka replication to Amazon Redshift.
-
Analyze Tavily Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Tavily data in Microsoft R Open.
-
Connect to Kintone Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Kintone Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Build an OLAP Cube in SSAS from Optimizely Data
Establish a connection to Optimizely data data from SQL Server Analysis Services, and use the Optimizely Data Provider to build OLAP cubes for use in analytics and reporting.
-
Connect to PDFMonkey Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time PDFMonkey data using standard SQL.
-
Create SSAS Tabular Models from Webex Data
How to build a SQL Server Analysis Service Tabular Model from Webex data using CData drivers.
-
Connect Oracle Sales to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Oracle Sales with IBM WebSphere for seamless data integration and connectivity.
-
Create Discord-Connected Applications in Appsmith
Connect to Discord Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Discord data.
-
Connect to LeadDesk Data in HULFT Integrate
Connect to LeadDesk as a JDBC data source in HULFT Integrate
-
Connect to Google Tasks Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Google Tasks data.
-
Integrating Cursor with BenchmarkEmail 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.
-
Create Informatica Mappings From/To an ODBC Data Source for Flowlu
Create an ODBC connection to Flowlu in Informatica and browse and transfer Flowlu data.
-
A PostgreSQL Interface for Attio Data using the CData ODBC Driver
Use the SQL Gateway and Attio ODBC Driver to create a PostgreSQL entry-point for data access.
-
Build a PostgreSQL Interface for Postmark Data using the CData JDBC Driver
Use the Remoting features of the Postmark JDBC Driver to create a PostgreSQL entry-point for data access.
-
Analyze MailChimp Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze MailChimp data in Microsoft R Open.
-
Bind Live Microsoft OneDrive Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Microsoft OneDrive data and seamlessly connect and bind them to Wijmo's FlexGrid for real-time, interactive data access without manual data movement.
-
How to Connect to Live PingOne Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live PingOne data securely in real time.
-
Analyze Sybase IQ Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Sybase IQ data in Microsoft R Open.
-
View Reports on Real-Time Webflow Data in Power BI Report Server
Use the CData ODBC Driver for Webflow to visualize Webflow data in Power BI Desktop and then publish them to Power BI Report Server.
-
Getting Started with the CData Excel Add-In for Contentful
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Contentful.
-
Integrating Kiro with iContact 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.
-
Use the CData Software ODBC Driver for Freshservice in MicroStrategy
Connect to Freshservice data in MicroStrategy Developer using the CData Software ODBC Driver for Freshservice.
-
Visualize Live Google Drive Data in the Power BI Service
Use CData Connect AI to connect to live Google Drive data and create custom reports in the Power BI Service through the On-Premises Gateway.
-
LINQ to QuickBooks 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 QuickBooks Data Provider.
-
Natively Connect to Parquet Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Parquet data. Leverage the native support for ODBC in PHP.
-
Use the CData Software ODBC Driver for Jumpseller in MicroStrategy
Connect to Jumpseller data in MicroStrategy Developer using the CData Software ODBC Driver for Jumpseller.
-
Enable the Oracle Sales JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Oracle Sales data.
-
Provide OData Services of Gorgias Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Gorgias data by developing a WCF Service Application.
-
How to Build an ETL App for OData Services in Python with CData
Create ETL applications and real-time data pipelines for OData services in Python with petl.
-
Integrate Bannerbear Data in the Pentaho Report Designer
Publish reports based on Bannerbear data in the Pentaho BI tool.
-
How to Access Live Timely Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Timely enables you to integrate Timely data into workflows built using Microsoft Power Automate Desktop.
-
Automated Continuous Kintone Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Kintone replication to Amazon Redshift.
-
Visualize Amazon S3 Data in Tableau
The CData ODBC driver for Amazon S3 enables you integrate Amazon S3 data into Tableau dashboards.
-
Automated Continuous Facebook Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Facebook replication to AlloyDB.
-
How to Connect to BigCommerce Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to BigCommerce data. Leverage the pyodbc module for ODBC in Python.
-
Bridge Discord Connectivity with Apache NiFi
Access and process Discord data in Apache NiFi using the CData JDBC Driver.
-
Query BambooHR Data as a SQL Server Database in Node.js
Execute SQL Server queries against BambooHR data from Node.js.
-
Integrating Codex with GraphQL 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.
-
How to Connect to Live FHIR 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 FHIR data for you.
-
Automated Continuous OpenWeatherMap Replication to IBM DB2
Use CData Sync for automated, continuous, customizable OpenWeatherMap replication to IBM DB2.
-
Visualize Live Monday.com Data in the Power BI Service
Use CData Connect AI to connect to live Monday.com data and create custom reports in the Power BI Service through the On-Premises Gateway.
-
How to create Apify federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Apify data in MySQL .
-
Build Dashboards with Toggl Data in DBxtra
Create dynamic dashboards and perform analytics based on Toggl data in DBxtra.
-
GetResponse Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on GetResponse facts in real time.
-
Build ADP-Connected Apps in Choreo
Use CData Connect AI to connect to ADP Data from Choreo and build custom apps using live ADP data.
-
Integrate Vercel Data in the Pentaho Report Designer
Publish reports based on Vercel data in the Pentaho BI tool.
-
Import Real-Time Asana Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Asana data in ColdFusion.
-
Getting Started with the CData ADO.NET Provider for Authorize.Net
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Authorize.Net.
-
Write a Simple Go Application to work with ShipEngine Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to ShipEngine data.
-
How to connect to Google Campaign Manager 360 Data from IntelliJ
Integrate connectivity to Google Campaign Manager 360 data with wizards in IntelliJ.
-
Getting Started with the CData Python Connector for Omnisend
Learn to install and license the CData Python Connector and configure a connection to live Omnisend data.
-
How to Connect the Power BI Service to Planio: Complete Guide
Connect to the CData Software Power BI Connector for Planio from PowerBI.com to provide real-time Planio data across the organization.
-
Build Data Flows from Instagram to SQL Server using SSIS
Easily back up Instagram data to SQL Server using the SSIS components for Instagram.
-
Connect to Eventbrite Data in Jaspersoft Studio
Execute SQL to remote Eventbrite data in Jaspersoft Studio.
-
Create Reports with eBay Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date eBay data.
-
LINQ to Discord 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 Discord Data Provider.
-
How to Easily Query HCL Domino Data in OpenOffice Base
Connect to HCL Domino data in OpenOffice Base using the CData ODBC Driver for HCL Domino and generate reports with live data insights.
-
Use the CData Software ODBC Driver for Bright Data in MicroStrategy
Connect to Bright Data data in MicroStrategy Developer using the CData Software ODBC Driver for Bright Data.
-
Use Databricks Agent Bricks to Talk to Your Azure Data Catalog Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Azure Data Catalog data for you.
-
Build Semantic Layer Views for Square Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Square data.
-
How to Query Live Parquet Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Parquet data data in natural language using Python.
-
How to Work with HBase Data in AWS Glue Jobs Using JDBC
Connect to HBase from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Create Exa-Connected Business Apps in AppSheet
Connect to Exa Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Exa data.
-
Automated Continuous GitLab Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable GitLab replication to Amazon Redshift.
-
Build Dashboards with GitLab Data in DBxtra
Create dynamic dashboards and perform analytics based on GitLab data in DBxtra.
-
Integrating Claude Code CLI with Optimizely 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 Missive to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Missive with IBM WebSphere for seamless data integration and connectivity.
-
Analyze Avro Data in Looker
Use CData Connect AI to connect to Avro Data from Looker and build custom apps using live Avro data.
-
Analyze ActiveCampaign Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of ActiveCampaign data and visualize live ActiveCampaign data in Infragistics Reveal.
-
Connect to Shopify in SpagoBI
Create reports featuring live Shopify data in SpagoBI Studio. Host Shopify reports on SpagoBI Server.
-
How to Connect to Live Presto Data from Google ADK Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Google ADK agents to securely read and take actions on your Presto data for you.
-
How to integrate SAP Hybris C4C with Apache Airflow
Access and process SAP Hybris C4C data in Apache Airflow using the CData JDBC Driver.
-
Connect to Salesforce CRM Analytics Data in NetBeans
Connect to Salesforce CRM Analytics data in NetBeans with the data source configuration wizard.
-
Integrate Quickbase Data into Power Automate Desktop using CData Connect
CData Connect for Quickbase Data enables you to integrate Quickbase data into workflows built using Microsoft Power Automate Desktop.
-
Integrate Live HDFS Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to HDFS from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live HDFS data.
-
Use the CData Software JDBC Driver for Freshsales in MicroStrategy Desktop
Connect to Freshsales data in MicroStrategy Desktop using the CData Software JDBC Driver for Freshsales.
-
Viewing Foursquare Data in RAD Studio Data Explorer
How to view Foursquare data in RAD Studio Data Explorer using the CData ODBC Driver for Foursquare.
-
Connect to Browserless Data in RazorSQL
Connect to Browserless from wizards and query Browserless data from the GUI in the RazorSQL database management tool.
-
Use Manus AI to Talk to Your Google Drive Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Manus AI agents to securely answer questions and take actions on Google Drive data.
-
Build Semantic Layer Views for PhantomBuster Data in APOS Live Data Gateway
Use the CData Connector for PhantomBuster in APOS Live Data Gateway to build Semantic Layer Views for PhantomBuster data.
-
Connect to Google Calendar Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Google Calendar Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Analyze SingleStore Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of SingleStore data and visualize live SingleStore data in Infragistics Reveal.
-
Integrating Kiro with SAP Ariba Procurement 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.
-
Use Dash to Build Web Apps on Mailgun Data via CData Connect AI
Build interactive Dash web apps on live Mailgun data using pandas and the CData Connect AI Python SDK.
-
Integrate Devin with Live Mailjet Data Using CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Devin, the AI software engineer, to securely access and query live Mailjet data.
-
Use Dash to Build to Web Apps on HDFS Data
Create Python applications that use pandas and Dash to build HDFS-connected web apps.
-
Automated Continuous Unbounce Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Unbounce replication to Google Cloud SQL.
-
Use CData Connect AI to Access Klipfolio Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Klipfolio data in the Power Pivot business intelligence tool.
-
Automate Exact Online Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Exact Online data from PowerShell? This article demonstrates how to utilize the Exact Online Cmdlets for tasks like connecting to Exact Online data, automating operations, downloading data, and more.
-
Build MVC Applications with Connectivity to Retently Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Retently from an ASP.NET MVC application.
-
Process & Analyze Facebook Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Facebook Data.