top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

How do I configure my Microsoft Access database to pull source data directly from SAP BW?

0 votes

I use several Microsoft Access databases on a regular basis to create reports. To get the source data, I currently have to log in to SAP BW (via SAP NetWeaver), run the source data report, export the results as a .csv file (but actually saving it as a .txt file), and then import that file into Microsoft Access. Is there a way that I can have Access pull the data from SAP BW directly?

posted Jan 19, 2018 by anonymous

Looking for an answer?  Promote on:
Facebook Share Button Twitter Share Button LinkedIn Share Button

Similar Questions
+3 votes

I am trying to get the Microsoft Connector for SAP BW ver 1.1 working in our environment. This is to push data into BW only not extract it. I have put the LibRFC.dll in place on the SQL server and can create a connection to BW. When I test the connection in SSIS it says OK so I know this bit is fine. When I do a test load I get an RFC failure. I have setup my Info cube and any necessary objects in BW. I have even looked on the gateway and can see the attempts but I need to interrogate the error at a lower level to find out what is going on. I am using SQL 2008 R2 with the Sap BW connector version 1.1. Can anybody offer me any help with this issue as its becoming quite critical.

0 votes

Can anybody answer my question please?