on 08-07-2015 8:52 AM
Hi Experts,
I am using SAP PI 7.4. The requirement is: PI has to delete few tables in TERADATA database once in a day (fixed time: 04:00 PM). Is it possible from PI end? If yes, please guide me how to achieve this.
Thanks in advance.
Regards,
Moumita
please let me know why do you want PI to delete the tables from Teradata DB?AFAIK even the external applications will not have complete access to the DB table however in your case you need PI to delete.any strong reasons for this?Why don't you please ask your DBA to do this stuff every day at 4PM.Definitely DB has some schedulers which can do this.
Thanks
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Ok, I understand, I have to schedule the time in receiver communication channel. But, in this case, PI has to initiate this process. Nothing is there in sender side for SAP PI.
So, could you please describe in details what all objects need to be created in PI and how this will work?
Please help.
Thanks,
Moumita
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello,
you need to create receiver structure like below to delete the data in table.
<StatementName>
<dbTableName action=”DELETE”>
<key1>
<col2>val2old</col2>
<col4>val4</col4>
</key1>
<key2>
<col2>val2old2</col2>
</key2>
</dbTableName>
</StatementName3>
and as you said it should be delete depends on time you can create ATP(availability time planing) for that interface or else if source is SAP ..you can ask abaper to write a report to run on that perticular time , so that PI can delete that data in Database on time.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
I assume this is an external database table?
What you can do is create a stored procedure and use a JDBC adapter.
For the timing, set this on communication channel level (available timings).
Kind regards,
Dimitri
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
93 | |
11 | |
10 | |
9 | |
9 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.