CData Software - Knowledge Base
Recent Articles
-
Analyze Office 365 in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Microsoft Office 365 and visualize the live in Slingshot (formerly Reveal BI) for seamless insights.
-
How to work with DB2 in Apache Spark using SQL
Access and process DB2 in Apache Spark using the CData Software JDBC Driver.
-
How to Work with Adobe Commerce in ETL Validator JDBC
Connect to Adobe Commerce from ETL Validator jobs using the CData Software JDBC Driver.
-
Replicate Sybase to Multiple Databases
Replicate Sybase to disparate databases with a point-and-click configuration.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed Exact Online to Power BI dashboards. Simply drag and drop Exact Online into data visuals on the Power BI canvas.
-
Connect to and Visualize Live FTP in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live FTP Servers.
-
Automated Continuous Amazon Marketplace Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Amazon Marketplace replication to Apache Kafka.
-
Object-Relational Mapping (ORM) with Shopify 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 Shopify into a Java-based ORM framework, Hibernate.
-
How to Query Live SharePoint Excel Services in Claude Desktop
Connect to and query live SharePoint Excel Services in Claude Desktop using CData Code Assist MCP.
-
Build Automated Workflows with Live Snapchat Ads in Workato
Use CData Connect AI to connect to live Snapchat Ads and build automated workflows in Workato.
-
Visualize MYOB AccountRight in TIBCO Spotfire through OData
Integrate MYOB AccountRight into dashboards in TIBCO Spotfire.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Sugar CRM
Provide connectivity to Sugar CRM through an SAP BusinessObjects universe.
-
Automated Continuous NetSuite Replication to AlloyDB
Use CData Sync for automated, continuous, customizable NetSuite replication to AlloyDB.
-
Visualize Epicor Kinetic in TIBCO Spotfire through ADO.NET
Integrate Epicor Kinetic into dashboards in TIBCO Spotfire.
-
Connecting Mastra with Adobe Commerce via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to enable Mastra agents to securely query, read, and act on real-time data across hundreds of enterprise sources no replication required.
-
Create Power BI Reports on Real-Time IBM Cloud Object Storage
Use the CData ODBC Driver for IBM Cloud Object Storage to visualize IBM Cloud Object Storage in Power BI Desktop.
-
How to work with Sage Intacct in Apache Spark using SQL
Access and process Sage Intacct in Apache Spark using the CData Software JDBC Driver.
-
Working with Epicor Kinetic in LINQPad
Execute LINQ queries to Epicor Kinetic in LINQPad.
-
How to Create Power BI Visual Reports with Real-Time Zoho Creator
Use CData Power BI Connectors to visualize Zoho Creator in Power BI.
-
Query Epicor Kinetic as a MySQL Database in Node.js
Execute MySQL queries against Epicor Kinetic from Node.js.
-
Create Informatica Mappings From/To an ODBC Data Source for Active Directory
Create an ODBC connection to Active Directory in Informatica and browse and transfer Active Directory.
-
How to Visualize MariaDB Data in Python with pandas
Use pandas and other modules to analyze and visualize live MariaDB in Python.
-
Build Couchbase-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Couchbase and create custom apps in Bubble.
-
How to Connect Flowise AI Agents to Live API via CData Connect AI
Integrate Flowise AI with the CData Connect AI MCP Server to enable agents to securely query and act on live data without replication.
-
Use the CData Software JDBC Driver for SAP Ariba Source in MicroStrategy Desktop
Connect to SAP Ariba Source in MicroStrategy Desktop using the CData Software JDBC Driver for SAP Ariba Source.
-
Edit and Search Jira Service Management External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of Atlassian Jira Service Management to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create Jira Service Management objects that you can access from apps and the dashboard.
-
Build Semantic Layer Views for CockroachDB in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for CockroachDB.
-
Connect to WooCommerce in RazorSQL
Connect to WooCommerce from wizards and query WooCommerce from the GUI in the RazorSQL database management tool.
-
Building Dynamic Web Pages with GraphQL Using AngularJS
Create single-page applications with live connectivity to GraphQL using the CData API Server.
-
Migrating data from Salesforce Marketing to Databricks using CData SSIS Components.
Easily push Salesforce Marketing Cloud to Databricks using the CData SSIS Tasks for Salesforce Marketing and Databricks.
-
How to create QuickBooks federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for QuickBooks Desktop in MySQL .
-
Replicate Cvent from PowerShell
Write a quick PowerShell script to query Cvent. Use connectivity to the live data to replicate Cvent to SQL Server.
-
Build Facebook-Connected Apps in Choreo
Use CData Connect AI to connect to Facebook from Choreo and build custom apps using live Facebook.
-
Use JayDeBeApi to access Phoenix in Python
Use standard Python scripting and the development environment of your choice to access live Apache Phoenix.
-
Import and Visualize Microsoft Project in Power View
Create data visualizations based on Microsoft Project in Excel.
-
Explore Geographical Relationships in Reckon Accounts Hosted with Power Map
Create data visualizations with Reckon Accounts Hosted in Power Map.
-
Access DB2 from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live IBM DB2 from HeidiSQL.
-
Access Live Redshift in AWS Lambda
Connect to live Amazon Redshift in AWS Lambda using the CData JDBC Driver.
-
Connect to Real-Time Zendesk Data in Power Apps Using Dataflows to Build Custom Applications
-