Sunday, July 31, 2011

Content Management (CMS), Document Management Solutions

Today I got chance to expolre my knowledge on content management and document management product specially for Alfresco Open source Content management.There are lot of product in the current market and every bit IT company like IBM,Oracle,OpenText ect are palying vital role to provide this solution to Oraginaztion.
This is great solution to manage document(e-document) and conetnt of site of any oragnization at highly security level.Some more features also have.It is also provide the colloboration solutions.

Below I have posted some of products name which are playing in current market.
Content Management (CMS), Document Management Software---->
Enterprise Content Management Systems

Alfresco Enterprise (J2EE, open source)
ASG Mobius
Autonomy (Interwoven) ECM
Bitrix Intranet Portal
CORENA (enterprise documentation)
Day Software
Ephesoft (open source document capture)
EMC/Documentum
EVER TEAM (European focused)
eXo ECM (open source)
Clearview ECM (built on SharePoint)
Content Conductor
FileNet  (now IBM)
Hummingbird (now Open Text Connectivity)
Hyland OnBase
IBM Enterprise CMS
Infogrid (open source)
Inmedius (documents, documentation, DITA)
IXOS (OpenText)

KnowledgeTree (open source, GPL)
Microsoft SharePoint ECM
Mobius (now ASG)
Nuxeo Enterprise Platform (open source)
O3 Spaces ECM (Java, DMS, Collaboration)
Objective
OpenText
Oracle UCM (Java, Fusion Middleware)
Perceptive Software (ECM platform, imaging)
pTools ECM
SAPERION  (ECM, DMS, BPM in Berlin)
Snowbound (imaging, file conversions)
Stellent  (now Oracle UCM)
SpringCM (SaaS DMS/ECM)
Vignette ECM (now Open Text)
VYRE - Unify


Document Management Software

Active Innovations - infoRouter
Ademero
Astoria Software
Box.net (SaaS, doc collaboration)
Calenco from NeoDoc (open source documentation management system)
ColumbiaSoft Document Locator
DB Technology - RAS
DocuSign (electronic signatures)
Docuvantage (SaaS)
Ephesoft (open source document capture)
eXo ECM (open source)
Glasscubes (DMS & Collaboration)
Group Drive 
HP TRIM (was Tower Software)
HyperOffice (SaaS)
IBM Connections
iDatix iSynergy (doc, process mgmnt)
ISIS Papyrus (documents, BPM)
Intranet Connections (intranet focused)
KnowledgeTree (open source, GPL)
Laserfiche (DMS, BPM) 

LinearCube (SaaS, based on Alfresco)
LogicalDOC (open source & enterprise)
Microsoft SharePoint Online (SaaS)
Microsoft SharePoint Server (MOSS)
Microsoft SharePoint Services (WSS) (free)
Napersoft (Communications, Compliance)
Nuxeo Open Source Document Management (DMS, DAM)
Objective (DMS and ECM platform)
Oracle UCM (Java, document-centric)
PaperWise (on-premise, .NET)
Perceptive Software (documents, imaging)
RedMap (acquisition, archiving, automation)
SambaJAM (SaaS, based on Alfresco)
SIVECO SIVADOC (Romania)
SpringCM (SaaS DMS/ECM)
Vasont
Xerox DocuShare
Xythos (SaaS/On-premise)


Enterprise Web Content Management Systems

Adobe CQ5 (Java, was Day Software)
Alterian Content Manager (was Morello)
Atex Polopoly (Java, J2EE)
Autonomy WCM  (was Interwoven)
Amaxus Web CMS
Bridgeline iAPPS Content Manager (.NET)
Browser CMS (Java)
Contensis CMS (.NET, Decoupled)
CoreMedia CMS
CrownPeak Web CMS (SaaS, decoupled)
e-Spirit FirstSpirit CMS (German, Java/XML)
Ektron CMS 400 (.NET)
Elcom CommunityManager.NET (WCM, Portal)
EpiServer (.NET)
eZ Publish (OSS, PHP)
Gentics (Austrian, Java, Portal & WCM)
GOSS iCM 
GX Software 
Hannon Hill Cascade Server (Java)
Ingeniux CMS (XML, SaaS option)
Interact Intranet (.NET)
Intranet DASHBOARD (Intra/Extranet, Portal)

Jahia Enterprise Edition (Java)
Liferay EE (Java, Portal, Intranet)
Limelight Networks / Clickability (SaaS)
Lotus Workplace Web CMS (Java)
Magnolia Enterprise (Java)
Microsoft SharePoint WCM (.NET)
Open Text WEM (was Vignette & Nstein)
Open Text WCM (was RedDot)
Oracle / Fatwire Content Server  (Java)
Oracle UCM (Java, Fusion Middlware, was Stellent)
Oracle WebCenter Suite (Java, Portal)
Percussion CM System (was Rhythmyx)
pTools CMS
SDL Web Solutions (was Tridion)
Seamless CMS (.NET)
Sitecore (.NET)
Softeng Portal Builder (SaaS, Spanish)
TERMINALFOUR (Java)
WebSideStory/Visual Sciences
WEDIA CrossMedia (Java, French)


Digital Asset Management (DAM) Software




SMB/Dept. Web Content Management Systems

ABC CMS
Affino
Applaud CMS
Autonome CMS (PHP, Open Source)
Big Medium CMS
Bitrix Site Manager
Bluenog CMS (OSS, based on Hippo)
Camelback liveSite (SaaS)
Composite C1 Web CMS (.NET, Open Source)
Convio
Cookie Jar CMS (Java)
dotCMS (Open Source, Java)
Dynamicweb CMS (.NET, eCommerce Friendly)
Eden Platform from Preation (SEO focused)
Easy CMS
Ego7 (Flash)
EM3 iOn
Emagine CMS
Estrada Onstage 
ExpressionEngine (PHP, proprietary)
eZ Publish (PHP, open source)
FirstSpirit (e-Spirit)
Fluid CMS
Fog Creek - City Desk
Freestyler CMS
GlobalScape
GroupTree (.NET)
Hardcore CMS
Hippo CMS (Java, open source)
Hot Banana CMS (marketing suite) (.NET)
iSite CMS
InfoPark CMS Fiona (WCM, Portal, CRM)
jAPS Portal (Java, GPLv2)
Kentico Web CMS (.NET, COS)



Web Publishing & Content Management for Publishers

Atex Polopoly (Java, J2EE)
Buzzr (SaaS, Drupal derivative)
Campsite (OSS, PHP)
Clickability (SaaS, Pro)
Content DSI WPS (SaaS, directories)
CrowdFusion (SaaS, web/mobile)
Drupal (Open Source, LAMP, Framework)
Escenic (COTS, Java, XML)
EidosMedia Méthode Portal Server (XML, Italy)
eZ Publish (OSS, LAMP)
K4 Publishing System
Magnolia OnAir (for Broadcasters, OSS, Java)
Managing News (Drupal +30 OSS projects)
MediaSpectrum ContentWatch (J2EE, Pro)

OpenPublish (Drupal derivative)
OpenText / Nstein (COS, Pro)
Plone (OSS, Zope)
Pressflow (high performance Drupal)
Pressmart ePortal (SaaS)
Quark Publishing System  
Really Strategies RSuite (XML, based on MarkLogic)
Roxen Editorial Portal (XML, Sweden)
SPIP (GPL Open Source, LAMP)
WoodWing Enterprise (Pro)
ZMags Publishing (Print-to-Digital)


Education Content Management / CMS for Education

Campusuite (SaaS)
Hannon Hill Cascade Server (Java)
Moodle (open source LMS)



Simple Web Content Management Systems

Barebones CMS (PHP)
CMS Made Simple (Open Source, PHP)
DMXReady CMSv2 (ASP 3.0)
Cushy CMS (SaaS, Super Simple)
Digitalus Web CMS (PHP, Zend, Open Source)
Enano CMS/Wiki (PHP, Open Source)
Feed.Us CMS (SaaS, Embeddable)
Hotaru CMS (PHP, Open Source)
iUpdateIt (SaaS w/ JavaScript embed)
IzzyWebsite CMS
Komodo
Marqui CMS
N2 CMS (.NET, Open Source, CMS Framework)
Orbis CMS (PHP, BSD Open Source)
Oxite (.NET)
ProcessWire CMS (PHP, Open Source)
PyroCMS (PHP/CodeIgnitor, Open Source)
QuickelSoft CMS (.NET)

Radiant (Open source - MIT, Ruby)
Refinery CMS (Open source - MIT, Rails)
SiteNOTE (.NET, Freeware)
Subdreamer (PHP)
Surreal CMS (SaaS, Super Simple)
Symphony CMS (PHP, Open Source)
Textpattern (OSS, PHP)
V2 CMS
Web Edition CMS
Webaptive (.NET, developer friendly)
Website Director CMS
Weceem CMS (Groovy/Grails, Open Source)
Xitex WebContent M1
YikeSite (SaaS, Simple)



Hosted (SaaS) Content Management Systems




Open Source Web Content Management Systems

Alfresco Community (J2EE, ECM, WCM)
Apache Lenya
APLAWS+
Autonome CMS (PHP, GPL)
Barebones CMS (PHP, MIT)
Bitweaver CMS (LGPL, PHP)
Bluenog CMS (based on Hippo & JetSpeed)
Bricolage
Campsite (GPL, PHP,web publishing)
CMS Made Simple (PHP)
Composite C1 Web CMS (.NET, dual license)
Digitalus Web CMS (PHP, Zend)
Docebo CMS
dotCMS Open Source (GPL, Java)
DotNetNuke
Drupal
e107 (PHP, GPL)
Enano CMS/Wiki (PHP, GPL)
eXo Web CMS
eZ Publish
Far Cry
Hippo CMS (Java, Apachev2)
Hotaru CMS (PHP, Social Bookmarking, Etc.)
Jahia Community Edition (Java, GPL)
jAPS Portal (Java, GPLv2)
JBoss Nukes
jCore CMS (PHP, GPL, multi-sites)
Jease (Java, GPL, Simpl)
Jetbox CMS
Joomla! (PHP, forked from Mambo)
Kooboo (.NET MVC, Chinese project)
Lenya
Liferay (Java, Portal, Collaboration)
Magnolia
Mambo Server
Midgard Project
MMBase
MODx CMS (PHP/AJAX)
mojoPortal (.NET, WCM, Portal)
Mura CMS (ColdFusion, GPL 2)

ndCMS
N2 CMS (.NET, LGPL, CMS Framework)
OpenCMS
Orbis CMS (PHP, BSD, Simple)
Oxite (.NET)
Papoo CMS
PHPNuke
phpwcms
PHPWebsite
Pimcore CMS (PHP/Zend, BSD)
Pligg
Plone
PortalApp
PostNuke
Pressflow (high performance Drupal)
ProcessWire CMS (PHP, GPLv2)
Radiant (Ruby, MIT, Simple)
Refinery CMS (Rails, MIT, Simple)
Red Hat CCM
SilverStripe (BSD, PHP/LAMP)
Simple Web CMS
Sitellite
SPIP (GPL, LAMP)
Squiz MySource
TikiWiki CMS/Groupware (PHP, LGPL)
TYPO3 (PHP, GLP)
TYPOlight webCMS (PHP, LGPL)
Umbraco
XOOPS
Web Edition CMS (PHP, GPL)
WebGUI
Weceem CMS (Java, Groovy/Grails, Apache)
Xaraya CMS


Micro Content Management Systems, Blogging and Wikis

Acquia Gardens (SaaS Drupal...coming soon.)
AtomSite (OSS, .NET, Blogging)
Bitweaver (OSS, Blogs, Wiki, Forums)
BlogEngine.NET (OSS, .NET)
Blogger.com (Google's SaaS)
Blogtronix (.NET social platform)
dasBlog (.NET, open source)
Drupal (OSS PHP semi-simple sites, portals)
eTouch Samepage Wiki (J2EE/SaaS)
Expression Engine (PHP...semi-simple)
Google Sites (SaaS, simple wikis, sites)
iUpload Personal Publisher
Joomla! (OSS PHP, semi-simple sites, portals)

Movable Type Org(OSS LAMP, blogs, social media)
Movable Type Pro(Perl/PHP blogs, social media)
OpenZine (SaaS, simple blog magazines)
PublicSquare (SaaS, semi-pro)
Screwturn Wiki (.NET)
SquareSpace (SaaS)
Subtext (.NET, open source blogging)
TypePad (Six Apart SaaS)
Viviti (SaaS, simple sites)
Vox (Six Apart, SaaS)
WordPress.com (Automattic SaaS blogs, sites) WordPress.org (Automattic PHP blogs, sites)


Web Analytics, Optimization, Intelligence and Personalization


Cognesia (optimization, personalization)
Lyris HQ
Personize (personalization)
Piwik (open source)
Site Meter
VisiStat (WAM, marketing optimization)
WebTrends
Web CEO
Yahoo! Web Analytics



Social Media Platforms & Social Media Monitoring

Alterian (Techrigy) (Social Monitoring)
Collective Intellect (Social Monitoring)
BlueKiwi (Social Platform + Monitoring)
Elgg (Social Platform, Open Source)
KickApps (SaaS Social Platform)
Microsoft Looking Glass (Social Monitoring)
Networked Insights (Social Monitoring)
Ning (Social Platform)
Radian6 (Social Monitoring)

SAS Social Media Analytics (Social Monitoring)
Scout Labs (Social Monitoring)
Social Engine (Social Platform)
Spiral16 (Social Monitoring)
Sysomos (Social Monitoring)
Visible Technologies (Social Monitoring)
Wool Labs - WebDig (Social Monitoring)


Data Mashing Tools & Platforms




Content Migration Tools




SharePoint Add-ons & Connectors

EntropySoft Connectors
IRISPowerScan (high volume OCR scanning, indexing for SharePoint)
Layer2/WAND Taxonomies (pre-defined SharePoint 2010 taxonomies)

SoftArtisans Silverdust (Blackberry access to SharePoint)



Miscellaneous Platforms

Family CMS (SaaS, religious, family oriented)




WYSIWYG Editors (HTML/XHTML)

DocEditPanel (ASP.NET Ctl)
Ektron (Win32)
Ephox (Plugin or Java)
FCKeditor (DHTML)
FreeTextbox (ASP.NET Ctl)
Hardcore Editor (DHTML)
HTMLArea (DHTML)
InnovaStudio (DHTML)

Loki (DHTML, open source)
pinEdit (DHTML)
Telerik RadEditor (ASP.NET AJAX)
TinyMCE (DHTML)
WebRenderer (Java)
WYMeditor (JavaScript, Simple)
XStandard (Plugin)
YUI Editor (DHTML, open source)


I hope above information very useful for all.Please provide your comment so that I could post some more information about content management solutions.

Friday, July 29, 2011

Migrating the character set

As per requirement of application,We can change character set on existing database.


CSSCAN Utility and CSALTER Script:

It is two stage process: data scanning (csscan) and data conversion (csalter.plb).

The CSSCAN Utility is used to denitrify possible database character set conversion problems and truncation of data. Data scanning identifies the amount of effort required to migrate data into the new character encoding scheme before changing the database character set. This information helps to determine the best approach for converting the database character set.

The CSALTER script is part of the Database Character Set Scanner utility. The CSALTER script is the most straightforward way to migrate a character set, but it can be used only if all of the schema data is a strict subset of the new character set. The new character set is a strict superset of the current character set if:
Process steps

Database Version: Oracle 10g Database
Source Character Set: WE8ISO8859P1
Target Character Set: AL32UTF8

1)Shut down the database,.
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.

2)Take a full database backup:
performed the full database export using Datapump utility (expdp/impdp)

3)Start up the database:
SQL> startup;

4)Run the Database Character Set Scanner (CSSCAN) utility.

This CSSCAN Utility executable is under the $ORACLE_HOME/bin directory.
$ csscan \"sys/password@mydb as sysdba\" full=y
During this activity script asks enter the new database character set name please enter the name

Enter new database character set name: > AL32UTF8

for any help on CSSCAN you can use
$ csscan help=y

Run the CSALTER script.

After Database Character Set Scanning has completed successfully, the database must be opened in restricted mode, because no normal user should allow to access the database during this task is being performed. So you can run the CSALTER script as the SYS user. The location of the CSALTER Script is "$ORACLE_HOME/rdbms/admin/csalter.plb".

Shut Down the Database
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.


Start Up the Database in Restricted Mode.
SQL> startup restrict;

Run the csalter.plb script
SQL> @?/rdbms/admin/csalter.plb

Shut Down the Database
SQL> shutdown immediate;

Start Up the Database
SQL> startup;
SQL>

Make sure the changes:
SQL> SELECT * FROM nls_database_parameters;

How to prevent password expiration for newly created Active Directory users

QUESTION:
When we create a new Active Directory user and browse to it using the "Active 
Directory Users and Computers" console, we can see that the "User Must Change 
Password at Next Logon" is checked (this option is found under the "Account" tab).

How do we setup the resource adapter so that this doesn't happen.
ANSWER:
The way to set expirePassword is to set password.accounts[RESOURCENAME].expire:

  <FieldLoop for='name' in='password.accounts[*].name'>
    <Field>
      <Field name='password.accounts[$(name)].selected'>
        <Expansion>
          <s>true</s>
        </Expansion>
      </Field>
      <Field name='password.accounts[$(name)].expire'>
        <Expansion>
          <s>false</s>
        </Expansion>
      </Field>
    </Field>
  </FieldLoop>

If you know the resource name then you don't need to put it through the loop.

Sun IDM + character unicode issue on Oracle database as a resource

Issue:I hope many people fcaed the issue with chinese character.When we update the chinese character(like 璐英') in Oracle 10 g database as user provisioning on resource,Data are not updated proper format showing chinese character value as a ¿¿ upside-down question marks.If any other applications uses this database records,It is not reflected proper format(chinese character)

I have faced similar type of issue below I am posting solution for this issue.

Solution:
I have created two database in my local machine
case 1) database name localtest has character set value as below

PARAMETER VALUE
NLS_CHARACTERSET WE8MSWIN1252 single byte as in my current database
NLS_NCHAR_CHARACTERSET AL16UTF16

1)created the table
CREATE TABLE TEST2(NAME VARCHAR2(50)); attribute type VARCHAR2

2)Insert One value with chiness character
INSERT INTO TEST2 VALUES ('Cé璐英');

3)check result for this
SELECT * FROM TEST2;

geeting value -- Cé¿¿ upside-down question marks


Case 2). database name localserver has character set value as below

PARAMETER VALUE
NLS_CHARACTERSET AL32UTF8 --- Multibyte character set
NLS_NCHAR_CHARACTERSET AL16UTF16


1)created the table
CREATE TABLE TEST2(NAME NVARCHAR2(50));

2)Insert One value with chiness character
INSERT INTO TEST2 VALUES ('Cé璐英');

3)check result for this
SELECT * FROM TEST2;

geeting value -- Cé璐英 Correct chinese character as insert.
WE8ISO8859P15
 ISO 8859-15 West European

While AL32UTF8
 Unicode 4.0 UTF-8 Universal character set

Database character set (NLS_CHARACTERSET) :- The character encoding scheme used by the database is defined as part of the CREATE DATABASE statement. All SQL CHAR datatype columns (CHAR, CLOB, VARCHAR2, and LONG), including columns in the data dictionary, have their data stored in the database character set. In addition, the choice of database character set determines which characters can name objects in the database.
National character set (NLS_NCHAR_CHARACTERSET):- A national character set is an alternate character set that enables you to store Unicode character data in a database that does not have a Unicode database character set.
NLS_CHARACTERSET              :- Database character set         
NLS_NCHAR_CHARACTERSET :- National character set

1) Below combination uses western European database characterset & AL16UTF16 national character set to store UNICODE data.
It means we can’t store Unicode database directly in CHAR,VARCHR2 data types , We have to Use NCHAR, NVARCHAR2 data types.
NLS_CHARACTERSET               WE8ISO8859P15
NLS_NCHAR_CHARACTERSET         AL16UTF16


2) This is UNICODE database character set use to store multilingual charters.
NLS_CHARACTERSET                      AL32UTF8
NLS_NCHAR_CHARACTERSET         AL16UTF16

AL32UTF8 will support the chinese character as well other languages.

 it is not simple method,  need to do Characterset conversion Migration activity
The easiest way to do the conversion is to export the database, drop the database, recreate it with the new characterset and perform an import.