CData Software - Knowledge Base
Recent Articles
-
Create Data Visualizations Based On Vault CRM Data in Mode
Use CData Connect AI to connect to Vault CRM Data from Mode and build visualizations using live
-
Connect and Visualize Live Square Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Square into the Databricks platform and create visualization dashboards with real-time Square.
-
Connect to Calendly Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Calendly as an External Source in Dremio.
-
Configure the CData JDBC Driver for MarkLogic in a Connection Pool in Tomcat
Connect to MarkLogic from a connection pool in Tomcat.
-
Write a Simple Go Application to work with Azure Data Lake Storage Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Azure Data Lake Storage.
-
Automated Continuous HelloSign Replication to Oracle
Use CData Sync for automated, continuous, customizable HelloSign replication to Oracle.
-
Visualize Aircall Data in Tableau
The CData ODBC driver for Aircall enables you integrate Aircall into Tableau dashboards.
-
Integrate Live Shopify Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Shopify and integrate live Shopify into apps built in Microsoft Power Apps.
-
Use the CData Software JDBC Driver for Email in MicroStrategy Web
Connect to Email in MicroStrategy Web using the CData Software JDBC Driver for Email.
-
Getting Started with the CData Tableau Connector for Ontraport
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Analyze Cosmos DB Data in Cognos Analytics
Use CData Connect AI to connect to Cosmos DB Data from Cognos Analytics and analyze live Azure Cosmos DB.
-
Migrating data from OnePageCrm to Snowflake using CData SSIS Components.
Easily push OnePageCrm to Snowflake using the CData SSIS Tasks for OnePageCrm and Snowflake.
-
Connect to Oracle Sales Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Oracle Sales from Filemaker Pro on Mac.
-
Use Dash to Build to Web Apps on Spark Data
Create Python applications that use pandas and Dash to build Spark-connected web apps.
-
Automated Gorgias Data Replication to Teradata
Use CData Sync to Customize and automate Gorgias replication to Teradata.
-
Use the CData Software JDBC Driver for SAP Hybris C4C in MicroStrategy Web
Connect to SAP Hybris C4C in MicroStrategy Web using the CData Software JDBC Driver for SAP Hybris C4C.
-
Access Invoiced Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Invoiced from your Oracle system.
-
How to Import Data from SAP HANA into Google Sheets
Import SAP HANA into a Google spreadsheet that is automatically refreshed.
-
Connect to MariaDB Data in Aqua Data Studio
Access MariaDB from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Build SharePoint Excel Services-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData MCP Server for SharePoint Excel Services to explore live SharePoint Excel Services Data in GitHub Copilot to assist with building SharePoint Excel Services-powered applications.
-
Connect to SAP Fieldglass Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for SAP Fieldglass in the Denodo Virtual DataPort Administrator.
-
Build Salesforce Data 360-Powered Applications in Claude Code with CData MCP Server
Use the CData MCP Server for Salesforce Data 360 to explore live Salesforce Data 360 Data in Claude Code to assist with building Salesforce Data 360-powered applications.
-
Moving Data from SendInBlue to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live SendInBlue data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
How to connect to CockroachDB Data with Squirrel SQL client
Connect to CockroachDB and execute queries in the Squirrel SQL Client.
-
How to Connect to Live Azure Data Lake Storage Data from Claude Agent SDK (via CData Connect AI)
Leverage CData Connect AI to enable Claude Agent SDK applications to securely read and take actions on your Azure Data Lake Storage for you.
-
Use JayDeBeApi to access Sage 300 Data in Python
Use standard Python scripting and the development environment of your choice to access live Sage 300.
-
Publish Reports with TigerGraph Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date TigerGraph.
-
Getting Started with the CData Power BI Connector for Codat
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Build Dashboards with ZendeskSell Data in Dundas BI
Create dynamic dashboards and perform analytics based on ZendeskSell in Dundas BI.
-
Use the CData Software JDBC Driver for SAP Netweaver Gateway in MicroStrategy
Connect to SAP Netweaver Gateway in MicroStrategy Developer using the CData Software JDBC Driver for SAP Netweaver Gateway.
-
Use JayDeBeApi to access Snapchat Ads Data in Python
Use standard Python scripting and the development environment of your choice to access live Snapchat Ads.
-
Integrate Live Mode Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Mode to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Replicate Twilio Data in Heroku for Use in Salesforce Connect
Replicate Twilio to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
How to use SQLAlchemy ORM to access PagerDuty Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of PagerDuty.
-
Connect to Vimeo Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Vimeo.
-
Connect and Query Live MongoDB Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live MongoDB into Databricks
-
How to load OData data into Elasticsearch via Logstash
Introducing a simple method to load OData data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Integrate Live Azure Synapse Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Azure Synapse and integrate live Azure Synapse into apps built in Microsoft Power Apps.
-
Integrate Live Microsoft Teams Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Microsoft Teams from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Microsoft Teams.
-
Visualize Live Freshdesk Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Freshdesk.
-
Use ChatGPT to Talk to Your Azure Data Lake Storage 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 Azure Data Lake Storage for you.
-
Build Apps with Live OpenWeatherMap Data Using the Low-Code Development Platform of Mendix
Connect OpenWeatherMap with Mendix to build apps using the CData API Driver for JDBC.
-
Access Highrise Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Highrise CRM from your Oracle system.
-
Integrating LangChain with NetSuite Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on NetSuite CRM & ERP within automated workflows.
-
Analyze SAP Hybris C4C Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of SAP Hybris C4C and visualize SAP Hybris C4C in SAP Analytics Cloud.
-
Trello Reporting in OBIEE with the Trello JDBC Driver
Deploy the Trello JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Easily Integrate Apify Data in Lazarus Pascal IDE
Learn how to easily integrate live Apify in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Build a Simple VCL Application for RSS Feeds
How to build a simple VCL Application to view RSS Feeds in RAD Studio using the CData ODBC Driver for RSS.
-
Explore Geographical Relationships in Azure Analysis Services Data with Power Map
Create data visualizations with Azure Analysis Services in Power Map.
-
Automated Continuous Google Cloud Storage Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Google Cloud Storage replication to Azure SQL Database.
-
Automated Continuous Testmonitor Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Testmonitor replication to PostgreSQL.
-
Integrating Boomi Agentstudio with MYOB AccountRight Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to MYOB AccountRight, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Automated Continuous Pipeline CRM Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Pipeline CRM replication to Amazon S3.
-
Getting Started with the CData SSIS Components for Paddle
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Paddle.
-
Connect to and Query AgileCRM Data in QlikView over ODBC
Create data visualizations with AgileCRM in QlikView.
-
Integrating GitHub Copilot CLI with Splunk 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.
-
Create Dynamic SageHR Grids Using the Infragistics XamDataGrid
Learn how you can connect SageHR to Infragistics XamDataGrid to build dynamic grids.
-
How to connect SharePoint with Sybase IQ Data through external lists
Provide Sybase IQ to SharePoint users as an external list.
-
Getting Started with the CData ODBC Driver for NetSuite
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for NetSuite.
-
Create SSAS Tabular Models from Oracle Data
How to build a SQL Server Analysis Service Tabular Model from Oracle Database using CData drivers.
-
Use Manus AI to Talk to Your ADP 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 ADP.
-
Use the CData Software JDBC Driver for Kintone in MicroStrategy Web
Connect to Kintone in MicroStrategy Web using the CData Software JDBC Driver for Kintone.
-
Edit and Search External YouTube Analytics Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of YouTube Analytics to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create YouTube Analytics Data objects that you can access from apps and the dashboard.
-
Migrating data from Postmark to Databricks using CData SSIS Components.
Easily push Postmark to Databricks using the CData SSIS Tasks for Postmark and Databricks.
-
Connect to and Visualize Live MailerSend Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live MailerSend.
-
Build AI/ML Models with Live PolarTeamPro Data using Dataiku
Connect PolarTeamPro Data with Dataiku using the CData API Driver for JDBC.
-
A PostgreSQL Interface for QuickBooks Online Data (MySQL Remoting via JDBC)
Use the Remoting features of the QuickBooks Online JDBC Driver to create a PostgreSQL entry-point for data access.
-
Integrate Accelo Data in Pentaho Data Integration
Build ETL pipelines based on Accelo in the Pentaho Data Integration tool.
-
Connect to Epicor Kinetic Data from AWS Glue
Use CData Connect AI to gain access to live Epicor Kinetic from your AWS Glue jobs.
-
Connect to Cosmos DB Data from a Connection Pool in JBoss
Integrate Azure Cosmos DB into Java servlets: Use the Management Console in JBoss to install the Cosmos DB JDBC Driver.
-
Build Apps with Live GetResponse Data Using the Low-Code Development Platform of Mendix
Connect GetResponse with Mendix to build apps using the CData API Driver for JDBC.
-
Connect to Discourse Data in HULFT Integrate
Connect to Discourse as a JDBC data source in HULFT Integrate
-
Build a Singer.io Tap for Azure Table With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Azure Table data using
-
How to Connect to & Open Parquet Data in Microsoft Excel
This article uses the CData ODBC driver for Parquet to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Integrating Claude Code CLI with PhantomBuster 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.
-
Import Oracle Financials Cloud Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Oracle Financials Cloud. In this article, you will use the OData format to import Oracle Financials Cloud into Microsoft Power Query.
-
How to Create Power BI Visual Reports with Real-Time Hugging Face Data
Use CData Power BI Connectors to visualize Hugging Face in Power BI.
-
Automated Continuous Google Search Replication to Databricks
Use CData Sync for automated, continuous, customizable Google Search replication to Databricks.
-
Add MySQL Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for MySQL with the Informatica Enterprise Data Catalog to classify and organize data.
-
Connect to Real-Time Snapchat Ads Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Snapchat Ads and Dataflow to import and use Snapchat Ads in Power Apps.
-
Getting Started with the CData SSIS Components for Avalara AvaTax
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Avalara AvaTax.
-
Integrate Snapchat Ads with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Snapchat Ads with External Services.
-
Build AI/ML Models with Live Apollo Data using Dataiku
Connect Apollo Data with Dataiku using the CData API Driver for JDBC.
-
Build a Simple VCL Application for Hubstaff Data
How to build a simple VCL Application to view Hubstaff in RAD Studio using the CData ODBC Driver for Hubstaff.
-
How to Connect to Customer.io Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Customer.io. Leverage the pyodbc module for ODBC in Python.
-
Establish a Live Connection with Square Data using Tableau Bridge
The CData ODBC Driver for Square enables you to integrate live Square into Tableau Cloud dashboards using the Tableau Bridge.
-
Access BambooHR Data from MySQL in PHP
Connect to BambooHR through the standard MySQL libraries in PHP.
-
Publish Pipeliner CRM-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Pipeliner CRM.
-
Analyze ZohoInvoice Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze ZohoInvoice in Microsoft R Open.
-
Access Live PDFMonkey Data in AWS Lambda (with IntelliJ IDEA)
Connect to live PDFMonkey in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Analyze Vercel Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Vercel with the CData JDBC Driver for Vercel.
-
Access Zuora 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 Zuora.
-
Bridge Aweber Connectivity with Apache NiFi
Access and process Aweber in Apache NiFi using the CData JDBC Driver.
-
Getting Started with the CData Excel Add-In for Landbot
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Landbot.
-
Natively Connect to GraphQL Data in PHP
The CData ODBC driver for GraphQL enables you to create PHP applications with connectivity to GraphQL. Leverage the native support for ODBC in PHP.
-
Connect to Act-On Data from PowerBuilder via JDBC
This article demonstrates how to access Act-On from PowerBuilder using the Act-On JDBC Driver.
-
Integrate Azure Data Lake Storage with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Azure Data Lake Storage with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Azure Data Lake Storage.
-
Integrate Goose with Live Power BI XMLA Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Power BI XMLA from within the local AI agent.
-
Connect to and Query Amplitude Data in QlikView over ODBC
Create data visualizations with Amplitude in QlikView.
-
How to Query Live Sage 300 Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Sage 300 data in natural language using Python.