Advanced-etl-processor
Backup Repository Dynamic Action
Importance of Backup
Regular backup is a necessary action to protect the business from data loss.
Metadata tab
- The Write Variables option ensures that the “Package Action” logs the variable values into the “Action vars before log file” before the action is executed and logs the updated variable values into the “Action vars after log file” after the action completes.
- This option is typically used for debugging and is not recommended in a production environment.
- It can be globally disabled through the options dialog .
Parameters tab
To minimize potential issues, avoid using mapped drives and opt for the UNC (Universal Naming Convention) path instead. Mapped drives can lead to problems with accessibility and permissions, especially in networked environments or automated processes. UNC paths provide a direct, reliable way to reference network resources without relying on local drive letters, ensuring better stability and consistency across different systems and users.
Variables tab
The Variables tab defines which variables are updated during the execution of the action.
Tip: Double-click a variable name to enable or disable it.it
Execution log tab
The Execution Log tab is populated after the action has been executed. Double-click a row to view the detailed execution log.
Calculated Backup file name example
Pascal
begin
Result:='c:\support\'+LeftString(GETSYSTEMVARIABLE('SYSTEM_DATE'),8)+'.zip';
end;Python
from datetime import datetime
Result.Value='c:\\support\\'+ datetime.now().strftime('%Y%m%d')+'.zip'About backup
Backup is a zip file which has sqlite database inside and ReadMe.txt file with a metadata about backup.
ReadMe.txt Example
Repository Backup
Repository Name: SQL_SERVER
Repository Type: MS Sql Server
Repository Server: DBSLAMD\SQLEXPRESS2019
Repository Database: AETL_REPOSITORY
Created: 05/04/2023 09:47:12
Computer Name: DBSLAMD
User Name: dbsl
Application: AdvancedETLEnt.exe
Version: 6.3.10.0
www.etl-tools.comPerformance
For very large repository it might take a while to perform backup. In this case we recommend clearing QUEU\* repository tables
Useful Links
For more technologies supported by our ETL Software see Advanced ETL Processor Versions
Confused? Ask question on our ETL Forum