Index:
Prerequisites
In this article, we'll go over the steps for setting up an Integrations Hub Pushabck with iMIS EMS.
*** Not sure if you have EMS or iMIS Web Service? Here's an easy way to check:
Within your iMIS account, navigate to:
Settings > About iMIS > iMIS version
Version 20.3 or later = EMS
Version 20.2 or earlier = Web Service
Here is a screenshot of what this settings area will look like or similar to:
Important Note: In order to set up a Pushback through Integrations Hub, you must configure an Integrations Hub SSO first.
If you do not have an Integrations Hub SSO, please configure one here first.
Basic Setup within Your OpenWater Instance
We're going to create a program for where our Pushback will be used, a form for our program (that collects the data we are pushing back to iMIS), then, a few test submissions. If you already have these items in place, feel free to skip to the next section: Basic Setup within Integrations Hub
As an OpenWater admin you can login to your organization's instance here:
https://{InstanceName}.secure-platform.com/admin
Follow the prompt to login then you'll be brought to your dashboard that will look similar to this:
We're now going to add a program.
Once you're done adding your program, you'll create your submission form. This form can be updated and changed whenever you like, so for the purpose of building this Pushback, just focus on including all of the fields you know you need in general (name, email, title, etc) and fields specific to the Pushback.
Next, create a few test submissions in your new submission form:
Get your program's direct link, it will take you to the submission form you built to fill out a test submission.
For your test forms, fill in whatever test data you'd like i.e. John Doe, Test Company, etc.
Make sure to fill out the entire form and use unique data for each form so you can tell them apart during testing later.
Once this is done, you can return to your dashboard. We have a few more items to complete in your instance in the next section.
Basic Setup within Integrations Hub
Get Started with Integrations Hub.
Add a new Pushback connector from the Integrations Hub dashboard.
You will be brought to a page with different Pushback options. Select iMIS (Applications).
You should now see the page below. We'll need to fill in a few settings:
Select the program that has your sample applications from your OpenWater Instance.
For credentials, choose the saved credentials from your previous SSO integration mentioned at the beginning of this article.
Set the CRON Expression to how often you'd like the Pushabck to trigger. We normally suggest Every Hour.
Once the above is added, click Save in the top left corner of your screen.
Select the Field Mapping tab towards the top of your screen and click Create Panel with Basic Mapping.
Give the panel a name and click create. I suggest a name like ow_ Pushback2023. My example uses ow_samples.
This will add a panel to your iMIS account. Press Run Once toward the top of the screen.
Great, now let’s see the data in iMIS. 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.
Note, you can add whatever fields you wish to the iMIS panel.
iMIS Side Settings
In a new browser tab, go to your iMIS organization account URL: https://{instanceurl}/staff
Example:
My organization is called King of The Hill and my website is KingoftheHill.com. This means my iMIS account login link should be: https://KingoftheHill.com/staff
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.
Now we're going to begin adjusting some settings and gathering a few items from within your organization's iMIS account.
Let's see where the data from this Pushback is going in iMIS. 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".
You can import an IQA or create your own from scratch.
Write "OpenWater" as the folder name and then click "Save".
Save this gist then import it into the OpenWater folder. Do this by selecting the folder OpenWater, and click Import at the top of your screen. A new popup will appear with a file importer. Select the gist we had you save, and click "Upload".
Ensure you update the destination with the new folder and click "Import".
Within your new IQA, go to Define > Sources > All Sources.
Next, search for the panel we just created:
Click into the panel we made and then go to the display tab and choose all columns.
Check off all available properties, press Save, then press Run.
This is where the data from OpenWater will be captured.
In iMIS, every IQA now has a checkbox for security settings called "Allow Access via REST API". You must check this box.
Back to Integrations Hub
Jumping back to Integrations Hub in the browser tab you left open earlier, we need to add your field mapping to wrap up the Pushback integration.
Now that we've added the panel iMIS, refresh the Integrations Hub Field Mapping page and choose Add Field.
You can now map any OpenWater form field to the iMIS Panel by using the drop-down options to connect your OpenWater Field to its corresponding iMIS Field. Then select Save in the top left corner of your screen.
Once you're ready, remember to Start the integration so it runs on a recurring basis.
Additional Tip:
If you wish to add custom fields to the Pushback, simply add more fields via the Rise Panel Designer in iMIS.
Testing Your New Pushback
You can test the integration by pushing just 1 test submission in OpenWater.
Wait for your pushback's CRON Expression to trigger.
After the designated time has passed, log in to iMIS and navigate to the IQA we created in Here you should see the data from your test submissions populate.