Thursday, November 12, 2015

Generic SQL Management agent released

Today is a big day for me...

For a long time now, I've wanted to build a new SQL Management that could do more than the built-in SQL Server Management Agent that you get out-of-the-box with FIM and MIM. And, finally, I have done just that.

It is here....

By using this generic Management Agent for SQL, you can synchronize almost any type of information with SQL Server tables - and now you can finally do deltas as well ...and hold on, you can run stored procedures against the tables as part of your synchronization import and export schedules. All these tings combined should give you the options to make some awesome solutions with FIM/MIM and SQL.


The MA have a lot of features that are needed for a modern FIM2010 or MIM2016 setup, including -
  • Full and delta imports
  • Delta and full exports
  • Can keep and revive deleted information / rows
  • Can execute pre- and post import/export Stored Procedures
The schema is very flexible and is generated based on the database tables definitions. A refresh of the schema for this management agent rediscovers the schema and you can override the structure in different manners using a configurable XML data.

I really hope that you make use of this MA and please let me know if there are any issues as this is the initial release - and I'll try to fix any issues as soon as possible.

You can get it on CodePlex from this URL - https://sqlma.codeplex.com/

Go it a go when you can...

Enjoy,
Soren

Sunday, November 8, 2015

Minor update of PowerShell MA released

I've released a minor update for the PowerShell MA. The build number for this is 5.5.1.1017 and the build is compatible with earlier 5.5 releases so you should be able to just replace the .DLL in the Extensions folder of your installation

NOTE - the MA now requires .NET Framework 4.5.2 to run, so please make sure that you have that installed on your Synchronization Service server.

The big news for this version is that I have added support for Write-Debug, Write-Verbose, Write-Progress, Write-Warning and Write-Error in your scripts. Any information from these commands will go into the trace log and  any information from Write-Warning or Write-Error will also go into the event log on your Synchronization Server for you to monitor and react to.

Also, all scripts will now receive an extra parameter of type PSCredential that hold the username and password configured on the MA. This is handy for you to use in your scripts. You will still get the username and password as separate parameters.

This version contains these changes -

  1. Added support for Write-Verbose/Debug/Progress/Error in scripts.
  2. Changed PowerShell host to use PowerShell instead of RunSpace to remedy memoryleak in System.Automation.dll if using RunSpace.
  3. Optimized import code to be more responsive after script returns.
  4. Also, added support for control values naming to no longer being case-sensitive. 
  5. Added additional parameter to all scripts to pass a PSCredential object for use in scripts.Simplified logging information for import objects.


As always, I've tried to test this version, so hopefully there are no big issues. Please do let me know if you find anything.

Go find the new version in the download section for the PowerShell MA.

Enjoy,
Soren