CData Software - Knowledge Base
Recent Articles
-
Automated Continuous Tanda Replication to Snowflake
Use CData Sync for automated, continuous, customizable Tanda replication to Snowflake.
-
Build MySQL-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live MySQL.
-
Query Opsgenie Data in DataGrip
Create a Data Source for Opsgenie in DataGrip and use SQL to query live Opsgenie.
-
Build MVC Applications with Connectivity to iContact Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access iContact from an ASP.NET MVC application.
-
Connecting Mastra with Redis 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 Redis, no replication required.
-
Publish Crystal Reports on Recurly Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Recurly.
-
Access Parquet 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 Apache Parquet.
-
Connect to ActiveCampaign from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from ActiveCampaign, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Getting Started with the CData JDBC Driver for Jodoo
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Jodoo.
-
Connect JDBC-ODBC Bridge to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect JDBC-ODBC Bridge with IBM WebSphere for seamless data integration and connectivity.
-
Build Apps with Live ConvertKit Data Using the Low-Code Development Platform of Mendix
Connect ConvertKit with Mendix to build apps using the CData API Driver for JDBC.
-
Bridge Reckon Accounts Hosted Connectivity with Apache NiFi
Access and process Reckon Accounts Hosted in Apache NiFi using the CData JDBC Driver.
-
Automated Continuous Xero Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Xero replication to IBM DB2.
-
Getting Started with the CData SSIS Components for Splunk
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Splunk.
-
Build AI Agents with SingleStore 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 SingleStore through CData Connect AI.
-
Access Telegram Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Telegram from HeidiSQL.
-
Automate Microsoft OneLake Data Replication to Azure Synapse
Use CData Sync to customize and automate Microsoft OneLake replication to Azure Synapse.
-
Create Power BI Reports on Real-Time ZendeskSell Data
Use the CData ODBC Driver for ZendeskSell to visualize ZendeskSell in Power BI Desktop.
-
Build a PostgreSQL Interface for Paylocity Data using the CData JDBC Driver
Use the Remoting features of the Paylocity JDBC Driver to create a PostgreSQL entry-point for data access.
-
A PostgreSQL Interface for ConstantContact Data (MySQL Remoting via JDBC)
Use the Remoting features of the ConstantContact JDBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to PhantomBuster Data in RazorSQL
Connect to PhantomBuster from wizards and query PhantomBuster from the GUI in the RazorSQL database management tool.
-
Provide OData Services of Datadog Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Datadog by developing a WCF Service Application.
-
Integrating LangChain with Azure Synapse Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Azure Synapse within automated workflows.
-
Integrate Hacker News Data in the Pentaho Report Designer
Publish reports based on Hacker News in the Pentaho BI tool.
-
How to connect to Oracle Financials Cloud Data from Spring Boot
Connect to Oracle Financials Cloud in a Spring Boot Application using the CData JDBC Driver for Oracle Financials Cloud
-
Connect to Wrike Data in JRuby
Create a simple JRuby app with access to live Wrike.
-
How to integrate Metabase with Oracle Financials Cloud Data
Use CData Connect AI to connect to live Oracle Financials Cloud and create an interactive dashboard in Metabase from Oracle Financials Cloud.
-
Connect to Presto Data from a Connection Pool in JBoss
Integrate Presto into Java servlets: Use the Management Console in JBoss to install the Presto JDBC Driver.
-
Build Semantic Layer Views for Google Calendar Data in APOS Live Data Gateway
Use the CData Connector for Google Calendar in APOS Live Data Gateway to build Semantic Layer Views for Google Calendar.
-
How to Connect to Live Zoho Projects 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 Zoho Projects for you.
-
Automate Billsby Data Replication to SAP HANA
Use CData Sync to customize and automate Billsby replication to SAP HANA.
-
How to create an RPA flow for Avro Data in UiPath Studio
Use the Avro ODBC Driver to create workflows that access real-time Apache Avro without any coding.
-
How to import Suadeo Data into Apache Solr
Use the CData Software JDBC Driver for Suadeo in Data Import Handler and create an automated import of Suadeo to Apache Solr Enterprise Search platform.
-
Automated Continuous Email Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Email replication to Amazon Redshift.
-
Create Informatica Mappings From/To an ODBC Data Source for PabblySubscriptions
Create an ODBC connection to PabblySubscriptions in Informatica and browse and transfer PabblySubscriptions.
-
ETL JotForm in Oracle Data Integrator
This article shows how to transfer JotForm into a data warehouse using Oracle Data Integrator.
-
Create Slack-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Slack Data from OutSystems and build custom enterprise apps using live Slack.
-
Integrating LangGraph with Reckon Accounts Hosted Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Reckon Accounts Hosted within automated workflows.
-
Object-Relational Mapping (ORM) with SAP Business One 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 SAP Business One into a Java-based ORM framework, Hibernate.
-
Automate MailerSend Integration Tasks from PowerShell
Are you in search of a quick and easy way to access MailerSend from PowerShell? This article demonstrates how to utilize the MailerSend Cmdlets for tasks like connecting to MailerSend, automating operations, downloading data, and more.
-
Build Hive-Powered Applications in Claude Code with CData MCP Server
Use the CData MCP Server for Hive to explore live Hive Data in Claude Code to assist with building Hive-powered applications.
-
Automate ZendeskSell Data Replication to SAP HANA
Use CData Sync to customize and automate ZendeskSell replication to SAP HANA.
-
Connect Zoho Creator to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Zoho Creator using the CData Python MCP Server.
-
Extract, Transform, and Load Twitter Ads Data in Informatica PowerCenter
Create a simple Workflow for Twitter Ads in Informatica PowerCenter.
-
How to Connect to Wrike Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Wrike. Leverage the pyodbc module for ODBC in Python.
-
Connect to Okta Data in CloverDX (formerly CloverETL)
Transfer Okta using the visual workflow in the CloverDX data integration tool.
-
Connect to YouTube Analytics Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live YouTube Analytics.
-
Use Dash to Build Web Apps on Amazon Athena Data via CData Connect AI
Build interactive Dash web apps on live Amazon Athena using pandas and the CData Connect AI Python SDK.
-
Visualize Live Stripe Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Stripe using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Build an OLAP Cube in SSAS from Guru Data
Establish a connection to Guru data from SQL Server Analysis Services, and use the Guru Data Provider to build OLAP cubes for use in analytics and reporting.
-
Snapchat Ads Reporting in OBIEE with the Snapchat Ads JDBC Driver
Deploy the Snapchat Ads JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Deploy the ADO.NET Provider for Klipfolio on an SSRS Report Server
Connect to Klipfolio from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.
-
SAP ERP: Enhanced sys_procedureparameters Metadata for BAPI Procedures
Learn about the enhanced sys_procedureparameters metadata for BAPI procedures in SAP ERP.
-
Automated Continuous PagerDuty Replication to SQL Server
Use CData Sync for automated, continuous, customizable PagerDuty replication to SQL Server.
-
How to Visualize Gmail Data in Python with pandas
Use pandas and other modules to analyze and visualize live Gmail in Python.
-
Connect to Salesforce Data from a Connection Pool in Jetty
The Salesforce JDBC Driver supports connection pooling: This article shows how to connect faster to Salesforce & Force.com from Web apps in Jetty.
-
Create Data Visualizations in Cognos BI with Notion Data
Access Notion as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Connect to Oracle Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Oracle and the SQL Gateway to access Oracle Database from Google Apps Script.
-
Getting Started with the CData Python Connector for Freshservice
Learn to install and license the CData Python Connector
-
Automated Continuous Vertica Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Vertica replication to Amazon Redshift.
-
Create Power BI Reports on Real-Time Reply.io Data
Use the CData ODBC Driver for Reply.io to visualize Reply.io in Power BI Desktop.
-
How to Connect Flowise AI Agents to Live WordPress 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 WordPress without replication.
-
How to use SQLAlchemy ORM to access Kintone Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Kintone.
-
Prepare, Blend, and Analyze Opsgenie Data in Alteryx Designer (ODBC)
Build workflows to access live Opsgenie for self-service data analytics.
-
Integrating GitHub Copilot CLI with Twitter Ads 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 load Cvent data into Elasticsearch via Logstash
Introducing a simple method to load Cvent data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Visualize Bullhorn CRM 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 Bullhorn CRM into TIBCO Spotfire.
-
Connect to Sendwithus Data Using the Script Function in Claris FileMaker Pro
Use the CData API Driver for ODBC and the Script function in FileMaker Pro to connect to Sendwithus and work with Sendwithus in your FileMaker application.
-
Connect to Salesforce Pardot Data from Crystal Reports
Use CData Connect AI to connect to and report on live Salesforce Pardot from Crystal Reports.
-
Integrate Cursor with Live Google Sheets Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Google Sheets from within the editor.
-
Create SSAS Tabular Models from SAP Concur Data
How to build a SQL Server Analysis Service Tabular Model from SAP Concur using CData drivers.
-
Operational Reporting on Tanda Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Tanda.
-
How to Connect to Live SAP Concur Data in Mistral AI Workflows
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live SAP Concur without replication.
-
Access GetResponse Data from MySQL in Amazon QuickSight
Connect to GetResponse and build visualizations of GetResponse using a MySQL Connection in Amazon QuickSight.
-
Establish a Live Connection with Cosmos DB Data using Tableau Bridge
The CData ODBC Driver for Cosmos DB enables you to integrate live Azure Cosmos DB into Tableau Cloud dashboards using the Tableau Bridge.
-
Build Phoenix-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Apache Phoenix.
-
Automate Clockify Data Replication to Couchbase
Use CData Sync to Customize and automate Clockify replication to Couchbase.
-
Getting Started with the CData Python Connector for Pipeliner CRM
Learn to install and license the CData Python Connector
-
Automate OnePageCrm Data Replication to Azure Synapse
Use CData Sync to customize and automate OnePageCrm replication to Azure Synapse.
-
How to Connect to Google Translate Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Google Translate. Leverage the pyodbc module for ODBC in Python.
-
Build Wave Financial-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData MCP Server for Wave Financial to explore live Wave Financial Data in GitHub Copilot to assist with building Wave Financial-powered applications.
-
How to work with HubSpot Data in Apache Spark using SQL
Access and process HubSpot Data in Apache Spark using the CData Software JDBC Driver.
-
How to Connect to Live HBase Data 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 Apache HBase for you.
-
Connect ShipEngine Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your ShipEngine using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Connect to Oracle HCM Cloud Data in Jaspersoft Studio
Execute SQL to remote Oracle HCM Cloud in Jaspersoft Studio.
-
Create Adobe Commerce-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Adobe Commerce Data from OutSystems and build custom enterprise apps using live Adobe Commerce.
-
Analyze Zoho Books Data in Cognos Analytics
Use CData Connect AI to connect to Zoho Books Data from Cognos Analytics and analyze live Zoho Books.
-
Create Informatica Mappings From/To an ODBC Data Source for NetSuite
Create an ODBC connection to NetSuite in Informatica and browse and transfer NetSuite CRM & ERP.
-
How to connect SharePoint with Zendesk Data through external lists
Provide Zendesk to SharePoint users as an external list.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for AdRoll
Provide connectivity to AdRoll through an SAP BusinessObjects universe.
-
How to integrate MarkLogic with Apache Airflow
Access and process MarkLogic in Apache Airflow using the CData JDBC Driver.
-
Building Dynamic Web Pages with Zoho Books Data Using AngularJS
Create single-page applications with live connectivity to Zoho Books using the CData API Server.
-
Create a Data Access Object for Printify Data using JDBI
A brief overview of creating a SQL Object API for Printify in JDBI.
-
Build an OLAP Cube in SSAS from ShipStation Data
Establish a connection to ShipStation data from SQL Server Analysis Services, and use the ShipStation Data Provider to build OLAP cubes for use in analytics and reporting.
-
Getting Started with the CData Tableau Connector for Mouseflow
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Integrate with Live Marketo Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Marketo from the MuleSoft Anypoint Platform to integrate live Marketo into custom reports and dashboards.
-
Integrate Spotify with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Spotify with External Services.
-
Use the CData Software JDBC Driver for Toggl in MicroStrategy Desktop
Connect to Toggl in MicroStrategy Desktop using the CData Software JDBC Driver for Toggl.
-
LINQ to Klaviyo 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 Klaviyo Data Provider.
-
Visualize Campaigner Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Campaigner.