Loading to SAP BW Tables Directly

softsys · Senior Member Joined: 13 May 2005 Posts: 45 Location: LA

I have been requested to find out if non-SAP flat file data can be loaded directly into SAP BW tables using data services and avoiding use of process chain on BW side ?

DS 4.0
BW 7.0

Thank you

Werner Daehn

Yes and No. Yes we can load all data into an InfoSource or a DataSource (BW 7.3 required for the latter). And as these are nothing else than tables, the answer is yes.
But your question sounds more like "Can I load the data directly into a cube model?" No, BW does not allow that. Would love to but I am forbidden.

aposullivan

Ok, here is my scenario. I am trying to load some data from SQL Server 2008 database through a source in BW that is Data Services source.

I have the RFC configuration working between Data Services 4.0 and BW 7.3.

In RSA1, under Modelling, I have created a Data Source to load Customer data. The source system is Data Services. In the Extraction tab the Adapter is set automatically to Load using RFC from Data Services and I have selected the source object of DBO.ODS_CUSTOMER.

In the Proposal tab, I have only selected 3 columns. In the Fields tab those same 3 columns are selected and they are:
CUST_ID, CUST_CLASSF and NAME1.

I have mapped these 3 columns to 3 infoobjects that I defined previously.

Data Type and Length all match.

What do I do next to load the SQL Server customer data into BW from this data source?

When right-clicking on the data source I can 'Create Transformation', 'Create Data Transfer Package' or 'Create InfoPackage'.

If I select Create InfoPackage, I give it a name and then it automatically fills in all the required tabs for me. I can then execute a Data Services job from this InfoPackage. In Data Services Management Console, I can see that the InfoPackage has been executed, but it doesn't finish successfully and fails with the following error message, which I do not understand:

(14.0) 02-13-12 10:42:20 (E) (8740:3504) RES-020104: |SESSION ZPAK_DC95CBR2618HDNMCMFMICX4IL@NBICLNT200|DATAFLOW ZPAK_DC95CBR2618HDNMCMFMICX4IL@NBICLNT200|STATEMENT <GUID::'dae4a319-f7ec-47b4-9b93-e8f841c346ab' LOAD TABLE "DS_SOURCE@NBICLNT200".""."ZDSCUSTOMER_TRAN@DS_SOURCE" INPUT("ZPAK_DC95CBR2618HDNMCMFMICX4IL@NBICLNT200")>
Cannot read from a file. Specify columns for file format <DS_SOURCE@NBICLNT200>. Notify Customer Support.

All i want to do is load some data into BW, using Data Services 4.0 and where the source is a sql server database table. I am not sure what I am missing. I cannot find any straight forward documentation on how you load data from Data Services into BW.

Many thanks to anyone who can put me onto the right steps of setting this up.

softsys · Senior Member Joined: 13 May 2005 Posts: 45 Location: LA

Thanks Werner.
My next question is load to BW 7.0 using DS 4.0 can be done only thru either master or transaction structures ? There is no other way to load like flat file target ?

Thanks

rodrigocpz

Hi, just for future queries, I faced the same issue here and solved, in my case, the Data Services job that BW create automatically is missing the target object, I create then a new BW target Data Store and import this target object manually, after that works running the job directly from BW

Best Regards,

Rodrigo.

anup_kumar_n · Forum Member Joined: 29 Apr 2008 Posts: 22

I have a custom DSO in SAP BW. I have data in an external sql server which needs to be loaded into this DSO. I created a SAP BW as Target Data source in data services and imported this DSO as a transaction source.

I created a data flow which reads data from the sql server and loads into this target table. The job fails giving error message

<Error 694 (RSM): Request REQU_1OPG0DSJHFQ64LJT5S86E5SAW properly ended; no further processing allowed from method BAPI_ISOURCE_TD_T_SEND.>

1) Can I load directly to the DSO table ? If so, why the error.

2) If not , does it always have to be a data source ?

SAP BW : 7.3
SAP DS: 4.0 (14.0.2)

Anup

rodrigocpz

Anup, based on my experience, you can load just a PSA as it's considered a Data Source on BW

anup_kumar_n · Forum Member Joined: 29 Apr 2008 Posts: 22

rodrigo, figured that out now. But for some reason, data services job is giving error as mentioned earlier. Anybody get that ? I am not able to get a single record inserted into the PSA.

Siva.dwh · Senior Member Joined: 13 Nov 2008 Posts: 45

Dear aposullivan,

Have you got any solution for your scenario, because i got same issue .

Could you please provide steps to resolve the issue.

Issue #
|SESSION ZPAK_DF52RL340SAMN1C9UA3JKJ95N@BPDCLNT200|DATAFLOW ZPAK_DF52RL340SAMN1C9UA3JKJ95N@BPDCLNT200|STATEMENT <GUID::'acca2fd9-443f-4617-b92d-8c4db33f1b28' LOAD TABLE "REPO@BPDCLNT200".""."DS_TRAN@REPO" INPUT("ZPAK_DF52RL340SAMN1C9UA3JKJ95N@BPDCLNT200")>
Cannot read from a file. Specify columns for file format <REPO@BPDCLNT200>. Notify Customer Support.

Thanks,

Siva.dwh · Senior Member Joined: 13 Nov 2008 Posts: 45

Hi aposullivan,

In your scenraio

1. Data types are not mismatch - BODS & BW
2. Quality of data is not loading
3. File format is not specified properly
4. Ex BODS - 2012.MON
But BW will not support above format.
It will support 2012.MM only.

like that same columns from both sides and relavant data type is required.

Thanks,

bmvrus

DS - Ability to direct write to ABAP tables.

https://ideas.sap.com/ct/ct_a_view_idea.bix?c=34503CB9-F213-4EF9-8603-E500CB16D712&idea_id=2F931BA4-3B5D-472E-BDDF-7689E33B47C8