BizTalk : BAM User management on views

Hi,

Recently, I came across a situation where I have to manage user permission in BAM Views. Eventhough I found so many help documents, references etc., most of them were difficult to understand or not working. After few desperate attends I found the view it works.

To do the actions in command prompt, open “cmd.exe” and go to “<Installpath>:\Program Files (x86)\Microsoft BizTalk Server 2013\Tracking” location.

Now, Let us say we have a View “BAM_VIEW_TEST” and the user account for which we wanted to give access is “arun”  on the AD domain “myCompany”. To add a access to the view for the mentioned users, below command can be used.

bm Add-Account -AccountName:myCompany\arun -View:BAM_VIEW_TEST

To remove a user from the accessing a view, below command can be used.

bm remove-Account -AccountName:myCompany\arun -View:BAM_VIEW_TEST

Note : 1. To get the list of all views you can use “bm get-views” command

2. For getting the users associated with a view, below command can be executed

                     bm get-accounts -View:<view name>

eg. bm get-accounts -View:BAM_VIEW_TEST

             3. For getting the complete list of users configured in BizTalk below query can be executed on the database “BAMPrimaryImport”

Select Name,SID,SUser_SName(SID) as UserAccount from sysusers
WHERE ISLogin = 1 AND issqluser = 0 AND isntuser = 1

BizTalk SAP Integration PART-1

/Hi Guys,

There are so many posts which explains the configuration in BizTalk and configuration in SAP to establish integration of BizTalk to SAP. For me, most of them were confusing, may be because of my knowledge level in SAP and BizTalk .Here, in my first post, I am putting the steps I followed for establishing the connectivity between SAP and BizTalk. In this part, let us discuss about how we can configure SAP and BizTalk and check the connectivity test. This is focuzed on SAP outbound – BizTalk inbound scenario. In the following parts, I will share you the steps which I followed for BizTalk outbound – SAP inbound. (This is my first post, I hope the readers shall ignore my basic mistakes 🙂 )

SAP OUTBOUND IDOC CONFIGURATION FOR BIZTALK

  1. Login To Development client(Normally client where you have access to code, In my case it was 400)
  2. Goto T-Code SALE
  3. BASIC SETTINGSàLOGICAL SYSTEMSàDEFINE LOGICAL SYSTEM
  4. Cross client information shall pop up : CLICK ON TICK
  5. Click on New entries
  6. Enter the logical name and description
  7. Click on Save button
  8. Select the correct Request and click on tick mark
  9. Exit
  10. Goto SM 59( for defining RFC Destination)
  11. For Biztalk select TCP/IP Connections
  12. Click on Add
  13. Enter the Logical name we put in step 6. Also enter the Description
  1. Select Registered server Program in Technical setting and give a Program Id(Naming convention to be followed is “PI_” Logical system
  2. Goto Unicode tab
  3. Select Unicode. An information box shall be shown. Click on the tick mark
  1. Click on Save. (Do not do connection test now. We need to configure Program id in Biztalk. Then only connection test be success)
  2. Log in to testing client (In my case it is 430)
  3. Goto t code bd64
  1. Click on edit button
  2. Select the proper model view (you can create a model view if needed by clicking create model view). For outbound idoc to Biztalk select MV_EAISAP(Model view for SAP Outbound- Biztalk Inbound)
  3. Expand model view
  4. Click on “Add Message type”
  5. Enter all values in all text boxes
  6. Model view à the model view created
  7. Logical system we created for SAP
  8. Logical system created in step 6
  9. Message type we mapped for IDOC
  10. Click on Save
  11. Select the message type we added in the tree view and Click on Environmentà Generate Partner Profiles
  12. Following screen shall be shown
  13. Click on execute(F8)
  14. Following screens shall be shown

Port and other relations shall be automatically created by this.

  1. Login to Biztalk Admin Console
  2. Open the Project you have deployed
  3. Define the receive location with Program Id we configured
  4. Enable the receive Location
  5. Now log in to SAP, goto RFC destination selected (SM59) and do the connection test. It should give “connection ok” like below
  6. Now do the Unicode test. It shall give the below screen
  7. Now create a filter send port(file type) in BizTalk application
  8. Enable the send port
  9. Trigger and IDOC
  10. Check the Biztalk File folder for the idoc xml file generated
  11. Goto SAP and check “smgw” t-code. We will find the active connections in the SAP gateway.

 

For steps with screenshots, please find the below word file.

SAP OUTBOUND IDOC CONFIGURATION FOR BIZTALK