diff options
| author | stephanchrst <stephanchrst@gmail.com> | 2023-09-20 10:49:12 +0700 |
|---|---|---|
| committer | stephanchrst <stephanchrst@gmail.com> | 2023-09-20 10:49:12 +0700 |
| commit | 378be935ef27121019d2e648212e34b05e02fe3b (patch) | |
| tree | ac82a2482e9ed746b2d7645f6302612892b83374 /import_adempiere_to_data_warehouse.ktr | |
| parent | c6aa658ff158e8758065649e4cb7162bdd0315b3 (diff) | |
migrate to gcp (test)
Diffstat (limited to 'import_adempiere_to_data_warehouse.ktr')
| -rw-r--r-- | import_adempiere_to_data_warehouse.ktr | 68 |
1 files changed, 52 insertions, 16 deletions
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> |