topic Re: How to load a catalogue(Excel - xlsx) with Data using MDM studio ?? in Talend Data Catalog

How to load a catalogue(Excel - xlsx) with Data using MDM studio ??

vbadri — Thu, 03 Sep 2015 16:12:36 GMT

Hello there,

I'm new to MDM (User of TOS DI product for more than 3 years) and testing/trying to understand features of MDM, I need some help to load a catalogue with data in it

I need answers for couple of questions to start with

a) Is there a standalone process available (using GUI - Browse/select and import file??) to import files into MDM??

b) Any particular component exists to read data from a very particular cell of any particular excel spreadsheet??

https://tlnd-prod--c.na119.content.force.com/sfc/dist/version/download/?oid=00D70000000Mzxj&ids=0683p000009MBFy&d=%2Fa%2F3p000000VG3h%2F6rRm6k3xow7XRk48ta3gLYew1IGjzVhGXJvcKD5f8dU&asPdf=false

any help would be appreciated.

Thanks & Regards

Re: How to load a catalogue(Excel - xlsx) with Data using MDM studio ??

Anonymous — Mon, 07 Sep 2015 08:33:16 GMT

Hi,
Talend open studio for MDM product includes TOS DI,TOS MDM and TOS DQ bundles.

You can use TalendHelpCenter:tMDMOutput to writes master data in an MDM Hub.
For your very particular cell of any particular excel spreadsheet, could you please elaborate your case with an example with input and expected output values?

Best regards
Sabrina

Re: How to load a catalogue(Excel - xlsx) with Data using MDM studio ??

vbadri — Tue, 08 Sep 2015 09:14:57 GMT

Thanks for your reply
I do understand that Talend MDM consists of TOS DI,MDM & DQ bundles.
Talend MDM output (xml) can be used to write data to MDM hub and also to web services if required, am i right??

My example goes like this, I'm looking for a solution to read an excel spreadsheet which contains x number of sheets in it.
Here I'm looking to read data from 'Common Catalogue Data' sheet from particular cells like

Supplier Name - B2
Catalogue Name - B3
Currency - B4
Versions - B5,B6
Contact Details - F3,F4,F5,F6,F7
Product Details - all rows with data starting from A10 to end of sheet

I know tExcelInput/metadata excel component reads data in general(first row to last row), but don't understand how to force it to read data in the particular way to i want it to be?