ILM works on a single object at a time, so it can be a little tricky if you want to make a decision based on other objects in your metaverse. It is, however, perfectly possible (though, I believe, officially discouraged) to run SQL queries against the metaverse table from your extension code.
This is a repost of an article which was originally about multivalue attributes in general, but with a focus on group members. I realised I had made some generalisations about multivalue attributes which actually specifically apply only to attributes like member, which contain reference DN values. So I am now re-releasing the post, with a [...]
And now for a closer look at the configuration of SQL MAs.
The config details that are common to all MA types are covered in this post, so I won’t repeat them here.
The SQL-specific options probably apply equally to the Oracle and DB2 MAs, but I’ve never used ‘em myself.
We’ll start on the Connect to database [...]
Here’s a really, really useful trick. You can copy the MicrosoftIdentityIntegrationServer database to another server, run miisactivate, and, within no time at all, have an exact replica of your live server.
Let me just spell this out – not only will you have all your MAs, your Metaverse fully populated, and your Connector Spaces fully populated; you [...]
A frustrating deficiency of the Identity Manager application is the inability to copy the list of disconnectors from the Joiner page. I really don’t understand why this functionality wasn’t included – was it just an oversight? Ploughing through the disconnectors is an inevitable part of taking over an existing directory, and to do that you’re [...]
Continuing on from this post, let’s say you’ve got a DTS package that is successfully creating Delta tables. You will now want to combine this with your MIIS Delta Import job.
Simple Scheduling
If your system is not particularly time critical you may be able to get away with very basic scheduling. SQL allows you to schedule [...]
When planning delta imports from SQL, thought needs to be given to clearing down the delta tables. If you have any type of code running in response to the imported data then you have to accept that import errors will occur, some of them not even your fault!
What should happen to the rows in [...]
Let me just say, at this point, that SQL was a mystery to me before I started working with MIIS. I’d always looked at it from a sys admin point of view – set up the server, install SQL, maybe even do some patching, and then hand it straight over to the DB people.
But you [...]
I’ve already covered how to create a multivalue table for SQL MAs; and I’ve also talked about generating Delta tables for single-valued attributes. If you are doing multivalue imports from SQL you are really going to want to get Delta imports working there too …. those babies can be sllloooowww. We need two tables for multivalue imports, [...]
MIIS gives you the option of specifying individual attributes to include in your delta import. Presumably you could use this to specify which single-valued attribute to import (perhaps the ‘Surname’ has changed, but nothing else has), but I’d be surprised if you got much of a performance improvement compared to just re-importing the whole row. [...]
