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

Using Import > From external datasource automates the creation of custom tables, domains, and queries to populate Guardium groups from your own datasources. Once created, these artifacts represent a durable connection between Guardium and your data: updates to your data become reflected in the associated Guardium groups.
Restriction: The following restrictions apply when importing group members using Members tab > Import > From external datasource:
  • 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.

Procedure

  1. Select Import > From external datasource to open the Import from external datasource dialog.
  2. Use the Datasource menu to import data from a datasource.
    Click the add icon to define a new datasource or the edit icon to edit an existing datasource.
  3. Use the Table name and Column name fields to identify the location of data to import from your datasource.
  4. Click OK to continue.

Results

Completing the Import from external datasource dialog automatically creates or updates the following Guardium artifacts:

  • Custom table
  • Custom datasource
  • Custom domain
  • Custom query
  • Group

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.

Table 1. Import from external datasource: summary of artifacts created.
Artifact Guardium tool Naming convention Example Scheduled
Custom table Custom Table Builder > Edit Data [table name]_[column name]_[datasource ID] USERS_ADMIN_12345  
Custom datasource Custom Table Builder > Upload Data [datasource name]_[datasource type](Custom Domain) user_repository(Custom Domain) scheduled
Custom domain Custom Domain Builder [group type]_[table name]_[column name]_[datasource ID] USERS_USERS_ADMIN_12345  
Custom query Custom Query Builder [group type]_[table name]_[column name]_[datasource ID] USERS_USERS_ADMIN_12345  
Group Group Builder > Populate from Query   PCI Admin Users scheduled
Attention: Imported names are truncated after 64 characters.