The NSX ERP Extract Suite for SAP provides SQL-based access to all R/3 and BW ODS tables 

The NSX ERP Extract Suite for SAP has three components.

OLEDB Provider for SAP

The OLEDB Provider for SAP is a fully functional OLEDB  data provider built in accordance with Microsoft’s OLEDB specifications. NSX OLEDB Provider for SAP is fully compatible with Microsoft SQL Server 2000 Data Transformation Services (DTS) and other development environments capable of consuming services offered by OLEDB data providers – Visual Studio, ASP – VB Script and JScript, etc.

Data Access SDK

The Data Access SDK for SAP supports programmatic access to both transparent and non-transparent SAP tables and views from COM-compliant languages, e.g., VB, VC++, VB Script, and JScript. The core of the product is a COM DLL that wraps all data access and processing functionality for SAP R/3 and BW ODS tables and views and exposes it in a convenient way to Windows and scripting programmers. It completely abstracts the application programmer from the complexities of accessing SAP data.

NSX Data Access SDK for SAP supports the execution of single table/view SQL statements. It accepts wildcard characters in WHERE clauses and returns data in ADO Recordset format.

DB Explorer for SAP

The DB Explorer for SAP is a desktop application used for real-time browsing of SAP table-based metadata and data from within a Windows environment. It is bundled with both NSX Data Access SDK for SAP and NSX OLEDB Provider for SAP.

With NSX DB Explorer a user can search for tables and views by name, description, or even wild cards. All metadata is displayed including field descriptions, data types, length, check tables, etc. Retrieved metadata can be stored in a local repository for fast access to frequently used information – even in off-line mode.

NSX DB Explorer for SAP also implements an ad hoc query capability that allows users to execute queries against SAP tables and views. Both SQL and query results can be saved for future use. Data can be stored in several formats: character-delimited, plain XML, or enhanced XML.

Key Benefits

• Enables Application developers to create solutions that seamlessly integrate to SAP

• Fully compatible with Microsoft SQL Server 2000 Data Transformation Services (DTS) and other development environments

• Automatically generates Linked Servers to provide Heterogeneous data access to SAP

• Automatically generates queries to provide real-time access to SAP from Microsoft EXCEL™ 

Copyright 2002 - NSX Software - All Rights Reserved