For knowage 7.1, is it possible to read and write for microsoft sql server?

Question

I used to using spagobi 5.0. After migration to knowage 7.1, the data source of microsoft sql server becomes read-only, and the read-and-write option is disabled. I am wondering how could I set it to read-and-write.

Answer 1

Dear Yuanxin
Starting from Knowage we have removed SQL Server from the list of certificated DBMS, used to store the metadata information and cache.

https://knowage-suite.readthedocs.io/en/7.1/installation-guide/software-release.html

So you can use SQL Server to read data only.

I suggest to use MySQL/Oracle/PostgreSQL as cache DBMS.

Best Regards

A