Enterprise Data Catalog Scanner Configuration Guide > Configuring Data Integration Resources > Database Scripts
  

Database Scripts

Create a Database Scripts resource to extract lineage information from database scripts.

Resource Connection Properties

The General tab includes the following properties:
Property
Description
Script Type
Specify the database script type to extract lineage information. Select one of the following database script types from the drop-down list:
  • - Oracle PL/SQL
  • - Teradata
  • - Apache HiveQL
  • - IBM DB2
File
Zip file that includes database scripts. The zip file can contain database scripts in file formats, such as .txt, .bteq, .sql, and .plsql. Ensure that the files in the .zip file are not stored in a directory within the .zip file. If the zip file is case sensitive, you must enclose the schema, table, and column name within double quotes.
Miscellaneous Options
Specify the miscellaneous options identified with a hyphen (-) followed by a letter and its value. For example, -d schema.
  • - -d. Provide a default schema. The letter -d allows to specify a schema name for the objects that do not have it defined explicitly.
The Metadata Load Settings tab includes the following properties:
Property
Description
Enable Source Metadata
Select to extract metadata from the data source.
Auto Assign Connections
Indicates that the connections are automatically assigned.
Memory
Specifies the memory required to run the scanner job. Select one of the following values based on the data set size imported:
  • - Low
  • - Medium
  • - High
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 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 should 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 the key pair value.
  • - -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.
Note: The Database Scripts resource type is available for technical preview. Technical preview functionality is supported but is unwarranted and is not production-ready. Informatica recommends that you use these features in non-production environments only.