Todd, That really depends on what tools you have at your disposal and the talent in your team. For me, we have the Microsoft System Center Suite. Using Orchestrator and a couple integration packs (Remedy, SharePoint), we would create a runbook to monitor for the specific requests to be populated into the SharePoint calendar. When found, use the SharePoint Integration Pack to insert the data from the Remedy request into the SharePoint calendar. It would be a good idea to do some validation to prevent duplicate entries etc.
Barring that, you could write a powershell script that essentially does the same thing that executes a sql query against the remedy database, then leverage SharePoint web services to do the insert into the calendar. Execute the script via a scheduled task to run on the desired interval. If you are looking for a "PHD" (Push Here Dummy) solution, I'm sure there are several vendors that will respond to your question and gladly take copious amounts from your wallet. Above all you have to factor in whether this is a one-off problem or a more common occurrence, then temper your choice of solution. Jim Coryat Micron Technology, Inc. From: Arner, Todd [mailto:[email protected]] Sent: Thursday, September 04, 2014 6:19 AM Subject: Importing Data from Remedy to SharePoint Caslendar ** I have a general question on importing data from a Remedy form into a SharePoint Calendar. We have a custom built form in Remedy that we use to list the implementation schedule. We are looking to export this date out of Remedy and into a SharePoint Calendar. Has anyone done this? Is there a product we can purchase to do this or is it something we need to build in house. Any insight is greatly appreciated. I'm not sure where to go with this one. Thanks, Todd Arner Great Lakes ________________________________ The information contained in this communication may be confidential, is intended only for the use of the recipient(s) named above, and may be protected under state or federal law. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution, or copying of this communication, or any of its contents, is strictly prohibited. If you have received this communication in error, please forward the communication to [email protected]<mailto:[email protected]> immediately and destroy or delete the original message and any copy of it from your computer system. If you have any questions concerning this message, please contact the sender. _ARSlist: "Where the Answers Are" and have been for 20 years_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
