https://community.qlik.com/t5/Talend-Studio/Best-practice-Database-to-JSON/m-p/2298423#M70894 <P>Hi all,<BR /><BR />What is the best practice for following:<BR /><BR />I have a SQL Server Database.<BR /><BR />I need a JSON.file as target<BR /><BR /><BR /><BR />Input-tHmap - jSONwritefile?<BR /><BR />I don't seem to understand how to set the fields in the data mapper of the tHmap?<BR /><BR />Thanks for the help!</P> Tue, 06 Oct 2015 07:39:40 GMT Anonymous 2015-10-06T07:39:40Z https://community.qlik.com/t5/Talend-Studio/Best-practice-Database-to-JSON/m-p/2298423#M70894 <P>Hi all,<BR /><BR />What is the best practice for following:<BR /><BR />I have a SQL Server Database.<BR /><BR />I need a JSON.file as target<BR /><BR /><BR /><BR />Input-tHmap - jSONwritefile?<BR /><BR />I don't seem to understand how to set the fields in the data mapper of the tHmap?<BR /><BR />Thanks for the help!</P> Tue, 06 Oct 2015 07:39:40 GMT https://community.qlik.com/t5/Talend-Studio/Best-practice-Database-to-JSON/m-p/2298423#M70894 Anonymous 2015-10-06T07:39:40Z https://community.qlik.com/t5/Talend-Studio/Best-practice-Database-to-JSON/m-p/2298424#M70895 Hi&nbsp; <BR />It is a general DI job: <BR />tMSSQLInput--main--tWriteJsonField--main--tFileOutputDelimited <BR /> <BR />Best regards <BR />Shong Fri, 09 Oct 2015 18:05:06 GMT https://community.qlik.com/t5/Talend-Studio/Best-practice-Database-to-JSON/m-p/2298424#M70895 Anonymous 2015-10-09T18:05:06Z