Informatica Power Center
Learn how to configure and set up Informatica Power Center as a metadata source for Cloudera Data Lineage (formerly Octopai).
Tool Permissions Prerequisites
- Open Server Port for each Informatica repository database.
- Existing/New (Oracle/SQL) user for each database with granted read permission for the
following dictionary tables:
- OPB_SESS_EXTNS
- OPB_MMD_SESS_EXTNS
- OPB_SESS_CNX_REFS
- OPB_CNX_ATTR
- OPB_CNX
- OPB_MMD_CNX
- OPB_EXPRESSION
- OPB_EXTN_ATTR
- OPB_MAPPING
- OPB_OBJECT_TYPE
- OPB_SWIDGET_ATTR
- OPB_SWIDGET_INST
- OPB_TABLE_GROUP
- OPB_TASK
- OPB_TASK_ATTR
- OPB_TASK_INST
- OPB_TASK_VAL_LIST
- OPB_WIDGET
- OPB_WIDGET_INST
- REP_ALL_MAPPINGS
- REP_ALL_MAPPLETS
- REP_ALL_SOURCE_FLDS
- REP_ALL_SOURCES
- REP_ALL_TARGET_FLDS
- REP_ALL_TARGETS
- REP_ALL_TASKS
- REP_COMPONENT
- REP_METADATA_EXTNS
- REP_SESS_WIDGET_CNXS
- REP_SUBJECT
- REP_TASK_ATTR
- REP_TASK_INST
- REP_WIDGET_ATTR
- REP_WIDGET_DEP
- REP_WIDGET_FIELD
- REP_WIDGET_INST
- REP_WORKFLOWS
If you would like to build a loop for this action, we offer to use this guide by Aron Kumar.
Setting up Informatica Metadata Source
Metadata Sources are set on the Octopai Client.
SQL Server:
Oracle:
Verify extraction results
After a successful run, confirm the metadata archive in the target folder. See Verify extracted metadata files.
Troubleshoot
If an error occurs during the extraction, see Troubleshoot connector extraction failures.
