How good is matillion with file integrations

Hello community, want to understand how good is matillion etl with file integrations / transformations.

 

coming from legacy tools like informatica and Alteryx there is not much of file extraction and transformations options in matillion etl .

eg:

want to convert and load xlsm (excel macro files)….

want to read different sheets from excel in same

file ….

want to load multiple pdf files tableauer data…

read multiple folder files …

 

 

other than python do we have any options in matillion that we are missing.

Hi @Ranzith​,

Your observation with Python being the only real approach within Matillion to process files is correct. There isn't any out of the box components that do this type of work. I believe in informatica, they leveraged 3rd party libraries under their components to do a lot of what look like magic when it came to file processing. I suppose there is a potential to find similar 3rd party libraries and leverage them but this would be as you stated, a Python approach and not an out of the box solution. I hope this helps in someway.

Agree…

matillion should reconsider the files based integrations .

cannot read .xlsm or pdfs , pipe delimit …or other formats …

@MatillionProductTeam

@MatillionProductTeam