3/21/2024 0 Comments Extract transform load etlThe transformation files must manually be moved from /data/pentaho_backup into a potential new folder structure (described below). When upgrading from previous versions the old transformation files will be moved into the folder /data/pentaho_backup. T o use the old databases, these must be moved manually which is not recommended. This will allow databases to follow potential new database schema(s). Since no data is stored in the ETL database, it is highly recommended to drop the databases and recreate them rather than moving them. This means that it is always safe to drop any ETL database and recreate it without the risk of losing data. The ETL databases do not contain the sole instance of any piece of data.At any point in time the data in the import and/or export database represents the currently best known state of the system.Both import and export databases are viewed as "api-like" interface to the system.When upgrading an existing solution running ETL for importing and/or exporting data to ITA a couple of guidelines are: Upgrade of the ETL system is a part of the general ITA upgrade. No files (or databases) will be deleted when upgrading/restoring an ITA system. Upgrading ETL external system integration Setting up the export is done using the server configuration interface as described here.If transformation is needed this must be done outside the server in a separate setup. The data exported from IT Advisor cannot be changed by transformations inside the ITA server. The data is exported using the ETL Export Database. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |