cancel
Showing results for 
Search instead for 
Did you mean: 

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

siva_pidugu1
Explorer
0 Kudos

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

Accepted Solutions (0)

Answers (2)

Answers (2)

cherry_tian
Explorer
0 Kudos

http://help.sap.com/saphelp_nw73/helpdata/en/8f/c08b3baaa59649e10000000a11402f/content.htm?frameset=...

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.

yakcinar
Active Contributor
0 Kudos

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

siva_pidugu1
Explorer
0 Kudos

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