CData Software - Knowledge Base
Recent Articles
-
Connect to SAS Data Sets in RazorSQL
Connect to SAS Data Sets from wizards and query SAS Data Sets from the GUI in the RazorSQL database management tool.
-
Object-Relational Mapping (ORM) with Phoenix 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 Apache Phoenix into a Java-based ORM framework, Hibernate.
-
Work with Live Amazon DynamoDB in Power Query
Use CData Connect AI to connect to Amazon DynamoDB and work with live Amazon DynamoDB in Microsoft Power Query.
-
Provide OData Services of Facebook from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Facebook by developing a WCF Service Application.
-
Import and Visualize Google Cloud Storage in Power View
Create data visualizations based on Google Cloud Storage in Excel.
-
Create Informatica Mappings From/To a JDBC Data Source for RSS
Create RSS data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Visualize SuiteCRM in Sisense
Create an ElastiCube in Sisense app with access to SuiteCRM.
-
How to pipe Oracle HCM Cloud to CSV in PowerShell
Use standard PowerShell cmdlets to access Oracle HCM Cloud tables.
-
Build Data Flows from Oracle Financials Cloud to SQL Server using SSIS
Easily back up Oracle Financials Cloud to SQL Server using the SSIS components for Oracle Financials Cloud.
-
How to connect Amazon QuickSight to Zoho Creator
Create a connection to Zoho Creator in CData Connect AI and insert Zoho Creator into Amazon QuickSight SPICE to build interactive dashboards.
-
How to Connect to Live Azure Synapse in n8n Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable n8n to securely read and take actions on your Azure Synapse for you.
-
Load Adobe Commerce to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Adobe Commerce to a database.
-
Connect to Avalara AvaTax in Google Apps Script via SQL Gateway
Use the ODBC Driver for Avalara AvaTax and the SQL Gateway to access Avalara AvaTax from Google Apps Script.
-
How to Connect Flowise AI Agents to Live OneNote 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.
-
How to Build an ETL App for Xero in Python with CData
Create ETL applications and real-time data pipelines for Xero Accounting in Python with petl.
-
Changelog: Driver Update 2024.3
Review the driver-specific changes from the 2024.3 CData Driver release.
-
Connect to MariaDB in RazorSQL
Connect to MariaDB from wizards and query MariaDB from the GUI in the RazorSQL database management tool.
-
Model Bullhorn CRM Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Bullhorn CRM, enabling the direct import of real-time Bullhorn CRM.
-
Getting Started with the CData SSIS Components for HubDB
Complete guide to installing, licensing, and connecting with the CData SSIS Components for HubDB.
-
Replicate Multiple Trello Accounts
Replicate multiple Trello accounts to one or many databases.
-
Connect to PayPal in JRuby
Create a simple JRuby app with access to live PayPal.
-
Automated Continuous Sugar CRM Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Sugar CRM replication to delimited files (CSV/TSV).
-
Automated Continuous Act-On Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Act-On replication to OneLake in Microsoft Fabric.
-
Connect to Monday.com in Google Apps Script via SQL Gateway
Use the ODBC Driver for Monday.com and the SQL Gateway to access Monday.com from Google Apps Script.
-
Use Microsoft Copilot Studio to talk to your HubSpot via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Microsoft Copilot Studio to securely answer questions and take actions on your HubSpot for you.
-
Consume Sugar CRM OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Sugar CRM feeds that reflect any changes in SAP Lumira.
-
Build CouchDB-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Apache CouchDB.
-
Connect to Snapchat Ads in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Snapchat Ads in Airbyte.
-
Connect to SAP Concur as an External Data Source using PolyBase
Use CData Connect AI and PolyBase to create an external data source in SQL Swerver with access to live SAP Concur.
-
Redshift Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Redshift facts in real time.
-
Connect to FTP from PowerBuilder via ADO.NET
This article demonstrates how to access FTP Servers from Appeon PowerBuilder using the CData ADO.NET Provider for FTP.
-
Use JayDeBeApi to access MySQL in Python
Use standard Python scripting and the development environment of your choice to access live MySQL.
-
Visualize Live Airtable in the Power BI Service
Use CData Connect AI to connect to live Airtable and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Natively Connect to Unbounce in PHP
The CData ODBC driver for Unbounce enables you to create PHP applications with connectivity to Unbounce. Leverage the native support for ODBC in PHP.
-
Visualize Asana in TIBCO Spotfire through OData
Integrate Asana into dashboards in TIBCO Spotfire.
-
How to Connect DBeaver to Amazon Athena via a JDBC Driver
Manage Amazon Athena with visual tools in DBeaver like the query browser.
-
Visualize Live SAP Concur in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live SAP Concur.
-
Connect to SAP Concur from AWS Glue
Use CData Connect AI to gain access to live SAP Concur from your AWS Glue jobs.
-
A PostgreSQL Interface for Printify using the CData ODBC Driver
Use the SQL Gateway and Printify ODBC Driver to create a PostgreSQL entry-point for data access.
-
Automated Continuous Microsoft Planner Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Microsoft Planner replication to Google Cloud SQL.
-
Connect to and Visualize Live Paylocity in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Paylocity.
-
Create Power BI Reports on Real-Time Redshift
Use the CData ODBC Driver for Redshift to visualize Amazon Redshift in Power BI Desktop.
-
Automated Continuous Odoo Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Odoo replication to Amazon S3.
-
Access Live HDFS in AWS Lambda (with IntelliJ IDEA)
Connect to live Apache HDFS in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
How to pipe Klipfolio to CSV in PowerShell
Use standard PowerShell cmdlets to access Klipfolio tables.
-
Integrating Claude Code with Amazon DynamoDB via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Amazon DynamoDB within assisted coding and automated development workflows.
-
How to Connect to Live Google Directory 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 Google Directory through natural language.
-
How to connect to Oracle SCM with Squirrel SQL client
Connect to Oracle SCM and execute queries in the Squirrel SQL Client.
-
Connecting Agentforce with Couchbase via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Agentforce to securely read and take actions on your Couchbase for you.
-
Build AI/ML Models with Live Blackbaud FE NXT Data using Dataiku
-