Synopsis
This operator simply performs an arbitrary SQL statement.
Description
This operator performs an arbitrary SQL statement on an SQL database. The SQL query can be passed to RapidMiner via a parameter or, in case of long SQL statements, in a separate file. Please note that column names are often case sensitive. Databases may behave differently here.
Please note that this operator cannot be used to load data from databases but mereley to execute SQL statements like CREATE or ADD etc. In oder to load data from a database, the operators DatabaseExampleSource or CachedDatabaseExampleSource can be used.
Input
- through 1:
Output
- through 1:
Parameters
- define connection: Indicates how the database connection should be specified.
- connection: A predefined database connection.
- database system: The used database system.
- database url: The URL connection string for the database, e.g. 'jdbc:mysql://foo.bar:portnr/database'
- username: The database username.
- password: The password for the database.
- jndi name: JNDI name for a data source.
- query: SQL query. If not set, the query is read from the file specified by 'query_file'.
- query file: File containing the query. Only evaluated if 'query' is not set.