Application Service Guide > Interactive Data Preparation Service > Interactive Data Preparation Service Properties
  

Interactive Data Preparation Service Properties

To view the Interactive 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 Interactive Data Preparation Service properties:

General Properties

General properties for the Interactive 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 Interactive 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 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 service runs.
Grid
If you selected Grid for node assignment, select the grid that you want to use for the Interactive Data Preparation Service.
A grid ensures horizontal scalability. Improved scalability supports high performance, interactive data preparation during increased data volumes and number of users. Each user is assigned a node in the grid using round-robin method to distribute the load across the nodes.

Model Repository Options and Data Integration Service Options

To edit the model repository options, click the pencil icon in the Model Repository Options area. In the Edit Model Repository Options window, edit the required fields.
The following table describes the model repository options:
Property
Description
Model Repository Service Name
Name of the Model Repository 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: ` ~ % ^ * + = { } \ ; : ' " / ? . , < > | ! ( ) ] [You cannot change the name of the service after you create it.
Model Repository Service User Name
User name to access the Model Repository Service.
Model Repository Service Password
Password to access the Model Repository Service.
Security Domain
Select the security domain to access the Model Repository Service.
To edit the Data Integration Service options, click the pencil icon in the Data Integration Service Options area. In the Edit Data Integration Service Options window, edit the required fields.
The following table describes the Data Integration Service options:
Property
Description
Data Integration Service Name
Name of the Data Integration Service.

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.

Oracle

  1. 1. To use an Oracle database for the Data Preparation repository, select Oracle as the database type.
  2. 2. Enter the connection properties for the database.
    3. The following table describes the connection properties:
    Property
    Description
    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.
    Connection String
    JDBC connection string to connect to the database. Format the string as follows:
    jdbc:informatica:oracle://<database host name>:<port>;ServiceName=<service name>
    Secure JDBC Parameters
    List of secure database parameters to connect to the database. Format the parameters as follows:
    EncryptionMethod=SSL;HostNameInCertificate=<secure database host name>;ValidateServerCertificate=true

MySQL

  1. 1. To use a MySQL database or a MariaDB database for the Data Preparation repository, select MySQL as the Database Type.
  2. 2. Enter the connection properties for the database.
    3. The following table describes the connection properties:
    Property
    Description
    Database User Name
    Database user account to use to connect to the database.
    Database User Password
    Password for the Data Preparation repository database user account.
    Database Host Name
    Host name of the machine that hosts the database.
    Database Port Number
    Port number for the database.
    Schema Name
    Schema or database name of the Data Preparation repository database.
    Connection String
    Connection string to connect to the database.
    To connect to a non-secure database, format the string as follows:
    jdbc:mysql://<database host name>:<port>
    The connection string is optional if you connect to a non-secure database.
    To connect to an SSL-enabled database, format the string as follows:
    verifyServerCertificate=true&useSSL=true&requireSSL=true
    Secure JDBC Parameters
    String containing the path and file name for the database truststore file, and the truststore password. Format the string as follows:
    trustCertificateKeyStoreUrl=file://<truststore path/truststore file name>&trustCertificatekeyStorePassword=<truststore password>

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 where the 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 service recovers data preparation files from the HDFS location.
If the Hadoop cluster uses Kerberos authentication, the impersonation user name must have read, write and execute permission on the HDFS storage location directory. The default location is: /datalake/dps_durable_storage.

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.
Hadoop Impersonation User Name
User name for the user account to impersonate when connecting to the Hadoop cluster. Use the Administrator tool to view Hadoop connection properties.
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 Interactive Data Preparation Service runs.

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.