| <?xml version="1.0" encoding="UTF-8"?> |
| <!-- |
| |
| Licensed to the Apache Software Foundation (ASF) under one or more |
| contributor license agreements. See the NOTICE file distributed with |
| this work for additional information regarding copyright ownership. |
| The ASF licenses this file to You under the Apache License, Version 2.0 |
| (the "License"); you may not use this file except in compliance with |
| the License. You may obtain a copy of the License at |
| |
| http://www.apache.org/licenses/LICENSE-2.0 |
| |
| Unless required by applicable law or agreed to in writing, software |
| distributed under the License is distributed on an "AS IS" BASIS, |
| WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. |
| See the License for the specific language governing permissions and |
| limitations under the License. |
| |
| --> |
| <pipeline> |
| <info> |
| <name>0009-getConnectionValues</name> |
| <name_sync_with_filename>Y</name_sync_with_filename> |
| <description/> |
| <extended_description/> |
| <pipeline_version/> |
| <pipeline_type>Normal</pipeline_type> |
| <pipeline_status>0</pipeline_status> |
| <parameters> |
| </parameters> |
| <capture_transform_performance>N</capture_transform_performance> |
| <transform_performance_capturing_delay>1000</transform_performance_capturing_delay> |
| <transform_performance_capturing_size_limit/> |
| <created_user>-</created_user> |
| <created_date>2017/05/17 13:55:11.297</created_date> |
| <modified_user>-</modified_user> |
| <modified_date>2017/05/17 13:55:11.297</modified_date> |
| <key_for_session_key>H4sIAAAAAAAAAAMAAAAAAAAAAAA=</key_for_session_key> |
| <is_key_private>N</is_key_private> |
| </info> |
| <notepads> |
| <notepad> |
| <note>semi-colon delimited file specs: (no header) |
| |
| field list: |
| tenantname |
| type (see types list below) |
| url |
| dbName (for s3, use s3 bucket path) |
| port |
| username (for s3 use ACCESS_KEY) |
| pw (for s3 use SECRET_ACCESS_KEY) |
| environment |
| |
| |
| types: |
| s3 (for amazon s3) |
| com (for direct db connection) |
| </note> |
| <xloc>144</xloc> |
| <yloc>240</yloc> |
| <width>277</width> |
| <heigth>330</heigth> |
| <fontname>.SF NS Text</fontname> |
| <fontsize>13</fontsize> |
| <fontbold>N</fontbold> |
| <fontitalic>N</fontitalic> |
| <fontcolorred>0</fontcolorred> |
| <fontcolorgreen>0</fontcolorgreen> |
| <fontcolorblue>0</fontcolorblue> |
| <backgroundcolorred>255</backgroundcolorred> |
| <backgroundcolorgreen>205</backgroundcolorgreen> |
| <backgroundcolorblue>112</backgroundcolorblue> |
| <bordercolorred>100</bordercolorred> |
| <bordercolorgreen>100</bordercolorgreen> |
| <bordercolorblue>100</bordercolorblue> |
| </notepad> |
| </notepads> |
| <order> |
| <hop> |
| <from>Text file input</from> |
| <to>If Null</to> |
| <enabled>Y</enabled> |
| </hop> |
| <hop> |
| <from>If Null</from> |
| <to>Get variables</to> |
| <enabled>Y</enabled> |
| </hop> |
| <hop> |
| <from>Get variables</from> |
| <to>Copy rows to result</to> |
| <enabled>Y</enabled> |
| </hop> |
| </order> |
| <transform> |
| <name>Copy rows to result</name> |
| <type>RowsToResult</type> |
| <description/> |
| <distribute>Y</distribute> |
| <custom_distribution/> |
| <copies>1</copies> |
| <partitioning> |
| <method>none</method> |
| <schema_name/> |
| </partitioning> |
| <attributes/> |
| <GUI> |
| <xloc>768</xloc> |
| <yloc>128</yloc> |
| </GUI> |
| </transform> |
| <transform> |
| <name>Get variables</name> |
| <type>GetVariable</type> |
| <description/> |
| <distribute>N</distribute> |
| <custom_distribution/> |
| <copies>1</copies> |
| <partitioning> |
| <method>none</method> |
| <schema_name/> |
| </partitioning> |
| <fields> |
| <field> |
| <name>env</name> |
| <variable>${environment}</variable> |
| <type>String</type> |
| <format/> |
| <currency/> |
| <decimal/> |
| <group/> |
| <length>-1</length> |
| <precision>-1</precision> |
| <trim_type>none</trim_type> |
| </field> |
| </fields> |
| <attributes/> |
| <GUI> |
| <xloc>512</xloc> |
| <yloc>128</yloc> |
| </GUI> |
| </transform> |
| <transform> |
| <name>If Null</name> |
| <type>IfNull</type> |
| <description/> |
| <distribute>Y</distribute> |
| <custom_distribution/> |
| <copies>1</copies> |
| <partitioning> |
| <method>none</method> |
| <schema_name/> |
| </partitioning> |
| <replaceAllByValue/> |
| <replaceAllMask/> |
| <selectFields>Y</selectFields> |
| <selectValuesType>N</selectValuesType> |
| <setEmptyStringAll>N</setEmptyStringAll> |
| <valuetypes> |
| </valuetypes> |
| <fields> |
| <field> |
| <name>url</name> |
| <value/> |
| <mask/> |
| <set_empty_string>N</set_empty_string> |
| </field> |
| <field> |
| <name>dbName</name> |
| <value/> |
| <mask/> |
| <set_empty_string>N</set_empty_string> |
| </field> |
| <field> |
| <name>port</name> |
| <value/> |
| <mask/> |
| <set_empty_string>N</set_empty_string> |
| </field> |
| <field> |
| <name>username</name> |
| <value/> |
| <mask/> |
| <set_empty_string>N</set_empty_string> |
| </field> |
| <field> |
| <name>pw</name> |
| <value/> |
| <mask/> |
| <set_empty_string>N</set_empty_string> |
| </field> |
| </fields> |
| <attributes/> |
| <GUI> |
| <xloc>304</xloc> |
| <yloc>128</yloc> |
| </GUI> |
| </transform> |
| <transform> |
| <name>Text file input</name> |
| <type>TextFileInput</type> |
| <description/> |
| <distribute>Y</distribute> |
| <custom_distribution/> |
| <copies>1</copies> |
| <partitioning> |
| <method>none</method> |
| <schema_name/> |
| </partitioning> |
| <accept_filenames>N</accept_filenames> |
| <passing_through_fields>N</passing_through_fields> |
| <accept_field/> |
| <accept_transform_name/> |
| <separator>;</separator> |
| <enclosure>"</enclosure> |
| <enclosure_breaks>N</enclosure_breaks> |
| <escapechar/> |
| <header>N</header> |
| <nr_headerlines>1</nr_headerlines> |
| <footer>N</footer> |
| <nr_footerlines>1</nr_footerlines> |
| <line_wrapped>N</line_wrapped> |
| <nr_wraps>1</nr_wraps> |
| <layout_paged>N</layout_paged> |
| <nr_lines_per_page>80</nr_lines_per_page> |
| <nr_lines_doc_header>0</nr_lines_doc_header> |
| <noempty>Y</noempty> |
| <include>N</include> |
| <include_field/> |
| <rownum>N</rownum> |
| <rownumByFile>N</rownumByFile> |
| <rownum_field/> |
| <format>mixed</format> |
| <encoding/> |
| <add_to_result_filenames>Y</add_to_result_filenames> |
| <file> |
| <name>${HOP_DATASETS_FOLDER}/tenantconfig.txt</name> |
| <filemask/> |
| <exclude_filemask/> |
| <file_required>N</file_required> |
| <include_subfolders>N</include_subfolders> |
| <type>CSV</type> |
| <compression>None</compression> |
| </file> |
| <filters> |
| </filters> |
| <fields> |
| <field> |
| <name>tenant</name> |
| <type>String</type> |
| <format/> |
| <currency/> |
| <decimal/> |
| <group>N</group> |
| <nullif/> |
| <ifnull/> |
| <position>-1</position> |
| <length>-1</length> |
| <precision>-1</precision> |
| <trim_type>none</trim_type> |
| <repeat>N</repeat> |
| </field> |
| <field> |
| <name>type</name> |
| <type>String</type> |
| <format/> |
| <currency/> |
| <decimal/> |
| <group>N</group> |
| <nullif/> |
| <ifnull/> |
| <position>-1</position> |
| <length>-1</length> |
| <precision>-1</precision> |
| <trim_type>none</trim_type> |
| <repeat>N</repeat> |
| </field> |
| <field> |
| <name>url</name> |
| <type>String</type> |
| <format/> |
| <currency/> |
| <decimal/> |
| <group>N</group> |
| <nullif/> |
| <ifnull/> |
| <position>-1</position> |
| <length>-1</length> |
| <precision>-1</precision> |
| <trim_type>none</trim_type> |
| <repeat>N</repeat> |
| </field> |
| <field> |
| <name>dbName</name> |
| <type>String</type> |
| <format/> |
| <currency/> |
| <decimal/> |
| <group>N</group> |
| <nullif/> |
| <ifnull/> |
| <position>-1</position> |
| <length>-1</length> |
| <precision>-1</precision> |
| <trim_type>none</trim_type> |
| <repeat>N</repeat> |
| </field> |
| <field> |
| <name>port</name> |
| <type>String</type> |
| <format/> |
| <currency/> |
| <decimal/> |
| <group>N</group> |
| <nullif/> |
| <ifnull/> |
| <position>-1</position> |
| <length>-1</length> |
| <precision>-1</precision> |
| <trim_type>none</trim_type> |
| <repeat>N</repeat> |
| </field> |
| <field> |
| <name>username</name> |
| <type>String</type> |
| <format/> |
| <currency/> |
| <decimal/> |
| <group>N</group> |
| <nullif/> |
| <ifnull/> |
| <position>-1</position> |
| <length>-1</length> |
| <precision>-1</precision> |
| <trim_type>none</trim_type> |
| <repeat>N</repeat> |
| </field> |
| <field> |
| <name>pw</name> |
| <type>String</type> |
| <format/> |
| <currency/> |
| <decimal/> |
| <group>N</group> |
| <nullif/> |
| <ifnull/> |
| <position>-1</position> |
| <length>-1</length> |
| <precision>-1</precision> |
| <trim_type>none</trim_type> |
| <repeat>N</repeat> |
| </field> |
| <field> |
| <name>environment</name> |
| <type>String</type> |
| <format/> |
| <currency/> |
| <decimal/> |
| <group>N</group> |
| <nullif/> |
| <ifnull/> |
| <position>-1</position> |
| <length>-1</length> |
| <precision>-1</precision> |
| <trim_type>none</trim_type> |
| <repeat>N</repeat> |
| </field> |
| </fields> |
| <limit>0</limit> |
| <error_ignored>N</error_ignored> |
| <skip_bad_files>N</skip_bad_files> |
| <file_error_field/> |
| <file_error_message_field/> |
| <error_line_skipped>N</error_line_skipped> |
| <error_count_field/> |
| <error_fields_field/> |
| <error_text_field/> |
| <bad_line_files_destination_directory/> |
| <bad_line_files_extension>warning</bad_line_files_extension> |
| <error_line_files_destination_directory/> |
| <error_line_files_extension>error</error_line_files_extension> |
| <line_number_files_destination_directory/> |
| <line_number_files_extension>line</line_number_files_extension> |
| <date_format_lenient>Y</date_format_lenient> |
| <date_format_locale>en_US</date_format_locale> |
| <shortFileFieldName/> |
| <pathFieldName/> |
| <hiddenFieldName/> |
| <lastModificationTimeFieldName/> |
| <uriNameFieldName/> |
| <rootUriNameFieldName/> |
| <extensionFieldName/> |
| <sizeFieldName/> |
| <attributes/> |
| <GUI> |
| <xloc>160</xloc> |
| <yloc>128</yloc> |
| </GUI> |
| </transform> |
| <transform_error_handling> |
| </transform_error_handling> |
| <attributes/> |
| </pipeline> |