Skip to Content
0
Jul 18, 2016 at 07:01 AM

Integrating BW and MS-SQL

94 Views

Dear All ,

I would like to know about the replicating the data from SAP BW into MS-SQL Server. Since the core DW will be BW ?

- Reason for the replication is to report in Power BI ?

- Is this good to go with the approach ?

- How about the maintenances ?

In case failure of loads / inconsistence of data , How easy to manage / handle especially when it is critical system ?

Is anyone practising this approach for large enterprise reporting. Both Fresh // Existing Data warehouse scenario ?

Below are some article about establishing the connection.

MS- Connector :

https://msdn.microsoft.com/en-us/library/hh245078.aspx

Integrating using the Open hub ?

http://www.google.co.in/url?sa=t&rct=j&q=&esrc=s&source=web&cd=3&cad=rja&uact=8&ved=0ahUKEwiqzrSHt_zNAhWK2BoKHSP5COIQFggnMAI&url=http%3A%2F%2Fwww.sdn.sap.com%2Firj%2Fscn%2Fgo%2Fportal%2Fprtroot%2Fdocs%2Flibrary%2Fuuid%2F40ea8832-59ac-2d10-ceae-87ee8d1f8da4%3Foverridelayout%3Dtrue&usg=AFQjCNG1aAY0ZAqiHHtLE_HB_tZIzHihBg

Please provide the valuable comments.

Thanks ,

VPS