Skip to main content Skip to complementary content

User Profile and Preferences

Select dropdown link to right of the logged-in user name in the top right of the UI.

Select Profile to access User Profile and Preferences. Three tabs are available:

  • Profile
  • Summaries & Statistics
  • Properties for Grid

Profile

Three sections are available in Profile: User Profile, User Access, and User Preferences. Select the tabs on the left to navigate to that section.

User Profile: Basic demographic information and password storage.

Select profile under user name to access profile and preferences

User Profile: Identity information

User profile is the first section in profile and preferences

User Access: Group associations and roles

User access is the second section in profile and preferences

User Preferences: Managing global settings

The User Preferences section of the User Profile and Preferences page contains a selection pane on which the user can set preferences around how the solution displays and formats data. These settings dictate how data appears when Qlik Catalog opens.

Information note

Source, entity, and field grids refer to objects in discover module. external source, external entity, and external field refer to objects in source module.

The User Preferences section offers the following settings:

  • Data Grid: Use the drop-down to select data grid options. Upon selection of a particular Data Grid users are able to define the following properties for that grid. Be sure to Take Action>Save selections.
  • Visible/Hidden Columns: Global setting prevents re-setting filters every time users view grids
  • Order of Columns: Sets the order of columns displayed, left to right
  • Sortable Columns: Sets which columns will or will not be sortable by the viewer
  • Default Sort Column [ASC/DESC]: Determines how the columns are sorted, ascending or descending
  • Display Length: Number of objects to display in the grid, per page.
  • Row Selection: Select Tick or Checkbox preference for object selection
  • Enable Personal Webhooks: Enable personal notifications for Jobs Completion by supplying application-specific (Outlook, Slack, Gmail, etc.) webhooks. Webhooks are also called a web callback or HTTP push API. See here for more details on setting up webhooks and enabling notifications.
  • Publish to Qlik Sense Default Starting View: Set default target destination when Publishing to Qlik Sense from My Cart
  • Qlik Sense Connection Name: In Single Node environments, users can provide the name of the connection to the Qlik Catalog Postgres distribution database in Qlik Sense to facilitate per-user connection security. The value can be found by finding the connection name in Qlik Catalog (Admin>QVD Import>QVD Paths>QS Connection column) or in Qlik Sense Qlik Management Console (<hostname>.qmc/dataconnections) name column. (Note this value can also be present and populated first from entity property podium.qlik.dataconnection.name if the value exists at entity level, if it does not exist at entity level this profile level field is queried, the third place the application will look for the value is core_env property podium.qlik.dataconnection.name.

Summaries & Statistics

This tab shows all available profiling summaries and validation statistics for the source and discover modules. Select up to fifteen items from the list on the left to add to the preferred list on the right. Hovering over the value on the left displays a tooltip for that metric. Click Save to preserve your choices.

Summaries & Statistics

Selected summaries and statistics will display in discover and source grids

Properties for Grid

This tab shows all viewable properties for the source (external) and discover(internal) modules. Select from the complete list on the left and click to add to the preferred list on the right. Choose an entire property or expand categories by clicking the caret on the left to select individual propertiest. Place a check in the box All properties will display in All Properties for Grid column to display all properties for that grid. If only some specified properties are selected for display on that grid the box will appear with a line through it Some properties will display. The box will be empty if no properties are selected for display No properties have been selected to display.User Profile is the first section in profile. Enable personal webhooks section in profile and preferences Click Save to set a preferred list.

Information note

The Undo button reverts back to the last saved settings.

The Reset button applies default settings (no properties are selected).

Preferred Properties (My Preferred List) will display on the listed grids and will also show up in User Preferences: Hidden/Visible Columns. There, the column order can be modified, and selected properties can be set to be sortable with default sort options. Grid properties that can be managed from this tab include: Dataflow Execution Logs, External Entity, External Field, External Source, Internal Entity, Internal Field, Internal Source, and Source Connection. Hover over the property on the left to display a tooltip description.

Properties for Grid

Profile and preferences select grid properties

User notifications upon job completion setup

Users are able to configure notifications upon load, prepare, or publish job completion at global level through core_env properties or individual user level on User Preference screen. Many applications provide instructions and functionality to easily build webhooks for group or individuals that can be embedded in the job.notification.uri property (for both global and personal settings). Both setting locations utilize same webhooks convention and tokens (available fields) with which to build a notification.

Available tokens with which to build job completion notifications are:

  • id: Long
  • user: String
  • type: String
  • deliveryId: String
  • status: String
  • recordCount: Long
  • startTime: Date
  • endTime: Date
  • loadTime: Date
  • goodCount: Long
  • badCount: Long
  • uglyCount: Long

These tokens are embedded globally in the job.notification.content property "text" field in core_env or individual User Preference screen section Webhook Content in the text notation.

Example: Example of token usage:

# "text": "Job status: %JOB_STATUS.id% '%JOB_STATUS.startTime%' %JOB_STATUS.endTime%, record count = %JOB_STATUS.recordCount%" \

The core_env property examples below displays a Job Completion notification configured for a Slack Channel.

Global core_env Property Configuration:

### Global Webhook Notifications ###

####################################

 

# If both job.notification.uri and job.notification.content are set then, upon completion of a load, prepare or publish job, a Webhook notification will be HTTP POST'ed to the specified URI containing the specified content. The token '%JOB_STATUS%' may be embedded in the content – it will be replaced with a JSON notification payload. Individual fields of the JSON payload may be included using the following notation: '%JOB_STATUS.deliveryId%'.

 

Examples are included for Slack and Outlook. Per-user (not global) notifications may be configured in the Podium UI under 'User Preferences'.

 

#job.notification.uri=https://hooks.slack.com/services/YOUR-SLACK-WEBHOOK-HERE

#job.notification.content={ "text": "%JOB_STATUS%", "channel": "#integration-test" }

 

#job.notification.uri=https://outlook.office.com/webhook/YOUR-OUTLOOK-WEBHOOK-HERE

#job.notification.content=\

#{ \

#  "@context": "https://schema.org/extensions", \

#  "@type": "MessageCard", \

#  "summary": "Podium Job Notification", \

#  "text": "Job status: %JOB_STATUS.type% '%JOB_STATUS.deliveryId%' %JOB_STATUS.status%, record count = %JOB_STATUS.recordCount%" \

#}

User preferences configuration:

Users can add a personal Webhook for receiving notifications through 'User Preferences' by selecting the radio button and configuring the properties similarly to those for core_env.properties. Many applications provide specific functionality and instructions for creation of webhooks. For example, if a user would like to receive completion notices for jobs they initiate in their Outlook Mail, they can create a Webhook with the following instructions:

  1. Log into the Outlook mail app and click the gear icon in the upper-right-hand corner of the page, and select Manage Integrations.
  2. Choose Connectors.
  3. Locate the Incoming Webhook connector in the list of available connectors, and choose Add.
  4. Enter a name for the connector and Create.
  5. Copy the Webhook URL and paste it in the Webhook URI field.

User Preferences configured for Outlook Mail Personal Webhook

Enable personal webhooks section in profile and preferences

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!