Welcome to the Syniti Ideas Portal!

Do you have feedback regarding the current product, or new ideas for improvement?

Tell us how we can make the Syniti Knowledge Platform more useful to you.

Planned

Orchestrate Cloud Replicate Task: enable Replicate Group selection

Support Request (#133657) Orchestrate does not allow adding Cloud Replicate Group replications, instead it requires adding replications one by one. We know that we can add an schedule to a Group in Cloud Replicate, but this would then be externally to the Orchestrate workflow and missing potential dependencies on standard workflows like: Refresh tables SRCECC Process ETL Run Data Quality reports

Ana Garcia Rubio (Syniti) 15 days ago

Future Consideration

Match Review - Ability to Group Groups together for SoldTo vs. ShipTo etc.

It would be helpful to add the functionality of grouping groups together into entities. This can be done outside the tool in a construction application currently, but with simple sold-to ship to differences as well as account groups it would be helpful to have hierarchical entity assignments that could be named.

Upton, Michael 18 days ago

1

Toggle button for 'Include Error Detail' on connection

In SQL Editor when you get certain errors in your query, a generic error message appears that says something to the effect of “if you want more details, you need to add ‘Include Error Detail’ = true in your connection string”. In my case we are not hardcoding the connection string, so we would want a toggle switch on the setup to make this doable for us.

jay.hornback@syniti.com 20 days ago

Postgres: build function or procedure to assist in column changes

Postgres is a lot more restrictive when it comes to adding/deleting columns to views, changing column names of a table, changing data types of a column, etc. If the column is used somewhere else Postgres will not allow it. In some cases, like if you try to delete a table, it will tell you which views prevent you from doing that. You have to go find anywhere where the object is used, edit each view or drop all views, make your table change, then recreate the views. This is dangerous as if you have multiple nested views, or if you’re deep into a project and there are many views using a table, you risk losing your work, dropping and not creating in the same order, etc. My idea here is that we at the very least come up with a script to query the database metadata to assist in this effort. At a minimum, you input a table or column and it outputs the views where it is used. The max ask here would be for the SP to execute the change for you - it would store the drop and create view scripts in temp variables, then execute the drop script, make the column change, execute the recreate script.

jay.hornback@syniti.com 20 days ago

2

ETL Tasks Save Current Configuration In Case Of Accidental Changes

Enable the saving and restoring of ETL tasks configuration similar to the promotion of ETL jobs to another environment, but to a timestamped named version. This would allow for a user to revert to an ETL version that worked previously if issues are found. Reasons this would be helpful: -We work on teams and at times team members make changes and do not realize their impact -Accidental reorder of ETL tasks can cause catastrophic issues that are difficult to find -Having a copy you know is working can allow you to make changes for testing to see if they resolve issues and revert if the issue is not resolved saving development time Cred to Jay Hornback for suggesting an undo button… this just takes to next level

Upton, Michael 20 days ago

1

Admin menu should appear to anyone with access to any of the admin features and not just those with the administrator role.

Admin Menu does not appear to anyone other than those with the administrator role. This is poor design as it should be available to anyone who has access to any of the administration features. Otherwise they cannot access these features as there is no navigation path to them. This caused the client to have to add me as an administrator despite their preference to only provide essential functions.

Upton, Michael 20 days ago

2

In Progress

Ability to display dashboard as well as ability to download DQ reports execution along with dataset information.

Client TECK Resources is using the SKP DQ Quality module to build and register multiple data quality reports and would like to use dashboards to regularly track data cleansing progress. They currently have four subject areas comprising over 70 datasets in total: ATR (Acquire-to-Retire) PTC (Product-to-Cash) RTR (Record-to-Report) STP (Source-to-Pay) The client would like to view weekly, monthly, and yearly trends for each subject area as well as for individual datasets. Out of the box, the standard dashboard only supports DQ trend reporting at the overall program level. Since subject-area and dataset-level trending is not supported natively, we attempted to build a custom dashboard that would display execution details by subject area along with dataset names. The intent was for the client to download this data and use it in their own Power BI dashboards. However, we were unable to include the dataset name in the custom dashboard because none of the standard data sources available in the custom dashboard builder expose this information. We consulted with Maz, who indicated that extracting this level of detail would require making an API call. . At this point, we have not identified a solution to download execution data that includes: Subject area Dataset name Rules Enforcement and implementation details Last execution date DQ score metrics Could you please advise on the recommended approach to achieve this level of reporting? Support ticket : https://support.syniti.com/hc/en-us/requests/131976

Gaurav Kothari 26 days ago

1

Security Profile Administrator vs Assigner

We understand that Users assigned to a Profile as a Manager can assign that Profile to an Asset. Can we establish two roles under the Profile? One as a Manager - Administrator to administer/change the Profile, and another as Manager - Assigner who can assign the Profile to Assets but cannot make changes to the Profile, like adding other Managers, Roles or Groups.

Anthony Moreno About 1 month ago

Dataset Design - auto-activate all columns

This doesn’t need to be a prominent feature, but having an “activate all” “deactivate all” button on the dataset design would be useful. In my case we’re activating sometimes 100 columns out of 110 on a target table, and it would be quicker to have a button to do this for us. I could see this being in the pop up box on the table details?

jay.hornback@syniti.com About 1 month ago

1

Client is looking for detailed information in the Rejected Mapping Email Notification in Mapping approval mail.

Client is looking for detailed information in the Rejected Mapping Email Notification as we receive for any Mapping Changes. Client is expecting a detailed message for "Rejected Build Status" - Currently we are getting this email notification as below :![](https://backofficeassociates.zendesk.com/attachments/token/0juT0KhrfTxO8HcREbnMGJr73/?name=mceclip0.png) Client is expecting a detailed message same as what they are receiving for any mapping changes as shown below:![](https://backofficeassociates.zendesk.com/attachments/token/IqJnDJ7oOtXOhI0LJFHZitiQi/?name=mceclip1.png) Can you please help with this?

Iliyan Atanasov About 2 months ago

Planned

Hi Team,

Feature Request: The client wants to see their DataSource and corresponding DataStore for each Business and Developer. The SKP documentation for Security Profiles states that applying it at the DataSource level shows both the DataSource and the DataStore. In our case, we did this with Ana, and now we can no longer see the DataSource; we only see the DataStore. The same thing happens when creating a new system and a new Security Profile Group in Cumulus. Is possible to create this feature request? BR, Iliyan

Iliyan Atanasov About 2 months ago

2

Governance Improvement: Audit Logging and Change Tracking Proposal

Dear Syniti Team, We have encountered an issue reported by our ETL team: changes were made to the Value List page, specifically involving modifications to page names. These changes have impacted downstream processes, but we currently lack visibility into who made these changes and when. To address this gap and strengthen governance, we propose the enhancement on Audit Logging & Change Tracking Thank you for your support. Best regards, Swapnila Aundhakar

Swapnila.Aundhakar About 2 months ago