Objects in a datastore can be scanned and browsed - however actual data will never be visible. Instead certain metadata can be browsed and edited as required - such as column names, datatypes and filters.
It is very important to check and verify the data structure that is inferred by the datastore scan.
The more data means the scan has a better chance of accurately profiling the structure but sometimes you may want to edit the profile by editing objects in the datastore.
Browse the Datastore
- Click on a datastore
- Select Browse
- Click the > to expand the object and see the column definitions.
If the datastore is created in your Project (not shared from another Project or Account) then you are able to edit Structure, Filters and Tags;
Edit Structure: existing columns
In the tab named Structure click the Edit pencil icon against a column.
Change the attributes as required.
For example you can change the size or data type of a column.
You can define a column as a Primary Key
Click Save
Edit Structure : create new columns
This is useful if you want to define some audit columns in a destination datastore.
Click + New Column
Enter a column name and define the column attributes
Click Save
Restrict the columns to share in a data transfer process
Untick the check box under Use to restrict that column from being processed.
Click Save
Filter the data
On the tab named filter click on the filter icon for a column.
The options available will depend on the data type of the column - for example, if the data is a number the filter will only accept a number.
Only rows of data where all the columns meet the filter criteria will be used by Eightwire.
Apply a Tag
A Tag can be created at Project Level to add a definition to a column.
This page shows you how to create your own: Using Datastore Tags
On the tab labelled Tags
Click on a column to apply a Tag.
Select from the availables tag.
Further information about the use of tags can be found here.
Want to browse a Datastore now? Check out this video...
Now you have your Datastore ready you may want to
For more details about the scan of a Datastore refer the FAQ page about the scan process