A user with authority creates a scheduled View or DataMart export by performing the following steps:
Log into EnterWorks Classic.
In the Feature bar, open the Content tab, open the Scheduled Exports folder, and open the Scheduled Exports repository.
Click the
icon to create a new record. The detail editor for a new Scheduled Export record appears.
Enter a Name for the scheduled export.
Enter the login ID of the user who will receive e-mails for this export in the Manager Login field.
In the Export Type drop-down selection list, select View for a SQL View or DataMart for Data Mart. A View export will be against the EPIM snapshot table views. A DataMart export will be against the Data Mart database.
Click the Export sub-tab.
Enter the SELECT SQL query into the View SQL field.
Select TAB, COMMA or ~ in the View Format field to specify the character to be used as a delimiter.
Enter the target details (file/e-mail/FTP/S3) in the appropriate fields:
Enter the name of the export file to be created.
To overwrite an existing file, set Target Overwrite File to “Yes”.
Click the Schedule sub-tab.
Set the Schedule Export field to “Yes”.
Set the Schedule Type to the desired type and the Schedule Period to the desired interval (based on the selected type). For example, to produce an export nightly, set the Schedule Type to Days and the Period to 1. To produce an export for every 2 weeks, set the Export Type to Weeks and the Scheduled Period to 2. If the Schedule Type is set to Days Of Week, the Schedule Period is not used and instead the days listed in Schedule Days determine which days of the week the export will be triggered:
Set the Next Export Datetime field to the date and time when the export is to run. For Schedule Types other than Minutes, the time portion of this field will determine the time of day the export will be triggered. If the date and time are in the past, the export will be initiated immediately and the Next Export Datetime will be used in conjunction with the Schedule Type and Schedule Period to calculate the next time the export should be initiated.
Click Save. When the current date and time passes the Next Export Datetime, the Repository export will be initiated. Once triggered, the Next Export Datetime will be updated using the Schedule Type and Schedule Period.