Hello,
I would like to know whether there is a functionality to “delete” data by using data migration:
Let me explain:
Data has been integrated in IFS using data migration
The client wants to delete and update a new list of data.
Is it possible to “delete” data by using data migration.
Thanking you for your feedback.
Hello,
It is actually possible to delete data using Data Migration. Normally the most common way to do this via migration jobs is using the procedure Remove__ in the Method List.
As an example, let’s imagine that we want to remove the Supplier Delivery Tax Code Tab from a supplier. We can then create a migration job calling the method Supplier_Delivery_Tax_Code_API.Remove__:
In the Database Information tab, we enter the view from where we want to remove the record, in our case SUPPLIER_DELIVERY_TAX_CODE, and in the Where Clause we must filter which records we want to fetch, in my case i tested with a dummy supplier:
In the Source Mapping we must map the OBJID, OBJVERSION and ROWID fields and enter ‘DO’ as default value in the ACTION field:
Once this is done you should be able to run the job. Be careful with the where clause and check the select is fetching the correct lines!!!
Thank you for your prompt answer. i’ll try the solution .
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.