Skip to main content

Read Access

Synopsis​

This operator reads an ExampleSet from a Microsoft Access database.

Description​

The Read Access operator is used for reading an ExampleSet from the specified Microsoft Access database (.mdb or .accdb extension). You need to have at least basic understanding of databases, database connections and queries in order to use this operator properly. Go through the parameters and Example Process to understand the flow of this operator.

Input​

query file​

This port expects a text file with the SQL query. If this port is connected, the parameters in define query are ignored.

file​

The input file for this parameter (replaces the database file parameter, if used).

Output​

output​

This port delivers the result of the query on database in tabular form along with the meta data. This output is similar to the output of the Retrieve (Deprecated) operator.

Parameters​

username​

This parameter is used to specify the username of the database (if any).

password​

This parameter is used to specify the password of the database (if any).

define query​

Query is a statement that is used to select required data from the database. This parameter specifies whether the database query should be defined directly, through a file or implicitly by a given table name. The SQL query can be auto generated giving a table name, passed via a parameter or, in case of long SQL statements, in a separate file. The desired behavior can be chosen using the define query parameter. Please note that column names are often case sensitive and might need quoting.

query​

This parameter is only available when the define query parameter is set to 'query'. This parameter is used to define the SQL query to select desired data from the specified database.

table name​

This parameter is only available when the define query parameter is set to 'table name'. This parameter is used to select the required table from the specified database.