https://community.qlik.com/t5/Talend-Studio/Way-to-transfer-the-data-efficiantly/m-p/2335753#M104279 We are planing to assign dedicate server for Talend Job Server. <BR />But I am wondering if I should install Talend Job Server in either Data Source Database Server or <BR />Target DWH Database Server. <BR />If I have the dedicate Talend Server, <BR />I assume ETL load the huge data from Data Source DB to Talend Server first over Ethernet and then push it <BR />to Destination Database Server from Talend Server again by Ethernet. <BR />If I installed Talend Job Service into either Src DB or Target DB, <BR />I assume the data transfer over EtherNet is only one time and the other one should be transferred by Internal SCSI BUS. <BR />But for maintenance and save CPU, Memory usage of the SRC Database, and DWH(Destination BD) servers, <BR />I would like to assign a dedicate server. <BR />Is there any way I can set the job to transfer directly using Talend <BR />Say I have Server A (Data Source DB Server), B (Destination DB Server), and C (Talend Job Server) <BR />all connected by Ethernet. <BR />I would like to set the job at Server C (Talend Server) to transfer the data from Server A to Server B directly. <BR />Is this possible? (I may have to actually create SQL/SP at Server A or Server B and just execute from Talend). <BR /> <BR />How much impact on the huge data transfer time should I expect if I separate the Talend Job Server from Data Source Server or Data Destination Server? <BR />Thank you! Sat, 16 Nov 2024 12:42:31 GMT Anonymous 2024-11-16T12:42:31Z https://community.qlik.com/t5/Talend-Studio/Way-to-transfer-the-data-efficiantly/m-p/2335753#M104279 We are planing to assign dedicate server for Talend Job Server. <BR />But I am wondering if I should install Talend Job Server in either Data Source Database Server or <BR />Target DWH Database Server. <BR />If I have the dedicate Talend Server, <BR />I assume ETL load the huge data from Data Source DB to Talend Server first over Ethernet and then push it <BR />to Destination Database Server from Talend Server again by Ethernet. <BR />If I installed Talend Job Service into either Src DB or Target DB, <BR />I assume the data transfer over EtherNet is only one time and the other one should be transferred by Internal SCSI BUS. <BR />But for maintenance and save CPU, Memory usage of the SRC Database, and DWH(Destination BD) servers, <BR />I would like to assign a dedicate server. <BR />Is there any way I can set the job to transfer directly using Talend <BR />Say I have Server A (Data Source DB Server), B (Destination DB Server), and C (Talend Job Server) <BR />all connected by Ethernet. <BR />I would like to set the job at Server C (Talend Server) to transfer the data from Server A to Server B directly. <BR />Is this possible? (I may have to actually create SQL/SP at Server A or Server B and just execute from Talend). <BR /> <BR />How much impact on the huge data transfer time should I expect if I separate the Talend Job Server from Data Source Server or Data Destination Server? <BR />Thank you! Sat, 16 Nov 2024 12:42:31 GMT https://community.qlik.com/t5/Talend-Studio/Way-to-transfer-the-data-efficiantly/m-p/2335753#M104279 Anonymous 2024-11-16T12:42:31Z