Azure Files Integration Demo

Design

There are three ways for Iguana sync files into Azure Storage:

• Azure Files Shares

• Azure SFTP

• Azure FileREST API

Azure Files Shares Integration Design

Key Components

• Azure File Shares: Remote File Storage

• File Share Mount: power-shell script accessible vis TCP SMB port (445)

• Iguana: read or write file to File Share Mount as regular network drive using File Channel components or Translator

How to:

1. Setup File Shares in Azure Storage account.

2. Execute Power-shell script from File Shares setting in Iguana Server Windows

   

   3. Configure Iguana Channel / translator to read or write files to this network drive

Azure SFTP Integration Design

Key Components

• SFTP Container: Remote SFTP server powered by Azure container

• Local User: provides SFTP remote access

• Iguana: read or write file to SFTP container using File Channels or Translator

How to

1. Create Local User in Azure SFTP

2. Provisioning SFTP container

3. Configure SFTP connections in Iguana File Channel or Translator

Sample Code

-- SFTP Example -- START ---
   local fileName = 'filterSFTPData.hl7'
   local sftpConfigs = configs.sftpConfigs
   local SftpConn = net.sftp.init{server=sftpConfigs.host, username=sftpConfigs.username, password=sftpConfigs.password}

   -- Push file to Remote SFTP
   local isSuccess = SftpConn:put{remote_path=fileName, data=Data, overwrite=true}
   trace(isSuccess)

   -- Read file from Remote SFTP
   local fileData = SftpConn:get{remote_path=fileName}
   trace(fileData)

Azure FileREST API Integration Design

Key Components

• SFTP Container: Remote SFTP server powered by Azure container

• Azure AD App: Azure AD App as part of SFTP container access control (IAM) provides API access for Iguana.

• Iguana: read or write file to SFTP container using Iguana net.http API in the Translator

How to

1. Provisioning SFTP container

2. Configure Access Control (IAM) in SFTP container (ex. Reader Role)

3. Build net.http API calls in Iguana translator

Sample Code

-- SFTP REST API Example -- START ---
   -- Use Azure AD APP API to access Azure Blob
   local appConfigs = configs.appConfigs
   --1) Get Access token
   local resp = net.http.post{
      url=appConfigs.url,
      headers={['Content-Type'] = "application/x-www-form-urlencoded"},
      parameters = {
         ['grant_type'] = 'client_credentials',
         ['client_id'] = appConfigs.clientID,
         ['client_secret'] = appConfigs.clientSecret,
         ['resource']= "https://storage.azure.com"
      },
      cache_time=60,
      live = true
   }
   local token = json.parse{data=resp}.access_token
   trace(token)

   --2) Read file
   local resp2 = net.http.get{
      url=configs.fileConfigs.baseUrl.."/"..fileName,
      headers={
         ['Authorization'] = "Bearer "..token,
         ['x-ms-version'] = configs.fileConfigs.storageVersion
      },
      cache_time=60,
      live = true
   }
   trace(resp2)
   -- SFTP REST API Example -- END ---

Demo

Reference

• https://www.youtube.com/watch?v=bmRZi9iGsK0

• https://www.youtube.com/watch?v=sJ5ZNzL1y10

• https://www.youtube.com/watch?v=PskWSEdc6v4

• https://azure.microsoft.com/en-us/products/storage/files/#overview

• https://learn.microsoft.com/en-us/azure/storage/blobs/secure-file-transfer-protocol-support

• https://learn.microsoft.com/en-us/rest/api/storageservices/get-file