The SAP ByDesign ADO.NET Data Provider enables user to easily connect to SAP ByDesign data from .NET applications. Rapidly create and deploy powerful .NET applications that integrate with SAP ByDesign.

Features

Powerful metadata querying enables SQL-like access to non-database sources
Push down query optimization pushes SQL operations down to the server whenever possible, increasing performance
Client-side query execution engine, supports SQL-92 operations that are not available server-side
Connect to live SAP Business ByDesign data, for real-time data access
Full support for data aggregation and complex JOINs in SQL queries
Secure connectivity through modern cryptography, including TLS 1.2, SHA-256, ECC, etc.
Seamless integration with leading BI, reporting, and ETL tools and with custom applications

Specifications

DataBind to SAP ByDesign using standard Visual Studio wizards.
Comprehensive support for CRUD (Create, Read, Update, and Delete).
Supports ADO.NET Entity Framework (EF 5 & 6), LINQ to Datasets, etc.
Full Unicode support for data, parameter, & metadata.
Support for 32-bit and 64-bit operating systems.
100% Fully-managed NET for .NET Standard, .NET Core, & Xamarin.

BI, ETL, & Reporting Tool Integration

ADO.NET is a popular interface for connecting .NET-based applications with data. Popular BI, Reporting, ETL, Database, and Analytics tools leverage ADO.NET extensibility to provide access to external data, including:

| Denodo | LINQPad | PowerBuilder |
|-----------|:-----------:|-----------:| | SAP Crystal Reports | SQL Server Analysis Services | SQL Server Reporting Services |
| SQL Server Integration Services | ... and many more!

Standard ADO.NET Access to SAP ByDesign

The SAP ByDesign ADO.NET Provider offers the most natural way to access SAP ByDesign data from any .NET application. Simply use SAP ByDesign Data Provider objects to connect and access data just as you would access any traditional database. You will be able to use the SAP ByDesign Data Provider through Visual Studio Server Explorer, in code through familiar classes, and in data controls like DataGridView, GridView, DataSet, etc.

The CData ADO.NET Provider for SAP ByDesign hides the complexity of accessing data and provides additional powerful security features, smart caching, batching, socket management, and more.

Working with DataAdapters, DataSets, DataTables, etc.

The SAP ByDesign Data Provider has the same ADO.NET architecture as the native .NET data providers for SQL Server and OLEDB, including: SAP ByDesignConnection, SAP ByDesignCommand, SAP ByDesignDataAdapter, SAP ByDesignDataReader, SAP ByDesignDataSource, SAP ByDesignParameter, etc. Because of this you can now access SAP ByDesign data in an easy, familiar way.

Contact us:

Call: (800) 235-7250

Online Documentation

SAP ByDesign ADO.NET Provider