topic Re: REST API 2 MYSQL MDM (TOS Open Studio + Community Version MDM) in Talend Data Catalog

REST API 2 MYSQL MDM (TOS Open Studio + Community Version MDM)

pravinm — Wed, 19 Jun 2019 12:14:25 GMT

Hi All,

Please correct if I have done anything wrong in the below flow, in Log sample rows I am getting all the 10 Rows logged in console but it does not commit in database, Appreciate your help, if any additional input is required to answer this questions feel free to ask.

Job Flow

Re: REST API 2 MYSQL MDM (TOS Open Studio + Community Version MDM)

Anonymous — Wed, 19 Jun 2019 16:30:38 GMT

Hello

Which component are you using to insert the data in your database?

I suggest you check the commit option.

Here is the commit with mysql

Re: REST API 2 MYSQL MDM (TOS Open Studio + Community Version MDM)

pravinm — Wed, 19 Jun 2019 21:04:12 GMT

Thanks for the quick reply after a looking day of r&d and permutations I figured out what mistake I made.
To resolve such issues. Which are unknown.follow these steps.
1. Enable die on error on all components.
2. Run the job. Your exception message will be displayed. In my case there where extra charecters sent so corrected the mapping in tExtractJsonFields component.
3. Executed the batch. And hurray made it.

I know it's a simple achievement but it was a great deal to me.

Thanks to the community which took time to read my question.