CData Software - Knowledge Base
Recent Articles
-
SAP BusinessObjects BI Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to SAP BusinessObjects BI through CData Connect AI using different applications and tools.
-
Model, Search, and Visualize Live SQL Analysis Services Data in ThoughtSpot
Use CData Connect AI to connect to live SQL Analysis Services for modeling, searching, and visualizing.
-
Publish Crystal Reports on Parquet Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Apache Parquet.
-
How to Create Power BI Visual Reports with Real-Time Paymo Data
Use CData Power BI Connectors to visualize Paymo in Power BI.
-
How to work with Mouseflow Data in Apache Spark using SQL
Access and process Mouseflow Data in Apache Spark using the CData Software JDBC Driver.
-
Build Epicor Kinetic-Powered Applications in Cursor with CData MCP Server
Use the CData MCP Server for Epicor Kinetic to explore live Epicor Kinetic Data in Cursor to assist with building Epicor Kinetic-powered applications.
-
Query Amazon DynamoDB Data in ColdFusion
Write standard ColdFusion data access code to connect to Amazon DynamoDB.
-
Access Live ServiceNow Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live ServiceNow data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Access Live Redshift Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Amazon Redshift into the statistical analysis tools available in SAS JMP. This article shows how to use Amazon Redshift in the Graph Builder and Query Builder.
-
Getting Started with the CData JDBC Driver for Nuclia
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Nuclia.
-
Analyze Insightly Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Insightly in Microsoft R Open.
-
Connect to Dynamics 365 Business Central from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Dynamics 365 Business Central, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Automated Helpscout Data Replication to Teradata
Use CData Sync to Customize and automate Helpscout replication to Teradata.
-
Use Azure AI Foundry to Talk to Your DB2 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 IBM DB2 for you.
-
Create Data Visualizations Based On Xero Data in Mode
Use CData Connect AI to connect to Xero Data from Mode and build visualizations using live
-
Automated Continuous Mailjet Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Mailjet replication to Amazon S3.
-
Manage LightSpeedRetail Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for LightSpeedRetail.
-
How to create CouchDB federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Apache CouchDB in MySQL .
-
Connect ZohoMarketingHub to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live ZohoMarketingHub using the CData Python MCP Server.
-
Connect to SharePoint Data in DBeaver
Use the CData ODBC Driver to connect to Microsoft SharePoint in DBeaver.
-
Automated Continuous Eventbrite Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Eventbrite replication to IBM DB2.
-
Create Reports from Google Calendar Data in Looker Studio
Use CData Connect AI to gain access to live Google Calendar and create custom reports in Looker Studio.
-
Build MVC Applications with Connectivity to Oracle Financials Cloud Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Oracle Financials Cloud from an ASP.NET MVC application.
-
Create Data Visualizations Based On Avalara AvaTax Data in Mode
Use CData Connect AI to connect to Avalara AvaTax Data from Mode and build visualizations using live
-
Build Automated Certinia-Connected Workflows in Zapier
Use CData Connect AI to connect to live Certinia and build automated workflows in Zapier.
-
Visualize Live Oracle SCM Data in the Power BI Service
Use CData Connect AI to connect to live Oracle SCM and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Getting Started with the CData JDBC Driver for Paymo
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Paymo.
-
Automated Continuous CouchDB Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable CouchDB replication to Apache Kafka.
-
Connect to Microsoft Planner Data in RapidMiner
Integrate Microsoft Planner with standard components and data source configuration wizards in RapidMiner Studio.
-
How to Seamlessly Import Google Analytics Data into IBM SPSS Modeler
Integrate Google Analytics data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
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.
-
Query Missive Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Missive from Node.js.
-
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.
-
Automated Continuous ZohoExpense Replication to MySQL
Use CData Sync for automated, continuous, customizable ZohoExpense replication to MySQL.
-
Query Salesforce CRM Analytics Data as a MySQL Database in Node.js
Execute MySQL queries against Salesforce CRM Analytics from Node.js.
-
How to connect and process ElevenLabs from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live ElevenLabs.
-
Integrate SAP BusinessObjects BI Data into Power Automate Desktop using CData Connect
CData Connect for SAP BusinessObjects BI Data enables you to integrate SAP BusinessObjects BI into workflows built using Microsoft Power Automate Desktop.
-
Build Elasticsearch-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Elasticsearch Data and create custom apps in Mendix.
-
Create a Data Access Object for Harvest Data using JDBI
A brief overview of creating a SQL Object API for Harvest in JDBI.
-
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.
-
Consume SendGrid OData Feeds in PowerBuilder
This article demonstrates how to consume SendGrid as OData feeds from PowerBuilder using the API Server.
-
Connect to Outreach.io 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 Outreach.io.
-
Create SSAS Tabular Models from Tavily Data
How to build a SQL Server Analysis Service Tabular Model from Tavily using CData drivers.
-
Work with Live Cassandra Data in Power Query
Use CData Connect AI to connect to Apache Cassandra and work with live Apache Cassandra in Microsoft Power Query.
-
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.
-
Getting Started with the CData JDBC Driver for Mailgun
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Mailgun.
-
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.
-
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.
-
Build Charts with OneNote Data in Clear Analytics
Create dynamic charts and perform analytics based on Microsoft OneNote in Clear Analytics.
-
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.
-
Publish SAP Concur-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live SAP Concur.
-
Extract, Transform, and Load Pipeliner CRM Data in Informatica PowerCenter
Create a simple Workflow for Pipeliner CRM in Informatica PowerCenter.
-
Use Manus AI to Talk to Your Paylocity Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Manus AI agents to securely answer questions and take actions on Paylocity.
-
Connect to Calendly from a Connection Pool in WebLogic
Use the CData JDBC Driver for Calendly to connect to Calendly from Web applications running on WebLogic.
-
How to Connect the Power BI Service to Toggl: Complete Guide
Connect to the CData Software Power BI Connector for Toggl from PowerBI.com to provide real-time Toggl across the organization.
-
Build Apps with Live FHIR in Adalo using CData Connect AI
Use CData Connect AI to integrate live FHIR into the Adalo platform and build custom mobile and web applications with real-time FHIR.
-
Automate iContact Data Replication to Azure Data Lake
Use CData Sync to customize and automate iContact replication to Azure Data Lake.
-
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.
-
Replicate Freshservice Data in Heroku for Use in Salesforce Connect
Replicate Freshservice to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
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.
-
Integrate with Live GitHub Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to GitHub from the MuleSoft Anypoint Platform to integrate live GitHub into custom reports and dashboards.
-
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.
-
Connect to FTP Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for FTP Servers in the Denodo Virtual DataPort Administrator.
-
Automated Nethunt Data Replication to Teradata
Use CData Sync to Customize and automate Nethunt replication to Teradata.
-
Build Hive-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData MCP Server for 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 Kafka Data Replication to Teradata
Use CData Sync to Customize and automate Apache Kafka replication to Teradata.
-
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.
-
Automated Continuous Couchbase Replication to Vertica
Use CData Sync for automated, continuous, customizable Couchbase replication to Vertica.
-
Connect to Placid Data in NetBeans
Connect to Placid in NetBeans with the data source configuration wizard.
-
Connect to ServiceDesk Plus Data from a Connection Pool in Jetty
The ServiceDesk Plus JDBC Driver supports connection pooling: This article shows how to connect faster to ServiceDesk Plus from Web apps in Jetty.
-
Create Apps from Zendesk Data in Qlik Sense Cloud
Use CData Connect AI to connect to Zendesk Data and build apps from live Zendesk in Qlik Sense Cloud.
-
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.
-
Access Presto Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Presto from HeidiSQL.
-
Connecting Agentforce with Act CRM 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 Act CRM for you.
-
Build Supabase-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Supabase and build web apps with connectivity to live Supabase.
-
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.
-
Publish Salesforce Data 360-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Salesforce Data 360.
-
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.
-
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.
-
Load Cassandra Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Apache Cassandra to a database.
-
Connect to and Query Dropbox Data in QlikView over ODBC
Create data visualizations with Dropbox in QlikView.
-
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.