<commit_before><?xml version="1.0" encoding="UTF-8"?>
<!--

    Copyright 2017 StreamSets Inc.

    Licensed 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.

-->
<!DOCTYPE task PUBLIC "-//OASIS//DTD DITA Task//EN" "task.dtd">
<task id="task_qpj_ncy_hw">
    <title>Configuring a JDBC Tee</title>
    <taskbody>
        <context><p><indexterm>JDBC Tee processor<indexterm>configuring</indexterm></indexterm>Configure a JDBC Tee
                processor to write data to a database table and enrich records with data from
                generated database columns.</p></context>
        <steps>
            <step
                conref="../Reusable_Content/ReusableSteps.dita#task_kzs_5vz_sq/1stStep-ReqField-ErrorHandling">
                <cmd/>
            </step>
            <step>
                <cmd>On the <wintitle>JDBC</wintitle> tab, configure the following properties:</cmd>
                <info>
                    <table frame="all" rowsep="1" colsep="1" id="table_lcm_yyq_tw">
                        <tgroup cols="2">
                            <colspec colname="c1" colnum="1" colwidth="1.5*"/>
                            <colspec colname="c2" colnum="2" colwidth="3.0*"/>
                            <thead>
                                <row>
                                    <entry>JDBC Property</entry>
                                    <entry>Description</entry>
                                </row>
                            </thead>
                            <tbody>
                                <row
                                    conref="../Reusable_Content/ReusableTables.dita#concept_wfr_rnw_yq/JDBCConnectString_row">
                                    <entry/>
                                </row>
                                <row>
                                    <entry>Table Name</entry>
                                    <entry>Database table to write to. Some databases require a
                                        fully-qualified table name, such as <codeph>&lt;schema |
                                            database>:&lt;tablename></codeph>. Use the table name
                                        format required by the database.<p>Enter one of the
                                            following:</p><ul id="ul_ncv_cm4_1w">
                                            <li>Name of an existing database table. If the table
                                                doesn't exist, the pipeline fails to start.</li>
                                            <li>Expression that evaluates to the name of an existing
                                                database table. For example, if the table name is
                                                stored in the "tableName" record attribute, enter
                                                the following
                                                expression:<codeblock>${record:attribute('tableName')}</codeblock>If
                                                the table doesn't exist, the records are treated as
                                                error records.</li>
                                        </ul></entry>
                                </row>
                                <row
                                    conref="../Reusable_Content/ReusableTables.dita#concept_wfr_rnw_yq/FieldToColumnJDBC_row">
                                    <entry/>
                                </row>
                                <row>
                                    <entry>Generated Column Mappings</entry>
                                    <entry>Map the generated database columns to fields in the
                                        record. Enter the following:<ul id="ul_zgb_wlw_tw">
                                            <li>Column Name. Name of the database column that
                                                contains the generated value. Enter a column name or
                                                enter an expression that defines the column. </li>
                                            <li>SDC Field. Name of the field in the record that
                                                receives the generated column value. You can specify
                                                an existing field or a new field. If the field does
                                                not exist, JDBC Tee creates the field. </li>
                                        </ul><p>Use the <uicontrol>Add</uicontrol> icon to create
                                            additional generated column mappings.</p></entry>
                                </row>
                                <row
                                    conref="../Reusable_Content/ReusableTables.dita#concept_wfr_rnw_yq/LogFormat_row">
                                    <entry/>
                                </row>
                                <row>
                                    <entry>Default Operation <xref href="JDBCTee-CRUDOperation.dita">
                                            <image href="../Graphics/icon_moreInfo.png" scale="10"
                                                id="image_m6p_rfp_vv"/></xref></entry>
                                    <entry
                                        conref="../Reusable_Content/ReusableSteps.dita#task_kzs_5vz_sq/entry_DefaultOperation"/>
                                </row>
                                <row>
                                    <entry>Unsupported Operation Handling </entry>
                                    <entry
                                        conref="../Reusable_Content/ReusableSteps.dita#task_kzs_5vz_sq/entry_UnsupportedOperation"/>
                                </row>
                                <row
                                    conref="../Reusable_Content/ReusableTables.dita#concept_wfr_rnw_yq/RollbackBatch_row">
                                    <entry/>
                                </row>
                                <row>
                                    <entry>Use Multi-Row Operation</entry>
                                    <entry><ph
                                            conref="../Reusable_Content/ReusableTables.dita#concept_wfr_rnw_yq/ph-MultirowDesc"
                                        /> For more information, see &lt;&lt;add xref>>.<p><ph
                                                conref="../Reusable_Content/ReusableTables.dita#concept_wfr_rnw_yq/ph-Multirow-Default"
                                            /></p></entry>
                                </row>
                                <row
                                    conref="../Reusable_Content/ReusableTables.dita#concept_wfr_rnw_yq/ParamLimit_row">
                                    <entry/>
                                </row>
                                <row
                                    conref="../Reusable_Content/ReusableTables.dita#concept_wfr_rnw_yq/JDBCUseCredentials_row">
                                    <entry/>
                                </row>
                                <row
                                    conref="../Reusable_Content/ReusableTables.dita#concept_wfr_rnw_yq/JDBCAddtitionalProps_row">
                                    <entry/>
                                </row>
                            </tbody>
                        </tgroup>
                    </table>
                </info>
            </step>
            <step conref="../Reusable_Content/ReusableSteps.dita#task_kzs_5vz_sq/JDBC-Credentials"><commit_msg>[doc] production update<commit_after><?xml version="1.0" encoding="UTF-8"?>
<!--

    Copyright 2017 StreamSets Inc.

    Licensed 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.

-->
<!DOCTYPE task PUBLIC "-//OASIS//DTD DITA Task//EN" "task.dtd">
<task id="task_qpj_ncy_hw">
    <title>Configuring a JDBC Tee</title>
    <taskbody>
        <context><p><indexterm>JDBC Tee processor<indexterm>configuring</indexterm></indexterm>Configure a JDBC Tee
                processor to write data to a database table and enrich records with data from
                generated database columns.</p></context>
        <steps>
            <step
                conref="../Reusable_Content/ReusableSteps.dita#task_kzs_5vz_sq/1stStep-ReqField-ErrorHandling">
                <cmd/>
            </step>
            <step>
                <cmd>On the <wintitle>JDBC</wintitle> tab, configure the following properties:</cmd>
                <info>
                    <table frame="all" rowsep="1" colsep="1" id="table_lcm_yyq_tw">
                        <tgroup cols="2">
                            <colspec colname="c1" colnum="1" colwidth="1.5*"/>
                            <colspec colname="c2" colnum="2" colwidth="3.0*"/>
                            <thead>
                                <row>
                                    <entry>JDBC Property</entry>
                                    <entry>Description</entry>
                                </row>
                            </thead>
                            <tbody>
                                <row
                                    conref="../Reusable_Content/ReusableTables.dita#concept_wfr_rnw_yq/JDBCConnectString_row">
                                    <entry/>
                                </row>
                                <row>
                                    <entry>Table Name</entry>
                                    <entry>Database table to write to. Some databases require a
                                        fully-qualified table name, such as <codeph>&lt;schema |
                                            database>:&lt;tablename></codeph>. Use the table name
                                        format required by the database.<p>Enter one of the
                                            following:</p><ul id="ul_ncv_cm4_1w">
                                            <li>Name of an existing database table. If the table
                                                doesn't exist, the pipeline fails to start.</li>
                                            <li>Expression that evaluates to the name of an existing
                                                database table. For example, if the table name is
                                                stored in the "tableName" record attribute, enter
                                                the following
                                                expression:<codeblock>${record:attribute('tableName')}</codeblock>If
                                                the table doesn't exist, the records are treated as
                                                error records.</li>
                                        </ul></entry>
                                </row>
                                <row
                                    conref="../Reusable_Content/ReusableTables.dita#concept_wfr_rnw_yq/FieldToColumnJDBC_row">
                                    <entry/>
                                </row>
                                <row>
                                    <entry>Generated Column Mappings</entry>
                                    <entry>Map the generated database columns to fields in the
                                        record. Enter the following:<ul id="ul_zgb_wlw_tw">
                                            <li>Column Name. Name of the database column that
                                                contains the generated value. Enter a column name or
                                                enter an expression that defines the column. </li>
                                            <li>SDC Field. Name of the field in the record that
                                                receives the generated column value. You can specify
                                                an existing field or a new field. If the field does
                                                not exist, JDBC Tee creates the field. </li>
                                        </ul><p>Use the <uicontrol>Add</uicontrol> icon to create
                                            additional generated column mappings.</p></entry>
                                </row>
                                <row
                                    conref="../Reusable_Content/ReusableTables.dita#concept_wfr_rnw_yq/LogFormat_row">
                                    <entry/>
                                </row>
                                <row>
                                    <entry>Default Operation <xref href="JDBCTee-CRUDOperation.dita">
                                            <image href="../Graphics/icon_moreInfo.png" scale="10"
                                                id="image_m6p_rfp_vv"/></xref></entry>
                                    <entry
                                        conref="../Reusable_Content/ReusableSteps.dita#task_kzs_5vz_sq/entry_DefaultOperation"/>
                                </row>
                                <row>
                                    <entry>Unsupported Operation Handling </entry>
                                    <entry
                                        conref="../Reusable_Content/ReusableSteps.dita#task_kzs_5vz_sq/entry_UnsupportedOperation"/>
                                </row>
                                <row
                                    conref="../Reusable_Content/ReusableTables.dita#concept_wfr_rnw_yq/RollbackBatch_row">
                                    <entry/>
                                </row>
                                <row>
                                    <entry>Use Multi-Row Operation</entry>
                                    <entry><ph
                                            conref="../Reusable_Content/ReusableTables.dita#concept_wfr_rnw_yq/ph-MultirowDesc"
                                        /> For more information, see <xref
                                            href="JDBCTee-SingleMultiOperations.dita#concept_jnl_rmp_h1b"
                                                />.<p><ph
                                                conref="../Reusable_Content/ReusableTables.dita#concept_wfr_rnw_yq/ph-Multirow-Default"
                                            /></p></entry>
                                </row>
                                <row
                                    conref="../Reusable_Content/ReusableTables.dita#concept_wfr_rnw_yq/ParamLimit_row">
                                    <entry/>
                                </row>
                                <row
                                    conref="../Reusable_Content/ReusableTables.dita#concept_wfr_rnw_yq/JDBCUseCredentials_row">
                                    <entry/>
                                </row>
                                <row
                                    conref="../Reusable_Content/ReusableTables.dita#concept_wfr_rnw_yq/JDBCAddtitionalProps_row">
                                    <entry/>
                                </row>
                            </tbody>
                        </tgroup>
                    </table>
                </info>
            </step>
            <step conref="../Reusable_Content/ReusableSteps.dita#task_kzs_5vz_sq/JDBC-Credentials">
{'fraction_non_alphanumeric': 0.0758107454017425, 'fraction_numerical': 0.00393272023233301, 'mean_word_length': 0.8914063393981004, 'pattern_counts': {'":': 0, '<': 248, '<?xml version=': 2, '>': 254, 'https://': 0, 'lorem ipsum': 0, 'www.': 2, 'xml': 2}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 170, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '4332455', 'n_tokens_mistral': 3612, 'n_tokens_neox': 3356, 'n_words': 824}