Access R/3 4.6C data from BSP

Hi,

I have SAP Web AS on one server together with BW, and on other servers SAP R/3 4.6C.

On documentation (WAS help, forums, SAP PRESS books, etc.) I can not find some usefull information/code example how to do data retrieval from R/3 in BSP, when this is on different servers and databases. Both databases (R/3 and WAS) are on MS SQL SERVER.

In BSP documentation and tutorials are very simple data retrievals of type:

select * from bsbook into table books.

How can I connect to different databases? Without this possibility is BSP/WAS useless.

I want to use BSP/WAS as platform for overall company reporting - so I will need to access to other MS SQL SERVER databases.

Thanks a lot,

Alexander Talac