Question on proper data flow with a SQL and REST job

Anonymous — Tue, 15 Nov 2016 20:36:31 GMT

Hi there,
We're starting our first set of jobs using Talend (Data services platform 6.2.1) and we have a POC job that I was hoping to get some feedback on:
We have a SQL database (Mssql) that contains a view of people data, we would like to import this data into our Jira Service Desk / Insights Database.

We currently have the flow a bit like this:
tMSSqlConnection - contains the connection string
1st flow - tMSSqlInput_1 (Get all people) -> tLogRow -> tMap (not sure if this is the correct point)
2nd flow - tRESTClient (Get Object Schema from Insights Webservice) - > tExtractJSONFields -> tMap (this seems a bit off)

We would like to map the disparate fields from SQL and Insights, create a JSON response and then POST it against the service.

Would we use the output from tMap and iterate with tlogrow into another tRESTClient using the primary key from the SQL response as a variable in the JSON post? Are we thinking about this the right way? Are there any examples jobs doing something similar?

Any help would be much appreciated.

Thanks! - Derek

Re: Question on proper data flow with a SQL and REST job

Anonymous — Wed, 16 Nov 2016 03:48:16 GMT

Hi,
Could you post your current job design screenshots into forum which will be helpful for us to understand your job requirement?
Best regards
Sabrina

topic Re: Question on proper data flow with a SQL and REST job in Talend Studio

Question on proper data flow with a SQL and REST job

Re: Question on proper data flow with a SQL and REST job