SAP PowerDesigner
Create a resource based on the SAP PowerDesigner resource type to extract metadata from an SAP PowerDesigner data source. You need to specify the connection details when you configure the resource.
Objects Extracted
Enterprise Data Catalog extracts metadata from the following objects in an SAP PowerDesigner data source:
- •*Table
- •*View
- •Procedure
- •Sequence
- •User
- •Association
- •*Synonym
- •Business rule
- •Dimension
- •Fact
- •Physical data model
- •Physical diagram
- •Multidimensional diagram
Note: * indicates the objects for which the resource extracts lineage information.
Resource Connection Properties
The following table describes the resource connection properties:
Property | Description |
|---|
Agent URL | URL to the Enterprise Data Catalog agent that runs on a Microsoft Windows Server. |
SAP PowerDesigner Model Type | The PowerDesigner version used to create the Physical Data Modeling (PDM) files. |
Remove Binary Characters | Removes binary characters from the PDM file before the file is parsed. |
Import UDPs | The resource does not support this option in the current version of Enterprise Data Catalog. |
Append Volumetric Information | Imports the value for the number of occurrences of an object and append the information to the description property of an object. |
Remove RTF | Removes Rich Text Formatting (RTF) from annotations. |
Reverse Role Names | Reverses the role names for each relationship in the model. |
Auto Assign Connections | Automatically assigns connections to the resource. |
File | Select the PDM file that includes the data model from where you want to import metadata. |
The following table describes the Additional and Advanced properties for source metadata settings on the Metadata Load Settings tab:
Property | Description |
|---|
Enable Source Metadata | Extracts metadata from the data source. |
Memory | The memory required to run a scanner job. Specify one of the following memory values: Note: For more information about the memory values, see the Tuning Enterprise Data Catalog Performance article on How To-Library Articles tab in the Informatica Doc Portal |
JVM Options | JVM parameters that you can set to configure scanner container. Use the following arguments to configure the parameters: - - Dscannerloglevel=<DEBUG/INFO/ERROR>. Changes the log level of scanner to specific values, such as DEBUG, ERROR, or INFO. Default value is INFO.
- - Dscanner.container.core=<No. of core>. Increases the core for the scanner container. The value must be a number.
- - Dscanner.yarn.app.environment=<key=value>. Key pair value that you need to set in the Yarn environment. Use a comma to separate multiple key-pair values.
- - Dscanner.pmem.enabled.container.memory.jvm.memory.ratio=<1.0/2.0>. Increases the scanner container memory when pmem is enabled. Default value is 1.
- - -DINFA_TRUSTSTORE=<trust store path>. Path to the Informatica truststore file.
- - -DINFA_TRUSTSTORE_PASSWORD=<trust store encrypted key>. Encrypted truststore password.
|
Track Data Source Changes | View metadata source change notifications in Enterprise Data Catalog. |