<turbo-stream action="update" target="wiki_3611_subpage_3715_info"><template>
<p>Connections are the databases or systems that you want to transfer data between. Read more about <a href="/wiki/Connections" title="Connections">Connections.</a></p>
<br>
<table>
<thead>
<tr>
<td><strong>Field</strong></td>
<td><strong>Type</strong></td>
<td><strong>Notes</strong></td>
</tr>
</thead>
<tbody>
<tr>
<td>id</td>
<td>string</td>
<td>unique id for the record</td>
</tr>
<tr>
<td>type</td>
<td>string</td>
<td>always "connections" (only used with JSONAPI)</td>
</tr>
<tr>
<td><strong>Attributes</strong></td>
<td></td>
<td></td>
</tr>
<tr>
<td>code</td>
<td>string</td>
<td>mandatory - please set a unique code</td>
</tr>
<tr>
<td>description</td>
<td>string</td>
<td>mandatory - please provide a useful description</td>
</tr>
<tr>
<td>connection_type</td>
<td>string</td>
<td>
<p>ms_dynamics_nav</p>
<p>ms_dynamics_nav_ws<br>ms_dynamics_nav_sql</p>
<p>ms_dynamics_nav_odata<br>ms_dynamics_ax</p>
<p>ms_dynamics_ax_ws</p>
<p>ms_dynamics_ax_odata<br>ms_dynamics_gp_sp<br>ms_dynamics_gp_sql</p>
<p>ms_dynamics_crm</p>
<p>ms_dynamics_c5<br>salesforce_com</p>
<p>ms_sql</p>
<p>oracle</p>
<p>odbc</p>
<p>lotus_notes<br>e_conomic<br>ibm_db2</p>
<p>mysql</p>
<p>xal</p>
<p>netsuite</p>
<p>navision_356</p>
<p>nas_connector</p>
<p>rest_webservice</p>
<p>sqlite</p>
<p>odata</p>
</td>
</tr>
<tr>
<td>server_connect</td>
<td>string</td>
<td></td>
</tr>
<tr>
<td>server_name</td>
<td>string</td>
<td>MySQL</td>
</tr>
<tr>
<td>port</td>
<td>integer</td>
<td>MySQL</td>
</tr>
<tr>
<td>driver</td>
<td>string</td>
<td>NAV</td>
</tr>
<tr>
<td>network_protocol</td>
<td>string</td>
<td>NAV</td>
</tr>
<tr>
<td>database</td>
<td>string</td>
<td></td>
</tr>
<tr>
<td>database_path</td>
<td>string</td>
<td></td>
</tr>
<tr>
<td>database_type</td>
<td>string</td>
<td></td>
</tr>
<tr>
<td>company</td>
<td>string</td>
<td>AX</td>
</tr>
<tr>
<td>account</td>
<td>string</td>
<td>NAV, GP</td>
</tr>
<tr>
<td>use_codeunits_permissions</td>
<td>boolean</td>
<td>NAV</td>
</tr>
<tr>
<td>installation_path</td>
<td>string</td>
<td>NAV</td>
</tr>
<tr>
<td>use_windows_authentication</td>
<td>string</td>
<td></td>
</tr>
<tr>
<td>user_id</td>
<td>string</td>
<td></td>
</tr>
<tr>
<td>schema</td>
<td>string</td>
<td></td>
</tr>
<tr>
<td>authentication_type_odata</td>
<td>string</td>
<td></td>
</tr>
<tr>
<td>authentication_type_crm</td>
<td>string</td>
<td></td>
</tr>
<tr>
<td>domain</td>
<td>string</td>
<td>AX odata</td>
</tr>
<tr>
<td>resource</td>
<td>string</td>
<td>AX odata</td>
</tr>
<tr>
<td>metadata</td>
<td>string</td>
<td>AX odata</td>
</tr>
<tr>
<td>use_ssl</td>
<td>boolean</td>
<td></td>
</tr>
<tr>
<td>service_list</td>
<td>string</td>
<td>AX WS</td>
</tr>
<tr>
<td>installation_path</td>
<td>string</td>
<td></td>
</tr>
<tr>
<td>use_ssl</td>
<td>boolean</td>
<td></td>
</tr>
<tr>
<td>sandbox</td>
<td>boolean</td>
<td></td>
</tr>
<tr>
<td>token</td>
<td>string</td>
<td>e-conomic</td>
</tr>
<tr>
<td>agreement_number</td>
<td>string</td>
<td>e-conomic</td>
</tr>
<tr>
<td>organization_name</td>
<td>string</td>
<td>CRM</td>
</tr>
<tr>
<td>sts_urn</td>
<td>string</td>
<td>CRM</td>
</tr>
<tr>
<td></td>
<td></td>
<td></td>
</tr>
</tbody>
</table>
<p></p>
<table>
<thead>
<tr>
<td><strong>Related objects</strong></td>
<td><strong></strong></td>
<td><strong></strong></td>
</tr>
</thead>
<tbody>
<tr>
<td>rapidiconnector (fields: user_id, password)</td>
<td></td>
<td></td>
</tr>
<tr>
<td>comments (fields: created_by, created_at)</td>
<td></td>
<td></td>
</tr>
</tbody>
</table>
<br>
<table>
<thead>
<tr>
<td><strong>Query Parameter</strong></td>
<td><strong>Notes</strong></td>
</tr>
</thead>
<tbody>
<tr>
<td>id</td>
<td></td>
</tr>
</tbody>
</table>
<br>
<p></p><div class="section_header"><div class="line"> <div class="column_blindupdown" data-controller="wiki" data-wiki-target="blindupdown"><a data-turbo="true" data-turbo-stream="true" href="/wiki/get_connections?inline=1&amp;parent_page_ids=3611_3715&amp;child_page_id=3717"><img class="blindupdown_show" id="show_wiki_3611_3715_subpage_3717_info" title="Show information" alt="Show information" src="/assets/gfx/showinfo-dfd75ef684363d1bd0e344be999155542dc15232a93cd61188484b8ca2bd07eb.gif"></a><img id="hide_wiki_3611_3715_subpage_3717_info" class="blindupdown_hide" title="Hide information" alt="Hide information" src="/assets/gfx/hideinfo-6e9943c0a2751c6dd2904a66f74a8591ed3d5fcd13413b704851ee06b53c4b51.gif"></div><div>Get Connections</div></div></div><div class="section_detail" id="wiki_3611_3715_subpage_3717_info"></div><p></p>
<p></p><div class="section_header"><div class="line"> <div class="column_blindupdown" data-controller="wiki" data-wiki-target="blindupdown"><a data-turbo="true" data-turbo-stream="true" href="/wiki/get_one_connection?inline=1&amp;parent_page_ids=3611_3715&amp;child_page_id=3718"><img class="blindupdown_show" id="show_wiki_3611_3715_subpage_3718_info" title="Show information" alt="Show information" src="/assets/gfx/showinfo-dfd75ef684363d1bd0e344be999155542dc15232a93cd61188484b8ca2bd07eb.gif"></a><img id="hide_wiki_3611_3715_subpage_3718_info" class="blindupdown_hide" title="Hide information" alt="Hide information" src="/assets/gfx/hideinfo-6e9943c0a2751c6dd2904a66f74a8591ed3d5fcd13413b704851ee06b53c4b51.gif"></div><div>Get One Connection</div></div></div><div class="section_detail" id="wiki_3611_3715_subpage_3718_info"></div><p></p>
<p></p><div class="section_header"><div class="line"> <div class="column_blindupdown" data-controller="wiki" data-wiki-target="blindupdown"><a data-turbo="true" data-turbo-stream="true" href="/wiki/create_connection?inline=1&amp;parent_page_ids=3611_3715&amp;child_page_id=3720"><img class="blindupdown_show" id="show_wiki_3611_3715_subpage_3720_info" title="Show information" alt="Show information" src="/assets/gfx/showinfo-dfd75ef684363d1bd0e344be999155542dc15232a93cd61188484b8ca2bd07eb.gif"></a><img id="hide_wiki_3611_3715_subpage_3720_info" class="blindupdown_hide" title="Hide information" alt="Hide information" src="/assets/gfx/hideinfo-6e9943c0a2751c6dd2904a66f74a8591ed3d5fcd13413b704851ee06b53c4b51.gif"></div><div>Create Connection</div></div></div><div class="section_detail" id="wiki_3611_3715_subpage_3720_info"></div><p></p>
<p></p><div class="section_header"><div class="line"> <div class="column_blindupdown" data-controller="wiki" data-wiki-target="blindupdown"><a data-turbo="true" data-turbo-stream="true" href="/wiki/update_connection?inline=1&amp;parent_page_ids=3611_3715&amp;child_page_id=3719"><img class="blindupdown_show" id="show_wiki_3611_3715_subpage_3719_info" title="Show information" alt="Show information" src="/assets/gfx/showinfo-dfd75ef684363d1bd0e344be999155542dc15232a93cd61188484b8ca2bd07eb.gif"></a><img id="hide_wiki_3611_3715_subpage_3719_info" class="blindupdown_hide" title="Hide information" alt="Hide information" src="/assets/gfx/hideinfo-6e9943c0a2751c6dd2904a66f74a8591ed3d5fcd13413b704851ee06b53c4b51.gif"></div><div>Update Connection</div></div></div><div class="section_detail" id="wiki_3611_3715_subpage_3719_info"></div><p></p>
<p></p><div class="section_header"><div class="line"> <div class="column_blindupdown" data-controller="wiki" data-wiki-target="blindupdown"><a data-turbo="true" data-turbo-stream="true" href="/wiki/delete_connection?inline=1&amp;parent_page_ids=3611_3715&amp;child_page_id=3721"><img class="blindupdown_show" id="show_wiki_3611_3715_subpage_3721_info" title="Show information" alt="Show information" src="/assets/gfx/showinfo-dfd75ef684363d1bd0e344be999155542dc15232a93cd61188484b8ca2bd07eb.gif"></a><img id="hide_wiki_3611_3715_subpage_3721_info" class="blindupdown_hide" title="Hide information" alt="Hide information" src="/assets/gfx/hideinfo-6e9943c0a2751c6dd2904a66f74a8591ed3d5fcd13413b704851ee06b53c4b51.gif"></div><div>Delete Connection</div></div></div><div class="section_detail" id="wiki_3611_3715_subpage_3721_info"></div><p></p>
<p></p><div class="section_header"><div class="line"> <div class="column_blindupdown" data-controller="wiki" data-wiki-target="blindupdown"><a data-turbo="true" data-turbo-stream="true" href="/wiki/test_connection?inline=1&amp;parent_page_ids=3611_3715&amp;child_page_id=3722"><img class="blindupdown_show" id="show_wiki_3611_3715_subpage_3722_info" title="Show information" alt="Show information" src="/assets/gfx/showinfo-dfd75ef684363d1bd0e344be999155542dc15232a93cd61188484b8ca2bd07eb.gif"></a><img id="hide_wiki_3611_3715_subpage_3722_info" class="blindupdown_hide" title="Hide information" alt="Hide information" src="/assets/gfx/hideinfo-6e9943c0a2751c6dd2904a66f74a8591ed3d5fcd13413b704851ee06b53c4b51.gif"></div><div>Test Connection</div></div></div><div class="section_detail" id="wiki_3611_3715_subpage_3722_info"></div><p></p>
<p></p><div class="section_header"><div class="line"> <div class="column_blindupdown" data-controller="wiki" data-wiki-target="blindupdown"><a data-turbo="true" data-turbo-stream="true" href="/wiki/read_design_on_connection?inline=1&amp;parent_page_ids=3611_3715&amp;child_page_id=3724"><img class="blindupdown_show" id="show_wiki_3611_3715_subpage_3724_info" title="Show information" alt="Show information" src="/assets/gfx/showinfo-dfd75ef684363d1bd0e344be999155542dc15232a93cd61188484b8ca2bd07eb.gif"></a><img id="hide_wiki_3611_3715_subpage_3724_info" class="blindupdown_hide" title="Hide information" alt="Hide information" src="/assets/gfx/hideinfo-6e9943c0a2751c6dd2904a66f74a8591ed3d5fcd13413b704851ee06b53c4b51.gif"></div><div>Read Design on Connection</div></div></div><div class="section_detail" id="wiki_3611_3715_subpage_3724_info"></div><p></p>
</template></turbo-stream>
<turbo-stream action="prepend" target="flash"><template></template></turbo-stream>
