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.

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 3 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 3 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 9 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 11 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) 18 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 21 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 23 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 23 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 23 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 23 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 29 days ago

1