IBM Optim

IBM Optim

Enable Data Operations with Optim for AI and Cloud - accelerating innovation, reducing costs, ensuring data sovereignty


#Dataintegration
#Databases
#InfoSphereOptim
#Analyticstools
 View Only

  • 1.  Can SQL scripts be run in Optim as Service?

    Posted 05/15/23 06:14 PM

    Dear all,

    There are some tasks that I still need to do via SQL script, and I am wondering if it is possible to add this query to one service and be possible to run as a service.
    Did anyone experience this situation and could help me? :)


    Kind Regards,
    Matheus



    ------------------------------
    Matheus Rocha
    ------------------------------


  • 2.  RE: Can SQL scripts be run in Optim as Service?

    Posted 05/15/23 06:22 PM
    Matheus,

    It is possible to run SQL commands for most databases within certain Optim processes.  To do this, you would need to utilize the "Actions" tab on the process/service.  There are generally options to do the script before or after a process.  Each is slightly different.

    Refer to the following link for information on managing the actions:  Managing Actions

    --

    Jimmy Wilson


    1999 S. Bascom Ste 700

    Campbell, CA 95008

    Phone +1(972) 567-5558

    jwilson@abmartin.com

     

    Unstructured Data Masking

    Data Privacy/Test data Management - fabrication, optimization, obfuscation






  • 3.  RE: Can SQL scripts be run in Optim as Service?

    Posted 05/19/23 05:17 AM

    Hello, 

    Jimmy,

    Thank you very much!
    I will try to do it and if I have further questions, is it possible to reach you?


    Kind Regards,
    Matheus Rocha



    ------------------------------
    Matheus Rocha
    ------------------------------

    Original Message


  • 4.  RE: Can SQL scripts be run in Optim as Service?

    Posted 07/12/23 02:45 AM

    Hey, Jimmy!

    Do you have an example of this use?



    ------------------------------
    Matheus Rocha
    ------------------------------

    Original Message


Related Content