CData Software - Knowledge Base
Recent Articles
-
How to create SAP Fieldglass federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for SAP Fieldglass in MySQL .
-
Create Informatica Mappings From/To a JDBC Data Source for Office 365
Create Office 365 data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Analyze Redis in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Redis in Microsoft R Open.
-
Connect to CouchDB in JRuby
Create a simple JRuby app with access to live Apache CouchDB.
-
Access Live Dynamics 365 in Emergent via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Emergent agents to securely access and build applications with live Microsoft Dynamics 365 through MCP integration.
-
Build Automated Reckon-Connected Workflows in Zapier
Use CData Connect AI to connect to live Reckon and build automated workflows in Zapier.
-
How to integrate MySQL with Apache Airflow
Access and process MySQL in Apache Airflow using the CData JDBC Driver.
-
Integrate Adobe Analytics in Pentaho Data Integration
Build ETL pipelines based on Adobe Analytics in the Pentaho Data Integration tool.
-
Use Agno to Talk to Your OneNote via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Agno agents to securely answer questions and take actions on your Microsoft OneNote for you.
-
Integrate Real-Time Access to SQL Analysis Services in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to SQL Analysis Services in real time.
-
How to connect to Oracle Eloqua Reporting with Squirrel SQL client
Connect to Oracle Eloqua Reporting and execute queries in the Squirrel SQL Client.
-
Access Redis from MySQL in Amazon QuickSight
Connect to Redis and build visualizations of Redis using a MySQL Connection in Amazon QuickSight.
-
Use the CData Software ODBC Driver for Sugar CRM in MicroStrategy Web
Connect to Sugar CRM in MicroStrategy Web using the CData Software ODBC Driver for Sugar CRM.
-
Access Airtable from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Airtable from HeidiSQL.
-
Create Amazon S3-Connected Applications in Appsmith
Connect to Amazon S3 via CData Connect AI in Appsmith and create custom business applications with real-time access to Amazon S3.
-
Import HarperDB into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access HarperDB. In this article, you will use the OData format to import HarperDB into Microsoft Power Query.
-
DataBind Charts to FHIR
Use the standard ADO.NET procedures for databinding to provide bidirectional access to FHIR from controls in the Visual Studio toolbox. This article demonstrates a graphical approach using wizards in Visual Studio, as well as how to databind with only a few lines of code.
-
Connect to Google Ad Manager in CloverDX (formerly CloverETL)
Transfer Google Ad Manager using the visual workflow in the CloverDX data integration tool.
-
Create Dynamic Blackbaud FE NXT Grids Using the Infragistics XamDataGrid
Learn how you can connect Blackbaud FE NXT to Infragistics XamDataGrid to build dynamic grids.
-
Build an OLAP Cube in SSAS from EnterpriseDB
Establish a connection to EnterpriseDB data from SQL Server Analysis Services, and use the EnterpriseDB Data Provider to build OLAP cubes for use in analytics and reporting.
-
Create Dashboards and Visualize Live Office 365 in Geckoboard
Use CData Connect AI to connect to live Microsoft Office 365 and create dashboards for real-time monitoring and visualization in Geckoboard.
-
How to Connect DBeaver to Sage 200 via a JDBC Driver
Manage Sage 200 with visual tools in DBeaver like the query browser.
-
Connect Microsoft Teams to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Microsoft Teams using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Automated Continuous ServiceNow Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable ServiceNow replication to delimited files (CSV/TSV).
-
Natively Connect to Adobe Experience Manager in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Adobe Experience Manager. Leverage the native support for ODBC in PHP.
-
Add Redshift to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Redshift with the Informatica Enterprise Data Catalog to classify and organize data.
-
How to Connect SurveyMonkey to Gemini Enterprise via CData Connect AI
Connect CData Connect AI Remote MCP to Gemini Enterprise to securely read and take actions on live SurveyMonkey data in real time using natural language.
-
Analyze HDFS in Infragistics Reveal
Use the CData API Server to create an OData API on top of Apache HDFS and visualize live Apache HDFS in Infragistics Reveal.
-
Connect to and Visualize Live Clio in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Clio.
-
Create Airtable-Connected Nintex Workflows
Use CData Connect AI to connect to Airtable from Nintex Workflow Cloud and build custom workflows using live Airtable.
-
Automate ActiveCampaign Replication to Azure Synapse
Use CData Sync to customize and automate ActiveCampaign replication to Azure Synapse.
-
Replicate Multiple CSV Accounts
Replicate multiple CSV accounts to one or many databases.
-
Build Hive-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Apache Hive.
-
Visualize Sugar CRM in Tableau
The CData ODBC driver for Sugar CRM enables you integrate Sugar CRM into Tableau dashboards.
-
Explore Geographical Relationships in BigCommerce with Power Map
Create data visualizations with BigCommerce in Power Map.
-
Connect to Jira Service Management from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Atlassian Jira Service Management from Filemaker Pro on Mac.
-
Query Google Analytics using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Google Analytics entities in PHP by modeling them as objects.
-
Visualize SuiteCRM from Tableau
Use the Tableau Desktop business intelligence tool to connect to SuiteCRM.
-
Automated Continuous Invoiced Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Invoiced replication to IBM DB2.
-
How to Connect to Live QuickBooks Time 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 QuickBooks Time for you.
-
How to Query Live Jira Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Atlassian Jira data in natural language using Python.
-
Create a Data Access Object for Snowflake using JDBI
A brief overview of creating a SQL Object API for Snowflake in JDBI.
-
Automated Continuous Teradata Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Teradata replication to Azure SQL Database.
-
Automated Continuous Xero Replication to SQL Server
Use CData Sync for automated, continuous, customizable Xero replication to SQL Server.
-
Build Azure Table-Powered Applications in GitHub Copilot with CData Code Assist MCP
-