CData Software - Knowledge Base
Recent Articles
-
Use the CData Software ODBC Driver for Zoho Creator in MicroStrategy
Connect to Zoho Creator data in MicroStrategy Developer using the CData Software ODBC Driver for Zoho Creator.
-
Analyze SendInBlue Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for SendInBlue from Power Pivot. You will use the Table Import Wizard to load SendInBlue data. You can visually build the import query or use any SQL supported by the driver.
-
Create Informatica Mappings From/To an ODBC Data Source for Facebook Ads
Create an ODBC connection to Facebook Ads in Informatica and browse and transfer Facebook Ads data.
-
Automated Continuous CouchDB Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable CouchDB replication to Google Cloud SQL.
-
Integrate ZarMoney with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate ZarMoney with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to ZarMoney data.
-
Access Live Elasticsearch Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Elasticsearch data from your Google Sheets.
-
Connect to Anaplan Data in HULFT Integrate
Connect to Anaplan as a JDBC data source in HULFT Integrate
-
Integrate OData Services in Pentaho Data Integration
Build ETL pipelines based on OData services in the Pentaho Data Integration tool.
-
Replicate Certinia Data to Multiple Databases via the CData Sync CLI
Replicate Certinia data to disparate databases with a single configuration.
-
Connect Yelp to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Yelp with IBM WebSphere for seamless data integration and connectivity.
-
Automated Continuous Vercel Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Vercel replication to Amazon Redshift.
-
Build Apps with Live Pipedrive Data Using the Low-Code Development Platform of Mendix
Connect Pipedrive data with Mendix to build apps using the CData JDBC Driver for Pipedrive.
-
Build Charts with HubSpot Data in Clear Analytics
Create dynamic charts and perform analytics based on HubSpot data in Clear Analytics.
-
How to Query Live Freshsales Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Freshsales data data in natural language using Python.
-
How to Connect Notion 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 Notion data in real time using natural language.
-
Use Microsoft Copilot Studio to talk to your Oracle Eloqua 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 Oracle Eloqua data for you.
-
Integrate Goose with Live GraphQL Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live GraphQL data from within the local AI agent.
-
How to create PhantomBuster federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for PhantomBuster data in MySQL .
-
Extract, Transform, and Load Raisers Edge NXT Data in Informatica PowerCenter
Create a simple Workflow for Raisers Edge NXT data in Informatica PowerCenter.
-
Build Apps with Live Greenhouse data in Adalo using CData Connect AI
Use CData Connect AI to integrate live Greenhouse data into the Adalo platform and build custom mobile and web applications with real-time Greenhouse data.
-
Replicate Workable Data from PowerShell
Write a quick PowerShell script to query Workable data. Use connectivity to the live data to replicate Workable data to SQL Server.
-
How to Connect to Live Confluence 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 Confluence data through natural language.
-
Automated Continuous MongoDB Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable MongoDB replication to Apache Kafka.
-
Connect to SAP BusinessObjects BI Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live SAP BusinessObjects BI data.
-
Visualize Live Insightly Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Insightly data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Operational Reporting on Email Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Email data.
-
Import SAP Ariba Procurement Data Using Azure Data Factory
Use CData Connect AI to connect to SAP Ariba Procurement Data from Azure Data Factory and import live SAP Ariba Procurement data.
-
Integrating Kiro with Workday 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 Build an ETL App for Tanda Data in Python with CData
Create ETL applications and real-time data pipelines for Tanda data in Python with petl.
-
Query Live SAP SuccessFactors 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 SAP SuccessFactors data through a conversational interface.
-
ETL HDFS in Oracle Data Integrator
This article shows how to transfer HDFS data into a data warehouse using Oracle Data Integrator.
-
Integrate Goose with Live Egnyte Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Egnyte data from within the local AI agent.
-
Query Grafana Data in DataGrip
Create a Data Source for Grafana in DataGrip and use SQL to query live Grafana data.
-
Query MarkLogic Data in DataGrip
Create a Data Source for MarkLogic in DataGrip and use SQL to query live MarkLogic data.
-
Build Data Flows from Azure Analysis Services to SQL Server using SSIS
Easily back up Azure Analysis Services data to SQL Server using the SSIS components for Azure Analysis Services.
-
Establish a Live Connection with GitHub Data using Tableau Bridge
The CData ODBC Driver for GitHub enables you to integrate live GitHub data into Tableau Cloud dashboards using the Tableau Bridge.
-
Integrate LibreChat with Live ServiceDesk Plus Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live ServiceDesk Plus data from within the chat interface.
-
Automate MongoDB Integration Tasks from PowerShell
Are you in search of a quick and easy way to access MongoDB data from PowerShell? This article demonstrates how to utilize the MongoDB Cmdlets for tasks like connecting to MongoDB data, automating operations, downloading data, and more.
-
Access Live LDAP Objects in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate LDAP objects into the statistical analysis tools available in SAS JMP. This article shows how to use LDAP objects in the Graph Builder and Query Builder.
-
Connect Short.io to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Short.io data using the CData Python MCP Server.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Teradata
Provide connectivity to Teradata data through an SAP BusinessObjects universe.
-
How to Use a Microsoft Access Database to Update Google Sheets Data in Real Time
Update Google Sheets data by creating a linked table in Microsoft Access with the CData Google Sheets ODBC Driver.
-
How to import Shortcut Data into Apache Solr
Use the CData Software JDBC Driver for Shortcut in Data Import Handler and create an automated import of Shortcut data to Apache Solr Enterprise Search platform.
-
Connect Snowflake to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Snowflake data using the CData Python MCP Server.
-
Prepare, Blend, and Analyze Snapchat Ads Data in Alteryx Designer (Connect AI)
Build workflows to access live Snapchat Ads data for self-service data analytics.
-
Create ServiceDesk Plus Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time ServiceDesk Plus data access from reports, embedded analytics, and more.
-
How to Query CouchDB Data in MySQL Workbench
Execute MySQL queries against live CouchDB data from MySQL Workbench.
-
Getting Started with the CData SSIS Components for Vault CRM
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Vault CRM.
-
Enable the FTP JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with FTP data.
-
How to Connect to CloudConvert Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to CloudConvert data. Leverage the pyodbc module for ODBC in Python.
-
Connect FTP Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your FTP data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Analyze JotForm Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for JotForm from Power Pivot. You will use the Table Import Wizard to load JotForm data. You can visually build the import query or use any SQL supported by the driver.
-
Integrate Azure Data Catalog Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Azure Data Catalog data from Informatica Cloud.
-
Build Agents in Relevance AI with Access to Live Samanage Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Samanage data within intelligent agent workflows.
-
Access ZendeskSell Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live ZendeskSell data from HeidiSQL.
-
Building Dynamic Web Pages with Oracle Financials Cloud Data Using AngularJS
Create single-page applications with live connectivity to Oracle Financials Cloud using the CData API Server.
-
Build MessageBird-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live MessageBird data.
-
Connect to Azure Data Catalog 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 Azure Data Catalog data.
-
How to Connect to Live Oracle Sales Data from Gemini CLI (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Gemini CLI to securely read and take actions on your Oracle Sales data for you.
-
Build Data Flows from Zoho Books to SQL Server using SSIS
Easily back up Zoho Books data to SQL Server using the SSIS components for Zoho Books.
-
Build Apps with Live Zoho Projects Data Using the Low-Code Development Platform of Mendix
Connect Zoho Projects data with Mendix to build apps using the CData JDBC Driver for Zoho Projects.
-
Validate Clari Data with QuerySurge
Access and validate Clari data in QuerySurge using the CData JDBC Driver.
-
Import Real-Time TigerGraph Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use TigerGraph data in ColdFusion.
-
Use JayDeBeApi to access Brex Data in Python
Use standard Python scripting and the development environment of your choice to access live Brex data.
-
Prepare, Blend, and Analyze Office 365 Data in Alteryx Designer (ODBC)
Build workflows to access live Office 365 data for self-service data analytics.
-
Automated Continuous Mailjet Replication to SQLite
Use CData Sync for automated, continuous, customizable Mailjet replication to SQLite.
-
Integrate Real-Time Access to PayPal in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to PayPal data in real time.
-
Connect to Pinterest Data in Jaspersoft Studio
Execute SQL to remote Pinterest data in Jaspersoft Studio.
-
Establish a Live Connection with Teradata Data using Tableau Bridge
The CData ODBC Driver for Teradata enables you to integrate live Teradata data into Tableau Cloud dashboards using the Tableau Bridge.
-
Connect to Google Sheets Data in RazorSQL
Connect to Google Sheets from wizards and query Google Sheets data from the GUI in the RazorSQL database management tool.
-
Build ZohoMarketingHub-Connected Apps in Choreo
Use CData Connect AI to connect to ZohoMarketingHub Data from Choreo and build custom apps using live ZohoMarketingHub data.
-
SharePoint Excel Services Reporting in OBIEE with the SharePoint Excel Services JDBC Driver
Deploy the SharePoint Excel Services JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Integrate Live Excel Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Excel data to Blue Prism using the CData ODBC Driver for Excel to create automated workflows for repetitive business tasks.
-
Connect to Real-Time Avalara AvaTax Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Avalara AvaTax and Dataflow to import and use Avalara AvaTax data in Power Apps.
-
Integrate Google's Antigravity Agent with Live CockroachDB Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live CockroachDB data using the Model Context Protocol.
-
Connect to SharePoint Excel Services Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for SharePoint Excel Services to connect to SharePoint Excel Services data and execute queries in PowerBuilder.
-
Build Semantic Layer Views for Blackbaud FE NXT Data in APOS Live Data Gateway
Use the CData Connector for Blackbaud FE NXT in APOS Live Data Gateway to build Semantic Layer Views for Blackbaud FE NXT data.
-
Integrate Cursor with Live ZohoSubscriptions Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live ZohoSubscriptions data from within the editor.
-
Build Semantic Layer Views for Perigon Data in APOS Live Data Gateway
Use the CData Connector for Perigon in APOS Live Data Gateway to build Semantic Layer Views for Perigon data.
-
Design BIRT Reports on SendInBlue Data
Provide current SendInBlue data to your embedded analytics.
-
Access Live Snowflake Data in TIBCO Data Virtualization
Use the Snowflake Tibco DV Adapter to create a Snowflake data data source in TIBCO Data Virtualization Studio and gain access to live Snowflake data from your TDV Server.
-
How to Access Live MessageBird Data in Power Automate Desktop via ODBC
The CData ODBC Driver for MessageBird enables you to integrate MessageBird data into workflows built using Microsoft Power Automate Desktop.
-
Access Parallel Data from MySQL in Amazon QuickSight
Connect to Parallel and build visualizations of Parallel data using a MySQL Connection in Amazon QuickSight.
-
Build Data Flows from SQL Server to Bullhorn CRM through SSIS
Easily push SQL Server data to Bullhorn CRM using the CData SSIS Tasks for Bullhorn CRM.
-
Integrating Dataiku with Snapchat Ads Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Snapchat Ads data.
-
Query, Visualize, and Share live Salesforce Pardot Data in Redash
Use CData Connect AI to connect to live Salesforce Pardot data in Redash for querying, visualizing, and sharing.
-
Integrate Live Sage Intacct Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf's Cascade agent to securely access and query live Sage Intacct data from within the IDE.
-
Process & Analyze OData Services in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live OData Services.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for SingleStore
Provide connectivity to SingleStore data through an SAP BusinessObjects universe.
-
A PostgreSQL Interface for MarkLogic Data using the CData ODBC Driver
Use the SQL Gateway and MarkLogic ODBC Driver to create a PostgreSQL entry-point for data access.
-
Create Dynamic Webex Grids Using the Infragistics XamDataGrid
Learn how you can connect Webex to Infragistics XamDataGrid to build dynamic grids.
-
Use the CData Software ODBC Driver for Chargebee in MicroStrategy Web
Connect to Chargebee data in MicroStrategy Web using the CData Software ODBC Driver for Chargebee.
-
Access Live GetResponse Data in Coginiti Pro
Connect to and query live GetResponse data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Build Adobe Commerce-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Adobe Commerce Data from Zoho Analytics and import live Adobe Commerce data.
-
Access Live Discourse Data in AWS Lambda
Connect to live Discourse data in AWS Lambda using the CData JDBC Driver.
-
Create Power BI Reports on Real-Time Lakebase Data
Use the CData ODBC Driver for Lakebase to visualize Lakebase data in Power BI Desktop.
-
Moving Data from Zoho Recruit to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Zoho Recruit data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Create Dynamic Zoho Projects Grids Using the Infragistics XamDataGrid
Learn how you can connect Zoho Projects to Infragistics XamDataGrid to build dynamic grids.
-
Query Quaderno Data in ColdFusion
Write standard ColdFusion data access code to connect to Quaderno data.
-
Query Live CapsuleCRM Data in Zed Editor via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Zed Editor to securely access and query live CapsuleCRM data directly from the development environment.