Filters¶

After defining the path to a resource, it is possible to establish filters that will be executed before processing the file.

The available filters are:

• UNZIP: decompress a ZIP compressed file.

• GUNZIP: decompress a GZIP compressed file.

• DECRYPTAES256: decrypts a file that was encrypted with the algorithm PBE with HMAC-SHA256-512 and AES-256.

• DECRYPT: decrypts a file that was encrypted with the “Password-Based-Encryption with MD5 and DES” algorithm.

  Note

  The filter DECRYPT is deprecated. If you can choose how the input file will be encrypted, we recommend using PBE with HMAC-SHA256-512 and AES-256 (DECRYPTAES256) because it is securer.

  See more about this in the section Features Deprecated in Denodo Platform.

  Virtual DataPort provides a tool to encrypt and decrypt files with the algorithm “PBE with HMAC-SHA256-512 and AES-256” or with “PBE with MD5 and DES”.

• CUSTOM: assigns a custom input filter to the data source. If the filter is located in a jar(s) that was loaded into the Server, add its name(s) to the JARS clause. If the custom filter has input parameters, add them after the name of the class of the filter. See more about this in the section Custom Input Filters of the Administration Guide.

The syntax of these filters is the following:

<filter> ::=
    DECRYPTAES256 PASSWORD = <literal> [ ENCRYPTED ]
  | DECRYPT PASSWORD = <literal> [ ENCRYPTED ]
  | UNZIP
  | GUNZIP
  | CUSTOM [ JARS <jar name:literal> [, <jar name:literal> ]* ]
    CLASSNAME = <literal> [ <route filter parameter> ]*

<route filter parameter> ::=
  <parameter name:identifier> = <literal> [ ENCRYPTED ] [ HIDDEN ]

For example, the command CREATE DATASOURCE ... ROUTE ... FILTER UNZIP will create a data source that will retrieve the data file, decompress it and finally process it.