Skip to Content

How to setup a automation between SAP BI process chain and SQL server 2012 job run

Hi Experts,

Please let me know the process(SAP BW 7.3) of process chain automation based on SQL server jobs run (After complete SQL table load SAP BI process chain should be run).

Thanks & Regards,

Siva

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • Apr 14, 2016 at 12:27 PM

    Hello Siva,

    On RSA1 Tx you can configure a DB connect to your SQL Server DB and perform normal BW operations.

    You can schedule SQL Job to fill table and process chains afterwards.

    Regards,

    Yuksel AKCINAR

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Yuksel,

      I already configured DB connection but my question is for PC automation, after complete SQL table load PC should be run based on schedule.

      Thanks & Regards,

      Siva

  • Apr 15, 2016 at 06:44 AM

    http://help.sap.com/saphelp_nw73/helpdata/en/8f/c08b3baaa59649e10000000a11402f/content.htm?frameset=/en/cf/9bdd42cadf2878e10000000a155106/frameset.htm&current_toc=/en/c5/f1c99abdd3fb4aa7febe103b5d77e5/plain.htm&node_id=4&show_children=false

    Hi, Siva,

    Please refer to the above wiki document about automatism of a process chain.

    As the remote SQL Server connection has been established, the current issue is more related BW feature, I suggest you post a question on SAP BW SCN http://wiki.scn.sap.com/wiki/display/BI/SAP+Business+Warehouse+Home

    Best regards.

    Cherry.

    Add comment
    10|10000 characters needed characters exceeded