CData Software - Knowledge Base
Recent Articles
-
Import GitLab Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to GitLab Data and provide access to live GitLab data for custom reports in the Power BI Service.
-
Integrating Codex with Simplesat 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.
-
Natively Connect to LinkedIn Ads Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to LinkedIn Ads data. Leverage the native support for ODBC in PHP.
-
Working with Microsoft Teams Data in LINQPad
Execute LINQ queries to Microsoft Teams data in LINQPad.
-
Natively Connect to Clari Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Clari data. Leverage the native support for ODBC in PHP.
-
Explore Geographical Relationships in Basecamp Data with Power Map
Create data visualizations with Basecamp data in Power Map.
-
View Reports on Real-Time Sage Cloud Accounting Data in Power BI Report Server
Use the CData ODBC Driver for Sage Cloud Accounting to visualize Sage Cloud Accounting data in Power BI Desktop and then publish them to Power BI Report Server.
-
Visualize Live Aircall Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Aircall data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Getting Started with the CData Power BI Connector for BenchmarkEmail
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Connect to LeadDesk Data as an External Source in Dremio
Use the CData JDBC Driver to connect to LeadDesk as an External Source in Dremio.
-
Build MVC Applications with Connectivity to Coinbase Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Coinbase from an ASP.NET MVC application.
-
Establish a Live Connection with JotForm Data using Tableau Bridge
The CData ODBC Driver for JotForm enables you to integrate live JotForm data into Tableau Cloud dashboards using the Tableau Bridge.
-
Visualize Miro Data in TIBCO Spotfire through ADO.NET
Integrate Miro data into dashboards in TIBCO Spotfire.
-
How to Connect to Highrise Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Highrise data. Leverage the pyodbc module for ODBC in Python.
-
Integrate Open WebUI with Live SAP Business Warehouse Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live SAP Business Warehouse data from within the chat interface.
-
Build an OLAP Cube in SSAS from GetResponse Data
Establish a connection to GetResponse data data from SQL Server Analysis Services, and use the GetResponse Data Provider to build OLAP cubes for use in analytics and reporting.
-
Automated Continuous Oracle Eloqua Reporting Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Oracle Eloqua Reporting replication to delimited files (CSV/TSV).
-
Query Samanage Data in DataGrip
Create a Data Source for Samanage in DataGrip and use SQL to query live Samanage data.
-
Use Biml to Build SSIS Tasks to Replicate Cohere Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Cohere data to SQL Server.
-
Natively Connect to Drip Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Drip data. Leverage the native support for ODBC in PHP.
-
Visualize Twitter Ads Data in Sisense
Create an ElastiCube in Sisense app with access to Twitter Ads data.
-
Create Dashboards and Visualize Live Microsoft Dataverse Data in Geckoboard
Use CData Connect AI to connect to live Microsoft Dataverse data and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Integrate LibreChat with Live Vertica Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Vertica data from within the chat interface.
-
Access Live Snapchat Ads Data in Emergent via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Emergent agents to securely access and build applications with live Snapchat Ads data through MCP integration.
-
Rapidly Develop SQL Analysis Services-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 SQL Analysis Services.
-
Build a Singer.io Tap for SurveyMonkey With the CData Python Connector
Learn how to easily build a Singer.io Tap for live SurveyMonkey data using the CData Python Connector.
-
How to Visualize SharePoint Excel Services Data in Python with pandas
Use pandas and other modules to analyze and visualize live SharePoint Excel Services data in Python.
-
Create Datasets from Facebook Ads in Domo Workbench and Build Visualizations of Facebook Ads Data in Domo
Use the CData Software ODBC Driver for Facebook Ads to create datasets from Facebook Ads data in Domo Workbench and then build visualizations in the Domo service.
-
How to connect to Parquet Data from Spring Boot
Connect to Parquet in a Spring Boot Application using the CData JDBC Driver for Parquet
-
Import and Visualize Paylocity Data in Power View
Create data visualizations based on Paylocity data in Excel.
-
Build Semantic Layer Views for Sendwithus Data in APOS Live Data Gateway
Use the CData Connector for Sendwithus in APOS Live Data Gateway to build Semantic Layer Views for Sendwithus data.
-
Automated Continuous Presto Replication to MongoDB
Use CData Sync for automated, continuous, customizable Presto replication to MongoDB.
-
Access Live Deel Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Deel data into the statistical analysis tools available in SAS JMP. This article shows how to use Deel data in the Graph Builder and Query Builder.
-
Query LaunchDarkly Data as a MySQL Database in Node.js
Execute MySQL queries against LaunchDarkly data from Node.js.
-
Visualize OData Services in TIBCO Spotfire through ADO.NET
Integrate OData services into dashboards in TIBCO Spotfire.
-
Access Live LeadDesk Data in AWS Lambda
Connect to live LeadDesk data in AWS Lambda using the CData JDBC Driver.
-
Access Campaigner Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Campaigner data from HeidiSQL.
-
Back Up Avalara AvaTax data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Avalara AvaTax. In this article, we will employ an SSIS workflow to populate a database with Avalara AvaTax data data.
-
Connect to PagerDuty Data in JRuby
Create a simple JRuby app with access to live PagerDuty data.
-
Automated Continuous Trello Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Trello replication to delimited files (CSV/TSV).
-
Build Agents in Relevance AI with Access to Live Azure Data Lake Storage Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Azure Data Lake Storage data within intelligent agent workflows.
-
Connecting Mastra with Snowflake Data 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 Snowflake data, no replication required.
-
Replicate FreeAgent Data from PowerShell
Write a quick PowerShell script to query FreeAgent data. Use connectivity to the live data to replicate FreeAgent data to SQL Server.
-
Use the CData Software JDBC Driver for Coda in MicroStrategy Web
Connect to Coda data in MicroStrategy Web using the CData Software JDBC Driver for Coda.
-
How to Connect Salesforce CRM Analytics 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 Salesforce CRM Analytics data in real time using natural language.
-
Integrate HelloSign Data in the Pentaho Report Designer
Publish reports based on HelloSign data in the Pentaho BI tool.
-
Build an OLAP Cube in SSAS from Invoiced Data
Establish a connection to Invoiced data data from SQL Server Analysis Services, and use the Invoiced Data Provider to build OLAP cubes for use in analytics and reporting.
-
How to Connect FTP 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 FTP data in real time using natural language.
-
Integrate Sage 200 Data into Power Automate Desktop using CData Connect
CData Connect for Sage 200 Data enables you to integrate Sage 200 data into workflows built using Microsoft Power Automate Desktop.
-
Automated Continuous Pushbullet Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Pushbullet replication to PostgreSQL.
-
Creating Teradata-Connected Applications in Unqork
You can use CData Connect AI to feed Teradata data to Unqork and build custom business apps.
-
Automate ClickTime Data Replication to Azure Data Lake
Use CData Sync to customize and automate ClickTime data replication to Azure Data Lake.
-
Visualize Impala Data in TIBCO Spotfire through OData
Integrate Impala data into dashboards in TIBCO Spotfire.
-
How to import Harvest Data into Apache Solr
Use the CData Software JDBC Driver for Harvest in Data Import Handler and create an automated import of Harvest data to Apache Solr Enterprise Search platform.
-
Import and Visualize Perplexity Data in Power View
Create data visualizations based on Perplexity data in Excel.
-
How to Connect to Live iContact 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 iContact data for you.
-
Migrating data from Vercel to Snowflake using CData SSIS Components.
Easily push Vercel data to Snowflake using the CData SSIS Tasks for Vercel and Snowflake.
-
Provide OData Services of CSV Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for CSV data by developing a WCF Service Application.
-
Build MVC Applications with Connectivity to Salesforce Data 360 Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Salesforce Data 360 from an ASP.NET MVC application.
-
Visualize Live Google Spanner Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Google Spanner data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Model Phoenix Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Phoenix, enabling the direct import of real-time Phoenix data.
-
How to Connect to & Open Tanda Data in Microsoft Excel
This article uses the CData ODBC driver for Tanda to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Connect to Exact Online Data in RapidMiner
Integrate Exact Online data with standard components and data source configuration wizards in RapidMiner Studio.
-
Trigger LinkedIn IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for LinkedIn with standard wizards in Logic Apps.
-
Connect to ElevenLabs Data from a Connection Pool in JBoss
Integrate ElevenLabs data into Java servlets: Use the Management Console in JBoss to install the ElevenLabs JDBC Driver.
-
Add Parquet Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Parquet with the Informatica Enterprise Data Catalog to classify and organize data.
-
Integrating Cursor with Egnyte 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.
-
Build Agents in Relevance AI with Access to Live SendGrid Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on SendGrid data within intelligent agent workflows.
-
Import Real-Time Adobe Analytics Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Adobe Analytics data in ColdFusion.
-
How to Visualize GetResponse Data in Python with pandas
Use pandas and other modules to analyze and visualize live GetResponse data in Python.
-
Use the CData ODBC Driver for HDFS in Microsoft Power Query
You can use the CData HDFS ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import HDFS data into Microsoft Power Query.
-
Connect to AlloyDB Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for AlloyDB data in Airbyte.
-
Integrate MariaDB Data in the Pentaho Report Designer
Publish reports based on MariaDB data in the Pentaho BI tool.
-
How to Connect the Power BI Service to Monday.com: Complete Guide
Connect to the CData Software Power BI Connector for Monday.com from PowerBI.com to provide real-time Monday.com data across the organization.
-
Connect to ZendeskSell Data in JRuby
Create a simple JRuby app with access to live ZendeskSell data.
-
Getting Started with the CData JDBC Driver for Instagram
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Instagram.
-
Manage eBay Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for eBay.
-
Prepare, Blend, and Analyze MessageBird Data in Alteryx Designer (ODBC)
Build workflows to access live MessageBird data for self-service data analytics.
-
Visualize SAP HANA XS Advanced Data in Sisense
Create an ElastiCube in Sisense app with access to SAP HANA XS Advanced data.
-
How to Connect to Live Sybase Data 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 Sybase data for you.
-
How to Connect DBeaver to Instagram via a JDBC Driver
Manage Instagram data with visual tools in DBeaver like the query browser.
-
Automated Continuous Campaigner Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Campaigner replication to Amazon Redshift.
-
Manage Flowlu Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Flowlu.
-
Natively Connect to AfterShip Data in PHP
The CData ODBC driver for AfterShip enables you to create PHP applications with connectivity to AfterShip data. Leverage the native support for ODBC in PHP.
-
Use the CData ODBC Driver for ServiceDesk Plus from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for ServiceDesk Plus to connect to ServiceDesk Plus data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring ServiceDesk Plus data in Excel.
-
Replicate Pipeline CRM Data to Multiple Databases via the CData Sync CLI
Replicate Pipeline CRM data to disparate databases with a single configuration.
-
How to Work with Everhour Data in AWS Glue Jobs Using JDBC
Connect to Everhour from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Access Live SAP HANA Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live SAP HANA data from your Google Sheets.
-
Integrate ZohoExpense Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live ZohoExpense data from Informatica Cloud.
-
Build Webex-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Webex data and build web apps with connectivity to live Webex data.
-
Automated Continuous Aircall Replication to MySQL
Use CData Sync for automated, continuous, customizable Aircall replication to MySQL.
-
Connect to SAP ByDesign Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for SAP ByDesign Data and connect to SAP ByDesign data in Akorbi Digital RunMyProcess.
-
Back Up Zuora data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Zuora. In this article, we will employ an SSIS workflow to populate a database with Zuora data data.
-
Back Up Telegram data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData API Driver for ADO.NET. In this article, we will employ an SSIS workflow to populate a database with Telegram data data.
-
Connect to OData Services as an External Data Source using PolyBase
Use CData Connect AI and PolyBase to create an external data source in SQL Swerver with access to live OData services.
-
Replicate SendGrid Data from PowerShell
Write a quick PowerShell script to query SendGrid data. Use connectivity to the live data to replicate SendGrid data to SQL Server.
-
How to work with Demio Data in Apache Spark using SQL
Access and process Demio Data in Apache Spark using the CData Software JDBC Driver.
-
Connect to Azure Data Lake Storage Data in Aqua Data Studio
Access Azure Data Lake Storage data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
How to Connect to & Open Keap Data in Microsoft Excel
This article uses the CData ODBC driver for Keap to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Connect to Google Spanner Data in Claris FileMaker Pro
Use the CData ODBC Driver for Google Spanner in FileMaker Pro to connect to Google Spanner and work with Google Spanner data in your FileMaker applications.