CData Software - Knowledge Base
Recent Articles
-
Bridge Google Contacts Connectivity with Apache NiFi
Access and process Google Contacts data in Apache NiFi using the CData JDBC Driver.
-
How to Connect to Live HBase 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 HBase data for you.
-
Use the CData Software JDBC Driver for QuickBooks Online in MicroStrategy Web
Connect to QuickBooks Online data in MicroStrategy Web using the CData Software JDBC Driver for QuickBooks Online.
-
How to Easily Query SAP ByDesign Data in OpenOffice Base
Connect to SAP ByDesign data in OpenOffice Base using the CData ODBC Driver for SAP ByDesign and generate reports with live data insights.
-
Connect to Autopilot Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Autopilot data.
-
How to connect SharePoint with SAP Concur Data through external lists
Provide SAP Concur data to SharePoint users as an external list.
-
Integrate Live Anaplan Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Anaplan from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Anaplan data.
-
Build AdRoll-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to AdRoll data and build web apps with connectivity to live AdRoll data.
-
Connect to AlloyDB Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live AlloyDB data from Filemaker Pro on Mac.
-
Import and Visualize Freshservice Data in Power View
Create data visualizations based on Freshservice data in Excel.
-
Query Jira Data in DataGrip
Create a Data Source for Jira in DataGrip and use SQL to query live Jira data.
-
Automate Bitly Data Replication to SAP HANA
Use CData Sync to customize and automate Bitly data replication to SAP HANA.
-
Integrate LibreChat with Live Marketo Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Marketo data from within the chat interface.
-
Explore Geographical Relationships in Oracle Data with Power Map
Create data visualizations with Oracle data in Power Map.
-
Integrate Google's Antigravity Agent with Live Salesforce Data 360 Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Salesforce Data 360 data using the Model Context Protocol.
-
Automated Continuous SAP HANA Replication to Oracle
Use CData Sync for automated, continuous, customizable SAP HANA replication to Oracle.
-
Connect and Query Live Apollo Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Apollo data into Databricks and enable direct, live querying and analysis without replication.
-
Create Dynamic Grafana Grids Using the Infragistics XamDataGrid
Learn how you can connect Grafana to Infragistics XamDataGrid to build dynamic grids.
-
Build Visualizations of SAP HANA Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of SAP HANA data in Birst.
-
Viewing Google Drive Data in RAD Studio Data Explorer
How to view Google Drive data in RAD Studio Data Explorer using the CData ODBC Driver for Google Drive.
-
Integrating Vimeo Data in Talend Cloud Data Management Platform
Connect Vimeo Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Import Real-Time SAP Netweaver Gateway Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use SAP Netweaver Gateway data in ColdFusion.
-
Integrate Live Jumpseller Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Jumpseller data to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Connect to Bright Data Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Bright Data and the SQL Gateway to access Bright Data data from Google Apps Script.
-
How to Connect to Live Cassandra Data from crewAI Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable crewAI agents to securely read and take actions on your Cassandra data for you.
-
Access Live Mailjet Data in Coginiti Pro
Connect to and query live Mailjet data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Integrate Google's Antigravity Agent with Live Sendwithus Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Sendwithus data using the Model Context Protocol.
-
Connect to Reckon Data in CloverDX (formerly CloverETL)
Transfer Reckon data using the visual workflow in the CloverDX data integration tool.
-
Load Aweber Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Aweber data to a database.
-
Integrating GitHub Copilot with Hacker News 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.
-
How to Work with Freshservice Data in AWS Glue Jobs Using JDBC
Connect to Freshservice from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Visualize Live Facebook Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Facebook data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Stream Planio Data into Apache Kafka Topics
Access and stream Planio data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
How to Visualize Dropbox Data in Python with pandas
Use pandas and other modules to analyze and visualize live Dropbox data in Python.
-
Integrate Dify with Live Google Forms Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Dify agents and workflows to securely access and query live Google Forms data.
-
How to Connect to Live EnterpriseDB Data in Mistral AI Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live EnterpriseDB data without replication.
-
How to use SQLAlchemy ORM to access Klipfolio Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Klipfolio data.
-
Query Suadeo Data as a SQL Server Database in Node.js
Execute SQL Server queries against Suadeo data from Node.js.
-
Integrate Google's Antigravity Agent with Live Zoom Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Zoom data using the Model Context Protocol.
-
Integrate with ZohoInvoice Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy ZohoInvoice data to a JSON file on disk.
-
How to publish and share QuickBooks Online Data dashboards with Tableau Server
The CData ODBC driver for QuickBooks Online enables you integrate QuickBooks Online data into Tableau dashboards.
-
Replicate Multiple Clari Accounts
Replicate multiple Clari accounts to one or many databases.
-
How to connect to Freshsales Data in DBVisualizer
Integrate Freshsales data with visual data analysis tools and data connection wizards in DBVisualizer
-
Working with Redshift Data in LINQPad
Execute LINQ queries to Redshift data in LINQPad.
-
Visualize Live Procore Data in the Power BI Service
Use CData Connect AI to connect to live Procore data and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Automated Continuous SAS xpt Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable SAS xpt replication to delimited files (CSV/TSV).
-
Connecting Mastra with Okta 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 Okta data, no replication required.
-
Access Live Parallel Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Parallel data into the statistical analysis tools available in SAS JMP. This article shows how to use Parallel data in the Graph Builder and Query Builder.
-
How to Visualize Active Directory Data in Python with pandas via CData Connect AI
Use the CData Connect AI Python SDK with pandas and Matplotlib to analyze and visualize live Active Directory data in Python.
-
Integrate Open WebUI with Live Microsoft Planner Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Microsoft Planner data from within the chat interface.
-
Extract, Transform, and Load WordPress Data in Informatica PowerCenter
Create a simple Workflow for WordPress data in Informatica PowerCenter.
-
Connect to Reckon Data in JRuby
Create a simple JRuby app with access to live Reckon data.
-
Connecting Agentforce with Samanage 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 Samanage data for you.
-
Viewing VWO Data in RAD Studio Data Explorer
How to view VWO data in RAD Studio Data Explorer using the CData ODBC Driver for VWO.
-
Integrating LangChain with Freshdesk Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Freshdesk data within automated workflows.
-
Migrating data from Okta to Google BigQuery using CData SSIS Components.
Easily push Okta data to Google BigQuery using the CData SSIS Tasks for Okta and Google BigQuery.
-
Build Act CRM-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Act CRM data and build Act CRM-connected web apps with Axios.
-
Connect to and Visualize Live Sybase Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Sybase data.
-
DataBind Controls to Azure Data Lake Storage Data in Delphi
DataBind to Azure Data Lake Storage data in Delphi with standard data access components and controls.
-
Load Salesforce Marketing Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Salesforce Marketing data to a database.
-
Automated Continuous Freshteam Replication to SQLite
Use CData Sync for automated, continuous, customizable Freshteam replication to SQLite.
-
Integrating LangGraph with SageHR Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on SageHR data within automated workflows.
-
Browserless Reporting in OBIEE with the Browserless JDBC Driver
Deploy the Browserless JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Integrate Trae with Live Paylocity Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Trae to securely access and query live Paylocity data from within the AI-powered IDE.
-
Analyze ShipStation Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of ShipStation data and visualize live ShipStation data in Infragistics Reveal.
-
Create Power BI Reports on Real-Time Amazon Athena Data
Use the CData ODBC Driver for Amazon Athena to visualize Amazon Athena data in Power BI Desktop.
-
Access Live Insightly Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Insightly data into the statistical analysis tools available in SAS JMP. This article shows how to use Insightly data in the Graph Builder and Query Builder.
-
Connect to Opsgenie Data from a Connection Pool in JBoss
Integrate Opsgenie data into Java servlets: Use the Management Console in JBoss to install the Opsgenie JDBC Driver.
-
ETL Stripe in Oracle Data Integrator
This article shows how to transfer Stripe data into a data warehouse using Oracle Data Integrator.
-
Connect to PostgreSQL Data in RapidMiner
Integrate PostgreSQL data with standard components and data source configuration wizards in RapidMiner Studio.
-
A PostgreSQL Interface for Google Sheets Data using the CData ODBC Driver
Use the SQL Gateway and Google Sheets ODBC Driver to create a PostgreSQL entry-point for data access.
-
Replicate ZendeskSell Data to Multiple Databases via the CData Sync CLI
Replicate ZendeskSell data to disparate databases with a single configuration.
-
Use Claude to Talk to Your Guru 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 Guru data for you.
-
Use the CData Software JDBC Driver for Sage Cloud Accounting in MicroStrategy Desktop
Connect to Sage Cloud Accounting data in MicroStrategy Desktop using the CData Software JDBC Driver for Sage Cloud Accounting.
-
Connect to and Query TaxJar Data in QlikView over ODBC
Create data visualizations with TaxJar data in QlikView.
-
Persistent Token Storage for Embedded Use Cases with CData Connectors
How CData connectors persist authentication tokens, covering the local file, memory, and S3 token stores, credential file storage, and how to implement the ITokenStore interface for a custom token store.
-
Feed Zoho Creator Data into FineReport
How to set Zoho Creator data as a JDBC data source in FineReport.
-
Using the CData Software ODBC Driver for Dynamics NAV in PyCharm
Connect to Dynamics NAV as an ODBC data source in PyCharm using the CData Software ODBC Driver for Dynamics NAV.
-
Access Live Samanage Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Samanage data from your Excel spreadsheets.
-
How to import Amazon S3 Data into Apache Solr
Use the CData Software JDBC Driver for Amazon S3 in Data Import Handler and create an automated import of Amazon S3 data to Apache Solr Enterprise Search platform.
-
Use the CData Software ODBC Driver for Freshdesk in MicroStrategy Desktop
Connect to Freshdesk data in MicroStrategy Desktop using the CData Software ODBC Driver for Freshdesk.
-
Build Apps with Live Oracle Service Cloud data in Adalo using CData Connect AI
Use CData Connect AI to integrate live Oracle Service Cloud data into the Adalo platform and build custom mobile and web applications with real-time Oracle Service Cloud data.
-
Integrate Cline with Live Reckon Accounts Hosted Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Reckon Accounts Hosted data from within your IDE.
-
How to integrate Metabase with Egnyte Data
Use CData Connect AI to connect to live Egnyte data and create an interactive dashboard in Metabase from Egnyte data.
-
Integrate Theia IDE with Live FHIR 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 FHIR data from within the development environment.
-
Automated Continuous Bannerbear Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Bannerbear replication to Google BigQuery.
-
Connect to Live Epicor Kinetic Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Epicor Kinetic in CData Connect AI and connect to your Epicor Kinetic data from PostgreSQL.
-
Build Jira Assets-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Jira Assets Data from Zoho Analytics and import live Jira Assets data.
-
Query Live Oracle Eloqua 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 Oracle Eloqua data through a conversational interface.
-
Integrate Live Wave Financial Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Wave Financial data to Blue Prism using the CData ODBC Driver for Wave Financial to create automated workflows for repetitive business tasks.
-
Build Data Flows from Sage 200 to SQL Server using SSIS
Easily back up Sage 200 data to SQL Server using the SSIS components for Sage 200.
-
Automated Continuous Azure Data Lake Storage Replication to Vertica
Use CData Sync for automated, continuous, customizable Azure Data Lake Storage replication to Vertica.
-
Analyze Live Zoho Books Data in SAS Viya
Use CData Connect AI to connect to Zoho Books data from SAS Viya and deploy self-service analytics using live Zoho Books data.
-
Integrate Theia IDE with Live Splunk 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 Splunk data from within the development environment.
-
Automate xBase Data Replication to Azure Synapse
Use CData Sync to customize and automate xBase data replication to Azure Synapse.
-
Validate VWO Data with QuerySurge
Access and validate VWO data in QuerySurge using the CData JDBC Driver.
-
How to Query Live Strava Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Strava data data in natural language using Python.
-
Automated Continuous Pipeliner CRM Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Pipeliner CRM replication to delimited files (CSV/TSV).
-
Replicate ZeroBounce Data from PowerShell
Write a quick PowerShell script to query ZeroBounce data. Use connectivity to the live data to replicate ZeroBounce data to SQL Server.
-
How to publish and share Tickspot Data dashboards with Tableau Server
The CData ODBC driver for Tickspot enables you integrate Tickspot data into Tableau dashboards.