cancel
Showing results for 
Search instead for 
Did you mean: 

Does openhub data deleted automatically

pavneet_rana
Active Participant
0 Kudos

Hi to all,

Can any one clear doubt about OPENHUB table.

Doe data in openhub table deleted automatically, once new request load the data in openhub ?

Example: if req1 load 4 record in openhub table , and then req2 load 6 data again in openhub table, so req1 4 data will be deleted automatically in openhub and req2 6 data will only present in openhub table.

Please correct me if i am wrong.

Regards

Pavneet Rana

Accepted Solutions (1)

Accepted Solutions (1)

KamalMehta
Advisor
Advisor
0 Kudos

Hi Pavneet ,

In Open Hub by default it has setting for overwriting the file so whenever a new file gets created it overwrites the Old File .

Do you have time stamp included in your Open Hub File name.

Thanks.

Answers (4)

Answers (4)

pavneet_rana
Active Participant
0 Kudos

Thanks to all,

I have checked the setting in OPENHUB.

In OPENHUB i can see that .

Destination Type: Thirs-Party Tool

RFC Destination: XXXXXXX (some third partly parameters)

There i cant see the any setting for deletion of last request.

Where i can find, if you have putting data to third party tool.

Regards

Pavneet Rana

RamanKorrapati
Active Contributor
0 Kudos

Hi Rana,

Check this one from your open hub definition.

I think you may designed your process chain, so pls check is there any process step to delete request before loading to open hub.

Thanks

KamalMehta
Advisor
Advisor
0 Kudos

Hi Pavneet ,

Have you checked the setting in open hub From RSA1 - double click on the openhub and check the relevant settings.

Thanks

RamanKorrapati
Active Contributor
0 Kudos

Hi Rana,

Deleting the existing request and loading new request  was happening because of setting at destination tab. As said by Nethaji, Definition of open hub may be selected "Drop data from table" at Destination tab.  You can cross check your open hub destination definition.

Thanks

Former Member
0 Kudos

Hi Pavneet,

Could you please check the settings of Open Hub ?

Where In the destination tab,
There is a check box " Deleting data from Table "


If that is checked, then each time the data will be deleted from Table

which means before dumping new data into table, the old data will be deleted.

MGrob
Active Contributor
0 Kudos

Hi

Yes that is the case. Default setting drops the open hub table before it gets refilled. You see it in the open hub settings

hope it clarifies

Martin