Altbestand / Detail

import / iwm_articles_properties_pil_herstellertext

Mandant csv-pipeline-smoke
Altbestand
Managed Definition öffnen
engine Typ
valid Parse-Status
Managed Status
draft
importEngine Kurzinfo

Raw YAML

Dateiinhalt

Engine: Import
Source_Config: oster400
Target_Config: importEngine
Mysql_Engine: InnoDB
Default_Charset: utf8
Source_Connection_Type: database
Source_Database_Connection_Service: DatabaseConnectionService

Queries:
 - Query:
     TargetDatapool: iwm_articles_properties_pil_herstellertext
     GetQuery: SELECT DISTINCT ARARTE, ARFIRM, TRIM(ADLNM1) as ADLNM1, ARHBSN
                 FROM IWMV2R1DTA.ARTS01 JOIN IWMADROLIB.ADRS00
                   ON ARLINR = ADANUM
               WHERE ADKZKL LIKE '%L%' AND ADSTAT = 'A' AND ARSTAT = 'A'

Metadata

Erkannte Konfiguration

Diese Sicht basiert auf der aktuell lesbaren Legacy-Datei und hilft beim Vergleichen vor dem Import.

Engine Import
Source_Config oster400
Target_Config importEngine
Mysql_Engine InnoDB
Default_Charset utf8
Source_Connection_Type database
Source_Database_Connection_Service DatabaseConnectionService
Queries [ { "Query": { "TargetDatapool": "iwm_articles_properties_pil_herstellertext", "GetQuery": "SELECT DISTINCT ARARTE, ARFIRM, TRIM(ADLNM1) as ADLNM1, ARHBSN FROM IWMV2R1DTA.ARTS01 JOIN IWMADROLIB.ADRS00 ON ARLINR = ADANUM WHERE ADKZKL LIKE '%L%' AND ADSTAT = 'A' AND ARSTAT = 'A'" } } ]