You can translate the document:

Content

In a job that has a CSV (or SQL) exporter configured, the default location for the exported file will be:

  • <DENODO_HOME>/work/scheduler/data/csv
  • <DENODO_HOME>/work/scheduler/data/sql

It is possible to modify this path in order to retrieve the result files wherever you want (e.g C:\Users\Example\result.csv or /opt/results/result.csv).

You only have to edit the path field in the Exporter Section of a job and enter an absolute path.

To access remote locations or network folders it is possible to create a symbolic link or a network drive so it shows up as a local folder. For more information see Accessing network drives from Denodo Virtual DataPort.

In addition to being able to specify a constant value for the “Output file” field it is also possible to use some predefined variables as part of the file path or name:

  • projectName: name of the Scheduler project.
  • jobName: name of the Scheduler job.
  • jobId: internal id of the Scheduler job.
  • jobStartTime: timestamp for the current execution of the job.

The syntax to specify these predefined variables will be: @{variableName}

You can also use a variable for the file path any field present in the documents exported by the job using the following syntax:

@{field:<DOCUMENT_FIELD_NAME>}

where <DOCUMENT_FIELD_NAME> is the name of the field in the exported documents.

When these variables are dates it is also possible to format them by specifying input and output date patterns. The input pattern is optional, if not present it will be assumed that the date is expressed in milliseconds since the midnight of January 1st,1970. The syntax for this date transformation will be:

@{jobStartTime,outputDateFormat:yyyy-MM-dd}

for predefined variables and

@{field:<DOCUMENT_FIELD_NAME>,inputDateFormat:yyyyMMdd,outputDateFormat:yyyy-MM-dd}

for fields in the exported documents.

References

Scheduler Administration Guide: Postprocessing Section (Filter/Exporters)

Accessing network drives from Denodo Virtual DataPort

Disclaimer
The information provided in the Denodo Knowledge Base is intended to assist our users in advanced uses of Denodo. Please note that the results from the application of processes and configurations detailed in these documents may vary depending on your specific environment. Use them at your own discretion.
For an official guide of supported features, please refer to the User Manuals. For questions on critical systems or complex environments we recommend you to contact your Denodo Customer Success Manager.

Questions

Ask a question

You must sign in to ask a question. If you do not have an account, you can register here