Datastore
- [Clients] - Copy Client settings to another Client
- Datastore Parameters
To use a Bizview Datastore for a client, you need to connect the Client to that Datastore. There can be multiple Datastores within a Bizview solution SQL Server environment; however, each and every Client in Bizview can only use one.
To define a Datastore for the Client, access the Datastore configuration by selecting System Administration > Data Services > Configuration > Datastore.
Below is a list of the available fields:
Field | Description | Example | Note |
|---|---|---|---|
Client ID | The Client ID for which to specify Datastore | 10 | |
Database | Type the name of the Datastore | bizview_ncg_ds | Note that the name has to exactly the same as the database name. |
Additional Information
Now that you told the Bizview Client which database to use (in the fields mentioned above), you also have to do the opposite! You need to specify which Bizview application database the Datastore should work against. This step requires that you open SQL Management Studio and perform a manual insert of a row.
Complete the following:
Open SQL Management Studio, and locate the Datastore.
Then, right-click on table app.settings Edit top 200 rows.
Find setting_id 100. If it does not exist, enter the information in an empty row:
setting_id*: " 100" must be the setting ID.
descr*: "Application Database" must be the description.
value_1*: Enter the exact name of the Bizview Application Database.