Engine / Editor
unitize_articles_promotions
Mandant codex-demo
Pipelines
Engines
Include Mappings
Filter
Überblick
Editor
Validierung
Metadaten
Revisionen
Zurück
Altbestand
Engine bearbeiten
Bestand öffnen
Altbestand
Zum Editor
Run erst mit Status active
DRAFT
Status
engine
Typ
unitize
Runner
1
Revisionen
Editor
Engine bearbeiten
Definitionstyp
Runner-Typ
Name
Titel
Status
draft
active
archived
YAML-Inhalt
Engine: Unitize Source_Config: importEngine Target_Config: unitizeEngine Mysql_Engine: InnoDB Default_Charset: latin1 Source_Connection_Type: database Source_Database_Connection_Service: DatabaseConnectionService Source_Datapool: iwm_articles_new Source_Primary_Key: [ordernumber, FIRMA] Target_Primary_Key: [ordernumber, firma, category_part_1_ost, category_part_2_ost, category_part_3_ost, category_part_1_tre, category_part_2_tre, category_part_3_tre, category_part_1_oms, category_part_2_oms, category_part_3_oms] #always primary key for target datapool. primary key of source pool can be read from the pool itself. Datapool: articles_promotions Add_Indices: - Add_Index: Datapool: iwm_articles_new Index_Name: idx_ordernumber_firma Fields: ORDERNUMBER, FIRMA - Add_Index: Datapool: export_articles_categories_ost Index_Name: idx_ordernumber_firma Fields: ordernumber, firma Sql: Select * from iwm_articles_new LEFT JOIN export_articles_categories_ost on iwm_articles_new.ORDERNUMBER = export_articles_categories_ost.ORDERNUMBER AND iwm_articles_new.FIRMA = export_articles_categories_ost.firma Datapool_Definition: ordernumber: VARCHAR(50) NOT NULL mainnumber: VARCHAR(50) DEFAULT NULL arte: VARCHAR(50) DEFAULT NULL firma: VARCHAR(50) NOT NULL category_part_1_ost: VARCHAR(50) NOT NULL category_part_2_ost: VARCHAR(50) NOT NULL category_part_3_ost: VARCHAR(50) NOT NULL category_part_1_tre: VARCHAR(50) NOT NULL category_part_2_tre: VARCHAR(50) NOT NULL category_part_3_tre: VARCHAR(50) NOT NULL category_part_1_oms: VARCHAR(50) NOT NULL category_part_2_oms: VARCHAR(50) NOT NULL category_part_3_oms: VARCHAR(50) NOT NULL price_ost: VARCHAR(50) NOT NULL price_tre: VARCHAR(50) NOT NULL price_oms: VARCHAR(50) NOT NULL aktion_Sonderpreis: VARCHAR(20) DEFAULT NULL aktion_Gutscheincode: VARCHAR(20) DEFAULT NULL Mapping: ordernumber: iwm_articles_new.ORDERNUMBER mainnumber: iwm_articles_new.MAINNUMBER arte: iwm_articles_new.MAINNUMBER firma: iwm_articles_new.FIRMA category_part_1_ost: export_articles_categories_ost.category_part_1 category_part_2_ost: export_articles_categories_ost.category_part_2 category_part_3_ost: export_articles_categories_ost.category_part_3 category_part_1_tre: () category_part_2_tre: () category_part_3_tre: () category_part_1_oms: () category_part_2_oms: () category_part_3_oms: () price_ost: () price_tre: () price_oms: () aktion_Sonderpreis: () aktion_Gutscheincode: ()
Definition aktualisieren