We are using a Business-Critical tier SQL Server in Azure. With this config, we automatically get a read replica. Is there any way for BIX to use this database as it's source? I found a thread from 5 years ago saying read-only was not possible for BIX, but was on the roadmap. Hope there's an update to this.
@SteveW3592 thanks for pointing us to the original discussion on the forum.
I checked and the documentation still specifies that BIX needs to be able to write records into the database, so while maybe on configuration time you might only need read permission, at runtime when executing the extract the privilege to insert records is needed.
So the documentation mentions the need for generic insert and view-metadata privileges, as well as when client is selecting extract file type.
"Specify a JDBC URL to an existing external database instance into which to insert the database schema manifest files.
You must have insert and view-metadata privileges for the database into which you want to insert the database schema manifest files."