Skip to Content

Integrating BW and MS-SQL

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

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Posted on Jul 20, 2016 at 01:02 AM

    Hi Senthilkumar,

    This is too big a subject for an SCN posting. Consider getting a consultant to help.

    (Yes, I am available).

    Here are some points to consider

    1) Without BW and Bex, you lose

    a) Language text conversion

    b) Currency conversion

    c) Unit of Measure conversion

    2) Every NetWeaver system, including ECC, contains a BW module. If you really want to make MS-SQL Sever your EDW (Enterprise Data Warehouse), consider leveraging the BW myself system in ECC to install required BI Content extractors and use process chains to post output to Open Hub destinations within the ECC system. I would keep the objects as few and as simple as necessary to get the raw data into your MS-SQL Sever EDW, and perform the transformations in the EDW.

    Please don't forget to record your final solution and to mark the question as answered.

    Good luck,

    John Hawk

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.