Use IBM® InfoSphere® Optim™ Designer
to define data models, data masking policies, data management services,
and data stores. You can define objects in Optim Designer and share them in an Optim directory. Use the Directory
Explorer to view and manage objects in an Optim directory.
- Data management services
- Use a data management service to extract, convert, load, or insert
data. A service uses access definitions to define the data to extract.
A service also uses table maps and column maps to map source and target
data. You can also transform process requests in an Optim Directory into data management services.
Use Optim Manager in embedded
mode to test services.
- Data masking
- You can mask data processed by a data management service. Use
data masking to transform data such as national ID numbers, credit
card numbers, dates, numeric values, and personal information. Use
a column map to enter a data masking function or create a column map
procedure with a LUA script.
- Access definitions
- Use an access definition to define data models and subsets of
data in matching or different schemas. An access definition identifies
selection criteria and relationships used in a data management service.
You can define relationships outside of a DBMS and use SQL to define
selection criteria.
- Optim Manager
- You can open Optim Manager
from Optim Designer (embedded
mode), allowing you to test data management services.