Inforiver

Upcoming webinar on 'Inforiver Charts : The fastest way to deliver stories in Power BI', Aug 29th , Monday, 10.30 AM CST.    Register Now

Writeback Matrix FAQ

General

1. Is there any installation required for the Writeback Matrix (SaaS)?

For the SaaS version, there is no installation required. Learn more about the SaaS version here.

2. How can I login to Inforiver?

All Power BI users with a valid Writeback Matrix subscription would be able to login using their Microsoft O365 account.

3. How does the login process work for the admin app/console?

You can login to admin console by visiting https://addons.inforiver.com/. Admin console provides options to manage users, schedules, writeback connections, assets for header/footers and more.  

4. How frequently would Inforiver be updated?

We are currently on monthly release cycles; we might be shifting to quarterly releases in the future. 

5. Do we need to be on a Power BI Premium workspace for the enterprise functionality to work?

We don't have any requirements on Power BI capacity ​for the enterprise features. One limitation that shared capacity customers might have – if they use scheduler and want to perform refresh dataset more than the allowed limit (8 times a day), it wouldn't work. 

6. What are all the permissions that we need to provide for the Inforiver?

Inforiver requires certain permissions to access resources in your organization which must be granted by the O365 admin.  Inforiver requires certain permissions to access resources in your organization which must be granted by the O365 admin.  

7. How to resolve the error showing that the app requires admin consent while login in?

Your office 365 administrator has restricted only to use app which has been consented by one of the administrators. Follow the steps outlined here for your administrator to approve. 

8. How to resolve the error that shows connection timed out when trying to connect to databases?

Your IT Team must whitelist addons.inforiver.com to enable Inforiver to connect with various destinations from your server.

9. What data do you encrypt in Inforiver SAAS application?

We encrypt sensitive data such as configuration, access tokens, and user inputs like comments and data inputs to ensure that it remains secure at rest. We also use HTTPS protocol to ensure that all data is transferred securely over the internet. Our encryption protocols meet industry standards and are regularly updated to ensure the highest level of security.

10. Can I choose where my data is stored?

Yes, we offer an on-premise option for customers who require their data to be stored separately for compliance reasons. This allows you to keep your data in a dedicated, secure environment that you control, while still benefiting from the features and functionality of our SAAS platform. 

Writeback

1. Do I have to bring my own database for the writeback?

Yes, customers must bring their own destination database for writeback data to be saved for both SaaS as well as on-premise on-prem edition. Inforiver will writeback customers' processed data in their configured destination database or other destinations such as OneDrive and SharePoint for data security and data residency compliance purposes. 

We don't provide any writeback database or any other destinations like SharePoint, OneDrive etc. for both SaaS and on-premise versions. This is done with customer's data security considerations in mind as well as it provides maximum flexibility to our architecture where the writeback could be used with cloud data warehouses such Azure SQL, SQL Server, Synapse Analytics Dedicated SQL Pool, Azure Data Lake Storage, Fabric Lakehouse, Fabric Warehouse, Dataverse, Databricks, Snowflake, Amazon Redshift, BigQuery, SingleStore, SAP HANA, Oracle, PostgreSQL and MySQL.

2. What are all the supported destinations for writeback?

These are the destinations we support at the moment – 

  • Database – Azure SQL, Dedicated SQL Pool, Azure Data Lake Storage, Databricks, Snowflake, Amazon Redshift, BigQuery, SingleStore, SQL Server, SAP HANA, Oracle, Fabric Lakehouse, Fabric Warehouse, Dataverse, PostgreSQL and MySQL
  • OneDrive and SharePoint – Writeback file as a CSV to the selected folder
  • URL – HTTPS post with the CSV as payload to a configured endpoint

3. Does row-level security work with writeback?

Yes, you can utilize Power BI Row Level Security (RLS) to restrict data access. 

4. Can we write back only comments?

Yes, cell level notes and comments are written back. You could use the settings filter option to send only comments. 
*Note: Comments in categories or column headers are not supported. 

5. Can we writeback only changed values?

Yes. You can do this by using the ‘writeback only changes’ option. 

6. Can we version the writeback data in the destination?

Yes. For folder destinations, on creating a new version a new writeback version file will be created. For databases, the writeback version column will be incremented to indicate a new version. Updating the same version which overwrites/replaces the data is also supported. 

7. How much volume of data does writeback support?

It is optimized for 30,000 rows, but it is subject to vary based on destination and mode of writeback (delta vs filter or collaborative). Writeback to Azure SQL and SQL Server can handle more data volume as we are utilizing a bulk insert approach. Writeback is optimized for up to 100K cells in the July release and we are looking to improve this further.  

8. Can customers get access to view the backend data in SAAS?

Access to your data is restricted to a limited number of authorized personnel at Inforiver who require it to provide technical support or perform maintenance on the system. We do not share or sell your data to any third parties.

9. Will writeback table get created after setting the destination?

No, this will be created on the first writeback execution.

10. Is it possible to retain the history of the WB ?

Yes, you can review all the writeback execution logs from the Inforiver console app.

Commenting

1. Can users add comments in reading mode?

Yes, comments can be added in the read mode. The main difference between the edit mode and read mode is the ability to configure additional settings such as restricting access, enabling public commenting and scheduling summary digests. 

2. Can users add comments in embedded reports?

Inforiver supports ‘Public Commenting’ where users external to the organization can login in read mode using their Gmail, LinkedIn or Twitter email ID and add comments. 

3. What are all the collaboration options available in the comments feature?

Inforiver supports collaboration with other users through real-time commenting, email notifications, and commentary digests.    

Users can post, reply, and mention users; email notifications are sent on reply and mentions. Authors can restrict access and decide who can post comments in the visual. Comment digests can be scheduled at custom intervals which summarizes all comments made between each run. 

4. When will the users get notified?

Users receive email notifications when someone responds to their comments, mentions, or assigns a task to them. 

5. Is it possible to write back all the comments made in that report?

Yes, you can writeback notes and comments to databases, shared drives, or URL. These are the destinations we support at the moment – 

  • Database – Azure SQL, Synapse Analytics Dedicated SQL Pool, Snowflake, Amazon Redshift, BigQuery, SingleStore, SQL Server, SAP HANA, Oracle, PostgreSQL and MySQL 
  • OneDrive and SharePoint – Writeback file as a CSV to the selected folder
  • URL – HTTPS post with the CSV as payload to a configured endpoint 

6. How are notes different from the comments feature?

Notes are static texts that do not capture user details. Commenting is a collaboration feature where multiple users can converse over a common thread and the user details and time stamps are recorded. Both notes and comments can be written back to csv, databases etc. 

7. What are all the governance options available for comments?

Report authors can limit commentary access to specific users within the domain – this ensures that only those users will be able to view/post comments. Report authors can also delete comments added by other users as necessary or delete all comments. 

8. Can I get a comment digest periodically?

You can configure comments digest for users within the domain – a scheduled summary of the comments at a specified frequency. 

Scheduler

1. Is it possible to schedule reports to an email or other destinations like OneDrive?

Custom scheduling of reports to email and other external destinations like OneDrive, SharePoint and Teams is supported. Burst and broadcast of paginated reports honoring row-level security (RLS) is also possible. 

2. Is there an ability to burst reports using scheduling?

Yes. With Writeback Matrix (either as SaaS or On-Premise) – you can setup comprehensive schedules, multiple destinations, and multiple output types (Excel, PDF, Image) for bursting your paginated reports. 

3. Is it possible to email group mailboxes?

Yes, they can specify any email address in the subscription. 

4. Should the scheduler be set by the report admin, or by the end user?

Both the admin and end user can schedule reports. 

5. Can we have other Power BI visuals included in the scheduler?

No. It is currently limited to Reporting Matrix and Analytics+ visuals. 

6. Can I export all tabs of a Power BI report into excel as a workbook with multiple tabs?

Multiple tabs of a power BI report with Inforiver visuals can be exported as a merged PDF and merged Excel workbook.

7. Can we set up filter rules for the paginated reports?

Yes. With the built-in page break feature in Inforiver – scheduler can handle this feature differently so that the same report could be sent to different individuals based on the page break criteria. 

8. Is there a way to call/reference the filter on the Email subject or body?

Yes, report filters can be included in the email subject/body – refer post for more details. 

9. Can I manually email the paginated reports without requiring Writeback Matrix?

Yes. With Reporting Matrix – you could manually download the paginated Inforiver PDF export and email your recipients. 

10. How much volume of data does scheduler support?

Inforiver is optimized for 30,000 rows or about 1,000 pages long. Inforiver is suited for highly visual and formatted paginated reports and not recommended for large data volume extract type reports. 

On-Premise

1. Is there any installation required for the Writeback Matrix On-Premise edition?

Self-hosting within your network in a private azure tenant requires you to deploy our solutions from the Azure Marketplace.
Detailed installation and configuration steps for Enterprise On-Premise are available for download here.
For further queries, feel free to reach out to us.

2. Can Inforiver walk us through the setup and administrative processes of the product?

Yes, we will provide walk through in our initial discovery call and we will help your deployment team as required. 

3. What documentation will Inforiver provide on the installation and maintenance?

Detailed installation and configuration steps for Enterprise On-Premise are available for download here. For further queries, feel free to reach out to us.

4. What access would Inforiver (company) require to the Inforiver (product) container/VM installed within our Azure?

We don't need any access. We can get together with your deployment team and guide them through the entire process. 

5. What are the communication requirements for the container/VM?

All communications would be done on top of https protocol itself. 

6. Would this Azure container/VM require being exposed to outside internet?

Yes, internet connectivity is required for proper functionality. Inforiver on-app premise services requires outbound connectivity to Power BI, Azure AD and Container Registry Service. 

7. What ports would need to be opened?

Only the outbound 443 port needs to be opened. All incoming ports except 443 and other outbound ports can be closed. 

8. Will any data be transported outside of the direct control of our organization?

Your organization would have the direct control of the entire data. We don't transport any data to any of our servers. Data can be moved to supporting user configured services from your org like Writeback database tables, OneDrive, SharePoint, SMTP etc. 

9. Is there any possibility of running this off AWS, EKS/ECS or on-prem Kubernetes?

Unfortunately, it is not possible right now. But we are looking for other platforms too. 

10. At what stage of implementation will we perform a sizing evaluation?

Before rolling out to the entire company or UAT is completed, we would be able to perform a sizing evaluation and provide proper recommendations. 

11. What capabilities does Inforiver have around role-based security models?

The access is regulated at the granular level and access controls are managed and monitored from Azure PIM. 

12. How long are the transaction logs available for?

30 days which is configurable after deployment through Azure Portal. 

13. How does the transport layer work between Power BI cloud and the Inforiver product?

We utilize SSL/TLS 1.2 to establish a secure communication between Inforiver and Power BI Cloud. The connection establishment and data transfer processes done as latest Power BI SDK. 

14. How is the Inforiver update sent to our Azure subscription (pull/push/automated)?

Image Pull update deployment All the components have an image tag version. When you update and re-deploy, the updates would be pulled directly from our container registry. 

15. Is there a particular type of server required server to be hosted within our environment?

We are using Azure Native cloud services. There is no VM based deployment. 

16. How is data sent to this server (authentication, network protocol)?

Data is sent through HTTPS protocol and every call would be authenticated by using JWT auth protocol. 

17. What are the prerequisites for Inforiver On-Premise?

The platform requirements are as below:  

     a. Existing Azure Subscription: A subscription trusts Azure AD to authenticate users, services, and devices.  

     b. New Azure Resource Group: new Azure group will grant the access at resource group level- which makes it simpler to manage           and provide greater visibility. 

     c. New Azure AD Application: User will use their domain-based credential to sign in so that users will have a single identity that           they can use to access their On-Premise version.

     d. SMTP Service Credentials: To enable email notification in the management console, user needs SMTP service credentials. 

SMTP Prerequisites  

  • SMTP Host/Server Address: An SMTP email server will have an address (or addresses) that can be set by the mail client or application that user is using and is generally formatted assmtp.serveraddress.com 
  • SMTP Username: User must mention full email address as SMTP Username, and email password as the SMTP password in mail configuration settings/coding 
  • SMTP Password: The SMTP password is the same as web password unless user is using 2SV. Use smtp.gmail.com, port 465, SSL or port 587/STARTTLS 
  • SMTP Port: SMTP is used to set up communication rules between the servers  

     e. Inforiver License Key: Prevents illegal use of software. It is a unique string of characters and numbers provided by Inforiver on          purchase of the product. User must agree to the terms of the license when acquiring the software. 

18. What are the resources needed in Azure for deployment?

We need the following resources in Azure: 

  1. Azure Web App Service and Plan
  2. Azure Kubernetes Service and its dependent Resource Group 
  3. Azure SQL Server and Database
  4. Azure Storage Account
  5. Azure Cache for Redis
  6. Azure Blob Storage
  7. Virtual Network and Subnets
  8. Private Links and Private Endpoints

19. What would be the Azure cost to maintain the services?

Pricing would be based on the estimation here. Pricing is subject to change from Azure itself and also based on your component’s usage.  

20. How does product support work with Writeback Matrix (On-Premise)?

You can purchase enterprise as a paid add-on, and it is meant for enterprises that require faster turnaround times and assurance. For more details, refer to https://inforiver.com/support/ 

Get Inforiver brochure

Maximize your business potential with Inforiver's paginated reporting, data entry, planning & budgeting capabilities
Download now
Inforiver by Lumel

Inforiver helps enterprises consolidate planning, reporting & analytics on a single platform (Power BI). The no-code, self-service award-winning platform has been recognized as the industry’s best and is adopted by many Fortune 100 firms.

Inforiver is a product of Lumel, the #1 Power BI AppSource Partner. The firm serves over 3,000 customers worldwide through its portfolio of products offered under the brands Inforiver, EDITable, ValQ, and xViz.

linkedin facebook pinterest youtube rss twitter instagram facebook-blank rss-blank linkedin-blank pinterest youtube twitter instagram