Direct discovery for Excel file

[zied_ahmed1]

Hello everybody,

I would like to use a direct discovery to lad excel file,i tried with a table in the database and it works :

LIB CONNECT TO 'SqlServer';

DIRECT QUERY

DIMENSION

"CMD_NUMERO",

    "CLIENT_ID",

    "Année de commande",

    "CMD_CREATION_DATE",

    "CMD_DATE_DEPART"

MEASURE

"Sum_LIG_FACTURABLE_MNT_BRUT_HT",

    "Sum_LIG_PRESTATION_MNT_BRUT",

    "Sum_LIG_REEL_ACHAT_MNT_BRUT",

    "Sum_LIG_PREV_MGE_HT",

    "Sum_LIG_PREV_MGE_TTC"FROM Rechargement.dbo."Table";

Now, I would like to to try this for an Excel file

Thanks for help

[jonathandienst]

Direct discovery is designed for "big data" sources where you cannot or prefer not to load the massive amount of data into memory due to memory and time constraints. It is neither intended for nor necessary for Excel loads. If you are determined to go down this route, you would need to make on ODBC connection to the Excel file (and even then it may not work very well - I would expect that the performance would be very poor).