CData Software - Knowledge Base
Recent Articles
-
Automated Continuous SAP Hybris C4C Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable SAP Hybris C4C replication to Azure SQL Database.
-
Create Tableau CRM Analytics-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Tableau CRM Analytics from OutSystems and build custom enterprise apps using live Tableau CRM Analytics.
-
Seamlessly Bring Slack into Retool Using CData Connect AI
Integrate Slack data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Write a Simple Go Application to work with SAP Ariba Procurement on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to SAP Ariba Procurement.
-
Publish Sybase-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Sybase.
-
Connect WordPress to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect WordPress with IBM WebSphere for seamless data integration and connectivity.
-
How to Work with Bitbucket in ETL Validator JDBC
Connect to Bitbucket from ETL Validator jobs using the CData Software JDBC Driver.
-
Connect to Amazon Marketplace from HeidiSQL
Use CData Connect AI to connect to and query live Amazon Marketplace from HeidiSQL.
-
Extract, Transform, and Load SAP Hybris C4C in Informatica PowerCenter
Create a simple Workflow for SAP Hybris C4C in Informatica PowerCenter.
-
Import Xero Using Azure Data Factory
Use CData Connect AI to connect to Xero from Azure Data Factory and import live Xero Accounting.
-
How to create EventBrite federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Eventbrite in MySQL .
-
Analyze MySQL in Looker
Use CData Connect AI to connect to MySQL from Looker and build custom apps using live MySQL.
-
Natively Connect to Asana in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Asana. Leverage the native support for ODBC in PHP.
-
Connect to Cvent from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Cvent to connect to Cvent and execute queries in PowerBuilder.
-
Automated Continuous Bullhorn CRM Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Bullhorn CRM replication to Apache Cassandra.
-
Visualize IBM Cloud Object Storage in Sisense
Create an ElastiCube in Sisense app with access to IBM Cloud Object Storage.
-
Integrate Sage 200 into Automated Tasks with Power Automate
Use CData Connect AI to connect to Sage 200 and integrate live Sage 200 into your Power Automate tasks.
-
Integrating LangGraph with Kintone via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Kintone within automated workflows.
-
Connect to Avalara AvaTax from a Connection Pool in JBoss
Integrate Avalara AvaTax into Java servlets: Use the Management Console in JBoss to install the Avalara AvaTax JDBC Driver.
-
Access Live MYOB AccountRight in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live MYOB AccountRight from your Google Sheets.
-
Analyze Jira in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Atlassian Jira in Microsoft R Open.
-
Automated Continuous Zendesk Replication to Microsoft Access
Use CData Sync for automated, continuous, customizable Zendesk replication to Microsoft Access.
-
How to Query Twitter Ads in MySQL Workbench
Execute MySQL queries against live Twitter Ads from MySQL Workbench.
-
How to connect to WooCommerce from Spring Boot
Connect to WooCommerce in a Spring Boot Application using CData JDBC WooCommerce Driver
-
Connect to eBay Analytics in CloverDX (formerly CloverETL)
Transfer eBay Analytics using the visual workflow in the CloverDX data integration tool.
-
Connect to FTP in DBArtisan
Use wizards in DBArtisan to configure FTP Servers as a data source.
-
Query SAP ByDesign from Node.js
Use the OData endpoint of the CData API Server to connect to your SAP Business ByDesign and perform CRUD operations on SAP ByDesign from Node.js.
-
Use Claude to Talk to Your Slack via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your Slack for you.
-
Analyze Dynamics 365 in Cognos Analytics
Use CData Connect AI to connect to Dynamics 365 from Cognos Analytics and analyze live Microsoft Dynamics 365.
-
Import Real-Time Tally via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Tally ERP in ColdFusion.
-
How to Connect to XML in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to XML Files. Leverage the pyodbc module for ODBC in Python.
-
Integrating LangGraph with Raisers Edge NXT via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Raisers Edge NXT within automated workflows.
-
Using CData JDBC Drivers in ColdFusion
This article will demonstrate how to use the CData JDBC Drivers with ColdFusion. Included are steps for adding the CData JDBC Driver as a data source, as well as basic ColdFusion code to query the data source and display results.
-
Integrate Jira in the Pentaho Report Designer
Publish reports based on Atlassian Jira in the Pentaho BI tool.
-
Connect to Harvest from PowerBuilder via JDBC
This article demonstrates how to access Harvest from PowerBuilder using the Harvest JDBC Driver.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Oracle Eloqua Reporting
Provide connectivity to Oracle Eloqua Reporting through an SAP BusinessObjects universe.
-
Build Greenplum Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Pivotal GreenPlum and build visualizations in Tableau.
-
Query NetSuite using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume NetSuite entities in PHP by modeling them as objects.
-
Prepare, Blend, and Analyze HubDB in Alteryx Designer (ODBC)
Build workflows to access live HubDB for self-service data analytics.
-
Automated Continuous MongoDB Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable MongoDB replication to PostgreSQL.
-
Connect to and Visualize Live Klaviyo in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Klaviyo.
-
Connect to DB2 in CloverDX (formerly CloverETL)
Transfer IBM DB2 using the visual workflow in the CloverDX data integration tool.
-
Getting Started with the CData JDBC Driver for Freshdesk
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Freshdesk.
-
Feed Dropbox into FineReport
How to set Dropbox as a JDBC data source in FineReport.
-
Build Dynamics CRM-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Microsoft Dynamics CRM and build Dynamics CRM-connected web apps with Axios.
-
Integrate Salesforce Pardot in the Pentaho Report Designer
Publish reports based on Salesforce Pardot in the Pentaho BI tool.
-
Natively Connect to ConstantContact in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to ConstantContact. Leverage the native support for ODBC in PHP.
-
How to Build an ETL App for Square in Python with CData
Create ETL applications and real-time data pipelines for Square in Python with petl.
-
Replicate Data from Multiple Files in an Amazon S3 Bucket Using CData Sync
Use CData Sync to replicate multiple files from an Amazon S3 bucket to a data warehouse
-
Stream Twitter into Apache Kafka Topics
Access and stream Twitter in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
How to Query Live MYOB AccountRight in Perplexity MacOS Desktop
Connect to and query live MYOB AccountRight in Perplexity Desktop using the CData MCP Server.
-
Access Live FHIR in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to FHIR from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Connect to Oracle Service Cloud from PowerBuilder via ADO.NET
This article demonstrates how to access Oracle Service Cloud from Appeon PowerBuilder using the CData ADO.NET Provider for Oracle Service Cloud.
-
SAP Hybris C4C Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to SAP Hybris C4C through CData Connect AI using different applications and tools.
-
How to connect PolyBase to Facebook Ads
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Facebook Ads.
-
How to work with SAP in Apache Spark using SQL
Access and process SAP in Apache Spark using the CData Software JDBC Driver.
-
Create Data Visualizations in Cognos BI with Invoiced
Access Invoiced as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Connect Paylocity to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Paylocity with IBM WebSphere for seamless data integration and connectivity.
-
Query Excel Online through ODBC in Node.js
Use node-odbc to execute SQL queries against Microsoft Excel Online from Node.js.
-
Getting Started with the CData Excel Add-In for Microsoft Dataverse
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Microsoft Dataverse.
-
Access Live SAP BusinessObjects BI in AWS Lambda (with IntelliJ IDEA)
Connect to live SAP BusinessObjects BI in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Integrate CSV in Pentaho Data Integration
Build ETL pipelines based on CSV/TSV Files in the Pentaho Data Integration tool.
-
Publish Dynamics CRM-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Microsoft Dynamics CRM.
-
How to create Visio diagrams from Highrise
Automatically update Highrise CRM with the changes you make to Visio master shapes.
-
Create Apps from Xero in Qlik Sense Cloud
Use CData Connect AI to connect to Xero and build apps from live Xero Accounting in Qlik Sense Cloud.
-
Build Dashboards with Cassandra in Dundas BI
Create dynamic dashboards and perform analytics based on Apache Cassandra in Dundas BI.
-
Access Live Harvest in Coginiti Pro
Connect to and query live Harvest from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Establish a Live Connection with Excel using Tableau Bridge
The CData ODBC Driver for Excel enables you to integrate live Microsoft Excel into Tableau Cloud dashboards using the Tableau Bridge.
-
How to Connect to Live Shopify from Google ADK Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Google ADK agents to securely read and take actions on your Shopify for you.
-
Automated Continuous Amazon Athena Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Amazon Athena replication to IBM DB2.
-
Connect to SAP Fieldglass from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for SAP Fieldglass to connect to SAP Fieldglass and execute queries in PowerBuilder.
-
Build Dashboards with Odoo in DBxtra
Create dynamic dashboards and perform analytics based on Odoo ERP in DBxtra.
-
Integrate with MySQL in SnapLogic
Use CData Connect AI to connect to and integrate with live MySQL in SnapLogic.
-
Use JayDeBeApi to access Dynamics NAV in Python
Use standard Python scripting and the development environment of your choice to access live Microsoft Dynamics NAV.
-
Import Salesforce into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Salesforce & Force.com. In this article, you will use the OData format to import Salesforce & Force.com into Microsoft Power Query.
-
Access Live Twitter in AWS Lambda
Connect to live Twitter in AWS Lambda using the CData JDBC Driver.
-
Connect to Zuora in CloverDX (formerly CloverETL)
Transfer Zuora using the visual workflow in the CloverDX data integration tool.
-
Create IBM Informix Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time IBM Informix data access from reports, embedded analytics, and more.
-
How to publish and share DocuSign dashboards with Tableau Server
The CData ODBC driver for DocuSign enables you integrate DocuSign into Tableau dashboards.
-
Use the CData Software ODBC Driver for Azure Table in SAS for Real-Time Reporting and Analytics
Connect to real-time Azure Table Storage in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Azure Table.
-
Query SAP Ariba Source as a MySQL Database in Node.js
Execute MySQL queries against SAP Ariba Source from Node.js.
-
Back Up LDAP to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for LDAP. In this article, we will employ an SSIS workflow to populate a database with LDAP data.
-
Natively Connect to BambooHR in PHP
The CData ODBC driver for BambooHR enables you to create PHP applications with connectivity to BambooHR. Leverage the native support for ODBC in PHP.
-
Integrate Dynamics CRM in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Microsoft Dynamics CRM from Informatica Cloud.
-
Connect to Twilio as an External Data Source using PolyBase
Use CData Connect AI and PolyBase to create an external data source in SQL Swerver with access to live Twilio.
-
Access Live Salesforce in TIBCO Data Virtualization
-