CData Software - Knowledge Base
Recent Articles
-
ETL Airtable in Oracle Data Integrator
This article shows how to transfer Airtable data into a data warehouse using Oracle Data Integrator.
-
Integrate Mixpanel Data in Pentaho Data Integration
Build ETL pipelines based on Mixpanel data in the Pentaho Data Integration tool.
-
Query Live Klipfolio 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 Klipfolio data directly from the development environment.
-
Replicate Auth0 Data in Heroku for Use in Salesforce Connect
Replicate Auth0 data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Analyze Paddle Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Paddle data in Microsoft R Open.
-
Create SSAS Tabular Models from MYOB AccountRight Data
How to build a SQL Server Analysis Service Tabular Model from MYOB AccountRight data using CData drivers.
-
Replicate Codat Data from PowerShell
Write a quick PowerShell script to query Codat data. Use connectivity to the live data to replicate Codat data to SQL Server.
-
Connect to Parquet Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Parquet data using standard SQL.
-
Bridge Splunk Connectivity with Apache NiFi
Access and process Splunk data in Apache NiFi using the CData JDBC Driver.
-
Extract, Transform, and Load SAP ByDesign Data in Informatica PowerCenter
Create a simple Workflow for SAP ByDesign data in Informatica PowerCenter.
-
How to connect Amazon QuickSight to Pinterest Data
Create a connection to Pinterest data in CData Connect AI and insert Pinterest data into Amazon QuickSight SPICE to build interactive dashboards.
-
Create Datasets from Sentry in Domo Workbench and Build Visualizations of Sentry Data in Domo
Use the CData Software ODBC Driver for Sentry to create datasets from Sentry data in Domo Workbench and then build visualizations in the Domo service.
-
Automated Continuous Opsgenie Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Opsgenie replication to PostgreSQL.
-
Use the CData ODBC Driver for Landbot from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Landbot to connect to Landbot data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Landbot data in Excel.
-
Connect to Real-Time Trello Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Trello and Dataflow to import and use Trello data in Power Apps.
-
A PostgreSQL Interface for Jodoo Data using the CData ODBC Driver
Use the SQL Gateway and Jodoo ODBC Driver to create a PostgreSQL entry-point for data access.
-
Process & Analyze Marketo Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Marketo Data.
-
Integrate Microsoft Exchange with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Microsoft Exchange with External Services.
-
Establish a Live Connection with Calendly Data using Tableau Bridge
The CData ODBC Driver for Calendly enables you to integrate live Calendly data into Tableau Cloud dashboards using the Tableau Bridge.
-
Integrating Antigravity CLI with Freshsales data via CData CLI
Connect Freshsales data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Integrating LangChain with Microsoft Teams Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Microsoft Teams data within automated workflows.
-
Create Informatica Mappings From/To an ODBC Data Source for EmailOctopus
Create an ODBC connection to EmailOctopus in Informatica and browse and transfer EmailOctopus data.
-
Integrate Goose with Live Google Cloud Storage Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Google Cloud Storage data from within the local AI agent.
-
Integrate Notion Data in Pentaho Data Integration
Build ETL pipelines based on Notion data in the Pentaho Data Integration tool.
-
Connecting GenSpark with Google Ads Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Google Ads data without any replication or custom integration required.
-
Visualize Live ZohoPeople Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live ZohoPeople data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
How to connect SharePoint with HBase Data through external lists
Provide HBase data to SharePoint users as an external list.
-
Integrate Theia IDE with Live Bitly 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 Bitly data from within the development environment.
-
How to use SQLAlchemy ORM to access Microsoft Teams Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Microsoft Teams data.
-
Configure the CData JDBC Driver for Epicor Kinetic in a Connection Pool in Tomcat
Connect to Epicor Kinetic data from a connection pool in Tomcat.
-
Visualize Avalara AvaTax Data in TIBCO Spotfire through ADO.NET
Integrate Avalara AvaTax data into dashboards in TIBCO Spotfire.
-
Automated Continuous MYOB AccountRight Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable MYOB AccountRight replication to Google Cloud SQL.
-
Establish a Live Connection with DocuSign Data using Tableau Bridge
The CData ODBC Driver for DocuSign enables you to integrate live DocuSign data into Tableau Cloud dashboards using the Tableau Bridge.
-
Automated Continuous Discourse Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Discourse replication to AlloyDB.
-
How to Access Perplexity Data Using Entity Framework
This article shows how to access Perplexity data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Automate QuickBooks Time Data Replication to Azure Data Lake
Use CData Sync to customize and automate QuickBooks Time data replication to Azure Data Lake.
-
How to connect SharePoint with Monday.com Data through external lists
Provide Monday.com data to SharePoint users as an external list.
-
How to use SQLAlchemy ORM to access Gorgias Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Gorgias data.
-
Automated Continuous Mailgun Replication to SQL Server
Use CData Sync for automated, continuous, customizable Mailgun replication to SQL Server.
-
How to Connect to Live Google Search Results from crewAI Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable crewAI agents to securely read and take actions on your Google Search results for you.
-
Integrating Claude Code with Gong Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Gong data within assisted coding and automated development workflows.
-
Connect to and Query Discord Data in QlikView over ODBC
Create data visualizations with Discord data in QlikView.
-
Access Live Shippo Data in Excel 365 Online (Excel for the web)
Connect to Shippo data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Create SSAS Tabular Models from Sendwithus Data
How to build a SQL Server Analysis Service Tabular Model from Sendwithus data using CData drivers.
-
Query, Visualize, and Share live XML Data in Redash
Use CData Connect AI to connect to live XML data in Redash for querying, visualizing, and sharing.
-
Automate ServiceDesk Plus Data Replication to Azure Data Lake
Use CData Sync to customize and automate ServiceDesk Plus data replication to Azure Data Lake.
-
Build Dashboards with LightSpeedRetail Data in Dundas BI
Create dynamic dashboards and perform analytics based on LightSpeedRetail data in Dundas BI.
-
Connect to and Visualize Live Splunk Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Splunk data.
-
Automate Act CRM Data Replication to Azure Data Lake
Use CData Sync to customize and automate Act CRM data replication to Azure Data Lake.
-
Automated Continuous eBay Analytics Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable eBay Analytics replication to Apache Cassandra.
-
Build AI/ML Models with Live Power BI XMLA Data using Dataiku
Connect Power BI XMLA Data with Dataiku using the CData JDBC Driver for Power BI XMLA.
-
Rapidly Develop ClickTime-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 ClickTime.
-
How to connect and process Grafana data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Grafana data.
-
Back Up Humanity data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData API Driver for ADO.NET. In this article, we will employ an SSIS workflow to populate a database with Humanity data data.
-
Import Email Data Using Azure Data Factory
Use CData Connect AI to connect to Email Data from Azure Data Factory and import live Email data.
-
Integrate SendGrid with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate SendGrid with External Services.
-
Connect to Certinia Data from HeidiSQL
Use CData Connect AI to connect to and query live Certinia data from HeidiSQL.
-
Explore Geographical Relationships in Wistia Data with Power Map
Create data visualizations with Wistia data in Power Map.
-
Integrating LlamaIndex with Apollo Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Apollo data in real time.
-
Visualize Live Stripe Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Stripe data.
-
Create Data Visualizations in Cognos BI with ConstantContact Data
Access ConstantContact data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Automated Continuous CircleCI Replication to AlloyDB
Use CData Sync for automated, continuous, customizable CircleCI replication to AlloyDB.
-
Configure the CData JDBC Driver for Dynamics 365 in a Connection Pool in Tomcat
Connect to Dynamics 365 data from a connection pool in Tomcat.
-
Use Biml to Build SSIS Tasks to Replicate SAP Business Warehouse Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate SAP Business Warehouse data to SQL Server.
-
Build AI Agents with Databricks Data in IBM watsonx Orchestrate using CData Connect AI
Learn how to build intelligent agents in IBM watsonx Orchestrate that can securely access and act on live Databricks data through CData Connect AI.
-
Integrating Dataiku with Teradata Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Teradata data.
-
Feed ClickTime Data into FineReport
How to set ClickTime data as a JDBC data source in FineReport.
-
Visualize Live SAP Ariba Procurement Data in the Power BI Service
Use CData Connect AI to connect to live SAP Ariba Procurement data and create custom reports in the Power BI Service through the On-Premises Gateway.
-
How to create an RPA flow for AgileCRM Data in UiPath Studio
Use the AgileCRM ODBC Driver to create workflows that access real-time AgileCRM data without any coding.
-
Building Dynamic Web Pages with Microsoft Entra ID Data Using AngularJS
Create single-page applications with live connectivity to Microsoft Entra ID using the CData API Server.
-
Query Mode Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Mode data from Node.js.
-
Use Azure AI Foundry to Talk to Your Mailgun 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 Mailgun data for you.
-
Migrating data from SharePoint to Snowflake using CData SSIS Components.
Easily push SharePoint data to Snowflake using the CData SSIS Tasks for SharePoint and Snowflake.
-
Access CampaignMonitor Data from MySQL in PHP
Connect to CampaignMonitor through the standard MySQL libraries in PHP.
-
Build Quickbase Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Quickbase data and build visualizations in Tableau Cloud.
-
Write a Simple Go Application to work with Zoho Books Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Zoho Books data.
-
Connect REST to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live REST data using the CData Python MCP Server.
-
Integrate Freshservice with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Freshservice with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Freshservice data.
-
Design BIRT Reports on Humanity Data
Provide current Humanity data to your embedded analytics.
-
Query Live OData Services 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 OData services directly from the development environment.
-
Connect to Google Ad Manager Data from PowerBuilder via JDBC
This article demonstrates how to access Google Ad Manager data from PowerBuilder using the Google Ad Manager JDBC Driver.
-
Analyze Live Spark Data in SAS Viya
Use CData Connect AI to connect to Spark data from SAS Viya and deploy self-service analytics using live Spark data.
-
Automated Continuous Eventbrite Replication to MongoDB
Use CData Sync for automated, continuous, customizable Eventbrite replication to MongoDB.
-
Automated Continuous Cohere Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Cohere replication to Azure SQL Database.
-
Visualize OnePageCrm Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to OnePageCrm data.
-
Query Shortcut Data as a MySQL Database in Node.js
Execute MySQL queries against Shortcut data from Node.js.
-
Integrate Tanda Data in Pentaho Data Integration
Build ETL pipelines based on Tanda data in the Pentaho Data Integration tool.
-
Analyze SAP HANA XS Advanced Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze SAP HANA XS Advanced data with the CData JDBC Driver for SAP HANA XS Advanced.
-
Add RSS Feeds to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for RSS with the Informatica Enterprise Data Catalog to classify and organize data.
-
Integrating LangGraph with SharePoint Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on SharePoint data within automated workflows.
-
Visualize Sentry Data in Tableau
The CData ODBC driver for Sentry enables you integrate Sentry data into Tableau dashboards.
-
Query Gumroad Data in ColdFusion
Write standard ColdFusion data access code to connect to Gumroad data.
-
Query Office 365 Data in DataGrip
Create a Data Source for Office 365 in DataGrip and use SQL to query live Office 365 data.
-
Integrating LangChain with Campaigner Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Campaigner data within automated workflows.
-
Integrate Live Paymo Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Paymo data and integrate live Paymo data into apps built in Microsoft Power Apps.
-
Integrate Dify with Live Redshift Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Dify agents and workflows to securely access and query live Redshift data.
-
Establish a Live Connection with Microsoft Teams Data using Tableau Bridge
The CData ODBC Driver for Microsoft Teams enables you to integrate live Microsoft Teams data into Tableau Cloud dashboards using the Tableau Bridge.
-
Building Dynamic Web Pages with REST Data Using AngularJS
Create single-page applications with live connectivity to REST using the CData API Server.
-
Integrating OpenCode with Outreach.io 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 Yelp with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Yelp with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Yelp data.