Execute a SQL Store Procedure in Script

User: "Danny_21371"
Danny_21371
Altair Community Member
Updated by Danny_21371
Hi, 
I am having such a hard time trying to figure out how to connect to a SQL Server and execute a stored procedure.  
I am using Monarch Automator 15.3.  I added a Script to the Visual process but there isn't any good tutorials that I can find to do this. 

Any help is much appreciated. 

Thanks,

------------------------------
Danny Valenzuela
Senior Database Administrator

------------------------------

Find more posts tagged with

English
Monarch
Sort by:
1 - 7 of 71
    User: "Mo Abdolrahim"
    Mo Abdolrahim
    Altair Employee
    Updated by Mo Abdolrahim

    Hi Danny,
    Please see attached document.
    Regards
    Mo

    ------------------------------
    Mahmoud Abdolrahim
    Senior Implementation & Integration Engineer
    Datawatch Corporation
    MA
    (978) 935-3840
    ------------------------------
    -------------------------------------------
    Original Message:
    Sent: 06-01-2019 05:32 PM
    From: Danny Valenzuela
    Subject: Execute a SQL Store Procedure in Script

    Hi,
    I am having such a hard time trying to figure out how to connect to a SQL Server and execute a stored procedure.
    I am using Monarch Automator 15.3.  I added a Script to the Visual process but there isn't any good tutorials that I can find to do this.

    Any help is much appreciated.

    Thanks,

    ------------------------------
    Danny Valenzuela
    Senior Database Administrator

    ------------------------------
    "
    How to run a Stored procedure in Automator Visual Process.docx
    User: "Leonid"
    Leonid
    New Altair Community Member
    Updated by Leonid

    Hi Danny,
    Please see attached document.
    Regards
    Mo

    ------------------------------
    Mahmoud Abdolrahim
    Senior Implementation & Integration Engineer
    Datawatch Corporation
    MA
    (978) 935-3840
    ------------------------------
    -------------------------------------------
    Original Message:
    Sent: 06-01-2019 05:32 PM
    From: Danny Valenzuela
    Subject: Execute a SQL Store Procedure in Script

    Hi,
    I am having such a hard time trying to figure out how to connect to a SQL Server and execute a stored procedure.
    I am using Monarch Automator 15.3.  I added a Script to the Visual process but there isn't any good tutorials that I can find to do this.

    Any help is much appreciated.

    Thanks,

    ------------------------------
    Danny Valenzuela
    Senior Database Administrator

    ------------------------------
    "
    Hi Mo,

    This is a very useful script that we were looking for. I have one question - instead of calling a stored procedure that has no output, can we call a SQL function (or direct Select from the table) that will return exactly one value - "select dbo.f_getBusinessDate()" and stored it in the Automator global variable. Then we can use this variable throughout all processes that need to insert data into different tables using business date, rather then calendar date.

    Thank you,
    Leonid

    ------------------------------
    Leonid Shteyngardt
    App Dev Manager
    Canaccord Genuity Inc.
    New York NY
    (212) 389-8176
    ------------------------------
    -------------------------------------------
    Original Message:
    Sent: 06-02-2019 09:23 PM
    From: Mahmoud Abdolrahim
    Subject: Execute a SQL Store Procedure in Script

    Hi Danny,
    Please see attached document.
    Regards
    Mo

    ------------------------------
    Mahmoud Abdolrahim
    Senior Implementation & Integration Engineer
    Datawatch Corporation
    MA
    (978) 935-3840
    ------------------------------

    Original Message:
    Sent: 06-01-2019 05:32 PM
    From: Danny Valenzuela
    Subject: Execute a SQL Store Procedure in Script

    Hi,
    I am having such a hard time trying to figure out how to connect to a SQL Server and execute a stored procedure.
    I am using Monarch Automator 15.3.  I added a Script to the Visual process but there isn't any good tutorials that I can find to do this.

    Any help is much appreciated.

    Thanks,

    ------------------------------
    Danny Valenzuela
    Senior Database Administrator

    ------------------------------
    "
    User: "Mo Abdolrahim"
    Mo Abdolrahim
    Altair Employee
    Updated by Mo Abdolrahim

    Hi Mo,

    This is a very useful script that we were looking for. I have one question - instead of calling a stored procedure that has no output, can we call a SQL function (or direct Select from the table) that will return exactly one value - "select dbo.f_getBusinessDate()" and stored it in the Automator global variable. Then we can use this variable throughout all processes that need to insert data into different tables using business date, rather then calendar date.

    Thank you,
    Leonid

    ------------------------------
    Leonid Shteyngardt
    App Dev Manager
    Canaccord Genuity Inc.
    New York NY
    (212) 389-8176
    ------------------------------
    -------------------------------------------
    Original Message:
    Sent: 06-02-2019 09:23 PM
    From: Mahmoud Abdolrahim
    Subject: Execute a SQL Store Procedure in Script

    Hi Danny,
    Please see attached document.
    Regards
    Mo

    ------------------------------
    Mahmoud Abdolrahim
    Senior Implementation & Integration Engineer
    Datawatch Corporation
    MA
    (978) 935-3840
    ------------------------------

    Original Message:
    Sent: 06-01-2019 05:32 PM
    From: Danny Valenzuela
    Subject: Execute a SQL Store Procedure in Script

    Hi,
    I am having such a hard time trying to figure out how to connect to a SQL Server and execute a stored procedure.
    I am using Monarch Automator 15.3.  I added a Script to the Visual process but there isn't any good tutorials that I can find to do this.

    Any help is much appreciated.

    Thanks,

    ------------------------------
    Danny Valenzuela
    Senior Database Administrator

    ------------------------------
    "
    Hi Leonid,
    Attached document provides an example of executing a TSQL function. 
    In this example I used one of the Monarch Server Automator User Defined functions, which returns the current Automator version number, and assign it to a global variable.

    Regards
    Mo

    ------------------------------
    Mahmoud Abdolrahim
    Senior Implementation & Integration Engineer
    Datawatch Corporation
    MA
    (978) 935-3840
    ------------------------------
    -------------------------------------------
    Original Message:
    Sent: 06-06-2019 07:34 AM
    From: Leonid Shteyngardt
    Subject: Execute a SQL Store Procedure in Script

    Hi Mo,

    This is a very useful script that we were looking for. I have one question - instead of calling a stored procedure that has no output, can we call a SQL function (or direct Select from the table) that will return exactly one value - "select dbo.f_getBusinessDate()" and stored it in the Automator global variable. Then we can use this variable throughout all processes that need to insert data into different tables using business date, rather then calendar date.

    Thank you,
    Leonid

    ------------------------------
    Leonid Shteyngardt
    App Dev Manager
    Canaccord Genuity Inc.
    New York NY
    (212) 389-8176
    ------------------------------

    Original Message:
    Sent: 06-02-2019 09:23 PM
    From: Mahmoud Abdolrahim
    Subject: Execute a SQL Store Procedure in Script

    Hi Danny,
    Please see attached document.
    Regards
    Mo

    ------------------------------
    Mahmoud Abdolrahim
    Senior Implementation & Integration Engineer
    Datawatch Corporation
    MA
    (978) 935-3840

    Original Message:
    Sent: 06-01-2019 05:32 PM
    From: Danny Valenzuela
    Subject: Execute a SQL Store Procedure in Script

    Hi,
    I am having such a hard time trying to figure out how to connect to a SQL Server and execute a stored procedure.
    I am using Monarch Automator 15.3.  I added a Script to the Visual process but there isn't any good tutorials that I can find to do this.

    Any help is much appreciated.

    Thanks,

    ------------------------------
    Danny Valenzuela
    Senior Database Administrator

    ------------------------------
    "
    Run a TSQL Scaler Function.docx
    User: "Leonid"
    Leonid
    New Altair Community Member
    Updated by Leonid

    Hi Leonid,
    Attached document provides an example of executing a TSQL function. 
    In this example I used one of the Monarch Server Automator User Defined functions, which returns the current Automator version number, and assign it to a global variable.

    Regards
    Mo

    ------------------------------
    Mahmoud Abdolrahim
    Senior Implementation & Integration Engineer
    Datawatch Corporation
    MA
    (978) 935-3840
    ------------------------------
    -------------------------------------------
    Original Message:
    Sent: 06-06-2019 07:34 AM
    From: Leonid Shteyngardt
    Subject: Execute a SQL Store Procedure in Script

    Hi Mo,

    This is a very useful script that we were looking for. I have one question - instead of calling a stored procedure that has no output, can we call a SQL function (or direct Select from the table) that will return exactly one value - "select dbo.f_getBusinessDate()" and stored it in the Automator global variable. Then we can use this variable throughout all processes that need to insert data into different tables using business date, rather then calendar date.

    Thank you,
    Leonid

    ------------------------------
    Leonid Shteyngardt
    App Dev Manager
    Canaccord Genuity Inc.
    New York NY
    (212) 389-8176
    ------------------------------

    Original Message:
    Sent: 06-02-2019 09:23 PM
    From: Mahmoud Abdolrahim
    Subject: Execute a SQL Store Procedure in Script

    Hi Danny,
    Please see attached document.
    Regards
    Mo

    ------------------------------
    Mahmoud Abdolrahim
    Senior Implementation & Integration Engineer
    Datawatch Corporation
    MA
    (978) 935-3840

    Original Message:
    Sent: 06-01-2019 05:32 PM
    From: Danny Valenzuela
    Subject: Execute a SQL Store Procedure in Script

    Hi,
    I am having such a hard time trying to figure out how to connect to a SQL Server and execute a stored procedure.
    I am using Monarch Automator 15.3.  I added a Script to the Visual process but there isn't any good tutorials that I can find to do this.

    Any help is much appreciated.

    Thanks,

    ------------------------------
    Danny Valenzuela
    Senior Database Administrator

    ------------------------------
    "
    Hi Mo,

    This is perfect!

    Thank you so much for sharing these scripts!

    Leonid

    ------------------------------
    Leonid Shteyngardt
    App Dev Manager
    Canaccord Genuity Inc.
    New York NY
    (212) 389-8176
    ------------------------------
    -------------------------------------------
    Original Message:
    Sent: 06-07-2019 11:29 AM
    From: Mahmoud Abdolrahim
    Subject: Execute a SQL Store Procedure in Script

    Hi Leonid,
    Attached document provides an example of executing a TSQL function.
    In this example I used one of the Monarch Server Automator User Defined functions, which returns the current Automator version number, and assign it to a global variable.

    Regards
    Mo

    ------------------------------
    Mahmoud Abdolrahim
    Senior Implementation & Integration Engineer
    Datawatch Corporation
    MA
    (978) 935-3840
    ------------------------------

    Original Message:
    Sent: 06-06-2019 07:34 AM
    From: Leonid Shteyngardt
    Subject: Execute a SQL Store Procedure in Script

    Hi Mo,

    This is a very useful script that we were looking for. I have one question - instead of calling a stored procedure that has no output, can we call a SQL function (or direct Select from the table) that will return exactly one value - "select dbo.f_getBusinessDate()" and stored it in the Automator global variable. Then we can use this variable throughout all processes that need to insert data into different tables using business date, rather then calendar date.

    Thank you,
    Leonid

    ------------------------------
    Leonid Shteyngardt
    App Dev Manager
    Canaccord Genuity Inc.
    New York NY
    (212) 389-8176

    Original Message:
    Sent: 06-02-2019 09:23 PM
    From: Mahmoud Abdolrahim
    Subject: Execute a SQL Store Procedure in Script

    Hi Danny,
    Please see attached document.
    Regards
    Mo

    ------------------------------
    Mahmoud Abdolrahim
    Senior Implementation & Integration Engineer
    Datawatch Corporation
    MA
    (978) 935-3840

    Original Message:
    Sent: 06-01-2019 05:32 PM
    From: Danny Valenzuela
    Subject: Execute a SQL Store Procedure in Script

    Hi,
    I am having such a hard time trying to figure out how to connect to a SQL Server and execute a stored procedure.
    I am using Monarch Automator 15.3.  I added a Script to the Visual process but there isn't any good tutorials that I can find to do this.

    Any help is much appreciated.

    Thanks,

    ------------------------------
    Danny Valenzuela
    Senior Database Administrator

    ------------------------------
    "
    User: "MRyba"
    MRyba
    Altair Community Member
    Updated by MRyba

    How do I download or view the file How to run a Stored procedure in Automator Visual Process.docx?

    User: "Mo Abdolrahim"
    Mo Abdolrahim
    Altair Employee
    Updated by Mo Abdolrahim

    Hi Matt,

    Please see attached file.

    Mo

    How to run a Stored procedure in Automator Visual Process1.docx
    User: "Mo Abdolrahim"
    Mo Abdolrahim
    Altair Employee
    Updated by Mo Abdolrahim

    If you click on the attached file it will be downloaded to the default download folder.

    Mo

Quick Links