Database View
Database View provides a complete view of your source database structure and configuration.
It consists of:
- On the left, the list of tables in the source database.
- On the right, the list of columns in those tables.
Database View
To display Database View, either:
- On the workspace management view, in the workspace navigation bar, click Database View.
- On Workspaces view, from the dropdown menu in the Name column, select Database View.
From Database View, you can assign table modes to tables, assign generators to columns, and determine column sensitivity.
Required license: Enterprise
You can override the table mode or column generator.
In the table list, when the table mode or the configuration for any column in the table is overridden, the override icon displays in front of the table mode selection.
Table list with override icons
In the column list, when a column generator is overridden, the override icon displays in front of the selected generator.
Database View column with override icon
To filter Database View to only display columns that have overrides, toggle Show Overrides Only to the on position. The filter does not look for tables that override the selected table mode.
Database View with Show Overrides Only enabled
The table list is grouped by schema. You can expand and collapse the list of tables in each schema. This does not affect the displayed columns.
Table list
For each table, the table list includes the following information:
- The name of the table.
- The number of columns that have an assigned generator (a generator other than Passthrough). The number does not display if none of the table columns has an assigned generator.
- D = De-identify
- S = Scale
- T = Truncate
- P = Preserve Destination
- I = Incremental
For a child workspace, if the selected table mode overrides the parent workspace configuration, then the override icon displays.
You can filter the table list by name and by the assigned table mode. You can also filter the tables based on whether any of the columns have assigned generators.
As you filter the table list, the column list also is filtered to only include the columns for the filtered tables.
In a child workspace, when Show Overrides Only is turned on, the list only includes tables that contain columns that override the parent workspace configuration. It does not include tables that only override the selected table mode.
To filter the table list by name, in the filter field, begin to type text that is in the table name.
As you type, Tonic filters the list to only display tables with names that contain the filter text.
Filtering the table list by table name
To filter the table list based on the assigned table mode:
Filtering the table list by table mode
- 1.Click Filters.
- 2.On the filter panel, check the checkbox next to each table mode to include. By default, the list includes all of the table modes. As you check and uncheck the table mode checkboxes, Tonic adds and removes the associated tables from the list.
You can filter the table list to only display tables that have no assigned generators:
- 1.Click Filters.
- 2.On the filter panel, to only show tables that do not have assigned generators, check the No Generators Applied checkbox.
Required workspace permission: Assign table modes
The table mode determines the number of rows and columns in the destination database. For details about the available table modes and how they work, see Table modes.
To change the assigned table mode for a single table:
Assigning a table mode to a single table
- 1.Click the table mode dropdown next to the table name.
- 2.From the Table Mode dropdown list, select the table mode.
- 3.For a child workspace, the table mode selection panel indicates whether the selected table mode is inherited from the parent workspace. If the child workspace currently overrides the parent workspace configuration, then to reset the table mode to the table that is assigned in the parent workspace, click Reset.
To change the assigned table mode for multiple tables:
Assigning a table mode to multiple tables
- 1.Check the checkbox for each table to change the table mode for. To select a continuous range of tables, click the first table in the range, then Shift-click the last table in the range. To select all of the tables in a schema, click the schema name.
- 2.Click Bulk Edit.
- 3.On the panel, click the radio button for the table mode to assign to the selected tables.
For each column, the column list includes the following information:
Column list
- The name of the column, in the format
tableName.columnName. When you click the column name, Table View for the column table displays. - The data type of the column.
- For columns that are not foreign keys, the generator that is assigned to the column. For columns that are assigned Passthrough, if the column is marked as sensitive, then the generator dropdown is red. If a child workspace overrides the assigned generator or any of the generator configuration, then the override icon displays in front of the generator name.
- For columns that are foreign keys, a label to indicate that the column is a foreign key. You do not assign a generator to a foreign key. It automatically uses the generator that is assigned to the primary key that provides the foreign key value. See Primary key generators.
- The selected configuration options for the assigned generator.
The column list is automatically filtered when you filter the table list. You can also filter the column list to only display columns for specific selected tables.
In a child workspace, when Show Overrides Only is turned on, the column list only includes columns that override the parent workspace configuration.
From the column list, you can filter the columns by column name. Tonic also provides advanced options to filter the columns by:
- Privacy settings (use At Risk to set all of the filters):
- Column data attributes:
The advanced filters also include a filter to only display:
- Columns that use Tonic data encryption. This filter is only displayed when you enable Tonic data encryption.
These filters do not combine with the other column filters.
Column filtering options
You can use column filters to quickly find columns that you want to verify or update the configuration for.
To filter the column list to only include columns for specific tables, either:
- Check the checkbox for each table to display columns for.
To filter the column list by column name, in the filter field, begin typing text that is in the column name. The filter only looks for the text in the column name, not the table name.
As you type, Tonic filters the column list.
Filtering columns by name
You can filter the columns by their data type. For example, you can only display varchar columns, or only columns that contain either numeric or integer values.
To filter the column list by data type:
- 1.Click Filters.
- 2.On the filter panel, in the Data Type field, enter the data types to include in the column list.
- 3.As you type, Tonic displays a list of matching types to select from.
As you select each type, Tonic adds it to the main filter field and updates the column list.
Filtering columns by data type
You can filter the list based on the assigned generator. For example, you can only display columns that are assigned either the Name or Address generators.
To filter the column list by the assigned generator:
- 1.Click Filters.
- 2.On the filter panel, in the Applied Generator field, enter the generators to include in the column list.
- 3.As you type, Tonic displays a list of matching generators to select from.
As you select each generator, Tonic adds it to the main filter field and updates the column list.
Filtering columns by assigned generator
In the advanced filter options, the At-Risk toggle provides a shortcut to set the Sensitivity, Protection, and Destination Data filters. It allows you to quickly identify sensitive columns that are populated in the destination database but do not have an assigned generator.
To enable the At-Risk filter:
- 1.Click Filters.
- 2.On the filter panel, next to the Privacy Settings heading, toggle At-Risk to the on position.
When you toggle At-Risk to the on position:
- Sensitivity is set to Sensitive.
- Protection is set to Not Protected.
- Destination Data is set to Included.
Filtering for at-risk columns
If you change any of these filters, the At-Risk toggle returns to the off position.
You can filter the list to only show sensitive or not sensitive columns. For example, you can use this filter to verify that all of the sensitive columns have assigned generators, or that all of the columns that contain sensitive data are correctly marked as sensitive.
To filter the column list based on whether the column is marked as sensitive:
- 1.Click Filters. By default, the list includes both sensitive and non-sensitive columns. Under Privacy Settings, the sensitivity filter is set to All.
- 2.To only include columns that are marked as sensitive, click Sensitive.
- 3.To only include columns that are marked as non-sensitive, click Not Sensitive.
When you select Sensitive or Not Sensitive, Tonic adds it to the main filter field and updates the column list.
Filtering columns by sensitivity
You can filter the list to find columns that either are or are not protected. A column is protected if it as an assigned generator other than Passthrough. For example, you can use this filter to find sensitive columns that need a generator assignment.
To filter the column list based on whether the column has an assigned generator other than Passthrough:
- 1.Click Filters. By default, the list includes all columns. Under Privacy Settings, the protection filter is set to All.
- 2.To only include columns that have an assigned generator, click Protected.
- 3.To only include columns that do not have an assigned generator, click Not Protected.
When you select Protected or Not Protected, Tonic adds it to the main filter field and updates the column list.
Filtering by protection status
You can filter the columns based on whether they are populated in the destination database. For example, if a table is truncated in the destination database, then the columns in that table are not populated.
To filter the columns based on whether they are populated in the destination database:
- 1.Click Filters. By default, the list contains both included and excluded columns. Under Privacy Settings, the Destination Data filter is set to All.
- 2.To only include columns that are populated in the destination database, click Included.
- 3.To only include columns that are not populated in the destination database, click Not Included.
When you select Included or Not Included, Tonic adds it to the main filter field and updates the column list.
Filtering based on whether the column is included in the destination database
To filter the column list based on whether the column is nullable:
- 1.Click Filters. By default, the list includes all columns. Under Data Attributes, the nullability filter is set to All.
- 2.To only include columns that are nullable, click Nullable.
- 3.To only include columns that are not nullable, click Not Nullable.
When you select Nullable or Not Nullable, Tonic adds it to the main filter field and updates the column list.
Filtering columns by whether they are nullable
To filter the column list based on whether the column values are required to be unique:
- 1.Click Filters. By default, the list includes all columns. Under Data Attributes, the uniqueness filter is set to All.
- 2.To only include columns that are unique, click Unique.
- 3.To only include columns that are not unique, click Not Unique.
When you select Unique or Not Unique, Tonic adds it to the main filter field and updates the column list.
Filtering columns by whether they are unique
You can filter the column list to indicate whether to include:
- Columns that are not primary or foreign keys.
- Columns that are foreign keys.
- Columns that are primary keys.
To indicate which columns to include:
- 1.Click Filters.
- 2.The Column Type toggles control whether to include each type of column. By default, all of the toggles are in the on position, indicating to include all types of columns.
- 3.As you turn the toggles on or off, Tonic filters the column list.
Filtering columns based on whether the column is a primary or foreign key
When the source database schema changes, you might need to update the configuration to reflect those changes. If you do not resolve the schema changes, then the data generation might fail. The data generation fails if there are unresolved conflicting changes, or if you configure Tonic to always fail data generation when there are any unresolved changes.
To only display columns that have unresolved schema changes, on the advanced settings panel, under Only Show, check the Unresolved Schema Changes checkbox.
Filter for columns that have unresolved schema changes
You cannot combine this filter with the other column filters. When you check Unresolved Schema Changes, the other filters are disabled, but Tonic remembers the current settings. When you uncheck Unsolved Schema Changes, Tonic automatically restores and applies the other filters.
You can enable Tonic data encryption, a configuration that allows Tonic to: Decrypt source data before applying the generator Encrypt generated data before writing it to the destination database
When Tonic data encryption is enabled, the generator configuration panel includes an option to use Tonic data encryption.
To only display columns that are configured to use Tonic data encryption, under Only Show, check the Uses Data Encryption Process checkbox.
Filter for columns that use Tonic data encryption
This checkbox only displays when Tonic data encryption is enabled.
You cannot combine this filter with the other column filters. When you check Uses Data Encryption, the other filters are disabled, but Tonic remembers the current settings.
When you uncheck Uses Data Encryption, Tonic automatically restores and applies the other filters.
By default, the column list is sorted first by table name, then by column name. The columns for each table display together. Within each table, the columns are in alphabetical order.
You can also sort the column list by column name first, then by table. Columns that have the same name display together. Those columns are sorted by the name of the table.
To change the column sort order:
- 1.Click Sort columns.
- 2.On the sort panel, click the dropdown.
- 3.In the list of sort options, click the option to apply to the list.
You can change the generator assignment and indicate whether a column is sensitive.
Required workspace permission: Configure column generators
To change the generator that is assigned to a selected column:
Selecting and configuring a generator for a column
- 1.Click the generator value for the column.
- 2.On the configuration panel, from the Generator Type dropdown list, select the generator.
- 3.Configure the generator options.
To reset an assigned generator to Passthrough, click the delete icon next to the generator dropdown.
For more information about selecting and configuring generators and generator presets, see Assigning and configuring generators.
Required workspace permission: Configure column sensitivity
When you create a workspace, Tonic performs an initial sensitivity scan to identify columns that contain sensitive data.
If a column is sensitive, and is assigned Passthrough as the generator, then the generator dropdown is red. If a column is assigned a generator other than Passthrough, then the generator dropdown is not red.
From the column list, you can change whether a column is sensitive.
In a child workspace, you cannot configure whether a column is sensitive. A child workspace always inherits the sensitivity designation from its parent workspace.
When you copy a workspace, Tonic performs a new sensitivity scan on the copy. It does not copy the sensitivity designations from the original workspace.
To change the sensitivity for an individual column:
- 1.Click the generator for the column. The Sensitivity setting is at the top right of the configuration panel.
- 2.To indicate that a column is sensitive, toggle the setting to the on position.
- 3.To indicate that the column is not sensitive, toggle the setting to the off position.
On Database View, the bulk editing options allow you to update multiple columns simultaneously. You can:
- Change whether the selected columns are sensitive
- Assign a generator to the selected columns.
Required workspace permission: Configure column sensitivity
To change the sensitivity for multiple columns:
Configuring sensitivity for multiple selected columns
- 1.Check the checkbox next to each column to configure. To select a continuous range of columns, check the checkbox of the first column in the range, then Shift-click the last column in the range.
- 2.Click Bulk Edit Sensitivity. The sensitivity panel shows the number of selected columns that are sensitive and not sensitive. If all of the columns have the same sensitivity, then that radio button is selected.
- 3.To make all of the selected columns sensitive, click the Sensitive radio button.
- 4.To make all of the selected columns not sensitive, click the Not Sensitive radio button.
Required workspace permission: Configure column generators
To assign a generator to multiple columns:
Assigning a generator to multiple selected columns
- 1.Check the checkbox next to each column to configure. To select a continuous range of columns, check the checkbox of the first column in the range, then Shift-click the last column in the range.
- 2.Click Bulk Edit Generator.
- 3.From the New Generator dropdown list, select the generator to assign to the selected columns.
- 4.Configure the generator options.
For a generator preset, the baseline configuration is the configuration that is saved for that preset. The baseline configuration determines the default configuration is used when you assign the preset to a column. After you select the preset, you can override the baseline configuration.
To restore the baseline configuration for multiple columns:
- 1.Check the checkbox next to each column for which to restore the baseline configuration. The columns must have the same preset assigned. To select a continuous range of columns, check the checkbox of the first column in the range, then Shift-click the last column in the range.
- 2.Click Bulk Edit Generator.
- 3.On the generator configuration panel, click Reset to baseline.
Required license: Professional or Enterprise
You can add comments to columns. For example, you might use a comment to explain why you selected a particular generator or marked a column as sensitive or not sensitive.
If a column does not have any comments, then to add a comment:
Comment panel for a column that has no comments
- 1.Hover over the column row. The comment icon displays after the generator dropdown.
- 2.Click the comment icon.
- 3.In the comment field, type the comment text.
- 4.Click Comment.
When a column has existing comments, a green comment icon displays at the end of the column row. To add comments:
Replying to existing comments on a column
- 1.Click the comment icon. The comments panel shows the previous comments. Each comment includes the comment user and timestamp.
- 2.In the comment field, type the comment text.
- 3.Click Reply.
Required workspace permission:
- Source data: Preview source data
- Destination data: Preview destination data
For each column, you can display a sample list of the column values.
For columns that have an assigned generator, the sample shows both the current values and the possible values after the generator is applied.
To display the sample values, click the magnifying glass icon for the column.
If the generator is Passthrough, then the sample data panel contains only Original Data.
Sample data for a column that does not have an assigned generator
If a different generator is assigned, then the sample data panel contains both Original Data and Protected Output.
Sample data for a column that has an assigned generator