{"id":5322,"date":"2025-01-17T16:21:48","date_gmt":"2025-01-17T16:21:48","guid":{"rendered":"https:\/\/help.iristrace.com\/docs\/connecting-from-azure-synapse-via-local-connection\/"},"modified":"2025-01-17T16:29:44","modified_gmt":"2025-01-17T16:29:44","password":"","slug":"connecting-from-azure-synapse-via-local-connection","status":"publish","type":"docs","link":"https:\/\/help.iristrace.com\/es\/docs\/connecting-from-azure-synapse-via-local-connection\/","title":{"rendered":"Conexi\u00f3n desde Azure Synapse via conexi\u00f3n local"},"content":{"rendered":"<p>La conexi\u00f3n local permite contectar con la base de datos intermedia usando la IP de su empresa. De esta forma s\u00f3lo estas IPs han de ser autorizadas en el firewall de Iristrace en lugar del rango completo de la la plataforma Azure Synapse.<\/p>\n<ol>\n<li>Vaya a Linked Services el panel de administraci\u00f3n de su Synapse Analytics\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-5305 size-full\" src=\"https:\/\/help.iristrace.com\/wp-content\/uploads\/2025\/01\/azure_synapse_step_1.png\" alt=\"\" width=\"279\" height=\"352\" srcset=\"https:\/\/help.iristrace.com\/wp-content\/uploads\/2025\/01\/azure_synapse_step_1.png 279w, https:\/\/help.iristrace.com\/wp-content\/uploads\/2025\/01\/azure_synapse_step_1-238x300.png 238w, https:\/\/help.iristrace.com\/wp-content\/uploads\/2025\/01\/azure_synapse_step_1-10x12.png 10w, https:\/\/help.iristrace.com\/wp-content\/uploads\/2025\/01\/azure_synapse_step_1-29x36.png 29w, https:\/\/help.iristrace.com\/wp-content\/uploads\/2025\/01\/azure_synapse_step_1-38x48.png 38w\" sizes=\"auto, (max-width: 279px) 100vw, 279px\" \/><\/li>\n<li>Cree un nuevo Linked service\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-5308 size-full\" src=\"https:\/\/help.iristrace.com\/wp-content\/uploads\/2025\/01\/azure_synapse_step_2.png\" alt=\"\" width=\"652\" height=\"267\" srcset=\"https:\/\/help.iristrace.com\/wp-content\/uploads\/2025\/01\/azure_synapse_step_2.png 652w, https:\/\/help.iristrace.com\/wp-content\/uploads\/2025\/01\/azure_synapse_step_2-300x123.png 300w, https:\/\/help.iristrace.com\/wp-content\/uploads\/2025\/01\/azure_synapse_step_2-360x147.png 360w, https:\/\/help.iristrace.com\/wp-content\/uploads\/2025\/01\/azure_synapse_step_2-12x5.png 12w, https:\/\/help.iristrace.com\/wp-content\/uploads\/2025\/01\/azure_synapse_step_2-36x15.png 36w, https:\/\/help.iristrace.com\/wp-content\/uploads\/2025\/01\/azure_synapse_step_2-48x20.png 48w\" sizes=\"auto, (max-width: 652px) 100vw, 652px\" \/><\/li>\n<li>Busque MariaDB\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-5311 size-full\" src=\"https:\/\/help.iristrace.com\/wp-content\/uploads\/2025\/01\/azure_synapse_step_3.png\" alt=\"\" width=\"588\" height=\"336\" srcset=\"https:\/\/help.iristrace.com\/wp-content\/uploads\/2025\/01\/azure_synapse_step_3.png 588w, https:\/\/help.iristrace.com\/wp-content\/uploads\/2025\/01\/azure_synapse_step_3-300x171.png 300w, https:\/\/help.iristrace.com\/wp-content\/uploads\/2025\/01\/azure_synapse_step_3-360x206.png 360w, https:\/\/help.iristrace.com\/wp-content\/uploads\/2025\/01\/azure_synapse_step_3-12x7.png 12w, https:\/\/help.iristrace.com\/wp-content\/uploads\/2025\/01\/azure_synapse_step_3-36x21.png 36w, https:\/\/help.iristrace.com\/wp-content\/uploads\/2025\/01\/azure_synapse_step_3-48x27.png 48w\" sizes=\"auto, (max-width: 588px) 100vw, 588px\" \/><\/li>\n<li>Despu\u00e9s de seleccionar After MariaDB complete los datos de conexi\u00f3n con la informaci\u00f3n que le hemos hecho llegar. Es muy imporante que seleccione \u00abIntegration Runtime LOCAL\u00bb. El modo SSL debe ser obligatoriamente\u00a0 \u00abRequired\u00bb\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-5314 size-full\" src=\"https:\/\/help.iristrace.com\/wp-content\/uploads\/2025\/01\/azure_synapse_step_4.png\" alt=\"\" width=\"660\" height=\"952\" srcset=\"https:\/\/help.iristrace.com\/wp-content\/uploads\/2025\/01\/azure_synapse_step_4.png 660w, https:\/\/help.iristrace.com\/wp-content\/uploads\/2025\/01\/azure_synapse_step_4-208x300.png 208w, https:\/\/help.iristrace.com\/wp-content\/uploads\/2025\/01\/azure_synapse_step_4-355x512.png 355w, https:\/\/help.iristrace.com\/wp-content\/uploads\/2025\/01\/azure_synapse_step_4-8x12.png 8w, https:\/\/help.iristrace.com\/wp-content\/uploads\/2025\/01\/azure_synapse_step_4-25x36.png 25w, https:\/\/help.iristrace.com\/wp-content\/uploads\/2025\/01\/azure_synapse_step_4-33x48.png 33w\" sizes=\"auto, (max-width: 660px) 100vw, 660px\" \/><\/li>\n<li>Una vez haya completado los campos, ser\u00e1 capaz de realizar una prueba de conexi\u00f3n. Si todo est\u00e1 correcto, ver\u00e1 un mensaje de conexi\u00f3n correcta.\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-5317 size-full\" src=\"https:\/\/help.iristrace.com\/wp-content\/uploads\/2025\/01\/azure_synapse_step_5.png\" alt=\"\" width=\"609\" height=\"75\" srcset=\"https:\/\/help.iristrace.com\/wp-content\/uploads\/2025\/01\/azure_synapse_step_5.png 609w, https:\/\/help.iristrace.com\/wp-content\/uploads\/2025\/01\/azure_synapse_step_5-300x37.png 300w, https:\/\/help.iristrace.com\/wp-content\/uploads\/2025\/01\/azure_synapse_step_5-360x44.png 360w, https:\/\/help.iristrace.com\/wp-content\/uploads\/2025\/01\/azure_synapse_step_5-12x1.png 12w, https:\/\/help.iristrace.com\/wp-content\/uploads\/2025\/01\/azure_synapse_step_5-36x4.png 36w, https:\/\/help.iristrace.com\/wp-content\/uploads\/2025\/01\/azure_synapse_step_5-48x6.png 48w\" sizes=\"auto, (max-width: 609px) 100vw, 609px\" \/><\/li>\n<\/ol>\n","protected":false},"excerpt":{"rendered":"<p>La conexi\u00f3n local permite contectar con la base de datos intermedia usando la IP de su empresa. De esta forma s\u00f3lo estas IPs han de ser autorizadas en el firewall de Iristrace en lugar del rango completo de la la plataforma Azure Synapse. Vaya a Linked Services el panel de administraci\u00f3n de su Synapse Analytics [&hellip;]<\/p>\n","protected":false},"author":9,"featured_media":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"doc_category":[203,207],"glossaries":[],"doc_tag":[],"class_list":["post-5322","docs","type-docs","status-publish","hentry","doc_category-integraciones-bi","doc_category-integrations-bi"],"year_month":"2026-04","word_count":127,"total_views":"408","reactions":{"happy":"0","normal":"0","sad":"0"},"author_info":{"name":"Gonzalo Cao","author_nicename":"gonzalo-caoiristrace-com","author_url":"https:\/\/help.iristrace.com\/es\/author\/gonzalo-caoiristrace-com\/"},"doc_category_info":[{"term_name":"Integraciones &amp; BI","term_url":"https:\/\/help.iristrace.com\/es\/docs-category\/integraciones-bi\/"},{"term_name":"Integrations &amp; BI","term_url":"https:\/\/help.iristrace.com\/docs-category\/integrations-bi\/"}],"doc_tag_info":[],"knowledge_base_info":[],"knowledge_base_slug":[],"_links":{"self":[{"href":"https:\/\/help.iristrace.com\/es\/wp-json\/wp\/v2\/docs\/5322","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/help.iristrace.com\/es\/wp-json\/wp\/v2\/docs"}],"about":[{"href":"https:\/\/help.iristrace.com\/es\/wp-json\/wp\/v2\/types\/docs"}],"author":[{"embeddable":true,"href":"https:\/\/help.iristrace.com\/es\/wp-json\/wp\/v2\/users\/9"}],"replies":[{"embeddable":true,"href":"https:\/\/help.iristrace.com\/es\/wp-json\/wp\/v2\/comments?post=5322"}],"version-history":[{"count":2,"href":"https:\/\/help.iristrace.com\/es\/wp-json\/wp\/v2\/docs\/5322\/revisions"}],"predecessor-version":[{"id":5324,"href":"https:\/\/help.iristrace.com\/es\/wp-json\/wp\/v2\/docs\/5322\/revisions\/5324"}],"wp:attachment":[{"href":"https:\/\/help.iristrace.com\/es\/wp-json\/wp\/v2\/media?parent=5322"}],"wp:term":[{"taxonomy":"doc_category","embeddable":true,"href":"https:\/\/help.iristrace.com\/es\/wp-json\/wp\/v2\/doc_category?post=5322"},{"taxonomy":"glossaries","embeddable":true,"href":"https:\/\/help.iristrace.com\/es\/wp-json\/wp\/v2\/glossaries?post=5322"},{"taxonomy":"doc_tag","embeddable":true,"href":"https:\/\/help.iristrace.com\/es\/wp-json\/wp\/v2\/doc_tag?post=5322"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}