WriteBackExtreme
Product Guide
Tableau helps people see and understand data. They make sure 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 however, you 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. You can support and solve a lot of your use cases in Tableau with this flexible and solid WriteBackExtreme extension.
This product guide helps you to get around in the WriteBackExtreme extension and helps you in deploying and managing your extension.
STAY IN THE FLOW | STAY IN TABLEAU | USE YOUR WRITE BACK SCENARIO
Learn everything about..
Supported Database Platforms
Currently, we support different database platforms to write data back to. Our goal is to support as many platforms and use cases our customers can think of. If your preferred database platform is not yet supported by the Write Back Extreme 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 datasources using a supported database platform like MySQL or MS SQL.
Microsoft SQL
MySQL
PostgreSQL
Snowflake
Azure Synapse
Oracle Database
Google Big Query
Teradata
FAQ
Yes! You can find a partner overview here.
Yes, please use the contact form on the pricing page.
No, we have no access to your environment. WriteBackExtreme does not require any internet connection and therefore we will never have access to your environment.
Please have a look at the WriteBackExtreme features page to find the latest list of supported databases.
Yes, you can contact us for the possibilities.
Yes, this is our main deployment method of WriteBackExtreme.
Yes, we offer WriteBackExtreme as a SaaS Solution, please contact sales for more information.
The advanced installation, testing, and setup procedure for WriteBackExtreme on Windows is incredibly user-friendly. No technical expertise is required and there is no need for additional products like IIS. View the installation manual for Windows here. For Linux we have a different installation procedure which you can find here.
Yes, we also offer combined licenses, feel free to contact sales about this.
No, WriteBackExtreme is a on-premises solution without the need of any internet connection. Our SaaS solutions are hosted in an isolated Azure environment only accessible for a by you approved group of engineers.
You can contact sales at any time to request a cancellation.
Yes, you can contact sales at any time to upgrade or extent your license.
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! You can find a partner overview here.
Yes, please use the contact form on the pricing page.
No, we have no access to your environment. WriteBackExtreme does not require any internet connection and therefore we will never have access to your environment.
Please have a look at the WriteBackExtreme features page to find the latest list of supported databases.
Yes, you can contact us for the possibilities.
Yes, this is our main deployment method of WriteBackExtreme.
Yes, we offer WriteBackExtreme as a SaaS Solution, please contact sales for more information.
The advanced installation, testing, and setup procedure for WriteBackExtreme on Windows is incredibly user-friendly. No technical expertise is required and there is no need for additional products like IIS. View the installation manual for Windows here. For Linux we have a different installation procedure which you can find here.
Yes, we also offer combined licenses, feel free to contact sales about this.
No, WriteBackExtreme is a on-premises solution without the need of any internet connection. Our SaaS solutions are hosted in an isolated Azure environment only accessible for a by you approved group of engineers.
You can contact sales at any time to request a cancellation.
Yes, you can contact sales at any time to upgrade or extent your license.
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.
We love to make solutions and help Tableau users to do things more efficiently. If you have feedback, ideas, questions or need support, please share them with us! Also, don’t forget to follow us on social media for our latest news and updates.