Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Can Kettle support SQL SERVER 2005 ANALYSIS SERVICES

  1. #1
    anderson916 Guest

    Default Can Kettle support SQL SERVER 2005 ANALYSIS SERVICES

    Hi,all

    can Kettle support SQL SERVER 2005 ANALYSIS SERVICES? can kettle deal
    with dimensions of SQLSERVER 2005 AS?

    Any information will be appreciated!
    Thanks.


    --~--~---------~--~----~------------~-------~--~----~
    You received this message because you are subscribed to the Google Groups "kettle-developers" group.
    To post to this group, send email to kettle-developers (AT) googlegroups (DOT) com
    To unsubscribe from this group, send email to kettle-developers-unsubscribe (AT) g...oups (DOT) com
    For more options, visit this group at http://groups.google.com/group/kettle-developers?hl=en
    -~----------~----~----~----~------~----~------~--~---

  2. #2
    Jens Bleuel Guest

    Default Re: Can Kettle support SQL SERVER 2005 ANALYSIS SERVICES

    Some time ago I looked at it and when I remember it right the dimensions
    are stores in normal tables (somewhere with a special naming syntax), so
    you should have access to them.

    Hope that helps,
    Jens

    anderson916 schrieb:
    > Hi,all
    >
    > can Kettle support SQL SERVER 2005 ANALYSIS SERVICES? can kettle deal
    > with dimensions of SQLSERVER 2005 AS?
    >
    > Any information will be appreciated!
    > Thanks.
    >
    >
    > >

    >


    --~--~---------~--~----~------------~-------~--~----~
    You received this message because you are subscribed to the Google Groups "kettle-developers" group.
    To post to this group, send email to kettle-developers (AT) googlegroups (DOT) com
    To unsubscribe from this group, send email to kettle-developers-unsubscribe (AT) g...oups (DOT) com
    For more options, visit this group at http://groups.google.com/group/kettle-developers?hl=en
    -~----------~----~----~----~------~----~------~--~---

  3. #3
    Matt Casters Guest

    Default Re: Can Kettle support SQL SERVER 2005 ANALYSIS SERVICES

    SSAS is an OLAP server. As such, you need to query it with MDX.
    We have a reader for Mondrian OLAP and soon for PALO as well, but not yet for
    SSAS.
    Perhaps you can access it through ODBC, but I somehow doubt it.

    Then again, I never tried ;-)

    Matt


    On Wednesday 17 October 2007 09:16:59 anderson916 wrote:
    > Hi,all
    >
    > can Kettle support SQL SERVER 2005 ANALYSIS SERVICES? can kettle deal
    > with dimensions of SQLSERVER 2005 AS?
    >
    > Any information will be appreciated!
    > Thanks.
    >
    >
    >



    --
    Matt
    ____________________________________________
    Matt Casters
    Chief Data Integration - Kettle founder
    Pentaho, Open Source Business Intelligence
    http://www.pentaho.org -- mcasters (AT) pentaho (DOT) org
    Tel. +32 (0) 486 97 29 37

    --~--~---------~--~----~------------~-------~--~----~
    You received this message because you are subscribed to the Google Groups "kettle-developers" group.
    To post to this group, send email to kettle-developers (AT) googlegroups (DOT) com
    To unsubscribe from this group, send email to kettle-developers-unsubscribe (AT) g...oups (DOT) com
    For more options, visit this group at http://groups.google.com/group/kettle-developers?hl=en
    -~----------~----~----~----~------~----~------~--~---

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.