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

CData Software - Knowledge Base

Recent Articles

Automate MYOB AccountRight Integration Tasks from PowerShell

Are you in search of a quick and easy way to access MYOB AccountRight from PowerShell? This article demonstrates how to utilize the MYOB AccountRight Cmdlets for tasks like connecting to MYOB AccountRight, automating operations, downloading data, and more.
Use Claude to Talk to Your Amazon DynamoDB via CData Connect AI

Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your Amazon DynamoDB for you.
How to Connect to Avalara AvaTax in Using Python: 6 Steps

Create Python applications on Linux/UNIX machines with connectivity to Avalara AvaTax. Leverage the pyodbc module for ODBC in Python.
How to integrate Sage Cloud Accounting with Apache Airflow

Access and process Sage Business Cloud Accounting in Apache Airflow using the CData JDBC Driver.
Create Reports from ActiveCampaign in Looker Studio

Use CData Connect AI to gain access to live ActiveCampaign and create custom reports in Looker Studio.
Automated Continuous SAP BusinessObjects BI Replication to Apache Cassandra

Use CData Sync for automated, continuous, customizable SAP BusinessObjects BI replication to Apache Cassandra.
Create Power BI Reports on Real-Time IBM Informix

Use the CData ODBC Driver for IBM Informix to visualize IBM Informix in Power BI Desktop.
Use the CData ODBC Driver for Microsoft Teams from SharePoint Excel Services

This article demonstrates how to use the CData ODBC Driver for Microsoft Teams to connect to Microsoft Teams from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Microsoft Teams in Excel.
Import and Visualize Active Directory in Power View

Create data visualizations based on Active Directory in Excel.
Back Up SAP Business ByDesign to SQL Server through SSIS

Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for SAP ByDesign. In this article, we will employ an SSIS workflow to populate a database with SAP Business ByDesign data.
Connect to Sage Intacct from Crystal Reports

Use CData Connect AI to connect to and report on live Sage Intacct from Crystal Reports.
How to Build an ETL App for Act-On in Python with CData

Create ETL applications and real-time data pipelines for Act-On in Python with petl.
Use Biml to Build SSIS Tasks to Replicate Wave Financial to SQL Server

Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Wave Financial to SQL Server.
Create a Data Access Object for SendGrid using JDBI

A brief overview of creating a SQL Object API for SendGrid in JDBI.
Integrating Gumloop with Jira Service Management via CData Connect AI

Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Atlassian Jira Service Management within automated workflows.
Build a Singer.io Tap for Freshdesk With the CData Python Connector

Learn how to easily build a Singer.io Tap for live Freshdesk data using
How to Connect to Live WooCommerce Data from Sourcegraph Amp (via CData Connect AI)

Integrate Sourcegraph Amp with CData Connect AI to query and manage live WooCommerce securely in real time.
Use the CData Software JDBC Driver for Google Spanner in MicroStrategy Desktop

Connect to Google Spanner in MicroStrategy Desktop using the CData Software JDBC Driver for Google Spanner.
Build Data Flows from Dynamics 365 Business Central to SQL Server using SSIS

Easily back up Dynamics 365 Business Central to SQL Server using the SSIS components for Dynamics 365 Business Central.
Getting Started with the CData ODBC Driver for XML

Complete guide to installing, licensing, and connecting with the CData ODBC Driver for XML.
Import Real-Time Instagram via ODBC in ColdFusion to Build Applications

Use CData ODBC drivers to import and use Instagram in ColdFusion.
Connect to Redis from AWS Glue

Use CData Connect AI to gain access to live Redis from your AWS Glue jobs.
How to Access Live Azure DevOps in Visual Studio Code via Cline

Run the CData MCP Server for Azure DevOps on Windows Subsytem for Linux (WSL) and connect to live Azure DevOps from the Cline extension in Visual Studio Code.
Bridge IBM Cloud Object Storage Connectivity with Apache NiFi

Access and process IBM Cloud Object Storage in Apache NiFi using the CData JDBC Driver.
Process & Analyze ShipStation in Databricks (AWS)

Use CData, AWS, and Databricks to perform data engineering and data science on live ShipStation .
How to connect Amazon QuickSight to Azure DevOps

Create a connection to Azure DevOps in CData Connect AI and insert Azure DevOps into Amazon QuickSight SPICE to build interactive dashboards.
Automated Continuous SAP Hybris C4C Replication to AlloyDB

Use CData Sync for automated, continuous, customizable SAP Hybris C4C replication to AlloyDB.
Integrate Invoiced with JetBrains RubyMine using CData JDBC Drivers

Learn how to integrate Invoiced with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Invoiced.
How to Work with LDAP Objects in AWS Glue Jobs Using JDBC

Connect to LDAP from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
Getting Started with the CData ADO.NET Provider for SAS xpt