All ideas are welcome. Just because the Idea doesn't make it into the product immediately does not make it a bad idea.
From ZenDesk ticket #47605:
I have a requirement to run a pre-built python script using Syniti to pull the files from a server path and upload the files in another server path.
How can we achieve this. We are looking for the solution to utilize the script in any of the Syniti tool and not limited to any tool usage that might be needed.
Also I need to connect the recommended system to REST API so a solution around that as well will be helpful.
Guest
We believe that you can run Python directly from SQL Server (2017 onwards) once the relevant extensions are installed. This should then allow you to trigger a procedure running that logic from with ADM or ADMM. Example here https://learn.microsoft.com/en-us/sql/machine-learning/tutorials/quickstart-python-create-script?view=sql-server-ver16
Longer term we are working on a more direct connection for REST APIs and the ability to call Orchestrate from Migrate ETL to give more options for running various tasks (match, melissa data, boomi, etc)
Attachments Open full size
You should be able to use Syniti Connect (I.e. Boomi) to call Rest APIs and run Python scripts. https://community.boomi.com/s/article/How-to-Execute-a-Python-Script. You can then call Syniti Connect from SKP Orchestrate.
Attachments Open full size