SQLAuthority News – Download Whitepaper Using SharePoint List Data in PowerPivot

One of the many features of Microsoft SQL Server PowerPivot is the range of data sources that can be used to import data. Anything, from Microsoft SQL Server relational databases, Oracle databases, and Microsoft Access databases, to text documents, can be used as data sources in PowerPivot. In this paper, I explain one of the new and upcoming data sources that people are excited about – SharePoint list data in the form of Atom feeds. This white paper goes on to explain the different ways you can import SharePoint list data into PowerPivot, what types of lists are supported, various components that need to be installed to use this feature, and where to get those components.

Download and read this whitepaper.

Note: Abstract is taken from MSDN

Reference: Pinal Dave (https://blog.sqlauthority.com)

, ,
Previous Post
SQL SERVER – Selecting Domain from Email Address
Next Post
SQLAuthority News – Job Interviewing the Right Way (and for the Right Reasons) – Guest Post by Feodor Georgiev

Related Posts

2 Comments. Leave new

  • Ashfaq Parkar
    June 21, 2011 8:17 pm

    1)
    CREATE NONCLUSTERED INDEX [idx_UnivStock_S_01] ON [vaapps].[tVehicle]
    (
    [COMPANYID] ASC,
    [IsDutiable] ASC,
    [IsAvailableForSale] ASC,
    [IsSold] ASC,
    [isinvoiced] ASC,
    [YearModel] ASC,
    [VehicleID] ASC
    ) WITH (SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF) ON [PRIMARY]

    2)
    CREATE NONCLUSTERED INDEX [idx_UnivStock_S_02] ON [vaapps].[tVehicle]
    (
    [OwnershipLocationID] ASC,
    [COMPANYID] ASC,
    [IsDutiable] ASC,
    [IsAvailableForSale] ASC,
    [IsSold] ASC,
    [isinvoiced] ASC,
    [YearModel] ASC
    ) WITH (SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF) ON [PRIMARY]
    go

    3)
    CREATE NONCLUSTERED INDEX [idx_UnivStock_S_03] ON [vaapps].[tVehicle]
    (
    [COMPANYID] ASC,
    [IsDutiable] ASC,
    [IsAvailableForSale] ASC,
    [IsSold] ASC,
    [isinvoiced] ASC,
    [YearModel] ASC,
    [VehicleID] ASC,
    [OwnershipLocationID] ASC,
    [ModelID] ASC,
    [BrandID] ASC,
    [ProductID] ASC,
    [ModelGrade] ASC,
    [Brand] ASC,
    [Product] ASC,
    [Status] ASC
    )
    INCLUDE
    (
    [SupplierModelCode],
    [CurrentLocationID],
    [ShipmentID],
    [IsRequested],
    [IsDamaged],
    [ColourCode]
    ) WITH (SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF) ON [PRIMARY]

    1) Can sombody tell me what is the difference between above 3 index (script) ?
    2) if i create index based on #3 will #1 and #2 be convered in #3? if yes the how ? if not then how. pls. explain as i want to learn some more on index.

    regards
    Ashfaq Parkar

    Reply
  • thanks for information.. I downloaded the Whitepaper Using SharePoint List Data in PowerPivot.

    It save my time.

    Thank you

    Reply

Leave a Reply

Menu