Connect to Azure table storage (data mart)

  1. Connect to the data mart.
  2. Click Get Data > More.
  1. Click Azure > Azure Table Storage. Click Connect.
  1. Enter the Azure Table storage URL and Access Key.

  1. In the Navigator select Booking, BookingAttendees and BookingItems tables then click Transform Data.
  1. Select the Booking table from the left sidebar.
  1. Click the Edit properties button in the Content column. Ensure all columns are selected then deselect (untick) Use original column name as prefix and click OK.
  1. Select the desired column by clicking the column header, then click Data type drop-down menu to select the appropriate data type for the column (see table below for appropriate data types).

    Booking Data type
    BookedByUserId Whole Number
    BookingCreateDate Date/Time
    BookingId Whole Number
    Capacity Whole Number
    FloorNo Whole Number
    HostUserId Whole Number
    IsDeleted True/False (logical)
    IsPrivateMeeting True/False
    LocationId Whole Number
    NumberOfAttendees Whole Number
    RecurrenceId Whole Number
    RequesterUserId Whole Number
    RoomId Whole Number
    ScheduledEndUtc Date/Time
    ScheduledStartUtc Date/Time
    WasBumped True/False
  1. Select the BookingAttendees table from the left sidebar.
  1. Repeat steps 7 and 8. The data types for BookingAttendees are shown in the table below.
    BookingAttendees Data type
    BookingId Whole Number
    IsInternal True/False
    UserId Whole Number
  1. Select the BookingItems table from the left sidebar.
  1. Repeat steps 7 and 8. The data types for BookingItems are shown in the table below.
    BookingItems Data type
    BookingId Whole Number
    Quantity Whole Number
    ScheduledEndUtc Date/Time
    ScheduledStartUtc Date/Time
  1. When finished, click Close & Apply button on the ribbon.
  1. Your query changes will now be applied and data will be downloaded locally for reporting.

Once loaded, check and edit the relationships between tables as described in the next section.

Feedback

Was this helpful?

Yes No
You indicated this topic was not helpful to you ...
Could you please leave a comment telling us why? Thank you!
Thanks for your feedback.

Post your comment on this topic.

Please do not use this for support questions.
Condeco Support

Post Comment