Click HERE to see how Saviynt Intelligence is transforming the industry. |
11/28/2023 07:12 AM
Hi Team,
We are looking to make use of dataset functionality for one of our integration.
Requirement - Using the technical rule account should be provisioned only to the users having certain specified email domain.
Steps so far - We have created a dataset with single column listing all the email domains and calling an select statement to check if the user email domain is in the pre-defined dataset.
The query seems to be working from data analyzer but the same is returning invalid condition when preview is performed in technical rule.
So, just want to understand if the usage of datasets is feasible from Technical Rule and user update rule. The below post says its feasible but seems to be not working even though the query is similar.
Kindly share your views.
Solved! Go to Solution.
11/29/2023 08:55 PM
Hi @AmarSimha,
We are checking on your request and we will keep you posted.
11/29/2023 09:08 PM
Can you share your configs
11/30/2023 02:30 AM
@rushikeshvartak @DixshantValecha : Below is the Query I am trying in the Technical Rule.
a.email IS NOT NULL AND (substring_index(a.email,'@',-1) in (SELECT dataset_values.attribute1 from dataset_values where dataset_values.datasetname = 'dataset'))
12/04/2023 06:20 PM
a.email IS NOT NULL AND (substring_index(a.email,'@',-1) in (SELECT attribute1 from Dataset_Values where datasetname = 'dataset'))
12/05/2023 10:16 AM - edited 12/05/2023 10:17 AM
@rushikeshvartak : Thank you for the update. I do see that the dataset values name is modified. Is this for HQL and also is there a reference to all the table names format that we should be using for HQL? I am aware of Users. But, want to see if there any documentation around it for the other tables as well.
12/05/2023 10:29 AM
I have pasted several in below post https://forums.saviynt.com/t5/identity-governance/java-table-schema-names/m-p/61386#M39844
12/01/2023 04:19 AM
Hi @AmarSimha,
We would appreciate it if you could provide feedback on the effectiveness of the queries provided below:
1. Query 1:
```sql
a.userkey=268117 and a.customproperty64 in (select distinct dataset_values.attribute1 from dataset_values where dataset_values.datasetname = 'City' )
```
2. Query 2:
```sql
a.email IS NOT NULL AND (substring_index(a.email,'@',-1) in (SELECT dataset_values.attribute1 from dataset_values where dataset_values.datasetname = 'dataset'))
```
When utilizing these queries, please inform us of any encountered issues or errors, and if possible, kindly share the specific error messages logged.
Your cooperation in this matter is greatly appreciated. Should you have any questions or require further clarification, feel free to reach out.
Thank you for your time and attention to this matter.
12/04/2023 05:44 AM
@DixshantValecha : I am not sure if I understand the ask correctly, do you want me to test the queries again? I do not see any change in the queries I had shared. Please confirm
12/04/2023 10:57 PM
Hi @AmarSimha,
I am writing to inquire about the status of the queries that were recently tested. If you have already conducted the tests, could you please furnish me with the relevant details? Specifically, I am interested in understanding the observations and findings derived from the logs during the comparison process of both the queries.
12/05/2023 10:28 AM
You need to have class name from java code exactly same