Loading Data to Palo MOLAP with Talend

    Loading Data to Palo MOLAP with Talend

    Hi dear all together,

    we have here at our project a problem with connecting a database to a Palo MOLAP Server.
    Our data will come from a MS SQL Server 2005 and should be written in a Cube based up on a Palo 2.5 Windows Server.
    We have no problems with connecting to the MS-SQL Server and the Palo Server is running too.

    At the Palo Server we created first a new Database ("mmc_v1") with the Palo Client. There we created the dimensions with the same name like the tables ("Konzern_ID" and "Firma_ID") in the MS SQL Server.
    Next step was to create a cube ("konzern") with the both dimension above.

    Back to Talend Studio we designed a job which should get directly the data and write it to Palo.

    If we want to run the job, we get follow error:


    Starte Job mmc_v1 am 16:49 16/03/2009.
    [statistics] connecting to socket on port 3764
    [statistics] connected
    Exception in component tPaloOutput_1
    java.lang.IllegalArgumentException: not the correct amount of dimensions : not the correct amount of dimensions (Error -27)
    at org.talend.palo.paloIXData.setDataX(Native Method)
    at org.talend.palo.paloIXData.setData(paloIXData.java:72)
    at mmc_v1.mmc_v1_0_1.mmc_v1.tMSSqlInput_1Process(mmc_v1.java:473)
    at mmc_v1.mmc_v1_0_1.mmc_v1.runJobInTOS(mmc_v1.java:657)
    at mmc_v1.mmc_v1_0_1.mmc_v1.main(mmc_v1.java:568)
    [statistics] disconnected
    Job mmc_v1 endet am 16:49 16/03/2009. [exit code=1]

    Can somebody help with this problem?
    Thanks in advance!


    Our System:
    -> Win2k3 Server
    - Palo Server 2.5
    - Talend Studio 3.1.0 M1
    - Palo Client (to see the MOLAP)
    - SpagoBI 2.0
    -> Win2k3 Server
    - MS SQL Server 2005
    Images
    • palo_client_1.jpg

      30.51 kB, 232×290, viewed 3,064 times
    • talend_studio_1.jpg

      22.93 kB, 336×418, viewed 1,977 times
    • talend_studio_2.jpg

      101.08 kB, 848×400, viewed 1,906 times

    RE: Loading Data to Palo MOLAP with Talend

    Hi MMC,

    please check the number of dimensions inside your cube. It must be the same like the columns you transfer to the palo Cube. Further you have to add one measure column!
    Your post on our forum (talendforge.org/forum/viewtopic.php?id=5840) shows me that the column for the measure is missing. If you have no measure inside your process and you want only create an empty cube please add a dummy column(Name=Measure, Type=double) with the tMap component. This new Measure-Column has to be selected inside the tPaloOutput Component as "Column as Measure".

    Regards
    Martin

    Webinar about Talend & Palo

    Hi,

    If you are interested in this topic and want to learn more on the interactions between Talend and Palo solutions, attend one of the following webinars!

    Open Source Data Analysis with Talend and Palo

    This one-hour Webinar will present:
    - How to extract your heterogeneous data with Talend and prepare it for reporting and multidimensional analysis
    - How to centralize and manage high-performance Excel-based reporting and analysis with Palo
    - How to get quick results and optimize your return on investment
    - Why open source is the right solution for data analysis

    in English : www2.gotomeeting.com/register/374537444 (19th of May 2009)
    in French : www2.gotomeeting.com/register/624420639 (19th of May 2009)
    in German : www2.gotomeeting.com/register/666108473 (13th of May 2009)