Raising SaaS OnBoarding Solution and Dominant PeopleSoft HR

2010 seems to mark a new begining in both the IT Services and F1 Racing. Cool,.. we are awaiting the growth in SaaS, SOA,… and some great adrenaline rush as Schumacher returns.. For People who still believe that PeopleSoft is leading the HR Services market, Lets remind them of the advent of Kronos Workforce (Application Service Provider), KMS XpressHR (Software as a Service – SaaS Solution), Open Text Recruiting Management Solution for Microsoft Sharepoint 10.0 driven by the Enterprise Content Management Solution like Livelink and Document Center respectively. The Clientele are really happy to spend for what they use unlike the age old model of fixed pricing.

Let’s see how KMS OnBoarding XpressHR SaaS Solution attracts the clientele with their functions when compared to Peoplesoft,

• In PeopleSoft, the SSN entered while adding a new person to the system is not validated or verified with the Department of Homeland Security or Social Security Administration(SSA). This had enabled Clientele to incorporate the XpressHR product for onboarding which constitutes the e-Verify Functionality.
• In PeopleSoft, the unavailability of the features like e-Signature & Digital content management in HR had enabled XpressHR to provide 100% Compliance with the State & Federal data related to the pre-hire process within an organization.
• SaaS based Onboarding Process & Document Center Model would enable clientele to leverage the increased ROI.
• Implementation effort seems to be less with the use of web services.

It’s these few aspects which drive the present day software investments, As posted in Service Oriented Computing Platform for Shared Services Model , the service providers whose verticle solutions(XpressHR) which are built on horizontal solutions (ECM) are undoubtedly growing 

Service Oriented Computing Platform for Shared Services Model

It is the need of the hour for business entities to revisit their growth plans and to perform consistent checks on their performance and operational utilization. One of the driving factor for the transformation of Application Service Providers (http://blogs.hexaware.com/pitstop/application-service-provider-vs-software-as-a-service-asp-vs-saas.html )to Software as a service is the change in the Information Technology Trends.

 Human Computer Interaction and Interoperable applications seems to be the cloud where the future software investments would be. Let’s look into the evolving service oriented computing platform which answers a lot of the present day business needs.

The Product based companies were quick to incorporate the service orientation in their product designs by mostly following the agile software development methodology whereas the Service based companies were quick to incorporate the shared resource pool to evolve the Shared Services Support.

Initially, the shared services model was spotted within organizations as specialized groups of system and vendor specific administrators and later evolved as ESSA (http://www.hexaware.com/shared-services.htm). The proposed service oriented computing platform for such shared services model would further enhance the customer satisfaction as the service design principles are followed.

Goin by the tag “If resources are not retainable, Let’s retain their knowledge within the organization” – the service oriented computing platform goes one step further from the traditional vertical solutions(CRM,TAM,.) by providing an SOA based solution utilizing the present day horizontal solutions(Livelink ECM ). This Open technology solution is vendor independant and can accomodate the existing applications of Oracle(Peoplesoft, Siebel), Microsoft(sharepoint),SAP,Kronos Workforce Timekeeper,.. by establishing a meta data driven knowledge solution for the shared services resource pool to work on.

Few Key advantages of this service oriented solution for the shared services model are

a.Reusabilty – the reduntant support (technical/Functional) effort is minimized.

b. Service Governance

c. Discoverability

d. Less Time consumption in performing a support activity

e. Knowledge Service Composition – enabling the maintenance of organization wide service data irrespective of their source department or technology.

Like the Peoplesoft Person Model which was based out of SOA, the service oriented solution design for the shared services model would make a huge difference among the corporate cube warriors. Let’s wait for more such innovative solutions to surface soon.

New Mile Stone in Workforce Modelling and Intelligence – Orgplus

It was the last quarter of 2007 when we had a discussion on the workforce modelling and intelligence(refer -”workforce modelling and intelligence” post) in our pitstop. Now, the news is – Orgplus enterprise is named as the top HR product of the year 2008.


Yes,.. In a latest news release by pressreleasepoint, the author states that ““OrgPlus allows managers to easily visualize and understand their talent data, and if an organization is growing, reorganizing or merging, OrgPlus rapidly models these changes using accurate financial, workforce, and budget data so HR, finance and executive teams can make better decisions to impact overall corporate objectives.”

The Integration between the PeopleSoft HCM 9.0 and Orgplus was much awaited to be validated by Oracle and now Orgplus had recieved the integration validation. In short, the integration revolution within the HR IT Products seems to win the race.The importance of such integrations were realised by companies who concentrated on their ROI few years back and I would suggest them even in our present financial crisis term. 

Enterprise Content Management – Livelink Vs SharePoint

Do you feel that the growth of an organization is directly proportional to the content mangement within the organization ? or vice versa? Let’s look into one of the driving force behind a companies growth – It’s the Enterprise Content Management. ’Collaboration’, ‘Goals’, ‘Processes’, Business Data Analysis are the words frequently uttered across; when a company revisits its own growth.

The ECM suites provides a better way to organize, reuse and share data across the organization. To name a few, Livelink ECM Suite and Microsoft SharePoint provides an interactive space for document management, version management, auditing, business workflows, business intelligence and many other interesting search features with a user friendly – ‘web site’ style application.And also Microsoft’s BDC and Web Part technologies plays a vital role in third party integrations.(the details of which can be seen in our future posts)

By now,one can define in simple terms that a place where documents are managed can be termed as Enterprise Content Management Suites.In reality, the ROI’s are too high for organizations that have implemented SharePoint or Livelink. Livelink goes one step further by handling the retention management process for documents and incorporating a seemless workflow approval chain along the organization tree. This enables an organization to setup the time period for which a document can be accessible and then purged. In comparision, Livelink seems to be DoD certified and SharePoint may be in the process of getting one…

AdventureWorks 2000 and SQL Server 2005

Wow !!! It was Lewis Hamilton in India – On hearing the news I almost thought he was in india for the inauguration of our formula one circuit at Delhi or Hyderabad. But later heard that it was for a commercial deal. Ok Friends, Here I am today trying to explain some of the activities that needs to be performed for attaching the AdventureWorks2000 database to SQL Server 2005.

What is AdventureWorks Database? – Microsoft provides a sample database for demonstration of various functional as well as technical aspects of a business need. An excerpt from microsoft website reads ‘The purpose of AdventureWorks Databases is to demonstrate best practices for designing an integrated enterprise-class schema, and provide a sample database for that schema’. This database is not automatically installed with SQL Server Express.

Now, having known little about what AdventureWorks is, let us get into the details of downloading the database and attaching it to the SQL Server 2005.

By accessing the microsoft download center, download Adventure Works Database 2000.msi and install.Once installed, the file AdventureWorks2000_Data.mdf gets loaded into the specific MSSQL folder within the program files whose path could always be found by a windows search. Having performed this activity, one could follow the procedure present in microsoft’s msdn page. The very first issue when executing the command SQLCMD -S (local)\sqlexpress -E in the Visual Studio 2008 command prompt is unable to remote in to the server error. Inorder to enable the remote connectivity, we need to perform the setup in SQL Server 2005 Surface Area Configuration. After the surface area configurations for services and connections are setup with the help of microsoft’s support, we would be able to attach the Adventureworks 2000 database for our testing and learning process. And always the best way to test the above activity is to verify whether the database is attached or not.

For all the people who are new to MSSQL, Hope this gives you an heads up on what AdventureWorks 2000 is ? and how it could be installed in SQL Server 2005 ?.

Read More: SQL Server 2005

Part II – DBA Refresher for Peoplesoft Database Cloning

Please read the Instant Peoplesoft Cloning Refresher Kit before continuing in this post,

Take care to remove the reuse word in the create control file statement and replace it with SET

Once the Control file is created

alter database open resetlogs

If you encounter problems,

login to command prompt,

sqlplus /nolog
connect sys/manager as sysdba
shutdown immediate
startup
exit

select * from psdbowner;

update PSDBOWNER SET DBNAME = ‘destination db name’

create user sysadm identified by <password> default tablespace <tablespacename> temporary tablespace <tablespacename>

Create user PS identified by <password> default tablespace <tablespacename> temporary tablespace <tablespacename>

Create user PEOPLE identified by <password> default tablespace <tablespacename> temporary tablespace <tablespacename>

Grant connect, resource, dba to sysadm

Grant connect, resource to ps

Grant create session to people

And after revisiting all the above points, you would be able to access application designer after configurations in configuration manager.

Read About: DBA Refresher