connect to SAP BI cubes using vb.net

[Former Member]

hey all,

I would like to connect to SAP BI cubes through an application in vb.net. is it possible to connect to it using SAP BW OLEDB provider? If so could someone please explain it in bit details or provide a link to some source. I've looked around and couldn't find anything. I would like to make a reporting website so basically I need to display the reports using reportviewer in asp.net 2.0 but i don't know how to connect to SAP BI cubes through .net application using any data provider available. I would really appreciate if someone could help me out. Thanking in advance!

[Former Member]

Hi Muhammad,

I would recommend that you take a look to the article http://technet.microsoft.com/en-us/library/bb508810.aspx, here you will find a step-by-step guide of how to use the .NET Data Provider for NetWeaver BI and SQL Server Reporting services for connecting form SQL Server to SAP BI using the XMLA interface. I would recommend using XMLA, XMLA provides direct access tot he query cubes as well as info cubes.

- Juergen

[Former Member]

Hi Muhammed,

you can find some information on how to connect from Microsoft .NET to SAP BW at http://www.microsoft.com/isv/sap/technology/interop/bi.aspx. ARe you running your SAP BI on SQL Server 2005 or on another database?

Thanks,

- Juergen

[Former Member]

yes, we got SQL Server 2005 database. I know how to connect to SAP BI cubes using SQL Server 2005 services but i would like display my report on a webpage so i need to add the report on report viewer on asp.net. As i mentioned, i found out that you can use SAP BW OLEDB provider but i don't know the exact connection string and whether it's latest technology and will be supported in future.