Application Service Guide > Interactive Data Preparation Service > Creating and Managing the Interactive Data Preparation Service
  

Creating and Managing the Interactive Data Preparation Service

Use the Administrator tool to create and manage the Interactive Data Preparation Service. When you change a service property, you must recycle the service or disable and then enable the service for the changes to take affect.

Create the Interactive Data Preparation Service

If you did not create the Interactive Data Preparation Service service during the console, or if you ran the silent installer, create the service through the Administrator tool.
Before you create the Interactive Data Preparation Service, verify that you have created and enabled the following services:
    1. In the Administrator tool, click the Managetab.
    2. Click the Services and Nodes view.
    3. In the Domain Navigator, select the domain.
    4. Click Actions > New > Interactive Data Preparation Service.
    5. Enter the following properties:
    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 Interactive Data Preparation Service. The description cannot exceed 765 characters.
    Location
    Location of the Interactive Data Preparation Service in the Informatica domain. You can create the service within a folder in the domain.
    License
    License object with the data lake option that allows the use of the Interactive Data Preparation Service.
    Node Assignment
    Type of node in the Informatica domain on which the Interactive 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.
    Select the Grid option to ensure horizontal scalability by using a grid with multiple Interactive Data Preparation Service nodes. 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.
    Default is Single Node.
    Node
    Name of the node on which the Interactive Data Preparation Service runs.
    6. Click Next.
    7. Enter the following Data Preparation repository properties:
    Property
    Description
    Database Type
    Type of database to use for the Data Preparation repository.
    Database User Name
    Database user account to use to connect to the database.
    Database User Password
    Password for the database user account.
    Host Name
    Host name of the database machine.
    Port Number
    Port number for the database.
    Schema Name
    Schema or database name of the Data Preparation repository database.
    Connection String
    Connection string used to connect to the database.
    To connect to an Oracle database, format the string as follows:
    jdbc:informatica:oracle://<database host name>:<port>;ServiceName=<service name>
    To connect to a non-secure MySQL or MariaDB 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 MySQL or MariaDB database, format the string as follows:
    verifyServerCertificate=true&useSSL=true&requireSSL=true
    Secure JDBC Parameters
    Secure JDBC parameters required to access a secure database.
    To connect to a secure Oracle database, format the string as follows:
    EncryptionMethod=SSL;HostNameInCertificate=<secure database host name>;ValidateServerCertificate=true
    To connect to as secure MySQL or MariaDB database, format the string as follows:
    trustCertificateKeyStoreUrl=file://<truststore path/truststore file name>&trustCertificatekeyStorePassword=<truststore password>
    8. Click Next.
    9. Enter the following storage properties:
    Property
    Description
    Local Storage Location
    Directory for data preparation file storage on the node where the service runs.
    Durable Storage Type
    Storage type for the data preparation file.
    Durable Storage Connection
    Connection for the data preparation file storage.
    Durable Storage Location
    Location for the data preparation file storage. If the connection to the local storage fails, the service recovers data preparation files from the 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.
    Hadoop Authentication Mode
    Security mode enabled for 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.
    10. Click Next.
    11. Enter the logging properties.
    12. If you plan to use rules, you must associate the Interactive Data Preparation Service with the Model Repository Service that manages the Model repository that contains the rule objects and metadata. You must also associate a Data Integration Service that runs rules during data preparation with the Interactive Data Preparation Service.
    Enter the following properties required to enable rules:
    Property
    Description
    Enable Rule Execution
    Enables the execution of the validation rule objects.
    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.
    Data Integration Service Name
    Name of the Data Integration Service.
    13. Click Next.
    14. Enter the following HTTP configuration properties:
    Property
    Description
    HTTP Port
    Port number for the HTTP connection to the Interactive Data Preparation Service.
    Enable Secure Communication
    Use a secure connection to connect to the Interactive Data Preparation Service. If you enable secure communication, you must set all required HTTPS properties, including the keystore and truststore properties.
    HTTPS Port
    Port number for the HTTPS connection to the Interactive Data Preparation Service.
    Keystore File
    Path and the file name of keystore file that contains key and certificates required for HTTPS communication.
    Keystore Password
    Password for the keystore file.
    Truststore File
    Path and the file name of truststore file that contains authentication certificates for the HTTPS connection.
    Truststore Password
    Password for the truststore file.
    15. Click Next.
    16. Enter the following rules execution property:
    Property
    Description
    Rules Server Port
    Port used by the rules server managed by the Interactive Data Preparation Service. Set the value to an available port on the node where the service runs.
    17. Click Finish.
    18. Select the Interactive Data Preparation Service in the Domain Navigator, and then select Actions > Create Repository to create the repository contents.
    19. Select Actions > Enable Service to enable the Interactive Data Preparation Service.

Enabling, Disabling, and Recycling the Interactive Data Preparation Service

You can enable, disable, and recycle the service from the Administrator tool.
    1. In the Administrator tool, click the Manage tab > Services and Nodes view.
    2. In the Domain Navigator, select the service.
    3. On the Actions tab, select one of the following options:
    1. a. Enable Service to enable the service.
    2. b. Disable Service to disable the service.
      3. Choose the mode to disable the service in. Optionally, you can choose to specify whether the action was planned or unplanned, and enter comments about the action. If you complete these options, the information appears in the Events and Command History panels in the Domain view on the Manage tab.
    3. c. Recycle Service to recycle the service.

Editing the Interactive Data Preparation Service

To edit the Interactive Data Preparation Service, 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 Interactive Data Preparation Service:
    1. To edit specific properties, click the pencil icon in the selected properties area.
    2. In the Edit Properties window, edit the required fields.
    3. Click OK.
    4. Click Actions > Recycle Service.
    5. In the Recycle Service window, select the required options.
    6. Click OK to restart the service.

Deleting the Interactive Data Preparation Service

Only users with ADMIN or WRITE permissions for the Interactive Data Preparation Service can delete the service.
To delete the Interactive Data Preparation Service:
    1. On the Manage tab, select the Services and Nodes view.
    2. In the Domain Navigator, select the Interactive Data Preparation Service.
    3. Disable the Interactive Data Preparation Service by clicking Actions > Disable Service .
    4. To delete the Interactive Data Preparation Service, click Actions > Delete.