SSIS tutorial: How to connect Jamf with SSIS

Updated on by ZappySys Team

Contents hide
1 Introduction
2 Prerequisites
3 Steps
3.1 Generate Jamf credentials
3.2 Create the OAuth connection
3.3 Create and Configure the JSON source
3.4 Step 4: Configure the Destination
4 Conclusion
5 Need Help?

Introduction

Jamf Pro

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 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.

Prerequisites

  1. SQL Server Integration Services (SSIS) must be installed.
  2. Visual Studio with SSIS extension or SQL Server Data Tools (SSDT) is required.
  3. Active Jamf Pro account with administrator privileges for API client configuration.
  4. Finally, do not forget to install ZappySys SSIS PowerPack.

Steps

Generate Jamf credentials

  1. Log in to your Jamf Pro instance as an administrator.
  2. Navigate to Settings > System Settings > API Roles and Clients.

    Jamf – API roles and clients

  3. First, create a new API Role with the required permissions:
    • Click API Roles, then click + New.
    • Enter a descriptive name (e.g., Admin).
    • Assign permissions based on your use case:
      • Check Read for data extraction (computers, devices, users)
      • Check Create, Update, or Delete only if you need to write data back to Jamf Pro
    • Click Save.

      Jamf – new API role

  4. Now, create an API Client:
    • Go back to API Roles and Clients and select the API Clients tab.
    • Click + New in the upper right corner.
    • Enter a Display Name (e.g., SSIS Connector).
    • Select the API Role created in the previous step.
    • Toggle Enable API client to ON, then click Save.
  5. Generate client credentials:
    • Select Generate client secret and click Create secret in the pop-up dialog.
    • Copy and securely save the Client ID and Client Secret for use in the next steps.

      Jamf – Generate Client ID and Client Secret

  6. Record your Jamf Pro instance URL (e.g., https://your-company.jamfcloud.com).

Create the OAuth connection

  1. Create or select your SSIS project and open the package.
  2. Right-click in the Connection Managers pane and select New Connection…
  3. Select ZS-OAUTH from the SSIS connectors list.

    Create a new SSIS OAuth API Connection Manager

  4. Set the OAuth Version to OAuth 2.0.
  5. Set the Grant Type to Client Credentials Grant.
  6. Enter the Client ID and the Client Secret from the API Client created above
  7. Enter the Token URL:
  8. Click OK to save the connection.

    Jamf – OAuth connection

Create and Configure the JSON source

  1. In your SSIS package, drag and drop a Data Flow Task from the Toolbox into the Control Flow.

    Drag and drop Data flow

  2. Double-click the Data Flow Task to enter the Data Flow tab.
  3. In the Data Flow, drag and drop a ZS JSON Source component from the Toolbox.
  4. Double-click the JSON Source to open its editor.
  5. Select your Jamf OAuth connection from the Connection Manager dropdown.
  6. Enter the Jamf Pro API endpoint path in the URL field. For example:
    • https://your-company.jamfcloud.com/JSSResource/accounts — To retrieve account data
    • https://your-company.jamfcloud.com/JSSResource/computers — To retrieve computer inventory
    • https://your-company.jamfcloud.com/JSSResource/mobiledevices — To retrieve mobile device data
    • https://your-company.jamfcloud.com/JSSResource/users — To retrieve user information
  7. Set the HTTP Method to GET for data retrieval.
  8. Configure the JSON Path Filter to extract the specific object you need from the response (e.g., $.account or $.computers).
  9. Click Preview to see sample data from the Jamf Pro API.

    Jamf – JSON source request

Step 4: Configure the Destination

  1. Drag and drop a destination component (e.g., Trash destination) into the Data Flow.
  2. Connect the output arrow from the JSON Source to the destination component.
  3. Double-click the destination component and configure it to point to your target table or file.
  4. Map the columns from the Jamf Pro API response to the appropriate destination columns
  5. Click OK to save the destination configuration.
  6. Execute the package and verify that the data extraction is working correctly.

    Jamf – Final Result

Conclusion

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—all flowing directly into your SQL Server database or data warehouse without writing a single line of custom code.

Explore the full capabilities of the ZappySys SSIS PowerPack 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.

Need Help?

If you encounter any issues, our support team is here to help:

  1. Live Chat — Use the chat widget (bottom-right corner of this page)
  2. Email — support@zappysys.com
  3. Support Center — Visit the ZappySys Support Portal
Posted in Uncategorized.