Index:

In this article, we'll go over the steps for setting up an Integrations Hub SSO with iMIS Web Service.

*** Not sure if you have iMIS Web Service or EMS? Here's an easy way to check:

Turns out you have iMIS EMS? See this article.

1. Get Started with Integrations Hub.

2. Add a new SSO connector from the Integrations Hub dashboard.

3. You will be brought to a page with different SSO options. Select iMIS Web Service.

4. You will now be shown the below screen. Keep this screen open in your browser. We'll be jumping over to your iMIS account to adjust some settings but we'll need to return to this page once we're done.

5. In a new browser tab, go to your iMIS organization account URL: https://{instanceurl}/staff

Example:

6. Request admin login credentials from your staff if you don't have them already (it's important that these credentials are admin, other account types will not have access to what we need). Once you have the proper credentials, login to iMIS with these credentials on the above page.

7. Now we're going to begin gathering a few items from within your organization's iMIS account. We'll be copy/pasting these items into your Integration Hub so be sure to add these to a notepad as we go, for easy reference after.

https://{imisInstanceUrl}/AsiCommon/Controls/Shared/FormsAuthentication/LoginStatusRedirect.aspx

https://{imisInstanceUrl}/asicommon/services/membership/membershipwebservice.asmx?wsdl

https://{imisInstanceUrl}/asicommon/services/query/queryservice.asmx?wsdl

8. Next, we're going to grab your Login URL from inside iMIS. Once logged in, you'll see settings/ dashboard items located on the left side of your screen. You need to scroll down to Rise > Page Builder > Manage Content:

9. You'll be brought to a new page. On this page, go to the top, and select New > Website Content.

10. Then, under the Definition tab, add the Publish Title. We usually suggest: OpenWaterRedirect

11. Now click into the "Properties" tab and check off "Content requires user to log in", select user condition for redirect as "User is authenticated"

12. Next, Change the Target URL or shortcut for redirect to the Integrations Hub Begin URL which you can get from integrations hub settings page. See the screenshots below. Once done, click "Save and Publish" in iMIS.

13. With this complete, you can now get your Login URL. After clicking "Save and Publish", go back to the Definition tab. You will now see a Login URL on this page, labeled as "Publish Location". It should follow this structure: https://{imisInstanceUrl}/OpenWaterRedirect.aspx

14. Let's grab your User Info IQA Path. Looking back to your iMIS dashboard items located on the far left of your screen, click Rise > Intelligent Query Architect. Once this page loads, click "New" (located at the top), and select "Folder".

15. Write "OpenWater" as the folder name and then click "Save".

16. You will see the folder has been created on the files explorer section, click on the folder and then select New > Query

17. In the Summary Tab give the query name, usually we use: GetDataByUserId

18. In the Sources tab click on Add Source then select CsContact object and click ok

19. Go to the Filters tab and make sure Advanced Mode is enabled

20. On this same page, we're now going to populate these settings:

21. Now go to the Display Tab and select "View all Columns"

22. This should show you all available properties. Select what fields you want to get for the user profile which will be used to map to OpenWater's user profile fields. Once you're done, click "Save" in the top right.

23. You'll now need to create your Query path. This query path will be: $/OpenWater/GetDataByUserId

24. Jumping back to Integrations Hub in the browser tab you left open earlier, we're going to now add all of these data pieces from iMIS to your Integrations Hub settings. At this stage you should now have:

25. Let's begin by giving your connector a name. This name can be whatever you'd like but we normally suggest this format: {Name of Organization} SSO {Year}

26. You now copy/paste the Login URL you saved earlier in the field located under the Name. This should be the URL for the page you created on iMIS, and it should be: https://{imisInstanceUrl}/OpenWaterRedirect.aspx

27. Under the Login URL field, click "Select Credentials" then click "Add New Credentials" from the drop-down menu:

28. You should now have a half-window open up on the right side of your screen labeled "Create New Credentials". You'll need to input the following from those previous pieces of data we saved:

29. The "Create New Credentials" half-window will now close. Click "save" at the top of left the connector settings.

30. Located under "Save" on the top left of your screen, click the "Field Mapping" tab. You'll now see an assortment of drop-down menus, allowing you to set what user profile fields your SSO will pull from your iMIS database into OpenWater. You can add to or delete any of the fields that auto-populate for you.

Additional Tip:

31. Once you're done, click "Save" and then "Publish" in the top left of your screen.

32. Now go back to your "Settings" tab and copy the Begin URL

33. Login to your OpenWater instance as an admin: https://{YourOpenWaterInstanceName}.secure-platform.com/admin/

34. From the dashboard settings located on the left side of your screen, scroll down to System Settings > Login Configuration

35. On this Login Configuration page, add the below settings:

Secret Key in Integrations Hub Settings:

36. Your SSO is now complete- high-five yourself, you did it!

37. As with any new integration or workflow, testing is super important! Follow these steps here: https://help.getopenwater.com/en/articles/6991126-testing-a-new-sso-single-sign-on-integration