CData Software - Knowledge Base
Recent Articles
-
How to Access Live SAP Hybris C4C in Visual Studio Code via Cline
Run the CData MCP Server for SAP Hybris C4C on Windows Subsytem for Linux (WSL) and connect to live SAP Hybris C4C from the Cline extension in Visual Studio Code.
-
Import Real-Time DocuSign via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use DocuSign in ColdFusion.
-
Replicate Multiple SurveyMonkey Accounts via the CData Sync CLI
Replicate multiple SurveyMonkey accounts to one or many databases.
-
Replicate CSV to Multiple Databases
Replicate CSV/TSV Files to disparate databases with a point-and-click configuration.
-
How to use SQLAlchemy ORM to access SAP HANA in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of SAP HANA.
-
Enable the IBM Cloud Object Storage JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with IBM Cloud Object Storage.
-
Azure Table Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Azure Table facts in real time.
-
Natively Connect to YouTube Analytics in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to YouTube Analytics. Leverage the native support for ODBC in PHP.
-
DataBind Controls to Cvent in C++Builder
DataBind to Cvent in C++Builder with standard components and controls.
-
Connect to Excel Online from a Connection Pool in JBoss
Integrate Microsoft Excel Online into Java servlets: Use the Management Console in JBoss to install the Excel Online JDBC Driver.
-
Analyze Redis in Cognos Analytics
Use CData Connect AI to connect to Redis from Cognos Analytics and analyze live Redis.
-
How to connect to SAP Ariba Procurement from Spring Boot
Connect to SAP Ariba Procurement in a Spring Boot Application using CData JDBC SAP Ariba Procurement Driver
-
Build Dashboards with Cvent in DBxtra
Create dynamic dashboards and perform analytics based on Cvent in DBxtra.
-
How to Work with SAP Ariba Source in AWS Glue Jobs Using JDBC
Connect to SAP Ariba Source from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
How to connect to Email from Spring Boot
Connect to Email in a Spring Boot Application using CData JDBC Email Driver
-
Automate Microsoft Project Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Microsoft Project from PowerShell? This article demonstrates how to utilize the Microsoft Project Cmdlets for tasks like connecting to Microsoft Project, automating operations, downloading data, and more.
-
A PostgreSQL Interface for Calendly (MySQL Remoting via JDBC)
Use the Remoting features of the Calendly JDBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to and Query WooCommerce in QlikView over ODBC
Create data visualizations with WooCommerce in QlikView.
-
How to connect to Microsoft OneDrive with Squirrel SQL client
Connect to Microsoft OneDrive and execute queries in the Squirrel SQL Client.
-
Query CouchDB using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume CouchDB entities in PHP by modeling them as objects.
-
Access Live Salesloft in AWS Lambda (with IntelliJ IDEA)
Connect to live Salesloft in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Bridge Adobe Target Connectivity with Apache NiFi
Access and process Adobe Target in Apache NiFi using the CData JDBC Driver.
-
Publish Crystal Reports on Couchbase
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Couchbase.
-
Create Apps from Microsoft Exchange in Qlik Sense Cloud
Use CData Connect AI to connect to Microsoft Exchange and build apps from live Microsoft Exchange in Qlik Sense Cloud.
-
Analyze HarperDB in R via JDBC
Use standard R functions and the development environment of your choice to analyze HarperDB with the CData JDBC Driver for HarperDB.
-
Visualize IBM Cloud Object Storage from Tableau
Use the Tableau Desktop business intelligence tool to connect to IBM Cloud Object Storage.
-
Connecting Moonlit Workflow with Google Spanner via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Moonlit workflows to securely read and act on your Google Spanner in real time.
-
Create Amazon Marketplace-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Amazon Marketplace from OutSystems and build custom enterprise apps using live Amazon Marketplace.
-
Analyze LinkedIn Ads in Cognos Analytics
Use CData Connect AI to connect to LinkedIn Ads from Cognos Analytics and analyze live LinkedIn Ads.
-
Prepare, Blend, and Analyze Stripe in Alteryx Designer (ODBC)
Build workflows to access live Stripe for self-service data analytics.
-
Integrate Azure Analysis Services in the Pentaho Report Designer
Publish reports based on Azure Analysis Services in the Pentaho BI tool.
-
Edit and Search External Microsoft Planner Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Microsoft Planner to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Microsoft Planner objects that you can access from apps and the dashboard.
-
Automated Continuous Salesforce Marketing Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Salesforce Marketing replication to Amazon Redshift.
-
Build a PostgreSQL Interface for OneNote using the CData JDBC Driver
Use the Remoting features of the OneNote JDBC Driver to create a PostgreSQL entry-point for data access.
-
Import and Visualize Google Calendar in Power View
Create data visualizations based on Google Calendar in Excel.
-
Access Live Jira Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live Jira data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Integrating Boomi Agentstudio with Splunk via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Splunk, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Integrating Dataiku with Freshdesk via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Freshdesk.
-
Building Dynamic Web Pages with Kafka Using AngularJS
Create single-page applications with live connectivity to Kafka using the CData API Server.
-
How to publish and share MailChimp dashboards with Tableau Server
The CData ODBC driver for MailChimp enables you integrate MailChimp into Tableau dashboards.
-
Connect to Microsoft Planner from PowerBuilder via ADO.NET
This article demonstrates how to access Microsoft Planner from Appeon PowerBuilder using the CData ADO.NET Provider for Microsoft Planner.
-
Visualize Twitter in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load Twitter into TIBCO Spotfire.
-
Connect to Hive from AWS Glue
Use CData Connect AI to gain access to live Apache Hive from your AWS Glue jobs.
-
Use the CData Software JDBC Driver for Amazon DynamoDB in MicroStrategy
Connect to Amazon DynamoDB in MicroStrategy Developer using the CData Software JDBC Driver for Amazon DynamoDB.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed ADP to Power BI dashboards. Simply drag and drop ADP into data visuals on the Power BI canvas.
-
How to create an RPA flow for BigQuery in UiPath Studio
Use the BigQuery ODBC Driver to create workflows that access real-time Google BigQuery without any coding.
-
Connect to QuickBooks in Ruby
Connect to QuickBooks Desktop in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Migrating data from Klaviyo to Google BigQuery using CData SSIS Components.
Easily push Klaviyo to Google BigQuery using the CData SSIS Tasks for Klaviyo and Google BigQuery.
-
Analyze Google Campaign Manager 360 in Infragistics Reveal
Use the CData API Server to create an OData API on top of Google Campaign Manager 360 and visualize live Google Campaign Manager 360 in Infragistics Reveal.
-
Connect to Live Databricks in PostGresSQL Interface through CData Connect AI
Create a live connection to Databricks in CData Connect AI and connect to your Databricks from PostgreSQL.
-
Automated Continuous CockroachDB Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable CockroachDB replication to PostgreSQL.
-
A PostgreSQL Interface for JotForm using the CData ODBC Driver
Use the SQL Gateway and JotForm ODBC Driver to create a PostgreSQL entry-point for data access.
-
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.
-
Extract, Transform, and Load Google Drive in Informatica PowerCenter
Create a simple Workflow for Google Drive in Informatica PowerCenter.
-
Create Dashboards and Visualize Live Redis in Geckoboard
Use CData Connect AI to connect to live Redis and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Build Data Flows from Pinterest to SQL Server using SSIS
Easily back up Pinterest to SQL Server using the SSIS components for Pinterest.
-
Connect to ShipStation from a Connection Pool in JBoss
Integrate ShipStation into Java servlets: Use the Management Console in JBoss to install the ShipStation JDBC Driver.
-
Access Aha 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 Aha!.
-
How to Query Live Dynamics NAV Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Microsoft Dynamics NAV data in natural language using Python.
-
Replicate Sage 300 from PowerShell
Write a quick PowerShell script to query Sage 300. Use connectivity to the live data to replicate Sage 300 to SQL Server.
-
Automate Salesforce Marketing Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live Salesforce Marketing Cloud and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
Extract, Transform, and Load HubDB in Informatica PowerCenter
Create a simple Workflow for HubDB in Informatica PowerCenter.
-
Connect to HCL Domino in Ruby
Connect to HCL Domino in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Connecting GenSpark with MariaDB via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to enterprise data across 300+ systems without any replication or custom integration required.
-
How to Query Live Vault CRM in Perplexity MacOS Desktop
Connect to and query live Vault CRM in Perplexity Desktop using the CData MCP Server.
-
How to connect to SAP HANA with Squirrel SQL client
Connect to SAP HANA and execute queries in the Squirrel SQL Client.
-
Manage Hive in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Hive.
-
Analyze REST in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of REST and visualize the live in Slingshot (formerly Reveal BI) for seamless insights.
-
How to connect SharePoint with Google Contacts through external lists
Provide Google Contacts to SharePoint users as an external list.
-
Integrate eBay Analytics with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate eBay Analytics with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to eBay Analytics.
-
Use the CData Software JDBC Driver for JDBC-ODBC Bridge in MicroStrategy Web
Connect to JDBC-ODBC Bridge in MicroStrategy Web using the CData Software JDBC Driver for JDBC-ODBC Bridge.
-
Build SAP SuccessFactors-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for SAP SuccessFactors and create custom apps in Mendix.
-
Use the CData Software JDBC Driver for Monday.com in MicroStrategy Desktop
Connect to Monday.com in MicroStrategy Desktop using the CData Software JDBC Driver for Monday.com.
-
Query Amazon Marketplace from Node.js
Use the OData endpoint of the CData API Server to connect to your Amazon Marketplace and perform CRUD operations on Amazon Marketplace from Node.js.
-
Access Live Acumatica in Coginiti Pro
Connect to and query live Acumatica ERP from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Prepare, Blend, and Analyze Google Calendar in Alteryx Designer (Connect AI)
Build workflows to access live Google Calendar for self-service data analytics.
-
DataBind Charts to Kintone
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Kintone from controls in the Visual Studio toolbox. This article demonstrates a graphical approach using wizards in Visual Studio, as well as how to databind with only a few lines of code.
-
Use JayDeBeApi to access PayPal in Python
Use standard Python scripting and the development environment of your choice to access live PayPal.
-
Connect to SurveyMonkey in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for SurveyMonkey and connect to SurveyMonkey in Akorbi Digital RunMyProcess.
-
Enable the HCL Domino JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with HCL Domino.
-
Configure the CData JDBC Driver for Zendesk in a Connection Pool in Tomcat
Connect to Zendesk from a connection pool in Tomcat.
-
Automated Continuous BambooHR Replication to Microsoft Access
Use CData Sync for automated, continuous, customizable BambooHR replication to Microsoft Access.
-
Connect and Query Live Instagram Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Instagram into Databricks
-
How to use SQLAlchemy ORM to access Shopify in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Shopify.
-
Getting Started with the CData Excel Add-In for OneNote
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for OneNote.
-
Create Dashboards and Visualize Live Snapchat Ads in Geckoboard
Use CData Connect AI to connect to live Snapchat Ads and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Use the CData SSIS Components to Insert New or Update Existing Stripe Records from SQL Server
Easily push SQL Server data to Stripe using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Stripe or update existing records with data from a SQL Server database.
-
Build Apps with Live SAP HANA XS Advanced Using the Low-Code Development Platform of Mendix
-