InfoSphere Optim

 View Only
  • 1.  Optim data masking support for AWS DynamoDB

    Posted Thu August 12, 2021 03:13 PM
    I've learnt in the IBM Optim forums that IBM Infosphere Optim supports data masking  for MongoDB. I wonder if IBM Infosphere Optim data masking works with AWS DynamoDB.
    Please share any insight into this requirement.

    ------------------------------
    Krishna Emandi
    ------------------------------

    #InfoSphereOptim
    #Optim


  • 2.  RE: Optim data masking support for AWS DynamoDB

    Posted Tue August 17, 2021 11:39 AM
    Hi Krishna,

    Connecting Optim with MongoDB or AWS Databases is not something straight forward.

    You can use IBM Federation Server to create wrapper using the ODBC/JDBC drivers from Amazon DocumentDB/Dynamo.
    Optim treats this database via federation as DB2 database, which will allow Optim to extract the data.

    The process is similar to how you can connect Optim with DB2 iSeries.

    As an alternate solution, we have an IBM product called DPU (Data Privacy for Unstructured Data) which will help you to Mask NoSQL databases by using Optim ODPP. 



    ------------------------------
    Harshavardhan Peddireddy
    ------------------------------



  • 3.  RE: Optim data masking support for AWS DynamoDB

    Posted Wed September 27, 2023 04:22 AM

    Hey Krishna Emandi,

    I've been tinkering with data masking in various contexts, and while I haven't personally used IBM Infosphere Optim for AWS DynamoDB, I can offer some insights.

    Data masking is essential for protecting sensitive information in production and non-production environments. Now, when it comes to DynamoDB, it's a bit of a twist since it's a NoSQL database as opposed to MongoDB, which is a document-based NoSQL database. The masking techniques might vary due to differences in data models.

    Here's a suggestion: First, investigate if IBM Infosphere Optim officially supports DynamoDB. Check their documentation and release notes for any mention of DynamoDB compatibility. If it's not explicitly mentioned, you might need to consider alternative solutions or custom scripting.

    In my experience, when a tool doesn't have native support, you can write custom scripts using AWS Lambda functions and AWS Identity and Access Management (IAM) roles to apply data masking before data is written or read from DynamoDB. This gives you fine-grained control over data protection.

    However, remember that with great power comes great responsibility. Ensure you comply with all data privacy regulations and test thoroughly in non-production environments.



    ------------------------------
    Alex Ahsras
    ------------------------------