Intelligent Data Lake Administrator Guide > Data Preparation Service > Data Preparation Service Properties
  

Data Preparation Service Properties

To view the Data Preparation Service properties, select the service in the Domain Navigator and click the Properties View. You can edit the properties by clicking the pencil icon in the respective area, while the service is running, but you must restart the service for the properties to take effect. You can configure the following Data Preparation Service properties:

General Properties

General properties for the Data Preparation Service include the name, description, and the node in the Informatica domain that the service runs on.
To edit the general properties, click the pencil icon in the General Properties area. In the Edit General Properties window, edit the required fields.
The following table describes the general properties for the service:
Property
Description
Name
Name of the Data Preparation Service. The name is not case sensitive and must be unique within the domain. It cannot exceed 128 characters or begin with @. It also cannot contain spaces or the following special characters: ` ~ % ^ * + = { } \ ; : ' " / ? . , < > | ! ( ) ] [
Description
Description of the service. The description cannot exceed 765 characters.
License
License object with the data lake option that allows use of the service.
Node Assignment
Type of node in the Informatica domain on which the Data Preparation Service runs. Select Single Node if a single service process runs on the node or Primary and Backup Nodes if a service process is enabled on each node for high availability. However, only a single process runs at any given time, and the other processes maintain standby status.
The Primary and Backup Nodes option will be available for selection based on the license configuration.
Default is Single Node.
Node
Name of the node on which the Data Preparation Service runs.

Data Preparation Repository Options

To edit the data preparation repository options, click the pencil icon in the Data Preparation Repository Options area. In the Edit Data Preparation Repository Options window, edit the required fields.
The following table describes the data preparation repository options:
Property
Description
Database Type
Type of database to use for the Data Preparation repository.
Host Name
Host name of the machine that hosts the Data Preparation repository database.
Database Port Number
Port number for the database.
Database User Name
Database user account to use to connect to the Data Preparation repository.
Database User Password
Password for the Data Preparation repository database user account.
Modify Database User Password
Select this checkbox to modify the database user password.
Schema Name
Schema or database name of the Data Preparation repository database.

Data Preparation Storage Options

Data preparation storage options enables you to specify the local storage and HDFS location for data persistence.
To edit the data preparation storage options, click the pencil icon in the Data Preparation Storage Options area. In the Edit Data Preparation Storage Options window, edit the required fields.
The following table describes the data preparation storage options:
Property
Description
Local Storage Location
Directory for data preparation file storage on the node on which the Data Preparation Service runs.
HDFS Connection
HDFS connection for data preparation file storage.
HDFS Storage Location
HDFS location for data preparation file storage. If the connection to the local storage fails, the Data Preparation Service recovers data preparation files from the HDFS location.

Hive Security Options

You can specify the Hive security options for the Hadoop cluster.
To edit the Hive security options, click the pencil icon in the Hive Security Options area. In the Edit Hive Security Options window, edit the required fields.
The following table describes the Hive security options:
Property
Description
Hadoop Authentication Mode
Security mode of the Hadoop cluster for data preparation storage. If the Hadoop cluster uses Kerberos authentication, you must set the required Hadoop security properties for the cluster.
HDFS Principal Service Name
Service Principal Name (SPN) for the data preparation Hadoop cluster. Specify the service principal name in the following format: user/_HOST@REALM.
Hadoop Impersonation User Name
User name for the user account to impersonate when connecting to the data preparation Hadoop cluster.
SPN Keytab File for User Impersonation
Path and file name of the SPN keytab file for the impersonation user account. The keytab file must be in a directory on the machine where the Data Preparation Service runs.

Hadoop Options

You can specify the Hadoop distribution for the data preparation storage.
To edit the Hadoop options, click the pencil icon in the Hadoop Options area. In the Edit Hadoop Options window, edit the required fields.
The following table describes the Hadoop options:
Property
Description
Hadoop Distribution
Hadoop distribution of the Hadoop cluster for data preparation storage. Select Cloudera or HortonWorks.

Custom Properties

Configure custom properties that are unique to specific environments. You might need to apply custom properties in special cases.
When you define a custom property, enter the property name and an initial value. Define custom properties only at the request of Informatica Global Customer Support.
To view the custom properties, select the service in the Domain Navigator and click the Properties view. You can change the properties while the service is running, but you must restart the service for the properties to take effect.
To edit the custom properties, click the pencil icon in the Custom Properties area. In the Edit Custom Properties window, edit the required fields.