InfoSphere Optim

InfoSphere Optim

Connect with Db2, Informix, Netezza, open source, and other data experts to gain value from your data, share insights, and solve problems.

 View Only
  • 1.  password protected Optim extract File

    Posted Wed May 25, 2022 01:28 PM
    Hi All,

    Is there any way can set up password for Optim extract file (XF file). like no one should be able to open the file without password and Optim. 

    is there any configuration available in Optim for this password  protection setup?

    Thanks
    Rajesh

    ------------------------------
    rajesh guttikonda
    ------------------------------

    #InfoSphereOptim
    #Optim


  • 2.  RE: password protected Optim extract File

    Posted Wed May 25, 2022 01:48 PM
    Hello Rajesh,

    Review Optim security, it has different options you can leverage,

    https://www.ibm.com/docs/en/iodg/11.3?topic=reference-optim-security

    ------------------------------
    Vishwas Balakrishna
    ------------------------------



  • 3.  RE: password protected Optim extract File

    Posted Wed May 25, 2022 02:24 PM
    Hi Vishwas,

    Thanks for your response. 

    i am particularly looking security options for extract file. i see there are options only for Archive file. 
    Let me know if you have any idea on this setting up security for Extract file.

    Thanks
    Rajesh

    ------------------------------
    rajesh guttikonda
    ------------------------------



  • 4.  RE: password protected Optim extract File

    Posted Wed May 25, 2022 05:05 PM
    Hello Rajesh,

    You don't need to keep extract file, as you can use convert after extract to mask any sensitive columns in your extracted data. So the data in your extract file will not have production data in it.

    Thanks and regards,
    Vishwas Balakrishna
    Cell: +1 818-309-0972





  • 5.  RE: password protected Optim extract File

    Posted Wed May 25, 2022 05:18 PM
    Rajesh,

    As a second option, if you use the convert switch at the same time as the extract, you can keep the extract files for further processing.  The switch instructs Optim to perform the convert essentially at the same time as the extract so no private data is stored permanently on disk.

    Just another option you can consider based on your needs.

    --

    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






  • 6.  RE: password protected Optim extract File

    Posted Wed May 25, 2022 08:54 PM
    Hey Vishwas,
    We need extract files to perform comparison. we cant delete them.

    ------------------------------
    rajesh guttikonda
    ------------------------------



  • 7.  RE: password protected Optim extract File

    Posted Wed May 25, 2022 08:55 PM
    Hey Jimmy,

    We need extract file to perform comparison. we are not looking to convert the file. .

    ------------------------------
    rajesh guttikonda
    ------------------------------



  • 8.  RE: password protected Optim extract File

    Posted Thu May 26, 2022 01:07 AM

    Hi Rajesh,


    You can put security on folders where you store Extract and convert files and provide access only to service account to those folder which you had configured for Optim with service account. 

    Adopting this you can have layer of security over your extract and convert files. 



    ------------------------------
    Madhav A
    ------------------------------