Tuesday, April 26, 2011

[22] Integrate from different DB using GEL

I once needed to import some data, on daily basis, from SQL Server to my Clarity database which is on Oracle. Wrote a GEL script which will do this thing in simpler way. Though there are many more efficient ways of data integrations, however this is within Clarity's scope and without need of writing external program/script to achieve this task.

Click here to download the script. Readme.txt file attached.


Monday, April 18, 2011

[21] Experimental Clarity Single Sign On (SSO)

Few days back, I was just experimenting on Single Sign On (SSO) with Clarity and came up with a light weight workaround. Though, it is still in Testing/Beta phase...

Click here (v13) to download source, code, instructions and limitations. (Refer Readme.txt).
Click here for V12 files.

For me it is working fine in Windows/Unix environments with Clarity 12.1 on it. (Not tested on earlier Clarity versions, though). Also works for embedded Clarity links/notifications in emails/documents.

Change log:-
18-May-2012 : v13 version published. 
21-Sep-2011 : 0.3 Beta Added enhanced security.
19-Apr-2011 : 0.2 Beta Minor Bug Fix
18-Apr-2011 : 0.1 Beta Released

Monday, February 28, 2011

[20] Clarity and Windows 2008 Active Directory

Infrastructure group was rolling out Active Directory upgrade to Windows 2008. Clarity 12.0.x or below doesn't support Windows 2008 Active Directory.

We worked with Clarity and Microsoft team to find a solution. We didn't have Clarity version that supports 2008 AD and Infrastructure team didn't want to stop upgrading to Windows 2008 AD.

After a long battle and with so many calls/emails with Microsoft, we got a fix from them. This needs a registry change in Active Directory Server. It was tested and finally deployed on all Active Directory Servers. Now Clarity (12.0.x) runs fine with Windows 2008 AD.

[ Make following Registry changes in Windows 2008 R2 Domain controller servers]

HKLM\System\CurrentControlSet\Services\NTDS\Parameters
Add String value “DSA Heuristics”
Set the value to 000000000001

More detailed discussion can be found here , and also some explanation I logged as SangeetC (on 06-Aug-2010)

* Test it in your environment before moving changes in Production.