forked from docs/doc-exports
chenxiaoxiong
f9e2808b7c
Reviewed-by: Pruthi, Vineet <vineet.pruthi@t-systems.com> Co-authored-by: chenxiaoxiong <chenxiaoxiong@huawei.com> Co-committed-by: chenxiaoxiong <chenxiaoxiong@huawei.com>
56 lines
7.0 KiB
HTML
56 lines
7.0 KiB
HTML
<a name="dataartsstudio_01_0332"></a><a name="dataartsstudio_01_0332"></a>
|
|
|
|
<h1 class="topictitle1">To MongoDB</h1>
|
|
<div id="body8662426"><p id="dataartsstudio_01_0332__en-us_topic_0000001507639409_p21313215367">If the destination link of a job is a <a href="dataartsstudio_01_0030.html">MongoDB link</a>, configure the destination job parameters based on <a href="#dataartsstudio_01_0332__en-us_topic_0000001507639409_table31823995163953">Table 1</a>.</p>
|
|
|
|
<div class="tablenoborder"><a name="dataartsstudio_01_0332__en-us_topic_0000001507639409_table31823995163953"></a><a name="en-us_topic_0000001507639409_table31823995163953"></a><table cellpadding="4" cellspacing="0" summary="" id="dataartsstudio_01_0332__en-us_topic_0000001507639409_table31823995163953" frame="border" border="1" rules="all"><caption><b>Table 1 </b>Parameter description</caption><thead align="left"><tr id="dataartsstudio_01_0332__en-us_topic_0000001507639409_row18653487163953"><th align="left" class="cellrowborder" valign="top" width="16.61%" id="mcps1.3.2.2.4.1.1"><p id="dataartsstudio_01_0332__en-us_topic_0000001507639409_p15314298163953">Parameter</p>
|
|
</th>
|
|
<th align="left" class="cellrowborder" valign="top" width="64.21%" id="mcps1.3.2.2.4.1.2"><p id="dataartsstudio_01_0332__en-us_topic_0000001507639409_p32498630163953">Description</p>
|
|
</th>
|
|
<th align="left" class="cellrowborder" valign="top" width="19.18%" id="mcps1.3.2.2.4.1.3"><p id="dataartsstudio_01_0332__en-us_topic_0000001507639409_p15143370163953">Example Value</p>
|
|
</th>
|
|
</tr>
|
|
</thead>
|
|
<tbody><tr id="dataartsstudio_01_0332__en-us_topic_0000001507639409_row2052684816261"><td class="cellrowborder" valign="top" width="16.61%" headers="mcps1.3.2.2.4.1.1 "><p id="dataartsstudio_01_0332__en-us_topic_0000001507639409_p175265482261">Database Name</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="64.21%" headers="mcps1.3.2.2.4.1.2 "><p id="dataartsstudio_01_0332__en-us_topic_0000001507639409_p145261848192619">Database to which data is to be imported</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="19.18%" headers="mcps1.3.2.2.4.1.3 "><p id="dataartsstudio_01_0332__en-us_topic_0000001507639409_p452664812616">mddb</p>
|
|
</td>
|
|
</tr>
|
|
<tr id="dataartsstudio_01_0332__en-us_topic_0000001507639409_row34313000163953"><td class="cellrowborder" valign="top" width="16.61%" headers="mcps1.3.2.2.4.1.1 "><p id="dataartsstudio_01_0332__en-us_topic_0000001507639409_p46804376161524">Collection Name</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="64.21%" headers="mcps1.3.2.2.4.1.2 "><p id="dataartsstudio_01_0332__en-us_topic_0000001507639409_p6187019816562">Collection of data to be imported, which is similar to the table name of a relational database. Click the icon next to the text box to go to the page for selecting the table or directly enter a table name.</p>
|
|
<p id="dataartsstudio_01_0332__en-us_topic_0000001507639409_p49990086164128">If the desired table is not displayed, check whether the table exists or whether the login account has the permission to query metadata.</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="19.18%" headers="mcps1.3.2.2.4.1.3 "><p id="dataartsstudio_01_0332__en-us_topic_0000001507639409_p41020337163953">COLLECTION</p>
|
|
</td>
|
|
</tr>
|
|
<tr id="dataartsstudio_01_0332__en-us_topic_0000001507639409_row142951933411"><td class="cellrowborder" valign="top" width="16.61%" headers="mcps1.3.2.2.4.1.1 "><p id="dataartsstudio_01_0332__en-us_topic_0000001507639409_p1574411865710">Behavior</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="64.21%" headers="mcps1.3.2.2.4.1.2 "><p id="dataartsstudio_01_0332__en-us_topic_0000001507639409_p162032941513">Insert operation to be performed during record migration to the MongoDB</p>
|
|
<ul id="dataartsstudio_01_0332__en-us_topic_0000001507639409_ul17595125285612"><li id="dataartsstudio_01_0332__en-us_topic_0000001507639409_li25957522567"><strong id="dataartsstudio_01_0332__en-us_topic_0000001507639409_b6328418387">Insert</strong>: Insert file records into a specified set.</li><li id="dataartsstudio_01_0332__en-us_topic_0000001507639409_li459515215563"><strong id="dataartsstudio_01_0332__en-us_topic_0000001507639409_b1287235354016">Insert</strong>: Use a specified filter key as the query condition. If a matching record is found in the set, the record is replaced. (If multiple matching records are found, only the first found record is replaced.) Otherwise, the new record will be added.</li><li id="dataartsstudio_01_0332__en-us_topic_0000001507639409_li259515295619"><strong id="dataartsstudio_01_0332__en-us_topic_0000001507639409_b10511143094213">Replace</strong>: Use a specified filter key as the query condition. If a matching record is found in the set, the record is replaced. (If multiple matching records are found, only the first found record is replaced.) Otherwise, the new record will not be added.</li></ul>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="19.18%" headers="mcps1.3.2.2.4.1.3 "><p id="dataartsstudio_01_0332__en-us_topic_0000001507639409_p103041912342">Add</p>
|
|
</td>
|
|
</tr>
|
|
<tr id="dataartsstudio_01_0332__en-us_topic_0000001507639409_row72772065529"><td class="cellrowborder" valign="top" width="16.61%" headers="mcps1.3.2.2.4.1.1 "><p id="dataartsstudio_01_0332__en-us_topic_0000001507639409_p12278969523">Prepare for Data Import</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="64.21%" headers="mcps1.3.2.2.4.1.2 "><p id="dataartsstudio_01_0332__en-us_topic_0000001507639409_p20278362524">MongoDB query statement that needs to be executed before a task is executed</p>
|
|
<div class="note" id="dataartsstudio_01_0332__en-us_topic_0000001507639409_note2655227113820"><span class="notetitle"> NOTE: </span><div class="notebody"><ul id="dataartsstudio_01_0332__en-us_topic_0000001507639409_ul897955904515"><li id="dataartsstudio_01_0332__en-us_topic_0000001507639409_li129791859104515">The value is a JSON string that contains two key-value pairs. The first key-value pair specifies the operation type. The key is <strong id="dataartsstudio_01_0332__en-us_topic_0000001507639409_b1278945220463">type</strong>, and the value can only be <strong id="dataartsstudio_01_0332__en-us_topic_0000001507639409_b126618595461">remove</strong> or <strong id="dataartsstudio_01_0332__en-us_topic_0000001507639409_b613416520472">drop</strong>. The second key-value pair is the name of the data condition or set to be configured for the operation type.</li><li id="dataartsstudio_01_0332__en-us_topic_0000001507639409_li1797975994512">The execution of the data import preparation statement does not affect the data to be written.</li></ul>
|
|
</div></div>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="19.18%" headers="mcps1.3.2.2.4.1.3 "><p id="dataartsstudio_01_0332__en-us_topic_0000001507639409_p31396427434">{"type":"remove","json":"{$or:[{Pid:{$gt:'0',$lt:'2'}},{X:{$gt:'50',$lt:'80'}}]}"}</p>
|
|
</td>
|
|
</tr>
|
|
</tbody>
|
|
</table>
|
|
</div>
|
|
</div>
|
|
<div>
|
|
<div class="familylinks">
|
|
<div class="parentlink"><strong>Parent topic:</strong> <a href="dataartsstudio_01_0061.html">Configuring CDM Destination Job Parameters</a></div>
|
|
</div>
|
|
</div>
|
|
|