CData Software - Knowledge Base
Recent Articles
-
Access Phoenix as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Apache Phoenix from your Oracle system.
-
Integrate with Hive in SnapLogic
Use CData Connect AI to connect to and integrate with live Apache Hive in SnapLogic.
-
Connect to Twilio as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Twilio.
-
Import MongoDB into the Power BI Service for Visualizations
Use CData Connect AI to connect to MongoDB and provide access to live MongoDB for custom reports in the Power BI Service.
-
View Reports on Real-Time SAP Business One in Power BI Report Server
Use the CData ODBC Driver for SAP Business One to visualize SAP Business One in Power BI Desktop and then publish them to Power BI Report Server.
-
Automate OData Services Replication to Couchbase
Use CData Sync to Customize and automate OData replication to Couchbase.
-
Access Live SAP ByDesign Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live SAP ByDesign data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
How to Connect to & Open Invoiced in Microsoft Excel
This article uses the CData ODBC driver for Invoiced to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Query XML from Node.js
Use the OData endpoint of the CData API Server to connect to your XML Files and perform CRUD operations on XML from Node.js.
-
Viewing PayPal in RAD Studio Data Explorer
How to view PayPal in RAD Studio Data Explorer using the CData ODBC Driver for PayPal.
-
How to Create Power BI Visual Reports with Real-Time XML
Use CData Power BI Connectors to visualize XML Files in Power BI.
-
Integrate Jira Assets in Pentaho Data Integration
Build ETL pipelines based on Jira Assets in the Pentaho Data Integration tool.
-
How to Connect DBeaver to ConstantContact via a JDBC Driver
Manage ConstantContact with visual tools in DBeaver like the query browser.
-
Choosing the Best Method to Connect Avalara AvaTax to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Avalara AvaTax from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Visualize Live Zuora in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Zuora into custom reports in Power BI.
-
Integrate with Zuora in JReport Designer
Create charts and reports based on Zuora in JReport Designer.
-
Connect to Spark in Ruby
Connect to Apache Spark SQL in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Connect to Quickbase in JRuby
Create a simple JRuby app with access to live Quickbase.
-
DataBind Controls to Google Drive in Delphi
DataBind to Google Drive in Delphi with standard data access components and controls.
-
Model, Search, and Visualize Live Xero in ThoughtSpot
Use CData Connect AI to connect to live Xero Accounting for modeling, searching, and visualizing.
-
Build Zoho CRM-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Zoho CRM and create custom apps in Bubble.
-
Load Adobe Experience Manager to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Adobe Experience Manager to a database.
-
Automated Continuous MariaDB Replication to SQLite
Use CData Sync for automated, continuous, customizable MariaDB replication to SQLite.
-
Extract, Transform, and Load Printify in Informatica PowerCenter
Create a simple Workflow for Printify in Informatica PowerCenter.
-
Replicate Reckon Accounts Hosted to Multiple Databases
Replicate Reckon Accounts Hosted to disparate databases with a point-and-click configuration.
-
Create SSAS Tabular Models from Gmail
How to build a SQL Server Analysis Service Tabular Model from Gmail using CData drivers.
-
Connect to Google Analytics in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Google Analytics in Airbyte.
-
Use the CData Software ODBC Driver for Asana in SAS for Real-Time Reporting and Analytics
Connect to real-time Asana in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Asana.
-
Analyze SingleStore in Infragistics Reveal
Use CData Connect AI to create on OData API on top of SingleStore and visualize live SingleStore in Infragistics Reveal.
-
Build Oracle HCM Cloud-Powered Applications in GitHub Copilot with CData Code Assist MCP
-