diff options
| -rw-r--r-- | calculate_pareto_status.ktr | 30 |
1 files changed, 15 insertions, 15 deletions
diff --git a/calculate_pareto_status.ktr b/calculate_pareto_status.ktr index 36745cb..1cb14ff 100644 --- a/calculate_pareto_status.ktr +++ b/calculate_pareto_status.ktr @@ -436,14 +436,14 @@ <notepads> </notepads> <connection> - <name>dw bi indoteknik</name> + <name>dw bi indoteknik (localhost)</name> <server>localhost</server> <type>POSTGRESQL</type> <access>Native</access> <database>dw_bi_indoteknik</database> - <port>5703</port> - <username>metabase</username> - <password>Encrypted 2be98dfba28d7bf86853c9f58cfc4f889</password> + <port>5432</port> + <username>odoo</username> + <password>Encrypted 2be98afc82bdfd8dd9a2ca45acc83f6c3</password> <servername/> <data_tablespace/> <index_tablespace/> @@ -462,7 +462,7 @@ </attribute> <attribute> <code>PORT_NUMBER</code> - <attribute>5703</attribute> + <attribute>5432</attribute> </attribute> <attribute> <code>PRESERVE_RESERVED_WORD_CASE</code> @@ -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,12 +487,12 @@ </attributes> </connection> <connection> - <name>erp indoteknik production</name> - <server>localhost</server> + <name>erp indoteknik production (localhost)</name> + <server>10.148.0.3</server> <type>POSTGRESQL</type> <access>Native</access> <database>erp_indoteknik</database> - <port>5901</port> + <port>5432</port> <username>odoo</username> <password>Encrypted 2be98afc82bdfd8dd9a2ca45acc83f6c3</password> <servername/> @@ -513,7 +513,7 @@ </attribute> <attribute> <code>PORT_NUMBER</code> - <attribute>5901</attribute> + <attribute>5432</attribute> </attribute> <attribute> <code>PRESERVE_RESERVED_WORD_CASE</code> @@ -529,7 +529,7 @@ </attribute> <attribute> <code>SUPPORTS_TIMESTAMP_DATA_TYPE</code> - <attribute>Y</attribute> + <attribute>N</attribute> </attribute> <attribute> <code>USE_POOLING</code> @@ -1012,7 +1012,7 @@ <method>none</method> <schema_name/> </partitioning> - <connection>erp indoteknik production</connection> + <connection>erp indoteknik production (localhost)</connection> <skip_lookup>N</skip_lookup> <commit>100</commit> <use_batch>N</use_batch> @@ -1057,7 +1057,7 @@ <method>none</method> <schema_name/> </partitioning> - <connection>dw bi indoteknik</connection> + <connection>dw bi indoteknik (localhost)</connection> <skip_lookup>N</skip_lookup> <commit>100</commit> <use_batch>N</use_batch> @@ -1102,7 +1102,7 @@ <method>none</method> <schema_name/> </partitioning> - <connection>dw bi indoteknik</connection> + <connection>dw bi indoteknik (localhost)</connection> <sql>select am.partner_id, sum(coalesce(am.amount_untaxed, 0)) as value, count(am."name") as trx from account_move am where 1=1 @@ -1330,7 +1330,7 @@ order by am.partner_id</sql> <method>none</method> <schema_name/> </partitioning> - <connection>dw bi indoteknik</connection> + <connection>dw bi indoteknik (localhost)</connection> <sql>select id, name from res_partner where pareto_status is null |