Skip to Content
avatar image
Bharathi Bharathi

How to pull data from MS Database in to BO

May 25, 2017 at 10:57 AM | 46 Views

Hi Team,

We have a requirement is we need to do pull and push data from MS Access database in to SAP BO AO (Analysis for Office)

SAP Analysis for Microsoft Office
Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

3 Answers

  • avatar image
    Tammy Powlas
    May 25, 2017 at 11:03 AM

    Right now Analysis Office only supports BW/HANA as a data source; the EPM plug in can access MSAS and Essbase, so on the surface this is not possible.

    Why not just use MS Access with Excel (instead of Analysis Office)? What is your business requirement?

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Bharathi Bharathi
    May 25, 2017 at 11:33 AM

    Hi Tammy,

    Thanks for your reply.

    We have a Two Data sources 1. Non SAP Data source (MYSQL) 2. BW on HANA Data source

    My requirements is we need to Pull data from BW and also from MS Access in the same Analysis Office excel workbook.

    How to do this scenario, can you please explain very helpful to implement this scenario.

    Thanks

    Bharathi

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Bharathi Bharathi
    May 26, 2017 at 10:14 AM

    HI,

    Can you please help me following below requirement, it is very urgent.

    We have a Two Data sources 1. Non SAP Data source (MYSQL) 2. BW on HANA Data source

    My requirements is we need to Pull data from BW and also from MS Access in the same Analysis Office excel workbook.

    How to do this scenario, can you please explain very helpful to implement this scenario.

    Thanks in Advance......Guru.

    Regards,

    Bharathi

    Add comment
    10|10000 characters needed characters exceeded