Importing and exporting data using R

Using the Custom Dialog Builder for Extensions, you can create custom nodes and write R scripts to read data from wherever your data source is, and write data out to any data format supported by R.

For example, a user wants to write her data to a database. She uses the Custom Dialog Builder for Extensions and R scripting to create a custom export JDBC node and then runs the model to write data into a database. To read data from the database, she can also create a custom import JDBC node. She could also use this same method to read data into SPSS® Modeler from a JSON file, for example. Then, after reading his data into SPSS Modeler, he can use all available SPSS Modeler nodes to work on his business problem.

To import/export data using R

1. Go to Extensions > Custom Node Dialog Builder.
2. Under Dialog Properties, select R for the Script Type and select Import or Export for the Node Type.
3. Enter other properties as desired, such as a Dialog Name.
4. In the Script section, type or paste your R script for importing or exporting data.
5. Click Install to install the R script. New custom import nodes will be added to the Sources palette, and new custom export nodes will be added to the Export palette.