summaryrefslogtreecommitdiff
path: root/import_accurate_to_data_warehouse.ktr
diff options
context:
space:
mode:
authorstephanchrst <stephanchrst@gmail.com>2023-09-20 10:49:12 +0700
committerstephanchrst <stephanchrst@gmail.com>2023-09-20 10:49:12 +0700
commit378be935ef27121019d2e648212e34b05e02fe3b (patch)
treeac82a2482e9ed746b2d7645f6302612892b83374 /import_accurate_to_data_warehouse.ktr
parentc6aa658ff158e8758065649e4cb7162bdd0315b3 (diff)
migrate to gcp (test)
Diffstat (limited to 'import_accurate_to_data_warehouse.ktr')
-rw-r--r--import_accurate_to_data_warehouse.ktr24
1 files changed, 9 insertions, 15 deletions
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>