Automic Workload Automation

Expand all | Collapse all

UC4 BW Process Chain

Jump to Best Answer
  • 1.  UC4 BW Process Chain

    Posted 18 days ago
    Hello All,

    We are using UC4 for SAP Job scheduling and in this regards we need to do monthly extract from BW process chains.
    These BW process chains generally generate huge data( spools), these spools need to be transferred from SAP to some windows shared location

    I do have an idea that it can be done via file transfer however we need to complete procedure to try it.

    Thanks and Regards
    Hima Bindu K

  • 2.  RE: UC4 BW Process Chain

    Posted 17 days ago

    It depends a bit how the SP01 Spool entries looks like to select the right once related to the BW Process Chain and maybe it's Sub Chains. To have a look in SP01 is strongly recommended before starting with definition and design.

    With the R3_GET_SPOOLREQUESTS capability of Automic (aka UC4) you can select the spools created with one or multiple jobs require. Please store this information in a Variables Object. Next Job is doing now the R3_GET_JOBSPOOL with the information already stored in the Variables Object. To download the spool.

    • If the SAP Agents is running on Windows and started with an AD User (AD SVC User recommended), you can directly store the file on a protected File Share where this AD use must have sufficient rights. (example For Each Workflow, looping the Variables Object)
    • If the SAP Agent is running on UNIX you might have to do this using the managed file transfer of Automic, transferring the data between the System where the SAP Agent is running and the Server where the File Share is. Please note, the SAP Agent do not provide Managed File Transfer capabilities. In this case you need an OS Agent on this Server too. 

    Managing Consultant EMEA - Enterprise Studio
    HCL Technologies Austria GmbH

  • 3.  RE: UC4 BW Process Chain
    Best Answer

    Posted 17 days ago
    Hi Hima,
    The integration to the multiple levels of the BW Process Chains is a decision point as to how deep you want to control SAP using the UC4 for SAP Agent. This will be limited unless you have the full interface enabled by using the function modules or Transports, we always recommend using ALL the transports as it allows you to integrate into the SP01 Spool entries, (as Franz mentioned). This recommendation comes, and should be integrated into the entire flow at the definition and design level along with your Basis folks just to let them know the whole picture. Once you have fully integrated the UC4/SAP interface, you will be able to monitor the parent Process Chain and down into the Sub Chain level to allow you to insert the UC4 steps, it is important to fully understand where the hand-off is, and keep in mind that once you have a seamless flow going back and forth, it only makes sense to bring more of the starting points into UC4, then whether you have to do a File Transfer, archive, compress step of the exposed data, you can do it seamlessly and with dependencies and notifications triggered from UC4. The standard recommendation here is when to integrate AE with SAP, and you will find that the external data management steps only enhance SAPs power and your Basis folks will be more cooperative. I am excited to monitor your journey and hear more of your challenges/successes.

    Founder and Partner
    Data Center Automation Consultants DCAC

  • 4.  RE: UC4 BW Process Chain

    Posted 13 days ago
    Hello Franz, Hello Brian,

    Thank you for information.
    As informed we are using UC4 only for Job scheduling of ABAP programs and to an extent of scripting for dynamic changes.

    Basically the requirement is to execute the BW process chain which runs on monthly basis, the extract or spool which generates need to be placed in some windows folder using FTP from UC4
    As SAP agents are in UNIX, we might to take the second option suggested by Franz.

    We would like to test it in our non production.
    I may come up with more queries regarding the same once we start the integration.

    Hima Bindu K