Importing from external datasources

Edit online

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 groups.
Restriction: The following restrictions apply when importing group members by using the Members > Import > From external datasource method:
  • 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. Open the group builder by navigating to Setup > Tools and Views > Group Builder.
  2. Click the New icon to create a new group, or select a group from the Group Builder table and click the Edit icon to edit an existing group.
  3. Select the Members tab of the Create new group or Edit group dialog.
  4. Select Import > From external datasource to open the Import from external datasource dialog.
  5. Use the Datasource menu to import data from a datasource.
    Click the New datasource icon to define a new datasource or the Edit datasource icon to edit an existing datasource.
  6. Use the Table name and Column name fields to identify the location of data to import from your datasource.
  7. 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.