CData Software - Knowledge Base
Recent Articles
-
Bridge Dynamics CRM Connectivity with Apache NiFi
Access and process Microsoft Dynamics CRM in Apache NiFi using the CData JDBC Driver.
-
Configure the CData JDBC Driver for MailerLite in a Connection Pool in Tomcat
Connect to MailerLite from a connection pool in Tomcat.
-
Visualize Splunk Data in TIBCO Spotfire through OData
Integrate Splunk into dashboards in TIBCO Spotfire.
-
Integrate Trello with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Trello with External Services.
-
Automated Continuous Amazon DynamoDB Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Amazon DynamoDB replication to Azure SQL Database.
-
How to Query Live Act CRM Data in Perplexity MacOS Desktop
Connect to and query live Act CRM Data in Perplexity Desktop using CData MCP Server.
-
Build Semantic Layer Views for ElevenLabs Data in APOS Live Data Gateway
Use the CData Connector for ElevenLabs in APOS Live Data Gateway to build Semantic Layer Views for ElevenLabs.
-
Integrate Brex Data in the Pentaho Report Designer
Publish reports based on Brex in the Pentaho BI tool.
-
Connect to Spark Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Apache Spark SQL using standard SQL.
-
Integrate Greenplum Data in Pentaho Data Integration
Build ETL pipelines based on Pivotal GreenPlum in the Pentaho Data Integration tool.
-
How to Create Power BI Visual Reports with Real-Time Supabase Data
Use CData Power BI Connectors to visualize Supabase in Power BI.
-
Connect to Blackbaud FE NXT from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Blackbaud FE NXT, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Integrate SFTP Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live SFTP from Informatica Cloud.
-
Connect to HBase Data from PowerBuilder via JDBC
This article demonstrates how to access Apache HBase from PowerBuilder using the HBase JDBC Driver.
-
Query Guru Data as a MySQL Database in Node.js
Execute MySQL queries against Guru from Node.js.
-
Automated Continuous Bannerbear Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Bannerbear replication to AlloyDB.
-
Replicate Harvest Data to Multiple Databases
Replicate Harvest to disparate databases with a point-and-click configuration.
-
Build a PostgreSQL Interface for ZeroBounce Data using the CData JDBC Driver
Use the Remoting features of the ZeroBounce JDBC Driver to create a PostgreSQL entry-point for data access.
-
How to connect to Retently Data from Spring Boot
Connect to Retently in a Spring Boot Application using the CData API Driver for JDBC
-
How to Create Power BI Visual Reports with Real-Time ServiceNow Data
Use CData Power BI Connectors to visualize ServiceNow in Power BI.
-
Getting Started with the CData Python Connector for SendGrid
Learn to install and license the CData Python Connector
-
Build a Singer.io Tap for Twitter Ads With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Twitter Ads data using
-
Connect to Sage Intacct Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Sage Intacct using standard SQL.
-
Connect to Telegram Data from PowerBuilder via ADO.NET
This article demonstrates how to access Telegram from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Mixpanel Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Mixpanel facts in real time.
-
Create Informatica Mappings From/To an ODBC Data Source for Amazon DynamoDB
Create an ODBC connection to Amazon DynamoDB in Informatica and browse and transfer Amazon DynamoDB.
-
Build Voice Agents in ElevenLabs with access to Live Zuora Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Zuora.
-
DataBind Charts to ConvertKit Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to ConvertKit 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.
-
Build Jira-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Jira Data and create custom apps in Bubble.
-
How to Query Live MySQL Data in Claude Desktop
Connect to and query live MySQL Data in Claude Desktop using CData MCP Server.
-
Prepare, Blend, and Analyze Discourse Data in Alteryx Designer (ODBC)
Build workflows to access live Discourse for self-service data analytics.
-
Automated Continuous Microsoft Ads Replication to Vertica
Use CData Sync for automated, continuous, customizable Microsoft Ads replication to Vertica.
-
Publish Crystal Reports on ZohoSubscriptions Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date ZohoSubscriptions.
-
Natively Connect to Stack Exchange Data in PHP
The CData ODBC driver for Stack Exchange enables you to create PHP applications with connectivity to Stack Exchange. Leverage the native support for ODBC in PHP.
-
Visualize Live Sendwithus Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Sendwithus using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Connect and Visualize Live Freshservice Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Freshservice into the Databricks platform and create visualization dashboards with real-time Freshservice.
-
Connect to Chargebee from Asprova with CData Software ODBC Driver for Chargebee
This article shows how to connect faster to Chargebee data from Asprova.
-
Connect to Dropbox Data from Crystal Reports
Use CData Connect AI to connect to and report on live Dropbox from Crystal Reports.
-
Getting Started with the CData JDBC Driver for Tanda
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Tanda.
-
How to work with Drip Data in Apache Spark using SQL
Access and process Drip Data in Apache Spark using the CData Software JDBC Driver.
-
Use Databricks Agent Bricks to Talk to Your Greenplum Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Pivotal GreenPlum for you.
-
Automated Continuous Instagram Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Instagram replication to delimited files (CSV/TSV).
-
Query Klaviyo Data in DataGrip
Create a Data Source for Klaviyo in DataGrip and use SQL to query live Klaviyo.
-
Analyze Authorize.Net Data in Cognos Analytics
Use CData Connect AI to connect to Authorize.Net Data from Cognos Analytics and analyze live Authorize.Net.
-
Connect to Cosmos DB Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Azure Cosmos DB in Airbyte.
-
Moving Data from FHIR to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live FHIR data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Access DB2 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 IBM DB2.
-
Excel Spreadsheet Automation on Stripe Data with the QUERY Formula
Pull data from Stripe, automate spreadsheets, and more with the QUERY formula.
-
Connect to CampaignMonitor Data in NetBeans
Connect to CampaignMonitor in NetBeans with the data source configuration wizard.
-
How to connect and process Cloudflare from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Cloudflare.
-
Using the CData Software ODBC Driver for SAP HANA in PyCharm
Connect to SAP HANA as an ODBC data source in PyCharm using the CData Software ODBC Driver for SAP HANA.
-
Build Oracle HCM Cloud-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Oracle HCM Cloud Data and create custom apps in Bubble.
-
Use JayDeBeApi to access Outreach.io Data in Python
Use standard Python scripting and the development environment of your choice to access live Outreach.io.
-
Visualize Stripe Data in TIBCO Spotfire through ADO.NET
Integrate Stripe into dashboards in TIBCO Spotfire.
-
Deploy the ADO.NET Provider for SendPulse on an SSRS Report Server
Connect to SendPulse 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.
-
How to Connect to & Open MariaDB Data in Microsoft Excel
This article uses the CData ODBC driver for MariaDB to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Use the CData API Server to Access Google Contacts Data in Microsoft PowerPivot
Use the CData API Server to connect to live Google Contacts in the Power Pivot business intelligence tool.
-
Automated Continuous Yelp Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Yelp replication to Google BigQuery.
-
Moving Data from Greenhouse to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Greenhouse data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Connect to Microsoft Planner Data in NetBeans
Connect to Microsoft Planner in NetBeans with the data source configuration wizard.
-
Getting Started with the CData SSIS Components for Wave Financial
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Wave Financial.
-
Build Dashboards with SAP HANA XS Advanced Data in DBxtra
Create dynamic dashboards and perform analytics based on SAP HANA XS Advanced in DBxtra.
-
Visualize Live OData Services in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live OData into custom reports in Power BI.
-
DataBind Controls to Yelp Data in C++Builder
DataBind to Yelp in C++Builder with standard components and controls.
-
Visualize Microsoft OneDrive Data in TIBCO Spotfire through ADO.NET
Integrate Microsoft OneDrive into dashboards in TIBCO Spotfire.
-
How to Connect to Access Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Microsoft Access. Leverage the pyodbc module for ODBC in Python.
-
Use Dash to Build to Web Apps on Microsoft Ads Data
Create Python applications that use pandas and Dash to build Microsoft Ads-connected web apps.
-
Connect to PolarTeamPro Data in CloverDX (formerly CloverETL)
Transfer PolarTeamPro using the visual workflow in the CloverDX data integration tool.
-
Automate Zoho Books Data Replication to Azure Synapse
Use CData Sync to customize and automate Zoho Books replication to Azure Synapse.
-
Automated Continuous Greenplum Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Greenplum replication to Google BigQuery.
-
Connect to Gumroad Data from a Connection Pool in JBoss
Integrate Gumroad into Java servlets: Use the Management Console in JBoss to install the Gumroad JDBC Driver.
-
Access Live Square Data in TIBCO Data Virtualization
Use the Square Tibco DV Adapter to create a Square data source in TIBCO Data Virtualization Studio and gain access to live Square from your TDV Server.
-
DataBind Controls to Calendly Data in C++Builder
DataBind to Calendly in C++Builder with standard components and controls.
-
Automate Google Analytics Data Replication to SAP HANA
Use CData Sync to customize and automate Google Analytics replication to SAP HANA.
-
How to Work with Contentful Data in ETL Validator JDBC
Connect to Contentful from ETL Validator jobs using the CData Software JDBC Driver.
-
Bind Live ShipStation Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live ShipStation data
-
Automated Facebook Data Replication to Teradata
Use CData Sync to Customize and automate Facebook replication to Teradata.
-
Create Redis Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Redis from PowerBI.com to create Power BI Dataflows with real-time data.
-
Connect to Workday Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Workday in the Denodo Virtual DataPort Administrator.
-
Automated Continuous Mouseflow Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Mouseflow replication to Google BigQuery.
-
How to Query Asana Data in MySQL Workbench
Execute MySQL queries against live Asana from MySQL Workbench.
-
How to connect to Factorial Data from Spring Boot
Connect to Factorial in a Spring Boot Application using the CData API Driver for JDBC
-
Excel Spreadsheet Automation on QuickBooks Online Data with the QUERY Formula
Pull data from QuickBooks Online, automate spreadsheets, and more with the QUERY formula.
-
ETL iContact in Oracle Data Integrator
This article shows how to transfer iContact into a data warehouse using Oracle Data Integrator.
-
Connect to SAS Data Sets Data in HULFT Integrate
Connect to SAS Data Sets as a JDBC data source in HULFT Integrate
-
Load ZendeskSell Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load ZendeskSell to a database.
-
Choosing the Best Method to Connect SAP Ariba Procurement to SQL Server: 5 Options Explained
Discover multiple ways to connect and use SAP Ariba Procurement from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Automate Amazon DynamoDB Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live Amazon DynamoDB and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
Build Dashboards with Elorus Data in Dundas BI
Create dynamic dashboards and perform analytics based on Elorus in Dundas BI.
-
Use the CData ODBC Driver for Microsoft Teams in Microsoft Power Query
You can use the CData Microsoft Teams ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Microsoft Teams into Microsoft Power Query.
-
Visualize REST Data in TIBCO Spotfire through OData
Integrate REST into dashboards in TIBCO Spotfire.
-
Use CData Connect AI to Access Databricks Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Databricks in the Power Pivot business intelligence tool.
-
Build Drip-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Drip.
-
Model, Search, and Visualize Live Greenplum Data in ThoughtSpot
Use CData Connect AI to connect to live Pivotal GreenPlum for modeling, searching, and visualizing.
-
Connect to Campaigner Data in Ruby
Connect to Campaigner in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Analyze eBay Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze eBay with the CData JDBC Driver for eBay.
-
Add Mocean Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Mocean with the Informatica Enterprise Data Catalog to classify and organize data.
-
Provide OData Services of Stripe Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Stripe by developing a WCF Service Application.
-
Build Pipelines with Live Phoenix Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Phoenix from Google Cloud Data Fusion, enabling the integration of live Apache Phoenix into the building and management of effective data pipelines.
-
How to Build an ETL App for LightSpeedRetail Data in Python with CData
Create ETL applications and real-time data pipelines for LightSpeedRetail in Python with petl.