CData Software - Knowledge Base
Recent Articles
-
Access Live SurveyMonkey Data in TIBCO Data Virtualization
Use the SurveyMonkey Tibco DV Adapter to create a SurveyMonkey data source in TIBCO Data Virtualization Studio and gain access to live SurveyMonkey from your TDV Server.
-
Excel Spreadsheet Automation on LeadDesk Data with the QUERY Formula
Pull data from LeadDesk, automate spreadsheets, and more with the QUERY formula.
-
Visualize eBay Data in Tableau
The CData ODBC driver for eBay enables you integrate eBay into Tableau dashboards.
-
View Reports on Real-Time Outlook Data in Power BI Report Server
Use the CData ODBC Driver for Outlook to visualize Outlook in Power BI Desktop and then publish them to Power BI Report Server.
-
How to work with BambooHR Data in Apache Spark using SQL
Access and process BambooHR Data in Apache Spark using the CData Software JDBC Driver.
-
Connect to Sugar CRM Data in DBArtisan
Use wizards in DBArtisan to configure Sugar CRM as a data source.
-
Analyze Adobe Commerce Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Adobe Commerce with the CData JDBC Driver for Adobe Commerce.
-
Use Biml to Build SSIS Tasks to Replicate Asana Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Asana to SQL Server.
-
How to Create Power BI Visual Reports with Real-Time Placid Data
Use CData Power BI Connectors to visualize Placid in Power BI.
-
Create Informatica Mappings From/To a JDBC Data Source for Excel Online
Create Excel Online data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Use the CData Software ODBC Driver for Spotify in SAS for Real-Time Reporting and Analytics
Connect to real-time Spotify in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Spotify.
-
Visualize Live Box Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Box using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Access Live Cassandra 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 Apache Cassandra through MCP integration.
-
Object-Relational Mapping (ORM) with Tally 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 Tally ERP into a Java-based ORM framework, Hibernate.
-
Use the CData Software JDBC Driver for Elorus in MicroStrategy Desktop
Connect to Elorus in MicroStrategy Desktop using the CData Software JDBC Driver for Elorus.
-
How to Access Pushbullet Data Using Entity Framework
This article shows how to access Pushbullet using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Publish VWO-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live VWO.
-
How to use SQLAlchemy ORM to access Reckon Accounts Hosted Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Reckon Accounts Hosted.
-
Connect to Salesforce Data in RapidMiner
Integrate Salesforce & Force.com with standard components and data source configuration wizards in RapidMiner Studio.
-
Connect to Microsoft OneDrive Data from a Connection Pool in JBoss
Integrate Microsoft OneDrive into Java servlets: Use the Management Console in JBoss to install the Microsoft OneDrive JDBC Driver.
-
Integrate with Adobe Analytics Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Adobe Analytics in SnapLogic.
-
Connect to Jira Assets Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Jira Assets as an External Source in Dremio.
-
Work with FHIR Data in FoxPro
Load FHIR into a FoxPro database. This article includes full code and a walk-through of the process.
-
Automated Continuous Zoho Projects Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Zoho Projects replication to delimited files (CSV/TSV).
-
Use Grok to Talk to Your LinkedIn Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Grok AI to securely answer questions and take actions on your LinkedIn for you.
-
Establish a Live Connection with Access Data using Tableau Bridge
The CData ODBC Driver for Access enables you to integrate live Microsoft Access into Tableau Cloud dashboards using the Tableau Bridge.
-
Publish Impala-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Apache Impala.
-
Integrating Gumloop with MariaDB Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on MariaDB within automated workflows.
-
Integrating Claude Code with Epicor Kinetic Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Epicor Kinetic within assisted coding and automated development workflows.
-
Automated Continuous SuiteCRM Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable SuiteCRM replication to Apache Cassandra.
-
Create Google Spanner-Connected Applications in Appsmith
Connect to Google Spanner Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Google Spanner.
-
Visualize Outreach.io Data in Tableau
The CData ODBC driver for Outreach.io enables you integrate Outreach.io into Tableau dashboards.
-
Replicate Campaigner Data to Multiple Databases
Replicate Campaigner to disparate databases with a point-and-click configuration.
-
Connect to Parquet Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Apache Parquet in the Denodo Virtual DataPort Administrator.
-
Access Billsby Data from MySQL in Amazon QuickSight
Connect to Billsby and build visualizations of Billsby using a MySQL Connection in Amazon QuickSight.
-
Prepare, Blend, and Analyze SendGrid Data in Alteryx Designer (ODBC)
Build workflows to access live SendGrid for self-service data analytics.
-
How to Connect to Live SAP BusinessObjects BI Data in n8n Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable n8n to securely read and take actions on your SAP BusinessObjects BI for you.
-
Visualize Live DB2 Data in the Power BI Service
Use CData Connect AI to connect to live IBM DB2 and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Natively Connect to SAP ByDesign Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to SAP Business ByDesign. Leverage the native support for ODBC in PHP.
-
Import Real-Time CampaignMonitor Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use CampaignMonitor in ColdFusion.
-
Connect Pingdom to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Pingdom using the CData Python MCP Server.
-
Connect to SendGrid Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for SendGrid and the SQL Gateway to access SendGrid from Google Apps Script.
-
Connecting Mastra with Apollo 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 Apollo, no replication required.
-
Automated Continuous HubDB Replication to Oracle
Use CData Sync for automated, continuous, customizable HubDB replication to Oracle.
-
Connect to MariaDB Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for MariaDB.
-
Migrating data from Google Directory to Databricks using CData SSIS Components.
Easily push Google Directory to Databricks using the CData SSIS Tasks for Google Directory and Databricks.
-
Build DB2-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to DB2 Data from Zoho Analytics and import live IBM DB2.
-
Connect Rebilly to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Rebilly with IBM WebSphere for seamless data integration and connectivity.
-
Use the CData Software ODBC Driver for Bitbucket in MicroStrategy Desktop
Connect to Bitbucket in MicroStrategy Desktop using the CData Software ODBC Driver for Bitbucket.
-
Integrating Claude Code CLI with Gmail 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.
-
Connect to Cassandra Data from a Connection Pool in JBoss
Integrate Apache Cassandra into Java servlets: Use the Management Console in JBoss to install the Cassandra JDBC Driver.
-
Use Grok to Talk to Your Splunk Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Grok AI to securely answer questions and take actions on your Splunk for you.
-
Access Zoom 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 Zoom.
-
Create Reports with Mocean Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Mocean.
-
Create eBay-Connected Applications in Appsmith
Connect to eBay Data via CData Connect AI in Appsmith and create custom business applications with real-time access to eBay.
-
Build an OLAP Cube in SSAS from PolarTeamPro Data
Establish a connection to PolarTeamPro data from SQL Server Analysis Services, and use the PolarTeamPro Data Provider to build OLAP cubes for use in analytics and reporting.
-
How to Connect Odoo Data to Gemini Enterprise via CData Connect AI
Connect CData Connect AI Remote MCP to Gemini Enterprise to securely read and take actions on live Odoo data in real time using natural language.
-
Query CockroachDB Data as a SQL Server Database in Node.js
Execute SQL Server queries against CockroachDB from Node.js.
-
Replicate Autopilot Data to Multiple Databases via the CData Sync CLI
Replicate Autopilot to disparate databases with a single configuration.
-
How to integrate Pinecone with Apache Airflow
Access and process Pinecone in Apache Airflow using the CData JDBC Driver.
-
Build Dashboards with HBase Data in Dundas BI
Create dynamic dashboards and perform analytics based on Apache HBase in Dundas BI.
-
Automated Continuous Stripe Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Stripe replication to OneLake in Microsoft Fabric.
-
Extract, Transform, and Load Moosend Data in Informatica PowerCenter
Create a simple Workflow for Moosend in Informatica PowerCenter.
-
Integrate Superchat with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Superchat with External Services.
-
Build Google Ads-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Google Ads Data and create custom apps in Bubble.
-
Connect to Figshare Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Figshare.
-
Publish Crystal Reports on ServiceNow Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date ServiceNow.
-
Access Live MailChimp Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live MailChimp from your Excel spreadsheets.
-
Analyze ShipEngine Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze ShipEngine with the CData JDBC Driver for ShipEngine.
-
HubSpot Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on HubSpot facts in real time.
-
How to Use a Microsoft Access Database to Update BigCommerce Data in Real Time
Update BigCommerce data by creating a linked table in Microsoft Access with the CData BigCommerce ODBC Driver.
-
Migrating data from WordPress to Google BigQuery using CData SSIS Components.
Easily push WordPress to Google BigQuery using the CData SSIS Tasks for WordPress and Google BigQuery.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live ServiceNow within intelligent workflows.
-
Connect to GitLab Data in HULFT Integrate
Connect to GitLab as a JDBC data source in HULFT Integrate
-
Use Claude to Talk to Your Oracle Eloqua Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your Oracle Eloqua for you.
-
Access DocuSign Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access DocuSign from your Oracle system.
-
How to Connect the Power BI Service to Front: Complete Guide
Connect to the CData Software Power BI Connector for Front from PowerBI.com to provide real-time Front across the organization.
-
Visualize Microsoft Teams 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 Microsoft Teams into TIBCO Spotfire.
-
How to integrate Microsoft Dataverse with Apache Airflow
Access and process Microsoft Dataverse (CDS) in Apache Airflow using the CData JDBC Driver.
-
Use CData Connect AI to Access HCL Domino Data in Microsoft Power Pivot
Use CData Connect AI to connect to live HCL Domino in the Power Pivot business intelligence tool.
-
Visualize Oracle Financials Cloud Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Oracle Financials Cloud.
-
Connect to ConvertKit Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for ConvertKit to connect to ConvertKit and execute queries in PowerBuilder.
-
Choosing the Best Method to Connect SAP Netweaver Gateway to SQL Server: 5 Options Explained
Discover multiple ways to connect and use SAP Netweaver Gateway from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Connect Yelp to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Yelp using the CData Python MCP Server.
-
Create Perigon Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Perigon data access from reports, embedded analytics, and more.
-
How to connect to SAP Business Warehouse Data in DBVisualizer
Integrate SAP Business Warehouse with visual data analysis tools and data connection wizards in DBVisualizer
-
Create a Data Access Object for Zoho Inventory Data using JDBI
A brief overview of creating a SQL Object API for Zoho Inventory in JDBI.
-
Build Procore-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Procore and build web apps with connectivity to live Procore.
-
How to Connect to Live Impala 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 Apache Impala without replication.
-
Build an OLAP Cube in SSAS from Hubstaff Data
Establish a connection to Hubstaff data from SQL Server Analysis Services, and use the Hubstaff Data Provider to build OLAP cubes for use in analytics and reporting.
-
Connect to LaunchDarkly Data in JRuby
Create a simple JRuby app with access to live LaunchDarkly.
-
Create Reports with Facebook Ads Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Facebook Ads.
-
Connect to Power BI XMLA Data in Aqua Data Studio
Access Power BI XMLA from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Access Paylocity 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 Paylocity.
-
Access Live Bullhorn CRM Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Bullhorn CRM from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Automate Cloudant Data Replication to Azure Synapse
Use CData Sync to customize and automate IBM Cloudant replication to Azure Synapse.
-
Build Apps with Live CSV/TSV Files in Adalo using CData Connect AI
Use CData Connect AI to integrate live CSV/TSV Files into the Adalo platform and build custom mobile and web applications with real-time CSV/TSV Files.
-
Connect to and Query Vault CRM Data in QlikView over ODBC
Create data visualizations with Veeva Vault & Vault CRM in QlikView.
-
Query SAP Concur Data through ODBC in Node.js
Use node-odbc to execute SQL queries against SAP Concur from Node.js.
-
How to Access Live CapsuleCRM Data in Power Automate Desktop via ODBC
The CData ODBC Driver for CapsuleCRM enables you to integrate CapsuleCRM into workflows built using Microsoft Power Automate Desktop.