Script Types
If the correct trust is in place, you can run any of these script types in Spotfire.
- IronPython
IronPython scripts can access the capabilities available in the Spotfire Analyst API, and also other APIs provided by the operating system. These capabilities include running arbitrary commands; therefore, strict control must be employed to those users who are allowed to author and mark scripts as trusted in the library (such as members of the Script Author group). - JavaScript in Text Area
To customize parts of the application that cannot be done using sanitized HTML in the Spotfire text area, you can add snippets of JavaScript. - HTML in Text Area
A subset of HTML is allowed in the text area visualization. - Custom Queries
A normal query (not custom) issued by a Spotfire data connection can use only allowed constructs (for example SELECT column FROM table) in a way that is tightly controlled by the Spotfire connector. A data connection with a custom query does not limit the types of language constructs that are allowed, and enables use of any language construct (for example INSERT, UPDATE, CREATE), as well as other functions specific to the data source. - TERR Data Functions
Spotfire® Enterprise Runtime for R (a/k/a TERR™) is an implementation of the R programming language that provides restricted and unrestricted execution environments. TERR data functions running in unrestricted mode have access to the operating system and can run arbitrary commands. - R Data Functions
The R programming language provides execution environments for running R scripts in an R engine that you have installed on a node manager. R data functions have access to the operating system and can run arbitrary commands. - Python Data Functions
The Spotfire Service for Python provides execution environments for running Python scripts in a Python interpreter installed on the node manager. Python data functions can have access to the operating system and can run arbitrary commands.
- IronPython
IronPython scripts can access the capabilities available in the Spotfire Analyst API, and also other APIs provided by the operating system. These capabilities include running arbitrary commands; therefore, strict control must be employed to those users who are allowed to author and mark scripts as trusted in the library (such as members of the Script Author group). - JavaScript in Text Area
To customize parts of the application that cannot be done using sanitized HTML in the Spotfire text area, you can add snippets of JavaScript. - HTML in Text Area
A subset of HTML is allowed in the text area visualization. - Custom Queries
A normal query (not custom) issued by a Spotfire data connection can use only allowed constructs (for example SELECT column FROM table) in a way that is tightly controlled by the Spotfire connector. A data connection with a custom query does not limit the types of language constructs that are allowed, and enables use of any language construct (for example INSERT, UPDATE, CREATE), as well as other functions specific to the data source. - TERR Data Functions
Spotfire® Enterprise Runtime for R (a/k/a TERR™) is an implementation of the R programming language that provides restricted and unrestricted execution environments. TERR data functions running in unrestricted mode have access to the operating system and can run arbitrary commands. - R Data Functions
The R programming language provides execution environments for running R scripts in an R engine that you have installed on a node manager. R data functions have access to the operating system and can run arbitrary commands. - Python Data Functions
The Spotfire Service for Python provides execution environments for running Python scripts in a Python interpreter installed on the node manager. Python data functions can have access to the operating system and can run arbitrary commands.
Parent topic: Scripts in Spotfire
Related concepts