Note that ENTITY_LINK fields point to related tables (one-to-many relationships). The Studio definition in SMA-X is used as a reference for fields in the record model. In addition, if you have production, development, and staging tenants, there will be views for each.Īs shown in the figure above, each record type has a corresponding view of the same name. You can find the views for any given tenants by filtering with a prefix “view_,” then select several views as needed to create reports. The naming convention of each view indicates to which tenant it belongs. Each set contains views representing all relevant record types in the SMA-X data model. Views and SMA-X tenantsĪ separate set of views is generated for each tenant in an SMA-X deployment instance. PG pool or repmgr is used for automatic failover.įor reference, see. PG pool is used in production for load balance and read/write splitting. PG stream replication in the production is for both high availability and load balance.
Replication, Clustering, and Connection Pooling is a good overview of resources and projects providing PG replication options.Īt the moment, pgpool II is our primary validated solution. There are many public resources with information about PostgreSQL replication. It is recommended to set up a replicated reporting store to properly support complex reporting in production environments. PostgreSQL reporting with a mirrored data store However, if the data model changes, for example, a new custom field is added, the views need to be refreshed manually by clicking the Refresh button in the Application Settings menu, as shown below. Note: You do not need to generate or refresh views to get the latest data updates. By connecting a third-party tool such as Microsoft Power BI and Tableau directly to your SMA-X data, PostgreSQL views can be utilized by a Service Management database user to generate database reports. PostgreSQL views are generated during the platform start-up. Meanwhile, complex reporting and KPI needs such as queries involving many-to-many relations can be better addressed with BI Tools crafted specifically for this purpose. SMA-X built-in reports and dashboards provide a quick and useful way to define many simple operational and analytic reports. Administer > Administer the Service Management > Generate report based on PostgreSQL views Generate report based on PostgreSQL views
0 kommentar(er)
