Learn more
 

CData Software - Knowledge Base

Recent Sage 300 ADO.NET Articles

LINQ to Sage 300

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 Sage 300 Data Provider.

How to Access Sage 300 Using Entity Framework

This article shows how to access Sage 300 using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.

Create Dynamic Sage 300 Grids Using the Infragistics XamDataGrid

Learn how you can connect Sage 300 to Infragistics XamDataGrid to build dynamic grids.

Connect to Sage 300 from PowerBuilder

This article demonstrates how to access Sage 300 from Appeon PowerBuilder using the CData ADO.NET Provider for Sage 300.

Provide OData Services of Sage 300 from a WCF Application

In this article, we will demonstrate the process of generating an OData feed for Sage 300 by developing a WCF Service Application.

Visualize Sage 300 in TIBCO Spotfire through ADO.NET

Integrate Sage 300 into dashboards in TIBCO Spotfire.

Build an OLAP Cube in SSAS from Sage 300

Establish a connection to Sage 300 data from SQL Server Analysis Services, and use the Sage 300 Data Provider to build OLAP cubes for use in analytics and reporting.

Back Up Sage 300 to SQL Server through SSIS

Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Sage 300. In this article, we will employ an SSIS workflow to populate a database with Sage 300 data.

Automate Sage 300 Integration Tasks from PowerShell

Are you in search of a quick and easy way to access Sage 300 from PowerShell? This article demonstrates how to utilize the Sage 300 Cmdlets for tasks like connecting to Sage 300, automating operations, downloading data, and more.