Interactive Data Preparation Service Overview
The Interactive Data Preparation Service is an application service that manages data preparation within the Enterprise Data Preparation application.
When an analyst prepares data in a project, the Interactive Data Preparation Service connects to the Data Preparation repository to store worksheet metadata. The service connects to the Hadoop cluster to read sample data or all data from the Hive table, depending on the size of the data. The service connects to the HDFS system in the Hadoop cluster to store the sample data being prepared in the worksheet.
The Interactive Data Preparation Service uses an Oracle database, a MySQL database, or a MariaDB database for the data preparation repository. You must configure a local storage location for data preparation file storage on the node on which the service runs.
You can create the Interactive Data Preparation Service when you install Enterprise Data Preparation, or you can use the Administrator tool to create the service after installation. Create the Interactive Data Preparation Service before you create the Enterprise Data Preparation Service. When you create the Enterprise Data Preparation Service, you must associate it with a Interactive Data Preparation Service.