amitscorp
asked on
PeopleSoft as a Central Database
I could not find an appropriate section to pose a question regarding PeopleSoft systems. However, my question is more general.
There are a lot of home grown applications (some in excel, some in Leap etc..) in our department. Currently these systems do not talk to each other, and thus there are manual inputs into these systems on a daily basis. We are now trying to consolidate all of these systems. Our parent company has PeopleSoft as the Primary HRMS system, however PeopleSoft is not deployed in our little site. Some of the data is manually uploaded into PeopleSoft with the help from the parent company.
Now, deploying PeopleSoft fully in our site can be a long term project and would cost quite a bit for the company. What we are looking for is a solution wherein we would still be able to upload the information into PeopleSoft and perhaps provide an interface that is friendly to use for Data reporting, creating standard reports etc.
Does anyone out there have something in mind how this can be achieved?
There are a lot of home grown applications (some in excel, some in Leap etc..) in our department. Currently these systems do not talk to each other, and thus there are manual inputs into these systems on a daily basis. We are now trying to consolidate all of these systems. Our parent company has PeopleSoft as the Primary HRMS system, however PeopleSoft is not deployed in our little site. Some of the data is manually uploaded into PeopleSoft with the help from the parent company.
Now, deploying PeopleSoft fully in our site can be a long term project and would cost quite a bit for the company. What we are looking for is a solution wherein we would still be able to upload the information into PeopleSoft and perhaps provide an interface that is friendly to use for Data reporting, creating standard reports etc.
Does anyone out there have something in mind how this can be achieved?
ASKER
Bill,
All of your questions are valid. Here are the answers:
I am really looking to replace all of the existing files with a single unified system, if at all possible.
Yes, the final goal is to upload the data into PS and pull internal reports.
As regards, Budget I do not have the exact amount but I guess if I can show a valid need for purchasing a software that will replace all of the systems then it definitely will be entertained.
Yes, I can expect reasonable support from the parent company.
THe data is currently scattered in excel files, some sort of Leap system...but I'd say mostly excel.
Thanks for taking the time, and looking forward to your suggestions.
Regards,
Amit
All of your questions are valid. Here are the answers:
I am really looking to replace all of the existing files with a single unified system, if at all possible.
Yes, the final goal is to upload the data into PS and pull internal reports.
As regards, Budget I do not have the exact amount but I guess if I can show a valid need for purchasing a software that will replace all of the systems then it definitely will be entertained.
Yes, I can expect reasonable support from the parent company.
THe data is currently scattered in excel files, some sort of Leap system...but I'd say mostly excel.
Thanks for taking the time, and looking forward to your suggestions.
Regards,
Amit
First of all you should not attempt to connect two pieces of software.
Connect the data!
Peoplesoft HRMS will prolly have an import function. And your system will have an export function. plain text (ASCII), csv etc. Use that.
Other way is to connect the databases. You can directly connect em with triggers and stuff or do it by batch. Create an xml file to import stuff batchwise.
Maybe the HRMS will have an xml function.. or some edi function.
Basically just keep in mind you do not want to connect the software you want to get the data in one place.
Hope that helps :)
Connect the data!
Peoplesoft HRMS will prolly have an import function. And your system will have an export function. plain text (ASCII), csv etc. Use that.
Other way is to connect the databases. You can directly connect em with triggers and stuff or do it by batch. Create an xml file to import stuff batchwise.
Maybe the HRMS will have an xml function.. or some edi function.
Basically just keep in mind you do not want to connect the software you want to get the data in one place.
Hope that helps :)
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Bill,
Perfect!! This is a great start...looks like you have experience from similar projects.
The data I am dealing with is mostly HR, viz Payroll, Comp, Employee data etc. Do you have software packages in mind that would be applicable for such data.
Also, I was wondering what it takes to deploy PeopleSoft for the subsidiary when the parent company has PeopleSoft fully functional?
Your help is greatly appreaciated.
Thanks,
Amit
Perfect!! This is a great start...looks like you have experience from similar projects.
The data I am dealing with is mostly HR, viz Payroll, Comp, Employee data etc. Do you have software packages in mind that would be applicable for such data.
Also, I was wondering what it takes to deploy PeopleSoft for the subsidiary when the parent company has PeopleSoft fully functional?
Your help is greatly appreaciated.
Thanks,
Amit
I'm not an HR person, but some of the ones I've heard of...
Great Plains used to be pretty cool, but has been bought by Microsoft. No idea if it's still good.
MAS90/MAS200 is popular with the bean counters, and has some decent reporting and import/export capabilities.
I used to use Solomon back in the old days before it got bought by Microsoft. It was fairly powerful, but not exactly friendly. Again, no idea what has happened to it since Microsoft took over. There's Abra... now that I think about it, pretty much everything I can think of off hand is owned by either Microsoft or Sage/Best.
As for deploying PeopleSoft, that probably depends on your relationship to your parent company. PeopleSoft's licensing is just plain weird. They charge fees based on how successful the company is, where you're located, what color socks you're wearing, etc, but not based on the number of users. So it's theoretically possible that they could just add you in to their existing system.
One thing to bear in mind: Oracle has bought PeopleSoft, and has in the past publicly stated that their intention was to eliminate the PeopleSoft product. There are sure to be significant changes at PeopleSoft in the near future. That could mean this is a good time to switch your company over to PS, or it's possible your parent company is even now considering options wrt their HR software.
Great Plains used to be pretty cool, but has been bought by Microsoft. No idea if it's still good.
MAS90/MAS200 is popular with the bean counters, and has some decent reporting and import/export capabilities.
I used to use Solomon back in the old days before it got bought by Microsoft. It was fairly powerful, but not exactly friendly. Again, no idea what has happened to it since Microsoft took over. There's Abra... now that I think about it, pretty much everything I can think of off hand is owned by either Microsoft or Sage/Best.
As for deploying PeopleSoft, that probably depends on your relationship to your parent company. PeopleSoft's licensing is just plain weird. They charge fees based on how successful the company is, where you're located, what color socks you're wearing, etc, but not based on the number of users. So it's theoretically possible that they could just add you in to their existing system.
One thing to bear in mind: Oracle has bought PeopleSoft, and has in the past publicly stated that their intention was to eliminate the PeopleSoft product. There are sure to be significant changes at PeopleSoft in the near future. That could mean this is a good time to switch your company over to PS, or it's possible your parent company is even now considering options wrt their HR software.
I think the comments posted have value, and would prefer to see it PAQed rather than deleted.
ASKER
Thanks Bill...Just missed out on going back and updating my response on the forum.
I'd like to get some more information.
Do you hope to replace all of the existing files with a single unified system, or are you just looking for a more efficient way to integrate the data from the files you have? Is your final goal to upload your data into PeopleSoft and also be able to pull your own internal reports from that same data? How much of a budget do you have? Can you count on your parent company cooperating in this process, or are you mostly on your own? What sort of data do you upload currently? Are you just sending them a file that they manually process, or is there some sort of automated import on their end?