{"id":12186,"date":"2026-06-04T21:27:03","date_gmt":"2026-06-04T21:27:03","guid":{"rendered":"https:\/\/zappysys.com\/blog\/?p=12186"},"modified":"2026-06-04T21:27:03","modified_gmt":"2026-06-04T21:27:03","slug":"ssis-tutorial-how-to-get-data-from-github","status":"publish","type":"post","link":"https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-get-data-from-github\/","title":{"rendered":"SSIS tutorial: How to get data from Github"},"content":{"rendered":"

<\/p>\n

Introduction<\/h2>\n

\"\"<\/a><\/p>\n

GitHub is one of the most widely used platforms for source control, DevOps collaboration, and software delivery. Teams often need GitHub data, such as repositories, issues, pull requests, and commits, in SQL Server for analytics, reporting, and governance.<\/p>\n

In this tutorial, you will learn how to connect GitHub REST APIs to SQL Server Integration Services (SSIS) by using ZappySys SSIS PowerPack. This approach helps you build automated ETL pipelines without writing custom API client code.<\/p>\n

 <\/p>\n

<\/p>\n

Prerequisites<\/h2>\n
    \n
  1. SQL Server Integration Services (SSIS) is installed.<\/li>\n
  2. Visual Studio with SSIS extension or SQL Server Data Tools (SSDT) is available.<\/li>\n
  3. A GitHub account with access to the repositories you want to extract.<\/li>\n
  4. ZappySys SSIS PowerPack<\/a> is installed on your machine.<\/li>\n<\/ol>\n

    <\/p>\n

    Steps<\/h2>\n

    Create a GitHub Personal Access Token<\/h3>\n
      \n
    1. Sign in to your GitHub account<\/a>.<\/li>\n
    2. Go to Settings<\/strong>, then find the Developer settings<\/strong> at the bottom of the page.\n
    3. Now go to Personal access tokens <\/strong>and create a new token (fine-grained or classic, depending on your security policy).<\/li>\n
    4. Select permissions required for your extraction scenario (for example, repository metadata, issues, or pull requests), owner, expiration date and more.<\/li>\n
    5. Generate the token and copy it to a secure location.\n
      <\/div>\n
      \"\"<\/a>

      Github – Generate a new token<\/p><\/div><\/li>\n<\/ol>\n

      Create an HTTP Connection in SSIS<\/h3>\n
        \n
      1. Create or open your SSIS project and package.<\/li>\n
      2. In Connection Managers<\/strong>, right-click and select New Connection…<\/strong>.<\/li>\n
      3. Select ZS-HTTP<\/strong> from the SSIS connectors list.\n
      4. Set Credentials Type<\/strong> to Static token\/API key<\/strong>.<\/li>\n
      5. Paste your GitHub token in the token value field.<\/li>\n
      6. Click OK<\/strong> to save the connection.\n
        <\/div>\n
        \"\"<\/a>

        Github- Connection configuration<\/p><\/div><\/li>\n<\/ol>\n

        Create and Configure JSON Source<\/h3>\n
          \n
        1. Drag a Data Flow Task<\/strong> into Control Flow<\/strong> and open it.<\/li>\n
        2. In Data Flow<\/strong>, drag and drop the ZS JSON Source<\/strong><\/a>.<\/li>\n
        3. Open the JSON Source editor and enable Use credentials<\/strong>.<\/li>\n
        4. Select the GitHub HTTP connection you created earlier.<\/li>\n
        5. Set the API URL. Example to extract repositories for the authenticated user:\n
          https:\/\/api.github.com\/user<\/pre>\n<\/li>\n
        6. Set HTTP Request Method<\/strong> to GET<\/strong>.<\/li>\n
        7. Set the following values in the HTTP headers:\n
            \n
          1. Accept: application\/vnd.github+json<\/li>\n
          2. X-GitHub-Api-Version: 2022-11-28<\/li>\n<\/ol>\n<\/li>\n
          3. Set JSON Path Filter<\/strong> if you need it.<\/li>\n
          4. Click Preview<\/strong> to confirm rows are returned, then click OK<\/strong>.\n
            \"\"<\/a>
            Github – JSON source configuration<\/p><\/div><\/li>\n<\/ol>\n
            Use Other GitHub Endpoints (Optional)<\/h3>\n
            You can reuse the same SSIS package pattern with different GitHub endpoints:<\/p>\n