Setup database schema and tables Creates the schemas and tables that are needed to import the IM-Metingen uitwisselformaat data 0 / - 2017/08/29 12:11:17.589 - 2017/08/29 12:11:17.589 database Name of the database host Host of the database (e.g. localhost) password schema_name dump user_name Name of the user of the database ID_JOB Y ID_JOB CHANNEL_ID Y CHANNEL_ID JOBNAME Y JOBNAME STATUS Y STATUS LINES_READ Y LINES_READ LINES_WRITTEN Y LINES_WRITTEN LINES_UPDATED Y LINES_UPDATED LINES_INPUT Y LINES_INPUT LINES_OUTPUT Y LINES_OUTPUT LINES_REJECTED Y LINES_REJECTED ERRORS Y ERRORS STARTDATE Y STARTDATE ENDDATE Y ENDDATE LOGDATE Y LOGDATE DEPDATE Y DEPDATE REPLAYDATE Y REPLAYDATE LOG_FIELD Y LOG_FIELD EXECUTING_SERVER N EXECUTING_SERVER EXECUTING_USER N EXECUTING_USER START_JOB_ENTRY N START_JOB_ENTRY CLIENT N CLIENT ID_BATCH Y ID_BATCH CHANNEL_ID Y CHANNEL_ID LOG_DATE Y LOG_DATE JOBNAME Y TRANSNAME JOBENTRYNAME Y STEPNAME LINES_READ Y LINES_READ LINES_WRITTEN Y LINES_WRITTEN LINES_UPDATED Y LINES_UPDATED LINES_INPUT Y LINES_INPUT LINES_OUTPUT Y LINES_OUTPUT LINES_REJECTED Y LINES_REJECTED ERRORS Y ERRORS RESULT Y RESULT NR_RESULT_ROWS Y NR_RESULT_ROWS NR_RESULT_FILES Y NR_RESULT_FILES LOG_FIELD N LOG_FIELD COPY_NR N COPY_NR ID_BATCH Y ID_BATCH CHANNEL_ID Y CHANNEL_ID LOG_DATE Y LOG_DATE LOGGING_OBJECT_TYPE Y LOGGING_OBJECT_TYPE OBJECT_NAME Y OBJECT_NAME OBJECT_COPY Y OBJECT_COPY REPOSITORY_DIRECTORY Y REPOSITORY_DIRECTORY FILENAME Y FILENAME OBJECT_ID Y OBJECT_ID OBJECT_REVISION Y OBJECT_REVISION PARENT_CHANNEL_ID Y PARENT_CHANNEL_ID ROOT_CHANNEL_ID Y ROOT_CHANNEL_ID N Create schema TRANS filename ${Internal.Job.Filename.Directory}/../Transformation/Database_action/Create_schema.ktr N N N N N N d:\konin_de\Documents\MEP_Duinen\ETL\etl_checkout\aquo\Logs\setup_database_schema log Y Y Basic N N Y N N N Pentaho local ${schema_name} ${user_name} Y N Y 0 224 144 Create tables TRANS filename ${Internal.Entry.Current.Directory}/../Transformation/Database_action/Create_tables.ktr N N N N N Y d:\konin_de\Documents\MEP_Duinen\ETL\etl_checkout\aquo\Logs\setup_database_tables log Y Y Basic N N Y N Y N ${schema_name} ${user_name} Y N Y 0 368 144 START SPECIAL Y N N 0 0 60 12 0 1 1 N Y 0 80 144 Success SUCCESS N Y 0 512 144 Create schema Create tables 0 0 Y Y N START Create schema 0 0 Y Y Y Create tables Success 0 0 Y Y N Deze Job is afhankelijk van de database connectie en daarbij ook de tabellen/schema's 80 48 586 50 -1 N N 0 0 0 255 205 112 100 100 100 Y METASTORE.pentaho Default Run Configuration {"namespace":"pentaho","id":"Default Run Configuration","name":"Default Run Configuration","description":"Defines a default run configuration","metaStoreName":null} {"_":"Embedded MetaStore Elements","namespace":"pentaho","type":"Default Run Configuration"} Pentaho local {"children":[{"children":[],"id":"server","value":null},{"children":[],"id":"clustered","value":"N"},{"children":[],"id":"name","value":"Pentaho local"},{"children":[],"id":"description","value":null},{"children":[],"id":"readOnly","value":"Y"},{"children":[],"id":"sendResources","value":"N"},{"children":[],"id":"logRemoteExecutionLocally","value":"N"},{"children":[],"id":"remote","value":"N"},{"children":[],"id":"local","value":"Y"},{"children":[],"id":"showTransformations","value":"N"}],"id":"Pentaho local","value":null,"name":"Pentaho local","owner":null,"ownerPermissionsList":[]}