{"id":604,"date":"2016-06-16T21:45:30","date_gmt":"2016-06-16T21:45:30","guid":{"rendered":"http:\/\/zappysys.com\/blog\/?p=604"},"modified":"2025-10-23T23:05:29","modified_gmt":"2025-10-23T23:05:29","slug":"add-remove-mongodb-user-ssis","status":"publish","type":"post","link":"https:\/\/zappysys.com\/blog\/add-remove-mongodb-user-ssis\/","title":{"rendered":"How to add \/ remove MongoDB User in SSIS"},"content":{"rendered":"<h2>Introduction<\/h2>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-2115 alignleft\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2017\/08\/mongodb-logo.png\" alt=\"\" width=\"88\" height=\"88\" \/>In this blog post, you will learn how to call MongoDB Shell Commands from SSIS using the <a href=\"\/\/zappysys.com\/products\/ssis-powerpack\/ssis-mongodb-executesql-task\/\" target=\"_blank\" rel=\"noopener\">MongoDB ExecuteSQL task<\/a><\/p>\n<p>Some use cases for calling <a href=\"\/\/zappysys.com\/onlinehelp\/ssis-powerpack\/scr\/ssis-mongodb-executesql-task.htm#A_Examples\" target=\"_blank\" rel=\"noopener\">MongoDB shell commands are listed here<\/a>.<\/p>\n<p>&nbsp;<\/p>\n<h2>How to call MongoDB Shell Commands in SSIS<\/h2>\n<ol>\n<li>Download and install <a href=\"\/\/zappysys.com\/products\/ssis-powerpack\/\">SSIS PowerPack from here<\/a><\/li>\n<li>From the toolbox of the SSIS designer, drag\u00a0 <a href=\"\/\/zappysys.com\/\/\/zappysys.com\/products\/ssis-powerpack\/ssis-mongodb-executesql-task\/\" target=\"_blank\" rel=\"noopener\">ZS MongoDB ExecuteSQL Task<\/a><\/li>\n<li>Click on New Connection (Next to the connection dropdown)<\/li>\n<li>Configure the MongoDB connection and click Test. Close UI by clicking OK<\/li>\n<li>Now, on the Task UI, configure it as below. Notice the &#8220;Examples&#8221; dropdown. That&#8217;s the best way to learn various commands.<\/li>\n<li>You can also use the &#8220;Insert Variables&#8221; option to make your command dynamic (Read value from SSIS variable)\n<div id=\"attachment_11590\" style=\"width: 969px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2016\/06\/How-to-add-remove-MongoDB-User-in-SSIS.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-11590\" class=\"size-full wp-image-11590\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2016\/06\/How-to-add-remove-MongoDB-User-in-SSIS.png\" alt=\"\" width=\"959\" height=\"575\" srcset=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2016\/06\/How-to-add-remove-MongoDB-User-in-SSIS.png 959w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2016\/06\/How-to-add-remove-MongoDB-User-in-SSIS-300x180.png 300w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2016\/06\/How-to-add-remove-MongoDB-User-in-SSIS-768x460.png 768w\" sizes=\"(max-width: 959px) 100vw, 959px\" \/><\/a><p id=\"caption-attachment-11590\" class=\"wp-caption-text\">How to add\/remove a MongoDB User in SSIS<\/p><\/div><\/li>\n<\/ol>\n<div class=\"mceTemp\"><\/div>\n<h2>Add MongoDB User<\/h2>\n<p>To add a MongoDB user using the <a href=\"\/\/zappysys.com\/\/\/zappysys.com\/products\/ssis-powerpack\/ssis-mongodb-executesql-task\/\" target=\"_blank\" rel=\"noopener\">MongoDB ExecuteSQL Task<\/a>, use the following Script<\/p>\n<pre class=\"lang:js decode:true\">{\r\n scope: 'database',\r\n command: 'eval',\r\n db: 'Northwind',\r\n args: { code: 'db.createUser( { user: \"myUser1\", pwd: \"password123\",roles: [ \"readWrite\", \"dbAdmin\" ] })' }\r\n}\r\n<\/pre>\n<p>&nbsp;<\/p>\n<h2>Remove MongoDB User<\/h2>\n<p>To remove the MongoDB user using the <a href=\"\/\/zappysys.com\/\/\/zappysys.com\/products\/ssis-powerpack\/ssis-mongodb-executesql-task\/\" target=\"_blank\" rel=\"noopener\">MongoDB ExecuteSQL Task<\/a>, use the following Script<\/p>\n<pre class=\"lang:js decode:true \">{\r\n scope: 'database',\r\n command: 'eval',\r\n db: 'Northwind',\r\n args: { code: 'db.removeUser(\"myUser1\")' }\r\n}<\/pre>\n<p>&nbsp;<\/p>\n<h2>List MongoDB Users from the Command Line<\/h2>\n<p>To list existing users for a specific database, perform the following steps.<\/p>\n<ol>\n<li>Open the command prompt and type <strong>mongo<\/strong><\/li>\n<li>If needed, type userid\/password (if not required, then do the next step)<\/li>\n<li>type <strong>use YourDBName<\/strong><\/li>\n<li>Type <strong>db.getUsers()<\/strong><\/li>\n<\/ol>\n<div id=\"attachment_605\" style=\"width: 502px\" class=\"wp-caption alignnone\"><a href=\"\/\/zappysys.com\/blog\/wp-content\/uploads\/2016\/06\/ssis-mongodb-list-database-users-command-line.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-605\" class=\"size-full wp-image-605\" src=\"\/\/zappysys.com\/blog\/wp-content\/uploads\/2016\/06\/ssis-mongodb-list-database-users-command-line.png\" alt=\"How to list MongoDB dabase users using db.getUsers() on mongo command line\" width=\"492\" height=\"479\" srcset=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2016\/06\/ssis-mongodb-list-database-users-command-line.png 492w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2016\/06\/ssis-mongodb-list-database-users-command-line-300x292.png 300w\" sizes=\"(max-width: 492px) 100vw, 492px\" \/><\/a><p id=\"caption-attachment-605\" class=\"wp-caption-text\">How to list MongoDB database users using db.getUsers() on the mongo command line<\/p><\/div>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Introduction In this blog post, you will learn how to call MongoDB Shell Commands from SSIS using the MongoDB ExecuteSQL task Some use cases for calling MongoDB shell commands are listed here. &nbsp; How to call MongoDB Shell Commands in SSIS Download and install SSIS PowerPack from here From the toolbox of the SSIS designer, [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":2115,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[112],"tags":[46,84,12],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v22.3 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\r\n<title>How to add \/ remove MongoDB User in SSIS | ZappySys Blog<\/title>\r\n<meta name=\"description\" content=\"In this blog post learn how to add \/ remove MongoDB User in SSIS using MongoDB ExecuteSQL Task. You can call any MongoDB Shell commands using this SSIS task\" \/>\r\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\r\n<link rel=\"canonical\" href=\"https:\/\/zappysys.com\/blog\/add-remove-mongodb-user-ssis\/\" \/>\r\n<meta property=\"og:locale\" content=\"en_US\" \/>\r\n<meta property=\"og:type\" content=\"article\" \/>\r\n<meta property=\"og:title\" content=\"How to add \/ remove MongoDB User in SSIS | ZappySys Blog\" \/>\r\n<meta property=\"og:description\" content=\"In this blog post learn how to add \/ remove MongoDB User in SSIS using MongoDB ExecuteSQL Task. You can call any MongoDB Shell commands using this SSIS task\" \/>\r\n<meta property=\"og:url\" content=\"https:\/\/zappysys.com\/blog\/add-remove-mongodb-user-ssis\/\" \/>\r\n<meta property=\"og:site_name\" content=\"ZappySys Blog\" \/>\r\n<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/ZappySys\/\" \/>\r\n<meta property=\"article:published_time\" content=\"2016-06-16T21:45:30+00:00\" \/>\r\n<meta property=\"article:modified_time\" content=\"2025-10-23T23:05:29+00:00\" \/>\r\n<meta property=\"og:image\" content=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2017\/08\/mongodb-logo.png\" \/>\r\n\t<meta property=\"og:image:width\" content=\"88\" \/>\r\n\t<meta property=\"og:image:height\" content=\"88\" \/>\r\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\r\n<meta name=\"author\" content=\"ZappySys\" \/>\r\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\r\n<meta name=\"twitter:creator\" content=\"@https:\/\/twitter.com\/zappysys\/\" \/>\r\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"ZappySys\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\r\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/zappysys.com\/blog\/add-remove-mongodb-user-ssis\/\",\"url\":\"https:\/\/zappysys.com\/blog\/add-remove-mongodb-user-ssis\/\",\"name\":\"How to add \/ remove MongoDB User in SSIS | ZappySys Blog\",\"isPartOf\":{\"@id\":\"https:\/\/zappysys.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/zappysys.com\/blog\/add-remove-mongodb-user-ssis\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/zappysys.com\/blog\/add-remove-mongodb-user-ssis\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2017\/08\/mongodb-logo.png\",\"datePublished\":\"2016-06-16T21:45:30+00:00\",\"dateModified\":\"2025-10-23T23:05:29+00:00\",\"author\":{\"@id\":\"https:\/\/zappysys.com\/blog\/#\/schema\/person\/2756c237457fbc95d82cb38962f81f82\"},\"description\":\"In this blog post learn how to add \/ remove MongoDB User in SSIS using MongoDB ExecuteSQL Task. You can call any MongoDB Shell commands using this SSIS task\",\"breadcrumb\":{\"@id\":\"https:\/\/zappysys.com\/blog\/add-remove-mongodb-user-ssis\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/zappysys.com\/blog\/add-remove-mongodb-user-ssis\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/zappysys.com\/blog\/add-remove-mongodb-user-ssis\/#primaryimage\",\"url\":\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2017\/08\/mongodb-logo.png\",\"contentUrl\":\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2017\/08\/mongodb-logo.png\",\"width\":88,\"height\":88},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/zappysys.com\/blog\/add-remove-mongodb-user-ssis\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/zappysys.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to add \/ remove MongoDB User in SSIS\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/zappysys.com\/blog\/#website\",\"url\":\"https:\/\/zappysys.com\/blog\/\",\"name\":\"ZappySys Blog\",\"description\":\"SSIS \/ ODBC Drivers \/ API Connectors for JSON, XML, Azure, Amazon AWS, Salesforce, MongoDB and more\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/zappysys.com\/blog\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/zappysys.com\/blog\/#\/schema\/person\/2756c237457fbc95d82cb38962f81f82\",\"name\":\"ZappySys\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/zappysys.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/5c9be148088ba9b8af8e955c5f7c22b5?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/5c9be148088ba9b8af8e955c5f7c22b5?s=96&d=mm&r=g\",\"caption\":\"ZappySys\"},\"sameAs\":[\"http:\/\/www.zappysys.com\/\",\"https:\/\/www.facebook.com\/ZappySys\/\",\"https:\/\/twitter.com\/https:\/\/twitter.com\/zappysys\/\"],\"url\":\"https:\/\/zappysys.com\/blog\/author\/admin\/\"}]}<\/script>\r\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to add \/ remove MongoDB User in SSIS | ZappySys Blog","description":"In this blog post learn how to add \/ remove MongoDB User in SSIS using MongoDB ExecuteSQL Task. You can call any MongoDB Shell commands using this SSIS task","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/zappysys.com\/blog\/add-remove-mongodb-user-ssis\/","og_locale":"en_US","og_type":"article","og_title":"How to add \/ remove MongoDB User in SSIS | ZappySys Blog","og_description":"In this blog post learn how to add \/ remove MongoDB User in SSIS using MongoDB ExecuteSQL Task. You can call any MongoDB Shell commands using this SSIS task","og_url":"https:\/\/zappysys.com\/blog\/add-remove-mongodb-user-ssis\/","og_site_name":"ZappySys Blog","article_author":"https:\/\/www.facebook.com\/ZappySys\/","article_published_time":"2016-06-16T21:45:30+00:00","article_modified_time":"2025-10-23T23:05:29+00:00","og_image":[{"width":88,"height":88,"url":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2017\/08\/mongodb-logo.png","type":"image\/png"}],"author":"ZappySys","twitter_card":"summary_large_image","twitter_creator":"@https:\/\/twitter.com\/zappysys\/","twitter_misc":{"Written by":"ZappySys","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/zappysys.com\/blog\/add-remove-mongodb-user-ssis\/","url":"https:\/\/zappysys.com\/blog\/add-remove-mongodb-user-ssis\/","name":"How to add \/ remove MongoDB User in SSIS | ZappySys Blog","isPartOf":{"@id":"https:\/\/zappysys.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/zappysys.com\/blog\/add-remove-mongodb-user-ssis\/#primaryimage"},"image":{"@id":"https:\/\/zappysys.com\/blog\/add-remove-mongodb-user-ssis\/#primaryimage"},"thumbnailUrl":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2017\/08\/mongodb-logo.png","datePublished":"2016-06-16T21:45:30+00:00","dateModified":"2025-10-23T23:05:29+00:00","author":{"@id":"https:\/\/zappysys.com\/blog\/#\/schema\/person\/2756c237457fbc95d82cb38962f81f82"},"description":"In this blog post learn how to add \/ remove MongoDB User in SSIS using MongoDB ExecuteSQL Task. You can call any MongoDB Shell commands using this SSIS task","breadcrumb":{"@id":"https:\/\/zappysys.com\/blog\/add-remove-mongodb-user-ssis\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/zappysys.com\/blog\/add-remove-mongodb-user-ssis\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/zappysys.com\/blog\/add-remove-mongodb-user-ssis\/#primaryimage","url":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2017\/08\/mongodb-logo.png","contentUrl":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2017\/08\/mongodb-logo.png","width":88,"height":88},{"@type":"BreadcrumbList","@id":"https:\/\/zappysys.com\/blog\/add-remove-mongodb-user-ssis\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/zappysys.com\/blog\/"},{"@type":"ListItem","position":2,"name":"How to add \/ remove MongoDB User in SSIS"}]},{"@type":"WebSite","@id":"https:\/\/zappysys.com\/blog\/#website","url":"https:\/\/zappysys.com\/blog\/","name":"ZappySys Blog","description":"SSIS \/ ODBC Drivers \/ API Connectors for JSON, XML, Azure, Amazon AWS, Salesforce, MongoDB and more","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/zappysys.com\/blog\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/zappysys.com\/blog\/#\/schema\/person\/2756c237457fbc95d82cb38962f81f82","name":"ZappySys","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/zappysys.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/5c9be148088ba9b8af8e955c5f7c22b5?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/5c9be148088ba9b8af8e955c5f7c22b5?s=96&d=mm&r=g","caption":"ZappySys"},"sameAs":["http:\/\/www.zappysys.com\/","https:\/\/www.facebook.com\/ZappySys\/","https:\/\/twitter.com\/https:\/\/twitter.com\/zappysys\/"],"url":"https:\/\/zappysys.com\/blog\/author\/admin\/"}]}},"_links":{"self":[{"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/posts\/604"}],"collection":[{"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/comments?post=604"}],"version-history":[{"count":7,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/posts\/604\/revisions"}],"predecessor-version":[{"id":11591,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/posts\/604\/revisions\/11591"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/media\/2115"}],"wp:attachment":[{"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/media?parent=604"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/categories?post=604"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/tags?post=604"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}