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

Saving output files to a shared server folder (Developer)

Avatar photoCustomer February 10, 2024 at 9:46 pm

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?

Viewing 6 reply threads
  • Author
    Replies
    • Support February 11, 2024 at 7:27 am  

      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.

    • Avatar photoCustomer February 12, 2024 at 11:13 am  

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

    • Support February 12, 2024 at 5:48 pm  

      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.

    • Avatar photoCustomer February 13, 2024 at 5:00 am  

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

    • Support February 13, 2024 at 2:25 pm  

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

    • Avatar photoCustomer February 14, 2024 at 9:26 pm  

      Can I set a system default for these server directories?

    • Support February 16, 2024 at 1:46 pm  

      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’.

Viewing 6 reply threads
  • You must be logged in to reply to this post.

Login with: