{"id":11961,"date":"2026-04-09T23:52:56","date_gmt":"2026-04-09T23:52:56","guid":{"rendered":"https:\/\/zappysys.com\/blog\/?p=11961"},"modified":"2026-04-10T00:23:01","modified_gmt":"2026-04-10T00:23:01","slug":"ssis-tutorial-how-to-connect-jamf-with-ssis","status":"publish","type":"post","link":"https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-connect-jamf-with-ssis\/","title":{"rendered":"SSIS tutorial: How to connect Jamf with SSIS"},"content":{"rendered":"<p><!-- Introduction --><\/p>\n<h2>Introduction<\/h2>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-zappysys alignleft\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/04\/jamf_software_logo.jpg\" alt=\"Jamf Pro\" width=\"88\" height=\"88\" \/><\/p>\n<p class=\"intro-text\">Jamf Pro is a comprehensive Apple device management platform that provides REST APIs for managing Macs, iPads, and iPhones across your organization. This guide demonstrates how to connect Zappysys SSIS connectors to Jamf Pro using OAuth 2.0 API authentication.<\/p>\n<p class=\"intro-text\">Whether you are using Jamf Cloud or an on-premises Jamf Pro server, you will learn how to configure secure OAuth 2.0 authentication without writing any custom code. Zappysys handles all the technical complexity, allowing you to focus on building your ETL workflows for managing device inventory, policy configurations, and compliance reporting.<\/p>\n<p><!-- Prerequisites --><\/p>\n<h2>Prerequisites<\/h2>\n<ol>\n<li>SQL Server Integration Services (SSIS) must be installed.<\/li>\n<li>Visual Studio with SSIS extension or SQL Server Data Tools (SSDT) is required.<\/li>\n<li>Active Jamf Pro account with administrator privileges for API client configuration.<\/li>\n<li>Finally, do not forget to install\u00a0ZappySys\u00a0<a href=\"https:\/\/zappysys.com\/products\/ssis-powerpack\/\" target=\"_blank\" rel=\"noopener\">SSIS PowerPack.<\/a><\/li>\n<\/ol>\n<p><!-- Steps --><\/p>\n<h2>Steps<\/h2>\n<h3>Generate Jamf credentials<\/h3>\n<ol>\n<li>Log in to your Jamf Pro instance as an administrator.<\/li>\n<li>Navigate to <strong>Settings<\/strong> &gt; <strong>System Settings<\/strong> &gt; <strong>API Roles and Clients<\/strong>.\n<div id=\"attachment_11963\" style=\"width: 864px\" class=\"wp-caption alignnone\"><a href=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/04\/Jamf-API-roles-and-clients.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-11963\" class=\"size-full wp-image-11963\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/04\/Jamf-API-roles-and-clients.png\" alt=\"\" width=\"854\" height=\"495\" srcset=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/04\/Jamf-API-roles-and-clients.png 854w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/04\/Jamf-API-roles-and-clients-300x174.png 300w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/04\/Jamf-API-roles-and-clients-768x445.png 768w\" sizes=\"(max-width: 854px) 100vw, 854px\" \/><\/a><p id=\"caption-attachment-11963\" class=\"wp-caption-text\">Jamf &#8211; API roles and clients<\/p><\/div><\/li>\n<li>First, create a new API Role with the required permissions:\n<ul>\n<li>Click <strong>API Roles<\/strong>, then click <strong>+ New<\/strong>.<\/li>\n<li>Enter a descriptive name (e.g., <strong>Admin<\/strong>).<\/li>\n<li>Assign permissions based on your use case:\n<ul>\n<li>Check <strong>Read<\/strong> for data extraction (computers, devices, users)<\/li>\n<li>Check <strong>Create<\/strong>, <strong>Update<\/strong>, or <strong>Delete<\/strong> only if you need to write data back to Jamf Pro<\/li>\n<\/ul>\n<\/li>\n<li>Click <strong>Save<\/strong>.\n<div id=\"attachment_11964\" style=\"width: 636px\" class=\"wp-caption alignnone\"><a href=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/04\/Jamf-new-API-role.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-11964\" class=\"size-full wp-image-11964\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/04\/Jamf-new-API-role.png\" alt=\"\" width=\"626\" height=\"487\" srcset=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/04\/Jamf-new-API-role.png 626w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/04\/Jamf-new-API-role-300x233.png 300w\" sizes=\"(max-width: 626px) 100vw, 626px\" \/><\/a><p id=\"caption-attachment-11964\" class=\"wp-caption-text\">Jamf &#8211; new API role<\/p><\/div><\/li>\n<\/ul>\n<\/li>\n<li>Now, create an API Client:\n<ul>\n<li>Go back to <strong>API Roles and Clients<\/strong> and select the <strong>API Clients<\/strong> tab.<\/li>\n<li>Click <strong>+ New<\/strong> in the upper right corner.<\/li>\n<li>Enter a <strong>Display Name<\/strong> (e.g., <strong>SSIS Connector<\/strong>).<\/li>\n<li>Select the API Role created in the previous step.<\/li>\n<li>Toggle <strong>Enable API client<\/strong> to ON, then click <strong>Save<\/strong>.<\/li>\n<\/ul>\n<\/li>\n<li>Generate client credentials:\n<ul>\n<li>Select <strong>Generate client secret<\/strong> and click <strong>Create secret<\/strong> in the pop-up dialog.<\/li>\n<li>Copy and securely save the <strong>Client ID<\/strong> and <strong>Client Secret<\/strong> for use in the next steps.\n<div id=\"attachment_11967\" style=\"width: 730px\" class=\"wp-caption alignnone\"><a href=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/04\/Jamf-Generate-Client-id-and-Client-Secret.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-11967\" class=\"wp-image-11967 size-large\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/04\/Jamf-Generate-Client-id-and-Client-Secret-1024x710.png\" alt=\"\" width=\"720\" height=\"499\" srcset=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/04\/Jamf-Generate-Client-id-and-Client-Secret-1024x710.png 1024w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/04\/Jamf-Generate-Client-id-and-Client-Secret-300x208.png 300w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/04\/Jamf-Generate-Client-id-and-Client-Secret-768x532.png 768w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/04\/Jamf-Generate-Client-id-and-Client-Secret-1536x1065.png 1536w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/04\/Jamf-Generate-Client-id-and-Client-Secret.png 1740w\" sizes=\"(max-width: 720px) 100vw, 720px\" \/><\/a><p id=\"caption-attachment-11967\" class=\"wp-caption-text\">Jamf &#8211; Generate Client ID and Client Secret<\/p><\/div><\/li>\n<\/ul>\n<\/li>\n<li>Record your Jamf Pro instance URL (e.g., <code>https:\/\/your-company.jamfcloud.com<\/code>).<\/li>\n<\/ol>\n<h3>Create the OAuth connection<\/h3>\n<ol>\n<li>Create or select your SSIS project and open the package.<\/li>\n<li>Right-click in the <strong>Connection Managers<\/strong> pane and select <strong>New Connection&#8230;<\/strong><\/li>\n<li>Select <strong>ZS-OAUTH<\/strong> from the SSIS connectors list.\n<div id=\"attachment_11825\" style=\"width: 959px\" class=\"wp-caption alignnone\"><a href=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2020\/02\/Create-a-new-SSIS-OAuth-API-Connection-Manager.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-11825\" class=\"size-full wp-image-11825\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2020\/02\/Create-a-new-SSIS-OAuth-API-Connection-Manager.png\" alt=\"\" width=\"949\" height=\"447\" srcset=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2020\/02\/Create-a-new-SSIS-OAuth-API-Connection-Manager.png 949w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2020\/02\/Create-a-new-SSIS-OAuth-API-Connection-Manager-300x141.png 300w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2020\/02\/Create-a-new-SSIS-OAuth-API-Connection-Manager-768x362.png 768w\" sizes=\"(max-width: 949px) 100vw, 949px\" \/><\/a><p id=\"caption-attachment-11825\" class=\"wp-caption-text\">Create a new SSIS OAuth API Connection Manager<\/p><\/div><\/li>\n<li>Set the <strong>OAuth Version<\/strong> to <strong>OAuth 2.0<\/strong>.<\/li>\n<li>Set the <strong>Grant Type<\/strong> to <strong>Client Credentials Grant<\/strong>.<\/li>\n<li>Enter the <strong>Client ID <\/strong>and the <strong>Client Secret <\/strong>from the API Client created above<\/li>\n<li>Enter the <strong>Token URL:<\/strong>\n<pre class=\"lang:default decode:true \">https:\/\/your-company.jamfcloud.com\/api\/oauth\/token<\/pre>\n<\/li>\n<li>Click <strong>OK<\/strong> to save the connection.\n<div id=\"attachment_11968\" style=\"width: 713px\" class=\"wp-caption alignnone\"><a href=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/04\/Jamf-OAuth-connection.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-11968\" class=\"size-full wp-image-11968\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/04\/Jamf-OAuth-connection.png\" alt=\"\" width=\"703\" height=\"665\" srcset=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/04\/Jamf-OAuth-connection.png 703w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/04\/Jamf-OAuth-connection-300x284.png 300w\" sizes=\"(max-width: 703px) 100vw, 703px\" \/><\/a><p id=\"caption-attachment-11968\" class=\"wp-caption-text\">Jamf &#8211; OAuth connection<\/p><\/div><\/li>\n<\/ol>\n<h3>Create and Configure the JSON source<\/h3>\n<ol>\n<li>In your SSIS package, drag and drop a <strong>Data Flow Task<\/strong> from the Toolbox into the Control Flow.\n<div id=\"attachment_11784\" style=\"width: 485px\" class=\"wp-caption alignnone\"><a href=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/02\/Drag-and-drop-Data-flow.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-11784\" class=\"size-full wp-image-11784\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/02\/Drag-and-drop-Data-flow.png\" alt=\"\" width=\"475\" height=\"178\" srcset=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/02\/Drag-and-drop-Data-flow.png 475w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/02\/Drag-and-drop-Data-flow-300x112.png 300w\" sizes=\"(max-width: 475px) 100vw, 475px\" \/><\/a><p id=\"caption-attachment-11784\" class=\"wp-caption-text\">Drag and drop Data flow<\/p><\/div><\/li>\n<li>Double-click the Data Flow Task to enter the Data Flow tab.<\/li>\n<li>In the Data Flow, drag and drop a <a href=\"https:\/\/zappysys.com\/products\/ssis-powerpack\/ssis-json-file-source\/\"><strong>ZS JSON Source<\/strong><\/a> component from the Toolbox.<\/li>\n<li>Double-click the <a href=\"https:\/\/zappysys.com\/products\/ssis-powerpack\/ssis-json-file-source\/\"><strong>JSON Source<\/strong><\/a> to open its editor.<\/li>\n<li>Select your Jamf OAuth connection from the <strong>Connection Manager<\/strong> dropdown.<\/li>\n<li>Enter the Jamf Pro API endpoint path in the <strong>URL<\/strong> field. For example:\n<ul>\n<li><code>https:\/\/your-company.jamfcloud.com\/JSSResource\/accounts<\/code> \u2014 To retrieve account data<\/li>\n<li><code>https:\/\/your-company.jamfcloud.com\/JSSResource\/computers<\/code> \u2014 To retrieve computer inventory<\/li>\n<li><code>https:\/\/your-company.jamfcloud.com\/JSSResource\/mobiledevices<\/code> \u2014 To retrieve mobile device data<\/li>\n<li><code>https:\/\/your-company.jamfcloud.com\/JSSResource\/users<\/code> \u2014 To retrieve user information<\/li>\n<\/ul>\n<\/li>\n<li>Set the <strong>HTTP Method<\/strong> to <strong>GET<\/strong> for data retrieval.<\/li>\n<li>Configure the <strong>JSON Path Filter<\/strong> to extract the specific object you need from the response (e.g., <code>$.account<\/code>\u00a0or <code>$.computers<\/code>).<\/li>\n<li>Click <strong>Preview<\/strong> to see sample data from the Jamf Pro API.\n<div id=\"attachment_11969\" style=\"width: 836px\" class=\"wp-caption alignnone\"><a href=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/04\/Jamf-JSON-source-request.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-11969\" class=\"size-full wp-image-11969\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/04\/Jamf-JSON-source-request.png\" alt=\"\" width=\"826\" height=\"743\" srcset=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/04\/Jamf-JSON-source-request.png 826w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/04\/Jamf-JSON-source-request-300x270.png 300w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/04\/Jamf-JSON-source-request-768x691.png 768w\" sizes=\"(max-width: 826px) 100vw, 826px\" \/><\/a><p id=\"caption-attachment-11969\" class=\"wp-caption-text\">Jamf &#8211; JSON source request<\/p><\/div><\/li>\n<\/ol>\n<h3>Step 4: Configure the Destination<\/h3>\n<ol>\n<li>Drag and drop a destination component (e.g., <strong>Trash destination<\/strong>) into the <strong>Data Flow<\/strong>.<\/li>\n<li>Connect the output arrow from the JSON Source to the destination component.<\/li>\n<li>Double-click the destination component and configure it to point to your target table or file.<\/li>\n<li>Map the columns from the Jamf Pro API response to the appropriate destination columns<\/li>\n<li>Click <strong>OK<\/strong> to save the destination configuration.<\/li>\n<li>Execute the package and verify that the data extraction is working correctly.\n<div id=\"attachment_11970\" style=\"width: 284px\" class=\"wp-caption alignnone\"><a href=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/04\/Jamf-Final-Result.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-11970\" class=\"size-full wp-image-11970\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/04\/Jamf-Final-Result.png\" alt=\"\" width=\"274\" height=\"260\" \/><\/a><p id=\"caption-attachment-11970\" class=\"wp-caption-text\">Jamf &#8211; Final Result<\/p><\/div><\/li>\n<\/ol>\n<p><!-- Conclusion --><\/p>\n<h2>Conclusion<\/h2>\n<p class=\"intro-text\">You now have a secure, reliable connection between Zappysys SSIS and Jamf Pro via OAuth 2.0. This modern, secure approach eliminates the need to store plaintext credentials and simplifies credential rotation and management. With your OAuth connection configured and JSON source component in place, you can build powerful ETL workflows to extract device inventory, policy data, user information, and compliance metrics from Jamf Pro\u2014all flowing directly into your SQL Server database or data warehouse without writing a single line of custom code.<\/p>\n<p class=\"intro-text\">Explore the full capabilities of the <a href=\"https:\/\/zappysys.com\/products\/ssis-powerpack\/\">ZappySys SSIS PowerPack<\/a> to optimize your data integration tasks. By applying this pattern, you can extend your solution to include additional transformations, data validation, error handling, and scheduling through SQL Server Agent.<\/p>\n<p><!-- Need Help --><\/p>\n<h2>Need Help?<\/h2>\n<p class=\"section-intro\">If you encounter any issues, our support team is here to help:<\/p>\n<ol>\n<li><strong>Live Chat<\/strong> \u2014 Use the chat widget (bottom-right corner of this page)<\/li>\n<li><strong>Email<\/strong> \u2014 support@zappysys.com<\/li>\n<li><strong>Support Center<\/strong> \u2014 Visit the ZappySys Support Portal<\/li>\n<\/ol>\n","protected":false},"excerpt":{"rendered":"<p>Introduction Jamf Pro is a comprehensive Apple device management platform that provides REST APIs for managing Macs, iPads, and iPhones across your organization. This guide demonstrates how to connect Zappysys SSIS connectors to Jamf Pro using OAuth 2.0 API authentication. Whether you are using Jamf Cloud or an on-premises Jamf Pro server, you will learn [&hellip;]<\/p>\n","protected":false},"author":5,"featured_media":11971,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v22.3 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\r\n<title>SSIS tutorial: How to connect Jamf with SSIS | ZappySys Blog<\/title>\r\n<meta name=\"description\" content=\"SSIS tutorial: How to connect Jamf with SSIS - 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-connect-jamf-with-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=\"SSIS tutorial: How to connect Jamf with SSIS | ZappySys Blog\" \/>\r\n<meta property=\"og:description\" content=\"SSIS tutorial: How to connect Jamf with SSIS - ZappySys Blog\" \/>\r\n<meta property=\"og:url\" content=\"https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-connect-jamf-with-ssis\/\" \/>\r\n<meta property=\"og:site_name\" content=\"ZappySys Blog\" \/>\r\n<meta property=\"article:published_time\" content=\"2026-04-09T23:52:56+00:00\" \/>\r\n<meta property=\"article:modified_time\" content=\"2026-04-10T00:23:01+00:00\" \/>\r\n<meta property=\"og:image\" content=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/04\/jamf_software_logo.jpg\" \/>\r\n\t<meta property=\"og:image:width\" content=\"200\" \/>\r\n\t<meta property=\"og:image:height\" content=\"200\" \/>\r\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\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=\"6 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-connect-jamf-with-ssis\/\",\"url\":\"https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-connect-jamf-with-ssis\/\",\"name\":\"SSIS tutorial: How to connect Jamf with SSIS | ZappySys Blog\",\"isPartOf\":{\"@id\":\"https:\/\/zappysys.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-connect-jamf-with-ssis\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-connect-jamf-with-ssis\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/04\/jamf_software_logo.jpg\",\"datePublished\":\"2026-04-09T23:52:56+00:00\",\"dateModified\":\"2026-04-10T00:23:01+00:00\",\"author\":{\"@id\":\"https:\/\/zappysys.com\/blog\/#\/schema\/person\/91b041e2dcf7ece5f068893c1a68ac6e\"},\"description\":\"SSIS tutorial: How to connect Jamf with SSIS - ZappySys Blog\",\"breadcrumb\":{\"@id\":\"https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-connect-jamf-with-ssis\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-connect-jamf-with-ssis\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-connect-jamf-with-ssis\/#primaryimage\",\"url\":\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/04\/jamf_software_logo.jpg\",\"contentUrl\":\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/04\/jamf_software_logo.jpg\",\"width\":200,\"height\":200},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-connect-jamf-with-ssis\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/zappysys.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SSIS tutorial: How to connect Jamf with 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\/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 connect Jamf with SSIS | ZappySys Blog","description":"SSIS tutorial: How to connect Jamf with SSIS - 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-connect-jamf-with-ssis\/","og_locale":"en_US","og_type":"article","og_title":"SSIS tutorial: How to connect Jamf with SSIS | ZappySys Blog","og_description":"SSIS tutorial: How to connect Jamf with SSIS - ZappySys Blog","og_url":"https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-connect-jamf-with-ssis\/","og_site_name":"ZappySys Blog","article_published_time":"2026-04-09T23:52:56+00:00","article_modified_time":"2026-04-10T00:23:01+00:00","og_image":[{"width":200,"height":200,"url":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/04\/jamf_software_logo.jpg","type":"image\/jpeg"}],"author":"ZappySys Team","twitter_card":"summary_large_image","twitter_misc":{"Written by":"ZappySys Team","Est. reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-connect-jamf-with-ssis\/","url":"https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-connect-jamf-with-ssis\/","name":"SSIS tutorial: How to connect Jamf with SSIS | ZappySys Blog","isPartOf":{"@id":"https:\/\/zappysys.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-connect-jamf-with-ssis\/#primaryimage"},"image":{"@id":"https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-connect-jamf-with-ssis\/#primaryimage"},"thumbnailUrl":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/04\/jamf_software_logo.jpg","datePublished":"2026-04-09T23:52:56+00:00","dateModified":"2026-04-10T00:23:01+00:00","author":{"@id":"https:\/\/zappysys.com\/blog\/#\/schema\/person\/91b041e2dcf7ece5f068893c1a68ac6e"},"description":"SSIS tutorial: How to connect Jamf with SSIS - ZappySys Blog","breadcrumb":{"@id":"https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-connect-jamf-with-ssis\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-connect-jamf-with-ssis\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-connect-jamf-with-ssis\/#primaryimage","url":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/04\/jamf_software_logo.jpg","contentUrl":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/04\/jamf_software_logo.jpg","width":200,"height":200},{"@type":"BreadcrumbList","@id":"https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-connect-jamf-with-ssis\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/zappysys.com\/blog\/"},{"@type":"ListItem","position":2,"name":"SSIS tutorial: How to connect Jamf with 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\/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\/11961"}],"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=11961"}],"version-history":[{"count":7,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/posts\/11961\/revisions"}],"predecessor-version":[{"id":11983,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/posts\/11961\/revisions\/11983"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/media\/11971"}],"wp:attachment":[{"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/media?parent=11961"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/categories?post=11961"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/tags?post=11961"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}