CData Software - Knowledge Base
Recent Articles
-
Stream EnterpriseDB Data into Apache Kafka Topics
Access and stream EnterpriseDB in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Connect to BigCommerce Data in JRuby
Create a simple JRuby app with access to live BigCommerce.
-
Build Paylocity-Powered Applications in Cursor with CData MCP Server
Use the CData MCP Server for Paylocity to explore live Paylocity Data in Cursor to assist with building Paylocity-powered applications.
-
Build Dashboards with Webex Data in DBxtra
Create dynamic dashboards and perform analytics based on Webex in DBxtra.
-
Build MailerLite-Powered Applications in Gemini Code Assist with CData MCP Server
Use the CData API Driver for MCP Server to explore live MailerLite Data in Gemini Code Assist to assist with building MailerLite-powered applications.
-
Automated Continuous HCL Domino Replication to SQLite
Use CData Sync for automated, continuous, customizable HCL Domino replication to SQLite.
-
Query Salesforce CRM Analytics Data as a MySQL Database in Node.js
Execute MySQL queries against Salesforce CRM Analytics from Node.js.
-
Use the CData Software JDBC Driver for Missive in MicroStrategy Web
Connect to Missive in MicroStrategy Web using the CData Software JDBC Driver for Missive.
-
Analyze BigQuery Data in Infragistics Reveal
Use the CData API Server to create an OData API on top of Google BigQuery and visualize live Google BigQuery in Infragistics Reveal.
-
How to connect and process ElevenLabs from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live ElevenLabs.
-
Build an OLAP Cube in SSAS from TaxJar Data
Establish a connection to TaxJar data from SQL Server Analysis Services, and use the TaxJar Data Provider to build OLAP cubes for use in analytics and reporting.
-
Use the CData Software ODBC Driver for SharePoint in MicroStrategy
Connect to Microsoft SharePoint in MicroStrategy Developer using the CData Software ODBC Driver for SharePoint.
-
Connect to Salesloft Data in Aqua Data Studio
Access Salesloft from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Connect to BigQuery Data in DBeaver
Use the CData ODBC Driver to connect to Google BigQuery in DBeaver.
-
Getting Started with the CData Excel Add-In for Teradata
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Teradata.
-
Integrate FreeAgent Data in the Pentaho Report Designer
Publish reports based on FreeAgent in the Pentaho BI tool.
-
Configure the CData JDBC Driver for Suadeo in a Connection Pool in Tomcat
Connect to Suadeo from a connection pool in Tomcat.
-
Connect to Mailjet 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 Mailjet and work with Mailjet in your FileMaker application.
-
Build MVC Applications with Connectivity to Pushbullet Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Pushbullet from an ASP.NET MVC application.
-
Getting Started with the CData SSIS Components for Bright Data
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Bright Data.
-
Connect to Adobe Target Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Query Discourse Data from Node.js
Use the OData endpoint of the CData API Server to connect to your Discourse and perform CRUD operations on Discourse from Node.js.
-
How to integrate Metabase with SAP Hybris C4C Data
Use CData Connect AI to connect to live SAP Hybris C4C and create an interactive dashboard in Metabase from SAP Hybris C4C.
-
Connect to Xero Data from a Connection Pool in Jetty
The Xero JDBC Driver supports connection pooling: This article shows how to connect faster to Xero Accounting from Web apps in Jetty.
-
Build Charts with OneNote Data in Clear Analytics
Create dynamic charts and perform analytics based on Microsoft OneNote in Clear Analytics.
-
Integrate Cosmos DB with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Cosmos DB with External Services.
-
Build Facebook Ads-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData MCP Server for Facebook Ads to explore live Facebook Ads Data in GitHub Copilot to assist with building Facebook Ads-powered applications.
-
Extract, Transform, and Load Pipeliner CRM Data in Informatica PowerCenter
Create a simple Workflow for Pipeliner CRM in Informatica PowerCenter.
-
Automate iContact Data Replication to Azure Data Lake
Use CData Sync to customize and automate iContact replication to Azure Data Lake.
-
Import and Visualize Trello Data in Power View
Create data visualizations based on Trello in Excel.
-
How to Easily Query Aha! Data in OpenOffice Base
Connect to Aha! data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Feed Procore Data into FineReport
How to set Procore as a JDBC data source in FineReport.
-
Access Live CockroachDB Data in TIBCO Data Virtualization
Use the CockroachDB Tibco DV Adapter to create a CockroachDB data source in TIBCO Data Virtualization Studio and gain access to live CockroachDB from your TDV Server.
-
Integrating Gumloop with HCL Domino Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on HCL Domino within automated workflows.
-
Access Live Raisers Edge NXT 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 Raisers Edge NXT through MCP integration.
-
Working with Splunk Data in LINQPad
Execute LINQ queries to Splunk in LINQPad.
-
Use the CData ODBC Driver for Drip from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Drip to connect to Drip from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Drip in Excel.
-
How to Connect to & Open GitHub Data in Microsoft Excel
This article uses the CData ODBC driver for GitHub to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Build Hive-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData MCP Server for Apache Hive to explore live Hive Data in GitHub Copilot to assist with building Hive-powered applications.
-
A PostgreSQL Interface for Act CRM Data (MySQL Remoting via JDBC)
Use the Remoting features of the Act CRM JDBC Driver to create a PostgreSQL entry-point for data access.
-
Automated Continuous SendPulse Replication to SQLite
Use CData Sync for automated, continuous, customizable SendPulse replication to SQLite.
-
Connect to Sage 200 Data in Ruby
Connect to Sage 200 in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
View Reports on Real-Time SendPulse Data in Power BI Report Server
Use the CData ODBC Driver for SendPulse to visualize SendPulse in Power BI Desktop and then publish them to Power BI Report Server.
-
Automated Continuous Couchbase Replication to Vertica
Use CData Sync for automated, continuous, customizable Couchbase replication to Vertica.
-
Analyze Zoho Projects Data in Cognos Analytics
Use CData Connect AI to connect to Zoho Projects Data from Cognos Analytics and analyze live Zoho Projects.
-
Connect to Placid Data in NetBeans
Connect to Placid in NetBeans with the data source configuration wizard.
-
Analyze Lakebase Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Lakebase and visualize live Lakebase in Infragistics Reveal.
-
How to connect SharePoint with Unbounce Data through external lists
Provide Unbounce to SharePoint users as an external list.
-
Prepare, Blend, and Analyze FreshBooks Data in Alteryx Designer (ODBC)
Build workflows to access live FreshBooks for self-service data analytics.
-
Create Tickspot Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Tickspot data access from reports, embedded analytics, and more.
-
Edit and Search Mouseflow External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of Mouseflow to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create Mouseflow objects that you can access from apps and the dashboard.
-
Access Presto Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Presto from HeidiSQL.
-
Connect to and Visualize Live Sage 200 Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Sage 200.
-
Getting Started with the CData Tableau Connector for Jira Assets
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Jira Assets.
-
Explore Geographical Relationships in SpaceX Data with Power Map
Create data visualizations with SpaceX in Power Map.
-
Build Charts with Testmonitor Data in Clear Analytics
Create dynamic charts and perform analytics based on Testmonitor in Clear Analytics.
-
How to Query Live Wistia Data in Claude Desktop
Connect to and query live Wistia Data in Claude Desktop using CData MCP Server.
-
Connect to Close Data in RapidMiner
Integrate Close with standard components and data source configuration wizards in RapidMiner Studio.
-
How to Connect to Google Drive Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Google Drive. Leverage the pyodbc module for ODBC in Python.
-
Create SSAS Tabular Models from Tally Data
How to build a SQL Server Analysis Service Tabular Model from Tally ERP using CData drivers.
-
Access Live Google Campaign Manager 360 Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Google Campaign Manager 360 from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Connect to Tally Data in RapidMiner
Integrate Tally ERP with standard components and data source configuration wizards in RapidMiner Studio.
-
How to connect to Sage 300 Data from IntelliJ
Integrate connectivity to Sage 300 with wizards in IntelliJ.
-
Visualize Testmonitor 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 Testmonitor into TIBCO Spotfire.
-
Create Certinia-Connected Business Apps in AppSheet
Connect to Certinia Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Certinia.
-
Visualize HBase Data in Tableau
The CData ODBC driver for HBase enables you integrate Apache HBase into Tableau dashboards.
-
DataBind Controls to Onfleet Data in Delphi
DataBind to Onfleet in Delphi with standard data access components and controls.
-
Connect to Acumatica Data in Ruby
Connect to Acumatica ERP in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Extract, Transform, and Load Excel Data in Informatica PowerCenter
Create a simple Workflow for Microsoft Excel in Informatica PowerCenter.
-
Consume Google Spanner OData Feeds in PowerBuilder
This article demonstrates how to consume Google Spanner as OData feeds from PowerBuilder using the API Server.
-
Access Klaviyo Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Klaviyo from your Oracle system.
-
Create a Data Access Object for Oracle Eloqua Reporting Data using JDBI
A brief overview of creating a SQL Object API for Oracle Eloqua Reporting in JDBI.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Freshteam
Provide connectivity to Freshteam through an SAP BusinessObjects universe.
-
Connect to Zoho Creator Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Zoho Creator in the Denodo Virtual DataPort Administrator.
-
Use Azure AI Foundry to Talk to Your BambooHR 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 BambooHR for you.
-
Query CapsuleCRM Data through ODBC in Node.js
Use node-odbc to execute SQL queries against CapsuleCRM from Node.js.
-
Connect Productboard Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Productboard using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Configure the CData JDBC Driver for Facebook in a Connection Pool in Tomcat
Connect to Facebook from a connection pool in Tomcat.
-
How to Query Live Samanage Data in Perplexity MacOS Desktop
Connect to and query live Samanage Data in Perplexity Desktop using CData MCP Server.
-
Use the CData API Server to Access Amazon S3 Data in Microsoft PowerPivot
Use the CData API Server to connect to live Amazon S3 in the Power Pivot business intelligence tool.
-
Automate Twitter Ads Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Twitter Ads from PowerShell? This article demonstrates how to utilize the Twitter Ads Cmdlets for tasks like connecting to Twitter Ads, automating operations, downloading data, and more.
-
Connect to Procore Data in Ruby
Connect to Procore in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Build Google Sheets Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Google Sheets and build visualizations in Tableau Cloud.
-
Build Landbot-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Landbot and build web apps with connectivity to live Landbot.
-
Automated Continuous ClickUp Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable ClickUp replication to Apache Kafka.
-
How to integrate Flowlu with Apache Airflow
Access and process Flowlu in Apache Airflow using the CData JDBC Driver.
-
Access Live HBase Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Apache HBase from your Google Sheets.
-
Integrate Cline with Live Microsoft Exchange Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Microsoft Exchange from within your IDE.
-
How to import Flowlu Data into Apache Solr
Use the CData Software JDBC Driver for Flowlu in Data Import Handler and create an automated import of Flowlu to Apache Solr Enterprise Search platform.
-
Integrate Live Sybase Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Sybase and integrate live Sybase into apps built in Microsoft Power Apps.
-
Access Live Power BI XMLA Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Power BI XMLA from your Google Sheets.
-
How to Connect the Power BI Service to Sage 200: Complete Guide
Connect to the CData Software Power BI Connector for Sage 200 from PowerBI.com to provide real-time Sage 200 across the organization.
-
Back Up CSV/TSV Files to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for CSV. In this article, we will employ an SSIS workflow to populate a database with CSV/TSV Files data.
-
Build Visualizations of Google Analytics Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Google Analytics in Birst.
-
How to connect PolyBase to Zoho Inventory
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Zoho Inventory.
-
Explore Geographical Relationships in Cloudant Data with Power Map
Create data visualizations with IBM Cloudant in Power Map.
-
Connect to Wrike Data from PowerBuilder via ADO.NET
This article demonstrates how to access Wrike from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Bidirectional Access to QuickBooks Online Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate QuickBooks Online in Filemaker Pro for Mac or Windows.
-
How to Access Live TigerGraph Data in Power Automate Desktop via ODBC
The CData ODBC Driver for TigerGraph enables you to integrate TigerGraph into workflows built using Microsoft Power Automate Desktop.
-
Access Live Bugsnag Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live Bugsnag data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.