CData Software - Knowledge Base
Recent Articles
-
Connect WordPress to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live WordPress using the CData Python MCP Server.
-
Access Live Sybase Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Sybase from your Excel spreadsheets.
-
Create Reports with Bright Data Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Bright Data.
-
Connect to Zuora Data in NetBeans
Connect to Zuora in NetBeans with the data source configuration wizard.
-
Establish a Live Connection with CSV Data using Tableau Bridge
The CData ODBC Driver for CSV enables you to integrate live CSV/TSV Files into Tableau Cloud dashboards using the Tableau Bridge.
-
Impala Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Impala facts in real time.
-
Use Grok to Talk to Your Couchbase Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Grok AI to securely answer questions and take actions on your Couchbase for you.
-
Create Dashboards and Visualize Live OData Services in Geckoboard
Use CData Connect AI to connect to live OData and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Access Live Okta Data in Excel 365 Online (Excel for the web)
Connect to Okta from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Analyze Clari Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Clari from Power Pivot. You will use the Table Import Wizard to load Clari. You can visually build the import query or use any SQL supported by the driver.
-
Connect to ADP Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for ADP.
-
Choosing the Best Method to Connect Zendesk to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Zendesk from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
View Reports on Real-Time Vercel Data in Power BI Report Server
Use the CData ODBC Driver for Vercel to visualize Vercel in Power BI Desktop and then publish them to Power BI Report Server.
-
Connect to Reply.io Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Reply.io.
-
Harvest Reporting in OBIEE with the Harvest JDBC Driver
Deploy the Harvest JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Connect to Tanda in SpagoBI
Create reports featuring live Tanda in SpagoBI Studio. Host Tanda reports on SpagoBI Server.
-
Use Databricks Agent Bricks to Talk to Your PostgreSQL Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your PostgreSQL for you.
-
Automated Continuous HDFS Replication to MongoDB
Use CData Sync for automated, continuous, customizable HDFS replication to MongoDB.
-
Connect to SendGrid in SpagoBI
Create reports featuring live SendGrid in SpagoBI Studio. Host SendGrid reports on SpagoBI Server.
-
Create Oracle Service Cloud-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Oracle Service Cloud Data from OutSystems and build custom enterprise apps using live Oracle Service Cloud.
-
Automated Continuous Moosend Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Moosend replication to OneLake in Microsoft Fabric.
-
Connect to LaunchDarkly Data from PowerBuilder via JDBC
This article demonstrates how to access LaunchDarkly from PowerBuilder using the LaunchDarkly JDBC Driver.
-
How to Query ConstantContact Data in MySQL Workbench
Execute MySQL queries against live ConstantContact from MySQL Workbench.
-
How to connect PolyBase to Opsgenie
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Opsgenie.
-
Build Redis-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Redis and build Redis-connected web apps with Axios.
-
Excel Spreadsheet Automation on Avalara AvaTax Data with the QUERY Formula
Pull data from Avalara AvaTax, automate spreadsheets, and more with the QUERY formula.
-
Building Dynamic Web Pages with SingleStore Data Using AngularJS
Create single-page applications with live connectivity to SingleStore using the CData API Server.
-
Getting Started with the CData Excel Add-In for ZohoPeople
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for ZohoPeople.
-
Build SFTP-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to SFTP and build web apps with connectivity to live SFTP.
-
Build Office 365-Powered Applications in Cursor with CData MCP Server
Use the CData MCP Server for Office 365 to explore live Office 365 Data in Cursor to assist with building Office 365-powered applications.
-
Create Informatica Mappings From/To an ODBC Data Source for Placid
Create an ODBC connection to Placid in Informatica and browse and transfer Placid.
-
Access Live Exa Data in Coginiti Pro
Connect to and query live Exa from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Analyze Shopify Data in Cognos Analytics
Use CData Connect AI to connect to Shopify Data from Cognos Analytics and analyze live Shopify.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Salesforce CRM Analytics using the Model Context Protocol.
-
Automate Gorgias Data Replication to Azure Synapse
Use CData Sync to customize and automate Gorgias replication to Azure Synapse.
-
Getting Started with the CData ADO.NET Provider for Chargebee
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Connect to Avaza Data in NetBeans
Connect to Avaza in NetBeans with the data source configuration wizard.
-
Rapidly Develop Oracle Eloqua Reporting-Driven Apps with Active Query Builder
Leverage the Active Query Builder SQL interface and .NET data access to create data-driven WinForms and ASP.NET apps backed by Oracle Eloqua Reporting.
-
Stream Landbot Data into Apache Kafka Topics
Access and stream Landbot in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Connect to Intercom Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Intercom in the Denodo Virtual DataPort Administrator.
-
How to connect to Perigon Data with Squirrel SQL client
Connect to Perigon and execute queries in the Squirrel SQL Client.
-
Natively Connect to Azure Data Catalog Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Azure Data Catalog. Leverage the native support for ODBC in PHP.
-
Connecting Mastra with SharePoint 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 Microsoft SharePoint, no replication required.
-
Connect to Highrise Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Highrise as an External Source in Dremio.
-
Build Data Flows from Amazon S3 to SQL Server using SSIS
Easily back up Amazon S3 to SQL Server using the SSIS components for Amazon S3.
-
Build Semantic Layer Views for Trello Data in APOS Live Data Gateway
Use the CData Connector for Trello in APOS Live Data Gateway to build Semantic Layer Views for Trello.
-
DataBind Controls to eBay Analytics Data in C++Builder
DataBind to eBay Analytics in C++Builder with standard components and controls.
-
Automated Continuous XML Replication to SingleStore
Use CData Sync for automated, continuous, customizable XML replication to SingleStore.
-
Connect to Odoo Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Odoo and the Script function in FileMaker Pro to connect to Odoo and work with Odoo ERP in your FileMaker application.
-
Connect to Greenhouse Data in HULFT Integrate
Connect to Greenhouse as a JDBC data source in HULFT Integrate
-
Migrating data from Front to Google BigQuery using CData SSIS Components.
Easily push Front to Google BigQuery using the CData SSIS Tasks for Front and Google BigQuery.
-
Visualize Paylocity Data in TIBCO Spotfire through ADO.NET
Integrate Paylocity into dashboards in TIBCO Spotfire.
-
How to connect PolyBase to SurveyMonkey
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live SurveyMonkey.
-
Integrate WordPress Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live WordPress from Informatica Cloud.
-
Use ChatGPT to Talk to Your SAP Fieldglass 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 SAP Fieldglass for you.
-
Integrate Bright Data with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Bright Data with External Services.
-
How to use SQLAlchemy ORM to access Teradata Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Teradata.
-
Integrating Kiro CLI with Azure DevOps 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 Sybase-Powered Applications in Gemini Code Assist with CData MCP Server
Use the CData MCP Server for Sybase to explore live Sybase Data in Gemini Code Assist to assist with building Sybase-powered applications.
-
Configure the CData JDBC Driver for Typeform in a Connection Pool in Tomcat
Connect to Typeform from a connection pool in Tomcat.
-
Connect to LinkedIn Ads Data from a Connection Pool in JBoss
Integrate LinkedIn Ads into Java servlets: Use the Management Console in JBoss to install the LinkedIn Ads JDBC Driver.
-
Use Dash to Build to Web Apps on Printify Data
Create Python applications that use pandas and Dash to build Printify-connected web apps.
-
Connect to ServiceNow Data in RapidMiner
Integrate ServiceNow with standard components and data source configuration wizards in RapidMiner Studio.
-
Create Datasets from DocuSign in Domo Workbench and Build Visualizations of DocuSign Data in Domo
Use the CData Software ODBC Driver for DocuSign to create datasets from DocuSign in Domo Workbench and then build visualizations in the Domo service.
-
Build MVC Applications with Connectivity to Quickbase Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Quickbase from an ASP.NET MVC application.
-
How to integrate ConvertAPI with Apache Airflow
Access and process ConvertAPI in Apache Airflow using the CData JDBC Driver.
-
Build Visualizations of Dynamics NAV Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Microsoft Dynamics NAV in Birst.
-
Getting Started with the CData JDBC Driver for Adobe Target
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Adobe Target.
-
Build Visualizations of ZohoDesk Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of ZohoDesk in Birst.
-
How to Query Live SAP Ariba Source Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live SAP Ariba Source data in natural language using Python.
-
Create MySQL-Connected Dashboards in Grafana
Connect to MySQL Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to MySQL.
-
Query Adobe Target Data in DataGrip
Create a Data Source for Adobe Target in DataGrip and use SQL to query live Adobe Target.
-
Natively Connect to Telegram Data in PHP
The CData ODBC driver for Telegram enables you to create PHP applications with connectivity to Telegram. Leverage the native support for ODBC in PHP.
-
Connecting Pipedream with Instagram 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 Instagram data in real time.
-
Build Apps with Live Reply.io Data Using the Low-Code Development Platform of Mendix
Connect Reply.io with Mendix to build apps using the CData API Driver for JDBC.
-
Connect to Adobe Analytics Data from a Connection Pool in Jetty
The Adobe Analytics JDBC Driver supports connection pooling: This article shows how to connect faster to Adobe Analytics from Web apps in Jetty.
-
Replicate Float Data to Multiple Databases
Replicate Float to disparate databases with a point-and-click configuration.
-
Automated Continuous Salesforce Marketing Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Salesforce Marketing replication to Google BigQuery.
-
Access Live Power BI XMLA Data in Roo Code via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Roo Code agents to securely access and build applications with live Power BI XMLA through MCP integration.
-
How to Connect to ActiveCampaign Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to ActiveCampaign. Leverage the pyodbc module for ODBC in Python.
-
Use JayDeBeApi to access DocuSign Data in Python
Use standard Python scripting and the development environment of your choice to access live DocuSign.
-
Extract, Transform, and Load CouchDB Data in Informatica PowerCenter
Create a simple Workflow for Apache CouchDB in Informatica PowerCenter.
-
How to connect Amazon QuickSight to SAP SuccessFactors Data
Create a connection to SAP SuccessFactors in CData Connect AI and insert SAP SuccessFactors into Amazon QuickSight SPICE to build interactive dashboards.
-
Integrate Live Azure Analysis Services Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Azure Analysis Services and integrate live Azure Analysis Services into apps built in Microsoft Power Apps.
-
Visualize ZeroBounce 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 ZeroBounce into TIBCO Spotfire.
-
Connect to Wave Financial in SpagoBI
Create reports featuring live Wave Financial in SpagoBI Studio. Host Wave Financial reports on SpagoBI Server.
-
Connect to Unbounce from a Connection Pool in WebLogic
Use the CData JDBC Driver for Unbounce to connect to Unbounce from Web applications running on WebLogic.
-
Connect to AdRoll Data in RapidMiner
Integrate AdRoll with standard components and data source configuration wizards in RapidMiner Studio.
-
Replicate Multiple Bullhorn CRM Accounts via the CData Sync CLI
Replicate multiple Bullhorn CRM accounts to one or many databases.
-
Automate Dynamics 365 Data Replication to Azure Data Lake
Use CData Sync to customize and automate Microsoft Dynamics 365 replication to Azure Data Lake.
-
Connect to ShipStation Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for ShipStation Data and connect to ShipStation in Akorbi Digital RunMyProcess.
-
Integrating LangGraph with Azure Analysis Services Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Azure Analysis Services within automated workflows.
-
Create Informatica Mappings From/To a JDBC Data Source for SuiteCRM
Create SuiteCRM data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Integrate OnePageCrm with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate OnePageCrm with External Services.
-
How to create Twilio federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Twilio in MySQL .
-
Visualize PivotalTracker Data in Tableau
The CData ODBC driver for PivotalTracker enables you integrate PivotalTracker into Tableau dashboards.
-
Create Informatica Mappings From/To an ODBC Data Source for Printful
Create an ODBC connection to Printful in Informatica and browse and transfer Printful.
-
Automated Continuous Elasticsearch Replication to MySQL
Use CData Sync for automated, continuous, customizable Elasticsearch replication to MySQL.
-
Integrate Snowflake Data in Pentaho Data Integration
Build ETL pipelines based on Snowflake in the Pentaho Data Integration tool.
-
Build an OLAP Cube in SSAS from Egnyte Data
Establish a connection to Egnyte data from SQL Server Analysis Services, and use the Egnyte Data Provider to build OLAP cubes for use in analytics and reporting.