Learn more
 

CData Software - Knowledge Base

Recent SAP Business One ADO.NET Articles

Connect to SAP Business One from PowerBuilder

This article demonstrates how to access SAP Business One from Appeon PowerBuilder using the CData ADO.NET Provider for SAP Business One.

DataBind SAP Business One to the DevExpress Data Grid

Use the CData Software ADO.NET Provider for SAP Business One with the DevExpress Windows Forms and Web controls to provide SAP Business One to a chart.

Back Up SAP Business One to SQL Server through SSIS

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

How to Access SAP Business One Using Entity Framework

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

LINQ to SAP Business One

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 SAP Business One Data Provider.

Publish Crystal Reports on SAP Business One

Use the Report Wizard and standard ADO.NET to design a report based on up-to-date SAP Business One.

Visualize SAP Business One in TIBCO Spotfire through ADO.NET

Integrate SAP Business One into dashboards in TIBCO Spotfire.

Build an OLAP Cube in SSAS from SAP Business One

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

How to Import SAP Business One into SQL Server using SSIS

Easily back up SAP Business One to SQL Server using the SSIS components for SAP Business One.

Automate SAP Business One Integration Tasks from PowerShell

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