sync has magento
Normal
0
/
ID_BATCH
Y
ID_BATCH
CHANNEL_ID
Y
CHANNEL_ID
TRANSNAME
Y
TRANSNAME
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
CLIENT
N
CLIENT
ID_BATCH
Y
ID_BATCH
SEQ_NR
Y
SEQ_NR
LOGDATE
Y
LOGDATE
TRANSNAME
Y
TRANSNAME
STEPNAME
Y
STEPNAME
STEP_COPY
Y
STEP_COPY
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
INPUT_BUFFER_ROWS
Y
INPUT_BUFFER_ROWS
OUTPUT_BUFFER_ROWS
Y
OUTPUT_BUFFER_ROWS
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
ID_BATCH
Y
ID_BATCH
CHANNEL_ID
Y
CHANNEL_ID
LOG_DATE
Y
LOG_DATE
TRANSNAME
Y
TRANSNAME
STEPNAME
Y
STEPNAME
STEP_COPY
Y
STEP_COPY
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
LOG_FIELD
N
LOG_FIELD
ID_BATCH
Y
ID_BATCH
CHANNEL_ID
Y
CHANNEL_ID
LOG_DATE
Y
LOG_DATE
METRICS_DATE
Y
METRICS_DATE
METRICS_CODE
Y
METRICS_CODE
METRICS_DESCRIPTION
Y
METRICS_DESCRIPTION
METRICS_SUBJECT
Y
METRICS_SUBJECT
METRICS_TYPE
Y
METRICS_TYPE
METRICS_VALUE
Y
METRICS_VALUE
0.0
0.0
10000
50
50
N
Y
50000
Y
N
1000
100
-
2025/12/30 10:49:22.731
-
2025/12/30 10:49:22.731
H4sIAAAAAAAAAAMAAAAAAAAAAAA=
N
live indoteknik
localhost
POSTGRESQL
Native
erp_indoteknik
5432
pdi
Encrypted 2be989bb20084ca95810197629d9ea18e
FORCE_IDENTIFIERS_TO_LOWERCASE
N
FORCE_IDENTIFIERS_TO_UPPERCASE
N
IS_CLUSTERED
N
PORT_NUMBER
5432
PRESERVE_RESERVED_WORD_CASE
Y
QUOTE_ALL_FIELDS
N
SUPPORTS_BOOLEAN_DATA_TYPE
Y
SUPPORTS_TIMESTAMP_DATA_TYPE
Y
USE_POOLING
N
magento mysql
localhost
MYSQL
Native
magento
3306
m2
Encrypted 2be98afc83ae78197bd0ffe62dac5fa8f
EXTRA_OPTION_MYSQL.defaultFetchSize
500
EXTRA_OPTION_MYSQL.useCursorFetch
true
FORCE_IDENTIFIERS_TO_LOWERCASE
N
FORCE_IDENTIFIERS_TO_UPPERCASE
N
IS_CLUSTERED
N
PORT_NUMBER
3306
PRESERVE_RESERVED_WORD_CASE
Y
QUOTE_ALL_FIELDS
N
STREAM_RESULTS
Y
SUPPORTS_BOOLEAN_DATA_TYPE
Y
SUPPORTS_TIMESTAMP_DATA_TYPE
Y
USE_POOLING
N
Table input
Select values
Y
Table input 2
Merge join
Y
Select values
Merge join
Y
Merge join
Select values 2
Y
Select values 2
Add constants
Y
Add constants
Update
Y
Update
Update 2
Y
Add constants
Constant
Y
1
none
val_true
Boolean
True
-1
-1
N
set_solr_flag
Integer
2
-1
-1
N
192
400
Y
Merge join
MergeJoin
Y
1
none
INNER
Select values
Table input 2
variant_id
id
368
256
Y
Select values
SelectValues
Y
1
none
N
sku
variant_id
Integer
-2
-2
false
false
368
112
Y
Select values 2
SelectValues
Y
1
none
id
product_tmpl_id
N
192
256
Y
Table input
TableInput
Y
1
none
magento mysql
SELECT sku FROM catalog_product_entity
where sku not like '%-%'
order by sku;
0
N
N
N
N
String
normal
sku
64
-1
Table input
sku
.
,
none
N
Y
0
N
N
N
en_US
Asia/Bangkok
N
192
112
Y
Table input 2
TableInput
Y
1
none
live indoteknik
SELECT id, product_tmpl_id
FROM product_product
WHERE has_magento = false OR has_magento IS NULL
order by id
0
N
N
N
N
Integer
normal
id
9
0
Table input 2
id
####0;-####0
.
,
none
N
Y
0
N
N
N
en_US
Asia/Bangkok
N
Integer
normal
product_tmpl_id
9
0
Table input 2
product_tmpl_id
####0;-####0
.
,
none
N
Y
0
N
N
N
en_US
Asia/Bangkok
N
560
256
Y
Update
Update
Y
1
none
live indoteknik
N
100
N
N
public
id
id
=
has_magento
val_true
368
400
Y
Update 2
Update
Y
1
none
live indoteknik
N
100
N
N
public
product_tmpl_id
id
=
solr_flag
set_solr_flag
560
400
Y
N