Data Warehousing @ OpenWorld 2009 - How to get organized
By KLaker on Sep 01, 2009
The OpenWorld site now has a complete list of dates and times for all the data warehouse presentations scheduled for this year's conference. You can see the complete schedule here.
To help our data warehouse customers, partners and Oracle employees get started on planning which sessions they would like to attend we have created an online calendar for the data warehouse presentations. In addition to this we will be creating a small booklet that you will be able to download and give to customers. This will provide a simplified calendar of events and information about the data warehouse demo pods that will be part of the demo grounds. The booklet will be ready for next month's newsletter.
Depending on your calendar software, you can subscribe directly to this new calendar and refresh it on a regular basis to receive updates/changes to the schedules or alternatively download a stand-alone calendar file and simply add this as a new local/offline calendar using your local calendar software. Once you have subscribed to, or added, this calendar to your local calendar application you can then synchronize the events with your PDA, iPhone, iPod, mobile phone etc. All the times for each presentation have been entered in Pacific Time so you will need to enable time zone support within your calendar and PDA/iPhone/iPod/mobile phone to see the events at the correct local Pacific Time when you arrive in San Francisco. At the moment the master calendar in iCal looks like this:
Here are the some options for linking this master calendar to your own calendar software:
1) If you are using Apple iCal
Subscribing to a live calendar
This is the best way to ensure your calendar is as up to date as possible. It is suitable for anyone who plans to synchronize this calendar with an iPhone, iPod, PDA or mobile phone calendar. You can subscribe to the "DW OpenWorld 2009" calendar using the standard features in Apple iCal. In the panel showing all your calendars simply click on a blank area and then select the option to "Subscribe". The URL for the calendar is:
This will add a new calendar to your Subscriptions node. All the events listed in this calendar are set for US Pacific time zone which means to view the events at the correct scheduled time you will need to change your time zone to US Pacific for both iCal (Preferences->Advanced-Turn On Time Zone Support) and in the Apple System Preferences under Date & Time. To see changes and updates to this calendar you will need to use the "refresh" option.
Using the Web-based Calendar Viewer
This is the ideal solution if you plan to use wifi access during the conference since you do not need to download anything or synchronize this calendar with any other devices.
You can view this calendar online using any web browser using the following URL:
This view defaults to US Pacific time since it is controlled by my master calendar. As we make changes to add additional presentations or change the date/time of a presentation to reflect changes made by the OpenWorld team these will be automatically published to this calendar.
Adding a stand-alone/disconnected Calendar
If you want to create a stand-alone calendar that is not linked to the master calendar there is an option to download the associated .ics file for this calendar using the web-based calendar view. Look for the "download" link on the left side of the web page. The .ics file can be manually added to Apple iCal or any other .ics compatible calendar software. Obviously, changes made to the master calendar will not be pushed through to the stand-alone/disconnected calendar but you can simply download an updated .ics file form the web calendar view as required.
2) If you are using Google Calendar
For customers, partners and employees who are already using Google calendar the DW OpenWorld 2009 calendar can be added as a new URL which will then appear in the "Other Calendars" panel, or it can be added as a local calendar to the "My Calendars" panel.
To subscribe to this new calendar using your own Google calendar account. Simply use the "Add by URL" option and set the public calendar address to:
You can also use this Google .ics file to add a calendar to Sunbird/Lightning or any other calendar software that supports the .ics format.
Google also provides an XML feed for integration with other calendar applications and the XML data feed is here:
3) If you are using Mozilla Sunbird/Lightning
Lightning is a Thunderbird plug-in version of Sunbird. Both these products can be downloaded from the Mozilla home page:
- Lightning for Thunderbird
Before you add the DW OpenWorld 2009 calendar to either Lightning or Sunbird I would recommend first setting the correct time zone in the application (for Sunbird useTools->OptionsTimeZone, for Lightning use Preferences->Lightning->Time zone) then restart the application to update this setting.
To subscribe to the DW OpenWorld 2009 calendar use the following steps:
- File->New Calendar
- Select "On the Network"
- Select iCalendar (ICS)
- Set the location to one of the following:
- If you want to link to the Apple iCal calendar use this URL:
- If you want to link to the Google Calendar use this URL:
- Set the name to something like "DW OpenWorld 2009"
- Set the color to RED
This will create a linked calendar and any changes or updates made to the master calendar by the DW PM team will be shown when/if you reload the remote calendar.
Adding a stand-alone/disconnected Calendar
If you want to create a stand-alone calendar that is not linked to the master calendar there is an option to download the associated .ics file for this calendar using the web-based calendar view, see here. Look for the "download" link on the left side of the web page. The .ics file can be manually added to Apple iCal. Obviously, changes made to the master calendar will not be pushed through to the stand-alone/disconnected calendar
4) Enabling Time zone support for iPhone/iPod Touch
Please note if you want to synchronize the "DW OpenWorld 2009" calendar with you iPhone/iPod you need to make sure the feature to manage time zones is correctly set. There are two settings for controlling time zone support. In the settings screen, first select "Mail, Contacts, Calendars" and turn time zone support off for calendars. Secondly, under the General settings select "Date & Time" and set the time zone to either "automatic" if you are using an iPhone or manually select the required local time zone if you are using an iPod Touch. This should ensure that if you set the time zone to US Pacific all the OpenWorld events will be shown as starting at the correct local time.
I hope this is useful and if you have any questions just let me know.