Synopsis
This operator reads a data set from an Access database.
Description
This operator reads a data set from a Microsoft Access database using the JDBC-ODBC-Bridge.
Input
Output
- output:
Parameters
- read not matching values as missings: Values which does not match to the specified value typed are considered as missings.
- data set meta data information: The meta data information
- attribute names already defined: the parameter describes whether the attribute names were set by the user manually or were generated by the the reader (generic names or first row of the file)
- 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 username for the Access database.
- password: The password for the Access database.
- jndi name: JNDI name for a data source.
- define query: Specifies whether the database query should be defined directly, through a file or implicitely by a given table name.
- query: An SQL query.
- query file: A file containing an SQL query.
- table name: The name of a single table within the Access database which should be read.
- database file: The mdb file containing the Access database which should be read from.