CData Software - Knowledge Base
Recent Articles
-
Connect Blackbaud FE NXT to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Blackbaud FE NXT using the CData Python MCP Server.
-
Create Data Visualizations Based On Smartsheet in Mode
Use CData Connect AI to connect to Smartsheet from Mode and build visualizations using live
-
Work with Parquet in FoxPro
Load Apache Parquet into a FoxPro database. This article includes full code and a walk-through of the process.
-
PowerShell Scripting to Replicate Snowflake to MySQL
Write a simple PowerShell script to replicate Snowflake to a MySQL database.
-
Connect to Google Directory from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Google Directory, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Connect to SAP HANA in Jaspersoft Studio
Execute SQL to remote SAP HANA in Jaspersoft Studio.
-
Natively Connect to Dynamics 365 Business Central in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Dynamics 365 Business Central. Leverage the native support for ODBC in PHP.
-
Query Amazon Athena from Node.js
Use the OData endpoint of the CData API Server to connect to your Amazon Athena and perform CRUD operations on Amazon Athena from Node.js.
-
How to Connect to Live Marketo from Gemini CLI (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Gemini CLI to securely read and take actions on your Marketo for you.
-
Create Data Visualizations in Cognos BI with Wave Financial
Access Wave Financial as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Automated Continuous Excel Online Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Excel Online replication to Apache Cassandra.
-
Build Amazon Athena-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Amazon Athena.
-
Natively Connect to Clio in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Clio. Leverage the native support for ODBC in PHP.
-
Enable the Twitter Ads JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Twitter Ads.
-
Analyze Kintone in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Kintone and visualize live Kintone in Infragistics Reveal.
-
Integrate with Google Cloud Storage using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Google Cloud Storage to a JSON file on disk.
-
Working with Lakebase in LINQPad
Execute LINQ queries to Lakebase in LINQPad.
-
Connect to Bitbucket from PowerBuilder via JDBC
This article demonstrates how to access Bitbucket from PowerBuilder using the Bitbucket JDBC Driver.
-
Integrate Live Elasticsearch into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Elasticsearch from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Elasticsearch.
-
Create Dashboards and Visualize Live ActiveCampaign in Geckoboard
Use CData Connect AI to connect to live ActiveCampaign and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Integrate SuiteCRM with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate SuiteCRM with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to SuiteCRM.
-
Build Dashboards with NetSuite in DBxtra
Create dynamic dashboards and perform analytics based on NetSuite CRM & ERP in DBxtra.
-
DataBind Google Sheets to the DevExpress Data Grid
Use the CData Software ADO.NET Provider for Google Sheets with the DevExpress Windows Forms and Web controls to provide Google Sheets to a chart.
-
Consume Oracle Service Cloud OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Oracle Service Cloud feeds that reflect any changes in SAP Lumira.
-
Access SAP HANA as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access SAP HANA from your Oracle system.
-
How to Connect to Live IBM Informix 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 IBM Informix for you.
-
Integrate Real-Time Access to Freshdesk in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Freshdesk in real time.
-
Create Dynamics CRM-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Dynamics CRM from OutSystems and build custom enterprise apps using live Microsoft Dynamics CRM.
-
Automated Continuous Square Replication to Snowflake
Use CData Sync for automated, continuous, customizable Square replication to Snowflake.
-
Create Dynamic CouchDB Grids Using the Infragistics XamDataGrid
Learn how you can connect CouchDB to Infragistics XamDataGrid to build dynamic grids.
-
Access Live SAP HANA in AWS Lambda (with IntelliJ IDEA)
Connect to live SAP HANA in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Access Live Blackbaud FE NXT in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Blackbaud FE NXT from your Excel spreadsheets.
-
How to Connect to Live Twitter from crewAI Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable crewAI agents to securely read and take actions on your Twitter for you.
-
Migrating data from QuickBooks Online to Databricks using CData SSIS Components.
Easily push QuickBooks Online to Databricks using the CData SSIS Tasks for QuickBooks Online and Databricks.
-
Analyze Reckon with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Reckon from Power Pivot. You will use the Table Import Wizard to load Reckon. You can visually build the import query or use any SQL supported by the driver.
-
Automated Continuous MYOB AccountRight Replication to MySQL
Use CData Sync for automated, continuous, customizable MYOB AccountRight replication to MySQL.
-
Connect to EnterpriseDB in DBArtisan
Use wizards in DBArtisan to configure EnterpriseDB as a data source.
-
Operational Reporting on Azure Data Catalog from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Azure Data Catalog.
-
How to Query Live Google Analytics in Perplexity MacOS Desktop
Connect to and query live Google Analytics in Perplexity Desktop using the CData MCP Server.
-
Getting Started with the CData SSIS Components for Highrise
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Highrise.
-
Analyze HDFS in R via JDBC
Use standard R functions and the development environment of your choice to analyze Apache HDFS with the CData JDBC Driver for HDFS.
-
Create Datasets from SAP in Domo Workbench and Build Visualizations of SAP in Domo
Use the CData Software ODBC Driver for SAP to create datasets from SAP ERP/NetWeaver in Domo Workbench and then build visualizations in the Domo service.
-
Build Semantic Layer Views for Instagram in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Instagram.
-
Using the CData Software ODBC Driver for Amazon S3 in PyCharm
Connect to Amazon S3 as an ODBC data source in PyCharm using the CData Software ODBC Driver for Amazon S3.
-
Getting Started with the CData SSIS Components for Gmail
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Gmail.
-
Configuring Incremental Replication in CData Sync
This entry covers how to set up incremental replication for Data Sync.
-
Bidirectional Access to JDBC-ODBC Bridge from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate JDBC-ODBC Bridge in Filemaker Pro for Mac or Windows.
-
Automate CouchDB Replication to Azure Synapse
Use CData Sync to customize and automate Apache CouchDB replication to Azure Synapse.
-
Build Data Flows from SQL Server to Microsoft Teams through SSIS
Easily push SQL Server data to Microsoft Teams using the CData SSIS Tasks for Microsoft Teams.
-
PowerShell Scripting to Replicate SFTP to MySQL
Write a simple PowerShell script to replicate SFTP to a MySQL database.
-
View Reports on Real-Time Azure Synapse in Power BI Report Server
Use the CData ODBC Driver for Azure Synapse to visualize Azure Synapse in Power BI Desktop and then publish them to Power BI Report Server.
-
Getting Started with the CData Power BI Connector for Avalara AvaTax
-