Running pre-built Python script to move files between server paths
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
- Dec 22 2023
- Already exists
-
Jan 18, 2024
Admin response
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
Related ideas
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)
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.