• 3 replies
  • Latest Post - ‏2015-09-16T15:29:25Z by Sesha Mandla
1 Post

Pinned topic Optim Data Provider Privacy

‏2012-11-02T11:09:00Z |
Dear Expert,

In fact, I'm trying to write a C or C++ application to do data masking. I came accorss Optim Data Provider Privacy. From my understanding, ODPP is a set of binary API which can be called from other applications through its API.

My question is:
+ is ODPP standalone product which means it can be installed without any other Optim product ?
+ if it is not, what should be installed with it ?
+ where can I download it ? partnumber maybe.

many thanks for your help.
Updated on 2012-11-05T06:52:47Z at 2012-11-05T06:52:47Z by SystemAdmin
  • SystemAdmin
    304 Posts

    Re: Optim Data Provider Privacy


    ODPP does not require any other Optim product to be installed to work. ODPProvider.majorver.minorver is the core library that you need to link your application to and except the ODPP libraries you only need the platform specific development environment (e.g. Visual Studio 2008 for windows). Platforms and the compilers are listed in the developer guide available with ODPP.

    Regarding download I need to check on the public download location and will update you on that shortly.

    if you have any questions/queries about ODPP or Data Masking in general feel free to send them to us.

  • Edward.D.
    3 Posts

    Re: Optim Data Provider Privacy


    We recently installed ODPP UDF for SQL server. This is where our optim directory database resides. We are running on Optim 11.3.

    These were the install steps:

    1)            Downloaded Optim-DPP-

    2)            Followed the steps in this link:!/SSMLQ4_11.3.0/

                    Build number is 5102

    3)            There was a missing folder (win_udf_mss) in images64

    Downloaded FP03 - Optim-DPP-11.3.0_20150129-BUILD5531

    In this file, folder Bld5531 is empty, so we kept previous Bld5102 with the same files that were in the first install Replaced contents of Images64 folder in C:\IBM\InfoSphere\Optim\DP\

    4)            Rebooted server

    5)            Install commands did not display error but test command did not work.


    When we try to run the Test sql, we are getting this error. It appears for all UDFs that we tested. What could be the root cause for this?


    -- OptimMaskDate
    print ('OptimMaskDate');
    select [dbo].[OptimMaskDate]('2001-01-01', N'pro=age,year=+1,mon=-2,week=+3,day=-4,flddef1=(name=col1,dt=date)');


    -- OptimMaskDouble
    print ('OptimMaskDouble');
    select [dbo].[OptimMaskDouble](12345.67890, N'pro=aff,mtd=repeatable,flddef1=(name=col1,dt=double)');




    Msg 6522, Level 16, State 2, Server XXXXXXXXXXXXXXXXXX, Line 3

    A .NET Framework error occurred during execution of user-defined routine or aggr

    egate "OptimMaskDate":



       at IBM.InfoSphere.ODPP.OptimMask.OptimMaskDate(Nullable`1 argument, String pr




    Msg 6522, Level 16, State 2, Server XXXXXXXXXXXXXXXXXXXXXXXX, Line 4

    A .NET Framework error occurred during execution of user-defined routine or aggr

    egate "OptimMaskDouble":



       at IBM.InfoSphere.ODPP.OptimMask.OptimMaskDouble(Nullable`1 argument, String


    Updated on 2015-09-11T06:56:03Z at 2015-09-11T06:56:03Z by Edward.D.
  • Sesha Mandla
    Sesha Mandla
    4 Posts

    Re: Optim Data Provider Privacy


    Have you configured and registered the  UDF's for the SQL Serer ? If yes, Can you run the below SQL command 

    Use the IOQMSSQLUDFTest.sql script to validate the Optim™ data privacy user-defined function (UDF) installation and configuration.
    From a command window, change directory to the scripts directory where you installed the UDF software.
    Enter the following command:
    sqlcmd -E -S ServerName\InstanceName -d DatabaseName -I -i IOQMSSQLUDFTest.sql