diff options
| -rw-r--r-- | import_accurate_fixco_to_data_warehouse.ktr | 8 | ||||
| -rw-r--r-- | import_accurate_to_data_warehouse.ktr | 24 | ||||
| -rw-r--r-- | import_adempiere_to_data_warehouse.ktr | 68 | ||||
| -rw-r--r-- | import_data_bi.sh | 2 | ||||
| -rw-r--r-- | import_leadtime_po_to_received.ktr | 373 | ||||
| -rw-r--r-- | import_leadtime_po_to_received_detail.ktr | 268 | ||||
| -rw-r--r-- | import_leadtime_so_send.ktr | 39 | ||||
| -rw-r--r-- | import_leadtime_so_send_detail.ktr | 702 | ||||
| -rw-r--r-- | import_margin.ktr | 18 | ||||
| -rw-r--r-- | import_odoo_14_to_data_warehouse.ktr | 18 | ||||
| -rw-r--r-- | import_sale_order.ktr | 324 | ||||
| -rw-r--r-- | refresh_materialized_view_fixco.ktr | 18 | ||||
| -rw-r--r-- | refresh_materialized_view_pricelist.ktr | 12 |
13 files changed, 910 insertions, 964 deletions
diff --git a/import_accurate_fixco_to_data_warehouse.ktr b/import_accurate_fixco_to_data_warehouse.ktr index e30b7b6..f92adc0 100644 --- a/import_accurate_fixco_to_data_warehouse.ktr +++ b/import_accurate_fixco_to_data_warehouse.ktr @@ -436,14 +436,14 @@ <notepads> </notepads> <connection> - <name>dw bi fixco</name> - <server>192.168.23.5</server> + <name>dw bi fixco (localhost)</name> + <server>localhost</server> <type>POSTGRESQL</type> <access>Native</access> <database>dw_bi_fixco</database> <port>5432</port> <username>odoo</username> - <password>Encrypted 2be98afc86aa7f2e4cb79ce10d196a0d5</password> + <password>Encrypted 2be98afc82bdfd8dd9a2ca45acc83f6c3</password> <servername/> <data_tablespace/> <index_tablespace/> @@ -598,7 +598,7 @@ <method>none</method> <schema_name/> </partitioning> - <connection>dw bi fixco</connection> + <connection>dw bi fixco (localhost)</connection> <commit>100</commit> <update_bypassed>N</update_bypassed> <lookup> diff --git a/import_accurate_to_data_warehouse.ktr b/import_accurate_to_data_warehouse.ktr index 778b90c..5f0fad1 100644 --- a/import_accurate_to_data_warehouse.ktr +++ b/import_accurate_to_data_warehouse.ktr @@ -436,14 +436,14 @@ <notepads> </notepads> <connection> - <name>dw bi fixco</name> - <server>192.168.23.5</server> + <name>dw bi fixco (localhost)</name> + <server>localhost</server> <type>POSTGRESQL</type> <access>Native</access> <database>dw_bi_fixco</database> <port>5432</port> <username>odoo</username> - <password>Encrypted 2be98afc86aa7f2e4cb79ce10d196a0d5</password> + <password>Encrypted 2be98afc82bdfd8dd9a2ca45acc83f6c3</password> <servername/> <data_tablespace/> <index_tablespace/> @@ -487,14 +487,14 @@ </attributes> </connection> <connection> - <name>dw bi indoteknik</name> - <server>192.168.23.5</server> + <name>dw bi indoteknik (localhost)</name> + <server>localhost</server> <type>POSTGRESQL</type> <access>Native</access> <database>dw_bi_indoteknik</database> <port>5432</port> <username>odoo</username> - <password>Encrypted 2be98afc86aa7f2e4cb79ce10d196a0d5</password> + <password>Encrypted 2be98afc82bdfd8dd9a2ca45acc83f6c3</password> <servername/> <data_tablespace/> <index_tablespace/> @@ -529,7 +529,7 @@ </attribute> <attribute> <code>SUPPORTS_TIMESTAMP_DATA_TYPE</code> - <attribute>Y</attribute> + <attribute>N</attribute> </attribute> <attribute> <code>USE_POOLING</code> @@ -659,7 +659,7 @@ <method>none</method> <schema_name/> </partitioning> - <connection>dw bi fixco</connection> + <connection>dw bi fixco (localhost)</connection> <commit>100</commit> <update_bypassed>N</update_bypassed> <lookup> @@ -727,7 +727,7 @@ <method>none</method> <schema_name/> </partitioning> - <connection>dw bi indoteknik</connection> + <connection>dw bi indoteknik (localhost)</connection> <commit>100</commit> <update_bypassed>N</update_bypassed> <lookup> @@ -1041,27 +1041,21 @@ <fields> <field> <name>invoice</name> - <rename/> </field> <field> <name>date_invoice</name> - <rename/> </field> <field> <name>customer</name> - <rename/> </field> <field> <name>total</name> - <rename/> </field> <field> <name>subtotal</name> - <rename/> </field> <field> <name>salesperson</name> - <rename/> </field> <select_unspecified>N</select_unspecified> <meta> diff --git a/import_adempiere_to_data_warehouse.ktr b/import_adempiere_to_data_warehouse.ktr index 46f7ec7..7da86fc 100644 --- a/import_adempiere_to_data_warehouse.ktr +++ b/import_adempiere_to_data_warehouse.ktr @@ -487,6 +487,57 @@ </attributes> </connection> <connection> + <name>dw bi indoteknik (localhost)</name> + <server>localhost</server> + <type>POSTGRESQL</type> + <access>Native</access> + <database>dw_bi_indoteknik</database> + <port>5432</port> + <username>odoo</username> + <password>Encrypted 2be98afc82bdfd8dd9a2ca45acc83f6c3</password> + <servername/> + <data_tablespace/> + <index_tablespace/> + <attributes> + <attribute> + <code>FORCE_IDENTIFIERS_TO_LOWERCASE</code> + <attribute>N</attribute> + </attribute> + <attribute> + <code>FORCE_IDENTIFIERS_TO_UPPERCASE</code> + <attribute>N</attribute> + </attribute> + <attribute> + <code>IS_CLUSTERED</code> + <attribute>N</attribute> + </attribute> + <attribute> + <code>PORT_NUMBER</code> + <attribute>5432</attribute> + </attribute> + <attribute> + <code>PRESERVE_RESERVED_WORD_CASE</code> + <attribute>Y</attribute> + </attribute> + <attribute> + <code>QUOTE_ALL_FIELDS</code> + <attribute>N</attribute> + </attribute> + <attribute> + <code>SUPPORTS_BOOLEAN_DATA_TYPE</code> + <attribute>Y</attribute> + </attribute> + <attribute> + <code>SUPPORTS_TIMESTAMP_DATA_TYPE</code> + <attribute>N</attribute> + </attribute> + <attribute> + <code>USE_POOLING</code> + <attribute>N</attribute> + </attribute> + </attributes> + </connection> + <connection> <name>erp indoteknik production</name> <server>34.101.171.249</server> <type>POSTGRESQL</type> @@ -1160,51 +1211,39 @@ <fields> <field> <name>customer</name> - <rename/> </field> <field> <name>invoice_date</name> - <rename/> </field> <field> <name>price_subtotal</name> - <rename/> </field> <field> <name>invoice</name> - <rename/> </field> <field> <name>quantity</name> - <rename/> </field> <field> <name>product</name> - <rename/> </field> <field> <name>brand</name> - <rename/> </field> <field> <name>salesperson</name> - <rename/> </field> <field> <name>name</name> - <rename/> </field> <field> <name>value</name> - <rename/> </field> <field> <name>odoo_partner_name</name> - <rename/> </field> <field> <name>industry</name> - <rename/> </field> <select_unspecified>N</select_unspecified> <meta> @@ -1833,7 +1872,7 @@ where reference_number is not null</sql> <method>none</method> <schema_name/> </partitioning> - <connection>dw bi indoteknik</connection> + <connection>dw bi indoteknik (localhost)</connection> <commit>100</commit> <update_bypassed>N</update_bypassed> <lookup> @@ -1935,15 +1974,12 @@ where reference_number is not null</sql> <fields> <field> <name>name</name> - <rename/> </field> <field> <name>reference_number</name> - <rename/> </field> <field> <name>industry</name> - <rename/> </field> <select_unspecified>N</select_unspecified> <meta> diff --git a/import_data_bi.sh b/import_data_bi.sh index 082f487..4075cbb 100644 --- a/import_data_bi.sh +++ b/import_data_bi.sh @@ -1 +1 @@ -sh /opt/data-integration/kitchen.sh -file="/home/stephan/transformation-job-bi/import_all_data_bi_indoteknik.kjb" > "/home/stephan/transformation-job-bi/log/import.log" +sh /home/stephan/data-integration/kitchen.sh -level="Debug" -file="/home/stephan/transformation-job-bi/import_all_data_bi_indoteknik.kjb" > "/home/stephan/transformation-job-bi/log/import.log" diff --git a/import_leadtime_po_to_received.ktr b/import_leadtime_po_to_received.ktr index 2a59cb7..b538184 100644 --- a/import_leadtime_po_to_received.ktr +++ b/import_leadtime_po_to_received.ktr @@ -430,20 +430,20 @@ <created_date>2023/03/15 11:47:24.742</created_date> <modified_user>-</modified_user> <modified_date>2023/03/15 11:47:24.742</modified_date> - <key_for_session_key/> + <key_for_session_key>H4sIAAAAAAAAAAMAAAAAAAAAAAA=</key_for_session_key> <is_key_private>N</is_key_private> </info> <notepads> </notepads> <connection> - <name>dw bi indoteknik</name> - <server>192.168.23.5</server> + <name>dw bi indoteknik (localhost)</name> + <server>localhost</server> <type>POSTGRESQL</type> <access>Native</access> <database>dw_bi_indoteknik</database> <port>5432</port> <username>odoo</username> - <password>Encrypted 2be98afc86aa7f2e4cb79ce10d196a0d5</password> + <password>Encrypted 2be98afc82bdfd8dd9a2ca45acc83f6c3</password> <servername/> <data_tablespace/> <index_tablespace/> @@ -478,7 +478,7 @@ </attribute> <attribute> <code>SUPPORTS_TIMESTAMP_DATA_TYPE</code> - <attribute>Y</attribute> + <attribute>N</attribute> </attribute> <attribute> <code>USE_POOLING</code> @@ -487,8 +487,8 @@ </attributes> </connection> <connection> - <name>erp indoteknik production</name> - <server>34.101.171.249</server> + <name>erp indoteknik production (localhost)</name> + <server>10.148.0.3</server> <type>POSTGRESQL</type> <access>Native</access> <database>erp_indoteknik</database> @@ -529,7 +529,7 @@ </attribute> <attribute> <code>SUPPORTS_TIMESTAMP_DATA_TYPE</code> - <attribute>Y</attribute> + <attribute>N</attribute> </attribute> <attribute> <code>USE_POOLING</code> @@ -550,6 +550,176 @@ </hop> </order> <step> + <name>Insert / update</name> + <type>InsertUpdate</type> + <description/> + <distribute>Y</distribute> + <custom_distribution/> + <copies>1</copies> + <partitioning> + <method>none</method> + <schema_name/> + </partitioning> + <connection>dw bi indoteknik (localhost)</connection> + <commit>100</commit> + <update_bypassed>N</update_bypassed> + <lookup> + <schema>public</schema> + <table>leadtime_po_to_received</table> + <key> + <name>id</name> + <field>id</field> + <condition>=</condition> + <name2/> + </key> + <value> + <name>id</name> + <rename>id</rename> + <update>N</update> + </value> + <value> + <name>vendor</name> + <rename>vendor</rename> + <update>Y</update> + </value> + <value> + <name>name</name> + <rename>name</rename> + <update>Y</update> + </value> + <value> + <name>year_month</name> + <rename>year_month</rename> + <update>Y</update> + </value> + <value> + <name>year</name> + <rename>year</rename> + <update>Y</update> + </value> + <value> + <name>month</name> + <rename>month</rename> + <update>Y</update> + </value> + <value> + <name>day</name> + <rename>day</rename> + <update>Y</update> + </value> + <value> + <name>date_po</name> + <rename>date_po</rename> + <update>Y</update> + </value> + <value> + <name>date_last_received</name> + <rename>date_last_received</rename> + <update>Y</update> + </value> + <value> + <name>difference</name> + <rename>difference</rename> + <update>Y</update> + </value> + <value> + <name>diff_in_day</name> + <rename>diff_in_day</rename> + <update>Y</update> + </value> + <value> + <name>diff_in_hour</name> + <rename>diff_in_hour</rename> + <update>Y</update> + </value> + <value> + <name>login</name> + <rename>login</rename> + <update>Y</update> + </value> + </lookup> + <attributes/> + <cluster_schema/> + <remotesteps> + <input> + </input> + <output> + </output> + </remotesteps> + <GUI> + <xloc>704</xloc> + <yloc>144</yloc> + <draw>Y</draw> + </GUI> + </step> + <step> + <name>Select values</name> + <type>SelectValues</type> + <description/> + <distribute>Y</distribute> + <custom_distribution/> + <copies>1</copies> + <partitioning> + <method>none</method> + <schema_name/> + </partitioning> + <fields> + <field> + <name>id</name> + </field> + <field> + <name>vendor</name> + </field> + <field> + <name>name</name> + </field> + <field> + <name>year_month</name> + </field> + <field> + <name>year</name> + </field> + <field> + <name>month</name> + </field> + <field> + <name>day</name> + </field> + <field> + <name>date_po</name> + </field> + <field> + <name>date_last_received</name> + </field> + <field> + <name>difference</name> + </field> + <field> + <name>diff_in_day</name> + </field> + <field> + <name>diff_in_hour</name> + </field> + <field> + <name>login</name> + </field> + <select_unspecified>N</select_unspecified> + </fields> + <attributes/> + <cluster_schema/> + <remotesteps> + <input> + </input> + <output> + </output> + </remotesteps> + <GUI> + <xloc>560</xloc> + <yloc>144</yloc> + <draw>Y</draw> + </GUI> + </step> + <step> <name>Table input</name> <type>TableInput</type> <description/> @@ -560,7 +730,7 @@ <method>none</method> <schema_name/> </partitioning> - <connection>erp indoteknik production</connection> + <connection>erp indoteknik production (localhost)</connection> <sql>select * from v_leadtime_po_to_received</sql> <limit>0</limit> <lookup/> @@ -804,7 +974,7 @@ <storagetype>normal</storagetype> <name>difference</name> <length>-1</length> - <precision>6</precision> + <precision>-1</precision> <origin>Table input</origin> <comments>difference</comments> <conversion_Mask/> @@ -883,189 +1053,6 @@ <draw>Y</draw> </GUI> </step> - <step> - <name>Select values</name> - <type>SelectValues</type> - <description/> - <distribute>Y</distribute> - <custom_distribution/> - <copies>1</copies> - <partitioning> - <method>none</method> - <schema_name/> - </partitioning> - <fields> - <field> - <name>id</name> - <rename/> - </field> - <field> - <name>vendor</name> - <rename/> - </field> - <field> - <name>name</name> - <rename/> - </field> - <field> - <name>year_month</name> - <rename/> - </field> - <field> - <name>year</name> - <rename/> - </field> - <field> - <name>month</name> - <rename/> - </field> - <field> - <name>day</name> - <rename/> - </field> - <field> - <name>date_po</name> - <rename/> - </field> - <field> - <name>date_last_received</name> - <rename/> - </field> - <field> - <name>difference</name> - <rename/> - </field> - <field> - <name>diff_in_day</name> - <rename/> - </field> - <field> - <name>diff_in_hour</name> - <rename/> - </field> - <field> - <name>login</name> - <rename/> - </field> - <select_unspecified>N</select_unspecified> - </fields> - <attributes/> - <cluster_schema/> - <remotesteps> - <input> - </input> - <output> - </output> - </remotesteps> - <GUI> - <xloc>560</xloc> - <yloc>144</yloc> - <draw>Y</draw> - </GUI> - </step> - <step> - <name>Insert / update</name> - <type>InsertUpdate</type> - <description/> - <distribute>Y</distribute> - <custom_distribution/> - <copies>1</copies> - <partitioning> - <method>none</method> - <schema_name/> - </partitioning> - <connection>dw bi indoteknik</connection> - <commit>100</commit> - <update_bypassed>N</update_bypassed> - <lookup> - <schema>public</schema> - <table>leadtime_po_to_received</table> - <key> - <name>id</name> - <field>id</field> - <condition>=</condition> - <name2/> - </key> - <value> - <name>id</name> - <rename>id</rename> - <update>N</update> - </value> - <value> - <name>vendor</name> - <rename>vendor</rename> - <update>Y</update> - </value> - <value> - <name>name</name> - <rename>name</rename> - <update>Y</update> - </value> - <value> - <name>year_month</name> - <rename>year_month</rename> - <update>Y</update> - </value> - <value> - <name>year</name> - <rename>year</rename> - <update>Y</update> - </value> - <value> - <name>month</name> - <rename>month</rename> - <update>Y</update> - </value> - <value> - <name>day</name> - <rename>day</rename> - <update>Y</update> - </value> - <value> - <name>date_po</name> - <rename>date_po</rename> - <update>Y</update> - </value> - <value> - <name>date_last_received</name> - <rename>date_last_received</rename> - <update>Y</update> - </value> - <value> - <name>difference</name> - <rename>difference</rename> - <update>Y</update> - </value> - <value> - <name>diff_in_day</name> - <rename>diff_in_day</rename> - <update>Y</update> - </value> - <value> - <name>diff_in_hour</name> - <rename>diff_in_hour</rename> - <update>Y</update> - </value> - <value> - <name>login</name> - <rename>login</rename> - <update>Y</update> - </value> - </lookup> - <attributes/> - <cluster_schema/> - <remotesteps> - <input> - </input> - <output> - </output> - </remotesteps> - <GUI> - <xloc>704</xloc> - <yloc>144</yloc> - <draw>Y</draw> - </GUI> - </step> <step_error_handling> </step_error_handling> <slave-step-copy-partition-distribution> diff --git a/import_leadtime_po_to_received_detail.ktr b/import_leadtime_po_to_received_detail.ktr index bdff8af..fe0b34c 100644 --- a/import_leadtime_po_to_received_detail.ktr +++ b/import_leadtime_po_to_received_detail.ktr @@ -430,20 +430,20 @@ <created_date>2023/03/16 13:25:37.713</created_date> <modified_user>-</modified_user> <modified_date>2023/03/16 13:25:37.713</modified_date> - <key_for_session_key/> + <key_for_session_key>H4sIAAAAAAAAAAMAAAAAAAAAAAA=</key_for_session_key> <is_key_private>N</is_key_private> </info> <notepads> </notepads> <connection> - <name>dw bi indoteknik</name> - <server>192.168.23.5</server> + <name>dw bi indoteknik (localhost)</name> + <server>localhost</server> <type>POSTGRESQL</type> <access>Native</access> <database>dw_bi_indoteknik</database> <port>5432</port> <username>odoo</username> - <password>Encrypted 2be98afc86aa7f2e4cb79ce10d196a0d5</password> + <password>Encrypted 2be98afc82bdfd8dd9a2ca45acc83f6c3</password> <servername/> <data_tablespace/> <index_tablespace/> @@ -478,7 +478,7 @@ </attribute> <attribute> <code>SUPPORTS_TIMESTAMP_DATA_TYPE</code> - <attribute>Y</attribute> + <attribute>N</attribute> </attribute> <attribute> <code>USE_POOLING</code> @@ -487,8 +487,8 @@ </attributes> </connection> <connection> - <name>erp indoteknik production</name> - <server>34.101.171.249</server> + <name>erp indoteknik production (localhost)</name> + <server>10.148.0.3</server> <type>POSTGRESQL</type> <access>Native</access> <database>erp_indoteknik</database> @@ -529,7 +529,7 @@ </attribute> <attribute> <code>SUPPORTS_TIMESTAMP_DATA_TYPE</code> - <attribute>Y</attribute> + <attribute>N</attribute> </attribute> <attribute> <code>USE_POOLING</code> @@ -550,140 +550,6 @@ </hop> </order> <step> - <name>Table input</name> - <type>TableInput</type> - <description/> - <distribute>Y</distribute> - <custom_distribution/> - <copies>1</copies> - <partitioning> - <method>none</method> - <schema_name/> - </partitioning> - <connection>erp indoteknik production</connection> - <sql>select * from v_leadtime_po_to_received_detail</sql> - <limit>0</limit> - <lookup/> - <execute_each_row>N</execute_each_row> - <variables_active>N</variables_active> - <lazy_conversion_active>N</lazy_conversion_active> - <cached_row_meta_active>N</cached_row_meta_active> - <row-meta/> - <attributes/> - <cluster_schema/> - <remotesteps> - <input> - </input> - <output> - </output> - </remotesteps> - <GUI> - <xloc>272</xloc> - <yloc>64</yloc> - <draw>Y</draw> - </GUI> - </step> - <step> - <name>Select values</name> - <type>SelectValues</type> - <description/> - <distribute>Y</distribute> - <custom_distribution/> - <copies>1</copies> - <partitioning> - <method>none</method> - <schema_name/> - </partitioning> - <fields> - <field> - <name>line_id</name> - <rename/> - </field> - <field> - <name>header_id</name> - <rename/> - </field> - <field> - <name>vendor</name> - <rename/> - </field> - <field> - <name>name</name> - <rename/> - </field> - <field> - <name>year_month</name> - <rename/> - </field> - <field> - <name>year</name> - <rename/> - </field> - <field> - <name>month</name> - <rename/> - </field> - <field> - <name>day</name> - <rename/> - </field> - <field> - <name>date_po</name> - <rename/> - </field> - <field> - <name>date_last_received</name> - <rename/> - </field> - <field> - <name>login</name> - <rename/> - </field> - <field> - <name>brand</name> - <rename/> - </field> - <field> - <name>product</name> - <rename/> - </field> - <field> - <name>item_code</name> - <rename/> - </field> - <field> - <name>product_uom_qty</name> - <rename/> - </field> - <field> - <name>qty_received</name> - <rename/> - </field> - <field> - <name>price_unit</name> - <rename/> - </field> - <field> - <name>price_subtotal</name> - <rename/> - </field> - <select_unspecified>N</select_unspecified> - </fields> - <attributes/> - <cluster_schema/> - <remotesteps> - <input> - </input> - <output> - </output> - </remotesteps> - <GUI> - <xloc>416</xloc> - <yloc>64</yloc> - <draw>Y</draw> - </GUI> - </step> - <step> <name>Insert / update</name> <type>InsertUpdate</type> <description/> @@ -694,7 +560,7 @@ <method>none</method> <schema_name/> </partitioning> - <connection>dw bi indoteknik</connection> + <connection>dw bi indoteknik (localhost)</connection> <commit>100</commit> <update_bypassed>N</update_bypassed> <lookup> @@ -811,6 +677,122 @@ <draw>Y</draw> </GUI> </step> + <step> + <name>Select values</name> + <type>SelectValues</type> + <description/> + <distribute>Y</distribute> + <custom_distribution/> + <copies>1</copies> + <partitioning> + <method>none</method> + <schema_name/> + </partitioning> + <fields> + <field> + <name>line_id</name> + </field> + <field> + <name>header_id</name> + </field> + <field> + <name>vendor</name> + </field> + <field> + <name>name</name> + </field> + <field> + <name>year_month</name> + </field> + <field> + <name>year</name> + </field> + <field> + <name>month</name> + </field> + <field> + <name>day</name> + </field> + <field> + <name>date_po</name> + </field> + <field> + <name>date_last_received</name> + </field> + <field> + <name>login</name> + </field> + <field> + <name>brand</name> + </field> + <field> + <name>product</name> + </field> + <field> + <name>item_code</name> + </field> + <field> + <name>product_uom_qty</name> + </field> + <field> + <name>qty_received</name> + </field> + <field> + <name>price_unit</name> + </field> + <field> + <name>price_subtotal</name> + </field> + <select_unspecified>N</select_unspecified> + </fields> + <attributes/> + <cluster_schema/> + <remotesteps> + <input> + </input> + <output> + </output> + </remotesteps> + <GUI> + <xloc>416</xloc> + <yloc>64</yloc> + <draw>Y</draw> + </GUI> + </step> + <step> + <name>Table input</name> + <type>TableInput</type> + <description/> + <distribute>Y</distribute> + <custom_distribution/> + <copies>1</copies> + <partitioning> + <method>none</method> + <schema_name/> + </partitioning> + <connection>erp indoteknik production (localhost)</connection> + <sql>select * from v_leadtime_po_to_received_detail</sql> + <limit>0</limit> + <lookup/> + <execute_each_row>N</execute_each_row> + <variables_active>N</variables_active> + <lazy_conversion_active>N</lazy_conversion_active> + <cached_row_meta_active>N</cached_row_meta_active> + <row-meta/> + <attributes/> + <cluster_schema/> + <remotesteps> + <input> + </input> + <output> + </output> + </remotesteps> + <GUI> + <xloc>272</xloc> + <yloc>64</yloc> + <draw>Y</draw> + </GUI> + </step> <step_error_handling> </step_error_handling> <slave-step-copy-partition-distribution> diff --git a/import_leadtime_so_send.ktr b/import_leadtime_so_send.ktr index c34183d..a82b9b8 100644 --- a/import_leadtime_so_send.ktr +++ b/import_leadtime_so_send.ktr @@ -436,14 +436,14 @@ <notepads> </notepads> <connection> - <name>dw bi indoteknik</name> - <server>192.168.23.5</server> + <name>dw bi indoteknik (localhost)</name> + <server>localhost</server> <type>POSTGRESQL</type> <access>Native</access> <database>dw_bi_indoteknik</database> <port>5432</port> <username>odoo</username> - <password>Encrypted 2be98afc86aa7f2e4cb79ce10d196a0d5</password> + <password>Encrypted 2be98afc82bdfd8dd9a2ca45acc83f6c3</password> <servername/> <data_tablespace/> <index_tablespace/> @@ -478,7 +478,7 @@ </attribute> <attribute> <code>SUPPORTS_TIMESTAMP_DATA_TYPE</code> - <attribute>Y</attribute> + <attribute>N</attribute> </attribute> <attribute> <code>USE_POOLING</code> @@ -487,8 +487,8 @@ </attributes> </connection> <connection> - <name>erp indoteknik production</name> - <server>34.101.171.249</server> + <name>erp indoteknik production (localhost)</name> + <server>10.148.0.3</server> <type>POSTGRESQL</type> <access>Native</access> <database>erp_indoteknik</database> @@ -529,7 +529,7 @@ </attribute> <attribute> <code>SUPPORTS_TIMESTAMP_DATA_TYPE</code> - <attribute>Y</attribute> + <attribute>N</attribute> </attribute> <attribute> <code>USE_POOLING</code> @@ -560,7 +560,7 @@ <method>none</method> <schema_name/> </partitioning> - <connection>dw bi indoteknik</connection> + <connection>dw bi indoteknik (localhost)</connection> <commit>100</commit> <update_bypassed>N</update_bypassed> <lookup> @@ -706,87 +706,66 @@ <fields> <field> <name>id</name> - <rename/> </field> <field> <name>so_number</name> - <rename/> </field> <field> <name>customer</name> - <rename/> </field> <field> <name>date_so_approved</name> - <rename/> </field> <field> <name>date_po_approved</name> - <rename/> </field> <field> <name>date_last_received</name> - <rename/> </field> <field> <name>date_last_send</name> - <rename/> </field> <field> <name>diff_po_so</name> - <rename/> </field> <field> <name>diff_po_so_in_hour</name> - <rename/> </field> <field> <name>diff_received_po</name> - <rename/> </field> <field> <name>diff_received_po_in_day</name> - <rename/> </field> <field> <name>diff_received_send</name> - <rename/> </field> <field> <name>diff_received_send_in_hour</name> - <rename/> </field> <field> <name>diff_received_send_in_day</name> - <rename/> </field> <field> <name>diff_so_send</name> - <rename/> </field> <field> <name>diff_so_send_in_day</name> - <rename/> </field> <field> <name>year_month</name> - <rename/> </field> <field> <name>year</name> - <rename/> </field> <field> <name>month</name> - <rename/> </field> <field> <name>day</name> - <rename/> </field> <field> <name>diff_po_so_in_day</name> - <rename/> </field> <select_unspecified>N</select_unspecified> </fields> @@ -815,7 +794,7 @@ <method>none</method> <schema_name/> </partitioning> - <connection>erp indoteknik production</connection> + <connection>erp indoteknik production (localhost)</connection> <sql>select * from v_leadtime_so_to_send_wf</sql> <limit>0</limit> <lookup/> diff --git a/import_leadtime_so_send_detail.ktr b/import_leadtime_so_send_detail.ktr index 7f15068..8c7b72a 100644 --- a/import_leadtime_so_send_detail.ktr +++ b/import_leadtime_so_send_detail.ktr @@ -430,20 +430,20 @@ <created_date>2023/03/16 14:05:50.350</created_date> <modified_user>-</modified_user> <modified_date>2023/03/16 14:05:50.350</modified_date> - <key_for_session_key/> + <key_for_session_key>H4sIAAAAAAAAAAMAAAAAAAAAAAA=</key_for_session_key> <is_key_private>N</is_key_private> </info> <notepads> </notepads> <connection> - <name>dw bi indoteknik</name> - <server>192.168.23.5</server> + <name>dw bi indoteknik (localhost)</name> + <server>localhost</server> <type>POSTGRESQL</type> <access>Native</access> <database>dw_bi_indoteknik</database> <port>5432</port> <username>odoo</username> - <password>Encrypted 2be98afc86aa7f2e4cb79ce10d196a0d5</password> + <password>Encrypted 2be98afc82bdfd8dd9a2ca45acc83f6c3</password> <servername/> <data_tablespace/> <index_tablespace/> @@ -478,7 +478,7 @@ </attribute> <attribute> <code>SUPPORTS_TIMESTAMP_DATA_TYPE</code> - <attribute>Y</attribute> + <attribute>N</attribute> </attribute> <attribute> <code>USE_POOLING</code> @@ -487,8 +487,8 @@ </attributes> </connection> <connection> - <name>erp indoteknik production</name> - <server>34.101.171.249</server> + <name>erp indoteknik production (localhost)</name> + <server>10.148.0.3</server> <type>POSTGRESQL</type> <access>Native</access> <database>erp_indoteknik</database> @@ -529,7 +529,7 @@ </attribute> <attribute> <code>SUPPORTS_TIMESTAMP_DATA_TYPE</code> - <attribute>Y</attribute> + <attribute>N</attribute> </attribute> <attribute> <code>USE_POOLING</code> @@ -550,6 +550,328 @@ </hop> </order> <step> + <name>Insert / update</name> + <type>InsertUpdate</type> + <description/> + <distribute>Y</distribute> + <custom_distribution/> + <copies>1</copies> + <partitioning> + <method>none</method> + <schema_name/> + </partitioning> + <connection>dw bi indoteknik (localhost)</connection> + <commit>100</commit> + <update_bypassed>N</update_bypassed> + <lookup> + <schema>public</schema> + <table>leadtime_so_to_send_detail</table> + <key> + <name>line_id</name> + <field>line_id</field> + <condition>=</condition> + <name2/> + </key> + <value> + <name>line_id</name> + <rename>line_id</rename> + <update>N</update> + </value> + <value> + <name>header_id</name> + <rename>header_id</rename> + <update>Y</update> + </value> + <value> + <name>so_number</name> + <rename>so_number</rename> + <update>Y</update> + </value> + <value> + <name>customer</name> + <rename>customer</rename> + <update>Y</update> + </value> + <value> + <name>date_so_approved</name> + <rename>date_so_approved</rename> + <update>Y</update> + </value> + <value> + <name>date_po_approved</name> + <rename>date_po_approved</rename> + <update>Y</update> + </value> + <value> + <name>date_last_received</name> + <rename>date_last_received</rename> + <update>Y</update> + </value> + <value> + <name>date_last_send</name> + <rename>date_last_send</rename> + <update>Y</update> + </value> + <value> + <name>diff_po_so</name> + <rename>diff_po_so</rename> + <update>Y</update> + </value> + <value> + <name>diff_po_so_in_hour</name> + <rename>diff_po_so_in_hour</rename> + <update>Y</update> + </value> + <value> + <name>diff_received_po</name> + <rename>diff_received_po</rename> + <update>Y</update> + </value> + <value> + <name>diff_received_po_in_day</name> + <rename>diff_received_po_in_day</rename> + <update>Y</update> + </value> + <value> + <name>diff_received_send</name> + <rename>diff_received_send</rename> + <update>Y</update> + </value> + <value> + <name>diff_received_send_in_hour</name> + <rename>diff_received_send_in_hour</rename> + <update>Y</update> + </value> + <value> + <name>diff_received_send_in_day</name> + <rename>diff_received_send_in_day</rename> + <update>Y</update> + </value> + <value> + <name>diff_so_send</name> + <rename>diff_so_send</rename> + <update>Y</update> + </value> + <value> + <name>diff_so_send_in_day</name> + <rename>diff_so_send_in_day</rename> + <update>Y</update> + </value> + <value> + <name>year_month</name> + <rename>year_month</rename> + <update>Y</update> + </value> + <value> + <name>year</name> + <rename>year</rename> + <update>Y</update> + </value> + <value> + <name>month</name> + <rename>month</rename> + <update>Y</update> + </value> + <value> + <name>day</name> + <rename>day</rename> + <update>Y</update> + </value> + <value> + <name>diff_po_so_in_day</name> + <rename>diff_po_so_in_day</rename> + <update>Y</update> + </value> + <value> + <name>salesperson</name> + <rename>salesperson</rename> + <update>Y</update> + </value> + <value> + <name>brand</name> + <rename>brand</rename> + <update>Y</update> + </value> + <value> + <name>product</name> + <rename>product</rename> + <update>Y</update> + </value> + <value> + <name>item_code</name> + <rename>item_code</rename> + <update>Y</update> + </value> + <value> + <name>product_uom_qty</name> + <rename>product_uom_qty</rename> + <update>Y</update> + </value> + <value> + <name>qty_delivered</name> + <rename>qty_delivered</rename> + <update>Y</update> + </value> + <value> + <name>qty_invoiced</name> + <rename>qty_invoiced</rename> + <update>Y</update> + </value> + <value> + <name>price_unit</name> + <rename>price_unit</rename> + <update>Y</update> + </value> + <value> + <name>price_subtotal</name> + <rename>price_subtotal</rename> + <update>Y</update> + </value> + <value> + <name>price_total</name> + <rename>price_total</rename> + <update>Y</update> + </value> + </lookup> + <attributes/> + <cluster_schema/> + <remotesteps> + <input> + </input> + <output> + </output> + </remotesteps> + <GUI> + <xloc>528</xloc> + <yloc>144</yloc> + <draw>Y</draw> + </GUI> + </step> + <step> + <name>Select values</name> + <type>SelectValues</type> + <description/> + <distribute>Y</distribute> + <custom_distribution/> + <copies>1</copies> + <partitioning> + <method>none</method> + <schema_name/> + </partitioning> + <fields> + <field> + <name>line_id</name> + </field> + <field> + <name>header_id</name> + </field> + <field> + <name>so_number</name> + </field> + <field> + <name>customer</name> + </field> + <field> + <name>date_so_approved</name> + </field> + <field> + <name>date_po_approved</name> + </field> + <field> + <name>date_last_received</name> + </field> + <field> + <name>date_last_send</name> + </field> + <field> + <name>diff_po_so</name> + </field> + <field> + <name>diff_po_so_in_hour</name> + </field> + <field> + <name>diff_received_po</name> + </field> + <field> + <name>diff_received_po_in_day</name> + </field> + <field> + <name>diff_received_send</name> + </field> + <field> + <name>diff_received_send_in_hour</name> + </field> + <field> + <name>diff_received_send_in_day</name> + </field> + <field> + <name>diff_so_send</name> + </field> + <field> + <name>diff_so_send_in_day</name> + </field> + <field> + <name>year_month</name> + </field> + <field> + <name>year</name> + </field> + <field> + <name>month</name> + </field> + <field> + <name>day</name> + </field> + <field> + <name>diff_po_so_in_day</name> + </field> + <field> + <name>salesperson</name> + </field> + <field> + <name>brand</name> + </field> + <field> + <name>product</name> + </field> + <field> + <name>item_code</name> + </field> + <field> + <name>product_uom_qty</name> + </field> + <field> + <name>qty_delivered</name> + </field> + <field> + <name>qty_invoiced</name> + </field> + <field> + <name>price_unit</name> + </field> + <field> + <name>price_subtotal</name> + </field> + <field> + <name>price_total</name> + </field> + <select_unspecified>N</select_unspecified> + </fields> + <attributes/> + <cluster_schema/> + <remotesteps> + <input> + </input> + <output> + </output> + </remotesteps> + <GUI> + <xloc>400</xloc> + <yloc>144</yloc> + <draw>Y</draw> + </GUI> + </step> + <step> <name>Table input</name> <type>TableInput</type> <description/> @@ -560,7 +882,7 @@ <method>none</method> <schema_name/> </partitioning> - <connection>erp indoteknik production</connection> + <connection>erp indoteknik production (localhost)</connection> <sql>select * from v_leadtime_so_to_send_detail_wf</sql> <limit>0</limit> <lookup/> @@ -758,7 +1080,7 @@ <storagetype>normal</storagetype> <name>diff_po_so</name> <length>-1</length> - <precision>6</precision> + <precision>-1</precision> <origin>Table input</origin> <comments>diff_po_so</comments> <conversion_Mask/> @@ -804,7 +1126,7 @@ <storagetype>normal</storagetype> <name>diff_received_po</name> <length>-1</length> - <precision>6</precision> + <precision>-1</precision> <origin>Table input</origin> <comments>diff_received_po</comments> <conversion_Mask/> @@ -850,7 +1172,7 @@ <storagetype>normal</storagetype> <name>diff_received_send</name> <length>-1</length> - <precision>6</precision> + <precision>-1</precision> <origin>Table input</origin> <comments>diff_received_send</comments> <conversion_Mask/> @@ -919,7 +1241,7 @@ <storagetype>normal</storagetype> <name>diff_so_send</name> <length>-1</length> - <precision>6</precision> + <precision>-1</precision> <origin>Table input</origin> <comments>diff_so_send</comments> <conversion_Mask/> @@ -1320,360 +1642,6 @@ <draw>Y</draw> </GUI> </step> - <step> - <name>Select values</name> - <type>SelectValues</type> - <description/> - <distribute>Y</distribute> - <custom_distribution/> - <copies>1</copies> - <partitioning> - <method>none</method> - <schema_name/> - </partitioning> - <fields> - <field> - <name>line_id</name> - <rename/> - </field> - <field> - <name>header_id</name> - <rename/> - </field> - <field> - <name>so_number</name> - <rename/> - </field> - <field> - <name>customer</name> - <rename/> - </field> - <field> - <name>date_so_approved</name> - <rename/> - </field> - <field> - <name>date_po_approved</name> - <rename/> - </field> - <field> - <name>date_last_received</name> - <rename/> - </field> - <field> - <name>date_last_send</name> - <rename/> - </field> - <field> - <name>diff_po_so</name> - <rename/> - </field> - <field> - <name>diff_po_so_in_hour</name> - <rename/> - </field> - <field> - <name>diff_received_po</name> - <rename/> - </field> - <field> - <name>diff_received_po_in_day</name> - <rename/> - </field> - <field> - <name>diff_received_send</name> - <rename/> - </field> - <field> - <name>diff_received_send_in_hour</name> - <rename/> - </field> - <field> - <name>diff_received_send_in_day</name> - <rename/> - </field> - <field> - <name>diff_so_send</name> - <rename/> - </field> - <field> - <name>diff_so_send_in_day</name> - <rename/> - </field> - <field> - <name>year_month</name> - <rename/> - </field> - <field> - <name>year</name> - <rename/> - </field> - <field> - <name>month</name> - <rename/> - </field> - <field> - <name>day</name> - <rename/> - </field> - <field> - <name>diff_po_so_in_day</name> - <rename/> - </field> - <field> - <name>salesperson</name> - <rename/> - </field> - <field> - <name>brand</name> - <rename/> - </field> - <field> - <name>product</name> - <rename/> - </field> - <field> - <name>item_code</name> - <rename/> - </field> - <field> - <name>product_uom_qty</name> - <rename/> - </field> - <field> - <name>qty_delivered</name> - <rename/> - </field> - <field> - <name>qty_invoiced</name> - <rename/> - </field> - <field> - <name>price_unit</name> - <rename/> - </field> - <field> - <name>price_subtotal</name> - <rename/> - </field> - <field> - <name>price_total</name> - <rename/> - </field> - <select_unspecified>N</select_unspecified> - </fields> - <attributes/> - <cluster_schema/> - <remotesteps> - <input> - </input> - <output> - </output> - </remotesteps> - <GUI> - <xloc>400</xloc> - <yloc>144</yloc> - <draw>Y</draw> - </GUI> - </step> - <step> - <name>Insert / update</name> - <type>InsertUpdate</type> - <description/> - <distribute>Y</distribute> - <custom_distribution/> - <copies>1</copies> - <partitioning> - <method>none</method> - <schema_name/> - </partitioning> - <connection>dw bi indoteknik</connection> - <commit>100</commit> - <update_bypassed>N</update_bypassed> - <lookup> - <schema>public</schema> - <table>leadtime_so_to_send_detail</table> - <key> - <name>line_id</name> - <field>line_id</field> - <condition>=</condition> - <name2/> - </key> - <value> - <name>line_id</name> - <rename>line_id</rename> - <update>N</update> - </value> - <value> - <name>header_id</name> - <rename>header_id</rename> - <update>Y</update> - </value> - <value> - <name>so_number</name> - <rename>so_number</rename> - <update>Y</update> - </value> - <value> - <name>customer</name> - <rename>customer</rename> - <update>Y</update> - </value> - <value> - <name>date_so_approved</name> - <rename>date_so_approved</rename> - <update>Y</update> - </value> - <value> - <name>date_po_approved</name> - <rename>date_po_approved</rename> - <update>Y</update> - </value> - <value> - <name>date_last_received</name> - <rename>date_last_received</rename> - <update>Y</update> - </value> - <value> - <name>date_last_send</name> - <rename>date_last_send</rename> - <update>Y</update> - </value> - <value> - <name>diff_po_so</name> - <rename>diff_po_so</rename> - <update>Y</update> - </value> - <value> - <name>diff_po_so_in_hour</name> - <rename>diff_po_so_in_hour</rename> - <update>Y</update> - </value> - <value> - <name>diff_received_po</name> - <rename>diff_received_po</rename> - <update>Y</update> - </value> - <value> - <name>diff_received_po_in_day</name> - <rename>diff_received_po_in_day</rename> - <update>Y</update> - </value> - <value> - <name>diff_received_send</name> - <rename>diff_received_send</rename> - <update>Y</update> - </value> - <value> - <name>diff_received_send_in_hour</name> - <rename>diff_received_send_in_hour</rename> - <update>Y</update> - </value> - <value> - <name>diff_received_send_in_day</name> - <rename>diff_received_send_in_day</rename> - <update>Y</update> - </value> - <value> - <name>diff_so_send</name> - <rename>diff_so_send</rename> - <update>Y</update> - </value> - <value> - <name>diff_so_send_in_day</name> - <rename>diff_so_send_in_day</rename> - <update>Y</update> - </value> - <value> - <name>year_month</name> - <rename>year_month</rename> - <update>Y</update> - </value> - <value> - <name>year</name> - <rename>year</rename> - <update>Y</update> - </value> - <value> - <name>month</name> - <rename>month</rename> - <update>Y</update> - </value> - <value> - <name>day</name> - <rename>day</rename> - <update>Y</update> - </value> - <value> - <name>diff_po_so_in_day</name> - <rename>diff_po_so_in_day</rename> - <update>Y</update> - </value> - <value> - <name>salesperson</name> - <rename>salesperson</rename> - <update>Y</update> - </value> - <value> - <name>brand</name> - <rename>brand</rename> - <update>Y</update> - </value> - <value> - <name>product</name> - <rename>product</rename> - <update>Y</update> - </value> - <value> - <name>item_code</name> - <rename>item_code</rename> - <update>Y</update> - </value> - <value> - <name>product_uom_qty</name> - <rename>product_uom_qty</rename> - <update>Y</update> - </value> - <value> - <name>qty_delivered</name> - <rename>qty_delivered</rename> - <update>Y</update> - </value> - <value> - <name>qty_invoiced</name> - <rename>qty_invoiced</rename> - <update>Y</update> - </value> - <value> - <name>price_unit</name> - <rename>price_unit</rename> - <update>Y</update> - </value> - <value> - <name>price_subtotal</name> - <rename>price_subtotal</rename> - <update>Y</update> - </value> - <value> - <name>price_total</name> - <rename>price_total</rename> - <update>Y</update> - </value> - </lookup> - <attributes/> - <cluster_schema/> - <remotesteps> - <input> - </input> - <output> - </output> - </remotesteps> - <GUI> - <xloc>528</xloc> - <yloc>144</yloc> - <draw>Y</draw> - </GUI> - </step> <step_error_handling> </step_error_handling> <slave-step-copy-partition-distribution> diff --git a/import_margin.ktr b/import_margin.ktr index 21e61b8..bef710a 100644 --- a/import_margin.ktr +++ b/import_margin.ktr @@ -436,14 +436,14 @@ <notepads> </notepads> <connection> - <name>dw bi indoteknik</name> - <server>192.168.23.5</server> + <name>dw bi indoteknik (localhost)</name> + <server>localhost</server> <type>POSTGRESQL</type> <access>Native</access> <database>dw_bi_indoteknik</database> <port>5432</port> <username>odoo</username> - <password>Encrypted 2be98afc86aa7f2e4cb79ce10d196a0d5</password> + <password>Encrypted 2be98afc82bdfd8dd9a2ca45acc83f6c3</password> <servername/> <data_tablespace/> <index_tablespace/> @@ -478,7 +478,7 @@ </attribute> <attribute> <code>SUPPORTS_TIMESTAMP_DATA_TYPE</code> - <attribute>Y</attribute> + <attribute>N</attribute> </attribute> <attribute> <code>USE_POOLING</code> @@ -487,8 +487,8 @@ </attributes> </connection> <connection> - <name>erp indoteknik production</name> - <server>34.101.171.249</server> + <name>erp indoteknik production (localhost)</name> + <server>10.148.0.3</server> <type>POSTGRESQL</type> <access>Native</access> <database>erp_indoteknik</database> @@ -529,7 +529,7 @@ </attribute> <attribute> <code>SUPPORTS_TIMESTAMP_DATA_TYPE</code> - <attribute>Y</attribute> + <attribute>N</attribute> </attribute> <attribute> <code>USE_POOLING</code> @@ -555,7 +555,7 @@ <method>none</method> <schema_name/> </partitioning> - <connection>erp indoteknik production</connection> + <connection>erp indoteknik production (localhost)</connection> <sql>select * from v_margin_sale_order</sql> <limit>0</limit> <lookup/> @@ -843,7 +843,7 @@ <method>none</method> <schema_name/> </partitioning> - <connection>dw bi indoteknik</connection> + <connection>dw bi indoteknik (localhost)</connection> <commit>100</commit> <update_bypassed>N</update_bypassed> <lookup> diff --git a/import_odoo_14_to_data_warehouse.ktr b/import_odoo_14_to_data_warehouse.ktr index c12bd7b..3791db9 100644 --- a/import_odoo_14_to_data_warehouse.ktr +++ b/import_odoo_14_to_data_warehouse.ktr @@ -436,14 +436,14 @@ <notepads> </notepads> <connection> - <name>dw bi indoteknik</name> - <server>192.168.23.5</server> + <name>dw bi indoteknik (localhost)</name> + <server>localhost</server> <type>POSTGRESQL</type> <access>Native</access> <database>dw_bi_indoteknik</database> <port>5432</port> <username>odoo</username> - <password>Encrypted 2be98afc86aa7f2e4cb79ce10d196a0d5</password> + <password>Encrypted 2be98afc82bdfd8dd9a2ca45acc83f6c3</password> <servername/> <data_tablespace/> <index_tablespace/> @@ -478,7 +478,7 @@ </attribute> <attribute> <code>SUPPORTS_TIMESTAMP_DATA_TYPE</code> - <attribute>Y</attribute> + <attribute>N</attribute> </attribute> <attribute> <code>USE_POOLING</code> @@ -487,8 +487,8 @@ </attributes> </connection> <connection> - <name>erp indoteknik production</name> - <server>34.101.171.249</server> + <name>erp indoteknik production (localhost)</name> + <server>10.148.0.3</server> <type>POSTGRESQL</type> <access>Native</access> <database>erp_indoteknik</database> @@ -529,7 +529,7 @@ </attribute> <attribute> <code>SUPPORTS_TIMESTAMP_DATA_TYPE</code> - <attribute>Y</attribute> + <attribute>N</attribute> </attribute> <attribute> <code>USE_POOLING</code> @@ -560,7 +560,7 @@ <method>none</method> <schema_name/> </partitioning> - <connection>dw bi indoteknik</connection> + <connection>dw bi indoteknik (localhost)</connection> <commit>100</commit> <update_bypassed>N</update_bypassed> <lookup> @@ -771,7 +771,7 @@ <method>none</method> <schema_name/> </partitioning> - <connection>erp indoteknik production</connection> + <connection>erp indoteknik production (localhost)</connection> <sql>select * from v_total_omzet_by_invoice</sql> <limit>0</limit> <lookup/> diff --git a/import_sale_order.ktr b/import_sale_order.ktr index 360cf8a..f165134 100644 --- a/import_sale_order.ktr +++ b/import_sale_order.ktr @@ -430,20 +430,20 @@ <created_date>2023/08/09 14:54:40.577</created_date> <modified_user>-</modified_user> <modified_date>2023/08/09 14:54:40.577</modified_date> - <key_for_session_key/> + <key_for_session_key>H4sIAAAAAAAAAAMAAAAAAAAAAAA=</key_for_session_key> <is_key_private>N</is_key_private> </info> <notepads> </notepads> <connection> - <name>dw bi indoteknik</name> - <server>192.168.23.5</server> + <name>dw bi indoteknik (localhost)</name> + <server>localhost</server> <type>POSTGRESQL</type> <access>Native</access> <database>dw_bi_indoteknik</database> <port>5432</port> <username>odoo</username> - <password>Encrypted 2be98afc86aa7f2e4cb79ce10d196a0d5</password> + <password>Encrypted 2be98afc82bdfd8dd9a2ca45acc83f6c3</password> <servername/> <data_tablespace/> <index_tablespace/> @@ -478,7 +478,7 @@ </attribute> <attribute> <code>SUPPORTS_TIMESTAMP_DATA_TYPE</code> - <attribute>Y</attribute> + <attribute>N</attribute> </attribute> <attribute> <code>USE_POOLING</code> @@ -487,8 +487,8 @@ </attributes> </connection> <connection> - <name>erp indoteknik production</name> - <server>34.101.171.249</server> + <name>erp indoteknik production (localhost)</name> + <server>10.148.0.3</server> <type>POSTGRESQL</type> <access>Native</access> <database>erp_indoteknik</database> @@ -529,7 +529,7 @@ </attribute> <attribute> <code>SUPPORTS_TIMESTAMP_DATA_TYPE</code> - <attribute>Y</attribute> + <attribute>N</attribute> </attribute> <attribute> <code>USE_POOLING</code> @@ -545,6 +545,159 @@ </hop> </order> <step> + <name>Insert / update</name> + <type>InsertUpdate</type> + <description/> + <distribute>Y</distribute> + <custom_distribution/> + <copies>1</copies> + <partitioning> + <method>none</method> + <schema_name/> + </partitioning> + <connection>dw bi indoteknik (localhost)</connection> + <commit>100</commit> + <update_bypassed>N</update_bypassed> + <lookup> + <schema>public</schema> + <table>sale_order</table> + <key> + <name>orderline_id</name> + <field>orderline_id</field> + <condition>=</condition> + <name2/> + </key> + <value> + <name>orderline_id</name> + <rename>orderline_id</rename> + <update>N</update> + </value> + <value> + <name>order_id</name> + <rename>order_id</rename> + <update>Y</update> + </value> + <value> + <name>documentno</name> + <rename>documentno</rename> + <update>Y</update> + </value> + <value> + <name>industry</name> + <rename>industry</rename> + <update>Y</update> + </value> + <value> + <name>customer</name> + <rename>customer</rename> + <update>Y</update> + </value> + <value> + <name>date_order</name> + <rename>date_order</rename> + <update>Y</update> + </value> + <value> + <name>write_date</name> + <rename>write_date</rename> + <update>Y</update> + </value> + <value> + <name>brand</name> + <rename>brand</rename> + <update>Y</update> + </value> + <value> + <name>product</name> + <rename>product</rename> + <update>Y</update> + </value> + <value> + <name>item_code</name> + <rename>item_code</rename> + <update>Y</update> + </value> + <value> + <name>qty</name> + <rename>qty</rename> + <update>Y</update> + </value> + <value> + <name>price_unit</name> + <rename>price_unit</rename> + <update>Y</update> + </value> + <value> + <name>discount</name> + <rename>discount</rename> + <update>Y</update> + </value> + <value> + <name>price_subtotal</name> + <rename>price_subtotal</rename> + <update>Y</update> + </value> + <value> + <name>price_total</name> + <rename>price_total</rename> + <update>Y</update> + </value> + <value> + <name>state</name> + <rename>state</rename> + <update>Y</update> + </value> + <value> + <name>salesperson</name> + <rename>salesperson</rename> + <update>Y</update> + </value> + <value> + <name>year_month_invoice_date</name> + <rename>year_month_invoice_date</rename> + <update>Y</update> + </value> + <value> + <name>year</name> + <rename>year</rename> + <update>Y</update> + </value> + <value> + <name>month</name> + <rename>month</rename> + <update>Y</update> + </value> + <value> + <name>quarter</name> + <rename>quarter</rename> + <update>Y</update> + </value> + <value> + <name>product_id</name> + <rename>product_id</rename> + <update>Y</update> + </value> + <value> + <name>brand_id</name> + <rename>brand_id</rename> + <update>Y</update> + </value> + </lookup> + <attributes/> + <cluster_schema/> + <remotesteps> + <input> + </input> + <output> + </output> + </remotesteps> + <GUI> + <xloc>400</xloc> + <yloc>112</yloc> + <draw>Y</draw> + </GUI> + </step> + <step> <name>Table input</name> <type>TableInput</type> <description/> @@ -555,7 +708,7 @@ <method>none</method> <schema_name/> </partitioning> - <connection>erp indoteknik production</connection> + <connection>erp indoteknik production (localhost)</connection> <sql>select * from v_sale_order</sql> <limit>0</limit> <lookup/> @@ -1062,159 +1215,6 @@ <draw>Y</draw> </GUI> </step> - <step> - <name>Insert / update</name> - <type>InsertUpdate</type> - <description/> - <distribute>Y</distribute> - <custom_distribution/> - <copies>1</copies> - <partitioning> - <method>none</method> - <schema_name/> - </partitioning> - <connection>dw bi indoteknik</connection> - <commit>100</commit> - <update_bypassed>N</update_bypassed> - <lookup> - <schema>public</schema> - <table>sale_order</table> - <key> - <name>orderline_id</name> - <field>orderline_id</field> - <condition>=</condition> - <name2/> - </key> - <value> - <name>orderline_id</name> - <rename>orderline_id</rename> - <update>N</update> - </value> - <value> - <name>order_id</name> - <rename>order_id</rename> - <update>Y</update> - </value> - <value> - <name>documentno</name> - <rename>documentno</rename> - <update>Y</update> - </value> - <value> - <name>industry</name> - <rename>industry</rename> - <update>Y</update> - </value> - <value> - <name>customer</name> - <rename>customer</rename> - <update>Y</update> - </value> - <value> - <name>date_order</name> - <rename>date_order</rename> - <update>Y</update> - </value> - <value> - <name>write_date</name> - <rename>write_date</rename> - <update>Y</update> - </value> - <value> - <name>brand</name> - <rename>brand</rename> - <update>Y</update> - </value> - <value> - <name>product</name> - <rename>product</rename> - <update>Y</update> - </value> - <value> - <name>item_code</name> - <rename>item_code</rename> - <update>Y</update> - </value> - <value> - <name>qty</name> - <rename>qty</rename> - <update>Y</update> - </value> - <value> - <name>price_unit</name> - <rename>price_unit</rename> - <update>Y</update> - </value> - <value> - <name>discount</name> - <rename>discount</rename> - <update>Y</update> - </value> - <value> - <name>price_subtotal</name> - <rename>price_subtotal</rename> - <update>Y</update> - </value> - <value> - <name>price_total</name> - <rename>price_total</rename> - <update>Y</update> - </value> - <value> - <name>state</name> - <rename>state</rename> - <update>Y</update> - </value> - <value> - <name>salesperson</name> - <rename>salesperson</rename> - <update>Y</update> - </value> - <value> - <name>year_month_invoice_date</name> - <rename>year_month_invoice_date</rename> - <update>Y</update> - </value> - <value> - <name>year</name> - <rename>year</rename> - <update>Y</update> - </value> - <value> - <name>month</name> - <rename>month</rename> - <update>Y</update> - </value> - <value> - <name>quarter</name> - <rename>quarter</rename> - <update>Y</update> - </value> - <value> - <name>product_id</name> - <rename>product_id</rename> - <update>Y</update> - </value> - <value> - <name>brand_id</name> - <rename>brand_id</rename> - <update>Y</update> - </value> - </lookup> - <attributes/> - <cluster_schema/> - <remotesteps> - <input> - </input> - <output> - </output> - </remotesteps> - <GUI> - <xloc>400</xloc> - <yloc>112</yloc> - <draw>Y</draw> - </GUI> - </step> <step_error_handling> </step_error_handling> <slave-step-copy-partition-distribution> diff --git a/refresh_materialized_view_fixco.ktr b/refresh_materialized_view_fixco.ktr index af911f3..eaf94a6 100644 --- a/refresh_materialized_view_fixco.ktr +++ b/refresh_materialized_view_fixco.ktr @@ -436,14 +436,14 @@ <notepads> </notepads> <connection> - <name>dw bi fixco</name> - <server>192.168.23.5</server> + <name>dw bi fixco (localhost)</name> + <server>localhost</server> <type>POSTGRESQL</type> <access>Native</access> <database>dw_bi_fixco</database> <port>5432</port> <username>odoo</username> - <password>Encrypted 2be98afc86aa7f2e4cb79ce10d196a0d5</password> + <password>Encrypted 2be98afc82bdfd8dd9a2ca45acc83f6c3</password> <servername/> <data_tablespace/> <index_tablespace/> @@ -524,7 +524,7 @@ <method>none</method> <schema_name/> </partitioning> - <connection>dw bi fixco</connection> + <connection>dw bi fixco (localhost)</connection> <execute_each_row>N</execute_each_row> <single_statement>N</single_statement> <replace_variables>N</replace_variables> @@ -562,7 +562,7 @@ <method>none</method> <schema_name/> </partitioning> - <connection>dw bi fixco</connection> + <connection>dw bi fixco (localhost)</connection> <execute_each_row>N</execute_each_row> <single_statement>N</single_statement> <replace_variables>N</replace_variables> @@ -600,7 +600,7 @@ <method>none</method> <schema_name/> </partitioning> - <connection>dw bi fixco</connection> + <connection>dw bi fixco (localhost)</connection> <execute_each_row>N</execute_each_row> <single_statement>N</single_statement> <replace_variables>N</replace_variables> @@ -638,7 +638,7 @@ <method>none</method> <schema_name/> </partitioning> - <connection>dw bi fixco</connection> + <connection>dw bi fixco (localhost)</connection> <execute_each_row>N</execute_each_row> <single_statement>N</single_statement> <replace_variables>N</replace_variables> @@ -676,7 +676,7 @@ <method>none</method> <schema_name/> </partitioning> - <connection>dw bi fixco</connection> + <connection>dw bi fixco (localhost)</connection> <execute_each_row>N</execute_each_row> <single_statement>N</single_statement> <replace_variables>N</replace_variables> @@ -714,7 +714,7 @@ <method>none</method> <schema_name/> </partitioning> - <connection>dw bi fixco</connection> + <connection>dw bi fixco (localhost)</connection> <execute_each_row>N</execute_each_row> <single_statement>N</single_statement> <replace_variables>N</replace_variables> diff --git a/refresh_materialized_view_pricelist.ktr b/refresh_materialized_view_pricelist.ktr index ba3da1d..4f65ce0 100644 --- a/refresh_materialized_view_pricelist.ktr +++ b/refresh_materialized_view_pricelist.ktr @@ -430,20 +430,20 @@ <created_date>2023/08/22 14:26:27.126</created_date> <modified_user>-</modified_user> <modified_date>2023/08/22 14:26:27.126</modified_date> - <key_for_session_key/> + <key_for_session_key>H4sIAAAAAAAAAAMAAAAAAAAAAAA=</key_for_session_key> <is_key_private>N</is_key_private> </info> <notepads> </notepads> <connection> - <name>dw bi indoteknik</name> - <server>192.168.23.5</server> + <name>dw bi indoteknik (localhost)</name> + <server>localhost</server> <type>POSTGRESQL</type> <access>Native</access> <database>dw_bi_indoteknik</database> <port>5432</port> <username>odoo</username> - <password>Encrypted 2be98afc86aa7f2e4cb79ce10d196a0d5</password> + <password>Encrypted 2be98afc82bdfd8dd9a2ca45acc83f6c3</password> <servername/> <data_tablespace/> <index_tablespace/> @@ -478,7 +478,7 @@ </attribute> <attribute> <code>SUPPORTS_TIMESTAMP_DATA_TYPE</code> - <attribute>Y</attribute> + <attribute>N</attribute> </attribute> <attribute> <code>USE_POOLING</code> @@ -499,7 +499,7 @@ <method>none</method> <schema_name/> </partitioning> - <connection>dw bi indoteknik</connection> + <connection>dw bi indoteknik (localhost)</connection> <execute_each_row>N</execute_each_row> <single_statement>N</single_statement> <replace_variables>N</replace_variables> |