Toucan 3.0
YouPrep documentationHelp centerGet a demo
  • Welcome
    • 👋Welcome to Toucan
    • ⚙️Technical resources
      • ⚙️Toucan stack
      • Setup mode
        • Toucan SaaS mode
      • ⚙️Security
        • Application Security
        • Source Code Quality
        • Global Security Practices
        • Security of Docker Images
  • TUTORIALS
    • 📊Getting Started : Embedded Analytics
    • 🤓Advanced tutorials
      • Embedding a story with user attributes
        • Dynamic filter with user attributes
        • Dynamic Tables
        • Dynamic Database
        • Dynamic Host
      • Using the HTTP API connector in advanced use cases
      • Using advanced syntax for SQL queries
      • Merging filters with our tool
      • Deep customization chart (CSS)
        • Homepage customization
        • Chart customization
        • Dashboard customization
  • Data Management
    • 🧮Overview of Data In Toucan
    • 📡Datasources in Toucan
      • 🔌Managing Connectors
        • 🔌Creating, editing and deleting a connector
        • 🔌Set up OAuth2 credentials for your platform
        • 🔌Setting up a connector
          • 🔌Generic Connectors
            • 🔌Setting up an HTTP API connector
            • 🔌Setting up an ODBC Connector
          • 🔌Database and data warehouse Connectors
            • 🔌Setting up an AWS Redshift Connector
            • 🔌Setting up a Snowflake Connector
            • 🔌Setting up a PostgreSQL Connector
            • 🔌Setting up a Google Big Query Connector
            • 🔌Setting up an AWS Athena connector
            • 🔌Setting up a MySQL connector
            • 🔌Setting up a MongoDB connector
            • 🔌Setting up a Microsoft SQL Server connector
            • 🔌Setting up an Azure SQL connector
            • 🔌Setting a Databricks Connector
            • 🔌Setting up a ElasticSearch Connector
            • 🔌Setting up a Clickhouse Connector
          • 🔌Online services connectors
            • 🔌Setting up a Sharepoint Connector
            • 🔌Setting up a Google Sheets Connector
            • 🔌Setting up a Salesforce Connector
            • 🔌Setting up a Hubspot Connector
          • 🔌Setting up an AWS S3 connector
      • 🗄️Managing remote file storages
        • 🗂️Setting up a file storage
          • SFTP
        • 📄Create a dataset from a file
      • 📁Managing Files
        • 📁Adding, editing and deleting local files
        • 📂Using advanced file settings
        • 📁Adding and combining remote files in Toucan
    • 🔢Datasets in Toucan
      • 🔢Stored and Live Datasets
      • 💿Managing datasets
        • 🔢Creating datasets
        • 🔢Editing, Duplicating and Deleting a dataset
        • 🔢Refreshing and Publishing Datasets
        • 📈Optimize data performance
        • 🗂️Adding indexes to stored datasets
        • 👩‍💻Code mode and single mode
      • 🛑Setting permissions on dataset
      • 🗃️Maintaining Data
        • 🗃️Tagging datasets
        • 🗃️Identifying datasets dependencies
        • 🗃️Set validation rules
    • 🧑‍🍳Preparing data
      • Overview of YouPrep™
        • 🎹Column header
          • Rename column
          • Duplicate column
          • Fill null values
          • Replace values
          • Sort values
          • Convert columns data types
        • Add
          • Add text column
          • Add formula column
          • Add conditional column
        • Filter
          • Delete columns
          • Keep columns
          • Filter rows
          • Top N rows
          • ArgMax
          • ArgMin
        • Aggregate
          • Group by
          • Add total rows
          • Hierarchical rollup
          • Get unique groups/values
        • Compute
          • Compute evolution
          • Cumulated sum
          • Percentage of total
          • Rank
          • Moving average
          • Compute statistics
          • Absolute value
        • Text
          • Concatenate
          • Split column
          • Extract substring
          • To lowercase
          • To uppercase
          • Compare text columns
          • Trim spaces
          • Replace text
        • Date
          • Convert text to date
          • Convert date to text
          • Extract date information
          • Add missing dates
          • Compute duration
          • Normalize date granularity
        • Reshape
          • Pivot
          • Unpivot
          • Waterfall
        • Combine
          • Append datasets
          • Join datasets
        • Geo
          • Geographic dissolve
          • Geographic hierarchy
          • Geographic simplify
          • Prepare geo data (with basemap)
      • YouPrep™ Native SQL
      • Hybrid pipeline
    • ➿Managing variables in Toucan
      • ➿Variables hub
      • ♈Use variables in YouPrep™
      • ➿Easy reference to variables
    • 🧞Using advanced data concepts
      • 🧞Data personnalisation with user attributes
        • Connector setup with a user attribute
        • Database selection with a user attribute
        • YouPrep data filtering with a user attribute
        • Filter data in SQL with a user attribute
      • 🧞Advanced syntax for variables
      • 🧞Data cache
  • Visualizations and Layouts
    • 📺Apps
      • 📺Managing Apps
        • ➕Creating Apps
        • 📄Duplicating Apps
        • 🖨️Publishing Apps
        • 🚮Deleting Apps
        • ✍️Editing within an App
      • 🖌️Customizing Apps
        • Customizing chart color elements
        • Customizing the app's font
        • Adding Assets
        • Adding Glossary
        • Setting up, Managing and testing custom visibilities
        • Customizing the "no data error" message
        • Creating a dynamic background based on an Filter's column
      • 🏠Home
        • Creating the Home
        • Creating Tiles
          • Tile Dynamic Value
          • Tile Leaderboard
          • Tile Line
          • Tile Scorecard
          • Tile Bullet
          • Tile Heatmap
          • Tile PDF
          • Tile Video
          • Tile Image
          • Tile Text
          • Tile HTML
          • Tile Separator
      • ✨Stories
        • Creating a Story
        • KPIs
        • Narrative
        • Crossfilter
      • 📽️Filters
        • Managing Filters
          • Creating, reusing and editing Filters
          • Applying Filters
          • Unpinning and deleting Filters
        • Type of Filters
          • Dropdown
          • Checkboxes
          • Buttons
          • Date Range
          • Hierarchical
          • Slider
        • Templating from Filters' values
        • Dependant Filters
      • 📈PDF Report
      • 🎡Datawall
      • 🏗️Dashboard Builder
        • Create a Dashboard Builder
        • Embed a Dashboard Builder
        • Dashboard export options
      • 🌟MyFavorites
    • 📊Creating Visualizations
      • 🤩Viz Gallery
        • Barchart
        • Barlinechart
        • Bubblechart
        • Bulletchart
        • Circularchart
        • Funnelchart
        • Gantt chart
        • Heatmap
        • HTML
        • Leaderboard
        • Leaderboard Centered Average
        • Linechart
        • Mapchart
          • Configure a drill
        • Mediachart
        • Radarchart
        • Tablechart
        • Timeline
        • Versuschart
        • Waterfallchart
        • Score Card
        • Stacked Barchart
      • 🧠Common Chart Configuration
      • 💅Customizing chart colors
      • 🧞‍♂️Advanced chart configuration
        • Templating from chart's dataset
        • Add units, precisions and sentiments
        • Adding Tutorials
        • Add sparklines
        • Navigate with stories
        • Group informations in your stories
        • Multiple charts in one story
        • Manage dates
        • Customize tiles' sources
        • Add stars to tiles' title
        • Manage data order in your tiles
        • Navigate with tiles
    • 👩‍💻Embedding
      • 🔐Authentication
      • 🖇️Integration
        • Generate and manage embeds
        • Customize embeds
        • Embedding a Toucan App Using iFrames
        • Passing Extra Variables to Your Toucan Embed
      • ⚙️Embed SDK
        • Embed SDK Authentication
      • ❓FAQ
    • 🙋Self-Service
      • Self-Service Dashboard
      • Self-service PDF Report
  • Collaboration
    • ⏰Creating alerts
    • 📧Managing notifications
    • ➕Enriching a story with descriptions
    • 💌Sharing content
    • 💬Adding comments to stories
  • Administration
    • Page
    • ⚙️Instance Management
      • ⚙️Managing operations in SaaS
      • ⚙️Customizing your instance (whitelabel)
    • 👥Managing Users
      • 👥Users
      • 👥Managing user groups
      • 👥Managing user properties
      • 👥Setting up permissions and visibilities
    • 🌐Managing languages in Toucan (internationalisation)
    • 📈Monitoring Engagement with User Analytics
      • 🎛️How to Filter your User Analytics?
      • 🖥️Understanding your User Analytics Dashboards
  • Additional Ressources
    • 📚External documentation
    • 🚁Support for App-builders
    • 🆕Latest releases
      • 🎁2025 Releases
      • 🎁2024 Releases
      • 🎁2023 Releases
    • 🔧Troubleshooting
      • Troubleshoot:: DataHub
      • Cross-Site Cookies
      • How to :: read the inspector error
      • How to :: troubleshoot the toucan way
Powered by GitBook
On this page

Was this helpful?

  1. Administration
  2. Managing Users

Managing user properties

Last updated 1 day ago

Was this helpful?

This feature is under feature flag, contact your CSM to enable it on your workspace.

To access to the User Properties Management, you have to contact your CSM to enable a User Attribute Management flag.

As an application administrator at both the app store and application levels, you can learn how to add and delete user properties.

This powerful new capability allows application administrators to create and delete custom user properties, enhancing the flexibility and personalization of your data visualization experience. Whether you're managing user-specific settings, handling complex user credentials, or tailoring application behavior, User Properties Management offers a robust solution.

Key Features

  1. Custom User Properties: Administrators can create custom attributes for users beyond the built-in properties (name, roles, groups, and privileges). These properties can be of various types:

    • Array: For lists or collections of values.

    • String: For text-based information.

    • Integer: For numeric values.

    • Boolean: For true/false settings.

    • Object: For structured data.

  2. Secret Attributes: In addition to classic attributes, administrators can create secret attributes. These are not visible at the application level but can be used internally to manage sensitive information like credentials for database connections.

  3. Variable Management Hub: This hub allows you to leverage the custom attributes to variabilize different levels of your application, ensuring a tailored experience for each user.

Using the User Properties Management Feature

Accessing the User Management Interface

  1. Log in to your application: Navigate to the administration section of your instance.

  2. User Management: Select 'Users' from the main menu to access the User Properties Management interface.

Creating Custom Attributes

  1. Navigate to User Properties: Within the Users space, find the 'Properties' tab.

  2. Add New Property: Click the 'Add New Property' button.

  3. Configure the Property:

    • Privacy: Choose 'Attribute' for visible attributes or 'Secret' for hidden ones.

    • Name: Provide a name for the property.

    • Data Type: Select the appropriate type (Array, String, Integer, Boolean, Object).

  4. Save: Click 'Create' to create the property.

Deleting Custom Attributes

  1. Navigate to User Properties: Access the 'Properties' tab within Users space.

  2. Select Property: Choose the attribute you wish to delete.

  3. Delete: Click the 'Delete' button and confirm the action.

Utilizing Custom Attributes

Custom attributes can be reused in your applications to customize and variabilize user experiences. For instance, you can:

  • Tailor user interfaces based on user-specific settings stored in custom attributes.

  • Use secret attributes to securely manage database connection credentials without exposing them at the application level.

More information in the documentation below

Best Practices

  • Security: Utilize secret attributes for any sensitive information to ensure it remains protected.

  • Naming Conventions: Use clear and consistent naming for attributes to avoid confusion and ensure easy management.

  • Documentation: Keep a record of all custom attributes and their intended use to maintain clarity within your team.

Alternative Solution: Add Custom User Attributes

Step 1: Update Your Instance Settings

This is the most delicate step in the process. You’ll need to modify your instance settings file using your preferred code editor to define a user_attributes_schema object.

In the example below, we are adding two custom attributes: city and country. To do this, add a user_attributes_schema section in your instance settings file, structured as follows:

user_attributes_schema: 
    type: "object" 
    properties: 
        city: type: "string" 
        country: type: "string" 
    required: ["city"]

Only the string type is currently supported.

You can specify which attributes are required using the required array.

You can access the instance settings file via the Settings menu in your instance.

Step 2: Prepare Your Users

Once your schema is defined, you’ll need to prepare your users accordingly. Go to the /users page to begin.

1. Download and Edit the Bulk Upload Template

  • Download the CSV template from the interface.

  • Open it using your preferred spreadsheet tool (e.g., Excel, Google Sheets).

2. Add Your Attributes

To include custom attributes like city and country, simply add new columns to the CSV.

  • Column headers should follow this format: attribute city, attribute country

  • Fill in the corresponding values for each user.

Take care ! The prefix should be attribute with a space at the end.

3. Upload Your File

Once your file is ready:

  • Drag and drop it onto the bulk user creation interface.

You’re all set! Your users will now include the custom attributes defined in your instance settings.

Conclusion

The User Properties Management feature is designed to offer unparalleled flexibility and security in managing user-specific settings and credentials within Toucan. By leveraging custom and secret attributes, you can enhance your data visualization applications, providing a more personalized and secure experience for your users.

For further assistance or questions, please contact our support team.

👥
👥
Variables hub | Toucan 3.0
Logo