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.

Extending existing System Report

Client would like to enhance the existing report Home > System Reports >> All Snapshot Tables with following fields: to include the following additional information: Execution context INITIATED_BY START_TIME END_TIME Outcome and metrics STATUS PROCESSED_RECORDS FAILED_RECORDS WARNING_COUNT LATENCY_SECONDS I could not find the table which stores this data. This information I think is beneficial for the client. Please look into this enhanced system report.

ash.tallapally 1 day ago

1

A List Over Limit error displays when the user selects a list box item in excel integration.

I understand that excel is limited to only 3000 entries in the list box. The default limitation is ok, however, I think we can have a setting like we had in ADM that will allow us to increase/modify this default setting to allow more values in the dropdown depending on the configuration in the project.

Divya Navandar 5 days ago

1

Enhancement Request: Enable Escape Key to Close Popup Windows in SKP

Currently, when interacting with popup/modal windows in the Syniti Knowledge Platform (SKP), users are unable to close the popup by pressing the Escape key on the keyboard. This deviates from standard web application behavior and impacts usability, accessibility, and efficiency for end users—especially for power users accustomed to using keyboard shortcuts. Request: We propose enhancing this experience by enabling Escape to close popups. However, if a user has unsaved changes within a popup, pressing Escape should trigger a prompt/warning before the popup is closed, allowing the user to cancel the action or continue and discard changes. Enhancement Details: Support Escape key as a shortcut to close popups and modal dialogs throughout SKP. If unsaved changes are detected within the popup: Intercept the Escape key event. Display a warning dialog: “You have unsaved changes. Are you sure you want to close this popup and discard your changes?” Offer “Cancel” and “Discard changes” options. This ensures alignment with broad web application standards and reduces accidental data loss. For popups where Escape/cancel is not appropriate (such as critical workflow confirmations), allow exceptions as appropriate.

santosh.srirangam@synniti.com 5 days ago

1

Create a way to execute a single ETL report in the background

In Migrate when you build a very heavy query and click the Refresh button, it will run for a max of 3 minutes regardless of what your report timeout and data source timeout have been set to. You do have the ability to kick off all reports from the Target > ETL page, and that will kick off a job queue and run it in the background. But I’m just trying to run a single report, and have it run one time. When you click the refresh icon, the status does change to the arrow/spin circle, but if you click off of the page I believe it cancels the job. And even if you stay on the page, if it takes longer than 3 minutes you get a 504 error. So we need a way to kick off these reports directly into the background (maybe from the Report Details?).

jay.hornback@syniti.com 14 days ago

1

Future Consideration

2 new Syntax Score Data Quality rules

We understand that the following syntax rules contribute to the clear definition of every Data Quality Rule: 1. Rule statement ≤ 84 characters when possible. The rules must be clearly explained in one single sentence 2. Avoid the usage of acronyms or abbreviations. It cannot be assumed that there are universally adopted acronyms for all personas Both rules could be included in Statement Syntax Score feature that helps the end user at the creation of a new Data Quality Rule. This is one example of the feature “Statement Syntax Score” that we mean:

jose.garcia 14 days ago

Add 'Map to Expression' to Replicate Preview

In SDR we have a feature to ‘Map to Expression’ but that is not available in Replicate Preview (as far as I can tell?). In my use case, I have an Oracle column that sometimes has a value chr(0) which is the equivalent to NULL. NULL is also a separate value. In our Postgres target database there is no concept of chr(0), so I would be attempting to create a case statement to map NULL and chr(0) → NULL. But I don’t think I currently have the ability to do this in Replicate today?

jay.hornback@syniti.com 20 days ago

Expand Export options

Right now when you create an export you can choose the delimiter and whether to have a header or not. The file that gets created follows the format: {{database}}.{{schema}}.{{view_name}}.csv I’d like to request a couple of additional parameters to this page: 1) TXT vs CSV vs Excel - allowing us to choose the file type 2) File name textbox - instead of defaulting to the {{database}}.{{schema}}.{{view_name}} format, what if I just want it to be view_name.txt? Or maybe something different all together? 3) Potentially a different destination, or a subfolder within the defined Admin > Setup > Parameters > Export Path

jay.hornback@syniti.com 22 days ago

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) 29 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 About 1 month 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 About 1 month 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 About 1 month 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 About 1 month 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 About 1 month ago

2