CData Software - Knowledge Base
Recent Articles
-
Databricks Reporting in OBIEE with the Databricks JDBC Driver
Deploy the Databricks JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Bridge LinkedIn Connectivity with Apache NiFi
Access and process LinkedIn in Apache NiFi using the CData JDBC Driver.
-
Integrating Claude Code CLI with Amplitude 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.
-
Automated Continuous Samanage Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Samanage replication to OneLake in Microsoft Fabric.
-
Connect to SAP HANA Data in HULFT Integrate
Connect to SAP HANA as a JDBC data source in HULFT Integrate
-
Automated Continuous Google Contacts Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Google Contacts replication to Apache Kafka.
-
Build Shopify-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Shopify.
-
Use CData Connect AI to Access Epicor Kinetic Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Epicor Kinetic in the Power Pivot business intelligence tool.
-
Integrating LangChain with MariaDB Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on MariaDB within automated workflows.
-
Connect ZohoExpense Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your ZohoExpense using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Query ConstantContact Data through ODBC in Node.js
Use node-odbc to execute SQL queries against ConstantContact from Node.js.
-
Explore Geographical Relationships in WooCommerce Data with Power Map
Create data visualizations with WooCommerce in Power Map.
-
Getting Started with the CData JDBC Driver for FHIR
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for FHIR.
-
Viewing Aircall Data in RAD Studio Data Explorer
How to view Aircall in RAD Studio Data Explorer using the CData ODBC Driver for Aircall.
-
Configure the CData JDBC Driver for Instagram in a Connection Pool in Tomcat
Connect to Instagram from a connection pool in Tomcat.
-
Build Visualizations of Brex Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Brex in Birst.
-
How to create an RPA flow for Paddle Data in UiPath Studio
Use the Paddle ODBC Driver to create workflows that access real-time Paddle without any coding.
-
How to Connect DBeaver to Gmail via a JDBC Driver
Manage Gmail with visual tools in DBeaver like the query browser.
-
eBay Analytics Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on eBay Analytics facts in real time.
-
Import Real-Time Hacker News Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Hacker News in ColdFusion.
-
Bidirectional Access to Discord Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Discord in Filemaker Pro for Mac or Windows.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed Apache CouchDB to Power BI dashboards. Simply drag and drop Apache CouchDB into data visuals on the Power BI canvas.
-
How to Query Live Neo4J Data in Claude Desktop
Connect to and query live Neo4J Data in Claude Desktop using CData MCP Server.
-
Create Informatica Mappings From/To a JDBC Data Source for Zoho Recruit
Create Zoho Recruit data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Extract, Transform, and Load Workable Data in Informatica PowerCenter
Create a simple Workflow for Workable in Informatica PowerCenter.
-
Model Redis Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Redis, enabling the direct import of real-time Redis.
-
Automated Continuous ConstantContact Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable ConstantContact replication to Apache Kafka.
-
Connect to Azure Synapse from Asprova with CData Software ODBC Driver for Azure Synapse
This article shows how to connect faster to Azure Synapse data from Asprova.
-
How to Connect to & Open Contentful Data in Microsoft Excel
This article uses the CData ODBC driver for Contentful to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Connect to Zoom Data from PowerBuilder via JDBC
This article demonstrates how to access Zoom from PowerBuilder using the Zoom JDBC Driver.
-
Build Vault CRM-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Vault CRM Data from Zoho Analytics and import live Veeva Vault & Vault CRM.
-
Automate Vault CRM Data Replication to SAP HANA
Use CData Sync to customize and automate Veeva Vault & Vault CRM replication to SAP HANA.
-
Integrating GitHub Copilot CLI with Zoho Books 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.
-
Access Live Apollo Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Apollo from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Connect MySQL Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your MySQL using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Visualize CloudConvert Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to CloudConvert.
-
How to Connect to Live Quickbase Data from OpenAI Python Applications (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable OpenAI-powered Python applications to securely read and take actions on your Quickbase through natural language.
-
Connecting Mastra with Salesforce 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 Salesforce & Force.com, no replication required.
-
Integrate with live Dynamics 365 Business Central Data in Jitterbit
Use CData Connect AI to connect to and integrate live Dynamics 365 Business Central in Jitterbit.
-
Query TaxJar Data through ODBC in Node.js
Use node-odbc to execute SQL queries against TaxJar from Node.js.
-
Import Real-Time FormSite Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use FormSite in ColdFusion.
-
Automate Gorgias Data Replication to Couchbase
Use CData Sync to Customize and automate Gorgias replication to Couchbase.
-
Automated Continuous Marketo Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Marketo replication to Google Cloud SQL.
-
Use ChatGPT to Talk to Your Act CRM Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable ChatGPT to securely answer questions and take actions on your Act CRM for you.
-
Query MailerSend Data as a MySQL Database in Node.js
Execute MySQL queries against MailerSend from Node.js.
-
Natively Connect to Perigon Data in PHP
The CData ODBC driver for Perigon enables you to create PHP applications with connectivity to Perigon. Leverage the native support for ODBC in PHP.
-
Create Reports with NetSuite Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date NetSuite CRM & ERP.
-
Connect to Smartsheet Data in DBArtisan
Use wizards in DBArtisan to configure Smartsheet as a data source.
-
Use the CData Software JDBC Driver for Recurly in MicroStrategy Desktop
Connect to Recurly in MicroStrategy Desktop using the CData Software JDBC Driver for Recurly.
-
Connect Square Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Square using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
How to Connect to Live Shopify 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 Shopify for you.
-
How to Create Power BI Visual Reports with Real-Time Mixpanel Data
Use CData Power BI Connectors to visualize Mixpanel in Power BI.
-
Bind Live LDAP Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live LDAP data
-
Analyze Pipedrive Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Pipedrive from Power Pivot. You will use the Table Import Wizard to load Pipedrive. You can visually build the import query or use any SQL supported by the driver.
-
Automated Continuous Google Calendar Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Google Calendar replication to delimited files (CSV/TSV).
-
Load Cvent Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Cvent to a database.
-
How to Access SageHR Data Using Entity Framework
This article shows how to access SageHR using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Connect to Live Basecamp Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Basecamp in CData Connect AI and connect to your Basecamp from PostgreSQL.
-
Getting Started with the CData Excel Add-In for Grafana
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Grafana.
-
Getting Started with the CData ODBC Driver for Wistia
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Wistia.
-
Connect to ServiceNow Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for ServiceNow to connect to ServiceNow and execute queries in PowerBuilder.
-
Automated Continuous PostgreSQL Replication to MySQL
Use CData Sync for automated, continuous, customizable PostgreSQL replication to MySQL.
-
Provide OData Services of Google Directory Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Google Directory by developing a WCF Service Application.
-
Prepare, Blend, and Analyze Exact Online Data in Alteryx Designer (ODBC)
Build workflows to access live Exact Online for self-service data analytics.
-
Connect to Egnyte Data from PowerBuilder via JDBC
This article demonstrates how to access Egnyte from PowerBuilder using the Egnyte JDBC Driver.
-
Edit and Search External Azure Table Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Azure Table Storage to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Azure Table Data objects that you can access from apps and the dashboard.
-
Analyze Google Contacts Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Google Contacts and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Build Azure Analysis Services-Powered Applications in Gemini Code Assist with CData MCP Server
Use the CData MCP Server for Azure Analysis Services to explore live Azure Analysis Services Data in Gemini Code Assist to assist with building Azure Analysis Services-powered applications.
-
Use JayDeBeApi to access BambooHR Data in Python
Use standard Python scripting and the development environment of your choice to access live BambooHR.
-
Query Azure Table Data in ColdFusion
Write standard ColdFusion data access code to connect to Azure Table Storage.
-
Integrate Live Email Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Email from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Email.
-
Connect to Spotify Data in RapidMiner
Integrate Spotify with standard components and data source configuration wizards in RapidMiner Studio.
-
Build Dashboards with Humanity Data in DBxtra
Create dynamic dashboards and perform analytics based on Humanity in DBxtra.
-
Publish Zuora-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Zuora.
-
Use Dash to Build to Web Apps on Mocean Data
Create Python applications that use pandas and Dash to build Mocean-connected web apps.
-
Connecting Agentforce with Oracle HCM Cloud 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 Oracle HCM Cloud for you.
-
Connect to SAP ByDesign Data in Jaspersoft Studio
Execute SQL to remote SAP Business ByDesign in Jaspersoft Studio.
-
Migrating data from Planio to Google BigQuery using CData SSIS Components.
Easily push Planio to Google BigQuery using the CData SSIS Tasks for Planio and Google BigQuery.
-
Use the CData API Server to Access MySQL Data in Microsoft PowerPivot
Use the CData API Server to connect to live MySQL in the Power Pivot business intelligence tool.
-
Automate Microsoft Teams Data Replication to SAP HANA
Use CData Sync to customize and automate Microsoft Teams replication to SAP HANA.
-
Build an OLAP Cube in SSAS from SendInBlue Data
Establish a connection to SendInBlue data from SQL Server Analysis Services, and use the SendInBlue Data Provider to build OLAP cubes for use in analytics and reporting.
-
Connect to SAP Ariba Source Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for SAP Ariba Source and the Script function in FileMaker Pro to connect to SAP Ariba Source and work with SAP Ariba Source in your FileMaker application.
-
Use the CData Software JDBC Driver for Cosmos DB in MicroStrategy
Connect to Azure Cosmos DB in MicroStrategy Developer using the CData Software JDBC Driver for Cosmos DB.
-
Visualize Adobe Target Data in TIBCO Spotfire through OData
Integrate Adobe Target into dashboards in TIBCO Spotfire.
-
Use the CData ODBC Driver for CockroachDB from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for CockroachDB to connect to CockroachDB from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring CockroachDB in Excel.
-
Automated Continuous IBM Cloud Object Storage Replication to Snowflake
Use CData Sync for automated, continuous, customizable IBM Cloud Object Storage replication to Snowflake.
-
Use Microsoft Copilot Studio to talk to your Microsoft Exchange Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Microsoft Copilot Studio to securely answer questions and take actions on your Microsoft Exchange for you.
-
How to Access Live SFTP Data in Power Automate Desktop via ODBC
The CData ODBC Driver for SFTP enables you to integrate SFTP into workflows built using Microsoft Power Automate Desktop.
-
Model SAP Ariba Procurement Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and SAP Ariba Procurement, enabling the direct import of real-time SAP Ariba Procurement.
-
Working with ZohoSubscriptions Data in LINQPad
Execute LINQ queries to ZohoSubscriptions in LINQPad.
-
Connect to Drift from a Connection Pool in WebLogic
Use the CData JDBC Driver for Drift to connect to Drift from Web applications running on WebLogic.
-
Integrating LangChain with Google Sheets Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Google Sheets within automated workflows.
-
How to Query Live Facebook Data in Perplexity MacOS Desktop
Connect to and query live Facebook Data in Perplexity Desktop using CData MCP Server.
-
Access Live Mixpanel Data in Coginiti Pro
Connect to and query live Mixpanel from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Access Live Grafana Data in AWS Lambda
Connect to live Grafana in AWS Lambda using the CData JDBC Driver.
-
Integrate with Notion Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Notion to a JSON file on disk.
-
Connect to Unbounce Data in Aqua Data Studio
Access Unbounce from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
How to work with Quickbase Data in Apache Spark using SQL
Access and process Quickbase Data in Apache Spark using the CData Software JDBC Driver.
-
How to Seamlessly Import Opsgenie Data into IBM SPSS Modeler
Integrate Opsgenie data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Prepare, Blend, and Analyze SendPulse Data in Alteryx Designer (ODBC)
Build workflows to access live SendPulse for self-service data analytics.