Configuring an Azure SSO portal

In a previous blog post I show how to enable your Office 365 Azure AD. Once you have access to Azure AD you have access to the free version of Azure AD. Amongst other things this allows you to manage user accounts, synchronise with on premises directories and get single sign (SSO) on across Azure, Office 365 and thousands of web based applications.

To set up this SSO portal you will need to login to your Azure AD as an Office 365 global administrator.

image

Select Active Directory from the menu on the left and the name of your Active Directory. That should display a screen like that shown above. From the menu across the top select the Applications option.

image

This will list any pre-configured web apps. If this is the first time here you will probably see that both Office 365 Exchange Online and SharePoint Online have been configured for you.

To add a new application to the SSO portal select the Add button at the bottom of the page.

image

Next, select the option to Add an application from the gallery.

image

You should see that there over 2,400 apps currently that you can select from. The easiest way to locate app you want to integrate into your SSO portal is by using the search features in the top right.

Here, I’m going to integrate Evernote, so I simply select the icon in the middle of the page once I have located it in the list.

image

Different applications have different configuration requirements but in this case with Evernote all I need to now do is assign which users need to access it. I do this by selecting the button Assign users.

image

This should now take you to a list of users (here, my Office 365 users).

Firstly, select the user you wish to assign the app to and then press the Assign button at the bottom of the page.

image

This will now prompt you to enter the app login credentials you wish to have for the user. Enter these and select the check icon in the lower right corner.

image

You should now see that user has a Direct assignment for that app as shown above.

image

To access the SSO portal you need to have users navigate to:

http://myapps.microsoft.com

and because we can connected our Office 365 directory to this SSO they can login using their usual Office 365 credentials but now they will only need to do that to access all their web based applications you have configured for them.

image

Once a user logs into the SSO portal they will see all the apps that you have configured for them. To access any of these they simply click on the icon.

image

In this case, if I click on the Evernote icon I just configured a new tab in my browser will automatically open and I will be automatically logged into the application using the credential entered at the configuration stage.

So that’s the basics of what’s included for free with Office 365, Azure and the single sign in portal. Is there more that you can do? Sure is, but that will have to wait for an upcoming blog post.

Introduction to Lookup Columns in SharePoint

SharePoint has the ability to act as a basic relational database. Thus, you can create one list that if referred to by other lists. This means that you can maintain only a single location for all your information. The most basic method to achieve this is by using Lookup Columns.

This tutorial will show you how to create a lookup column in a new list and then how to work with the information. You’ll see how to add and update information as well as edit the column headings in the new list so they present better.

This video is another in my Intermediate SharePoint series that you can follow through. Of course don’t forget my Getting Started with SharePoint series which you also get via email or download and install on your own SharePoint Team Site. You can subscribe to the free Getting Started with SharePoint lessons by entering your email below.


#mc_embed_signup{background:#fff; clear:left; font:14px helvetica,arial,sans-serif; }
/* Add your own MailChimp form style overrides in your site stylesheet or in this style block.
We recommend moving this block and the preceding CSS link to the HEAD of your HTML file. */

Subscribe to free SharePoint training via email

Need to Know podcast–Episode 73

I’m joined by an old friend, MVP Mark O’Shea to talk reseller opportunities in the Microsoft cloud. We especially look at products like Azure and Intune. Mark gives us his experience and knowledge about really getting into Azure and how it can make a real difference to your business and your customers.

Mark spells out how import Azure is becoming and why resellers really need to start looking into what solutions it can provide from them. You’ll also hear more about Intune and role that it can play when coupled with Office 365 and Azure to provide an overall management solution.

You can listen to the episode at:

http://ciaops.podbean.com/e/episode-73-mark-oshea/

or subscribe to this and all episodes in iTunes at:

https://itunes.apple.com/au/podcast/ciaops-need-to-know-podcasts/id406891445?mt=2

The podcast is also available on Stitcher at:

http://www.stitcher.com/podcast/ciaops/need-to-know-podcast?refid=stpr

Don’t forget to give the show a rating as well as send me any feedback or suggestions you may have for the show.

Resources

intunedin.net

@intuned

OneDrive for Business now available for MAC

Yes all you Office 365 and Mac fan boys and girls, Microsoft has just announced that SkyDrive for Business sync client for MAC is available on iOS! You can read all the good news here and how you can procure it:

http://blogs.office.com/2015/01/28/onedrive-business-comes-mac-ios-devices/

There is also an Office Mechanics video that shows you all the features.

Demonstrates how OneDrive for Business is really a great cross platform tool for sharing and syncing files.

Connect SharePoint to MS Access

You can consider SharePoint as an extension of the Office applications you have on your desktop. One of these that provides a huge amount of power but gets used infrequently is Microsoft Access.

Many don’t appreciate that you can easily connect a SharePoint list to Microsoft Access on the desktop. Doing so allows you to use SharePoint as the data repository and Access as the analytical front end, allowing to create complex structures and queries as well as producing mind blowing reports and data analysis quickly and easily.

This tutorial will show you the basic steps of connecting SharePoint to your desktop version of Access. You see how that when you do it establishes an bi-directional link that means data is updated no matter where it is changed.

This is only the beginning of what is possible when you combine Access and SharePoint, however it is a very good place to start. Watch out for more content on this topic very soon.

Globalization of SMB–Webinar

 

 

 

 

 

 

 

 

I got up very, very early this morning my time to be the guest on Karl Palachuk’s Webinar series – The Globalization of SMB – a Webinar Series.

The session was recorded and you can watch in on YouTube:

or listen to the MP3.

Here are list of books I recommend as good reads to help with a transition to global focus:

The World is Flat – Thomas Friedman

The Four Hour Work Week – Tim Ferriss

The Millionaire Fastlane MJ DeMarco

The Tipping Point – Malcolm Gladwell

I also encourage people to look at support international organisations like Kiva that provides micro-financing all around the world. You can view my Kiva portfolio of loans here:

http://www.kiva.org/lender/robert5824

I do read a lot of material and recommend you follow me on Goodreads here:

https://www.goodreads.com/user/show/708903-robert

To keep up with the changing world of business and technology I strongly recommend:

Fortune Magazine

of which I have been an avid reader for over 25 years.

If I had to pick a favourite place in the world I have been to it would be:

Ryoanji Temple – Kyoto

and a close second would be Berlin:

Berlin – my travel log

For Australian’s travelling to Europe I would strongly recommend the Australian Battlefields of World War One. I have been twice and created a whole web site about the Australian involvement there:

Australian Battlefields of World War 1 – France

The one thing I’d recommend you pack when you travel is:

Skins

and the one travel tip I have is that no matter how tired you are when you arrive at your destination, only sleep when it is dark. It is painful the first day but gets you in sync much faster.

I thank Karl Palachuk for the opportunity to be a guest and hope that everyone got value from my experiences and opinions. Of course if you have any feedback or question please feel free to contact me directly (director@ciaops.com).

Need to Know podcast–Episode 72

James Eling returns to discuss the importance of building a strong business culture. James shares his experiences, wins and losses, in achieving this within his own business.

In this episode you’ll get some really great insights and information that you can implement inside any business immediately. Most importantly, you’ll understand what does and doesn’t work when it comes to building a viable and successful culture within a business from someone who has already done that. Plenty of learnings from an experienced operator here.

You can listen to the episode at:

http://ciaops.podbean.com/e/episode-72-james-eling/

or subscribe to this and all episodes in iTunes at:

https://itunes.apple.com/au/podcast/ciaops-need-to-know-podcasts/id406891445?mt=2

The podcast is also available on Stitcher at:

http://www.stitcher.com/podcast/ciaops/need-to-know-podcast?refid=stpr

Don’t forget to give the show a rating as well as send me any feedback or suggestions you may have for the show.

Episode resources

James Eling

www.extremenetworks.com.au

jeling@extremenetworks.com.au

Australian Office 365 tenant relocation information

As you hopefully already know, Microsoft has announced a raft of new datacenters for Office 365. One of the most exciting for users down under is the opening of Office 365 datacenters in Australia and the relocation of Australian Office 365 tenants from their current location in Singapore to Australia starting at the end of March 2015.

If you want all the latest information about this visit:

New datacenter regions for Office 365

Where you’ll find information about how the move will take place, what impact there will be, what you have to do (if anything) and the expected communications that will come from Microsoft. There is also a specific Australian FAQ that locals should look at.

If you are interesting in having your Office 365 tenant moved early as part of a beta test that will allow Microsoft to test the process you can register your interest here:

Registration for Office 365 Customer Data Move Beta program for Office 365 customers

Microsoft will select tenants to relocate depending on certain factors that will allow them to test their processes, so you may not get selected and it is not on a first come first basis. I have applied, so fingers crossed that I’ll be one of the first to experience the differences and can report back here.

So check out the information Microsoft has provided and check back regularly as it is being updated daily. If you have any questions about the upcoming migration to Australian data centers, start there.