Företag i Nya Zeeland hittade Integration Software via Google

Att den fysiska platsen som ett företag verkar på spelar mindre roll tack vare digitaliseringens utveckling för att växa globalt har det lilla produktföretaget Integration Software i Karlstad fått erfara. Idag arbetar här fyra personer med att leverera spetsprodukter inom systemintegrationsområdet. Och tack vare deras synlighet i digitala medier som Google har de fått kunder både i Nya Zeeland och England. Kunder de kontinuerligt arbetar med men aldrig träffat.

Artikeln i sin helhet finner du här

Yet another Integration platform supported! Now supports Mule ESB

We are proud to announce that Integration Manager now supports Mule ESB. With future releases it will be possible to monitor applications and endpoints in Mule. It will also be possible to track messages and context within Mule applications.

Monitor Mule applications and endpoints

The next two pictures show an example of a monitor view of Mule. In the first one everything is working as expected but in the second one an application is indicating an error. In this case the application has been stopped.

Integration-Manager-Monitoring-Mule

Integration-Manager-Monitoring-Mule-Application-Stopped

Start and Stop actions

If the monitor view is configured to allow actions it will be possible to start and stop the monitored Mule applications and endpoints. Just click on the action button and select start or stop.

Integration-Manager-Monitoring-Mule-Actions

Tracked message events in Mule

Integration Manager receives the tracked messages (body and context) by using the Log component in Mule.

Integration-Manager-Mule-Logger

It is also possible to use the Mule Custom Business Events to retrieve the necessary information. Custom Business Events are only available in the Enterprise Edition.

 

After the messages has been processed by Integration Manager the will be shown in the web client.

Integration-Manager-Tracked-Messages-Events-Mule

 

The context of the received message.

Integration-Manager-Tracked-Messages-Events-Mule-Context

 

More from Integration Software:

Videos on  YouTube
Information on  Twitter
Contact on  LinkedIn

Online documentation: Latest version
Latest release notes: Release Notes
Support site: Support Site

 

Supervise the size of your SQL Databases in Azure

Make sure your SQL databases in the cloud stay performant and within the sizing thresholds your business requires. By monitoring the size, you gain awareness and can take actions to keep only the required amounts of data. This will save you money.

With the SQL monitor agent in Integration Manager it is easy to keep track of your SQL Databases in Azure. Today the there are two categories available for monitoring the SQL Databases.

  • Size check
  • Custom statements

This blog post describes how to monitor size checks using Integration Manager.

SQL Monitor Agent

With Integration Manager comes an agent for monitoring SQL Server instances and databases on premise and SQL Databases in the cloud. To read more about the agent and see all supported monitoring capabilities, please visit the Documentation site.

The Agent can be installed in multiple instances on premise or in the cloud/partner location on a virtual machine.

SQL Monitor Agent

 

Global Configuration

Using Remote Configuration the agent can be configured to monitor one or more databases

Size Check Category

Configure

Configure the thresholds for the size check category to get warnings and errors if the limits are reached. An error will also be raised if the resource is unavailable (network error, someone accidently removes the database, changes permissions and so on).

There are two options available for the size check evalution

  1. Percentage
  2. Size in Megabytes

Remote Configuration SQL Server

Read more about configuration in the Integration Manager Documentation, Azure – SQL Size Checks.

Monitor

When the configuration is done it is easy to add the resource to one or more Monitor Views. Within the monitor view you can configure whether an alert should be raised or not when an error or warning occurs. More about Monitor Views in Integration Manager can be found here.

Azure SQL Monitor

This screen shot shows a list of my Monitor Views.

The Azure SQL Monitor view, which supervise the size of the databases are currently OK in the example above. The other view, ‘Azure LogicApps Monitor’ indicates a problem with my Logic Apps (more about monitoring Logic Apps in a future blog post).

Detailed configuration

A specific resource can easily be reconfigured and information about limits are also showed. In the example below one can see that there was indeed a size limit on just 100 MB and percentage was the better monitoring configuration for this specific database.

Azure Database Size Check Configuration

Summary

With Integration Manager it is easy to monitor all your assets independent of where and what they are. This was a short blog post about how to monitor your Azure SQL Databases without logging in to the Azure portal and manually keep track of the size.  A database cannot grow beyond limits and your business critical applications will fail if there’s not enough free space to deal with your transaction needs. Stay proactive using Integration Manager

Videos on  YouTube
Information on  Twitter
Contact on  LinkedIn

Online documentation: Latest version
Latest release notes: Release Notes
Support site: Support Site

Integration Software joined Power BI Red Carpet

We are proud and happy to announce that we at Integration Software now are part of the Microsoft Power BI Red Carpet program, making us an official partner and enabling us to provide our customers with the latest information and great support for Microsoft Power BI.

Microsoft Power BI is helping users spot risks & find opportunities at a glance so they can save the day, every single day.

Microsoft Power BI has been adapted to Integration Manager at an early stage. It is a great way for customers within the IT department to provide their business and other departments with the data they need to have the insights and control over system integrations they want. System integrations have been and still are black holes for many departments of an organizations. This black hole must no longer be a black hole and we believe and know that by using Integration Manager together with Microsoft Power BI, you enable your business to use integrations as a business resource, rather than a cost. But it is not only the business that can take advantage of this solution, the possibilities are endless.

  • Document system integrations with Integration Manager and easily find out dependencies, who is responsible, versions and so on by connecting it to Power BI.
  • Change Managers can easily find out systems/applications that are being affected when making and applying changes and giving them with one sight whom to contact.
  • Track the number of errors per integration
  • Measure the number of messages per integration
  • Provide the business with dashboards giving them live status of the systems and the information for them to know if everything is up and running
  • And much much more…

Feel free to contact us at info@integrationsoftware.se and book an online demo showing you both Integration Manager and Power BI and the endless opportunity both solutions provide!

Monitor Microsoft Azure services with Integration Manager

The number of monitor agents is getting bigger and bigger enabling you to monitor even more systems, services, platforms and applications. Not only are we working on supporting even more integration platforms, such as Mule or iCore, … we also work on integrating more with the Microsoft Azure platform, enabling you to monitor your cloud-based & hybrid integrations with ease – centralizing message logging and monitoring into your Integration Manager platform and having it all in one place.

We are currently supporting the following Microsoft Azure services:

  1. Cloud Services
  2. App Services (Logic & API Apps)
  3. Web Jobs
  4. Service Bus

Integration Manager 4.0 webinar available on YouTube

The webinar held on September 22nd, 2015 is now available on YouTube – click here.

We were showing some of the new features available in the new version of Integration Manager – version 4.0.

List of features seen in the video:

  • Actions
  • Expected State
  • Dynamic Data Custom Field plugin
  • User Interface
  • Search Field Expression tester
  • Source remote configuration
  • etc

[Webinar] Join the webinar and see Integration Manager 4.0 in action

On September 22nd (Duration: 1-hour) we will be showing the new features of Integration Manager in action.

It has been a busy year for us. We have been working hard on stabilizing and improving Integration Manager – and the result is amazing. Working with your integrations is becoming easier and easier, the insights and control given is helping not only you in your IT department, but also your business!

Our main focus on this version has been the monitoring engine of Integration Manager making it a lot easier to configure and to administrate the different resources / systems / applications you are monitoring. But not only the monitoring engine has been improved, a lot has happened and we would like you to join us at our webinar to see the improvements we did!

Feel free to join the webinar and learn more about the new version of Integration Manager, version 4.0.

Register here or contact us at info@integrationsoftware to book an online demo.

Integration Manager 4.0 – Webinar

Date: September 22, 2015 – 1:00 PM CET (Duration: 1 hour)

We are happy to announce the release of Integration Manager’s upcoming version – version 4.0.

We would like to invite you to our webinar giving you the opportunity to see all the new features / functions and changes. 

Feature Agenda:

New Changes
  • Actions / Control Center
  • Expected State
  • Custom Fields / Dynamic Data
  • End-To-End Monitoring Capabilities
  • UI Changes

Click here to see a full list of news and changes.

Want to know more? Contact us at info@integrationsoftware.se to book a private in depth meeting.

YouTube Channel

YouTube is a great way of sharing videos with other people around the World, that is why we at Integration Software decided to create our own YouTube channel. This to make it easy for us to share tutorials, introductions, etc regarding the products we offer. We started recording videos for Integration Manager, but will of course over time create videos for the rest of our Products we offer.

Feel free to comment the videos or to contact us to tell us everything about what you think!

You can reach our YouTube channel by following this link.

Connect Microsoft Office Excel using Power Query to Integration Manager

This is a tutorial describing how you can use all the data from Integration Manager in tools such as Microsoft Office Excel using Microsoft Power BI’s add-in for Excel – Power Query.

Before you get started

This tutorial also assumes that you have a basic understanding of what is Power Query and how to use it – if you do not please follow this link that helps you get started within just a couple of minutes. Please make sure you have the access to the Integration Manager instance(s) you want to connect to as well as a working copy of Power Query installed to your Excel. In case you are using Excel 2016 Preview, Power Query is already part of the suite and does not need be installed. In case you are a Excel 2010, 2013 user use the following link to download Power Query – https://www.microsoft.com/en-us/download/details.aspx?id=39379.

Note: The below tutorial also works while working with the Power BI designer – Microsoft Power BI’s stand-alone client for connecting to external data sources.

Introduction

While Integration Manager is used for logging and monitoring purposes, we thought – why not create an API layer to which our users can connect to by using 3rd party applications, such as Microsoft Excel, and take advantage of everything that is going on. And that is exactly what we did. Integration Manager’s Web Client uses the API layer to work with Integration Manager’s data, that means that everything you can see in the GUI of the web client, can be received by using tools like Microsoft Excel.

The Web API

By navigating to the WebAPI URL of the installed instance of Integration Manager with your browser you get a list of all available API calls (see picture 1 below) –  the URL is usually something like http://servername/IM/WebAPI.

webapi-reference

Picture 1: Web API reference

 

The Web API layer is of course secured, that means for instance, that you are required to be part of the administrators group in order for you to access alarms, stylesheets and so on by using the Web API. You can only receive the data you are allowed to see, so if you are not an administrator you cannot use HTTP POST, PUT, DELETE commands – only GET and you can only receive events and monitor data from views that you have access to!

How to

Let’s assume you would like to get a list of all integrations that you have documented with the Repository Model of Integration Manager and import it to Microsoft Excel.

The API call for this action would be http://servername/IM/WebAPI/api/integrations/ (see Picture 2 below showing the result in the browser).

Picture 2: Result of integrations API call

Picture 2: Result of integrations API call

 

Copy the URL of the API call and open up a new Power Query – From Web (see Picture 3 – This is version Excel 2016 . In Excel earlier than 2016 you will have a tab that says “Power Query”).

Picture 3: New Power Query

Picture 3: New Power Query

 

Paste in the API call URL and press OK.

Power Query might ask you for more authentication details – use Windows Authentication and press OK. In the current state of Integration Manager we do not support other authentication methods than Windows Authentication. (see Picture 4 – Choose Windows Authentication).

Picture 3

Picture 4 – Choose Windows Authentication

 

As soon as you have pressed the OK button the Power Query Editor windows pops up and you are able to navigate through the API of Integration Manager with a nice and clean editor – the Power Query Editor.

Note: Integration Manager’s API uses Collection+JSON as its standard for how the API is build – learn more at http://amundsen.com/media-types/collection/.

The result

If you have navigated through the object model that the API call provided you, you can easily achieve a system-dependency report showing you what systems are used in the different system integrations. (See picture 5 below – system dependencies)

Picture 5 - System Dependencies

Picture 5 – System Dependencies

 

Summary

Connecting Microsoft Office Excel / Microsoft Power BI to Integration Manager is easy by using the API reference of Integration Manager and using tools such as Power Query and/or the Power BI designer.

If you want to learn more about how to use Integration Manager together with Microsoft Power BI – feel free to contact us at info@integrationsoftware.se and we are happy to book an online demo with you for showing you the power of Integration Manager.

Twitter
YouTube
LinkedIn