https://communities.sas.com/t5/Fraud-AML-and-Security/adding-client-specific-views-to-PostgreSQL-VI-10-8-AML-8-3/m-p/897405#M960 <P>It's better to create a new Schema with all the custom views so that these are more manageable. however, you could create views in existing schemas form where the data is being sourced. Adding new tables and views shouldn't impact future HFs or upgrades.</P> Thu, 05 Oct 2023 15:39:39 GMT AchinGupta 2023-10-05T15:39:39Z https://communities.sas.com/t5/Fraud-AML-and-Security/adding-client-specific-views-to-PostgreSQL-VI-10-8-AML-8-3/m-p/893549#M954 <P>Hi all,<BR />we have a request to write complex queries based on the information regarding alerts client have in AML 8.3 (VI 10.8)<BR />we were thinking about creating some views in the VI internal DB that will help us to query the data.<BR />is this possible?<BR />what is the best practice for this? a difference scheme, etc?</P><P>Thanks ,<BR />Alex.</P> Mon, 11 Sep 2023 11:46:22 GMT https://communities.sas.com/t5/Fraud-AML-and-Security/adding-client-specific-views-to-PostgreSQL-VI-10-8-AML-8-3/m-p/893549#M954 agesser 2023-09-11T11:46:22Z https://communities.sas.com/t5/Fraud-AML-and-Security/adding-client-specific-views-to-PostgreSQL-VI-10-8-AML-8-3/m-p/897405#M960 <P>It's better to create a new Schema with all the custom views so that these are more manageable. however, you could create views in existing schemas form where the data is being sourced. Adding new tables and views shouldn't impact future HFs or upgrades.</P> Thu, 05 Oct 2023 15:39:39 GMT https://communities.sas.com/t5/Fraud-AML-and-Security/adding-client-specific-views-to-PostgreSQL-VI-10-8-AML-8-3/m-p/897405#M960 AchinGupta 2023-10-05T15:39:39Z