From 378be935ef27121019d2e648212e34b05e02fe3b Mon Sep 17 00:00:00 2001
From: stephanchrst <stephanchrst@gmail.com>
Date: Wed, 20 Sep 2023 10:49:12 +0700
Subject: migrate to gcp (test)

---
 import_adempiere_to_data_warehouse.ktr | 68 ++++++++++++++++++++++++++--------
 1 file changed, 52 insertions(+), 16 deletions(-)

(limited to 'import_adempiere_to_data_warehouse.ktr')

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
@@ -486,6 +486,57 @@
       </attribute>
     </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>
@@ -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>
-- 
cgit v1.2.3