Course Overview
This three-day, instructor-led course on OpenText™ Structured Data Manager (SDM) Administration is designed to equip learners with the skills required to handle both basic and advanced functionalities of SDM.
You will engage in hands-on activities that cover in-place masking, synthetic data generation, application retirement, and archive planning and deployment across various scenarios. The course structure includes a blend of lectures and practical labs to ensure a thorough understanding of the material.
Throughout the course, you will gain insights into the fundamentals, architecture, and solution types of SDM – specifically, architecture and archive solution types. You will identify the prerequisites for SDM installation, install SDM, apply data modeling techniques, use parameters and cartridges, and configure business flows. You will manage repositories and deployment environments, and you will explore various deployment options, providing yourself with a well-rounded skillset to effectively utilize SDM in real-world applications.
Highlights
- Provide an overview of SDM
- Install and configure SDM
- Work with the SDM Designer
- Work on the archival of inactive data
- Use Test Data Management
Who should attend
This course is intended for:
- Information Security Administrators
- Database Administrators
- Information Security Consultants
- Data Privacy Manager
Prerequisites
To be successful in this course, you should have the following prerequisites or knowledge:
- Basic knowledge of the system and network
- Core concepts of database
- System services
Course Objectives
On completion of this course, participants should be able to:
- Understand the fundamentals, architecture, and solution types of SDM.
- Identify the prerequisites for installing SDM.
- Navigate and use the Web Console.
- Work with the SDM Designer.
- Install and use the SDM Discovery.
- Perform sensitive and personal data discovery, use the discovery dashboard, and scan for sensitive data.
- Apply data modeling techniques, use parameters and cartridges, and configure business flows.
- Manage repositories, deployment environments, and explore various deployment options.
- Archive inactive data.
- Implement in-place masking.
- Configure and use the data access cartridge.
Course Content
Chapter 01: Course overview
- Identify the contents and objectives of the course
- Define the class logistics
- Discuss the lab environment details
Chapter 02: Introduction to SDM
- Explain SDM
- Outline different types of archives
- Discuss various archive solutions
- Describe SDM use cases
Chapter 03: Install and configure SDM
- Install SDM
- Install Web Console service
- Install a repository
- Verify the SDM installation
- Access the Web Console
Chapter 04: Web Console
- Describe the Web Console
- Create an environment
- Run business flows
- Configure Web Console settings
- Create users and groups
Chapter 05: Discover personal/sensitive data
- Describe personal/sensitive data
- Install Discovery
- Discover personal/sensitive data
Chapter 06: Models, parameters, cartridges, and business flows
- Describe the Designer
- Create a project
- Create a model
- Add tables to a model
- Create a cartridge
- Create a business flow
- Deploy a cartridge/business flow
Chapter 07: Generate synthetic data
- Describe synthetic data
- Generate synthetic data
Chapter 08: Integration of SDM with SecureData
- Integrate SDM with SecureData
- View Mask data
Chapter 09: Archival of inactive data
- Archive database-to-file
- Archive database-to-database
- Archive database-to-file-to-database
Chapter 10: In-Place masking
- Describe In-Place masking
- Mask sensitive/personal data
Chapter 11: Application retirement
- Describe application retirement
- Create data access rules
- Create a data access cartridge
Chapter 12: Test Data Management
- Describe TDM
- Install TDM
- Generate synthetic test data
- Run a business flow from TDM