{"id":1234,"date":"2021-10-26T10:14:39","date_gmt":"2021-10-26T14:14:39","guid":{"rendered":"https:\/\/labs.icahn.mssm.edu\/msdw\/?page_id=1234"},"modified":"2025-06-09T12:32:34","modified_gmt":"2025-06-09T16:32:34","slug":"msdw2-direct-database-access","status":"publish","type":"page","link":"https:\/\/labs.icahn.mssm.edu\/msdw\/msdw2-direct-database-access\/","title":{"rendered":"MSDW2 Direct Database Access"},"content":{"rendered":"

[et_pb_section fb_built=”1″ _builder_version=”4.9.0″ _module_preset=”default” custom_padding=”0px||0px||false|false”][et_pb_row _builder_version=”4.9.0″ _module_preset=”default” custom_padding=”||0px||false|false”][et_pb_column type=”4_4″ _builder_version=”4.9.0″ _module_preset=”default”][et_pb_text admin_label=”Breadcrumb” _builder_version=”4.9.0″ _module_preset=”default”]<\/p>\n

Scientific Computing and Data<\/a>\u00a0\/\u00a0Mount Sinai Data Warehouse<\/a> \/ Direct Access to MSDW2<\/p>\n

[\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section][et_pb_section fb_built=”1″ specialty=”on” _builder_version=”4.9.0″ _module_preset=”default”][et_pb_column type=”2_3″ specialty_columns=”2″ _builder_version=”3.25″ custom_padding=”|||” custom_padding__hover=”|||”][et_pb_row_inner _builder_version=”4.9.0″ _module_preset=”default”][et_pb_column_inner saved_specialty_column_type=”2_3″ _builder_version=”4.9.0″ _module_preset=”default”][et_pb_text _builder_version=”4.9.0″ _module_preset=”default” header_font=”|600|||||||” header_text_color=”#221f72″ header_2_text_color=”#00aeef” header_2_font_size=”24px” header_3_text_color=”#221f72″ hover_enabled=”0″ sticky_enabled=”0″]<\/p>\n

Mount Sinai Data Warehouse Direct Access<\/h1>\n

For those researchers who meet the criteria in the MSDW Direct Database Access Agreement, the MSDW team can provision your direct access to your OMOP data mart in Microsoft SQL Server.<\/p>\n

Don’t have an OMOP Data Mart? Consider requesting a custom data report<\/a> from the MSDW Analyst team or utilizing one of the self-service query tools<\/a> to query MSDW data.<\/p>\n

 <\/p>\n

Request Access to Your Specific Data Mart<\/h2>\n

The MSDW Analyst Team delivered your data to you that included your direct specifications. If you wish to access and interact with the data set directly, it is possible to access the data set on the server.<\/p>\n

Step 1: Sign the Direct Database Access Agreement<\/strong><\/p>\n

Download, read, and sign the MSDW Database Access Agreement<\/a>.<\/p>\n

User must have valid Mount Sinai credentials (Hospital or School) to complete and submit.<\/p>\n

Step 2: Request access to your custom OMOP data mart or MSDW’s de-identified OMOP Database<\/strong><\/p>\n

Navigate to the MSDW Service Desk<\/a> and submit a ticket for “MSDW Data Request.” Ticket must include an attached signed MSDW Database Access Agreement<\/a>. If possible, include details of your custom OMOP Data Mart(s).<\/p>\n