CData Software - Knowledge Base
Recent Articles
-
Use the CData Software JDBC Driver for MarkLogic in MicroStrategy Desktop
Connect to MarkLogic in MicroStrategy Desktop using the CData Software JDBC Driver for MarkLogic.
-
Consume Power BI XMLA OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Power BI XMLA feeds that reflect any changes in SAP Lumira.
-
Automate Tasks in Power Automate Using the CData API Server
Automate Teradata actions in Microsoft Flow — sending emails, posting to social media, or syncing CRM and ERP.
-
Connecting Moonlit Workflow with SharePoint Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Moonlit workflows to securely read and act on your Microsoft SharePoint in real time.
-
Connect to and Visualize Live ZeroBounce Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live ZeroBounce.
-
How to import MariaDB Data into Apache Solr
Use the CData Software JDBC Driver for MariaDB in Data Import Handler and create an automated import of MariaDB to Apache Solr Enterprise Search platform.
-
Work with Oracle SCM Data in FoxPro
Load Oracle SCM into a FoxPro database. This article includes full code and a walk-through of the process.
-
Migrating data from MariaDB to Snowflake using CData SSIS Components.
Easily push MariaDB to Snowflake using the CData SSIS Tasks for MariaDB and Snowflake.
-
How to connect SharePoint with Mistral AI Data through external lists
Provide Mistral AI to SharePoint users as an external list.
-
Connect to Retently Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Retently and the SQL Gateway to access Retently from Google Apps Script.
-
Model, Search, and Visualize Live Marketo Data in ThoughtSpot
Use CData Connect AI to connect to live Marketo for modeling, searching, and visualizing.
-
Explore Geographical Relationships in Customer.io Data with Power Map
Create data visualizations with Customer.io in Power Map.
-
Integrating Codex CLI with Bullhorn CRM 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.
-
Integrate with Excel Online Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Microsoft Excel Online in SnapLogic.
-
Bridge Supabase Connectivity with Apache NiFi
Access and process Supabase in Apache NiFi using the CData JDBC Driver.
-
Create Data Visualizations in Cognos BI with Ontraport Data
Access Ontraport as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Connect to Adobe Analytics Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Adobe Analytics in the Denodo Virtual DataPort Administrator.
-
Integrating Claude Code CLI with Timely 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.
-
Build Visualizations of JotForm Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of JotForm in Birst.
-
Build Voice Agents in ElevenLabs with access to Live CouchDB Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Apache CouchDB.
-
Import Real-Time Presto Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Presto in ColdFusion.
-
Automate Front Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Front from PowerShell? This article demonstrates how to utilize the Front Cmdlets for tasks like connecting to Front, automating operations, downloading data, and more.
-
Process & Analyze MySQL Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live MySQL Data.
-
Build DocuSign-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live DocuSign.
-
Integrate Webex Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Webex from Informatica Cloud.
-
Access Live PayPal Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live PayPal from your Excel spreadsheets.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Postmark
Provide connectivity to Postmark through an SAP BusinessObjects universe.
-
Automate SAP HANA XS Advanced Data Replication to Couchbase
Use CData Sync to Customize and automate SAP HANA XS Advanced replication to Couchbase.
-
Connect to eBay Analytics Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for eBay Analytics in the Denodo Virtual DataPort Administrator.
-
How to Access ShipStation Data Using Entity Framework
This article shows how to access ShipStation using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Access Facebook Ads 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 Facebook Ads.
-
Model Amazon Marketplace Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Amazon Marketplace, enabling the direct import of real-time Amazon Marketplace.
-
Replicate Multiple LightSpeedRetail Accounts via the CData Sync CLI
Replicate multiple LightSpeedRetail accounts to one or many databases.
-
Access Live Postmark Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Postmark into the statistical analysis tools available in SAS JMP. This article shows how to use Postmark in the Graph Builder and Query Builder.
-
Connect to FormSite in SpagoBI
Create reports featuring live FormSite in SpagoBI Studio. Host FormSite reports on SpagoBI Server.
-
Use the CData Software ODBC Driver for Microsoft Ads in MicroStrategy
Connect to Microsoft Ads in MicroStrategy Developer using the CData Software ODBC Driver for Microsoft Ads.
-
Automated Invoiced Data Replication to Teradata
Use CData Sync to Customize and automate Invoiced replication to Teradata.
-
Build MVC Applications with Connectivity to Reckon Accounts Hosted Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Reckon Accounts Hosted from an ASP.NET MVC application.
-
Automate ZohoInvoice Integration Tasks from PowerShell
Are you in search of a quick and easy way to access ZohoInvoice from PowerShell? This article demonstrates how to utilize the ZohoInvoice Cmdlets for tasks like connecting to ZohoInvoice, automating operations, downloading data, and more.
-
Twitter Ads Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Twitter Ads facts in real time.
-
How to create Tavily federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Tavily in MySQL .
-
Visualize CockroachDB Data in TIBCO Spotfire through ADO.NET
Integrate CockroachDB into dashboards in TIBCO Spotfire.
-
Query eBay Data through ODBC in Node.js
Use node-odbc to execute SQL queries against eBay from Node.js.
-
How to Access Live SAP SuccessFactors Data in Visual Studio Code via Cline
Run CData MCP Server for SAP SuccessFactors on Windows Subsytem for Linux (WSL) and connect to live SAP SuccessFactors from the Cline extension in Visual Studio Code.
-
Create SSAS Tabular Models from ADP Data
How to build a SQL Server Analysis Service Tabular Model from ADP using CData drivers.
-
How to create an RPA flow for SFTP Data in UiPath Studio
Use the SFTP ODBC Driver to create workflows that access real-time SFTP without any coding.
-
Create Informatica Mappings From/To a JDBC Data Source for Teamwork
Create Teamwork data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Establish a Live Connection with Redis Data using Tableau Bridge
The CData ODBC Driver for Redis enables you to integrate live Redis into Tableau Cloud dashboards using the Tableau Bridge.
-
Connect to Amazon S3 Data from Crystal Reports
Use CData Connect AI to connect to and report on live Amazon S3 from Crystal Reports.
-
How to Connect SingleStore 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 SingleStore data in real time using natural language.
-
Visualize Grafana Data in Tableau
The CData ODBC driver for Grafana enables you integrate Grafana into Tableau dashboards.
-
How to Query Live Elorus Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Elorus data in natural language using Python.
-
Easily Integrate Templated Data in Lazarus Pascal IDE
Learn how to easily integrate live Templated in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Connect to FTP Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for FTP to connect to FTP Servers and execute queries in PowerBuilder.
-
How to connect to Microsoft OneDrive Data from Spring Boot
Connect to Microsoft OneDrive in a Spring Boot Application using the CData JDBC Driver for Microsoft OneDrive
-
Automated Continuous SAP Replication to AlloyDB
Use CData Sync for automated, continuous, customizable SAP replication to AlloyDB.
-
Connect to Oracle Eloqua Reporting Data from PowerBuilder via ADO.NET
This article demonstrates how to access Oracle Eloqua Reporting from Appeon PowerBuilder using the CData ADO.NET Provider for Oracle Eloqua Reporting.
-
How to create an RPA flow for Freshdesk Data in UiPath Studio
Use the Freshdesk ODBC Driver to create workflows that access real-time Freshdesk without any coding.
-
A PostgreSQL Interface for Slack Data (MySQL Remoting via JDBC)
Use the Remoting features of the Slack JDBC Driver to create a PostgreSQL entry-point for data access.
-
Create SSAS Tabular Models from LDAP Objects
How to build a SQL Server Analysis Service Tabular Model from LDAP using CData drivers.
-
Analyze FHIR Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of FHIR and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed Clio to Power BI dashboards. Simply drag and drop Clio into data visuals on the Power BI canvas.
-
Build SurveyMonkey-Connected Apps in Choreo
Use CData Connect AI to connect to SurveyMonkey Data from Choreo and build custom apps using live SurveyMonkey.
-
Publish Reports with CloudConvert Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date CloudConvert.
-
Automate Zoom Data Replication to SAP HANA
Use CData Sync to customize and automate Zoom replication to SAP HANA.
-
How to Connect the Power BI Service to SageHR: Complete Guide
Connect to the CData Software Power BI Connector for SageHR from PowerBI.com to provide real-time SageHR across the organization.
-
Query Hubstaff Data in DataGrip
Create a Data Source for Hubstaff in DataGrip and use SQL to query live Hubstaff.
-
How to connect to Monday.com Data from Spring Boot
Connect to Monday.com in a Spring Boot Application using the CData JDBC Driver for Monday.com
-
Deploy the ADO.NET Provider for Humanity on an SSRS Report Server
Connect to Humanity 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.
-
Visualize CircleCI 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 CircleCI into TIBCO Spotfire.
-
Build a Singer.io Tap for Humanity With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Humanity data using
-
Use the CData Software ODBC Driver for Vimeo in SAS for Real-Time Reporting and Analytics
Connect to real-time Vimeo in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Vimeo.
-
Create Auth0 Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Auth0 data access from reports, embedded analytics, and more.
-
Integrating Act-On Data in Talend Cloud Data Management Platform
Connect Act-On Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Act-On.
-
Automate Redis Data Replication to Azure Synapse
Use CData Sync to customize and automate Redis replication to Azure Synapse.
-
Automated Continuous FormSite Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable FormSite replication to Apache Kafka.
-
Prepare, Blend, and Analyze Square Data in Alteryx Designer (Connect AI)
Build workflows to access live Square for self-service data analytics.
-
Connect to LeadDesk 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 LeadDesk and work with LeadDesk in your FileMaker application.
-
Create Informatica Mappings From/To a JDBC Data Source for Customer.io
Create Customer.io data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Access BigCommerce Data from MySQL in Amazon QuickSight
Connect to BigCommerce and build visualizations of BigCommerce using a MySQL Connection in Amazon QuickSight.
-
Getting Started with the CData Excel Add-In for Oracle Eloqua
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Oracle Eloqua.
-
Integrating Codex CLI with Tavily 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 HubDB Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable HubDB replication to OneLake in Microsoft Fabric.
-
Operational Reporting on Campaigner Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Campaigner.
-
Load HBase Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Apache HBase to a database.
-
Use CData Connect AI to Access NetSuite SuiteAnalytics Data in Microsoft Power Pivot
Use CData Connect AI to connect to live NetSuite SuiteAnalytics in the Power Pivot business intelligence tool.
-
How to load Teradata data into Elasticsearch via Logstash
Introducing a simple method to load Teradata data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Getting Started with the CData Excel Add-In for SAS Data Sets
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for SAS Data Sets.
-
How to connect to ClickTime Data in DBVisualizer
Integrate ClickTime with visual data analysis tools and data connection wizards in DBVisualizer
-
Automated Continuous Sage Cloud Accounting Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Sage Cloud Accounting replication to Google Cloud SQL.
-
Prepare, Blend, and Analyze SAP HANA Data in Alteryx Designer (ODBC)
Build workflows to access live SAP HANA for self-service data analytics.
-
Connect to Brex Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Brex in the Denodo Virtual DataPort Administrator.
-
Build Neo4J-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Neo4J.
-
Automate Apify Data Replication to Azure Data Lake
Use CData Sync to customize and automate Apify replication to Azure Data Lake.
-
How to Connect to Live Zoho Projects 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 Zoho Projects through natural language.
-
Connect to Smartsheet Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Smartsheet in Airbyte.
-
Use the CData ODBC Driver for FHIR from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for FHIR to connect to FHIR from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring FHIR in Excel.
-
How to Easily Query Supabase Data in OpenOffice Base
Connect to Supabase data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
How to Connect DBeaver to Dynamics 365 via a JDBC Driver
Manage Microsoft Dynamics 365 with visual tools in DBeaver like the query browser.
-
Query Sendwithus Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Sendwithus from Node.js.