SQL Transformation for SAP Application

[former_member678556]

I have datastore with type SAP Application.

Need to extract specific data without Data Services. For type Database using SQL Transformation.

How can I use SQL Transformation for this datastore? Or is there an alternative way?

[Julian_Riegel]

Dear galiks,

I am not entirely sure about your requirement but I recommend going through Dirk's great blog for all possible options available to extract data from ECC via SAP Data Services:

https://blogs.sap.com/2017/03/13/extracting-data-from-sap-ecc/

Using an SAP Application as a Source Data Store for a SQL Transform is not possible in DS.

Regards,

Julian

[akhileshkiran]

Hi galiks,

You cannot use the SAP Application Datastore in the SQL Transform.
SQL Transform only support the Datastore Type : Database.

If you are looking to extract the SAP Application Data. You can directly use the table in the Dataflow orelse you can create a ABAP Dataflow and Apply filter on the data level.

Regards,

Akhilesh Kiran