connect data OLAP SAP BW from SQL Server 2000

We are now doing application in SQL Server 2000 that needs data from SAP. Unfortunately, we may not access data from the database itself.
We only may view data from SAP BW.
we consider how to get data from SAP BW.

Since we know that SAP BW is an OLAP system, how can we get the data from there without access the database?
Do you have any idea about it?
is there any connector tools that we can use?
Really need a help about this.

Thank you for any advices.

Regards,
Tyas

There are lots of extraction tools that cost money from various sources and I believe there is an export to text tool thats part of SAP.

connect data OLAP SAP BW from SQL Server 2000

We are now doing application in SQL Server 2000 that needs data from SAP. Unfortunately, we may not access data from the database itself.
We only may view data from SAP BW.
we consider how to get data from SAP BW.

Since we know that SAP BW is an OLAP system, how can we get the data from there without access the database?
Do you have any idea about it?
is there any connector tools that we can use?
Really need a help about this.

Thank you for any advices.

Regards,
Tyas

There are lots of extraction tools that cost money from various sources and I believe there is an export to text tool thats part of SAP.

Connect .mdf file to MSDE 2000

I'm using a product (SAP Business one) using MSDE 2000A. Another product I
receintly bought also uses SQL. According to this products manual I need to
connect the *.mdf database to my SQL server using SQL Enterprise Manager. How
does it work?
hi,
GV wrote:
> I'm using a product (SAP Business one) using MSDE 2000A. Another
> product I receintly bought also uses SQL. According to this products
> manual I need to connect the *.mdf database to my SQL server using
> SQL Enterprise Manager. How does it work?
you are required to "attach" the provided database to an existing SQL
Server/MSDE instance...
as MSDE does not provide Entrprise Manager, you have to resort on the
command line tool, oSql.exe, to execute the corresponding Transact-SQL
statement to attach the database using the system stored procedure
sp_attach_db...
you can find the full synopsis of the introduced stored procedure at
http://msdn.microsoft.com/library/de...ae-az_52oy.asp
at http://support.microsoft.com/default...;EN-US;q325003 you will
find some information on how to use oSql.exe to perform this task as long as
other related management tasks..
for your convenience, you can have a look at a free prj of mine, available
at the link following my sign., which provides a graphical user interface
similar to Enterprise Manager in order to accomplish management tasks,
including the one here discussed..
futher tools for MSDE, both commercial and free, are listed
http://www.microsoft.com/sql/msde/partners/default.asp and/or
http://www.aspfaq.com/show.asp?id=2442
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.10.0 - DbaMgr ver 0.56.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply