Home › Discussions › Questions & Answers › Saving output files to a shared server folder (Developer)

Saving output files to a shared server folder (Developer)

Avatar photoCustomer Questions & Answers 7 replies

I need to configure a scheduled report to automatically place a copy of the output file onto a specific directory on the application server for consumption by an ETL process. How is this defined?

7 replies

  • Support Enginatics

    This is configured using the developer-only option ‘Additional Out. Directory on APPS Server’. This saves a copy of the report output file in the specified directory.

  • Can I define the directory path dynamically, perhaps creating a new folder based on the report date?

  • Support Enginatics

    Yes, you can use tokens to create a directory path dynamically. For example, `/interface/ _ `. If the resulting directory does not exist, it is automatically created, provided the apps owner has permissions.

  • Is there a similar option if the target directory is on the database server?

  • Support Enginatics

    Yes, you would use ‘Additional Out. Directory on DB Server’. The list of available directories is fetched from the `dba_directories` table.

  • Can I set a system default for these server directories?

  • Support Enginatics

    These settings can be defaulted by the corresponding profile options, such as ‘Blitz Report Additional Output Directory APPS Server’ and ‘Blitz Report Additional Output Directory DB Server’.

  • You must be logged in to reply to this post.