In 11gR2 there are a few SAP mapping runtime parameters that are not explained very well and the documentation describes data retrieval techniques without telling you what exact properties to use for each of the approaches. The properties which are not described are the INSTALL ONLY and the Include FTP properties, the table below illustrates for the modes in the documentation what the property values need to be set to.
|Mode \ Properties||INSTALL ONLY||Include FTP|
|Semi-automated||TRUE/FALSE for DEV, then send ABAP to SAP admin for PROD||TRUE|
|Manual||TRUE/FALSE for DEV, then send ABAP to SAP admin for PROD||FALSE|
The INSTALL ONLY property controls the deployment of the ABAP into the SAP system, general the SAP administrator will not let you deploy directly into the production SAP system, so OWB supports the following modes to deploy the mapping into;
When the mapping is executed the file system that SAP writes to can be either a shared folder setup or ftp/https is used to transfer from SAP to the OWB system. If you plan to transfer data using a shared directory (shared between the SAP system and the OWB runtime service) you need to validate that both systems can access the directory. If you are using FTP you need to validate that both ends can transfer into the directory. One thing that is a pain today is that the load is only done when ‘Include FTP’ option is true, soooo if you are using a shared folder..there is no need to ftp right, but can only load when ftp is used.
The 'Include ftp' configuration parameter on the mapping that controls whether when the mapping is executed by OWB will include the transfer of the file by one of the transfer types (ftp/http/https) defined in the SAP location. Above you see I set 'Include ftp' to false, in doing so when the mapping is executed the ABAP code writes a file into /tmp and I will manually transfer the file in a process flow for example (or it may be written to a shared file system). One of the restrictions is that there is no sftp in this list as you notice. So what customers have done mostly is perform the sftp in a process flow after the mapping has been executed. That way the development/test/prod designs are identical. The ABAP generated by OWB when executed generates a SQL*Loader control file that has both the header and the data, so an activity to load the data using the SQL*Loader control file must be constructed (see here for details).
then the generated ABAP has this value;
…so in reverse if the administrator changes the ABAP report when moving into production you can align the production OWB mapping with the values he used and everything will be in sync (if using OWB's built in ftp capability), or change your custom process flow to have the values in a process flow parameter for example.
My location for the above used FILE transport type. If I had enabled 'Include FTP' above in the mapping configuration then I would have to have set the transport type to FTP/HTTP/HTTPS and supplied credentials for the transport properties. These are just protocols to retrieve the staged file (so they are doing 'ftp get' 'http get' 'https get'), the get is initiated from the OWB runtime connecting to the ftp service. The ftp service could be on the SAP system or on another system that the administrator setup to decouple from the SAP system.
Hopefully that helps bridge the gap between what is mentioned in the automated/semi-automated/manual system configurations in the doc and how you configure the mappings.