Stay in the Flow – Stay in Tableau – Use your write-back Scenario
Tableau helps people see and understand data and ensure that, in the process of exploring and analyzing data, there are no changes made to the data.
Most analytics tools are based on strictly read-only technology. Sometimes, users want to have the ability to add, delete or edit existing data behind a Tableau visualization and instantly see how those changes are reflected in the Viz. Infotopics | Apps for Tableau developed the ultimate solution for these challenges and many other use cases. We proudly present to you – WriteBackExtreme. Collaborate, forecast, run surveys and more directly in Tableau!
Safe and secure under the governance of Tableau.
You’ll love it!
Some of our valued customers
Modules
WriteBackExtreme has been penetration tested and provides authentication with SAML. It works natively with Azure, Okta and custom Single Sign-On Providers.
Currently, we support different database platforms to write data back to. We aim to support as many platforms and use cases as our customers can think of. If your preferred database platform is not yet natively supported by the WriteBackExtreme extension, you can still use the WriteBackExtreme extension with a supported secondary use database platform. The Data Helper and Add Data modules can integrate seamlessly with your existing data sources using a supported database platform like Snowflake, Amazing Redshift, Oracle, Azure Synapse, MySQL, Microsoft SQL Server, and PostgreSQL.
Collaboration add-on
The Collaboration template is a part of the Add Data module. It allows you to create annotations and comments on marks in your visualizations from within your dashboard. Consequently, this improves the collaboration in dashboards and makes it highly efficient. Keep track of your expert annotations and conversations on your most valuable assets.
- Create and manage annotations on marks in your visualizations
- Assign annotations to other users
- Reply on annotations/comments to start the dialog
- Collaborate to the full extent
WriteBackExtreme’s Key Features
NEW: Row Level Security
When setting up a schema in the management console, admins can set row-level security on groups and/or users so they only see the data that is relevant to them within WriteBackExtreme. You can filter rows for dashboard users or user groups, an example is that users in a particular department will only see their department’s data. By default the extension hides all rows when RLS is turned on and you can apply your RLS policy to make rows visible. You can also show data by column value. This means that WriteBackExtreme will filter rows based on the values entered in the form (for example, the group development can only see data when the field ‘priority’ has the value ‘High’).
Value-added Functionalities
Customer Stories
*Click on the images to read the stories
Are you ready to WriteBackExtreme?
Support
Our team is committed to your success with Infotopics | Apps for TableauContact us by mail:
Test for free
- Free for testing
- Demo Tableau workbook
- Tableau Desktop – Tableau Server – Tableau Cloud
- Always up to date
- Requires internet access
- Instant Download
- Cloud based / 99% uptime
- –
- Support by ticketing system
Enterprise
- Billed Annually
- On premise trial
- Tableau Desktop – Tableau Server – Tableau Cloud
- Always up to date
- No internet access required
- Additional enterprise features
- On premise installation
- Personal enterprise portal
- Personal enterprise support
SaaS solution
- Billed Annualy
- Cloud based trial
- Tableau Desktop – Tableau Server – Tableau Cloud
- Always up to date
- Requires internet access
- Additional enterprise features
- Cloud based / 99% uptime
- Personal enterprise portal
- Personal enterprise support
Latest news
Enterprise-Ready Security
When company policy or IT security requires an on-premise installation / integration of the extension, we can help you organize it. This is particularly useful when your Tableau Server is not granted internet access, or you need to be in full control of the usage and management of your extension.
On-premise installations allow you to be in control of infrastructure, privacy, governance, and to comply with company policies. It also allows the installation/hosting of several individual extensions. Please contact us for more information regarding on-premise installation of our extensions.
RECORDING
LAUNCH EVENT
– Why WriteBack in Tableau (3:30)
– Use Cases (4:27)
– Live demonstration of WriteBackExtreme (9:37)
– Customer Stories (4:54 & 7:30)
– Offering (21:51)
FAQ
You can use a blend, Join or Relationship to connect primary data with writeback data. With Data Correction you can write back in the primary data source (if on a live connection) and you only need a Blend/Join or Relationship if you want to combine your primary data with the writeback data in the same visualization. You can also use an ETL process to combine primary data with WriteBack data.
Yes. The write back connection where the data from the writeback forms is stored needs to be on a live connection. The rest of your data sources can be on an extract.
Currently we support branches of SQL, we support MySQL, MicrosoftSQL and PostgreSQL. We also support a few cloud data warehouses like Snowflake and Amazon Redshift and Synapse and we also support the Oracle database for the WriteBackExtreme extension.
When creating a new schema for Snowflake an error message was thrown that it could not create the schema.
Reason
This is happening because the PDO/ODBC implementation of Snowflake has some quirks with preparing a SQL query. Our intended workflow of all of our database implementations should be: Prepare data (escape/sanitises data) -> execute query. Only the default Snowflake ODBC implementation fires the query directly instead of preparing the query.
Solution
Within the ODBC driver configuration file we need to set the configuration `NoExecuteInSQLPrepare=true` re-enable the original intended functionality of the prepare statement of the PDO/ODBC. Checkout this documentation for help.
References:
– https://docs.snowflake.com/en/release-notes/2020-08.html#odbc-driver-2-21-6-changes-to-the-handling-of-ddl-statements-in-sqlprepare-and-sqlexecute
– https://appsfortableau.infotopics.com/support/documentation/write-back-extreme-installation-manual-linux/
- Make sure the extension domain is whitelisted on Tableau Online/Server.
- Webserver services content with proper
X-Frame-OptionsandContent-Security-Policyheaders. - Extensions feature is turned on, on Tableau Online/Server.
- The Extension server/domain has a valid SSL Certificate.
- Tableau Online/Server has access to the Extension Server to load the extension.
You can find any issues by doing the following: While running on Tableau Online/Server in the browser open the “console” tab in Chrome Developer’s tools. To open the developers tools can be done via: Hamburger menu top right > More Tools > Developer tools. Refresh the page while the developers tools is open. Now you can see if there any issue while embedding.
Note: Tableau will show warnings with something like: ‘cannot load source map’ by default, these are not caused by our extensions. They can be identified based on the domain of the url that it warns with.
Make sure to follow our installation guide to setup the right configuration!
Common issues
CSP Header error or X-Frame-Options error.
Make sure the following headers are properly set:
X-Frame-Options: SAMEORIGIN
Content-Security-Policy: frame-ancestors 'self' *.online.tableau.com;For Tableau Server
*.online.tableau.comshould be your domain.
Check all security headers with the following website: https://securityheaders.com/
Within the management console administrators will be able to create groups and assign permissions to the groups.
Yes you can! And they can all integrate in one container on your dashboard.
We understand you might have some extra ideas and use cases that might be solved with this extension with a slight addition of functionality. You can email [email protected] or use our information form.
Yes that is possible. You can start with 1 module and if needed you can upgrade to 2 modules or 3. We also offer a discount for the second and third module.
Only users that are actually going to interact with Write Back Extreme need to be licensed license, this includes all Tableau Creators, Explorers and Viewers that are going to use the extension.
Yes of course. You can migrate and use all the value of Write Back Extreme. We can migrate your Annotations subscription to the Write Back Extreme | Add Data module at no extra costs.
If you want to start with Write Back Extreme, you can contact us to plan a meeting to talk about your use cases and have a live demo that meets your requirements.
We can grant you access to our online demo server and after a functional PoC we can also agree on an installation on your server if you like to use your own data, infrastructure and dashboards.
No, you only need licenses for your production environment and you can use the extension on your development and test environment without extra need for licenses.
We have developed a permissions system which is very similar to Tableau Server. You can set permissions on your schema’s for every group. These permissions will be pushed to the extension automatically.
Yes. The write back connection where the data from the writeback forms is stored needs to be on a live connection. The rest of your data sources can be on an extract.
You can use a blend, Join or Relationship to connect primary data with writeback data. With Data Correction you can write back in the primary data source (if on a live connection) and you only need a Blend/Join or Relationship if you want to combine your primary data with the writeback data in the same visualization. You can also use an ETL process to combine primary data with WriteBack data.
Within the management console administrators will be able to create groups and assign permissions to the groups.
When creating a new schema for Snowflake an error message was thrown that it could not create the schema.
Reason
This is happening because the PDO/ODBC implementation of Snowflake has some quirks with preparing a SQL query. Our intended workflow of all of our database implementations should be: Prepare data (escape/sanitises data) -> execute query. Only the default Snowflake ODBC implementation fires the query directly instead of preparing the query.
Solution
Within the ODBC driver configuration file we need to set the configuration `NoExecuteInSQLPrepare=true` re-enable the original intended functionality of the prepare statement of the PDO/ODBC. Checkout this documentation for help.
References:
– https://docs.snowflake.com/en/release-notes/2020-08.html#odbc-driver-2-21-6-changes-to-the-handling-of-ddl-statements-in-sqlprepare-and-sqlexecute
– https://appsfortableau.infotopics.com/support/documentation/write-back-extreme-installation-manual-linux/
We have developed a permissions system which is very similar to Tableau Server. You can set permissions on your schema’s for every group. These permissions will be pushed to the extension automatically.
No, you only need licenses for your production environment and you can use the extension on your development and test environment without extra need for licenses.
If you want to start with Write Back Extreme, you can contact us to plan a meeting to talk about your use cases and have a live demo that meets your requirements.
We can grant you access to our online demo server and after a functional PoC we can also agree on an installation on your server if you like to use your own data, infrastructure and dashboards.
Yes of course. You can migrate and use all the value of Write Back Extreme. We can migrate your Annotations subscription to the Write Back Extreme | Add Data module at no extra costs.
Only users that are actually going to interact with Write Back Extreme need to be licensed license, this includes all Tableau Creators, Explorers and Viewers that are going to use the extension.
Yes that is possible. You can start with 1 module and if needed you can upgrade to 2 modules or 3. We also offer a discount for the second and third module.
We understand you might have some extra ideas and use cases that might be solved with this extension with a slight addition of functionality. You can email [email protected] or use our information form.
Yes you can! And they can all integrate in one container on your dashboard.
- Make sure the extension domain is whitelisted on Tableau Online/Server.
- Webserver services content with proper
X-Frame-OptionsandContent-Security-Policyheaders. - Extensions feature is turned on, on Tableau Online/Server.
- The Extension server/domain has a valid SSL Certificate.
- Tableau Online/Server has access to the Extension Server to load the extension.
You can find any issues by doing the following: While running on Tableau Online/Server in the browser open the “console” tab in Chrome Developer’s tools. To open the developers tools can be done via: Hamburger menu top right > More Tools > Developer tools. Refresh the page while the developers tools is open. Now you can see if there any issue while embedding.
Note: Tableau will show warnings with something like: ‘cannot load source map’ by default, these are not caused by our extensions. They can be identified based on the domain of the url that it warns with.
Make sure to follow our installation guide to setup the right configuration!
Common issues
CSP Header error or X-Frame-Options error.
Make sure the following headers are properly set:
X-Frame-Options: SAMEORIGIN
Content-Security-Policy: frame-ancestors 'self' *.online.tableau.com;For Tableau Server
*.online.tableau.comshould be your domain.
Check all security headers with the following website: https://securityheaders.com/
Currently we support branches of SQL, we support MySQL, MicrosoftSQL and PostgreSQL. We also support a few cloud data warehouses like Snowflake and Amazon Redshift and Synapse and we also support the Oracle database for the WriteBackExtreme extension.
