Optim Designer user reference

Use IBM® InfoSphere® Optim™ Designer to define data models, data masking policies, and data management services. You can define objects in Optim Designer and share them 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.


Feedback