cancel
Showing results for 
Search instead for 
Did you mean: 

.net provider for mySAP Business suite

Former Member
0 Kudos

Hi,

We trying to connect from SQL reporting side to mySAP SCM Business suite.

We are using .net provider to connect from SQL to SAP for reporting.

The drawback of .net provider is that it can access only one table at time from SAP. So a query which needs data from more than one table fails.

Also we feel there is performance issue using this .net provider.

Is there any restriction on .net provider to pull only data from standard tables?

Also i would like to understand the impact of querying from .net provider by many users on SAP system performance.

Please provide pointers to the queries raised above.

Thanks in advance.

Regards,

Amit Deshpande

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi Amit,

the provider was designed primarily for data extraction, not ad-hoc querying. As such a reporting solution should be designed against a copy of the data in data warehouse rather than SAP directly. For this reason the query capabilities are limited to a single table in the current version.

The provider can pull data from all table types (transparent, cluster, pool). There are some limits regarding data types, e.g. text is not supported as it is not accessible with a standard SQL query.

Because the provider is optimized for large extracts, small queries incur some overhead.

Thanks,

- Juergen

Former Member
0 Kudos

Hi Juergen,

Thank you for the valuable pointers provided by you.

As you rightly said reporting solution should be designed against the copy of the data rather than directly from SAP. But in that case it might happen that some of the reports where there is need for real time will not give desired results.

Is it best practice to copy the data in data warehouse and then query?

Is there any other alternative for .net provider?

Thanks and regards,

Amit Deshpande

Former Member
0 Kudos

hi Amit,

have you guys concidered using the SAP.NET Connector to read the SAP Tables via RFC's or generically using SAP web services ?

it is one level high than the .net SQL provider, but it will give you all the results you want for quering if used appropriately

with respect,

amit

JayChan
Active Participant
0 Kudos

Hi Amit,

Do we have any .NET connector to support visual studio 2008?

Former Member
0 Kudos

Hi,

see thread [Which connector to use|]

Extract from that post:

A limitation of the NCo is that SAP has only delivered a version that depends on .NET 1.1, and integrates within VS2003. However, there is a by SAP-documented workaround to enable the NCo to also utilize with .NET 2.0 and later runtime context / and within VS2005 and later: [Using SAP Connector for MS .NET (NCO) in Microsoft Visual Studio 2005|http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/92333e6b-0b01-0010-9cbf-fecd62d6c895]

Best regards, William