Show articles by: Integration Technology | Driver Technology | Recent Articles

CData Software - Knowledge Base

Recent Articles

How to Connect the Power BI Service to Reckon Accounts Hosted: Complete Guide

Connect to the CData Software Power BI Connectors from PowerBI.com to provide real-time datasets across the organization.
Work with Live Act-On in Power Query

Use CData Connect AI to connect to Act-On and work with live Act-On in Microsoft Power Query.
Use the CData ODBC Driver for Amazon DynamoDB from SharePoint Excel Services

This article demonstrates how to use the CData ODBC Driver for Amazon DynamoDB to connect to Amazon DynamoDB from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Amazon DynamoDB in Excel.
Connect to Oracle HCM Cloud in RapidMiner

Integrate Oracle HCM Cloud with standard components and data source configuration wizards in RapidMiner Studio.
Visualize SFTP in TIBCO Spotfire through ODBC

The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load SFTP into TIBCO Spotfire.
ETL Dynamics 365 Business Central in Oracle Data Integrator

This article shows how to transfer Dynamics 365 Business Central into a data warehouse using Oracle Data Integrator.
Query, Visualize, and Share live Confluence in Redash

Use CData Connect AI to connect to live Atlassian Confluence in Redash for querying, visualizing, and sharing.
Import Sage Intacct into Microsoft Power Query

The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Sage Intacct. In this article, you will use the OData format to import Sage Intacct into Microsoft Power Query.
How to create ClickUp federated tables in MySQL

Use the SQL Gateway and the ODBC Driver to set up federated tables for ClickUp in MySQL .
Automate FTP Integration Tasks from PowerShell

Are you in search of a quick and easy way to access FTP Servers from PowerShell? This article demonstrates how to utilize the FTP Cmdlets for tasks like connecting to FTP Servers, automating operations, downloading data, and more.
Connect to Sugar CRM in ACL Analytics

Connect to Sugar CRM via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Sugar CRM.
Automated Continuous Zendesk Replication to AlloyDB

Use CData Sync for automated, continuous, customizable Zendesk replication to AlloyDB.
Automate CData Connect AI Replication to SAP HANA

Use CData Sync to customize and automate CData Connect AI replication to SAP HANA.
How to create Visio diagrams from JSON Services

Automatically update JSON with the changes you make to Visio master shapes.
Choosing the Best Method to Connect Box to SQL Server: 5 Options Explained

Discover multiple ways to connect and use Box from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
Connect to SAP Netweaver Gateway from PowerBuilder via JDBC

This article demonstrates how to access SAP Netweaver Gateway from PowerBuilder using the SAP Netweaver Gateway JDBC Driver.
Import Office 365 into Microsoft Power Query

The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Microsoft Office 365. In this article, you will use the OData format to import Microsoft Office 365 into Microsoft Power Query.
How to update Exact Online from Excel

This article explains how to transfer data from Excel to Exact Online using the Excel Add-In for Exact Online.
Creating Zoho Inventory-Connected Applications in Unqork

You can use CData Connect AI to feed Zoho Inventory to Unqork and build custom business apps.
Integrating Dataiku with Zoho CRM via CData Connect AI

Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Zoho CRM.
Getting Started with the CData JDBC Driver for GraphQL

Complete guide to installing, licensing, and connecting with the CData JDBC Driver for GraphQL.
Connect Dropbox to AI Assistants With the CData Python MCP Server

Learn how to give AI assistants like Claude direct access to live Dropbox using the CData Python MCP Server.
Prepare, Blend, and Analyze Redis in Alteryx Designer (ODBC)

Build workflows to access live Redis for self-service data analytics.
Visualize Live Parquet of Power BI Report Builder in Power BI Service

Use CData Power BI Connectors to connect to live Apache Parquet using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
Automate FTP Tasks in Power Automate Using CData API Server

With CData API Server, easily create OData endpoints for live FTP Servers and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
Getting Started with the CData Power BI Connector for Amazon DynamoDB