RESTful web services application to send employee record updates from Ultipro to SABA daily

Hello, All.
I am new to web services and have been task to convert several of our current system interfaces to web services. I want to thank you in advanced for any information you can share to help me better understand this new area for me.  

My main focus right now is to develop a web service that will update employee information from UltiPro to SABA on a daily basis.

I have been able to access the exposed UltiPro web services and query basic information using C#.

1. First question: One area I really need some help with is identifying and querying by unique field.  From my understanding they have user social security, employee Identifier, company code may be used to identify employee if the other fields produce multiple employees.  However, I am use to using databases and not sure how to identify the correct field(s) that serve as the "key" in this configuration.

2. If you have any experience on the SABA side with web services, Could you share information with me on taking a record from one system and updating those updated employee files on the SABA side

3. Also, please share the environment that you have found to be the best to develop solution as well as deployed configuration success.  I will need to have this web service run daily, what is the best area to deploy and configure a web service.

Also, I wasn't sure if it would be helpful to attach my working temporary application.  If anyone wishes to see this prototype application I will be happy to send to you.


Thank you so very much, Karen
krg2Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

käµfm³d 👽Commented:
I can only answer 1 & 3.

1. You can only use whatever interface the service provides. The service owner's documentation should specify what constitutes a unique key. In the worst case, you can download the entire list from the service--assuming it isn't too large--and do the searching on your side.

3. A web service doesn't run on a schedule--it runs when called. You would need some other process set up on a scheduler in order to invoke your web service on a schedule. This could be a console application put into the Task Scheduler, or you could use a scheduling library like Quart.net.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
krg2Author Commented:
Hello käµfm³d!

Thank you so very much for your input and I appreciate your detailed answers which confirms some of my ideas.

I will wait a little bit longer to see if I can get some direction on the 2nd question about SABA.

Thanks again,
Karen
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
C#

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.