Management Console

The Management Console of the WriteBackExtreme extension is the place to start your journey. With the Management Console you can manage and control the configuration and authorization of the schemas, database connections, extension updates and its users. The Management Console is a web application that can either be opened in a modal window in your Tableau dashboard or directly in your favorite browser. The entire extension (including the Management Console) will be hosted on-premise or in your private cloud behind your secure firewalls.

Management Console of the Write Back Extreme extension for Tableau

The URL of your Management Console is the base url of your WriteBackExtreme extension (that can be found in the trex file) with “/backend”  as a suffix. The URL to the Management Console of the WriteBackExtreme Gallery Demo for instance is: https://gallery.demo.writebackextreme.com/backend/ user: writeback pass: adminadmin

Ease of use

Through the guiding web-interface of the Management Console you will be able to setup your write-back use case in minutes. After configuring your WriteBack use case in the Management Console you can instantly use it in Tableau Dashboards and share it with your fellow dashboard users. The Management Console is available to authenticated users. Authenticated users can manage users, extension updates, database connections and schema’s.  

Management Console versus Front end configuration

Within the Management Console you can setup your Database connections and write back scenario’s (or schema’s). After you set up and stored a new schema and selected the database and module that fit your use case, you can start configuring the behavior and appearance of the extension in your Tableau Dashboard. This is what we call the Front-End configuration. The extension will automatically connect to the back-end and authenticate you. In the extension you will also be provided with a step by step setup. Here you can select your newly created use case and start doing write back actions! Let’s find out more about the pages you find in the Management Console.

Management Console functions

The Management Console allows you to

Manage Security

Username + Password

This is the basic username + password authentication method. You can configure username and password in the Users section. This method will force every user which uses the extension to login first.

Single Sign On (SSO). Available for Azure and more to follow!

A much requested feature for WriteBackExtreme is now available in 1.5. This is of great value in conjunction with Tableau Server sync of Username/User Groups and group memberships. All users will need verified credentials to have access to the use of WriteBackExtreme on your dashboard. Save time and gain even more control on your access permissions in WriteBackExtreme. Follow our tutorial to set this up.

Tableau Authentication

Using the REST API you’re able to authenticate any user with Tableau Server or Tableau Online. If the Username and Password matches an account on Tableau Server the extension will start. This will need to be a local Tableau account, not a SSN. Fill in the details of your Tableau environment under the security tab. Note: This security method only works with Authentication Mode ‘Tableau’. You can find this on Tableau Server/Online on the Users page.

Pincode

Create and share a pincode which all users will need to enter before having access to the extension. This can be any number combination digit between 4-6 digits. There’s an option to only allow administrators or all users. 

No Authentication

This is the default authentication method, we recommend to only use for testing purposes. Usernames will be tracked using the username field in Tableau. It is the least secure, but it is perfectly usable in a closed environment. You can choose if Admin accounts can also use the extension. No authentication, any user with access to the dashboard can interact with the extension.

Manage security in WriteBackExtreme

Windows Authentication for SQL connections

It’s now possible to leave the username and password empty when setting up the connection in the setup of the application. The application will recognize this and instead of login in with a fixed username password, it will use the AD (Active Directory) account of the user running the PHP application.

IP filtering for Management Console

By enabling this option, you can restrict the access to the Management Console for certain IPs of your choosing only. Making it even more safe!

Add the WHITELIST_IPS_MANAGEMENT_CONSOLE setting to the .ENV to enable.

Separate IPs by using ;

Example:
WHITELIST_IPS_MANAGEMENT_CONSOLE=”127.0.0.1;196.186.186.200″

Make sure to encapsulate the IPs with double quotes “

Manage Schemas

A schema is the collection which contains everything about your use-case. The schema will contain information about the selected database, module, user groups and the configuration of the structure of the write-back table. Whenever you create a new schema you have to choose one of our modules first. Depending on the selected module the setup of your schema will be different.

Create a new schema

Below you will find the steps to create a new schema. In this example we create a schema with the DATA HELPER module. Click on the first image and a slideshow will show up. use your right arrow to see the next image, use your left arrow to see the previous image.

Below you see an animated gif that illustrates the entire process of creating a new schema. At the end of the animation it also shows how to edit an existing field, just by opening the schema, select the field you want to change and save your changes. The fields available to add to your form are listed below. 

Single Line Text
Paragraph Text
Number
Boolean (Yes/No)
Dropdown Select
Date/Datetime

Create a new schema in the Management Console of the Write Back Extreme extension for tableau

 

Set Schema permissions

If you want your schema to be available for all users, you don’t have to set any permissions. If you want a selected group of users to enjoy the schema you set permissions on the schema. Below an animated gif on how to set permissions on a specific schema. If you want to learn how to create groups, click here.

Set Group Permissions on a schema with the Write Back Extreme Management Console

Manage Connections

Connections hold information about the connections to your databases. You only have to do this once for every database connection you would like to use for a WriteBack scenario. The username and password of a connection are stored safely and encrypted in our back-end.

A schema is connected to one of the available connections of the WriteBackExtreme module. You can have multiple schemas connected to one single connection. You can simply state that a connection is the authorized path to a database server and one database to store or edit write back information via the schemas within the available modules.

Read more about our supported databases in the ‘Supported Database’ section down below. You can also find more information about our database support in the road map section.

Create a new database connection

Below you will find the steps to create a new connection. In this example we create a connection to a MySQL database in the Gallery Demo of WriteBackExtreme. Click on the first image and a slideshow will show up. use your right arrow to see the next image, use your left arrow to see the previous image.

Below you see an animated GIF that illustrates the entire process of creating a new connection. You can also re-open a connection and change settings, although it is not recommended to change existing connections.

Create a new connection in the Management Console of the Write Back Extreme extension for Tableau

Manage Users

Whenever somebody opens a dashboard with the WriteBackExtreme extension inside, this user will automatically be authenticated and registered as a standard user in the Management Console of the Extension. If the user already exists in the Management Console and has access through a group to the schema, the extension will show. If the user does not exist or the group has no permissions on the schema that is used in the dashboard, the extension will throw an error.

Users are stored in the Management Console for several reasons. The WriteBackExtreme extension has a user-based license model. Therefore it is important to register every user which needs access to the extension. Secondly, by having the users in the Management Console, you can manage which users are able to use the schemas that are available by placing them in groups.

Rules:

  • A user belongs to one or more groups
  • Permissions are not set on a user basis but on a user group basis (except for the admin permissions)
  • In order to use the extension a user must be registered in the Management Console
  • Row Level Security can be set up on a user basis, based on which group they’re in

Create a new (admin) user

All users that interact with the extension will be automatically registered in the WriteBackExtreme Management Console. In the Management Console you can transform a regular user to an admin or vice versa. Below you will find the steps to create a new user. Click on the first image and a slideshow will show up. use your right arrow to see the next image, use your left arrow to see the previous image.

Below you see an animated GIF that illustrates the entire process of creating a new user. You can also edit user properties just by clicking on a user and adjust the properties.

Create a new user in the Write Back Extreme Management Console

Manage Groups

Groups are sets of users who need the same type of access to content. We require that you organize users into groups. You can then set permissions at the group level, to apply a set of capabilities to all users in the group. When you want a new write-back user, just add them to the groups that give the access they need.

Rules:

  • A group contains 1 or more users
  • A group belongs to 1 or more schemas
  • A group has a set of permissions

Create a new group

Below a demonstration of how to create a group in the WriteBackExtreme Management Console.

Create a group in the Management Console of the Write Back Extreme extension for Tableau

Upgrade License

Your license is stored in the Enterprise Customer portal which is available for authorized users within your organization. To update your license you must

  1. Login to the Enterprise Customer Portal
  2. Select the menu option “Licenses”
  3. Copy the WriteBackExtreme license to the clipboard by clicking the appropriate black button
  4. Login to your WriteBackExtreme Management Console (backend)
  5. Open the menu “Upgrade & License”
  6. Click the button “Change License”, a popup window will be shown
  7. Paste the License key you copied to the clipboard in step 3
  8. Now press “Validate & Store” to apply the new license key for WriteBackExtreme
  9. Check if your expected changes are applied to your WriteBackExtreme instance. If not start again at step 1
  10. Log out of the WriteBackExtreme Management Console (backend) 

Below a screencast of the entire process. The screencast starts with the obtaining of the license via the Enterprise Customer portal. After obtaining the license (copied to the clipboard) in the Enterprise Customer portal it shows how to proceed after logging in to the Management Console of WriteBackExtreme.

 

Changing the license in your WriteBackExtreme extension