https://community.qlik.com/t5/Talend-Studio/getting-started/m-p/2248155#M33100 it's a beat short….<BR />there is a lot of solution…<BR />the good question are:<BR />is it one shot?<BR />is there keys on data?<BR />what is the structure of the db.<BR />what is it for (at the end)..<BR /><BR />good luck Wed, 13 Mar 2019 09:03:45 GMT fdenis 2019-03-13T09:03:45Z https://community.qlik.com/t5/Talend-Studio/getting-started/m-p/2248154#M33099 <P>hello,</P> <P>&nbsp;</P> <P>I have installed talend 7.1.1 and I'm trying to update our database with new data (article data).</P> <P>&nbsp;</P> <P>It's a Windows MS SQL Server 2012 - now with actual updates <span class="lia-inline-image-display-wrapper" image-alt="0683p000009MACn.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/154443iC5B8CACEF3D12C6A/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009MACn.png" alt="0683p000009MACn.png" /></span> - and there aren't anymore than old article update scripts, which aren't working anymore with the new structure of our erp system (and of cause not the quickest server ^^).</P> <P>&nbsp;</P> <P>Now I can build a new system - my question is which is the best way?</P> <P>&nbsp;</P> <P>I have a csv file - and I have 3-5 tables which hold the article data in it - they have to be updated and new one have to be inserted (about 4k articles).</P> <P>&nbsp;</P> <P>Anyhelp is apreciated, thanks</P> <P>apit</P> <P>&nbsp;</P> Sat, 16 Nov 2024 06:21:38 GMT https://community.qlik.com/t5/Talend-Studio/getting-started/m-p/2248154#M33099 Anonymous 2024-11-16T06:21:38Z https://community.qlik.com/t5/Talend-Studio/getting-started/m-p/2248155#M33100 it's a beat short….<BR />there is a lot of solution…<BR />the good question are:<BR />is it one shot?<BR />is there keys on data?<BR />what is the structure of the db.<BR />what is it for (at the end)..<BR /><BR />good luck Wed, 13 Mar 2019 09:03:45 GMT https://community.qlik.com/t5/Talend-Studio/getting-started/m-p/2248155#M33100 fdenis 2019-03-13T09:03:45Z