{"id":3393,"date":"2025-03-12T14:50:33","date_gmt":"2025-03-12T18:50:33","guid":{"rendered":"https:\/\/labs.icahn.mssm.edu\/msdw\/?page_id=3393"},"modified":"2025-09-04T16:12:23","modified_gmt":"2025-09-04T20:12:23","slug":"omop-development-configure-dbeaver-to-connect-to-msdw2","status":"publish","type":"page","link":"https:\/\/labs.icahn.mssm.edu\/msdw\/omop-development-configure-dbeaver-to-connect-to-msdw2\/","title":{"rendered":"OMOP Development \/ Configure DBeaver to connect to MSDW2"},"content":{"rendered":"<p>[et_pb_section bb_built=&#8221;1&#8243; admin_label=&#8221;Hero&#8221; _builder_version=&#8221;4.27.4&#8243; background_color_gradient_start=&#8221;#02cbd6&#8243; background_color_gradient_end=&#8221;#086acc&#8221; background_color_gradient_direction=&#8221;1deg&#8221; background_color_gradient_end_position=&#8221;0%&#8221; custom_padding=&#8221;||||false|false&#8221; animation_style=&#8221;zoom&#8221; animation_direction=&#8221;bottom&#8221; animation_intensity_zoom=&#8221;8%&#8221; animation_starting_opacity=&#8221;100%&#8221; box_shadow_style=&#8221;preset3&#8243; box_shadow_vertical=&#8221;-80px&#8221; box_shadow_blur=&#8221;0px&#8221; box_shadow_color=&#8221;#F8FBFE&#8221; box_shadow_position=&#8221;inner&#8221; background_pattern_color=&#8221;rgba(0,0,0,0.2)&#8221; background_mask_color=&#8221;#ffffff&#8221; vertical_offset_tablet=&#8221;0&#8243; horizontal_offset_tablet=&#8221;0&#8243;][et_pb_row _builder_version=&#8221;4.27.4&#8243; _module_preset=&#8221;default&#8221; background_pattern_color=&#8221;rgba(0,0,0,0.2)&#8221; background_mask_color=&#8221;#ffffff&#8221; box_shadow_horizontal_tablet=&#8221;0px&#8221; box_shadow_vertical_tablet=&#8221;0px&#8221; box_shadow_blur_tablet=&#8221;40px&#8221; box_shadow_spread_tablet=&#8221;0px&#8221; vertical_offset_tablet=&#8221;0&#8243; horizontal_offset_tablet=&#8221;0&#8243; z_index_tablet=&#8221;0&#8243;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;4.9.0&#8243; _module_preset=&#8221;default&#8221; background_color_gradient_stops=&#8221;#2b87da 0%|#29c4a9 100%&#8221;][et_pb_text admin_label=&#8221;Breadcrumb&#8221; _builder_version=&#8221;4.27.4&#8243; _module_preset=&#8221;default&#8221; background_pattern_color=&#8221;rgba(0,0,0,0.2)&#8221; background_mask_color=&#8221;#ffffff&#8221; text_text_shadow_horizontal_length=&#8221;text_text_shadow_style,%91object Object%93&#8243; text_text_shadow_horizontal_length_tablet=&#8221;0px&#8221; text_text_shadow_vertical_length=&#8221;text_text_shadow_style,%91object Object%93&#8243; text_text_shadow_vertical_length_tablet=&#8221;0px&#8221; text_text_shadow_blur_strength=&#8221;text_text_shadow_style,%91object Object%93&#8243; text_text_shadow_blur_strength_tablet=&#8221;1px&#8221; link_text_shadow_horizontal_length=&#8221;link_text_shadow_style,%91object Object%93&#8243; link_text_shadow_horizontal_length_tablet=&#8221;0px&#8221; link_text_shadow_vertical_length=&#8221;link_text_shadow_style,%91object Object%93&#8243; link_text_shadow_vertical_length_tablet=&#8221;0px&#8221; link_text_shadow_blur_strength=&#8221;link_text_shadow_style,%91object Object%93&#8243; link_text_shadow_blur_strength_tablet=&#8221;1px&#8221; ul_text_shadow_horizontal_length=&#8221;ul_text_shadow_style,%91object Object%93&#8243; ul_text_shadow_horizontal_length_tablet=&#8221;0px&#8221; ul_text_shadow_vertical_length=&#8221;ul_text_shadow_style,%91object Object%93&#8243; ul_text_shadow_vertical_length_tablet=&#8221;0px&#8221; ul_text_shadow_blur_strength=&#8221;ul_text_shadow_style,%91object Object%93&#8243; ul_text_shadow_blur_strength_tablet=&#8221;1px&#8221; ol_text_shadow_horizontal_length=&#8221;ol_text_shadow_style,%91object Object%93&#8243; ol_text_shadow_horizontal_length_tablet=&#8221;0px&#8221; ol_text_shadow_vertical_length=&#8221;ol_text_shadow_style,%91object Object%93&#8243; ol_text_shadow_vertical_length_tablet=&#8221;0px&#8221; ol_text_shadow_blur_strength=&#8221;ol_text_shadow_style,%91object Object%93&#8243; ol_text_shadow_blur_strength_tablet=&#8221;1px&#8221; quote_text_shadow_horizontal_length=&#8221;quote_text_shadow_style,%91object Object%93&#8243; quote_text_shadow_horizontal_length_tablet=&#8221;0px&#8221; quote_text_shadow_vertical_length=&#8221;quote_text_shadow_style,%91object Object%93&#8243; quote_text_shadow_vertical_length_tablet=&#8221;0px&#8221; quote_text_shadow_blur_strength=&#8221;quote_text_shadow_style,%91object Object%93&#8243; quote_text_shadow_blur_strength_tablet=&#8221;1px&#8221; header_text_shadow_horizontal_length=&#8221;header_text_shadow_style,%91object Object%93&#8243; header_text_shadow_horizontal_length_tablet=&#8221;0px&#8221; header_text_shadow_vertical_length=&#8221;header_text_shadow_style,%91object Object%93&#8243; header_text_shadow_vertical_length_tablet=&#8221;0px&#8221; header_text_shadow_blur_strength=&#8221;header_text_shadow_style,%91object Object%93&#8243; header_text_shadow_blur_strength_tablet=&#8221;1px&#8221; header_2_text_shadow_horizontal_length=&#8221;header_2_text_shadow_style,%91object Object%93&#8243; header_2_text_shadow_horizontal_length_tablet=&#8221;0px&#8221; header_2_text_shadow_vertical_length=&#8221;header_2_text_shadow_style,%91object Object%93&#8243; header_2_text_shadow_vertical_length_tablet=&#8221;0px&#8221; header_2_text_shadow_blur_strength=&#8221;header_2_text_shadow_style,%91object Object%93&#8243; header_2_text_shadow_blur_strength_tablet=&#8221;1px&#8221; header_3_text_shadow_horizontal_length=&#8221;header_3_text_shadow_style,%91object Object%93&#8243; header_3_text_shadow_horizontal_length_tablet=&#8221;0px&#8221; header_3_text_shadow_vertical_length=&#8221;header_3_text_shadow_style,%91object Object%93&#8243; header_3_text_shadow_vertical_length_tablet=&#8221;0px&#8221; header_3_text_shadow_blur_strength=&#8221;header_3_text_shadow_style,%91object Object%93&#8243; header_3_text_shadow_blur_strength_tablet=&#8221;1px&#8221; header_4_text_shadow_horizontal_length=&#8221;header_4_text_shadow_style,%91object Object%93&#8243; header_4_text_shadow_horizontal_length_tablet=&#8221;0px&#8221; header_4_text_shadow_vertical_length=&#8221;header_4_text_shadow_style,%91object Object%93&#8243; header_4_text_shadow_vertical_length_tablet=&#8221;0px&#8221; header_4_text_shadow_blur_strength=&#8221;header_4_text_shadow_style,%91object Object%93&#8243; header_4_text_shadow_blur_strength_tablet=&#8221;1px&#8221; header_5_text_shadow_horizontal_length=&#8221;header_5_text_shadow_style,%91object Object%93&#8243; header_5_text_shadow_horizontal_length_tablet=&#8221;0px&#8221; header_5_text_shadow_vertical_length=&#8221;header_5_text_shadow_style,%91object Object%93&#8243; header_5_text_shadow_vertical_length_tablet=&#8221;0px&#8221; header_5_text_shadow_blur_strength=&#8221;header_5_text_shadow_style,%91object Object%93&#8243; header_5_text_shadow_blur_strength_tablet=&#8221;1px&#8221; header_6_text_shadow_horizontal_length=&#8221;header_6_text_shadow_style,%91object Object%93&#8243; header_6_text_shadow_horizontal_length_tablet=&#8221;0px&#8221; header_6_text_shadow_vertical_length=&#8221;header_6_text_shadow_style,%91object Object%93&#8243; header_6_text_shadow_vertical_length_tablet=&#8221;0px&#8221; header_6_text_shadow_blur_strength=&#8221;header_6_text_shadow_style,%91object Object%93&#8243; header_6_text_shadow_blur_strength_tablet=&#8221;1px&#8221; box_shadow_horizontal_tablet=&#8221;0px&#8221; box_shadow_vertical_tablet=&#8221;0px&#8221; box_shadow_blur_tablet=&#8221;40px&#8221; box_shadow_spread_tablet=&#8221;0px&#8221; vertical_offset_tablet=&#8221;0&#8243; horizontal_offset_tablet=&#8221;0&#8243; z_index_tablet=&#8221;0&#8243;]<\/p>\n<div class=\"_1pbyzo7u _kqswpfqs\" data-testid=\"with-sticky-header\" data-vc=\"sticky-wrapper-css-container\">\n<div class=\"_n7zlglyw _1pby1ial _bfhkvuon _18u014id _19bv19bv _n3td19bv _1bsb1kw7\" data-test-id=\"header-animated-box\" data-vc=\"header-animated-box\">\n<div class=\"_n7zlglyw _1pby1ial _1bsb1osq _1e0c1txw _2lx21bp4 _vchhusvi _p12f18ua _kqsw1n9t _bfhkvuon _1ltv1d4h _18u0idpf\">\n<div class=\"_zulpv77o _4t3i8vuz _1e0c1txw _4cvr1h6o _ca0qidpf _u5f31crf _n3tdidpf _19bv1crf\" data-testid=\"content-header-container\">\n<div class=\"cc-6oa946\" data-testid=\"breadcrumb\">\n<div class=\"cc-1iek1a2\" data-testid=\"breadcrumbs-with-space-name-dropdown\" data-ssr-placeholder=\"b4n75:4y5Pz:qz-Pe:F4Zdx-0\">\n<div class=\"cc-g7kpby\">\u00a0<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<div data-testid=\"content-container-component\">\n<div class=\"cc-12o10oz\">\n<div data-testid=\"title-wrapper\">\n<div class=\"_1e0c1o8l _vchhusvi _1tke68cl _1bsb1osq _p12f1osq\" data-test-id=\"page-content-header\" data-testid=\"page-content-header\">\n<div class=\"_kqswh2mm _otyr1ejb\">\n<div id=\"title-text\" class=\"_19pkidpf _2hwxidpf _otyridpf _18u0idpf _syaz1fxt _1nmz1hna _slp31hna _o57218hr _1tkeldb6 _80omtlke _1e0c1txw _1wnx1c04 _ik201h6o _15cmi7a9 _8lw010th _1mb8n7od _sf7z18uv _ca0qidpf _lcxv73ad\" data-test-id=\"title-text\" data-testid=\"title-text\">\n<div role=\"presentation\"><a href=\"https:\/\/labs.icahn.mssm.edu\/minervalab\/scientific-computing-and-data\">Scientific Computing and Data<\/a>\u00a0\/\u00a0<a href=\"https:\/\/labs.icahn.mssm.edu\/msdw\">Mount Sinai Data Warehouse<\/a>\u00a0\/OMOP Development\/Configure DBeaver to connect to MSDW2<\/div>\n<\/div>\n<\/div>\n<div class=\"cc-k5cxwk\" data-testid=\"content-title-and-byline\">\n<div class=\"_11c81o8v _18s8t1lt _syaz1gjq _1e0c1txw _4cvr1h6o _y3gn1kw7 page-metadata-modification-info\">\n<div class=\"_1bsb1osq _593818uv _yha2glyw _1nmznqa1 _43ds14q2 _7hxb18uv _9m7f18uv _rfqo18uv _qfs118uv _15zv8stv _w7sw8stv _1bgk8stv _s41o8stv _1xvinqa1 _15a9nqa1 _1t0pnqa1 _1k6pnqa1 _p03c16c2 _oavv16c2 _oxk416c2 _1cay16c2 _19pkidpf _2hwxidpf _otyridpf _18u0idpf\">\n<div class=\"_11c81o8v _18s8ze3t _syaz1gjq _1e0c1txw _4cvr1h6o _y3gn1kw7 _16jlkb7n _1pby1wug _o5721q9c _4t3i1wug _1bsb1osq _kqswh2mm _7yjrt94y _1r3z1n1a\">\n<div class=\"cc-1xqzyhu\" data-testid=\"byline-single-line\">\n<div role=\"presentation\">\n<div class=\"cc-r48y2c\">\n<div class=\"_12ji1r31 _1qu2glyw _12y3idpf _1e0c1o8l _kqswh2mm\">\u00a0<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.27.4&#8243; _module_preset=&#8221;default&#8221; background_pattern_color=&#8221;rgba(0,0,0,0.2)&#8221; background_mask_color=&#8221;#ffffff&#8221; text_text_shadow_horizontal_length=&#8221;text_text_shadow_style,%91object Object%93&#8243; text_text_shadow_horizontal_length_tablet=&#8221;0px&#8221; text_text_shadow_vertical_length=&#8221;text_text_shadow_style,%91object Object%93&#8243; text_text_shadow_vertical_length_tablet=&#8221;0px&#8221; text_text_shadow_blur_strength=&#8221;text_text_shadow_style,%91object Object%93&#8243; text_text_shadow_blur_strength_tablet=&#8221;1px&#8221; link_text_shadow_horizontal_length=&#8221;link_text_shadow_style,%91object Object%93&#8243; link_text_shadow_horizontal_length_tablet=&#8221;0px&#8221; link_text_shadow_vertical_length=&#8221;link_text_shadow_style,%91object Object%93&#8243; link_text_shadow_vertical_length_tablet=&#8221;0px&#8221; link_text_shadow_blur_strength=&#8221;link_text_shadow_style,%91object Object%93&#8243; link_text_shadow_blur_strength_tablet=&#8221;1px&#8221; ul_text_shadow_horizontal_length=&#8221;ul_text_shadow_style,%91object Object%93&#8243; ul_text_shadow_horizontal_length_tablet=&#8221;0px&#8221; ul_text_shadow_vertical_length=&#8221;ul_text_shadow_style,%91object Object%93&#8243; ul_text_shadow_vertical_length_tablet=&#8221;0px&#8221; ul_text_shadow_blur_strength=&#8221;ul_text_shadow_style,%91object Object%93&#8243; ul_text_shadow_blur_strength_tablet=&#8221;1px&#8221; ol_text_shadow_horizontal_length=&#8221;ol_text_shadow_style,%91object Object%93&#8243; ol_text_shadow_horizontal_length_tablet=&#8221;0px&#8221; ol_text_shadow_vertical_length=&#8221;ol_text_shadow_style,%91object Object%93&#8243; ol_text_shadow_vertical_length_tablet=&#8221;0px&#8221; ol_text_shadow_blur_strength=&#8221;ol_text_shadow_style,%91object Object%93&#8243; ol_text_shadow_blur_strength_tablet=&#8221;1px&#8221; quote_text_shadow_horizontal_length=&#8221;quote_text_shadow_style,%91object Object%93&#8243; quote_text_shadow_horizontal_length_tablet=&#8221;0px&#8221; quote_text_shadow_vertical_length=&#8221;quote_text_shadow_style,%91object Object%93&#8243; quote_text_shadow_vertical_length_tablet=&#8221;0px&#8221; quote_text_shadow_blur_strength=&#8221;quote_text_shadow_style,%91object Object%93&#8243; quote_text_shadow_blur_strength_tablet=&#8221;1px&#8221; header_text_shadow_horizontal_length=&#8221;header_text_shadow_style,%91object Object%93&#8243; header_text_shadow_horizontal_length_tablet=&#8221;0px&#8221; header_text_shadow_vertical_length=&#8221;header_text_shadow_style,%91object Object%93&#8243; header_text_shadow_vertical_length_tablet=&#8221;0px&#8221; header_text_shadow_blur_strength=&#8221;header_text_shadow_style,%91object Object%93&#8243; header_text_shadow_blur_strength_tablet=&#8221;1px&#8221; header_2_text_shadow_horizontal_length=&#8221;header_2_text_shadow_style,%91object Object%93&#8243; header_2_text_shadow_horizontal_length_tablet=&#8221;0px&#8221; header_2_text_shadow_vertical_length=&#8221;header_2_text_shadow_style,%91object Object%93&#8243; header_2_text_shadow_vertical_length_tablet=&#8221;0px&#8221; header_2_text_shadow_blur_strength=&#8221;header_2_text_shadow_style,%91object Object%93&#8243; header_2_text_shadow_blur_strength_tablet=&#8221;1px&#8221; header_3_text_shadow_horizontal_length=&#8221;header_3_text_shadow_style,%91object Object%93&#8243; header_3_text_shadow_horizontal_length_tablet=&#8221;0px&#8221; header_3_text_shadow_vertical_length=&#8221;header_3_text_shadow_style,%91object Object%93&#8243; header_3_text_shadow_vertical_length_tablet=&#8221;0px&#8221; header_3_text_shadow_blur_strength=&#8221;header_3_text_shadow_style,%91object Object%93&#8243; header_3_text_shadow_blur_strength_tablet=&#8221;1px&#8221; header_4_text_shadow_horizontal_length=&#8221;header_4_text_shadow_style,%91object Object%93&#8243; header_4_text_shadow_horizontal_length_tablet=&#8221;0px&#8221; header_4_text_shadow_vertical_length=&#8221;header_4_text_shadow_style,%91object Object%93&#8243; header_4_text_shadow_vertical_length_tablet=&#8221;0px&#8221; header_4_text_shadow_blur_strength=&#8221;header_4_text_shadow_style,%91object Object%93&#8243; header_4_text_shadow_blur_strength_tablet=&#8221;1px&#8221; header_5_text_shadow_horizontal_length=&#8221;header_5_text_shadow_style,%91object Object%93&#8243; header_5_text_shadow_horizontal_length_tablet=&#8221;0px&#8221; header_5_text_shadow_vertical_length=&#8221;header_5_text_shadow_style,%91object Object%93&#8243; header_5_text_shadow_vertical_length_tablet=&#8221;0px&#8221; header_5_text_shadow_blur_strength=&#8221;header_5_text_shadow_style,%91object Object%93&#8243; header_5_text_shadow_blur_strength_tablet=&#8221;1px&#8221; header_6_text_shadow_horizontal_length=&#8221;header_6_text_shadow_style,%91object Object%93&#8243; header_6_text_shadow_horizontal_length_tablet=&#8221;0px&#8221; header_6_text_shadow_vertical_length=&#8221;header_6_text_shadow_style,%91object Object%93&#8243; header_6_text_shadow_vertical_length_tablet=&#8221;0px&#8221; header_6_text_shadow_blur_strength=&#8221;header_6_text_shadow_style,%91object Object%93&#8243; header_6_text_shadow_blur_strength_tablet=&#8221;1px&#8221; box_shadow_horizontal_tablet=&#8221;0px&#8221; box_shadow_vertical_tablet=&#8221;0px&#8221; box_shadow_blur_tablet=&#8221;40px&#8221; box_shadow_spread_tablet=&#8221;0px&#8221; vertical_offset_tablet=&#8221;0&#8243; horizontal_offset_tablet=&#8221;0&#8243; z_index_tablet=&#8221;0&#8243;]<\/p>\n<div class=\"_1pbyzo7u _kqswpfqs\" data-testid=\"with-sticky-header\" data-vc=\"sticky-wrapper-css-container\">\n<div class=\"_n7zlglyw _1pby1ial _bfhkvuon _18u014id _19bv19bv _n3td19bv _1bsb1kw7\" data-test-id=\"header-animated-box\" data-vc=\"header-animated-box\">\n<div class=\"_n7zlglyw _1pby1ial _1bsb1osq _1e0c1txw _2lx21bp4 _vchhusvi _p12f18ua _kqsw1n9t _bfhkvuon _1ltv1d4h _18u0idpf\">\n<div class=\"_zulpv77o _4t3i8vuz _1e0c1txw _4cvr1h6o _ca0qidpf _u5f31crf _n3tdidpf _19bv1crf\" data-testid=\"content-header-container\">\n<div class=\"cc-6oa946\" data-testid=\"breadcrumb\">\n<div class=\"cc-1iek1a2\" data-testid=\"breadcrumbs-with-space-name-dropdown\" data-ssr-placeholder=\"b4n75:4y5Pz:qz-Pe:F4Zdx-0\">\n<div class=\"cc-g7kpby\">\n<div id=\"breadcrumbs-space-name\" class=\"_1reo15vq _18m915vq _11c82smr _1bton7od _1bsb1osq _o5721q9c _p12f1osq _1nwp1wyi _1w801wyi\"><strong style=\"color: #00aeef;font-size: 30px\">Configure DBeaver to connect to MSDW2<\/strong><\/div>\n<\/div>\n<\/div>\n<div>\u00a0<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<div data-testid=\"content-container-component\">\n<div class=\"cc-12o10oz\">\n<div data-testid=\"title-wrapper\">\n<div class=\"_1e0c1o8l _vchhusvi _1tke68cl _1bsb1osq _p12f1osq\" data-test-id=\"page-content-header\" data-testid=\"page-content-header\">\n<div class=\"_kqswh2mm _otyr1ejb\">\n<div id=\"title-text\" class=\"_19pkidpf _2hwxidpf _otyridpf _18u0idpf _syaz1fxt _1nmz1hna _slp31hna _o57218hr _1tkeldb6 _80omtlke _1e0c1txw _1wnx1c04 _ik201h6o _15cmi7a9 _8lw010th _1mb8n7od _sf7z18uv _ca0qidpf _lcxv73ad\" data-test-id=\"title-text\" data-testid=\"title-text\">\n<div role=\"presentation\">\n<h2 id=\"ConfigureDBeavertoconnecttoMSDW2-StepsforAllUsers\"><strong><span style=\"color: #00aeef\">Steps for All Users<\/span><\/strong><\/h2>\n<hr \/>\n<ul>\n<li>Download DBeaver from the following website:\u00a0<a class=\"external-link\" href=\"https:\/\/dbeaver.io\/download\/\" rel=\"nofollow\">https:\/\/dbeaver.io\/download\/<\/a>\n<ul>\n<li>If you have a School <strong>mssm.edu<\/strong>\u00a0email address, you are eligible to obtain the full featured &#8220;Enterprise Edition&#8221; of DBeaver free of charge<\/li>\n<li>Other users should download the DBeaver &#8220;Community Edition&#8221; \u2013 which doesn&#8217;t have all the features of &#8220;Enterprise Edition&#8221; but should be adequate for almost all users<\/li>\n<\/ul>\n<\/li>\n<li>Ensure you have the proper SQL Server driver installed: \u00a0<span data-colorid=\"mvb9e3pfd0\">Microsoft JDBC Driver for SQL Server<\/span>\n<ul>\n<li><span data-colorid=\"sq1rkwedun\">To install a new driver (<a class=\"external-link\" href=\"https:\/\/dbeaver.com\/docs\/wiki\/Database-drivers\/#adding-driver-configuration-in-dbeaver\" rel=\"nofollow\">DBeaver docs<\/a>), in the\u00a0<em>Database<\/em>\u00a0menu click &#8220;Driver Manager&#8221;, which opens this modal:<br \/><\/span><span data-colorid=\"kxx1ttsv71\"><span class=\"confluence-embedded-file-wrapper confluence-embedded-manual-size\"><img loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-3821 aligncenter\" src=\"https:\/\/labs.icahn.mssm.edu\/msdw\/wp-content\/uploads\/sites\/350\/2025\/09\/image2021-12-21_14-47-15-300x270.png\" alt=\"\" width=\"300\" height=\"270\" \/>\u00a0<\/span><\/span><\/li>\n<li><span data-colorid=\"dha3m8wb4x\">Select MS SQL Server, New, and configure these driver settings:<\/span><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p><span class=\"confluence-embedded-file-wrapper confluence-embedded-manual-size\"><span data-colorid=\"x9lj5nauoj\"><img loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-3823 aligncenter\" src=\"https:\/\/labs.icahn.mssm.edu\/msdw\/wp-content\/uploads\/sites\/350\/2025\/09\/image2021-12-21_15-2-10-300x191.png\" alt=\"\" width=\"300\" height=\"191\" \/><\/span><\/span><\/p>\n<ul>\n<li style=\"list-style-type: none\">\n<ul>\n<li>\n<p class=\"auto-cursor-target\"><span data-colorid=\"cae9pzwf0k\">Click on the Libraries tab. Click on Add Artifact\u2192 Under Dependency Declaration add below maven config to get all the dependencies.<\/span><\/p>\n<div class=\"code panel pdl conf-macro output-block\" data-hasbody=\"true\" data-macro-id=\"f46d90ae-9223-4c20-9564-7d3edb607201\" data-macro-name=\"code\">\n<div class=\"codeContent panelContent pdl\">\n<div>\n<div id=\"highlighter_353344\" class=\"syntaxhighlighter sh-confluence nogutter xml\">\n<table border=\"0\" cellspacing=\"0\" cellpadding=\"0\">\n<tbody>\n<tr>\n<td class=\"code\">\n<div class=\"container\" title=\"Hint: double-click to select code\">\n<div class=\"line number1 index0 alt2\" data-bidi-marker=\"true\"><code class=\"xml plain\">&lt;<\/code><code class=\"xml keyword\">dependency<\/code><code class=\"xml plain\">&gt;<\/code><\/div>\n<div class=\"line number3 index2 alt2\" data-bidi-marker=\"true\"><code class=\"xml spaces\">\u00a0\u00a0<\/code><code class=\"xml plain\">&lt;<\/code><code class=\"xml keyword\">groupId<\/code><code class=\"xml plain\">&gt;com.microsoft.azure&lt;\/<\/code><code class=\"xml keyword\">groupId<\/code><code class=\"xml plain\">&gt;<\/code><\/div>\n<div class=\"line number5 index4 alt2\" data-bidi-marker=\"true\"><code class=\"xml spaces\">\u00a0\u00a0<\/code><code class=\"xml plain\">&lt;<\/code><code class=\"xml keyword\">artifactId<\/code><code class=\"xml plain\">&gt;adal4j&lt;\/<\/code><code class=\"xml keyword\">artifactId<\/code><code class=\"xml plain\">&gt;<\/code><\/div>\n<div class=\"line number7 index6 alt2\" data-bidi-marker=\"true\"><code class=\"xml spaces\">\u00a0\u00a0<\/code><code class=\"xml plain\">&lt;<\/code><code class=\"xml keyword\">version<\/code><code class=\"xml plain\">&gt;1.6.7&lt;\/<\/code><code class=\"xml keyword\">version<\/code><code class=\"xml plain\">&gt;<\/code><\/div>\n<div class=\"line number9 index8 alt2\" data-bidi-marker=\"true\"><code class=\"xml plain\">&lt;\/<\/code><code class=\"xml keyword\">dependency<\/code><code class=\"xml plain\">&gt;<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>\u00a0<\/p>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/li>\n<li>\n<p class=\"auto-cursor-target\">Once added, select the dependency from options &amp; click on Download\/update.Accept all downloads.The result should look like this:<\/p>\n<p><span data-colorid=\"x9lj5nauoj\"><span class=\"confluence-embedded-file-wrapper confluence-embedded-manual-size\"><img loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-3824 aligncenter\" src=\"https:\/\/labs.icahn.mssm.edu\/msdw\/wp-content\/uploads\/sites\/350\/2025\/09\/image2021-12-22_10-56-24-300x159.png\" alt=\"\" width=\"300\" height=\"159\" \/><br \/><\/span><\/span><\/p>\n<\/li>\n<\/ul>\n<\/li>\n<li>Create connection to MSDW2\n<ul>\n<li>Peripheral to DBeaver, a user&#8217;s AD credentials must be added to the appropriate security group(s). To configure:\n<ul>\n<li>Submit a Sailpoint ticket for a user to be added to (<em>need more information on appropriate MSDW2 group<\/em>)<\/li>\n<\/ul>\n<\/li>\n<li>From the Database Navigator, right click on the &#8220;master&#8221; database and select &#8220;Edit Connection&#8221;<\/li>\n<li>\u00a0From Connection settings, select the Main tab<\/li>\n<li>Input the following:\n<ul>\n<li>Host:\u00a0<a class=\"external-link\" href=\"http:\/\/msdw_prd.mountsinai.org\/\" rel=\"nofollow\">MSDW_PRD.mountsinai.org<\/a><\/li>\n<li>Port: 1433<\/li>\n<li>Authentication: Kerberos<\/li>\n<li>Username &amp; Password reflect existing Mount Sinai ID and password<br \/><span data-colorid=\"kxx1ttsv71\"><span class=\"confluence-embedded-file-wrapper confluence-embedded-manual-size\"><img loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-3825 aligncenter\" src=\"https:\/\/labs.icahn.mssm.edu\/msdw\/wp-content\/uploads\/sites\/350\/2025\/09\/InkedDBBeaver.png-300x223.jpg\" alt=\"\" width=\"300\" height=\"223\" \/><\/span><\/span><\/li>\n<\/ul>\n<\/li>\n<li>Select &#8220;Test Connection&#8221; at the bottom-right of the pop-up to determine success in the connection<\/li>\n<li>If successful, click &#8220;OK&#8221;<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<h2>\u00a0<\/h2>\n<h2 id=\"ConfigureDBeavertoconnecttoMSDW2-AdditionalStepsforMacOS&amp;LinuxUsers\"><strong><span style=\"color: #00aeef\">Additional Steps for MacOS &amp; Linux Users<\/span><\/strong><\/h2>\n<hr \/>\n<p class=\"auto-cursor-target\">In your \/etc directory, create a text file called krb5.conf with the following contents:<\/p>\n<div class=\"code panel pdl conf-macro output-block\" data-hasbody=\"true\" data-macro-id=\"f564851e-bd79-447d-bc0c-37bedb4d316a\" data-macro-name=\"code\">\n<div class=\"codeHeader panelHeader pdl\"><b>krb5.conf<\/b><\/div>\n<div class=\"codeContent panelContent pdl\">\n<div>\n<div id=\"highlighter_25613\" class=\"syntaxhighlighter sh-confluence nogutter text\">\n<table border=\"0\" cellspacing=\"0\" cellpadding=\"0\">\n<tbody>\n<tr>\n<td class=\"code\">\n<div class=\"container\" title=\"Hint: double-click to select code\">\n<div class=\"line number1 index0 alt2\" data-bidi-marker=\"true\"><code class=\"text plain\">[libdefaults]<\/code><\/div>\n<div class=\"line number2 index1 alt1\" data-bidi-marker=\"true\"><code class=\"text spaces\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code><code class=\"text plain\">default_realm = MSNYUHEALTH.ORG<\/code><\/div>\n<div class=\"line number3 index2 alt2\" data-bidi-marker=\"true\"><code class=\"text spaces\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code><code class=\"text plain\">kdc_timesync = 1<\/code><\/div>\n<div class=\"line number4 index3 alt1\" data-bidi-marker=\"true\"><code class=\"text spaces\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code><code class=\"text plain\">ccache_type = 4<\/code><\/div>\n<div class=\"line number5 index4 alt2\" data-bidi-marker=\"true\"><code class=\"text spaces\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code><code class=\"text plain\">forwardable = true<\/code><\/div>\n<div class=\"line number6 index5 alt1\" data-bidi-marker=\"true\"><code class=\"text spaces\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code><code class=\"text plain\">proxiable = true<\/code><\/div>\n<div class=\"line number7 index6 alt2\" data-bidi-marker=\"true\"><code class=\"text spaces\">\u00a0<\/code><\/div>\n<div class=\"line number8 index7 alt1\" data-bidi-marker=\"true\"><code class=\"text plain\">[realms]<\/code><\/div>\n<div class=\"line number9 index8 alt2\" data-bidi-marker=\"true\"><code class=\"text spaces\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code><code class=\"text plain\">MSSMCAMPUS.MSSM.EDU = {<\/code><\/div>\n<div class=\"line number10 index9 alt1\" data-bidi-marker=\"true\"><code class=\"text spaces\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code><code class=\"text plain\">kdc = ad.mssm.edu<\/code><\/div>\n<div class=\"line number11 index10 alt2\" data-bidi-marker=\"true\"><code class=\"text spaces\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code><code class=\"text plain\">admin_server = ad.mssm.edu<\/code><\/div>\n<div class=\"line number12 index11 alt1\" data-bidi-marker=\"true\"><code class=\"text spaces\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code><code class=\"text plain\">default_domain = MSSMCAMPUS.MSSM.EDU<\/code><\/div>\n<div class=\"line number13 index12 alt2\" data-bidi-marker=\"true\"><code class=\"text spaces\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code><code class=\"text plain\">}<\/code><\/div>\n<div class=\"line number14 index13 alt1\" data-bidi-marker=\"true\"><code class=\"text spaces\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code><code class=\"text plain\">MSNYUHEALTH.ORG = {<\/code><\/div>\n<div class=\"line number15 index14 alt2\" data-bidi-marker=\"true\"><code class=\"text spaces\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code><code class=\"text plain\">kdc = ad.mountsinai.org<\/code><\/div>\n<div class=\"line number16 index15 alt1\" data-bidi-marker=\"true\"><code class=\"text spaces\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code><code class=\"text plain\">admin_server = ad.mountsinai.org<\/code><\/div>\n<div class=\"line number17 index16 alt2\" data-bidi-marker=\"true\"><code class=\"text spaces\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code><code class=\"text plain\">default_domain = MSNYUHEALTH.ORG<\/code><\/div>\n<div class=\"line number18 index17 alt1\" data-bidi-marker=\"true\"><code class=\"text spaces\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code><code class=\"text plain\">}<\/code><\/div>\n<div class=\"line number19 index18 alt2\" data-bidi-marker=\"true\"><code class=\"text spaces\">\u00a0<\/code><\/div>\n<div class=\"line number20 index19 alt1\" data-bidi-marker=\"true\"><code class=\"text plain\">[domain_realm]<\/code><\/div>\n<div class=\"line number21 index20 alt2\" data-bidi-marker=\"true\"><code class=\"text spaces\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code><code class=\"text plain\">mssm.edu = MSSMCAMPUS.MSSM.EDU<\/code><\/div>\n<div class=\"line number22 index21 alt1\" data-bidi-marker=\"true\"><code class=\"text spaces\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code><code class=\"text plain\">.mssm.edu = MSSMCAMPUS.MSSM.EDU<\/code><\/div>\n<div class=\"line number23 index22 alt2\" data-bidi-marker=\"true\"><code class=\"text spaces\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code><code class=\"text plain\">mountsinai.org = MSNYUHEALTH.ORG<\/code><\/div>\n<div class=\"line number24 index23 alt1\" data-bidi-marker=\"true\"><code class=\"text spaces\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code><code class=\"text plain\">.mountsinai.org = MSNYUHEALTH.ORG<\/code><\/div>\n<div class=\"line number25 index24 alt2\" data-bidi-marker=\"true\"><code class=\"text spaces\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code><code class=\"text plain\">msnyuhealth.org = MSNYUHEALTH.ORG<\/code><\/div>\n<div class=\"line number26 index25 alt1\" data-bidi-marker=\"true\"><code class=\"text spaces\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code><code class=\"text plain\">.msnyuhealth.org = MSNYUHEALTH.ORG<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<p class=\"auto-cursor-target\">Open a terminal and enter the following commands, where lastnf99 is your AD username following by either @msnyuhealth.org (for Hospital users) or @mssmcampus.mssm.edu (for School users):<\/p>\n<div class=\"code panel pdl conf-macro output-block\" data-hasbody=\"true\" data-macro-id=\"7b4f1990-09ec-49c0-92c1-0a2a913f994b\" data-macro-name=\"code\">\n<div class=\"codeHeader panelHeader pdl\"><b>Terminal Commands<\/b><\/div>\n<div class=\"codeContent panelContent pdl\">\n<div>\n<div id=\"highlighter_435947\" class=\"syntaxhighlighter sh-confluence nogutter text\">\n<table border=\"0\" cellspacing=\"0\" cellpadding=\"0\">\n<tbody>\n<tr>\n<td class=\"code\">\n<div class=\"container\" title=\"Hint: double-click to select code\">\n<div class=\"line number1 index0 alt2\" data-bidi-marker=\"true\"><code class=\"text plain\">$ kinit lastnf99@MSNYUHEALTH.ORG<\/code><\/div>\n<div class=\"line number2 index1 alt1\" data-bidi-marker=\"true\"><code class=\"text plain\">Password for lastnf99@MSNYUHEALTH.ORG: &lt;enter your password here&gt;<\/code><\/div>\n<div class=\"line number3 index2 alt2\" data-bidi-marker=\"true\">\u00a0<\/div>\n<div class=\"line number4 index3 alt1\" data-bidi-marker=\"true\"><code class=\"text plain\">$ klist<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<p class=\"auto-cursor-target\">You should then see output similar to this:<\/p>\n<div class=\"code panel pdl conf-macro output-block\" data-hasbody=\"true\" data-macro-id=\"ce514551-dfb8-4278-a825-376f807a5aa0\" data-macro-name=\"code\">\n<div class=\"codeHeader panelHeader pdl\"><b>Terminal Output<\/b><\/div>\n<div class=\"codeContent panelContent pdl\">\n<div>\n<div id=\"highlighter_665149\" class=\"syntaxhighlighter sh-confluence nogutter text\">\n<table border=\"0\" cellspacing=\"0\" cellpadding=\"0\">\n<tbody>\n<tr>\n<td class=\"code\">\n<div class=\"container\" title=\"Hint: double-click to select code\">\n<div class=\"line number1 index0 alt2\" data-bidi-marker=\"true\"><code class=\"text plain\">Credentials cache: API:93D78EDD-9E69-47F5-86B3-ED1B6F66C29C<\/code><\/div>\n<div class=\"line number2 index1 alt1\" data-bidi-marker=\"true\"><code class=\"text spaces\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code><code class=\"text plain\">Principal: yul09@MSNYUHEALTH.ORG<\/code><\/div>\n<div class=\"line number3 index2 alt2\" data-bidi-marker=\"true\"><code class=\"text spaces\">\u00a0<\/code><\/div>\n<div class=\"line number4 index3 alt1\" data-bidi-marker=\"true\"><code class=\"text spaces\">\u00a0\u00a0<\/code><code class=\"text plain\">Issued\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Expires\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Principal<\/code><\/div>\n<div class=\"line number5 index4 alt2\" data-bidi-marker=\"true\"><code class=\"text plain\">Jul 29 11:54:10 2021\u00a0 Jul 29 21:53:56 2021\u00a0 krbtgt\/MSNYUHEALTH.ORG@MSNYUHEALTH.ORG<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<p class=\"auto-cursor-target\">In DBeaver&#8217;s dialog box for your connection to MSDW2, set the following in the &#8220;Main&#8221; connection parameters tab:<\/p>\n<p class=\"auto-cursor-target\"><span class=\"confluence-embedded-file-wrapper confluence-embedded-manual-size\"><img loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-3826 aligncenter\" src=\"https:\/\/labs.icahn.mssm.edu\/msdw\/wp-content\/uploads\/sites\/350\/2025\/09\/DBeaver-connection-via-Kerberos-300x211.png\" alt=\"\" width=\"300\" height=\"211\" \/><\/span><\/p>\n<p class=\"auto-cursor-target\">In DBeaver&#8217;s dialog box for your connection to MSDW2, click on the &#8220;Driver properties&#8221; tab and set the following values:<\/p>\n<div class=\"table-wrap\">\n<table class=\"wrapped confluenceTable tablesorter tablesorter-default\" role=\"grid\">\n<colgroup>\n<col \/>\n<col \/>\n<col \/><\/colgroup>\n<thead><\/thead>\n<tbody aria-live=\"polite\">\n<tr role=\"row\">\n<td class=\"confluenceTd\">Parameter<\/td>\n<td class=\"confluenceTd\">Value<\/td>\n<td class=\"confluenceTd\" colspan=\"1\">Comment<\/td>\n<\/tr>\n<tr role=\"row\">\n<td class=\"confluenceTd\">serverName<\/td>\n<td class=\"confluenceTd\"><a class=\"external-link\" href=\"http:\/\/msdw_prd.mountsinai.org\/\" rel=\"nofollow\">MSDW_PRD.mountsinai.org<\/a><\/td>\n<td class=\"confluenceTd\" colspan=\"1\">If configuring a connection to the development environment, use msdw2-mssql-dv2.msnyuhealth.org instead<\/td>\n<\/tr>\n<tr role=\"row\">\n<td class=\"confluenceTd\">databaseName<\/td>\n<td class=\"confluenceTd\">omop<\/td>\n<td class=\"confluenceTd\" colspan=\"1\">Most users will have access only to the omop database, but Scientific Computing users could choose a different default<\/td>\n<\/tr>\n<tr role=\"row\">\n<td class=\"confluenceTd\">integratedSecurity<\/td>\n<td class=\"confluenceTd\">true<\/td>\n<td class=\"confluenceTd\" colspan=\"1\">\u00a0<\/td>\n<\/tr>\n<tr role=\"row\">\n<td class=\"confluenceTd\" colspan=\"1\">encrypt<\/td>\n<td class=\"confluenceTd\" colspan=\"1\">true<\/td>\n<td class=\"confluenceTd\" colspan=\"1\">\u00a0<\/td>\n<\/tr>\n<tr role=\"row\">\n<td class=\"confluenceTd\" colspan=\"1\">authenticationScheme<\/td>\n<td class=\"confluenceTd\" colspan=\"1\">JavaKerberos<\/td>\n<td class=\"confluenceTd\" colspan=\"1\">This setting is to align with the &#8220;Kerberos&#8221; authentication setting on the &#8220;Main&#8221; connection parameters tab<\/td>\n<\/tr>\n<tr role=\"row\">\n<td class=\"confluenceTd\" colspan=\"1\">trustStoreType<\/td>\n<td class=\"confluenceTd\" colspan=\"1\">KeychainStore<\/td>\n<td class=\"confluenceTd\" colspan=\"1\">\n<p>This setting is required by MacOS (not sure about Linux)<\/p>\n<p><a class=\"external-link\" href=\"https:\/\/github.com\/dbeaver\/dbeaver\/discussions\/13386\" rel=\"nofollow\">According to Arthur<\/a>: &#8220;<span data-colorid=\"ot5wjc8447\">To make [this]<\/span><span data-colorid=\"r8b0thk9o2\">\u00a0work, the Mac&#8217;s Keychain must store a trusted root certificate for the institution where the SQL Server runs.<\/span>&#8220;<\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<div class=\"cc-k5cxwk\" data-testid=\"content-title-and-byline\">\n<div class=\"_11c81o8v _18s8t1lt _syaz1gjq _1e0c1txw _4cvr1h6o _y3gn1kw7 page-metadata-modification-info\">\n<div class=\"_1bsb1osq _593818uv _yha2glyw _1nmznqa1 _43ds14q2 _7hxb18uv _9m7f18uv _rfqo18uv _qfs118uv _15zv8stv _w7sw8stv _1bgk8stv _s41o8stv _1xvinqa1 _15a9nqa1 _1t0pnqa1 _1k6pnqa1 _p03c16c2 _oavv16c2 _oxk416c2 _1cay16c2 _19pkidpf _2hwxidpf _otyridpf _18u0idpf\">\n<div class=\"_11c81o8v _18s8ze3t _syaz1gjq _1e0c1txw _4cvr1h6o _y3gn1kw7 _16jlkb7n _1pby1wug _o5721q9c _4t3i1wug _1bsb1osq _kqswh2mm _7yjrt94y _1r3z1n1a\">\n<div class=\"cc-1xqzyhu\" data-testid=\"byline-single-line\">\n<div role=\"presentation\">\n<div class=\"cc-r48y2c\">\n<div class=\"_12ji1r31 _1qu2glyw _12y3idpf _1e0c1o8l _kqswh2mm\">\n<h2>\u00a0<\/h2>\n<h2 id=\"ConfigureDBeavertoconnecttoMSDW2-AdditionalStepsforMacOS&amp;LinuxUsers\"><strong><span style=\"color: #00aeef\">Alternative Steps for MacOS Users<\/span><\/strong><\/h2>\n<p>For MacOS based devices, in the event difficulties arise in establishing the correct configuration the<strong>\u00a0following software packages may work for certain users<\/strong>:<\/p>\n<ul>\n<li><a href=\"https:\/\/www.jetbrains.com\/datagrip\/\">DataGrip<\/a><\/li>\n<li><a href=\"https:\/\/dbgate.org\/\">DbGate<\/a><\/li>\n<li><a href=\"https:\/\/code.visualstudio.com\/\">VSCode<\/a> and <a href=\"https:\/\/marketplace.visualstudio.com\/items?itemName=ms-mssql.sql-database-projects-vscode\">SQL Database Projects<\/a><\/li>\n<\/ul>\n<\/div>\n<\/div>\n<p>Please visit the <a href=\"https:\/\/labs.icahn.mssm.edu\/msdw\/faqs\/\">MSDW FAQ<\/a> section if additional support is needed.<\/p>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u00a0 Scientific Computing and Data\u00a0\/\u00a0Mount Sinai Data Warehouse\u00a0\/OMOP Development\/Configure DBeaver to connect to MSDW2 \u00a0 Configure DBeaver to connect to MSDW2\u00a0Steps for All UsersDownload DBeaver from the following website:\u00a0https:\/\/dbeaver.io\/download\/If you have a School mssm.edu\u00a0email address, you are eligible to obtain the full featured &#8220;Enterprise Edition&#8221; of DBeaver free of chargeOther users should download the DBeaver [&hellip;]<\/p>\n","protected":false},"author":699,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_et_pb_use_builder":"on","_et_pb_old_content":"","_et_gb_content_width":"","footnotes":""},"class_list":["post-3393","page","type-page","status-publish","hentry"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/labs.icahn.mssm.edu\/msdw\/wp-json\/wp\/v2\/pages\/3393","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/labs.icahn.mssm.edu\/msdw\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/labs.icahn.mssm.edu\/msdw\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/labs.icahn.mssm.edu\/msdw\/wp-json\/wp\/v2\/users\/699"}],"replies":[{"embeddable":true,"href":"https:\/\/labs.icahn.mssm.edu\/msdw\/wp-json\/wp\/v2\/comments?post=3393"}],"version-history":[{"count":30,"href":"https:\/\/labs.icahn.mssm.edu\/msdw\/wp-json\/wp\/v2\/pages\/3393\/revisions"}],"predecessor-version":[{"id":3831,"href":"https:\/\/labs.icahn.mssm.edu\/msdw\/wp-json\/wp\/v2\/pages\/3393\/revisions\/3831"}],"wp:attachment":[{"href":"https:\/\/labs.icahn.mssm.edu\/msdw\/wp-json\/wp\/v2\/media?parent=3393"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}