Invantive Estate

This function is specifically for system administrators.

With 'Administration: Run ETL Process' you can execute programs for the moving of data in the background. This can be used for:

•Retrieving actual figures from the general ledger system and reading them again in the ERP interface.

•Geocoding of locations with the help of Google Geocode API.

•Offering of instructions to an application such as Basware for payments are refactored.

The programs can be developed with the Kettle of Pentaho Data Integration.

An ETL program gets the following parameters:

•BUBS_DB_SERVER: name of the server in the JDBC connection with the name 'bubs_tomcat'.

•BUBS_DB_PORT: port in the JDBC connection with the name 'bubs_tomcat'.

•BUBS_DB_NAME: name of the database in the JDBC connection with the name 'bubs_tomcat'.

•BUBS_DB_USER: name of the database user in the JDBC connection with the name 'bubs_tomcat'.

•BUBS_DB_PASSWORD: password of the database user in the JDBC connection with the name 'bubs_tomcat'.

•BUBS_JOB_GBR_AANMELD_CODE: login code of the application user that requested the background process.

•BUBS_JOB_BJB_SEQ: number of the background process.

•BUBS_JOB_SCT_CODE: code of the background script that is running.

•BUBS_JOB_SDR_CODE: code of the background planner that executes the background process.

•Plus all parameters that the background script has.

 

Login

Per Kettle program (transformation of job) you can create connections. If you want to connect with the application, give this connection the name 'bubs' with the following specification:

<connection>

   <name>bubs</name>

   <server>${BUBS_DB_SERVER}</server>

   <type>ORACLE</type>

   <access>Native</access>

   <database>${BUBS_DB_NAME}</database>

   <port>${BUBS_DB_PORT}</port>

   <username>${BUBS_DB_USER}</username>

   <password>${BUBS_DB_PASSWORD}</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>1521</attribute></attribute>

     <attribute><code>QUOTE_ALL_FIELDS</code><attribute>N</attribute></attribute>

     <attribute><code>SUPPORTS_BOOLEAN_DATA_TYPE</code><attribute>N</attribute></attribute>

     <attribute><code>USE_POOLING</code><attribute>N</attribute></attribute>

     <attribute><code>SQL_CONNECT</code><attribute>/* Log on to middle tier. */

insert into bubs_pre_laden_r

(action_requested, action_parameter1, action_parameter2, action_parameter3, action_parameter4, action_parameter5, action_parameter6, action_parameter7, action_parameter8, action_parameter9)

values

( &apos;LOGON FULL&apos;

, &apos;$Header: http://svn.invantive.com/repos/p104/trunk/help/nl/manual/Topics/draai-etl-proces.xml 19891 2012-10-09 13:23:03Z gle3 $&apos;

, &apos;ETL&apos;

, &apos;${BUBS_JOB_GBR_AANMELD_CODE}&apos;

, &apos;Job ${BUBS_JOB_BJB_SEQ}&apos;

, null

, null

, null

, &apos;$Header: http://svn.invantive.com/repos/p104/trunk/help/nl/manual/Topics/draai-etl-proces.xml 19891 2012-10-09 13:23:03Z gle3 $&apos; || to_char(sysdate, &apos;YYYYMMDDHH24MISS&apos;)

, null

)

</attribute></attribute>

   </attributes>

 </connection>