CData Software - Knowledge Base
Recent Articles
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed SQL Analysis Services to Power BI dashboards. Simply drag and drop SQL Analysis Services into data visuals on the Power BI canvas.
-
Create Power BI Reports on Real-Time Cvent
Use the CData ODBC Driver for Cvent to visualize Cvent in Power BI Desktop.
-
Create Reports from Couchbase in Looker Studio
Use CData Connect AI to gain access to live Couchbase and create custom reports in Looker Studio.
-
Build Oracle Service Cloud-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Oracle Service Cloud.
-
Automate QuickBooks Integration Tasks from PowerShell
Are you in search of a quick and easy way to access QuickBooks Desktop from PowerShell? This article demonstrates how to utilize the QuickBooks Cmdlets for tasks like connecting to QuickBooks Desktop, automating operations, downloading data, and more.
-
Use the CData ODBC Driver for Odoo in Microsoft Power Query
You can use the CData Odoo ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Odoo ERP into Microsoft Power Query.
-
Load Amazon S3 to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Amazon S3 to a database.
-
Connect to Authorize.Net from a Connection Pool in Jetty
The Authorize.Net JDBC Driver supports connection pooling: This article shows how to connect faster to Authorize.Net from Web apps in Jetty.
-
Integrate Azure Table into Automated Tasks with Power Automate
Use CData Connect AI to connect to Azure Table Storage and integrate live Azure Table Storage into your Power Automate tasks.
-
How to Connect to Live HCL Domino from OpenAI Python Applications (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable OpenAI-powered Python applications to securely read and take actions on your HCL Domino through natural language.
-
Visualize Live Excel Online in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Microsoft Excel Online into custom reports in Power BI.
-
Automated Continuous Twilio Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Twilio replication to Apache Kafka.
-
Import and Visualize Oracle Eloqua Reporting in Power View
Create data visualizations based on Oracle Eloqua Reporting in Excel.
-
Automated Continuous Sybase IQ Replication to Vertica
Use CData Sync for automated, continuous, customizable Sybase IQ replication to Vertica.
-
Integrate with Teradata using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Teradata to a JSON file on disk.
-
Integrating LangChain with Active Directory via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Active Directory within automated workflows.
-
Connect to NetSuite as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live NetSuite CRM & ERP.
-
How to Seamlessly Import Lakebase Data into IBM SPSS Modeler
Integrate Lakebase data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Create Power BI Reports on Real-Time Oracle HCM Cloud
Use the CData ODBC Driver for Oracle HCM Cloud to visualize Oracle HCM Cloud in Power BI Desktop.
-
Back Up Reckon Accounts Hosted to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Reckon Accounts Hosted. In this article, we will employ an SSIS workflow to populate a database with Reckon Accounts Hosted data.
-
Operational Reporting on SAP HANA XS Advanced from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote SAP HANA XS Advanced.
-
Bind Live Databricks Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Databricks data
-
Use JayDeBeApi to access QuickBooks in Python
Use standard Python scripting and the development environment of your choice to access live QuickBooks Desktop.
-
Access BigQuery from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Google BigQuery from HeidiSQL.
-
How to Build an ETL App for Twilio in Python with CData
Create ETL applications and real-time data pipelines for Twilio in Python with petl.
-
Integrate Cline with Live Amazon Marketplace Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Amazon Marketplace from within your IDE.
-
Connect to BambooHR as an External Source in Dremio
Use the CData JDBC Driver to connect to BambooHR as an External Source in Dremio.
-
How to Query Salesforce Pardot in MySQL Workbench
Execute MySQL queries against live Salesforce Pardot from MySQL Workbench.
-
Connect to Harvest in RapidMiner
Integrate Harvest with standard components and data source configuration wizards in RapidMiner Studio.
-
Connect to SAP Fieldglass in NetBeans
Connect to SAP Fieldglass in NetBeans with the data source configuration wizard.
-
Getting Started with the CData Excel Add-In for Blackbaud FE NXT
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Blackbaud FE NXT.
-
Use Biml to Build SSIS Tasks to Replicate HubDB to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate HubDB to SQL Server.
-
Access Live Stripe in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Stripe from your Excel spreadsheets.
-
How to publish and share SharePoint Excel Services dashboards with Tableau Server
The CData ODBC driver for SharePoint Excel Services enables you integrate SharePoint Excel Services into Tableau dashboards.
-
How to Query Live SAP Business One Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live SAP Business One data in natural language using Python.
-
Extract, Transform, and Load Zendesk in Informatica PowerCenter
Create a simple Workflow for Zendesk in Informatica PowerCenter.
-
Back Up Zendesk to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Zendesk. In this article, we will employ an SSIS workflow to populate a database with Zendesk data.
-
Integrating Boomi Agentstudio with MailChimp via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to MailChimp, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Integrate with Basecamp using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Basecamp to a JSON file on disk.
-
Getting Started with the CData SSIS Components for Wave Financial
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Wave Financial.
-
How to Create Power BI Visual Reports with Real-Time Google Data Catalog
Use CData Power BI Connectors to visualize Google Data Catalog in Power BI.
-
Build Semantic Layer Views for Facebook Ads in APOS Live Data Gateway
Use the CData Connector for Facebook Ads in APOS Live Data Gateway to build Semantic Layer Views for Facebook Ads.
-
How to connect to Google Search Results from Spring Boot
Connect to Google Search in a Spring Boot Application using CData JDBC Google Search Driver
-
Connect to and Visualize Live Azure Table in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Azure Table Storage.
-
How to Connect to MariaDB in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to MariaDB. Leverage the pyodbc module for ODBC in Python.
-
How to Connect the Power BI Service to Zendesk: Complete Guide
Connect to the CData Software Power BI Connectors from PowerBI.com to provide real-time datasets across the organization.
-
How to Access Live ADP in Visual Studio Code via Cline
-