CData Software - Knowledge Base
Recent Articles
-
Access Live eBay Data in TIBCO Data Virtualization
Use the eBay Tibco DV Adapter to create a eBay data data source in TIBCO Data Virtualization Studio and gain access to live eBay data from your TDV Server.
-
DataBind Charts to Marketo Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Marketo data 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.
-
Integrating Claude Code CLI with Monday.com 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 to Wrike Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Wrike to connect to Wrike data and execute queries in PowerBuilder.
-
Connect to ZohoDesk Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for ZohoDesk and the SQL Gateway to access ZohoDesk data from Google Apps Script.
-
Publish SAS Data Sets-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live SAS Data Sets data.
-
DataBind Charts to Exact Online Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Exact Online data 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.
-
Analyze Dynamics 365 Business Central Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Dynamics 365 Business Central data and visualize live Dynamics 365 Business Central data in Infragistics Reveal.
-
Query Live MySQL Data in Zed Editor via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Zed Editor to securely access and query live MySQL data directly from the development environment.
-
Replicate HDFS Data from PowerShell
Write a quick PowerShell script to query HDFS data. Use connectivity to the live data to replicate HDFS data to SQL Server.
-
Automated Continuous Azure Data Lake Storage Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Azure Data Lake Storage replication to PostgreSQL.
-
DataBind Adobe Analytics Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for Adobe Analytics with the DevExpress Windows Forms and Web controls to provide Adobe Analytics data to a chart.
-
Automated Continuous Wrike Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Wrike replication to Amazon Redshift.
-
Load JobNimbus Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load JobNimbus data to a database.
-
Create Data Visualizations in Cognos BI with Spark Data
Access Spark data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Create SAP Netweaver Gateway-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to SAP Netweaver Gateway Data from Klipfolio and build custom visualizations using live SAP Netweaver Gateway data.
-
Use the CData ODBC Driver for Redshift in Microsoft Power Query
You can use the CData Redshift ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Redshift data into Microsoft Power Query.
-
Operational Reporting on Reply.io Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Reply.io data.
-
Connecting Agentforce with ShipEngine Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Agentforce to securely read and take actions on your ShipEngine data for you.
-
Getting Started with the CData SSIS Components for Timely
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Timely.
-
Use the CData Software ODBC Driver for Short.io in MicroStrategy Desktop
Connect to Short.io data in MicroStrategy Desktop using the CData Software ODBC Driver for Short.io.
-
Natively Connect to Bright Data Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Bright Data data. Leverage the native support for ODBC in PHP.
-
Integrating Kiro with PolarTeamPro 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 Google Contacts Data in the Pentaho Report Designer
Publish reports based on Google Contacts data in the Pentaho BI tool.
-
Integrating Claude Code CLI with Dynamics 365 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 to MySQL Data in HULFT Integrate
Connect to MySQL as a JDBC data source in HULFT Integrate
-
Build Slack-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Slack Data from Zoho Analytics and import live Slack data.
-
Visualize Live Dotmailer Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Dotmailer data.
-
How to integrate Metabase with ZohoPeople Data
Use CData Connect AI to connect to live ZohoPeople data and create an interactive dashboard in Metabase from ZohoPeople data.
-
Visualize Planio Data in TIBCO Spotfire through ADO.NET
Integrate Planio data into dashboards in TIBCO Spotfire.
-
Access Live Facebook Ads Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Facebook Ads data from your Excel spreadsheets.
-
Object-Relational Mapping (ORM) with ShipStation Data Entities in Java
Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to ShipStation data into a Java-based ORM framework, Hibernate.
-
How to Access Wistia Data Using Entity Framework
This article shows how to access Wistia data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Connect to Planio Data in Jaspersoft Studio
Execute SQL to remote Planio data in Jaspersoft Studio.
-
Build Shopify-Connected Applications in Kiro with CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Kiro to securely access, query, and take action on live Shopify data without replication.
-
How to Connect DBeaver to ZohoMarketingHub via a JDBC Driver
Manage ZohoMarketingHub data with visual tools in DBeaver like the query browser.
-
Connect to Monday.com Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Monday.com as an External Source in Dremio.
-
How to work with FreshBooks Data in Apache Spark using SQL
Access and process FreshBooks Data in Apache Spark using the CData Software JDBC Driver.
-
Connect to Coinbase Data in DBeaver
Use the CData ODBC Driver to connect to Coinbase data in DBeaver.
-
Integrate Devin with Live Sage 300 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 300 data.
-
Build Automated Workflows with Live SAP Hybris C4C Data in Workato
Use CData Connect AI to connect to live SAP Hybris C4C data and build automated workflows in Workato.
-
Replicate Multiple Sybase IQ Accounts
Replicate multiple Sybase IQ accounts to one or many databases.
-
Create Everhour Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Everhour data access from reports, embedded analytics, and more.
-
A PostgreSQL Interface for Google Translate Data using the CData ODBC Driver
Use the SQL Gateway and Google Translate ODBC Driver to create a PostgreSQL entry-point for data access.
-
Choosing the Best Method to Connect Redis to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Redis data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
How to Connect the Power BI Service to Mistral AI: Complete Guide
Connect to the CData Software Power BI Connector for Mistral AI from PowerBI.com to provide real-time Mistral AI data across the organization.
-
Access Live Elasticsearch Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Elasticsearch data from your Excel spreadsheets.
-
Automated Continuous HubDB Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable HubDB replication to Apache Cassandra.
-
Build AI/ML Models with Live Exact Online Data using Dataiku
Connect Exact Online Data with Dataiku using the CData JDBC Driver for Exact Online.
-
Connect to ZohoDesk Data from HeidiSQL
Use CData Connect AI to connect to and query live ZohoDesk data from HeidiSQL.
-
Automated Continuous Superchat Replication to SingleStore
Use CData Sync for automated, continuous, customizable Superchat replication to SingleStore.
-
Use ChatGPT to Talk to Your Xero Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable ChatGPT to securely answer questions and take actions on your Xero data for you.
-
Integrating Gumloop with Raisers Edge NXT Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Raisers Edge NXT data within automated workflows.
-
Import and Visualize GitLab Data in Power View
Create data visualizations based on GitLab data in Excel.
-
Query Gong Data as a MySQL Database in Node.js
Execute MySQL queries against Gong data from Node.js.
-
DataBind Charts to Tickspot Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Tickspot data 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.
-
Getting Started with the CData Power BI Connector for Azure DevOps
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Azure DevOps.
-
Build an OLAP Cube in SSAS from MariaDB Data
Establish a connection to MariaDB data data from SQL Server Analysis Services, and use the MariaDB Data Provider to build OLAP cubes for use in analytics and reporting.
-
Model, Search, and Visualize Live Egnyte Data in ThoughtSpot
Use CData Connect AI to connect to live Egnyte data for modeling, searching, and visualizing.
-
Bidirectional Access to Reckon Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Reckon data in Filemaker Pro for Mac or Windows.
-
Access Live Google Spanner Data in TIBCO Data Virtualization
Use the Google Spanner Tibco DV Adapter to create a Google Spanner data data source in TIBCO Data Virtualization Studio and gain access to live Google Spanner data from your TDV Server.
-
Getting Started with the CData Excel Add-In for Supabase
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Supabase.
-
Integrating Kiro with Anaplan 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 Create Power BI Visual Reports with Real-Time GitLab Data
Use CData Power BI Connectors to visualize GitLab data in Power BI.
-
Integrate Bannerbear Data into Power Automate Desktop using CData Connect
CData Connect for Bannerbear Data enables you to integrate Bannerbear data into workflows built using Microsoft Power Automate Desktop.
-
Replicate GitLab Data from PowerShell
Write a quick PowerShell script to query GitLab data. Use connectivity to the live data to replicate GitLab data to SQL Server.
-
Connect to Certinia Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Certinia data in Airbyte.
-
Build Dashboards with DocuSign Data in Dundas BI
Create dynamic dashboards and perform analytics based on DocuSign data in Dundas BI.
-
Build an OLAP Cube in SSAS from Outlook Data
Establish a connection to Outlook data data from SQL Server Analysis Services, and use the Outlook Data Provider to build OLAP cubes for use in analytics and reporting.
-
A PostgreSQL Interface for Pipedrive Data (MySQL Remoting via JDBC)
Use the Remoting features of the Pipedrive JDBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to Placid Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Placid data using standard SQL.
-
Connect to SAS xpt Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with SAS xpt Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Natively Connect to Active Directory Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Active Directory data. Leverage the native support for ODBC in PHP.
-
Query Sage 200 Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Sage 200 entities in PHP by modeling them as objects.
-
Automated Continuous Zoho Creator Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Zoho Creator replication to delimited files (CSV/TSV).
-
Analyze Oracle Service Cloud Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Oracle Service Cloud data in Microsoft R Open.
-
Easily Integrate Unbounce Data in Lazarus Pascal IDE
Learn how to easily integrate live Unbounce data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Connect to Jodoo Data in CloverDX (formerly CloverETL)
Transfer Jodoo data using the visual workflow in the CloverDX data integration tool.
-
How to Work with Zoom Data in ETL Validator JDBC
Connect to Zoom from ETL Validator jobs using the CData Software JDBC Driver.
-
Connect to Omnisend Data in JRuby
Create a simple JRuby app with access to live Omnisend data.
-
Use the CData Software ODBC Driver for Hubstaff in MicroStrategy Web
Connect to Hubstaff data in MicroStrategy Web using the CData Software ODBC Driver for Hubstaff.
-
Create Adobe Analytics-Connected Business Apps in AppSheet
Connect to Adobe Analytics Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Adobe Analytics data.
-
Access Live ZohoPeople Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live ZohoPeople data from your Excel spreadsheets.
-
Use the CData Software JDBC Driver for SAP Business One in MicroStrategy Desktop
Connect to SAP Business One data in MicroStrategy Desktop using the CData Software JDBC Driver for SAP Business One.
-
Connect to CSV Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with CSV Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
How to Work with Parquet Data in AWS Glue Jobs Using JDBC
Connect to Parquet from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Connect to Avalara AvaTax from Asprova with CData Software ODBC Driver for Avalara AvaTax
This article shows how to connect faster to Avalara AvaTax data from Asprova.
-
Use Dash to Build to Web Apps on YouTube Analytics Data
Create Python applications that use pandas and Dash to build YouTube Analytics-connected web apps.
-
Manage Cassandra Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Cassandra.
-
Connect to Apollo Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Apollo data.
-
Consume Cassandra OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Cassandra feeds that reflect any changes in SAP Lumira.
-
Visualize Mixpanel 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 Mixpanel data into TIBCO Spotfire.
-
Connect to Neo4J Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to Neo4J.
-
Build a Singer.io Tap for Access With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Access data using the CData Python Connector.
-
Getting Started with the CData Tableau Connector for Redshift
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Redshift.
-
Provide OData Services of SAS Data Sets Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for SAS Data Sets data by developing a WCF Service Application.
-
Todoist Reporting in OBIEE with the Todoist JDBC Driver
Deploy the Todoist JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Connect to CSV Data in DBArtisan
Use wizards in DBArtisan to configure CSV data as a data source.
-
Use the CData SSIS Components to Insert New or Update Existing Excel Online Records from SQL Server
Easily push SQL Server data to Excel Online using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Excel Online or update existing records with data from a SQL Server database.
-
Connect to Campaigner Data from HeidiSQL
Use CData Connect AI to connect to and query live Campaigner data from HeidiSQL.