top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

Loading Data into SAP BW via SSIS

+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.

posted Jan 29, 2018 by Elena Kretova

Looking for an answer?  Promote on:
Facebook Share Button Twitter Share Button LinkedIn Share Button
Removed the promotional link from the question?

Similar Questions
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?

0 votes

Can anybody answer my question please?