Interfaces to the Bizview Application Database
The following published interfaces to the Bizview application database are available (Bizview 5.2). New staging tables may be published in later versions.
This topic contains the following sections:
Object Values and Related Data
stg.object_values
Interface for ObjectValues (dimension members) to the Bizview application database. For example the chart of accounts, the list of cost centers, customers groups etc.
stg.object_value_attributes
Interface for adding attributes to the ObjectValues. For example product color, account type etc. Because one ObjectValue can have unlimited number of attributes, this must be a separate table.
stg.object_trees
Interface for linking ObjectValues between different Objects. I.e. connect for example cost centers to divisions (if they are different objects, different dimensions).
Users and Access Control
stg.users
Interface for the list of users able to login and access the Bizview system and the related Bizview application database.
stg.user_clients
Interface for the connection between each user and what clients the user should have access to.
stg.user_roles
Interface for the connection between each user and what roles the user should be associated to.
stg.user_organizations
Interface for the connection between each user and what Bizview organizations the user should linked to.
Active Directory Users and Access Control
By using the Bizview Active Directory Service it's possible to automatically synchronize Active Directory users and groups into the Bizview application database. This is very useful in combination with the Single Sign-on (SSO) functionality within Bizview. It also makes it possible to manage the access to the Bizview system using Active Directory.
If a 'role' in Bizview has the same name as an AD, the AD-users in this group will be pushed by the service to the stg.ad_users table, and the group belonging will be pushed to the stg.ad_users_links table. After these actions the service will execute the 'xxx' procedure. This procedure will need to be customized for each installation due to the fact that the active directory user information is not enough for Bizview. The AD user information must be complemented by data from an ERP system or other data source and then finally be added to the stg.users and related tables described above.
stg.ad_users
Interface for Bizview Active Directory Service with AD-users. Data from this table should be loaded together with other data to the above described stg.users table.
stg.ad_users_links
Interface for the Bizview Active Directory Service with AD-group relations for each user. Data from this table should be loaded together with other data to the above described stg.user_clients, roles and organization tables.
Next step: Planning Data