CData Software - Knowledge Base
Recent Articles
-
How to Access Live Reckon Accounts Hosted Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Reckon Accounts Hosted enables you to integrate Reckon Accounts Hosted data into workflows built using Microsoft Power Automate Desktop.
-
Connecting Mastra with Epicor Kinetic 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 Epicor Kinetic data, no replication required.
-
Create Dynamic HDFS Grids Using the Infragistics XamDataGrid
Learn how you can connect HDFS to Infragistics XamDataGrid to build dynamic grids.
-
Query ServiceNow Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume ServiceNow entities in PHP by modeling them as objects.
-
Connect Avalara AvaTax to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Avalara AvaTax data using the CData Python MCP Server.
-
Connect to Real-Time Drip Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Drip data in Power Apps.
-
Import Notion Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Notion Data and provide access to live Notion data for custom reports in the Power BI Service.
-
Create Anaplan Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Anaplan from PowerBI.com to create Power BI Dataflows with real-time data.
-
Connect and Query Live Avro Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Avro data into Databricks and enable direct, live querying and analysis without replication.
-
How to connect PolyBase to Pinecone
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Pinecone data.
-
Visualize ChargeOver Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to ChargeOver data.
-
Object-Relational Mapping (ORM) with ConstantContact 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 ConstantContact data into a Java-based ORM framework, Hibernate.
-
Connect to VWO Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to VWO and work with VWO data in your FileMaker applications.
-
Access Live ZohoMarketingHub Data in Excel 365 Online (Excel for the web)
Connect to ZohoMarketingHub data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
How to update Greenplum from Excel
This article explains how to transfer data from Excel to Greenplum using the Excel Add-In for Greenplum.
-
Integrate Trae with Live Exa Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Trae to securely access and query live Exa data from within the AI-powered IDE.
-
Create Reports from Teradata Data in Looker Studio
Use CData Connect AI to gain access to live Teradata data and create custom reports in Looker Studio.
-
Connect to Aircall Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Aircall data.
-
Use the CData Software JDBC Driver for ZohoMarketingHub in MicroStrategy Desktop
Connect to ZohoMarketingHub data in MicroStrategy Desktop using the CData Software JDBC Driver for ZohoMarketingHub.
-
Provide OData Services of SurveyMonkey Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for SurveyMonkey data by developing a WCF Service Application.
-
Integrate Live Greenplum Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Greenplum from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Greenplum data.
-
Integrate Cline with Live Amazon Marketplace Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Amazon Marketplace data from within your IDE.
-
How to load Kafka data into Elasticsearch via Logstash
Introducing a simple method to load Kafka data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Use the CData Software ODBC Driver for PayPal in MicroStrategy Desktop
Connect to PayPal data in MicroStrategy Desktop using the CData Software ODBC Driver for PayPal.
-
Access Live QuickBooks Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live QuickBooks data from your Google Sheets.
-
Automated Continuous QuickBooks Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable QuickBooks replication to Azure SQL Database.
-
Use ChatGPT to Talk to Your Freshteam 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 Freshteam data for you.
-
Integrate DocuSign Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live DocuSign data from Informatica Cloud.
-
Create Apps from Google Forms Data in Qlik Sense Cloud
Use CData Connect AI to connect to Google Forms Data and build apps from live Google Forms data in Qlik Sense Cloud.
-
Object-Relational Mapping (ORM) with SFTP 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 SFTP data into a Java-based ORM framework, Hibernate.
-
How to connect to Dynamics 365 Data with Squirrel SQL client
Connect to Dynamics 365 data and execute queries in the Squirrel SQL Client.
-
Design BIRT Reports on OpenWeatherMap Data
Provide current OpenWeatherMap data to your embedded analytics.
-
Connect to Postmark Data from a Connection Pool in Jetty
The Postmark JDBC Driver supports connection pooling: This article shows how to connect faster to Postmark data from Web apps in Jetty.
-
Process & Analyze GitHub Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live GitHub Data.
-
Connect to Greenhouse Data from PowerBuilder via ADO.NET
This article demonstrates how to access Greenhouse data from Appeon PowerBuilder using the CData ADO.NET Provider for Greenhouse.
-
DataBind Controls to Factorial Data in Delphi
DataBind to Factorial data in Delphi with standard data access components and controls.
-
Operational Reporting on Bugsnag Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Bugsnag data.
-
Access Notion Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Notion data from your Oracle system.
-
How to publish and share PhantomBuster Data dashboards with Tableau Server
The CData ODBC driver for PhantomBuster enables you integrate PhantomBuster data into Tableau dashboards.
-
How to Seamlessly Import Power BI XMLA Data into IBM SPSS Modeler
Integrate Power BI XMLA data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Easily Integrate Billsby Data in Lazarus Pascal IDE
Learn how to easily integrate live Billsby data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Build Dashboards with SAP Business One Data in Dundas BI
Create dynamic dashboards and perform analytics based on SAP Business One data in Dundas BI.
-
Replicate Facebook Ads Data to Multiple Databases via the CData Sync CLI
Replicate Facebook Ads data to disparate databases with a single configuration.
-
Use the CData Software ODBC Driver for Spark in MicroStrategy Desktop
Connect to Spark data in MicroStrategy Desktop using the CData Software ODBC Driver for Spark.
-
Back Up TaxJar data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for TaxJar. In this article, we will employ an SSIS workflow to populate a database with TaxJar data data.
-
Migrating data from VWO to Snowflake using CData SSIS Components.
Easily push VWO data to Snowflake using the CData SSIS Tasks for VWO and Snowflake.
-
Access Live Lakebase Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Lakebase data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Build Automated Workflows with Live Microsoft Teams Data in Workato
Use CData Connect AI to connect to live Microsoft Teams data and build automated workflows in Workato.
-
Connect to SharePoint Excel Services Data in Jaspersoft Studio
Execute SQL to remote SharePoint Excel Services data in Jaspersoft Studio.
-
Connect to MySQL Data in Ruby
Connect to MySQL data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Build Data Flows from SQL Server to Airtable through SSIS
Easily push SQL Server data to Airtable using the CData SSIS Tasks for Airtable.
-
Build AlloyDB-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to AlloyDB data and build web apps with connectivity to live AlloyDB data.
-
Access IBM Informix Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live IBM Informix data from HeidiSQL.
-
Moving Data from Google Ad Manager to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Google Ad Manager data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
DataBind Charts to Azure Data Catalog Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Azure Data Catalog 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.
-
Connect to Stripe Data from HeidiSQL
Use CData Connect AI to connect to and query live Stripe data from HeidiSQL.
-
Connecting Moonlit Workflow with ZohoInvoice 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 ZohoInvoice data in real time.
-
How to publish and share Bitbucket Data dashboards with Tableau Server
The CData ODBC driver for Bitbucket enables you integrate Bitbucket data into Tableau dashboards.
-
Use Biml to Build SSIS Tasks to Replicate Zoom Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Zoom data to SQL Server.
-
Integrate Cvent Data into Power Automate Desktop using CData Connect
CData Connect for Cvent Data enables you to integrate Cvent data into workflows built using Microsoft Power Automate Desktop.
-
Integrating Antigravity CLI with Demio data via CData CLI
Connect Demio data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Getting Started with the CData ADO.NET Provider for Workday
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Workday.
-
Automated GitLab Data Replication to Teradata
Use CData Sync to Customize and automate GitLab data replication to Teradata.
-
Interact with Live Amazon DynamoDB Data in Meta Muse via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Muse to securely interact with live Amazon DynamoDB data.
-
Use the CData Software JDBC Driver for Neo4J in MicroStrategy Web
Connect to Neo4J data in MicroStrategy Web using the CData Software JDBC Driver for Neo4J.
-
Visualize Live Sybase Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Sybase data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Access SendPulse Data in Mule Applications Using the CData JDBC Driver
Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for SendPulse data.
-
Use the CData Software JDBC Driver for Wistia in MicroStrategy
Connect to Wistia data in MicroStrategy Developer using the CData Software JDBC Driver for Wistia.
-
Connect to Bright Data Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Bright Data data in the Denodo Virtual DataPort Administrator.
-
Build PostgreSQL-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 PostgreSQL data without replication.
-
Connect to Exact Online Data in Claris FileMaker Pro
Use the CData ODBC Driver for Exact Online in FileMaker Pro to connect to Exact Online and work with Exact Online data in your FileMaker applications.
-
How to Connect Flowise AI Agents to Live eBay Data via CData Connect AI
Integrate Flowise AI with the CData Connect AI MCP Server to enable agents to securely query and act on live eBay data without replication.
-
Build Dashboards with AgileCRM Data in Dundas BI
Create dynamic dashboards and perform analytics based on AgileCRM data in Dundas BI.
-
Access Live SAP Fieldglass 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 SAP Fieldglass data through MCP integration.
-
Search External Grafana Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Grafana data to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Grafana Data objects that you can access from apps and the dashboard.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for NetSuite
Provide connectivity to NetSuite data through an SAP BusinessObjects universe.
-
Use the CData Software JDBC Driver for Smartsheet in MicroStrategy
Connect to Smartsheet data in MicroStrategy Developer using the CData Software JDBC Driver for Smartsheet.
-
Build Semantic Layer Views for Teamwork Data in APOS Live Data Gateway
Use the CData Connector for Teamwork in APOS Live Data Gateway to build Semantic Layer Views for Teamwork data.
-
Integrate with live JSON Services in Jitterbit
Use CData Connect AI to connect to and integrate live JSON services in Jitterbit.
-
Design BIRT Reports on Postmark Data
Provide current Postmark data to your embedded analytics.
-
Connect to Azure Table from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Azure Table data, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Connect to Hubstaff Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to Hubstaff.
-
Publish ZohoInvoice-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live ZohoInvoice data.
-
Build Phoenix-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Phoenix Data from Zoho Analytics and import live Phoenix data.
-
Build Data Flows from Deel to SQL Server using SSIS
Easily back up Deel data to SQL Server using the SSIS components for Deel.
-
Natively Connect to SingleStore Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to SingleStore data. Leverage the native support for ODBC in PHP.
-
Automated Continuous Klipfolio Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Klipfolio replication to Amazon S3.
-
Create a Data Access Object for OData Services using JDBI
A brief overview of creating a SQL Object API for OData services in JDBI.
-
Analyze Mocean Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Mocean data in Microsoft R Open.
-
Access Live WordPress 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 WordPress data through MCP integration.
-
Automated Continuous Oracle Sales Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Oracle Sales replication to Apache Kafka.
-
Integrate Live Certinia Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Certinia data to Blue Prism using the CData ODBC Driver for Certinia to create automated workflows for repetitive business tasks.
-
Automated Continuous Square Replication to MongoDB
Use CData Sync for automated, continuous, customizable Square replication to MongoDB.
-
Rapidly Develop Dynamics 365 Business Central-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 Dynamics 365 Business Central.
-
Create RabbitMQ Dataflows on PowerBI.com
Connect to the CData Power BI Connector for RabbitMQ from PowerBI.com to create Power BI Dataflows with real-time data.
-
Stream Google Campaign Manager 360 Data into Apache Kafka Topics
Access and stream Google Campaign Manager 360 data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Connect to Everhour Data in CloverDX (formerly CloverETL)
Transfer Everhour data using the visual workflow in the CloverDX data integration tool.
-
Working with Printify Data in LINQPad
Execute LINQ queries to Printify data in LINQPad.
-
Visualize Mistral AI Data in Sisense
Create an ElastiCube in Sisense app with access to Mistral AI data.
-
Create Informatica Mappings From/To an ODBC Data Source for Microsoft Exchange
Create an ODBC connection to Microsoft Exchange in Informatica and browse and transfer Microsoft Exchange data.