CData Software - Knowledge Base
Recent Articles
-
Create Microsoft Entra ID Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Microsoft Entra ID data access from reports, embedded analytics, and more.
-
Integrate SparkPost Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live SparkPost data from Informatica Cloud.
-
Getting Started with the CData JDBC Driver for Paddle
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Paddle.
-
Automated Continuous Sage 300 Replication to Vertica
Use CData Sync for automated, continuous, customizable Sage 300 replication to Vertica.
-
How to create Bullhorn CRM federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Bullhorn CRM data in MySQL .
-
Suadeo Reporting in OBIEE with the Suadeo JDBC Driver
Deploy the Suadeo JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Prepare, Blend, and Analyze Authorize.Net Data in Alteryx Designer (Connect AI)
Build workflows to access live Authorize.Net data for self-service data analytics.
-
Bind Live Sage 200 Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Sage 200 data and seamlessly connect and bind them to Wijmo's FlexGrid for real-time, interactive data access without manual data movement.
-
Build MVC Applications with Connectivity to Act CRM Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Act CRM from an ASP.NET MVC application.
-
Create Power BI Reports on Real-Time Paddle Data
Use the CData ODBC Driver for Paddle to visualize Paddle data in Power BI Desktop.
-
Interact with Live Pinterest Data in Meta Muse via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Muse to securely interact with live Pinterest data.
-
Connect to FHIR Data in NetBeans
Connect to FHIR data in NetBeans with the data source configuration wizard.
-
Build a Singer.io Tap for Optimizely With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Optimizely data using the CData Python Connector.
-
Connect to ZohoMarketingHub Data from Crystal Reports
Use CData Connect AI to connect to and report on live ZohoMarketingHub data from Crystal Reports.
-
How to load SendInBlue data into Elasticsearch via Logstash
Introducing a simple method to load SendInBlue data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Visualize Live HCL Domino Data in the Power BI Service
Use CData Connect AI to connect to live HCL Domino data and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Access Trello Data from MySQL in Amazon QuickSight
Connect to Trello and build visualizations of Trello data using a MySQL Connection in Amazon QuickSight.
-
Connect to Sybase IQ Data in RapidMiner
Integrate Sybase IQ data with standard components and data source configuration wizards in RapidMiner Studio.
-
Build a PostgreSQL Interface for Google Sheets Data using the CData JDBC Driver
Use the Remoting features of the Google Sheets JDBC Driver to create a PostgreSQL entry-point for data access.
-
How to create an RPA flow for Accelo Data in UiPath Studio
Use the Accelo ODBC Driver to create workflows that access real-time Accelo data without any coding.
-
How to create Mouseflow federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Mouseflow data in MySQL .
-
Integrate with HelloSign Data in JReport Designer
Create charts and reports based on HelloSign data in JReport Designer.
-
Connect to Real-Time ZohoDesk Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use ZohoDesk data in Power Apps.
-
Connect to SAP Ariba Procurement Data in JRuby
Create a simple JRuby app with access to live SAP Ariba Procurement data.
-
Integrate Theia IDE with Live Amazon Athena Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE's built-in AI agents to securely access and query live Amazon Athena data from within the development environment.
-
Connect to Act-On Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Act-On and the Script function in FileMaker Pro to connect to Act-On and work with Act-On data in your FileMaker application.
-
Analyze Todoist Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Todoist data with the CData JDBC Driver for Todoist.
-
Connect to Cassandra Data in RazorSQL
Connect to Cassandra from wizards and query Cassandra data from the GUI in the RazorSQL database management tool.
-
Excel Spreadsheet Automation on Twilio Data with the QUERY Formula
Pull data from Twilio, automate spreadsheets, and more with the QUERY formula.
-
Validate Teradata Data with QuerySurge
Access and validate Teradata data in QuerySurge using the CData JDBC Driver.
-
Use the CData Software ODBC Driver for HubDB in MicroStrategy
Connect to HubDB data in MicroStrategy Developer using the CData Software ODBC Driver for HubDB.
-
Create MySQL Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time MySQL data access from reports, embedded analytics, and more.
-
Integrate Cline with Live Redshift Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Redshift data from within your IDE.
-
Prepare, Blend, and Analyze Splunk Data in Alteryx Designer (ODBC)
Build workflows to access live Splunk data for self-service data analytics.
-
Visualize Live Greenhouse Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Greenhouse data into custom reports in Power BI.
-
Work with Live Facebook Ads Data in Power Query
Use CData Connect AI to connect to Facebook Ads data and work with live Facebook Ads data in Microsoft Power Query.
-
Operational Reporting on Outreach.io Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Outreach.io data.
-
Import Real-Time Placid Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Placid data in ColdFusion.
-
Integrating LangGraph with Bright Data Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Bright Data data within automated workflows.
-
Access HDFS 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 HDFS data.
-
Visualize Live ZohoInvoice Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live ZohoInvoice data into custom reports in Power BI.
-
Use Manus AI to Talk to Your Excel Online 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 Excel Online data.
-
Connect to Vault CRM Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Vault CRM data.
-
Integrating OpenCode with FreeAgent 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.
-
Visualize Mode Data in Tableau
The CData ODBC driver for Mode enables you integrate Mode data into Tableau dashboards.
-
Query HCL Domino Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume HCL Domino entities in PHP by modeling them as objects.
-
Connect to QuickBooks Online Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for QuickBooks Online and the Script function in FileMaker Pro to connect to QuickBooks Online and work with QuickBooks Online data in your FileMaker application.
-
Integrating LlamaIndex with SendGrid Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on SendGrid data in real time.
-
Build Charts with Anaplan Data in Clear Analytics
Create dynamic charts and perform analytics based on Anaplan data in Clear Analytics.
-
Connect to and Query EmailOctopus Data in QlikView over ODBC
Create data visualizations with EmailOctopus data in QlikView.
-
Extract, Transform, and Load OneNote Data in Informatica PowerCenter
Create a simple Workflow for OneNote data in Informatica PowerCenter.
-
Visualize Bitbucket Data in Tableau
The CData ODBC driver for Bitbucket enables you integrate Bitbucket data into Tableau dashboards.
-
Create Informatica Mappings From/To an ODBC Data Source for CapsuleCRM
Create an ODBC connection to CapsuleCRM in Informatica and browse and transfer CapsuleCRM data.
-
How to create Impala federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Impala data in MySQL .
-
Getting Started with the CData Tableau Connector for ChartMogul
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Connect to Notion 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 Notion data.
-
How to connect to Procore Data from Spring Boot
Connect to Procore in a Spring Boot Application using the CData API Driver for JDBC
-
Query Live WordPress Data in Perplexity Desktop via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Perplexity Desktop to securely access and query live WordPress data through a conversational interface.
-
Create SSAS Tabular Models from WooCommerce Data
How to build a SQL Server Analysis Service Tabular Model from WooCommerce data using CData drivers.
-
A PostgreSQL Interface for Hive Data (MySQL Remoting via JDBC)
Use the Remoting features of the Hive JDBC Driver to create a PostgreSQL entry-point for data access.
-
Zuora Reporting in OBIEE with the Zuora JDBC Driver
Deploy the Zuora JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Connect to Sage Intacct Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Sage Intacct data.
-
Connecting Pipedream with Guru Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Pipedream workflows to securely read and take actions on Guru data in real time.
-
Getting Started with the CData ADO.NET Provider for Copper
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Access Live Cloudant Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Cloudant data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
How to create an RPA flow for Splunk Data in UiPath Studio
Use the Splunk ODBC Driver to create workflows that access real-time Splunk data without any coding.
-
Query Nuclia Data in DataGrip
Create a Data Source for Nuclia in DataGrip and use SQL to query live Nuclia data.
-
Access Live Reckon Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Reckon data from your Excel spreadsheets.
-
Build Visualizations of Discord Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Discord data in Birst.
-
Integrate Elorus Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Elorus data from Informatica Cloud.
-
How to connect and process eBay data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live eBay data.
-
Connect to Amplitude Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to Amplitude.
-
Migrating data from Kintone to Snowflake using CData SSIS Components.
Easily push Kintone data to Snowflake using the CData SSIS Tasks for Kintone and Snowflake.
-
Access Live Oracle SCM Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Oracle SCM data from your Excel spreadsheets.
-
How to Connect to MailerLite Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to MailerLite data. Leverage the pyodbc module for ODBC in Python.
-
How to import Microsoft Exchange Data into Apache Solr
Use the CData Software JDBC Driver for Microsoft Exchange in Data Import Handler and create an automated import of Microsoft Exchange data to Apache Solr Enterprise Search platform.
-
How to Connect DBeaver to Shortcut via a JDBC Driver
Manage Shortcut data with visual tools in DBeaver like the query browser.
-
Automated Continuous Samanage Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Samanage replication to Google Cloud SQL.
-
A PostgreSQL Interface for Sendwithus Data using the CData ODBC Driver
Use the SQL Gateway and Sendwithus ODBC Driver to create a PostgreSQL entry-point for data access.
-
How to Query Blackbaud FE NXT Data in MySQL Workbench
Execute MySQL queries against live Blackbaud FE NXT data from MySQL Workbench.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Mistral AI
Provide connectivity to Mistral AI data through an SAP BusinessObjects universe.
-
Connect LinkedIn Ads to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live LinkedIn Ads data using the CData Python MCP Server.
-
Operational Reporting on Pinecone Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Pinecone data.
-
Publish Couchbase-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Couchbase data.
-
Integrate with Live Couchbase Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Couchbase from the MuleSoft Anypoint Platform to integrate live Couchbase data into custom reports and dashboards.
-
Connect to MailerLite Data in RapidMiner
Integrate MailerLite data with standard components and data source configuration wizards in RapidMiner Studio.
-
How to use SQLAlchemy ORM to access Spotify Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Spotify data.
-
Build Pipelines with Live Google Ad Manager Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Google Ad Manager from Google Cloud Data Fusion, enabling the integration of live Google Ad Manager data into the building and management of effective data pipelines.
-
Connect to Live Highrise Data in MicroStrategy through CData Connect AI
Create a live connection to Highrise Data in CData Connect AI and connect to your Highrise data from MicroStrategy.
-
Excel Spreadsheet Automation on Office 365 Data with the QUERY Formula
Pull data from Office 365, automate spreadsheets, and more with the QUERY formula.
-
Visualize Live Raisers Edge NXT Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Raisers Edge NXT data.
-
Automated Continuous QuickBooks Online Replication to Amazon S3
Use CData Sync for automated, continuous, customizable QuickBooks Online replication to Amazon S3.
-
Automated Continuous Access Replication to Vertica
Use CData Sync for automated, continuous, customizable Access replication to Vertica.
-
Connect to Cassandra Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Cassandra data in the Denodo Virtual DataPort Administrator.
-
Create a Data Access Object for PhantomBuster Data using JDBI
A brief overview of creating a SQL Object API for PhantomBuster data in JDBI.
-
Build Gmail Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Gmail data and build visualizations in Tableau Cloud.
-
Getting Started with the CData Tableau Connector for Contentful
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Use the CData ODBC Driver for Drip in Microsoft Power Query
You can use the CData Drip ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Drip data into Microsoft Power Query.
-
Add Adobe Target Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Adobe Target with the Informatica Enterprise Data Catalog to classify and organize data.
-
Use Manus AI to Talk to Your Quickbase 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 Quickbase data.