CData Software - Knowledge Base
Recent Articles
-
Create Datasets from Mocean in Domo Workbench and Build Visualizations of Mocean Data in Domo
Use the CData Software ODBC Driver for Mocean to create datasets from Mocean data in Domo Workbench and then build visualizations in the Domo service.
-
How to load LinkedIn data into Elasticsearch via Logstash
Introducing a simple method to load LinkedIn data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Integrate with SingleStore Data in JReport Designer
Create charts and reports based on SingleStore data in JReport Designer.
-
Connect to Pipeline CRM Data in Aqua Data Studio
Access Pipeline CRM data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Explore Geographical Relationships in Hugging Face Data with Power Map
Create data visualizations with Hugging Face data in Power Map.
-
Back Up eBay Analytics data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for eBay Analytics. In this article, we will employ an SSIS workflow to populate a database with eBay Analytics data data.
-
Creating Bitly-Connected Applications in Unqork
You can use CData Connect AI to feed Bitly data to Unqork and build custom business apps.
-
Operational Reporting on Cassandra Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Cassandra data.
-
Build Amazon DynamoDB-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Amazon DynamoDB Data and create custom apps in Mendix.
-
How to Connect to Live SAP SuccessFactors Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live SAP SuccessFactors data securely in real time.
-
Model SAP ByDesign Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and SAP ByDesign, enabling the direct import of real-time SAP ByDesign data.
-
Integrate Humanity with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Humanity with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Humanity data.
-
Integrating Claude Code with Authorize.Net Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Authorize.Net data within assisted coding and automated development workflows.
-
View Reports on Real-Time ShipStation Data in Power BI Report Server
Use the CData ODBC Driver for ShipStation to visualize ShipStation data in Power BI Desktop and then publish them to Power BI Report Server.
-
Access Live Vercel Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Vercel data into the statistical analysis tools available in SAS JMP. This article shows how to use Vercel data in the Graph Builder and Query Builder.
-
Automated Continuous Accelo Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Accelo replication to delimited files (CSV/TSV).
-
Integrate Devin with Live Sage 200 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 Sage 200 data.
-
Access Eventbrite Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Eventbrite data from HeidiSQL.
-
Replicate Freshservice Data from PowerShell
Write a quick PowerShell script to query Freshservice data. Use connectivity to the live data to replicate Freshservice data to SQL Server.
-
Build Automated AgileCRM-Connected Workflows in Zapier
Use CData Connect AI to connect to live AgileCRM data and build automated workflows in Zapier.
-
Manage FHIR Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for FHIR.
-
Use Manus AI to Talk to Your Confluence 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 Confluence data.
-
Replicate Authorize.Net Data from PowerShell
Write a quick PowerShell script to query Authorize.Net data. Use connectivity to the live data to replicate Authorize.Net data to SQL Server.
-
Connect to Real-Time RabbitMQ Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use RabbitMQ data in Power Apps.
-
Build a PostgreSQL Interface for Azure Table Data using the CData JDBC Driver
Use the Remoting features of the Azure Table JDBC Driver to create a PostgreSQL entry-point for data access.
-
Building Dynamic Web Pages with Zoho Inventory Data Using AngularJS
Create single-page applications with live connectivity to Zoho Inventory using the CData API Server.
-
Automate Freshservice Data Replication to Azure Synapse
Use CData Sync to customize and automate Freshservice data replication to Azure Synapse.
-
Integrating LangGraph with Amazon Athena Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Amazon Athena data within automated workflows.
-
Connect to Azure Analysis Services Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Azure Analysis Services data from Filemaker Pro on Mac.
-
Create Data Visualizations in Cognos BI with Nethunt Data
Access Nethunt data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
How to Work with Close Data in ETL Validator JDBC
Connect to Close from ETL Validator jobs using the CData Software JDBC Driver.
-
Integrate Google Forms with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Google Forms with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Google Forms data.
-
Connect to SendGrid Data 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 SendGrid data.
-
Use the CData ODBC Driver for Aha! in Microsoft Power Query
You can use the CData Aha! ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Aha! data into Microsoft Power Query.
-
Create Data Visualizations in Cognos BI with Clio Data
Access Clio data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Integrating Codex with Hive 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.
-
Automated Continuous Strava Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Strava replication to Apache Cassandra.
-
Automated Continuous XML Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable XML replication to Amazon Redshift.
-
Excel Spreadsheet Automation on Oracle Data with the QUERY Formula
Pull data from Oracle, automate spreadsheets, and more with the QUERY formula.
-
Automated Continuous Retently Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Retently replication to Apache Kafka.
-
Choosing the Best Method to Connect Tanda to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Tanda data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Integrating GitHub Copilot with DocuSign 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 work with Chargebee Data in Apache Spark using SQL
Access and process Chargebee Data in Apache Spark using the CData Software JDBC Driver.
-
Operational Reporting on ClickUp Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote ClickUp data.
-
Connect to Mouseflow Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Mouseflow as an External Source in Dremio.
-
Use JayDeBeApi to access Basecamp Data in Python
Use standard Python scripting and the development environment of your choice to access live Basecamp data.
-
Connect to Factorial Data in DBeaver
Use the CData ODBC Driver to connect to Factorial data in DBeaver.
-
Design BIRT Reports on Wave Financial Data
Provide current Wave Financial data to your embedded analytics.
-
Automated Continuous Notion Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Notion replication to Amazon Redshift.
-
Connect to Dynamics NAV Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to Dynamics NAV.
-
Connect and Visualize Live HubSpot Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live HubSpot data into the Databricks platform and create visualization dashboards with real-time HubSpot data.
-
Connecting Moonlit Workflow with Greenplum Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Moonlit workflows to securely read and act on your Greenplum data in real time.
-
How to Connect DBeaver to CampaignMonitor via a JDBC Driver
Manage CampaignMonitor data with visual tools in DBeaver like the query browser.
-
Use Manus AI to Talk to Your Azure Table 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 Azure Table data.
-
Automated Zoho Books Data Replication to Teradata
Use CData Sync to Customize and automate Zoho Books data replication to Teradata.
-
How to Connect LinkedIn Ads 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 LinkedIn Ads data in real time using natural language.
-
Create Data Visualizations in Cognos BI with Box Data
Access Box data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Write a Simple Go Application to work with Microsoft Teams Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Microsoft Teams data.
-
Integrate Devin with Live Monday.com 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 Monday.com data.
-
Use Biml to Build SSIS Tasks to Replicate Google Ad Manager Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Google Ad Manager data to SQL Server.
-
Integrate Cline with Live Klipfolio Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Klipfolio data from within your IDE.
-
Automated Continuous Unbounce Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Unbounce replication to PostgreSQL.
-
Getting Started with the CData JDBC Driver for Auth0
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Auth0.
-
Create QuickBooks Time-Connected Applications in Appsmith
Connect to QuickBooks Time Data via CData Connect AI in Appsmith and create custom business applications with real-time access to QuickBooks Time data.
-
Access Live Marketo Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Marketo data from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Connect to Microsoft Ads Data in DBArtisan
Use wizards in DBArtisan to configure Microsoft Ads data as a data source.
-
Publish Teamwork-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Teamwork data.
-
How to create Clio federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Clio data in MySQL .
-
LINQ to JobNimbus 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 JobNimbus Data Provider.
-
Automate Telegram Data Replication to Couchbase
Use CData Sync to Customize and automate Telegram data replication to Couchbase.
-
Build Charts with Everhour Data in Clear Analytics
Create dynamic charts and perform analytics based on Everhour data in Clear Analytics.
-
How to Connect the Power BI Service to Figshare: Complete Guide
Connect to the CData Software Power BI Connector for Figshare from PowerBI.com to provide real-time Figshare data across the organization.
-
Google Directory Reporting in OBIEE with the Google Directory JDBC Driver
Deploy the Google Directory JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Visualize Adobe Experience Manager Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Adobe Experience Manager data.
-
Integrate Cline with Live Mailgun Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Mailgun data from within your IDE.
-
Access Live Tavily 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 Tavily data through MCP integration.
-
Publish PayPal-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live PayPal data.
-
Search External SAP ByDesign Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of SAP ByDesign data to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create SAP ByDesign Data objects that you can access from apps and the dashboard.
-
Connect to Xero Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Xero as an External Source in Dremio.
-
Create a Data Access Object for Elasticsearch Data using JDBI
A brief overview of creating a SQL Object API for Elasticsearch data in JDBI.
-
Create Power BI Reports on Real-Time Facebook Data
Use the CData ODBC Driver for Facebook to visualize Facebook data in Power BI Desktop.
-
Automated Continuous Oracle Service Cloud Replication to Snowflake
Use CData Sync for automated, continuous, customizable Oracle Service Cloud replication to Snowflake.
-
Automated Continuous Contentful Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Contentful replication to Google BigQuery.
-
How to connect and process AdRoll data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live AdRoll data.
-
Access Live Freshservice Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Freshservice data into the statistical analysis tools available in SAS JMP. This article shows how to use Freshservice data in the Graph Builder and Query Builder.
-
Back Up CockroachDB data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for CockroachDB. In this article, we will employ an SSIS workflow to populate a database with CockroachDB data data.
-
Query Reckon Accounts Hosted Data in DataGrip
Create a Data Source for Reckon Accounts Hosted in DataGrip and use SQL to query live Reckon Accounts Hosted data.
-
Back Up QuickBooks data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for QuickBooks. In this article, we will employ an SSIS workflow to populate a database with QuickBooks data data.
-
Enable the VWO JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with VWO data.
-
Integrate Theia IDE with Live iContact 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 iContact data from within the development environment.
-
Create Reports with Smartsheet Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Smartsheet data.
-
Use Azure AI Foundry to Talk to Your Sybase IQ 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 Sybase IQ data for you.
-
How to Access Jira Data Using Entity Framework
This article shows how to access Jira data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Access Live Shippo 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 Shippo data through MCP integration.
-
Create Datasets from Oracle Service Cloud in Domo Workbench and Build Visualizations of Oracle Service Cloud Data in Domo
Use the CData Software ODBC Driver for Oracle Service Cloud to create datasets from Oracle Service Cloud data in Domo Workbench and then build visualizations in the Domo service.
-
Automated Continuous Avaza Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Avaza replication to Apache Kafka.
-
Visualize Close Data in Sisense
Create an ElastiCube in Sisense app with access to Close data.
-
How to connect to Quaderno Data with Squirrel SQL client
Connect to Quaderno data and execute queries in the Squirrel SQL Client.
-
How to connect Amazon QuickSight to SQL Analysis Services Data
Create a connection to SQL Analysis Services data in CData Connect AI and insert SQL Analysis Services data into Amazon QuickSight SPICE to build interactive dashboards.
-
Consume Active Directory OData Feeds in PowerBuilder
This article demonstrates how to consume Active Directory data as OData feeds from PowerBuilder using the API Server.