CData Software - Knowledge Base
Recent Articles
-
Create Datasets from Microsoft Ads in Domo Workbench and Build Visualizations of Microsoft Ads Data in Domo
Use the CData Software ODBC Driver for Microsoft Ads to create datasets from Microsoft Ads data in Domo Workbench and then build visualizations in the Domo service.
-
How to connect to Greenplum Data from IntelliJ
Integrate connectivity to Greenplum data with wizards in IntelliJ.
-
How to integrate Microsoft Ads with Apache Airflow
Access and process Microsoft Ads data in Apache Airflow using the CData JDBC Driver.
-
How to load Acumatica data into Elasticsearch via Logstash
Introducing a simple method to load Acumatica data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Integrate Cursor with Live Salesforce Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Salesforce data from within the editor.
-
Visualize HubDB Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to HubDB data.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Azure Data Catalog
Provide connectivity to Azure Data Catalog data through an SAP BusinessObjects universe.
-
Connect Bright Data to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Bright Data data using the CData Python MCP Server.
-
DataBind Mailjet Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Mailjet data to a chart.
-
Integrate ServiceNow Data in Pentaho Data Integration
Build ETL pipelines based on ServiceNow data in the Pentaho Data Integration tool.
-
Integrate Devin with Live Optimizely 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 Optimizely data.
-
Connect and Query Live Egnyte Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Egnyte data into Databricks and enable direct, live querying and analysis without replication.
-
Automated Continuous Pingdom Replication to Oracle
Use CData Sync for automated, continuous, customizable Pingdom replication to Oracle.
-
Integrate with live Okta Data in Jitterbit
Use CData Connect AI to connect to and integrate live Okta data in Jitterbit.
-
Connect SAP Business One to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live SAP Business One data using the CData Python MCP Server.
-
Consume Azure Table OData Feeds in PowerBuilder
This article demonstrates how to consume Azure Table data as OData feeds from PowerBuilder using the API Server.
-
Analyze ZohoExpense Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of ZohoExpense data and visualize ZohoExpense data in SAP Analytics Cloud.
-
Add Reckon Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Reckon with the Informatica Enterprise Data Catalog to classify and organize data.
-
Getting Started with the CData ADO.NET Provider for Sentry
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Connect SAS Data Sets to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect SAS Data Sets with IBM WebSphere for seamless data integration and connectivity.
-
Automated Continuous Scrapfly Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Scrapfly replication to Amazon S3.
-
Connect to Live Spark Data in MicroStrategy through CData Connect AI
Create a live connection to Spark Data in CData Connect AI and connect to your Spark data from MicroStrategy.
-
Use the CData ODBC Driver for Adobe Target in Microsoft Power Query
You can use the CData Adobe Target ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Adobe Target data into Microsoft Power Query.
-
Publish Quaderno-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Quaderno data.
-
Working with Azure DevOps Data in LINQPad
Execute LINQ queries to Azure DevOps data in LINQPad.
-
Connect to Live Campaigner Data in MicroStrategy through CData Connect AI
Create a live connection to Campaigner Data in CData Connect AI and connect to your Campaigner data from MicroStrategy.
-
How to Seamlessly Import Cosmos DB Data into IBM SPSS Modeler
Integrate Cosmos DB data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Consume Facebook OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Facebook feeds that reflect any changes in SAP Lumira.
-
How to connect PolyBase to Wave Financial
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Wave Financial data.
-
Connect to Elasticsearch Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Elasticsearch data in the Denodo Virtual DataPort Administrator.
-
Automated Continuous Impala Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Impala replication to Azure SQL Database.
-
Automated Continuous Basecamp Replication to MongoDB
Use CData Sync for automated, continuous, customizable Basecamp replication to MongoDB.
-
WooCommerce Reporting in OBIEE with the WooCommerce JDBC Driver
Deploy the WooCommerce JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Connect to FreeAgent Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for FreeAgent data in the Denodo Virtual DataPort Administrator.
-
Automated Continuous GraphQL Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable GraphQL replication to Amazon Redshift.
-
Connect to Cvent Data in RazorSQL
Connect to Cvent from wizards and query Cvent data from the GUI in the RazorSQL database management tool.
-
Import Real-Time Vimeo Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Vimeo data in ColdFusion.
-
How to Visualize Teradata Data in Python with pandas
Use pandas and other modules to analyze and visualize live Teradata data in Python.
-
Create SSAS Tabular Models from Cassandra Data
How to build a SQL Server Analysis Service Tabular Model from Cassandra data using CData drivers.
-
Integrating Gumloop with Cosmos DB Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Cosmos DB data within automated workflows.
-
Analyze Zuora Data in Cognos Analytics
Use CData Connect AI to connect to Zuora Data from Cognos Analytics and analyze live Zuora data.
-
Integrate Devin with Live Supabase 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 Supabase data.
-
Work with GitHub Data in FoxPro
Load GitHub data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Automated Continuous iContact Replication to SQL Server
Use CData Sync for automated, continuous, customizable iContact replication to SQL Server.
-
Connect to Monday.com Data in Google Apps Script via Connect AI
Use CData Connect AI to access Monday.com data in Google Apps Script.
-
Connect to Helpscout Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to Helpscout.
-
Getting Started with the CData Power BI Connector for Teamwork
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Edit and Search External CockroachDB Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of CockroachDB data to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create CockroachDB Data objects that you can access from apps and the dashboard.
-
How to create an RPA flow for Vercel Data in UiPath Studio
Use the Vercel ODBC Driver to create workflows that access real-time Vercel data without any coding.
-
Create Informatica Mappings From/To a JDBC Data Source for Gorgias
Create Gorgias data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Manage Authorize.Net Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Authorize.Net.
-
How to Deploy Cross-Platform CData Sync to IIS
Deploying Cross-Platform CData Sync to Microsoft Internet Information Services (IIS) and setting up IIS as a reverse proxy for CData Sync.
-
Visualize Printify Data in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load Printify data into TIBCO Spotfire.
-
Integrating Codex with SingleStore 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.
-
Integrate Live DocuSign Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to DocuSign data and integrate live DocuSign data into apps built in Microsoft Power Apps.
-
Getting Started with the CData Power BI Connector for EmailOctopus
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Connect to Oracle SCM Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Oracle SCM data using standard SQL.
-
Automated Continuous Google Directory Replication to SingleStore
Use CData Sync for automated, continuous, customizable Google Directory replication to SingleStore.
-
Visualize Act-On Data in TIBCO Spotfire through ADO.NET
Integrate Act-On data into dashboards in TIBCO Spotfire.
-
Connect to Real-Time Teamwork Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Teamwork data in Power Apps.
-
Use Databricks Agent Bricks to Talk to Your Amazon Marketplace Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Amazon Marketplace data for you.
-
Replicate Multiple Outlook Accounts
Replicate multiple Outlook accounts to one or many databases.
-
How to Create Power BI Visual Reports with Real-Time Amplitude Data
Use CData Power BI Connectors to visualize Amplitude data in Power BI.
-
Create Informatica Mappings From/To a JDBC Data Source for Jira
Create Jira data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Manage MySQL Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for MySQL.
-
Use the CData Software ODBC Driver for Autopilot in MicroStrategy Web
Connect to Autopilot data in MicroStrategy Web using the CData Software ODBC Driver for Autopilot.
-
Design BIRT Reports on Outreach.io Data
Provide current Outreach.io data to your embedded analytics.
-
Create SendPulse-Connected Applications in Appsmith
Connect to SendPulse Data via CData Connect AI in Appsmith and create custom business applications with real-time access to SendPulse data.
-
How to Connect to Live MariaDB 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 MariaDB data for you.
-
Add QuickBooks Online Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for QuickBooks Online with the Informatica Enterprise Data Catalog to classify and organize data.
-
Automated Continuous Close Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Close replication to Amazon Redshift.
-
Connect to Hive Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Hive data.
-
Replicate Avalara AvaTax Data from PowerShell
Write a quick PowerShell script to query Avalara AvaTax data. Use connectivity to the live data to replicate Avalara AvaTax data to SQL Server.
-
How to Build an ETL App for Klaviyo Data in Python with CData
Create ETL applications and real-time data pipelines for Klaviyo data in Python with petl.
-
How to connect and process Bullhorn CRM data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Bullhorn CRM data.
-
Build MVC Applications with Connectivity to Calendly Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Calendly from an ASP.NET MVC application.
-
Getting Started with the CData Tableau Connector for EnterpriseDB
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for EnterpriseDB.
-
Validate Excel Online Data with QuerySurge
Access and validate Excel Online data in QuerySurge using the CData JDBC Driver.
-
Creating GraphQL-Connected Applications in Unqork
You can use CData Connect AI to feed GraphQL data to Unqork and build custom business apps.
-
Create ServiceNow-Connected Dashboards in Grafana
Connect to ServiceNow Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to ServiceNow data.
-
How to update SharePoint from Excel
This article explains how to transfer data from Excel to SharePoint using the Excel Add-In for SharePoint.
-
Connect to Superchat Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Superchat and the SQL Gateway to access Superchat data from Google Apps Script.
-
Build Semantic Layer Views for Freshservice Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Freshservice data.
-
Automated Continuous Toggl Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Toggl replication to Amazon S3.
-
Access Live JobNimbus Data in AWS Lambda
Connect to live JobNimbus data in AWS Lambda using the CData JDBC Driver.
-
Use the CData Software JDBC Driver for Dynamics NAV in MicroStrategy
Connect to Dynamics NAV data in MicroStrategy Developer using the CData Software JDBC Driver for Dynamics NAV.
-
Extract, Transform, and Load Apollo Data in Informatica PowerCenter
Create a simple Workflow for Apollo data in Informatica PowerCenter.
-
Getting Started with the CData Power BI Connector for Attio
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
How to load HubSpot data into Elasticsearch via Logstash
Introducing a simple method to load HubSpot data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Use the CData Software JDBC Driver for BenchmarkEmail in MicroStrategy Desktop
Connect to BenchmarkEmail data in MicroStrategy Desktop using the CData Software JDBC Driver for BenchmarkEmail.
-
How to connect to ZohoSubscriptions Data in DBVisualizer
Integrate ZohoSubscriptions data with visual data analysis tools and data connection wizards in DBVisualizer
-
How to connect PolyBase to Stack Exchange
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Stack Exchange data.
-
Connect to Azure Analysis Services Data in Aqua Data Studio
Access Azure Analysis Services data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Create Data Visualizations Based On Facebook Ads Data in Mode
Use CData Connect AI to connect to Facebook Ads Data from Mode and build visualizations using live Facebook Ads data.
-
Access Live Cassandra Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Cassandra data from your Google Sheets.
-
Connect to Act CRM from a Connection Pool in WebLogic
Use the CData JDBC Driver for Act CRM to connect to Act CRM data from Web applications running on WebLogic.
-
Build Figshare-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Figshare Data and create custom apps in Mendix.
-
Use the CData SSIS Components to Insert New or Update Existing Zoho Projects Records from SQL Server
Easily push SQL Server data to Zoho Projects using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Zoho Projects or update existing records with data from a SQL Server database.
-
How to Visualize Impala Data in Python with pandas
Use pandas and other modules to analyze and visualize live Impala data in Python.
-
Integrate NASA with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate NASA with External Services.