Skip to Content

How to transfer the Data from SAP-System to Non-SAP system without additional Cost/License

Can we Transfer the Reports/Data from SAP-System to Non-SAP system without additional Cost/License?.

Yes, we can transfer using with simple FTP/SFTP.

Is it required any additional License or additional Cost?

No.

Is there any complex Coding or Configuration required?.

No, it is very simple.

How Can I transfer the Report/Data?.

Here I’m considering SAP-BW system running in UNIX operating system and Windows XP as Non-SAP System.

Source          : SAP-BW System running on UNIX.

Destination : SQL-Server running on Windows XP.

Scenario:

I have data in SAP-BW System, e.g. InfoCube 0SD_C03. And 0SD_C03 is having some reports and want to transfer the reports data to SQL-Server running on Windows XP.

Else

You may need to transfer ECC Data to SQL-Server running on Windows XP. For this also you can use the same logic.

Here are the steps…

  1. Set the Variable values using fixed restrictions or Using SAP/Customer Exits variables in BW Report. (If you have any variables.)
  2. Using RSCRM_BAPI TCode schedule the report based on your requirement i.e. daily, weekly…etc. And then dump the report result into one path (Directory) in Application Server.                                                                                                      E.g.: 
    Directory:  /usr/sap/BP1/DVEBMGS00/work/
    You can see this path in AL11 Tcode.
  3. Open the port in BW Application server.

  4. Create FTP/SFTP User ID in Application server level in BW System.
  5. Using Windows Script you call the Report in /usr/sap/BP1/DVEBMGS00/work/ path in BW system to SQL-Server running on Windows XP. This script you can save as a batch file and schedule it based on your requirement in Windows Server.

        Sample Windows script:

image

Note: For better understanding or Changing of the above code, please contact your Windows system Administrator. This is just sample code only.

Here I’m using RSCRM_BAPI Tcode to dump the report result into Application Server. You can use your own method also. Our intension is how to transfer the data from SAP to Non-SAP System.

To report this post you need to login first.

26 Comments

You must be Logged on to comment or reply to a post.

  1. Arun Varadarajan
    RSCRM_BAPI fails when the query resultset is too large ( more than 1 mill rows ) – we found that the same can be achieved faster by taking a dump from the cube / DSO into a flat file and then using the FTP procedure. The logic for the query calculation can be built into your target DB..

    And if you have super user rights on the backend DB then you can use something like TOAD to pull out the data from the backend directly instead…

    (0) 
    1. Surendra Kumar Reddy Koduru Post author
      Hi, Arun.
      This method is useful when you want to transfer the data from SAP-BW to Non-SAP system on daily basis using reports on Data Targets. The simple scenario is…
      I have five reports on various InfoCubes, and the output of this result is Input of SQL Server (Non-SAP). Every day I’ll load Data at 01:00:00 A.M to InfoCube from ECC. Then I’ll run RSCRM_BAPI and dump into Application server, the data is not in millions, because this is daily based data. And I’ll run Batch job in SQL server and take the data from SAP-BW, and in SQL server the other team will process the data and send the final reports to TOP Level Management.  I implemented this concept, since 4 months I didn’t face any kind of failure, it is working smoothly…

      Thanks
      Surendra Kumar Reddy Koduru

      (0) 
  2. Kamaljeet Kharbanda
    We can also use Broadcaster to run the report and save the file into application server, and then UNIX script can take care of loading it to any customized location.

    Kamaljeet

    (0) 
    1. Surendra Kumar Reddy Koduru Post author
      Hi, yes we can use Broadcaster to run the report and save the file into application server, but here we transferring/sending data to Non-SAP system, running on Windows. So this is one of the best and simple methods to send the reports data from SAP-BW to Non-SAP system.
      I found some posting regarding how to transfer the data between SAP-BW and Non-SAP systems. So in this blog I explained the simple concept.
      (0) 
    2. Surendra Kumar Reddy Koduru Post author
      Hi, yes we can use Broadcaster to run the report and save the file into application server, but here we transferring/sending data to Non-SAP system, running on Windows. So this is one of the best and simple methods to send the reports data from SAP-BW to Non-SAP system.
      I found some posting regarding how to transfer the data between SAP-BW and Non-SAP systems. So in this blog I explained the simple concept.

      Thnaks
      Surendra Kumar Reddy Koduru

      (0) 
  3. Rodrigo Augusto Ogassavara
    Hello!

    What about extracting without BW. Is there a way to extract data to be stored in Oracle directly.

    I’ve a customer that wants the data in the DB to use their “homemade” BI solution.

    As they spend lots of effort doing this personalized tool, they would appreciate a solution where BW activation and operation costs can be postponed until they feel the tool is obsolete (they will not improve it anymore, but they expect a 3-4years of use to have a acceptable ROI.

    Any directions would be appreciated.

    Regards,
    Rodrigo Ogassavara

    (0) 
    1. Surendra Kumar Reddy Koduru Post author
      Hi,
      I couldn’t get “What about extracting without BW”.  Using Open Hub , we can store the data in DB tables directly.
      If you use Open Hub service to extract data to non-SAP systems, you may need some APIs to connect a third-party tool to the BW system and then to distribute the data to other non-SAP systems.
      So using this concept without any efforts, we can transfer the data.

      Thanks
      Surendra Kumar Reddy Koduru

      (0) 
  4. Roberto Negro
    Hi dear,
    maybe in the meanwhile something has been changed, but I know that SAP officially says that “extracting data from SAP BW by any means requires additional licensing”.
    Pay attention: this doesn’t mean that you cannot technically execute data transfer into external systems (on the other hand, you know, even Open Hub Service or RSCRM_BAPI are always there at your disposal and you can use them with no technical constraint), but I know it’s necessary to clarify this point with your own SAP sales representative…
    (0) 
    1. Surendra Kumar Reddy Koduru Post author
      Dear Roberto Negro.
      Yes you are right, and this was already informed to my SAP sales representatives, regarding the scenario which has been mentioned in the blog.

      Thanks for your valuable suggestion.

      Warm Regards
      Surendra Kumar Reddy Koduru
      ITC Infotech

      (0) 
  5. Ritika Sharma
    I just read an article of yours at SDN explaining data transfer from SAP BI to non SAP system using ftp. I have got couple of queries for the same scenario. Can you please elaborate your thoughts on the same:

    (1). If we transfer all data targets data directly from fact table, hierarchy table and SID table to other non-SAP system. Then will it require license?
    (2). We can use JCO from non-SAP side to pull the data and checked for data transfer for InfoCube/DSO/InfoObject and found data is reaching properly but again in this case am confused whether license would be an issue at later stages or not?

    (0) 
    1. Surendra Kumar Reddy Koduru Post author
      You can’t transfer data directly from fact table because, BW follows Extended star schema. I’m not talking about particular data, it is about any data from SAP-BW to NON-SAP.
      I think you may need some extra license…

      Regards
      Surendra Kumar Reddy Koduru
      ITC Infotech

      (0) 
  6. Anup Chaudhari
    Dear Reddy,

    Can i transfer the SAP BW data to Cognos system. We are actually trying to build reports from the cognos tool.

    Thanks & Rgds,
    Anup

    (0) 
    1. Diego Valdevino
      Dear Anup,

      I know this might be a little late, but it can still be usefull.

      You can use any OpenHub process to do this and generate files to build Cognos PowerCubes.

      You can try to connect a Cognos framework to a BW query. This query must be prepared (optional filter variables, no free characteristics and so on )and used to build Cognos cubes.

      You might try to use it to build Cognos analysis but the performance will be poor. Another way would be to use it as a data source for a Cognos Report Studio report, but some customization might be necessary to achieve similar performance to SAP BW Queries.

      Best regards,
      Diego Valdevino

      (0) 
    2. Surendra Kumar Reddy Koduru Post author
      Dear Arup,
      As Diego Valdevino suggested, we can transfer the data from BW to Cognos System. But you need to create proper Query in BW and it should run in background without user input.

      Thanks
      Surendra Kumar Reddy Koduru.
      SAP-BI.

      (0) 
      1. Surendra Kumar Reddy Koduru Post author
        Hi,

        I need to transfer four reports data from SAP to NON-SAP system, so I used RSCRM_BAPI tcode and transferred the data from Report to Application Server in BW, and then Using OS Level User ID the fields will read from Application server and takes to another location called different system, from there the SQL server will reads the files.

        Thanks
        Surendra Kumar Reddy Koduru
        SAP-BI Lead
        ITC Infotech India.

        (0) 
  7. Patrick Yolabo
    Hello Surendra,

    could you please provide more information about:

    1.how to open the port in BW Application server.

    2. How to create FTP/SFTP User ID in Application server level in BW System.
    3. How to do this steps by steps?Using Windows Script you call the Report in /usr/sap/BP1/DVEBMGS00/work/ path in BW system to SQL-Server running on Windows XP. This script you can save as a batch file and schedule it based on your requirement in Windows Server.

    Thanks

    Gilo

    (0) 
    1. Surendra Kumar Reddy Koduru Post author
      Hi,

      1.how to open the port in BW Application server.
      This is Basis and Network/Backend support Team Job. In My company Data Center is there so they will take care all these activities.

      2. How to create FTP/SFTP User ID in Application server level in BW System.

      For this you need to take help of Basis and Newtwork/Backend support Team, they will do it.

      3. How to do this steps by steps?Using Windows Script you call the Report in /usr/sap/BP1/DVEBMGS00/work/ path in BW system to SQL-Server running on Windows XP. This script you can save as a batch file and schedule it based on your requirement in Windows Server.

      For this you need to take help of Basis and Newtwork/Backend support Team, they will do it.

      I just collected the information how to transfer the data from SAP to NON-SAP systems and then all steps I given to my Basis Team and Network/Back End Support Team and did the scenario.

      Note: You need Basis Team and Backen Team support/help they know all script and FTP etc..
      Regards
      Surendra Kumar Reddy Koduru
      SAP-BI Lead
      ITC Infotech India.

      (0) 
    1. Surendra Kumar Reddy Koduru Post author
      Hi,
      Once you complete the configuration, you just run one scenario and test. I also tested somany times and then only I moved to Production System.
      Set all timings correctly. i.e. Script execution timings and file transformation timings.

      Thanks
      Surendra Kumar Reddy. Koduru.
      SAP – BI Lead.
      ITC Infotech India.

      (0) 
  8. Luis Espinosa
    Hello Colleague,

    I hope that you can help me with this request

    Currently we’re configuring a open hub destination, but we have an issue once we execute the test, the error comes up with the API of 3rd. Party with the exception of communication failure, we have already configured the RFC between BW server and BO Server is working right now, but i really don’t understand why this exception comes up, i notice that this exception sends a message that doesn’t found the target system, and also noticed that the target system is incomplete, i mean the name doesn’t have all the letters. if this hostname stored in some parameters of the API’s or something like that, please let me know if you can help me with this request or if you need more information about it.

    Thanks a lot for your support

    (0) 

Leave a Reply