CData Software - Knowledge Base
Recent Articles
-
Build Semantic Layer Views for Chargebee Data in APOS Live Data Gateway
Use the CData Connector for Chargebee in APOS Live Data Gateway to build Semantic Layer Views for Chargebee.
-
Automated Continuous Facebook Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Facebook replication to Google BigQuery.
-
Connecting GenSpark with ADP Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to ADP without any replication or custom integration required.
-
Automated Continuous Eventbrite Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Eventbrite replication to Apache Cassandra.
-
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.
-
Configure the CData JDBC Driver for MarkLogic in a Connection Pool in Tomcat
Connect to MarkLogic from a connection pool in Tomcat.
-
Visualize XML Data in Tableau
The CData ODBC driver for XML enables you integrate XML Files into Tableau dashboards.
-
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.
-
How to connect SharePoint with SparkPost Data through external lists
Provide SparkPost to SharePoint users as an external list.
-
Use Biml to Build SSIS Tasks to Replicate ZendeskSell Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate ZendeskSell to SQL Server.
-
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.
-
Getting Started with the CData Tableau Connector for Ontraport
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Explore Geographical Relationships in Factorial Data with Power Map
Create data visualizations with Factorial in Power Map.
-
Manage Azure DevOps Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Azure DevOps.
-
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 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.
-
Connect to PayPal Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live PayPal.
-
Use Biml to Build SSIS Tasks to Replicate Teradata Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Teradata to SQL Server.
-
How to Import Data from SAP HANA into Google Sheets
Import SAP HANA into a Google spreadsheet that is automatically refreshed.
-
Build Salesforce Data 360-Powered Applications in Claude Code with CData MCP Server
Use the CData MCP Server for Salesforce Data Cloud to explore live Salesforce Data 360 Data in Claude Code to assist with building Salesforce Data 360-powered applications.
-
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.
-
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.
-
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.
-
Connect to Scrapfly Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Scrapfly.
-
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.
-
Create a Data Access Object for Azure Table Data using JDBI
A brief overview of creating a SQL Object API for Azure Table Storage in JDBI.
-
Integrating LlamaIndex with Oracle Sales Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Oracle Sales in real time.
-
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.
-
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 Charts with Presto Data in Clear Analytics
Create dynamic charts and perform analytics based on Presto in Clear Analytics.
-
Analyze Jira Assets Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Jira Assets in Microsoft R Open.
-
Access Contentful Data from MySQL in Amazon QuickSight
Connect to Contentful and build visualizations of Contentful using a MySQL Connection in Amazon QuickSight.
-
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.
-
Work with Live Slack Data in Power Query
Use CData Connect AI to connect to Slack and work with live Slack in Microsoft Power Query.
-
Integrate Real-Time Access to Aha! in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Aha! in real time.
-
Moving Data from QuickBooks to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live QuickBooks data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Build an OLAP Cube in SSAS from NASA Data
Establish a connection to NASA data from SQL Server Analysis Services, and use the NASA Data Provider to build OLAP cubes for use in analytics and reporting.
-
Rapidly Develop PabblySubscriptions-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 PabblySubscriptions.
-
Build Apps with Live Workable Data Using the Low-Code Development Platform of Mendix
Connect Workable with Mendix to build apps using the CData API Driver for JDBC.
-
Getting Started with the CData SSIS Components for Facebook Ads
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Facebook Ads.
-
Model, Search, and Visualize Live Twitter Ads Data in ThoughtSpot
Use CData Connect AI to connect to live Twitter Ads for modeling, searching, and visualizing.
-
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.
-
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.
-
Design BIRT Reports on SharePoint Excel Services Data
Provide current SharePoint Excel Services to your embedded analytics.
-
Automate Google Ads Data Replication to Azure Data Lake
Use CData Sync to customize and automate Google Ads replication to Azure Data Lake.
-
Build AI/ML Models with Live PolarTeamPro Data using Dataiku
Connect PolarTeamPro Data with Dataiku using the CData API Driver for JDBC.
-
Build Data Flows from CockroachDB to SQL Server using SSIS
Easily back up CockroachDB to SQL Server using the SSIS components for CockroachDB.
-
Import AlloyDB Data Using Azure Data Factory
Use CData Connect AI to connect to AlloyDB Data from Azure Data Factory and import live Google AlloyDB.
-
How to Work with Apollo Data in AWS Glue Jobs Using JDBC
Connect to Apollo from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Automated Continuous Yelp Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Yelp replication to PostgreSQL.
-
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.
-
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.
-
Visualize Live Microsoft Dataverse Data in the Power BI Service
Use CData Connect AI to connect to live Microsoft Dataverse (CDS) and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Create SSAS Tabular Models from Exact Online Data
How to build a SQL Server Analysis Service Tabular Model from Exact Online using CData drivers.
-
Connect to and Visualize Live Bright Data Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Bright Data.
-
Natively Connect to ZohoDesk Data in PHP
The CData ODBC driver for ZohoDesk enables you to create PHP applications with connectivity to ZohoDesk. Leverage the native support for ODBC in PHP.
-
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.
-
Create Informatica Mappings From/To an ODBC Data Source for Smartsheet
Create an ODBC connection to Smartsheet in Informatica and browse and transfer Smartsheet.
-
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.
-
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.
-
Automated Continuous CData Connect AI Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable CData Connect AI replication to PostgreSQL.
-
Access Live Microsoft Planner Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Microsoft Planner into the statistical analysis tools available in SAS JMP. This article shows how to use Microsoft Planner in the Graph Builder and Query Builder.
-
How to Connect to Live Freshdesk 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 Freshdesk for you.
-
Object-Relational Mapping (ORM) with OpenWeatherMap Data Entities in Java
Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to OpenWeatherMap into a Java-based ORM framework, Hibernate.
-
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.
-
Connect to Live Oracle Eloqua Data in MicroStrategy through CData Connect AI
Create a live connection to Oracle Eloqua Data in CData Connect AI and connect to your Oracle Eloqua from MicroStrategy.
-
Import Vimeo Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Vimeo. In this article, you will use the OData format to import Vimeo into Microsoft Power Query.
-
How to Query Live ConvertAPI Data in Perplexity MacOS Desktop
Connect to and query live ConvertAPI Data in Perplexity Desktop using CData MCP Server.
-
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.
-
Connect to Wrike Data in RazorSQL
Connect to Wrike from wizards and query Wrike from the GUI in the RazorSQL database management tool.
-
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.
-
Visualize Live Moosend Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Moosend.
-
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.
-
Query Box Data in DataGrip
Create a Data Source for Box in DataGrip and use SQL to query live Box.
-
Connect to GitLab Data as an External Source in Dremio
Use the CData JDBC Driver to connect to GitLab as an External Source in Dremio.
-
Easily Integrate FormSite Data in Lazarus Pascal IDE
Learn how to easily integrate live FormSite in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Integrate Simplesat Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Simplesat from Informatica Cloud.
-
Connecting Agentforce with Blackbaud FE NXT 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 Blackbaud FE NXT for you.
-
Use the CData Software JDBC Driver for Beeminder in MicroStrategy Desktop
Connect to Beeminder in MicroStrategy Desktop using the CData Software JDBC Driver for Beeminder.
-
Access Live Salesforce Pardot Data in Coginiti Pro
Connect to and query live Salesforce Pardot from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Apollo using the Model Context Protocol.
-
Trigger Google Ad Manager IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for Google Ad Manager with standard wizards in Logic Apps.
-
Natively Connect to Omnisend Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Omnisend. Leverage the native support for ODBC in PHP.
-
Access Live ZendeskSell Data in Coginiti Pro
Connect to and query live ZendeskSell from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
How to integrate CockroachDB with Apache Airflow
Access and process CockroachDB in Apache Airflow using the CData JDBC Driver.
-
Automated Continuous NetSuite SuiteAnalytics Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable NetSuite SuiteAnalytics replication to Apache Cassandra.