Print Friendly and PDF

Dynamic Data Masking

onDemand | Data Security | Self-Paced | Version 9.9.2

Course Overview

Gain the skills to implement dynamic data masking techniques, define custom masking rules to handle complex data masking requirements, and protect a relational system. Learn administrative tasks such as JDBC client configuration with DDM, LDAP authentication for DDM, creating Custom Loggers, writing logs to the database tables, and generating Reports. This course is applicable for version 9.9.2.

Objectives

After successfully completing this course, students should be able to:

  • Setup Dynamic Data Masking
  • Define connection rules and security rule sets
  • Define dynamic data masking functions
  • Manage Rules
  • Setup MySQL JDBC client configuration with DDM
  • Setup LDAP authentication for DDM
  • Use Log Loader and write logs to the database tables
  • Create Custom Loggers to write the rule log information
  • Generate Reports for the logs written to database

Target Audience

  • Developer
  • Administrator

Prerequisites

  • None
Agenda
Module 1: Introduction to Dynamic Data Masking
  • Dynamic Data Masking Overview
  • Dynamic Data Masking Methodology
  • Architecture and its Components
  • Rules Overview
  • DDM Integration with Informatica Products
  • Lab: Getting started with DDM
Module 2: Connection and Security Rules
  • Connection Rules
  • Security Rules
  • Manage Rules
  • Security Rule Set Simulator
  • Basic steps to configure Dynamic Data Masking
  • Server Control Command Line Program
  • Basic Troubleshooting of Dynamic Data Masking
  • Lab: Deny database access within a time frame
  • Lab: Protect CUSTOMER and CUSTOMER_SERVICE tables
  • Lab: Disable, export, and delete rules
  • Lab: Replace an incoming SQL Query
  • Lab: Edit an incoming SQL Query
  • Lab: Define Data Access to a User
  • Lab: Restrict Data Access to a User Using Java Matcher
  • Lab: Identify Specific SQL Statements
  • Lab: Alter the Database Request Using Replace Table Action
 
Module 3: DDM Administration
  • JDBC Client Configuration
  • LDAP Authentication for DDM
  • Log Loaders
  • Custom Loggers
  • DDM Reports
  • Lab: Configure MySQL JDBC Database with DDM
  • Lab: Setup LDAP Authentication for DDM and Restrict User Access
  • Lab: Create a Custom Logger
  • Lab: Use LogLoaders and Log the data into Database
  • Lab: Generate Reports
Enroll Now

Back to Course Overview

Power User Axon for Community Users (Instructor Led or onDemand) Axon Content Curation (Instructor Led) Axon for Power Users (Instructor Led) Axon Data Governance (Professional Certification) Axon Data Governance (Professional Certification) Axon Data Governance (Professional Certification) Some more content to make this bigger asdf asdf asdf

Informatica offers programs to extend learning in convenient and economic packages. Programs include self-paced subscriptions as well as bundled instructor led training and certifications. Each program is curated around a specific skillset to enable customer success.

365University Data Governance Annual Subscription

Informatica MasterPass Education Subscription

Informatica Learning Library

Data Governance & Privacy Journey Master

View Full Course Offerings