CData Software - Knowledge Base
Recent Articles
-
How to integrate SQL Analysis Services with Apache Airflow
Access and process SQL Analysis Services data in Apache Airflow using the CData JDBC Driver.
-
Visualize Live Egnyte Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Egnyte data into custom reports in Power BI.
-
Build Automated Workflows with Live HubDB Data in Workato
Use CData Connect AI to connect to live HubDB data and build automated workflows in Workato.
-
How to Access Live Oracle SCM Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Oracle SCM enables you to integrate Oracle SCM data into workflows built using Microsoft Power Automate Desktop.
-
How to Create Power BI Visual Reports with Real-Time Drip Data
Use CData Power BI Connectors to visualize Drip data in Power BI.
-
Build Dashboards with Teamwork Data in Dundas BI
Create dynamic dashboards and perform analytics based on Teamwork data in Dundas BI.
-
Create Informatica Mappings From/To a JDBC Data Source for Pinecone
Create Pinecone data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Replicate Sentry Data in Heroku for Use in Salesforce Connect
Replicate Sentry data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Getting Started with the CData SSIS Components for BigCommerce
Complete guide to installing, licensing, and connecting with the CData SSIS Components for BigCommerce.
-
How to connect to Clari Data in DBVisualizer
Integrate Clari data with visual data analysis tools and data connection wizards in DBVisualizer
-
Create Informatica Mappings From/To a JDBC Data Source for ZohoMarketingHub
Create ZohoMarketingHub data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Access Foursquare Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Foursquare data from HeidiSQL.
-
Integrate Cursor with Live SAP Concur Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live SAP Concur data from within the editor.
-
Connect to OpenWeatherMap Data in JRuby
Create a simple JRuby app with access to live OpenWeatherMap data.
-
Build MVC Applications with Connectivity to Couchbase Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Couchbase from an ASP.NET MVC application.
-
Create Datasets from MYOB AccountRight in Domo Workbench and Build Visualizations of MYOB AccountRight Data in Domo
Use the CData Software ODBC Driver for MYOB AccountRight to create datasets from MYOB AccountRight data in Domo Workbench and then build visualizations in the Domo service.
-
Integrate RSS Feeds into Automated Tasks with Power Automate
Use CData Connect AI to connect to RSS feeds and integrate live RSS feeds into your Power Automate tasks.
-
Build Salesforce CRM Analytics-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Salesforce CRM Analytics Data and create custom apps in Bubble.
-
Build Automated Workflows with Live Salesforce CRM Analytics Data in Workato
Use CData Connect AI to connect to live Salesforce CRM Analytics data and build automated workflows in Workato.
-
Access Snapchat Ads Data from MySQL in PHP
Connect to Snapchat Ads through the standard MySQL libraries in PHP.
-
Operational Reporting on HBase Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote HBase data.
-
Query Intercom Data as a MySQL Database in Node.js
Execute MySQL queries against Intercom data from Node.js.
-
Configure the CData JDBC Driver for JotForm in a Connection Pool in Tomcat
Connect to JotForm data from a connection pool in Tomcat.
-
Connect to Highrise Data in NetBeans
Connect to Highrise data in NetBeans with the data source configuration wizard.
-
Automated Continuous Jira Assets Replication to SQLite
Use CData Sync for automated, continuous, customizable Jira Assets replication to SQLite.
-
Build Dynamics 365 Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Dynamics 365 data and build visualizations in Tableau.
-
Integrate Suadeo with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Suadeo with External Services.
-
Create Datasets from MongoDB in Domo Workbench and Build Visualizations of MongoDB Data in Domo
Use the CData Software ODBC Driver for MongoDB to create datasets from MongoDB data in Domo Workbench and then build visualizations in the Domo service.
-
Integrating OpenCode with Omnisend 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 connect to FormSite Data in DBVisualizer
Integrate FormSite data with visual data analysis tools and data connection wizards in DBVisualizer
-
Automate Avalara AvaTax Data Replication to Azure Data Lake
Use CData Sync to customize and automate Avalara AvaTax data replication to Azure Data Lake.
-
Access Live Cloudflare Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Cloudflare data from your Excel spreadsheets.
-
Automated Continuous Instagram Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Instagram replication to Amazon S3.
-
Integrating Postmark Data in Talend Cloud Data Management Platform
Connect Postmark Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
How to connect and process Auth0 data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Auth0 data.
-
A PostgreSQL Interface for CockroachDB Data using the CData ODBC Driver
Use the SQL Gateway and CockroachDB ODBC Driver to create a PostgreSQL entry-point for data access.
-
Integrate RabbitMQ with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate RabbitMQ with External Services.
-
Trigger Bitbucket IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for Bitbucket with standard wizards in Logic Apps.
-
Build AI/ML Models with Live Telegram Data using Dataiku
Connect Telegram Data with Dataiku using the CData API Driver for JDBC.
-
Provide OData Services of Amazon DynamoDB Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Amazon DynamoDB data by developing a WCF Service Application.
-
How to create Insightly federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Insightly data in MySQL .
-
Integrate with Azure Data Lake Storage Data in JReport Designer
Create charts and reports based on Azure Data Lake Storage data in JReport Designer.
-
Use the CData Software JDBC Driver for Kafka in MicroStrategy
Connect to Kafka data in MicroStrategy Developer using the CData Software JDBC Driver for Kafka.
-
Integrating Antigravity CLI with Raisers Edge NXT data via CData CLI
Connect Raisers Edge NXT data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Object-Relational Mapping (ORM) with eBay Analytics 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 eBay Analytics data into a Java-based ORM framework, Hibernate.
-
Productboard Reporting in OBIEE with the Productboard JDBC Driver
Deploy the Productboard JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Access Discourse Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Discourse data from your Oracle system.
-
Visualize Snapchat Ads Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Snapchat Ads data.
-
Build Pipelines with Live Act-On Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Act-On from Google Cloud Data Fusion, enabling the integration of live Act-On data into the building and management of effective data pipelines.
-
Connect to Cloudflare 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 Cloudflare data.
-
Build HelloSign-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live HelloSign data.
-
How to Work with ZeroBounce Data in AWS Glue Jobs Using JDBC
Connect to ZeroBounce from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Publish Reports with PabblySubscriptions Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date PabblySubscriptions data.
-
Connect to Recurly Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Recurly data.
-
Connecting Moonlit Workflow with Azure Data Catalog 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 Azure Data Catalog data in real time.
-
Connect to and Query Pinecone Data in QlikView over ODBC
Create data visualizations with Pinecone data in QlikView.
-
Use Biml to Build SSIS Tasks to Replicate Anaplan Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Anaplan data to SQL Server.
-
Use the CData Software ODBC Driver for Mouseflow in MicroStrategy Web
Connect to Mouseflow data in MicroStrategy Web using the CData Software ODBC Driver for Mouseflow.
-
Automated Continuous MariaDB Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable MariaDB replication to Amazon Redshift.
-
Getting Started with the CData Python Connector for CapsuleCRM
Learn to install and license the CData Python Connector and configure a connection to live CapsuleCRM data.
-
Automated Continuous Hive Replication to MySQL
Use CData Sync for automated, continuous, customizable Hive replication to MySQL.
-
Migrating data from BenchmarkEmail to Databricks using CData SSIS Components.
Easily push BenchmarkEmail data to Databricks using the CData SSIS Tasks for BenchmarkEmail and Databricks.
-
Use the CData ODBC Driver for Factorial from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Factorial to connect to Factorial data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Factorial data in Excel.
-
Access Live MongoDB 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 MongoDB data through MCP integration.
-
Getting Started with the CData Power BI Connector for NASA
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Import Real-Time BigCommerce Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use BigCommerce data in ColdFusion.
-
Integrating Boomi Agentstudio with Coda Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Coda data, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Connect to Microsoft Ads Data in HULFT Integrate
Connect to Microsoft Ads as a JDBC data source in HULFT Integrate
-
Use Biml to Build SSIS Tasks to Replicate Twilio Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Twilio data to SQL Server.
-
Build Pinecone-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Pinecone data and build web apps with connectivity to live Pinecone data.
-
Stream SpaceX Data into Apache Kafka Topics
Access and stream SpaceX data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Automated Continuous Facebook Ads Replication to MySQL
Use CData Sync for automated, continuous, customizable Facebook Ads replication to MySQL.
-
Analyze CSV Data in Cognos Analytics
Use CData Connect AI to connect to CSV Data from Cognos Analytics and analyze live CSV data.
-
Build an OLAP Cube in SSAS from Jumpseller Data
Establish a connection to Jumpseller data data from SQL Server Analysis Services, and use the Jumpseller Data Provider to build OLAP cubes for use in analytics and reporting.
-
LINQ to Placid 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 Placid Data Provider.
-
Create ShipStation-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to ShipStation Data from Klipfolio and build custom visualizations using live ShipStation data.
-
Use the CData Software JDBC Driver for Quaderno in MicroStrategy Web
Connect to Quaderno data in MicroStrategy Web using the CData Software JDBC Driver for Quaderno.
-
How to Create Power BI Visual Reports with Real-Time Facebook Data
Use CData Power BI Connectors to visualize Facebook data in Power BI.
-
Use the CData Software ODBC Driver for Intercom in MicroStrategy Desktop
Connect to Intercom data in MicroStrategy Desktop using the CData Software ODBC Driver for Intercom.
-
Access Cloudant 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 Cloudant data.
-
Query Live VWO 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 VWO data directly from the development environment.
-
How to Access Live Pinterest Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Pinterest enables you to integrate Pinterest data into workflows built using Microsoft Power Automate Desktop.
-
Feed NetSuite Data into FineReport
How to set NetSuite data as a JDBC data source in FineReport.
-
Connecting Agentforce with SageHR 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 SageHR data for you.
-
Create Reports from eBay Analytics Data in Looker Studio
Use CData Connect AI to gain access to live eBay Analytics data and create custom reports in Looker Studio.
-
Using the CData Software ODBC Driver for TigerGraph in PyCharm
Connect to TigerGraph as an ODBC data source in PyCharm using the CData Software ODBC Driver for TigerGraph.
-
Natively Connect to Spark Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Spark data. Leverage the native support for ODBC in PHP.
-
Provide OData Services of Microsoft Dataverse Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Microsoft Dataverse data by developing a WCF Service Application.
-
Build Pipelines with Live Paylocity Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Paylocity from Google Cloud Data Fusion, enabling the integration of live Paylocity data into the building and management of effective data pipelines.
-
Automated Continuous ClickTime Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable ClickTime replication to Azure SQL Database.
-
Establish a Live Connection with BenchmarkEmail Data using Tableau Bridge
The CData ODBC Driver for BenchmarkEmail enables you to integrate live BenchmarkEmail data into Tableau Cloud dashboards using the Tableau Bridge.
-
Connect to Tavily Data in DBeaver
Use the CData ODBC Driver to connect to Tavily data in DBeaver.
-
Stream Aircall Data into Apache Kafka Topics
Access and stream Aircall data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
How to Connect Flowise AI Agents to Live Authorize.Net 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 Authorize.Net data without replication.
-
Replicate Azure Data Catalog Data to Multiple Databases
Replicate Azure Data Catalog data to disparate databases with a point-and-click configuration.
-
Connect to and Visualize Live Google Forms Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Google Forms data.
-
Integrating Google Ad Manager Data in Talend Cloud Data Management Platform
Connect Google Ad Manager Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Google Ad Manager.
-
Connect to Amazon DynamoDB Data from AWS Glue
Use CData Connect AI to gain access to live Amazon DynamoDB data from your AWS Glue jobs.
-
Integrate Real-Time Access to Kafka in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Kafka data in real time.
-
Automated Continuous CSV Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable CSV data replication to OneLake in Microsoft Fabric.