Direct discovery for Excel file

zied_ahmed1 — Mon, 21 May 2018 08:29:47 GMT

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

Re: Direct discovery for Excel file

jonathandienst — Mon, 21 May 2018 08:36:39 GMT

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).

topic Direct discovery for Excel file in Management & Governance

Direct discovery for Excel file

Re: Direct discovery for Excel file