-
Suggestion
-
Resolution: Unresolved
-
None
-
9
-
Problem Definition
Once data is imported in Data Manager , we do not have a way to delete or reset the imported data in Data Manager
Suggested Solution
Provide ability to delete objects from data manager
Workaround
We have one workaround to replace all the Objects with one dummy object.
Example - clearing out all data from the Compute Object class
- Remove all existing Data sources for a particular object class (Data Manager >> Settings >> Data Sources)
- Create a CSV file that includes:
- A column for the primary key
- A single row (i.e. object) with that primary key populated. No other attributes need to be populated
- Set up a CSV import in adapters (Adapters >> Create Job) : Create and configure a Flat File job
- Import into Data Manager : Run a job
- Configure the data source with a cleansing rule of : Exclude Null or Empty PK - Force Cleaned (Data Manager >> Cleanse & Import >> Cleansing Rules)
- Map, Cleanse, Import (Data Manager >> Cleanse & Import section)
- Result:
- Only a single object remains in the Compute object class
- When you are ready for actual data to populate in this object class, Remove the Data Source , and Dummy Object can be removed using the new configuration, i.e Exclude Null or Empty PK - Force Cleansed and condition on other attributes.