CData Software - Knowledge Base
Recent Articles
-
How to use SQLAlchemy ORM to access Tally in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Tally ERP.
-
Integrate with live MongoDB in Jitterbit
Use CData Connect AI to connect to and integrate live MongoDB in Jitterbit.
-
Rapidly Develop Microsoft Planner-Driven Apps with Active Query Builder
Leverage the Active Query Builder SQL interface builder and the ease of .NET data access to create data-driven WinForms and ASP.NET apps.
-
Integrating Gumloop with Greenplum via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Pivotal GreenPlum within automated workflows.
-
Viewing OData Services in RAD Studio Data Explorer
How to view OData in RAD Studio Data Explorer using the CData ODBC Driver for OData.
-
LINQ to RSS Feeds
LINQ offers versatile querying capabilities within the .NET Framework (v3.0+), offering a straightforward method for programmatic data access through CData ADO.NET Data Providers. In this article, we demonstrate the use of LINQ to retrieve information from the RSS Data Provider.
-
Connect to HDFS in Aqua Data Studio
Access Apache HDFS from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
How to Create a Linked Server in AWS RDS for SQL Server
Learn how to create and use linked servers with AWS RDS for SQL Server, including limitations, stored procedure setup, and query examples.
-
Import Act-On into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Act-On. In this article, you will use the OData format to import Act-On into Microsoft Power Query.
-
Integrating Claude Code with ServiceNow via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on ServiceNow within assisted coding and automated development workflows.
-
Replicate Sage 300 from PowerShell
Write a quick PowerShell script to query Sage 300. Use connectivity to the live data to replicate Sage 300 to SQL Server.
-
Use the CData Software ODBC Driver for Avro in SAS for Real-Time Reporting and Analytics
Connect to real-time Apache Avro in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Avro.
-
Write a Simple Go Application to work with Office 365 on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Microsoft Office 365.
-
Easily Integrate Azure DevOps in Lazarus Pascal IDE
Learn how to easily integrate live Azure DevOps in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Integrate PayPal into Power Automate Desktop using CData Connect
CData Connect for PayPal enables you to integrate PayPal into workflows built using Microsoft Power Automate Desktop.
-
Process & Analyze Power BI XMLA in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Power BI XMLA .
-
Integrate with Jira in JReport Designer
Create charts and reports based on Atlassian Jira in JReport Designer.
-
Connect Excel Online to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Microsoft Excel Online using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Import Real-Time Bitbucket via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Bitbucket in ColdFusion.
-
Connect to GitHub in Claris FileMaker Pro
-