The Data Prep Studio Node
The Data Prep Studio Node is a desktop virtualization plugin for SmartWorks Analytics that allows remote access to a desktop installation of Data Prep Studio.
While the example described in this help page refers specifically to CSV files, Data Prep Studio can work with multiple file types, such as Microsoft Excel, PDF, HTML, report files, and various databases. If you wish to work with any of the files you have uploaded to the SmartWorks Analytics Library in Data Prep Studio, you may do so by following the steps outlined below. However, only exports from Data Prep Studio to delimited text (e.g., CSV) files can be used in SmartWorks Analytics workflows.
An Execution Profile with an active session linked to the workflow
From the Connect group of the Nodes tab, drag and drop the Data Prep Studio Plugin node to the Workflow Canvas.
Configure the Data Prep Studio node by double-clicking on the node or using the Open option provided in the node menu.
In the Configuration page, specify a username and password to login to Data Prep Studio. Tick the Save user credentials box to avoid being asked for the same credentials in a later session. Click Login to start the remote Data Prep Studio session.
For ease of use, you can view and work on the Data Prep Studio plugin in full-screen mode by expanding the Session Configuration window, right-clicking on the Go fullscreen link at the left-hand panel of the node configuration, and then selecting Open link in new tab or Open link in new window.
CSV files may be imported from the SmartWorks Analytics library to Data Prep Studio for data prep operations. Click Open Data > PDF & Text > Get Data.
Files uploaded to the SmartWorks Analytics library are available in Altair Library (D:).
When you have completed your data prep operations, export the table back to the Altair Library D: drive.
The plugin displays in full-screen mode in another tab or window, and the screen from which the plugin node was launched is updated as follows.
Refreshing the original browser tab returns the node to this tab.
In the file explorer that displays, go to the Altair Library (D:) and then select and open the file to import.
The CSV file is imported to Data Prep Studio and can be prepped as usual.
When the export operation has been completed, the exported file is added to the SmartWorks Analytics library and can be used in workflows.