CData Software - Knowledge Base
Recent Articles
-
Work with Live ServiceNow in Power Query
Use CData Connect AI to connect to ServiceNow and work with live ServiceNow in Microsoft Power Query.
-
How to create eBay Analytics federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for eBay Analytics in MySQL .
-
Automated Continuous Blackbaud FE NXT Replication to Snowflake
Use CData Sync for automated, continuous, customizable Blackbaud FE NXT replication to Snowflake.
-
Use the CData Software ODBC Driver for Phoenix in MicroStrategy
Connect to Apache Phoenix in MicroStrategy Developer using the CData Software ODBC Driver for Phoenix.
-
Connecting Pipedream with Twitter Ads 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 Twitter Ads data in real time.
-
Connecting Pipedream with Jira 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 Jira data in real time.
-
How to Query Live Salesforce in Claude Desktop
Connect to and query live Salesforce in Claude Desktop using CData Code Assist MCP.
-
Using the CData Software ODBC Driver for Oracle in PyCharm
Connect to Oracle as an ODBC data source in PyCharm using the CData Software ODBC Driver for Oracle.
-
Create Data Visualizations Based On Paylocity in Mode
Use CData Connect AI to connect to Paylocity from Mode and build visualizations using live
-
Access Live SAP Business One 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 SAP Business One through MCP integration.
-
Use Azure AI Foundry to Talk to Your YouTube Analytics via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Azure AI Foundry agents to securely answer questions and take actions on your YouTube Analytics for you.
-
Create SSAS Tabular Models from SAP ByDesign
How to build a SQL Server Analysis Service Tabular Model from SAP Business ByDesign using CData drivers.
-
Building Dynamic Web Pages with Shippo Using AngularJS
Create single-page applications with live connectivity to Shippo using the CData API Server.
-
Automated Continuous Confluence Replication to MongoDB
Use CData Sync for automated, continuous, customizable Confluence replication to MongoDB.
-
Build Semantic Layer Views for Vault CRM in APOS Live Data Gateway
Use the CData Connector for Vault CRM in APOS Live Data Gateway to build Semantic Layer Views for Veeva Vault & Vault CRM.
-
Build Automated Workflows with Live Shopify in Workato
Use CData Connect AI to connect to live Shopify and build automated workflows in Workato.
-
Getting Started with the CData Excel Add-In for Adobe Target
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Adobe Target.
-
Connect to Bitbucket as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Bitbucket.
-
Edit and Search FHIR External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of FHIR to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create FHIR objects that you can access from apps and the dashboard.
-
Integrating Boomi Agentstudio with Airtable via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Airtable, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
How to Work with Lakebase in AWS Glue Jobs Using JDBC
Connect to Lakebase from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Access Live Sage Cloud Accounting in Coginiti Pro
Connect to and query live Sage Business Cloud Accounting from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
How to use SQLAlchemy ORM to access SAP Business One in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of SAP Business One.
-
Deploy the ADO.NET Provider for ClickUp on an SSRS Report Server
Connect to ClickUp from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.
-
Build Google Sheets-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Google Sheets.
-
Migrating data from Workday to Google BigQuery using CData SSIS Components.
Easily push Workday to Google BigQuery using the CData SSIS Tasks for Workday and Google BigQuery.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Google Analytics within intelligent workflows.
-
Connect to Live Lakebase in PostGresSQL Interface through CData Connect AI
Create a live connection to Lakebase in CData Connect AI and connect to your Lakebase from PostgreSQL.
-
Connect SAP Ariba Procurement to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live SAP Ariba Procurement using the CData Python MCP Server.
-
Operational Reporting on Bullhorn CRM from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Bullhorn CRM.
-
Automated Continuous ServiceNow Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable ServiceNow replication to OneLake in Microsoft Fabric.
-
How to update Paylocity from Excel
This article explains how to transfer data from Excel to Paylocity using the Excel Add-In for Paylocity.
-
Query Smartsheet as a MySQL Database in Node.js
Execute MySQL queries against Smartsheet from Node.js.
-
Automated Continuous Tally Replication to Microsoft Access
Use CData Sync for automated, continuous, customizable Tally replication to Microsoft Access.
-
Visualize HDFS in TIBCO Spotfire through OData
Integrate Apache HDFS into dashboards in TIBCO Spotfire.
-
Object-Relational Mapping (ORM) with Paylocity 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 Paylocity into a Java-based ORM framework, Hibernate.
-
Create Reports from Paylocity in Looker Studio
Use CData Connect AI to gain access to live Paylocity and create custom reports in Looker Studio.
-
Create Data Visualizations Based On ShipStation in Mode
Use CData Connect AI to connect to ShipStation from Mode and build visualizations using live
-
Migrating data from IBM Informix to Snowflake using CData SSIS Components.
Easily push IBM Informix to Snowflake using the CData SSIS Tasks for IBM Informix and Snowflake.
-
Use Manus AI to Talk to Your Trello 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 Trello.
-
Integrate Theia IDE with Live Xero Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE
-
Stream Salesforce Pardot into Apache Kafka Topics
Access and stream Salesforce Pardot in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Add MYOB AccountRight to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for MYOB AccountRight with the Informatica Enterprise Data Catalog to classify and organize data.
-
How to Query WordPress in MySQL Workbench
Execute MySQL queries against live WordPress from MySQL Workbench.
-
A PostgreSQL Interface for Redshift using the CData ODBC Driver
Use the SQL Gateway and Redshift ODBC Driver to create a PostgreSQL entry-point for data access.
-
Create Dynamic REST Grids Using the Infragistics XamDataGrid
Learn how you can connect REST to Infragistics XamDataGrid to build dynamic grids.
-
Build LinkedIn Ads-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live LinkedIn Ads and build LinkedIn Ads-connected web apps with Axios.
-
Back Up Pivotal GreenPlum to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Greenplum. In this article, we will employ an SSIS workflow to populate a database with Pivotal GreenPlum data.
-
Build AI/ML Models with Live Adobe Analytics Data using Dataiku
-