CData Software - Knowledge Base
Recent Articles
-
Build Charts with Oracle Eloqua Data in Clear Analytics
Create dynamic charts and perform analytics based on Oracle Eloqua in Clear Analytics.
-
How to Access Phoenix Data Using Entity Framework
This article shows how to access Apache Phoenix using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Query Square Data in ColdFusion
Write standard ColdFusion data access code to connect to Square.
-
Automated Continuous Certinia Replication to SingleStore
Use CData Sync for automated, continuous, customizable Certinia replication to SingleStore.
-
Integrate Instantly Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Instantly from Informatica Cloud.
-
How to Connect DBeaver to Active Directory via a JDBC Driver
Manage Active Directory with visual tools in DBeaver like the query browser.
-
Visualize Google Ads Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Google Ads.
-
Query Customer.io Data in ColdFusion
Write standard ColdFusion data access code to connect to Customer.io.
-
Configure the CData JDBC Driver for Pushbullet in a Connection Pool in Tomcat
Connect to Pushbullet from a connection pool in Tomcat.
-
Automated Continuous AlloyDB Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable AlloyDB replication to Google BigQuery.
-
Create Dynamic Pingdom Grids Using the Infragistics XamDataGrid
Learn how you can connect Pingdom to Infragistics XamDataGrid to build dynamic grids.
-
Choosing the Best Method to Connect Adobe Analytics to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Adobe Analytics from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Add OpenWeatherMap Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for OpenWeatherMap with the Informatica Enterprise Data Catalog to classify and organize data.
-
Connect to iContact Data in RazorSQL
Connect to iContact from wizards and query iContact from the GUI in the RazorSQL database management tool.
-
Access Live Snowflake Data in AWS Lambda
Connect to live Snowflake in AWS Lambda using the CData JDBC Driver.
-
Integrate Hubstaff Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Hubstaff from Informatica Cloud.
-
Build SQL Server-Powered Applications in Gemini Code Assist with CData MCP Server
Use the CData MCP Server for SQL Server to explore live SQL Server Data in Gemini Code Assist to assist with building SQL Server-powered applications.
-
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.
-
Automated Continuous Impala Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Impala replication to Azure SQL Database.
-
Publish Reports with Browserless Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Browserless.
-
Integrating LangChain with YouTube Analytics Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on YouTube Analytics within automated workflows.
-
Connect to FreeAgent Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for FreeAgent in the Denodo Virtual DataPort Administrator.
-
Integrating Kiro CLI with Contentful 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.
-
Access Live Quickbase Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Quickbase from your Excel spreadsheets.
-
Connect to LinkedIn Ads Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live LinkedIn Ads.
-
How to use SQLAlchemy ORM to access Gmail Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Gmail.
-
Integrate Live Instagram Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf
-
How to work with Spark Data in Apache Spark using SQL
Access and process Spark Data in Apache Spark using the CData Software JDBC Driver.
-
Import Real-Time Coda Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Coda in ColdFusion.
-
Import Real-Time Vimeo Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Vimeo in ColdFusion.
-
Establish a Live Connection with CockroachDB Data using Tableau Bridge
The CData ODBC Driver for CockroachDB enables you to integrate live CockroachDB into Tableau Cloud dashboards using the Tableau Bridge.
-
How to connect SharePoint with Zoho Books Data through external lists
Provide Zoho Books to SharePoint users as an external list.
-
Visualize Live Telegram Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Telegram using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Connecting Mastra with Presto 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 Presto, no replication required.
-
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.
-
Integrate Real-Time Access to Wave Financial in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Wave Financial in real time.
-
How to connect to ServiceNow Data in DBVisualizer
Integrate ServiceNow with visual data analysis tools and data connection wizards in DBVisualizer
-
Build Microsoft Exchange-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData MCP Server for Microsoft Exchange to explore live Microsoft Exchange Data in GitHub Copilot to assist with building Microsoft Exchange-powered applications.
-
Automated Continuous ShipStation Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable ShipStation replication to Google Cloud SQL.
-
Integrating Codex CLI with SingleStore 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.
-
Getting Started with the CData ODBC Driver for Hugging Face
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Hugging Face.
-
Integrating OpenCode Terminal with AlloyDB 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.
-
DataBind Charts to Clio Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Clio 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.
-
How to Connect to Live Epicor Kinetic 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 Epicor Kinetic for you.
-
Integrating OpenCode Terminal with Azure Data Lake Storage 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 Access Live Splunk Data in Visual Studio Code via Cline
Run CData MCP Server for Splunk on Windows Subsytem for Linux (WSL) and connect to live Splunk from the Cline extension in Visual Studio Code.
-
Create Data Visualizations in Cognos BI with Azure Synapse Data
Access Azure Synapse as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
View Reports on Real-Time ClickTime Data in Power BI Report Server
Use the CData ODBC Driver for ClickTime to visualize ClickTime in Power BI Desktop and then publish them to Power BI Report Server.
-
Extract, Transform, and Load Teamgate Data in Informatica PowerCenter
Create a simple Workflow for Teamgate in Informatica PowerCenter.
-
Choosing the Best Method to Connect LionDesk to SQL Server: 5 Options Explained
Discover multiple ways to connect and use LionDesk from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Feed SAP Fieldglass Data into FineReport
How to set SAP Fieldglass as a JDBC data source in FineReport.
-
How to Query Greenplum Data in MySQL Workbench
Execute MySQL queries against live Pivotal GreenPlum from MySQL Workbench.
-
Connect to Impala Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Apache Impala.
-
Analyze HubSpot Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze HubSpot in Microsoft R Open.
-
How to create Paymo federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Paymo in MySQL .
-
How to import Wrike Data into Apache Solr
Use the CData Software JDBC Driver for Wrike in Data Import Handler and create an automated import of Wrike to Apache Solr Enterprise Search platform.
-
Access Paylocity Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Paylocity from your Oracle system.
-
Automated Sage Cloud Accounting Data Replication to Teradata
Use CData Sync to Customize and automate Sage Business Cloud Accounting replication to Teradata.
-
Integrating GitHub Copilot CLI with Monday.com 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.
-
Publish PostgreSQL-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live PostgreSQL.
-
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.
-
Access Live Cloudant 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 IBM Cloudant through MCP integration.
-
How to import CouchDB Data into Apache Solr
Use the CData Software JDBC Driver for CouchDB in Data Import Handler and create an automated import of Apache CouchDB to Apache Solr Enterprise Search platform.
-
Connect to NetSuite in SpagoBI
Create reports featuring live NetSuite CRM & ERP in SpagoBI Studio. Host NetSuite reports on SpagoBI Server.
-
Build HCL Domino-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData MCP Server for HCL Domino to explore live HCL Domino Data in GitHub Copilot to assist with building HCL Domino-powered applications.
-
Feed Campaigner Data into FineReport
How to set Campaigner as a JDBC data source in FineReport.
-
How to import BigQuery Data into Apache Solr
Use the CData Software JDBC Driver for BigQuery in Data Import Handler and create an automated import of Google BigQuery to Apache Solr Enterprise Search platform.
-
Manage ShipStation Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for ShipStation.
-
Use Grok to Talk to Your GitHub Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Grok AI to securely answer questions and take actions on your GitHub for you.
-
ETL Spark in Oracle Data Integrator
This article shows how to transfer Apache Spark SQL into a data warehouse using Oracle Data Integrator.
-
How to publish and share HubDB Data dashboards with Tableau Server
The CData ODBC driver for HubDB enables you integrate HubDB into Tableau dashboards.
-
Automated Continuous Shortcut Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Shortcut replication to PostgreSQL.
-
Use the CData Software JDBC Driver for BenchmarkEmail in MicroStrategy Desktop
Connect to BenchmarkEmail in MicroStrategy Desktop using the CData Software JDBC Driver for BenchmarkEmail.
-
Create Apps from Airtable Data in Qlik Sense Cloud
Use CData Connect AI to connect to Airtable Data and build apps from live Airtable in Qlik Sense Cloud.
-
Import and Visualize Zoho Books Data in Power View
Create data visualizations based on Zoho Books in Excel.
-
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.
-
Edit and Search External Azure DevOps Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Azure DevOps to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Azure DevOps Data objects that you can access from apps and the dashboard.
-
Visualize SAP BusinessObjects BI Data in Sisense
Create an ElastiCube in Sisense app with access to SAP BusinessObjects BI.
-
Extend Google Sheets with Pinterest Data
Make calls to Pinterest from Google Apps Script via the API Server.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Azure Analysis Services
Provide connectivity to Azure Analysis Services through an SAP BusinessObjects universe.
-
Getting Started with the CData ADO.NET Provider for Microsoft Planner
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Microsoft Planner.
-
Connect to MongoDB Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Visualize Cosmos DB Data in TIBCO Spotfire through ADO.NET
Integrate Azure Cosmos DB into dashboards in TIBCO Spotfire.
-
How to Access Live Templated Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Templated enables you to integrate Templated into workflows built using Microsoft Power Automate Desktop.
-
Query Google Cloud Storage Data in DataGrip
Create a Data Source for Google Cloud Storage in DataGrip and use SQL to query live Google Cloud Storage.
-
Integrate with Impala Data in JReport Designer
Create charts and reports based on Apache Impala in JReport Designer.
-
Connect to Ontraport in SpagoBI
Create reports featuring live Ontraport in SpagoBI Studio. Host Ontraport reports on SpagoBI Server.
-
Connect to Onfleet Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Onfleet in the Denodo Virtual DataPort Administrator.
-
How to Connect to Acumatica Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Acumatica ERP. Leverage the pyodbc module for ODBC in Python.
-
Create Informatica Mappings From/To an ODBC Data Source for Workday
Create an ODBC connection to Workday in Informatica and browse and transfer Workday.
-
Integrating LangGraph with Okta Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Okta within automated workflows.
-
ETL Ontraport in Oracle Data Integrator
This article shows how to transfer Ontraport into a data warehouse using Oracle Data Integrator.
-
Build Jira-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Jira Data from Zoho Analytics and import live Atlassian Jira.
-
Work with Live Paylocity Data in Power Query
Use CData Connect AI to connect to Paylocity and work with live Paylocity in Microsoft Power Query.
-
Excel Spreadsheet Automation on Redshift Data with the QUERY Formula
Pull data from Redshift, automate spreadsheets, and more with the QUERY formula.
-
Build Dashboards with Google Forms Data in Dundas BI
Create dynamic dashboards and perform analytics based on Google Forms in Dundas BI.
-
Query Vimeo Data in DataGrip
Create a Data Source for Vimeo in DataGrip and use SQL to query live Vimeo.
-
Perform API Operations Using Stored Procedures in CData SSIS Components
The CData SSIS Data Flow components allow you to easily import and export data from various data sources. However, in some cases, the type of operation you need does not fit the SSIS Data Source or the SSIS Data Destination model. In this article, we will demonstrate how to use a CData stored procedure in your SSIS Data Flow.
-
Build Monday.com-Powered Applications in Cursor with CData MCP Server
Use the CData MCP Server for Monday.com to explore live Monday.com Data in Cursor to assist with building Monday.com-powered applications.