CData Software - Knowledge Base
Recent Articles
-
How to connect and process Aircall from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Aircall.
-
How to Connect to Live SAP Business One Data from Claude Agent SDK (via CData Connect AI)
Leverage CData Connect AI to enable Claude Agent SDK applications to securely read and take actions on your SAP Business One for you.
-
Use the CData SSIS Components to Insert New or Update Existing PostgreSQL Records from SQL Server
Easily push SQL Server data to PostgreSQL using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into PostgreSQL or update existing records with data from a SQL Server database.
-
Visualize Live SAP Netweaver Gateway Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live SAP Netweaver Gateway.
-
How to Connect to Live SharePoint Data from Google ADK Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Google ADK agents to securely read and take actions on your Microsoft SharePoint for you.
-
Explore Geographical Relationships in Harvest Data with Power Map
Create data visualizations with Harvest in Power Map.
-
Consume Amazon DynamoDB OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Amazon DynamoDB feeds that reflect any changes in SAP Lumira.
-
Analyze Office 365 Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Microsoft Office 365 and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Create Dynamic Zuora Grids Using the Infragistics XamDataGrid
Learn how you can connect Zuora to Infragistics XamDataGrid to build dynamic grids.
-
Query Live Amazon S3 Data in Zed Editor via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Zed Editor to securely access and query live Amazon S3 directly from the development environment.
-
How to connect and process Oracle HCM Cloud from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Oracle HCM Cloud.
-
Connect to SAP Fieldglass Data in DBArtisan
Use wizards in DBArtisan to configure SAP Fieldglass as a data source.
-
Publish Crystal Reports on Avaza Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Avaza.
-
Integrating Antigravity CLI with Pingdom via CData CLI
Connect Pingdom to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Use the CData API Server to Access Lakebase Data in Microsoft PowerPivot
Use the CData API Server to connect to live Lakebase in the Power Pivot business intelligence tool.
-
Build Google Ads-Connected Apps in Choreo
Use CData Connect AI to connect to Google Ads Data from Choreo and build custom apps using live Google Ads.
-
Analyze Oracle Data in Cognos Analytics
Use CData Connect AI to connect to Oracle Data from Cognos Analytics and analyze live Oracle Database.
-
Extend Google Sheets with Amazon S3 Data
Make calls to Amazon S3 from Google Apps Script via the API Server.
-
Replicate Harvest Data from PowerShell
Write a quick PowerShell script to query Harvest. Use connectivity to the live data to replicate Harvest to SQL Server.
-
Integrating Antigravity CLI with Smartsheet via CData CLI
Connect Smartsheet to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Build Apps with Live QuickBooks Data Using the Low-Code Development Platform of Mendix
Connect QuickBooks Desktop with Mendix to build apps using the CData JDBC Driver for QuickBooks.
-
Create a Data Access Object for Sage Cloud Accounting Data using JDBI
A brief overview of creating a SQL Object API for Sage Business Cloud Accounting in JDBI.
-
Design BIRT Reports on Xero Data
Provide current Xero Accounting to your embedded analytics.
-
Build Guru-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Guru.
-
Replicate Multiple Oracle Financials Cloud Accounts via the CData Sync CLI
Replicate multiple Oracle Financials Cloud accounts to one or many databases.
-
Work with GitLab Data in FoxPro
Load GitLab into a FoxPro database. This article includes full code and a walk-through of the process.
-
Use Microsoft Copilot Studio to talk to your Dynamics CRM Data 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 Microsoft Dynamics CRM for you.
-
Integrating Kiro CLI with ChartMogul Data via CData CLI
CData CLI gives AI coding agents direct, command-line-native access to CData Drivers across hundreds of data sources, allowing agents to manage licenses, configure connections, run SQL queries, and explore schema metadata, all without leaving the terminal.
-
Connect to ZohoExpense Data from a Connection Pool in JBoss
Integrate ZohoExpense into Java servlets: Use the Management Console in JBoss to install the ZohoExpense JDBC Driver.
-
Integrate LibreChat with Live SQL Server Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Microsoft SQL Server from within the chat interface.
-
Create SSAS Tabular Models from Paymo Data
How to build a SQL Server Analysis Service Tabular Model from Paymo using CData drivers.
-
Automated Continuous Azure Blob Storage Replication to MySQL
Use CData Sync for automated, continuous, customizable Azure Blob Storage replication to MySQL.
-
Access Live Oracle HCM Cloud Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Oracle HCM Cloud from your Google Sheets.
-
Load Couchbase Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Couchbase to a database.
-
Build Clockify-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Clockify and build web apps with connectivity to live Clockify.
-
Configure the CData JDBC Driver for ChartMogul in a Connection Pool in Tomcat
Connect to ChartMogul from a connection pool in Tomcat.
-
Migrating data from Neo4J to Google BigQuery using CData SSIS Components.
Easily push Neo4J to Google BigQuery using the CData SSIS Tasks for Neo4J and Google BigQuery.
-
Migrating data from Eventbrite to Snowflake using CData SSIS Components.
Easily push Eventbrite to Snowflake using the CData SSIS Tasks for Eventbrite and Snowflake.
-
How to use SQLAlchemy ORM to access Sage 300 Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Sage 300.
-
Getting Started with the CData ADO.NET Provider for Cloudflare
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Working with Elorus Data in LINQPad
Execute LINQ queries to Elorus in LINQPad.
-
How to Visualize HDFS Data in Python with pandas
Use pandas and other modules to analyze and visualize live Apache HDFS in Python.
-
Create Azure Analysis Services-Connected Applications in Appsmith
Connect to Azure Analysis Services Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Azure Analysis Services.
-
Build CSV-Powered Applications in Gemini Code Assist with CData MCP Server
Use the CData MCP Server for CSV to explore live CSV Data in Gemini Code Assist to assist with building CSV-powered applications.
-
Publish Attio-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Attio.
-
DataBind Controls to Smartsheet Data in C++Builder
DataBind to Smartsheet in C++Builder with standard components and controls.
-
How to Work with WordPress Data in AWS Glue Jobs Using JDBC
Connect to WordPress from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Automated Continuous iContact Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable iContact replication to Apache Cassandra.
-
Blackbaud FE NXT Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Blackbaud FE NXT through CData Connect AI using different applications and tools.
-
Integrating LangChain with Jira Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Atlassian Jira within automated workflows.
-
DataBind Controls to Harvest Data in C++Builder
DataBind to Harvest in C++Builder with standard components and controls.
-
Visualize BenchmarkEmail Data in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load BenchmarkEmail into TIBCO Spotfire.
-
How to connect PolyBase to Twitter Ads
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Twitter Ads.
-
How to Query Live Google Spanner Data in Claude Desktop
Connect to and query live Google Spanner Data in Claude Desktop using CData MCP Server.
-
Automated Continuous Omnisend Replication to SQLite
Use CData Sync for automated, continuous, customizable Omnisend replication to SQLite.
-
Connect to SAP BusinessObjects BI Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for SAP BusinessObjects BI and the SQL Gateway to access SAP BusinessObjects BI from Google Apps Script.
-
Query, Visualize, and Share live SAP Netweaver Gateway Data in Redash
Use CData Connect AI to connect to live SAP Netweaver Gateway in Redash for querying, visualizing, and sharing.
-
How to Query Live Xero Data in Perplexity MacOS Desktop
Connect to and query live Xero Data in Perplexity Desktop using CData MCP Server.
-
Connecting Pipedream with Zoho Inventory Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Pipedream workflows to securely read and take actions on Zoho Inventory data in real time.
-
Integrate Live GitHub Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf
-
Import Real-Time Superchat Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Superchat in ColdFusion.
-
Connect to EmailOctopus Data from a Connection Pool in JBoss
Integrate EmailOctopus into Java servlets: Use the Management Console in JBoss to install the EmailOctopus JDBC Driver.
-
Import Real-Time Quaderno Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Quaderno in ColdFusion.
-
Build Automated Workflows with Live Snapchat Ads Data in Workato
Use CData Connect AI to connect to live Snapchat Ads and build automated workflows in Workato.
-
How to Access Live Planio Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Planio enables you to integrate Planio into workflows built using Microsoft Power Automate Desktop.
-
Query, Visualize, and Share live Amazon Marketplace Data in Redash
Use CData Connect AI to connect to live Amazon Marketplace in Redash for querying, visualizing, and sharing.
-
Build Charts with ChargeOver Data in Clear Analytics
Create dynamic charts and perform analytics based on ChargeOver in Clear Analytics.
-
How to connect to ConstantContact Data with Squirrel SQL client
Connect to ConstantContact and execute queries in the Squirrel SQL Client.
-
Connect PDFMonkey to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live PDFMonkey using the CData Python MCP Server.
-
Import FreshBooks Data Using Azure Data Factory
Use CData Connect AI to connect to FreshBooks Data from Azure Data Factory and import live FreshBooks.
-
Build Azure Data Catalog-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Azure Data Catalog.
-
View Reports on Real-Time Google Calendar Data in Power BI Report Server
Use the CData ODBC Driver for Google Calendar to visualize Google Calendar in Power BI Desktop and then publish them to Power BI Report Server.
-
Integrate with GitHub Data in JReport Designer
Create charts and reports based on GitHub in JReport Designer.
-
Build Apps with Live SAP SuccessFactors Data Using the Low-Code Development Platform of Mendix
Connect SAP SuccessFactors with Mendix to build apps using the CData JDBC Driver for SAP SuccessFactors.
-
Connect to SingleStore Data in DBArtisan
Use wizards in DBArtisan to configure SingleStore as a data source.
-
Object-Relational Mapping (ORM) with Perigon Data 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 Perigon into a Java-based ORM framework, Hibernate.
-
Use Azure AI Foundry to Talk to Your Highrise Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Azure AI Foundry agents to securely answer questions and take actions on your Highrise CRM for you.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Azure Data Lake Storage
Provide connectivity to Azure Data Lake Storage through an SAP BusinessObjects universe.
-
Build Data Flows from Adobe Analytics to SQL Server using SSIS
Easily back up Adobe Analytics to SQL Server using the SSIS components for Adobe Analytics.
-
Seamlessly Bring HCL Domino Data into Retool Using CData Connect AI
Integrate HCL Domino data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Migrating data from Google Analytics to Databricks using CData SSIS Components.
Easily push Google Analytics to Databricks using the CData SSIS Tasks for Google Analytics and Databricks.
-
Extract, Transform, and Load Placid Data in Informatica PowerCenter
Create a simple Workflow for Placid in Informatica PowerCenter.
-
Feed Grafana Data into FineReport
How to set Grafana as a JDBC data source in FineReport.
-
Visualize Live Dropbox Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Dropbox into custom reports in Power BI.
-
Integrating Boomi Agentstudio with Sage 200 Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Sage 200, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
How to Connect the Power BI Service to Paylocity: Complete Guide
Connect to the CData Software Power BI Connector for Paylocity from PowerBI.com to provide real-time Paylocity across the organization.
-
Work with Pingdom Data in FoxPro
Load Pingdom into a FoxPro database. This article includes full code and a walk-through of the process.
-
Integrate Live SendGrid Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf
-
Integrate with JSON Services using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy JSON to a JSON file on disk.
-
Prepare, Blend, and Analyze MYOB AccountRight Data in Alteryx Designer (ODBC)
Build workflows to access live MYOB AccountRight for self-service data analytics.
-
How to Connect the Power BI Service to Aircall: Complete Guide
Connect to the CData Software Power BI Connector for Aircall from PowerBI.com to provide real-time Aircall across the organization.
-
Automate PabblySubscriptions Data Replication to Azure Synapse
Use CData Sync to customize and automate PabblySubscriptions replication to Azure Synapse.
-
Publish Bitbucket-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Bitbucket.
-
Automated Continuous Instagram Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Instagram replication to Apache Cassandra.
-
Connect to Sybase IQ Data in HULFT Integrate
Connect to Sybase IQ as a JDBC data source in HULFT Integrate
-
Connect and Visualize Live Google Search Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Google Search into the Databricks platform and create visualization dashboards with real-time Google Search.
-
Connect to Live Sage Intacct Data in MicroStrategy through CData Connect AI
Create a live connection to Sage Intacct Data in CData Connect AI and connect to your Sage Intacct from MicroStrategy.
-
Visualize WooCommerce Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to WooCommerce.
-
Use the CData Software JDBC Driver for Apollo in MicroStrategy Desktop
Connect to Apollo in MicroStrategy Desktop using the CData Software JDBC Driver for Apollo.
-
How to work with Zoom Data in Apache Spark using SQL
Access and process Zoom Data in Apache Spark using the CData Software JDBC Driver.