Importing from external datasources
Learn how to quickly populate Guardium groups with data from your own databases and keep those groups in sync with your data.
About this task
- When using Run Once Now, the maximum number of imported members is 5,000 rows. This is not configurable.
- When using a schedule, the maximum number of imported members is 20,000 rows by default. You can configure this limit with the CLI command show/store populate_from_query_maxrecs. For more information, see Configuration and Control CLI Commands.
- Select Import from external datasource dialog. to open the
Use the Datasource menu to import data from a datasource.
Click the icon to define a new datasource or the icon to edit an existing datasource.
- Use the Table name and Column name fields to identify the location of data to import from your datasource.
- Click OK to continue.
Completing the Import from external datasource dialog automatically creates or updates the following Guardium artifacts:
- Custom table
- Custom datasource
- Custom domain
- Custom query
These artifacts are available through standard Guardium tools using naming conventions described in the following table, where [table name] and [column name] are taken from the Table name and Column name fields of the Import from external datasource dialog.
|Artifact||Guardium tool||Naming convention||Example||Scheduled|
|Custom table||[table name]_[column name]_[datasource ID]||
|Custom datasource||[datasource name]_[datasource type](Custom Domain)||
|Custom domain||[group type]_[table name]_[column name]_[datasource ID]||
|Custom query||[group type]_[table name]_[column name]_[datasource ID]||
|Group||PCI Admin Users|