{"id":11932,"date":"2026-04-04T14:27:12","date_gmt":"2026-04-04T14:27:12","guid":{"rendered":"https:\/\/zappysys.com\/blog\/?p=11932"},"modified":"2026-04-04T14:27:12","modified_gmt":"2026-04-04T14:27:12","slug":"ssis-tutorial-how-to-extract-data-from-docuware-using-rest-api","status":"publish","type":"post","link":"https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-extract-data-from-docuware-using-rest-api\/","title":{"rendered":"SSIS tutorial: How to extract data from DocuWare using REST API"},"content":{"rendered":"

<\/p>\n

Introduction<\/h2>\n

\"Zappysys\"<\/p>\n

DocuWare is a powerful document management platform that provides REST APIs for accessing documents, metadata, and workflows. This guide demonstrates how to connect Zappysys SSIS connectors to DocuWare using OAuth 2.0 or Bearer Token authentication.<\/p>\n

Whether you are using DocuWare Cloud or an on-premises deployment, you will learn how to configure secure authentication without writing any custom code. Zappysys handles all the technical complexity, allowing you to focus on building your ETL workflows.<\/p>\n

<\/p>\n

Prerequisites<\/h2>\n
    \n
  1. SQL Server Integration Services (SSIS) must be installed.<\/li>\n
  2. Visual Studio with SSIS extension or SQL Server Data Tools (SSDT) is required.<\/li>\n
  3. Active DocuWare account with appropriate permissions.<\/li>\n
  4. ZappySys SSIS PowerPack<\/a> installed.<\/li>\n<\/ol>\n

    <\/p>\n

    Steps<\/h2>\n

    Get the Endpoint Examples<\/h3>\n

    Download the DocuWare API Postman collection<\/a> to review available endpoints. This helps you understand the API structure before configuring your connection. For additional guidance, see our article on migrating Postman to SSIS<\/a>.<\/p>\n

    OAuth 2.0 Connection (DocuWare Cloud)<\/h3>\n
      \n
    1. Create or select your SSIS project and open the package.dtsx file.<\/li>\n
    2. Drag and drop the ZS REST API task from the Toolbox.<\/li>\n
    3. Right-click in the Connection Managers<\/strong> pane and select New Connection…<\/strong><\/li>\n
    4. Select ZS-OAuth<\/strong> from the SSIS connectors list.\n
    5. Set the OAuth Version<\/strong> to OAuth 2.0<\/strong>.<\/li>\n
    6. Set Grant Type<\/strong> to Password Grant<\/strong>.<\/li>\n
    7. Enter Client ID:<\/strong> docuware.public.client<\/code><\/li>\n
    8. Enter your DocuWare credentials (username and password).<\/li>\n
    9. Enter the Token URL:<\/strong>\n
      https:\/\/your-docuware-server\/DocuWare\/Platform\/Account\/Logon<\/pre>\n<\/li>\n
    10. Enter the Scope:<\/strong> docuware.platforms<\/code><\/li>\n
    11. Click OK<\/strong> to save the connection.\n
      \"\"<\/a>
      Docuware – OAuth connection<\/p><\/div><\/li>\n<\/ol>\n
      NTLM Authentication (For On-Premises or Windows-based Environments)<\/h3>\n
        \n
      1. If using NTLM authentication instead of OAuth, select ZS-HTTP<\/strong> from the SSIS connectors list.<\/li>\n
      2. Set Credential Type<\/strong> to NTLM Authentication<\/strong>.<\/li>\n
      3. Enter the Base URL:<\/strong>\n
        https:\/\/your-docuware-server\/DocuWare\/Platform<\/pre>\n<\/li>\n
      4. Enter your Windows credentials (domain\\username and password).<\/li>\n
      5. Click OK<\/strong> to save the connection.\n
        \"\"<\/a>
        Docuware – NTLM Authentication connection<\/p><\/div><\/li>\n<\/ol>\n
        Configure the REST API Task<\/h3>\n
          \n
        1. Drag and drop the REST API task<\/a><\/strong> into the Control Flow, then double-click it to open the editor.<\/li>\n
        2. Select the connection you created (OAuth or NTLM).<\/li>\n
        3. Enter the DocuWare API endpoint URL (for example: \/FileCabinets<\/code> to retrieve all file cabinets and document trays)<\/li>\n
        4. Select the appropriate HTTP method\u2014typically GET<\/strong> for retrieving data.<\/li>\n
        5. Click Test Connection<\/strong> to verify the configuration works correctly.\n
          \"\"<\/a>
          Docuware – REST API example<\/p><\/div><\/li>\n<\/ol>\n
          <\/p>\n
          Conclusion<\/h2>\n
          You now have a secure and reliable connection between Zappysys SSIS and DocuWare. Use OAuth 2.0 for DocuWare Cloud deployments and NTLM authentication for on-premises environments.<\/p>\n
          With your connection configured, you can build powerful ETL workflows using the REST connector in SSIS to extract document data, apply transformations, and load results into SQL Server\u2014all without writing any custom code.<\/p>\n
          Next steps:<\/strong> Create a Data Flow Task and use the Zappysys REST Source component to query DocuWare API endpoints and load the extracted document data into your SQL Server database.<\/p>\n
          <\/p>\n
          Need Help?<\/h2>\n
          If you have questions or encounter any issues:<\/p>\n
            \n
          1. Live Chat Support<\/strong> \u2014 Use the chat widget on this page for immediate assistance<\/li>\n
          2. Email Support<\/strong> \u2014 support@zappysys.com<\/li>\n
          3. DocuWare Support Portal<\/strong> \u2014 Visit https:\/\/www.docuware.com\/en\/support<\/a><\/li>\n<\/ol>\n","protected":false},"excerpt":{"rendered":"
            Introduction DocuWare is a powerful document management platform that provides REST APIs for accessing documents, metadata, and workflows. This guide demonstrates how to connect Zappysys SSIS connectors to DocuWare using OAuth 2.0 or Bearer Token authentication. Whether you are using DocuWare Cloud or an on-premises deployment, you will learn how to configure secure authentication without […]<\/p>\n","protected":false},"author":5,"featured_media":11934,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"yoast_head":"\r\nSSIS tutorial: How to extract data from DocuWare using REST API | ZappySys Blog<\/title>\r\n<meta name=\"description\" content=\"SSIS tutorial: How to extract data from DocuWare using REST API - ZappySys Blog\" \/>\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\/ssis-tutorial-how-to-extract-data-from-docuware-using-rest-api\/\" \/>\r\n<meta property=\"og:locale\" content=\"en_US\" \/>\r\n<meta property=\"og:type\" content=\"article\" \/>\r\n<meta property=\"og:title\" content=\"SSIS tutorial: How to extract data from DocuWare using REST API | ZappySys Blog\" \/>\r\n<meta property=\"og:description\" content=\"SSIS tutorial: How to extract data from DocuWare using REST API - ZappySys Blog\" \/>\r\n<meta property=\"og:url\" content=\"https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-extract-data-from-docuware-using-rest-api\/\" \/>\r\n<meta property=\"og:site_name\" content=\"ZappySys Blog\" \/>\r\n<meta property=\"article:published_time\" content=\"2026-04-04T14:27:12+00:00\" \/>\r\n<meta property=\"og:image\" content=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/04\/Logo-Docuware.png\" \/>\r\n\t<meta property=\"og:image:width\" content=\"512\" \/>\r\n\t<meta property=\"og:image:height\" content=\"512\" \/>\r\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\r\n<meta name=\"author\" content=\"ZappySys Team\" \/>\r\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\r\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"ZappySys Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\r\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-extract-data-from-docuware-using-rest-api\/\",\"url\":\"https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-extract-data-from-docuware-using-rest-api\/\",\"name\":\"SSIS tutorial: How to extract data from DocuWare using REST API | ZappySys Blog\",\"isPartOf\":{\"@id\":\"https:\/\/zappysys.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-extract-data-from-docuware-using-rest-api\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-extract-data-from-docuware-using-rest-api\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/04\/Logo-Docuware.png\",\"datePublished\":\"2026-04-04T14:27:12+00:00\",\"dateModified\":\"2026-04-04T14:27:12+00:00\",\"author\":{\"@id\":\"https:\/\/zappysys.com\/blog\/#\/schema\/person\/91b041e2dcf7ece5f068893c1a68ac6e\"},\"description\":\"SSIS tutorial: How to extract data from DocuWare using REST API - ZappySys Blog\",\"breadcrumb\":{\"@id\":\"https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-extract-data-from-docuware-using-rest-api\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-extract-data-from-docuware-using-rest-api\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-extract-data-from-docuware-using-rest-api\/#primaryimage\",\"url\":\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/04\/Logo-Docuware.png\",\"contentUrl\":\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/04\/Logo-Docuware.png\",\"width\":512,\"height\":512},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-extract-data-from-docuware-using-rest-api\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/zappysys.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SSIS tutorial: How to extract data from DocuWare using REST API\"}]},{\"@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\/91b041e2dcf7ece5f068893c1a68ac6e\",\"name\":\"ZappySys Team\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/zappysys.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/746bec9c9d27f1b90bb181aa516ee234?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/746bec9c9d27f1b90bb181aa516ee234?s=96&d=mm&r=g\",\"caption\":\"ZappySys Team\"},\"sameAs\":[\"https:\/\/zappysys.com\"],\"url\":\"https:\/\/zappysys.com\/blog\/author\/dcalbimonte\/\"}]}<\/script>\r\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"SSIS tutorial: How to extract data from DocuWare using REST API | ZappySys Blog","description":"SSIS tutorial: How to extract data from DocuWare using REST API - ZappySys Blog","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\/ssis-tutorial-how-to-extract-data-from-docuware-using-rest-api\/","og_locale":"en_US","og_type":"article","og_title":"SSIS tutorial: How to extract data from DocuWare using REST API | ZappySys Blog","og_description":"SSIS tutorial: How to extract data from DocuWare using REST API - ZappySys Blog","og_url":"https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-extract-data-from-docuware-using-rest-api\/","og_site_name":"ZappySys Blog","article_published_time":"2026-04-04T14:27:12+00:00","og_image":[{"width":512,"height":512,"url":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/04\/Logo-Docuware.png","type":"image\/png"}],"author":"ZappySys Team","twitter_card":"summary_large_image","twitter_misc":{"Written by":"ZappySys Team","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-extract-data-from-docuware-using-rest-api\/","url":"https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-extract-data-from-docuware-using-rest-api\/","name":"SSIS tutorial: How to extract data from DocuWare using REST API | ZappySys Blog","isPartOf":{"@id":"https:\/\/zappysys.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-extract-data-from-docuware-using-rest-api\/#primaryimage"},"image":{"@id":"https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-extract-data-from-docuware-using-rest-api\/#primaryimage"},"thumbnailUrl":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/04\/Logo-Docuware.png","datePublished":"2026-04-04T14:27:12+00:00","dateModified":"2026-04-04T14:27:12+00:00","author":{"@id":"https:\/\/zappysys.com\/blog\/#\/schema\/person\/91b041e2dcf7ece5f068893c1a68ac6e"},"description":"SSIS tutorial: How to extract data from DocuWare using REST API - ZappySys Blog","breadcrumb":{"@id":"https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-extract-data-from-docuware-using-rest-api\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-extract-data-from-docuware-using-rest-api\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-extract-data-from-docuware-using-rest-api\/#primaryimage","url":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/04\/Logo-Docuware.png","contentUrl":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/04\/Logo-Docuware.png","width":512,"height":512},{"@type":"BreadcrumbList","@id":"https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-extract-data-from-docuware-using-rest-api\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/zappysys.com\/blog\/"},{"@type":"ListItem","position":2,"name":"SSIS tutorial: How to extract data from DocuWare using REST API"}]},{"@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\/91b041e2dcf7ece5f068893c1a68ac6e","name":"ZappySys Team","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/zappysys.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/746bec9c9d27f1b90bb181aa516ee234?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/746bec9c9d27f1b90bb181aa516ee234?s=96&d=mm&r=g","caption":"ZappySys Team"},"sameAs":["https:\/\/zappysys.com"],"url":"https:\/\/zappysys.com\/blog\/author\/dcalbimonte\/"}]}},"_links":{"self":[{"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/posts\/11932"}],"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\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/comments?post=11932"}],"version-history":[{"count":7,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/posts\/11932\/revisions"}],"predecessor-version":[{"id":11953,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/posts\/11932\/revisions\/11953"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/media\/11934"}],"wp:attachment":[{"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/media?parent=11932"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/categories?post=11932"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/tags?post=11932"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}