Data Warehousing at OpenWorld 2010 - How to get organized

The OpenWorld site has a complete list of dates and times for all the data warehouse presentations, hands-on labs and customer panels scheduled for this year's conference. You can see the complete schedule by clicking here: http://www.eventreg.com/cc250/main.jsp.

To help you get started on planning which sessions to attend I have created an online calendar which lists all the relevant the data warehouse presentations, hands-on labs and customer panels. Depending on your calendar software, you can:

  • Subscribe directly to my online calendars (Google Calendar or Apple iCal) and refresh it on a regular basis to receive updates/changes to the schedules
  • View the calendar (iCal or Google) via the web
  • Download a calendar file (.ics) and create a new local/offline calendar within your own 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 listed 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 data warehousing "OpenWorld" 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: webcal://ical.me.com/keith_laker/OpenWorld.ics

This will add a new calendar to the Subscriptions node in iCal. 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: http://ical.me.com/keith_laker/OpenWorld

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, see here: https://files.me.com/keith_laker/zd0e0h. 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

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:

http://www.google.com/calendar/ical/53vjh6vfu9fjcr74vn8rsmlkuk%40group.calendar.google.com/public/basic.ics

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:

http://www.google.com/calendar/feeds/53vjh6vfu9fjcr74vn8rsmlkuk%40group.calendar.google.com/public/basic

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
  • Sunbird

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 calendar use the following steps:

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: https://files.me.com/keith_laker/zd0e0h. 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 "OpenWorld" calendar with your 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.


Comments:

Post a Comment:
Comments are closed for this entry.
About

The data warehouse insider is written by the Oracle product management team and sheds lights on all thing data warehousing and big data.

Search

Archives
« April 2014
SunMonTueWedThuFriSat
  
2
4
5
6
7
8
9
10
11
12
13
14
16
18
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today