12 Replies Latest reply: Mar 2, 2009 2:27 AM by 688490 RSS

    Google - Oracle Calendar sync

    ErikP
      Anyone successful in syncing Google and Oracle calendars?
      I have personal events in one (because of clubs I am with) and company events in the other.

      I'm considering doing the following:
      Oracle => Palm
      http://www.oracle.com/technology/products/cs/user_info/ocalendar/sync_client_index.html

      Palm => Google
      http://www.goosync.com/UpgradeDetail.aspx

      But have not tried it yet.

      Erik
        • 1. Re: Google - Oracle Calendar sync
          576896
          You can export Oracle Calendar as an iCal-file.
          That you can import in Google Calendar.

          However, a script doing this for you would be nicer, but i'm not into scripting.
          • 2. Re: Google - Oracle Calendar sync
            159369
            The exporting and importing suggestion is really the only easy way to do it right now. If Oracle Calendar begins supporting caldav in a future version, you should be able to just subscribe to your corporate calendar caldav URL directly from Google Calendar.

            If you are a developer, you could try to write a small program using the Calendar SDK to extract your agenda data into an iCal formatted file (at least I'm pretty sure it can do that). If you make the iCal formatted file web accessible, you can point Google Calendar to the URL and it will automatically download the agenda data into your calendar. You, of course, would want to automate the extraction of your corporate agenda to the file so you wouldn't have to remember to do it yourself.

            I'm not a big user of Google Calendar so I'm basing this suggestion on some basic tests I tried. Also, automating this means you would have to have to include your account password in the program you write (somewhat okay if it is compiled but still a security risk). It also means you would have to update your program any time you changed your password.

            Soo...if you are willing to do a little manual work and not have to write a program, just export the data into iCal format (.ics), copy it to a web accessible area, and set up Google Calendar to always look for it at that URL.
            • 3. Re: Google - Oracle Calendar sync
              622814
              It's not a sync, but there is a very nice easy to configure feed here:

              www.syncml2ical.com

              You need to register your account first. The script for Oracle works something like this:

              http://sync.syncml2ical.com/?serverurl=https://yoursyncmlserver.com/ocst-bin/ocas.fcgi?sub=syncml&user=yourusername&pass=yourpassword&eventsdb=./Calendar/Events?/dr(0,30)
              • 4. Re: Google - Oracle Calendar sync
                580125
                The Google sync tool will push / pull from MS Outlook. I have managed to sync Google and Oracle Calendar by using the Outlook connector.
                • 5. Re: Google - Oracle Calendar sync
                  633439
                  We use the Outlook Connector throughout our organization. I thought that the sync would work, but I haven't been able to get it to. I figured it was because Outlook wasn't actually storing data on the machine. Did you have to do anything special?
                  • 6. Re: Google - Oracle Calendar sync
                    580125
                    The main issues I've had have revolved around using the Oracle calendar (w/connector) as well as the default Outlook calendar. If you set up the connector as the default calendar to show in Outlook (connector install/config final screen) then evrything here has fallen into place. Hope this helps, Joe
                    • 7. Re: Google - Oracle Calendar sync
                      644816
                      Even though I've selected the Two-way option, I've still only managed to sync one way (google cal to outlook 2003) using Google Calendar Sync. Has anyone managed to get it to work both ways?
                      • 8. Re: Google - Oracle Calendar sync
                        653649
                        Hello,

                        I would like to use the outlook connector to sync my oracle and google calendar, please could you describe the proccess in a bit more detail?

                        Thanks
                        • 9. Re: Google - Oracle Calendar sync
                          580125
                          Several months ago I had a user who wanted her Google cal migrated into Oracle. This was my first experience with Google calendar. It was simple enough to create a sample Google cal, download the ics, and import to Oracle. I then experimented with the Google sync tool. The only thing I remember is there was a slight hitch in the way it handled recurrences.

                          Months later, after blowing out my MS Office and reinstalling(2003/2003) with the latest and greatest (both Outlook Con and Google sync tool) I had another user who wished to sync. I can no longer sync a single appointment between the two. I know this worked once because of the content of the appointments on my Google cal (this after not logging in for several months).

                          I don't know which software upgrade killed what should be a routine process. But I thought I would post this, so as not to build up false hope. This is a very low priority in our shop and I won't have time to pursue it.

                          Joe
                          • 10. Re: Google - Oracle Calendar sync
                            654714
                            Could you please enlighten us? I'd love to konw how you got this working. We have Oracle calendar 10.1.2 and I'm using the Oracle connector 1013_07 with Outlook 2003. I get nada on my google calendar.
                            • 11. Re: Google - Oracle Calendar sync
                              633439
                              My OCFO is my default calendar, but I still get nothing when I sync to google. Have you heard of people having issues with this?
                              fran.grabowski@bc.edu
                              • 12. Re: Google - Oracle Calendar sync
                                688490
                                Here's a method that will let you sync Oracle Calendar to Google Calendar + iCal iPhone:

                                http://blog.zenone.org/2009/02/sync-oracle-calendar-to-google-calendar.html