MS SQL 2012 to Exchange 2010 Public Calendar Add/Update/Delete

Κλειστό Αναρτήθηκε Πριν 6 χρόνια Πληρώθηκε κατά την παράδοση
Κλειστό Πληρώθηκε κατά την παράδοση

[login to view URL]

We use a database in our HR system for employees to request Paid Time Off (PTO). We would like to take the employee's name, pto date and description of PTO and have it populate a public folder calendar by creating, updating or deleting a calendar entry based off the SQL database.

My thoughts would be a trigger.. new record creates calendar event. Change of PTO hours requested would change PTO description. (Currently employees can request Unpaid time, 4 hours time or 8 hours time so the description of the PTO would be JANE DOE - 4 HOURS or if changed JANE DOE - 8 hours and the calendar date/time would just be an all day event). FInally if the PTO is canceled then the calendar entry it removed.

Right now to track the information is just a SSRS report.

Thanks for looking and your proposal. Will consider budget and experience, also willing to work with freelancer if project goes off track a bit. Willing to pay 20% at beginning and 80% at completion.

Προγραμματισμός Βάσης Δεδομένων Microsoft Exchange Microsoft SQL Server SQL

Ταυτότητα Εργασίας: #15990787

Σχετικά με την εργασία

9 προτάσεις Απομακρυσμένη εργασία Ενεργό Πριν 6 χρόνια

9 freelancers κάνουν προσφορές κατά μέσο όρο $180 για αυτή τη δουλειά

SergioAlfaroV

I am a MCSA SQL Server 2014 certified professional, with more than 10 years of experience in SQL related projects and tasks. My approach would be to use INSERT/UPDATE/DELETE triggers that call xp_sql2exchange Extended Περισσότερα

$200 USD σε 3 μέρες
(22 Αξιολογήσεις)
5.7
sreenivas2903

I have made changes like this earlier , if we both will have discussion and freeze the requirement. I will be able to provide the results before deadline.I have bid for small amount for getting an oppurtunity . Hope d Περισσότερα

$133 USD σε 4 μέρες
(17 Αξιολογήσεις)
4.3
khannanav

We are a team of Database experts with more than 12 years of rich experience on Database management, programming, modelling, applications. FullStack: JAVA, Python, Golang, JavaScript, Java, R, Hadoop, Kafka Databa Περισσότερα

$222 USD σε 3 μέρες
(7 Αξιολογήσεις)
3.8
symaticssolution

Dear Hiring Manager! As per your job post I got your point and somehow I agree with your trigger solution but there are other options too. We can have brief discussion over it. I have seen article too I know it make Περισσότερα

$277 USD σε 3 μέρες
(1 Κριτική)
3.2
vw7914687vw

A proposal has not yet been provided

$222 USD σε 5 μέρες
(0 Αξιολογήσεις)
0.0
majumdergoutam8

Day 1: Requirement understanding and coding Day 2: Fine tuning and submission. Although I am new here in freelancer. I have in depth understanding of databases and I handle data in TBs. You can give me a shot. :)

$111 USD σε 2 μέρες
(0 Αξιολογήσεις)
0.0